Category: 4 SPL Learning materials

SPL has two file formats: bin file and composite table, with suffixes btx and ctx respectively. This article introduces the conventional calculations of SPL on these/ two types of files, similar to the simple calculations that SQL can express (excluding subqueries). The basic concepts and generation methods related to these two types of files can be found in: How to use SPL storage for beginners . Sample data Here, we use some data tables and fields from TPCH. orders, order table (ctx), the used fields are O_ORDERKEY order number, primary key; O_CUSTKEY customer number; O_TOTALPRICE order amount; O_ ORDERDATE order

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 8: Primary-sub Table and Parallel Calculation. Multidimensional Analysis Backend Practice 8: Primary-sub Table and Parallel Calculation

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 7: Boolean Dimension and Binary Dimension. Multidimensional Analysis Backend Practice 7: Boolean Dimension and Binary Dimension

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 6: big fact table associate with small dimension table. Multidimensional Analysis Backend Practice 6: big fact table associate with small dimension table

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 5: small fact table associate with small dimension table. Multidimensional Analysis Backend Practice 5: small fact table associate with small dimension table

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 4: Pre-aggregate and Redundant Sorting. Multidimensional Analysis Backend Practice 4: Pre-aggregate and Redundant Sorting

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 3: Dimensions Sorting and Compression. Multidimensional Analysis Backend Practice 3: Dimensions Sorting and Compression

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 2: Data Type Optimization. Multidimensional Analysis Backend Practice 2: Data Type Optimization

This series of articles explain how to perform multidimensional analysis (OLAP) in steps with detailed samples. Click to learn more in Multidimensional Analysis Backend Practice 1: Basic Wide Table. Multidimensional Analysis Backend Practice 1: Basic Wide Table

Target task We have a user events table T. Below is its structure and part of its data: Time UserID EventType OS Browser ProductID … f1 f2 f3 f4 f5 … 2022/6/1 10:20 1072755 Search Android IE 100001 … true false false true false … 2022/6/1 12:12 1078030 Browse IOS Safari 100002 … false false true true true … 2022/6/1 12:36 1005093 Submit Android Chrome 100003 … true true true false false … 2022/6/1 13:21 1048655 Login Windows Chrome … false false true true true … 2022/6/1 14:46 1037824 Logout Android Edge … false false false true true … 2022/6/1