Tag: Calculation Logic

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

JOIN is used to combine records from two or more tables. This article will explore the solutions and basic principles of SPL for join problems. The data interdependence between tables is called the inter table association relationship. The association relationships between tables can be divided into the following types: one-to-one, many-to-one, one-to-many, and many-to-many. We can join two or more tables through inter table association relationships to achieve the goal of multi table association queries. Many to many association: A record of Table A can correspond to any number of records of Table B; At the same time, a record

JOIN is used to combine records from two or more tables. This article will explore the solutions and basic principles of SPL for join problems. The data interdependence between tables is called the inter table association relationship. The association relationships between tables can be divided into the following types: one-to-one, many-to-one, one-to-many, and many-to-many. We can join two or more tables through inter table association relationships to achieve the goal of multi table association queries. Many to one association refers to any number of records of one table to correspond to one record of another table. A many-to-one association relationship,