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

Internet of Thing Awesome Basics You Need to Read Now: Part 5

Internet of things can be applied to both Vertical and Horizontal of things: Applications of the Internet of Things (IoT) have spread across an enormously large number of industry sectors. The development of the vertical applications in these sectors is unbalanced.

It is very important to sort out those vertical applications and identify common underpinning technologies that can be used across the board, so that interconnecting, interrelating, and synergized grand integration and new creative, disruptive applications can be achieved.

IoT part 5
IoT part 5
One of the common characteristics of the Internet of Things is that objects in a IoT world have to be instrumented 

Why we need IOT is a fundamental change in the way information is generated, from mostly manual input to massively machine-generated without human intervention.

To achieve such 5A (anything, anywhere, anytime, anyway, anyhow) and 3I (instrumented, interconnected, and intelligent) capabilities, some common, horizontal, general-purpose technologies, standards, and platforms, especially middleware platforms based on common data representations just like the three-tiered application server middleware, HTML language, and HTTP protocol in the Internet/web arena, have to be established to support various vertical applications cost effectively, and new applications can be added to the platform unlimitedly.

Four pillars of IOT
  • RFID - The internet of devices.Example,Radio wave, NFC,IC cards
  • WSN-The internet of transducers. Examples Wireless mess, Bluetooth,Networks, ZigBee
  • M2M - Machine to machine. Examples, Cellular, Fixed networks, WAN, GPRS
  • SCADA-The network of controllers. Example-Wired Field Buses, CanBus,BacNet

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