3 SPL Technology & Evaluation

 

Performance Testing

SPL computing performance test series: TPCH
SPL computing performance test series: associate tables and wide table
SPL computing performance test series: multi-index aggregating
SPL computing performance test series: position association
SPL computing performance test series: funnel analysis
SPL computing performance test series: in-group accumulation

Comparison of esProc composite table, ORC, Parquet
ClickHouse is fast, esProc SPL is faster

Comparison test of Python and SPL in data reading and computing performance
Performance comparison of Python and SPL in data processing

How to conduct database computing performance testing?

Algorithms & Techniques

How to make JOIN run faster?
How does the in-memory database bring memory’s advantage into play?
How to make the columnar storage data warehouse more efficient
Speed up Big Data User Behavior Analysis using Bi-dimension Ordering Structure
How to cope with high-concurrency account query?
What is the key to make the multi-tag user profile analysis run faster?
Why Are There So Many Snapshot Tables in BI Systems?
The ways to make pre-aggregation in multi-dimensional analysis effective
Why does wide table prevail?
How to implement fast multi-index calculation
How to speed up funnel analysis of e-commerce system
The significance of ordered storage for high performance

Programming Languages Comparison

SQL

Comparison of SQL & SPL: Set-oriented Operations
Comparison of SQL & SPL: Select Operation
Comparison of SQL & SPL: Order-based Computations
Comparison of SQL & SPL: Equi-grouping
Comparison of SQL & SPL: Non-equi-grouping
Comparison of SQL & SPL: Order-based Grouping
Comparison of SQL & SPL: Join Operations (Ⅰ)
Comparison of SQL & SPL: Join Operations (Ⅱ)
Comparison of SQL & SPL: Join Operations (Ⅲ)
Comparison of SQL & SPL: Static Transposition
Comparison of SQL & SPL: Complicated Static Transposition
Comparison of SQL & SPL: Dynamic Transposition
Comparison of SQL & SPL: Recursion Operation

Python

Python vs. SPL 1–Download and Installation
Python vs. SPL 2–Set
Python vs. SPL 3–Loop Function
Python vs. SPL 4– Selection and Positioning
Python vs. SPL 5 – Order-related Operation
Python vs. SPL 6 – Equivalence Grouping
Python vs. SPL 7 – Alignment Grouping & Enumeration Grouping
Python vs. SPL 8 – Ordered Grouping
Python vs. SPL 9 – Inverse Grouping & Transpose
Python vs. SPL 10 – One-to-N Association
Python vs. SPL 11 – Many-to-One Association
Python vs. SPL 12 – Big Data Processing

Overview Comparison

Prorgam

Looking for the Best SQL-On-File Tool for Analyst
Looking for the Best Programming Language for Processing Excel Files
Looking for the Best Class Library for Computing JSON Data
From JsonPath to SPL
Looking for the Best Class Library for Computing XML Data
From XPath to SPL
Looking for the Best Class Library for Computing MongoDB Data

Looking for the Best Java Data Computation Layer Tool
Are You Trying to Replace SQL with Java 8 Stream?
Are You Trying to Replace SQL with Kotlin?
From Stream to Kotlin to SPL

Looking for the Best Post-SQL Scripting Tool
Looking for the Best External Analytic Technique for Salesforce
Looking for the Best Technique of Processing Retrieved WebService/RESTful Data

Looking for the Best Tool for Using Non-RDB Data Sources in Reporting Tools
Looking for the Best Tool for Handling Diverse/Multiple Data Sources for Report Building
Looking for the Best Method of Handling Multistep Data Preparation for Reporting Tools

Looking for the Best Scripting Tool for Computing Time Series Data

Framework

Just How Slow is Data Retrieval via JDBC
Methods of dumping data among databases
Is ORM a Convenient Option for Data Migration between Databases?
The technologies for SQL migration

Cross-database Computing Methods
Implementation technologies of T+0 query
Looking for the Best Report Data Source Hot-Swapping Technique

Drawbacks of Using Stored Procedures to Compute Data
Methods for implementing data processing in microservice

Desktop

What programming language should business people learn?
Python Is Not Built for Business People
Looking for the Best Lightweight Data Analysis Script Tools
Looking for the Best Excel Add-ins
Looking for suitable tools for querying and calculating large files