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 test of Python and SPL in data reading and computing performance
- Performance comparison of Python and SPL in data processing
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
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
