Concurrency Control

Multi-version Concurrency Control (MVCC)

In PieCloudDB, the concurrency control scheme used by each coordinator instance is Multi-Version Concurrency Control (MVCC). This approach ensures that each transaction reads from a consistent snapshot of the database that remains unaltered by concurrent transactions.

Data Model

Relational

PieCloudDB is a relational DBMS that supports SQL.

Indexes

Not Supported

PieCloudDB does not support index because it targets OLAP workloads.

Isolation Levels

Read Committed Serializable Snapshot Isolation Repeatable Read

PieCloudDB support two isolation levels: Read Committed and Repeatable Read.

Joins

Nested Loop Join Hash Join Sort-Merge Join Semi Join

PieCloudDB support multiple join algorithms, including Hash Join, Merge Join and Nested Loop Join. And PieCloudDB also support two logical joins: Semi Join and Anti Join.

Query Compilation

JIT Compilation

Query Execution

Tuple-at-a-Time Model

Query Interface

SQL

PieCloudDB provides full support for the SQL:1992 standard. It is also the components of the SQL:2016 that target OLAP workloads. It also supports additional operations, such as window functions.

Storage Architecture

Disk-oriented

PieCloudDB supports various distributed file system protocol for data storage, including object storage, HDFS and posix. The worker node also uses its local disk as data cache.

Storage Format

Custom

PieCloudDB build its own hybrid column/row (PAX) storage format called "JAMN".

Storage Model

Decomposition Storage Model (Columnar)

PieCloudDB's horizontal data block into compressed, immutable files, along with the inclusion of footers containing column offsets, provides an efficient and optimized storage system. It improves data compression, accelerates query processing, and simplifies data management within the database.

Stored Procedures

Supported

System Architecture

Shared-Disk

In PieCloudDB, query execution is performed within elastic clusters of virtual machines called virtual warehouses. When executing queries, virtual warehouses utilize related file system protocol to read and write data from a distributed file system. The Cloud Service layer in PieCloudDB encompasses a collection of services responsible for managing computation clusters, queries, transactions, and metadata such as database catalogs and access control information.

Views

Virtual Views Materialized Views

PieCloudDB support both materialized views and virtual views.