Register
HowTo
Blog
TalkingData
eBook
Q&A
Download
Documentation
Official Website
SCUDATA
RAQSOFT
Chat
More
mars • • 2025-09-17 12:16:39
4. Time-related Analysis
4.1 Data information Open esProc, run createOrders.splx, and you can get below data table. This ..
eBook
mars •
1
View
• • 2025-09-10 10:53:55
3 Grouping & aggregation
3.1 Compute total sales of each salesperson in the last year A 1 =file(“sales.csv”).import@tc(sa ..
eBook
mars • • 2025-09-09 10:35:45
2. Some simplest data analytics use cases
Data information Below is a table (sales.csv) recording a company’s sales data: [pic] The first ..
eBook
mars • • 2025-09-08 10:42:32
1. Preparation
1.1 Download and installation The free SPL Desktop Edition is enough. Download SPL HERE. After d ..
eBook
mars •
1
Reply
•
3
View
• • 2025-09-17 12:17:38
Data Analytics Programming - From Beginner to Expert
[url]Preface In today’s data-driven era, data analytics has become an indispensable core capabil ..
eBook
raqsoft •
1
View
• • 2025-08-18 16:23:57
Guide to Maven-based esProc Community Edition Upgrade in the Integrated Environment
Applicable scenarios When esProc Community Edition is integrated into a third-party project and ..
esProc
ezpz •
4
View
• • 2025-08-08 11:53:30
Micronaut Integration with SPL to Implement Microservices
Microservices architecture, celebrated for its flexible deployment and strong scalability, has b ..
Application
chenhu •
1
Reply
•
24
View
• • 2025-08-01 21:52:52
A Lightweight Solution to Speed up Queries by Dumping Data to Files
Traditional transactional databases (TP) do not good at handling analytical computations. Profes ..
esProc
chenhu •
9
View
• • 2025-08-01 21:39:19
Practice #6: Conditional Filtering by Enumerated Field
An enumerated field has only several values. The format of filtering condition specified on an e ..
esProc
chenhu •
7
View
• • 2025-08-01 21:36:15
Practice #5: EXISTS at Large Primary-Subtable Join
EXISTS operation on large primary table and subtable often has low performance. Such a computati ..
esProc
chenhu •
6
View
• • 2025-08-01 21:32:41
Practice #4: Large Primary-Subtable Join
This section focuses on the speed-up of primary key-based joins. The association between the pri ..
esProc
chenhu •
6
View
• • 2025-08-01 18:20:05
Practice #3: Foreign-key-based Dimension Table Join
SQL’s JOIN definition is very simple. It is the filtered Cartesian product of two tables, repres ..
esProc
chenhu •
5
View
• • 2025-08-01 18:07:14
Practice#2: COUNT DISTINCT
SQL COUNT DISTINCT has been slow. It is, in essence, a grouping operation, which keeps traversed ..
esProc
chenhu •
3
View
• • 2025-08-01 18:02:14
Practice#1: Regular Filtering and Grouping & Aggregation
We use orders table as an example to achieve esProc SPL data externalization to speed up regular ..
esProc
mars •
1
View
• • 2025-07-23 09:35:38
7.4 Hierarchical k-means clustering
Based on industrial experience, it is known that outputs of higher importance have a greater inf ..
eBook
mars •
7
View
• • 2025-07-22 10:19:42
7.3 Prediction
Having obtained the initial cluster centroids, passing them to the k-means algorithm allows us t ..
eBook
mars •
2
View
• • 2025-07-21 10:52:14
7.2 Initialization of centroids
K-means clustering results are highly sensitive to the random initialization of centroids. The r ..
eBook
mars •
3
View
• • 2025-07-18 10:05:54
7.1 Output yield and production route
In industrial settings, the output yields of certain units often exhibit significant fluctuation ..
eBook
Index
Explore
Message
Login