Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

Image
SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT t1.id, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON t1.id >= t2.id GROUP BY t1.id, t1.value ORDER BY t1.id; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

2 Top Differences Automation Vs Internet of Things

Five reasons why IoT automation provides opportunities to deliver better product or Services. The data from sensors is a golden asset to derive benefits and to apply in products or services.

Automation and IoT both are different 

Automation

The automation is based on the data collected from various devices and make it happen when something goes wrong you can say as automation.

The best example is based on sensor generated data the automation tool take corrective action during course of flying from one country to other.

  Internet of Things

  1. More mobile phones than fixed
  2. New architecture models (ex: Cloud computing)
  3. The new protocol (Ipv6)
  4. Everything is Sensor-laden
  5. More machines than people

The Growth of Internet Usage

The internet will be double in size every 5.32 years. More devices can be connected to the internet through IP. The internet limitation in IPv4 is 4 billion addresses.

But, the internet limitation for IPv6 is 2^128. The total IP traffic over the internet is 1 ZettaByte as of 2011.

Data process
Wisdom from Data

Data 

  1. Information-It is the data after you did clean the raw data.
  2. Knowledge-The ideas or patterns you obtain from cleaned data.
  3. Wisdom-Building models and you can make automate the certain task.

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers