SPL Application scenarios

 

Got SQL

Is There Any Java Open-source Library for SQL-style Computations?

Is There Any Java Open-source Library for Data Query & Analysis

Is There Any Java Open-source Library Like SQLite?

How to Query and Compute TXT/CSV Files in Java?

Can We Execute SQL on TXT/CSV Files in Java?

How to Query and Compute XLS in Java?

Can We Execute SQL on XLS in Java?

How to Parse and Generate XLS in Java?

How to Parse and Compute JSON in Java?

How to Parse and Compute XML in Java?

How Java Executes SQL on MongoDB

How Java Queries or Analyzes MongoDB Data

How Java Performs JOINs on MongoDB

How Java Handles Data Returned from WebService/RESTful

How to Achieve More Queries and Analyses on Salesforce Data

How to Achieve Complex Logic Queries and Analyses on Data from SAP BW

How Can Reporting Tools Use Non-RDB Data Sources Directly?

How Reporting Tools Access MongoDB Data

How Reporting Tools Access Webservice/Restful Data

How Reporting Tools Access JSON/XML Data

How Reporting Tools Access TXT/CSV/XLS Data

How Reporting Tools Access Hadoop Data

How Reporting Tools Access Salesforce Data

Beyond SQL

How SQL Gets Continuous Records Meeting a Specified Condition

How SQL Groups Rows Every Three Ones

How SQL Groups Data by Position

* How to Handle Different Data Types during Row-to-Column Transposition in SQL?

* How to Convert Dates in One Group into An Interval in SQL?

* How to Display Dates Easily in SQL?

* How to Split Attributes of Same Type in One Row and Convert Them into Multiple Rows in SQL?

* How to Calculate Median on Values That Have Corresponding Quantities in SQL?

* How to Calculate the Difference between Each Value in a Certain Column and Its Previous One and Display Result in the Original Order in SQL?

* How to Parse Key-value Pairs from a Base64-encoded String in SQL?

* How to Replace a Null with the Corresponding Value in the Previous Record in SQL?

* In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes in SQL?

* How to Transpose Rows to Columns on Multiple Fields in Each Group in SQL?

* How to Combine Every Five Values into One Record in SQL

*How to Transpose Columns in Each Group to a Single Row in SQL

Cooperate DB

What Can We Do with the Slow JDBC?

How to Write Universal SQL That Can Be Executed in All Databases?

How Reporting Tools Auto-convert SQL between Different Databases?

Which Intermediate File Type You Are Using for Data Migration between Databases in a Program?

How to Achieve T+0 Query and Analysis?

How So Many Intermediate Tables in the Database Come into Being?

Is There Any Alternative to Stored Procedures?

What are the disadvantages of using Java for report data preparation?

What are the disadvantages of using stored procedures for report data preparation?

How to Migrate Developed Reports Seamlessly Across Different Databases?

How to Achieve Hot-swappable Reports?

How to reduce the development cost of reports?

Besides Java Hardcoding, Is There a Better Alternative to Implement Data Processing Logic in Microservices?

Besides DBLink, Is There Any Better Choice to Achieve Cross-data Computations?

Surpass DB

How to Speed up Queries Containing a WHERE Clause That Has Multiple IN Conditions?

How to Make TopN Operations Fast?

How to Make High-Concurrency Account Queries Fast?

How to Make Queries and Analyses on Data with Thousands of Tags Run Fast?

Is OLAP Pre-Aggregation for Speeding up Multidimensional Analysis Reliable?

How to Enhance Performance of Multidimensional Analysis Involving a Lot of Dimension Tables?

How to Speed up JOIN Operations Involving Huge Tables, like the Order Table and the Order_detail Table?

Is Columnar Storage Always Faster?

Which Columnar Storage Scheme Is Best Suited to Parallel Processing?

Is Elasticsearch Best Suited to High-Concurrency Queries?

Is There Any Lightweight Big Data Computing Technology?

Is ClickHouse as Powerful as We Thought?

Is There Any Simple and Lightweight In-memory Database Technology?

Is There Any Alternative Technology to Spark?

Is There a Database Technique That Enables Fast JOIN?

Application cases

Performance optimization

Open-source SPL Speeds up Query on Detail Table of Group Insurance by 2000+ Times

Open-source SPL improves bank’s self-service analysis from 5-concurrency to 100-concurrency

Open-source SPL turns pre-association of query on bank mobile account into real-time association

Open-source SPL speeds up batch operating of bank loan agreements by 10+ times

Open-source SPL optimizes batch operating of insurance company from 2 hours to 17 minutes

Open-source SPL speeds up intersection calculation of customer groups in bank user profile by 200+ times