Report Data Source

• How to migrate SQL in application to different types of databases

• Some examples of solving BIRT dynamic data source

• How to deal with rounding balance in reports

• Some examples of solving BIRT special layout

• Making a More Efficient iReport with esProc

• Joining MongoDB Collections for Reporting Tools

• MongoDB JOIN MySQL for Reporting Tools

• Query Sharded Databases

• Implement intra-group cross-row calculation In Birt

• Dynamic Grouping of crosstab in BIRT

• Detailed discussion on pivot

• Solve some difficult problems in reporting tools such as Jasper

• Solve some difficult problems in reporting tools such as Birt

• How to implement irregular month statistics in Birt

Java Computing Layer

• The skill of updating database with esProc

• Performing Joins over MongoDB with SPL

• Getting MongoDB Indexes with SPL

• Merging MongDB Subdocuments

• Querying ListField in a MongoDB Subdocument

• Getting Top N from MongoDB Data

• MongoDB Data Grouping & Aggregationate

• Achieving Foreign Key Joins between MongoDB Collections in SPL

• MongoDB Data Grouping & Aggregation

• Handling Set Operations in SPL for Java

• SPL assists mongoDB calculation

• Compare Members of Same Positions for MongDB

• Cross Aggregation for MongoDB

• Export MongoDB as a CSV File

• Implement grouping easily in Java with embeded SPL

• Simplifying MongoDB Data Association

• esProc-driven MongoDB Hackers

Performance optimization

• Performance optimization - Search

• Performance optimization - Traversal

• Performance optimization - Join

• Performance optimization - Multidimensional analysis

• Performance optimization skill: orderly grouping

• Performance optimization skill: Joining Big Fact Data and Big Dimension Data

• Performance optimization skill: Joining Small Fact Data and Big Dimension Data

• Performance optimization skill: Attached Table

• Performance optimization skill: Order-based Targeted MERGE

• Performance optimization skill: Order-based MERGE

• Performance optimization skill: Pre-Joining

• Performance optimization skill: For Dimension Table Filtering & Computation

• Performance optimization skill: Numbered Foreign Key

• Performance optimization skill: Pre-Joining of Dimensions

• Performance optimization skill: Reuse of traversing result to speed up multiple grouping

• Performance optimization skill：TopN

• Parallel computation of external data by esProc

• Learn performance optimization skills from TPCH tests

• Query of Large Quantity of Random Key Values in Big Data

• Fetch data in parallel Improving Data Reading Performance

• SPL Examples of Implementing & Optimizing SQL IN & EXISTS