Judy articles - 224 total
Using Java/Python in place of stored procedure for batch jobs?
Using stored procedure for batch jobs has always been a common practice. Proceduralizing SQL through...
Structured Text computing: SPL Practice
Structured Text Computing Requirements Structured text files are a common data storage...
Data Comparison between Different Types of Databases-SPL Practice
Data comparison between databases of different types means comparing data between two tables having...
How to Speed Up Conditional Filtering on Enumerated Fields with esProc
Enumerated fields in data tables have a limited number of predefined values. Filtering conditions on...
How to Speed Up EXISTS in Primary-Subtable Joins with esProc
In databases, EXISTS operations between large primary and sub tables often result in poor...
How to Speed Up Associations between Large Primary and Sub Tables with esProc
Associations between primary and sub tables, like orders and order details tables, are quite common....
How to Implement Mixed Computations Between Oracle and MySQL with esProc
Logical data warehouses can implement multi-source mixed computations, but require configuring views...
How to Implement JOIN Operations Between Tables from Different Databases with esProc?
When data analysis involves different business systems, cross-database computations become necessary....
How to operate large CSV files with esProc SPL
esProc SPL provides cursor operations, which can operate large CSV files with very simple code. With...
Data storing using file or database, which is more suitable?
It is common to use the database to store the data for the reason that the database not only provides...
Is This a Refreshing Way to Understand Association?
The definition of association in SQL is overly simplistic: association is essentially performing a...
Using SQL for data analysis seems to be a false proposition
Using SQL for data anlysis is actually quite basic SQL is widely used for data analysis and often...
What should we do when SQL (and stored procedure) runs too slowly?
As the most commonly used data processing language, SQL is widely used in many scenarios, such as...
How to merge overlapping time intervals with esProc
A certain database table has multiple accounts, each with multiple time intervals that overlap. Now...
Ordered grouping
We know that SQL uses the concept of unordered sets in mathematics, so SQL grouping does not pay...
How to Build a Streaming Deduplication Pipeline with Kafka, GlassFlow, and ClickHouse
Introduction When you work with data streaming in the real world, sooner or later you'll...
How to check the same status of data in each row within a group with esProc
The ID field of a certain database table is the grouping field of cars, and each group of cars is...
How to Operate nested JSON from RESTful with esProc
After receiving JSON from RESTful services, further calculations are often required. Processing such...
How to quickly transform multi-layer sets in JSON strings
There is a 2-layer JSON string with multiple dynamic key values in the lower layer, excluding...
A programming language coding in a grid
What? A programming language coding in a grid? Yes, you read that right, SPL (Structured Process...
How to simplify the Merge Operations Across Tables from Multiple Databases
Due to business requirements, data is stored by year in two structurally identical databases. To...
How to simply perform the difference set operation of a continuous interval ？
There are two tables in a certain database. The original inventory table data_add stores multiple...
How to supplement the missing capabilities of database SQL with esProc
Some database SQL lacks necessary capabilities and usually requires writing large sections of code to...
How to set duplicate content in a dataset to null with esProc
The first two fields of a certain database table may have duplicate values, such as the first three...
Statistics by time window: SPL VS SQL #16
The Time field of a certain database table is time, and the time interval is sometimes greater than 1...
How to Dump Database Tables into Files to Speed Up Queries with esProc
Large data volumes or high database loads can both lead to slow database query performance. In these...
How to Use esProc to Speed Up JOIN to Avoid Wide Tables
In data analysis applications, multi-table JOIN operations within a database often involve complex...
How to Implement Hot-Cold Data Mixed Computing with esProc
Separating hot and cold data into different databases makes performing mixed queries quite...
This Is Likely the Computing Technology that Supports the Most Data Sources
oday, the data sources of enterprises have evolved from "a few tables" to a diverse range such as...
How to Speed Up COUNT DISTINCT with esProc
The COUNT DISTINCT in SQL has always been relatively slow. De-duplication is essentially a grouping...