Problem description & analysis
We have two database table. One is ORDERINFO, which has data as follows:
The other is TIER, which stores data as follows:
In the order information table… Read More
We often hear about the advertisements for the performance of a big data product, saying that it is capable of running “queries over trillion-row tables in seconds”, wh… Read More
The columnar storage is a commonly used storage technique. Often it implies high performance, and has basically become a standard configuration for today’s analytical databases.
The ba… Read More
How to Split Attributes of Same Type in One Row and Convert Them into Multiple Rows
The actual table is rather wide and here we just use seven columns to do a computing a task. The goal is… Read More
We have a database table TBLTEST. Below is part of its data:
The data is ordered by date. We are trying to group rows by the first five columns, convert dates in each group into an interval… Read More
We have a database table FIRSTTBL. Below is part of its data:
And we are trying to combine every six rows into one record. Below is part of the desired result:
It is a row-to-column transp… Read More
We have a database table STAKEHOLDER as follows:
We are trying to group the table by CLASS and convert all columns to a same row. Below is the desired result set:
SQL code written in Oracl… Read More
Posted on Mar 5 Title party, there are thousands of Python programmers, of course, many people can master it. The term “you” here refers to none professionals in… Read More
Posted on Feb 18 Many large databases accumulate a large number of data tables after running for many years, with severe cases reaching tens of thousands, making the databas… Read More
Posted on Jan 31 Many modern applications will move data computation and processing tasks away from databases and implement them in Java, which can gain framework benefits… Read More
Posted on Jan 26 The usage frequency of historical data often decreases over time, and how to store and calculate it becomes a problem.Low frequency of use does not mean tha… Read More
Posted on Jan 10 2024 could be a big year in the tech world while all the AI, ML, Web3, and similar evolving faster than ever. If you're getting into coding, one of the firs… Read More
Posted on Jan 11 This article lists five great projects that are not very popular that you should give a shot. 🔥These tools are aimed at improving data processing, A… Read More
Posted on Jan 3 • Originally published at madza.hashnode.dev To kickstart 2024 on a productive note, I've curated a list of 18 GitHub repositories… Read More
Posted on Dec 5 The stored procedure is a love-hate thing.Its significance is obvious as all old-brand databases support it. Newcomer databases are often slighted if they do… Read More
Posted on Dec 16 When learning SQL, we often hear the saying that SQL is a declarative language. You just need to tell it what to do, without telling it how to do it, it wil… Read More
Posted on Dec 10 Open-source projects are like a big meeting place where computer experts from all around the world gather to share their smart ideas, skills, and love for m… Read More
Posted on Nov 7 In the age of microservices, the demand for applications built on microservices frameworks is soaring. However, efficient data processing within microservice… Read More
Posted on Nov 14 MongoDB is a typical NoSQL database. Its document-oriented structure makes both storage and access convenient and efficient. But the database has rather wea… Read More
Posted on Oct 16 Built purely in Java, esProc SPL is a powerful and efficient data analysis engine that can help businesses of all sizes make better decisions faster. It can… Read More
Posted on Nov 18 The stored procedure is a love-hate thing.Its significance is obvious as all old-brand databases support it. Newcomer databases are often slighted if they d… Read More
Posted on Oct 8 Imagine having a data analysis engine like esProc SPL that can really cut down on your application costs compared to traditional SQL-based technologies. It's… Read More
Posted on Nov 10 SQL is widely used, and data scientists (analysts) often need to use SQL to query and process data in their daily work. Many enterprises hold the view that… Read More
Posted on Nov 12 Currently the vast majority of data warehouses employ SQL to process data. Following decades of development, SQL has become the standard language in the dat… Read More
Posted on Sep 13 SQL is a powerful language for querying and manipulating data, but it can be difficult to optimize for performance, especially with large datasets and compl… Read More
Posted on Oct 17 • Originally published at madza.hashnode.dev Open-source projects are playgrounds of innovation, collaboration, and creativity. I… Read More
Posted on Jul 16 Many small and micro applications also require certain data processing and computing abilities. Integrating a database will make the application too heavy… Read More