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

RDBMS Vs NOSQL awesome differences to read now

NoSQL and RDBMS or SQL are different from each other. You may ask what is the difference. Below explained in a way that you can understand quickly.

rdbms vs no sql

đŸ’¡Traditional Database

  • A schema is required. All traditional data warehouses using RDBMS to store datamarts.
  • Databases understand SQL language. It has a specific format and rules to interact with traditional databases.
  • Less scalable. It has certain limitations. 
  • Expensive to make the databases as scalable
  • Data should be in a certain format.
  • Data stored in row format.

NoSQL database

The growing internet usage and involving a number of devices caused to invent databases that have the capability to store any kind of data.

NoSQL Special Features
  • The schema is not required. Ability to handle multiple data types. This is the power of NoSQL.
  • NoSQL is much suitable for analytical databases. Since those should be flexible, scalable, and able to store any formatted data.
  • The increased usage of web applications, the availability of broadband for the common man, caused the generating of a variety of data. So NoSQL is absolutely needed for the new generation businesses.
  • Data stored in column format. In the form of key-value pairs.
  • Python, Ruby, PHP, and Java are top languages you need to interact with NoSQL databases.

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