PieCloudDB is a cloud-native database, which Integrate physical data warehouses into a cloud-native data computing platform. By dynamically creating virtual data warehouses based on data authorization, supports the data and computation needs of larger models, increases the computable data space by an order of magnitude, and reduces the cost of data warehousing by an order of magnitude. PieCloudDB offers cloud service to all users. Besides, it can also be installed on any IaaS cloud and bare metal according to customer needs.
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. MVCC offers several advantages over lock-based concurrency control in PieCloudDB, particularly in terms of performance.
Read Committed Serializable Snapshot Isolation Repeatable Read
PieCloudDB support two isolation levels: Read Committed and Repeatable Read.
Nested Loop Join Hash Join Sort-Merge Join Semi Join
PieCloudDB support multiple joins, including Hash Join, Merge Join and Nested Loop Join. And PieCloudDB also support two logical joins: Semi Join and Anti Join, which are used to support sub-link pull up.
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.
PieCloudDB utilizes object storage as its underlying data storage mechanism. Query execution is performed within elastic clusters of virtual machines called virtual warehouses. When executing queries, virtual warehouses utilize an HTTP-based interface to read and write data from the object storage. 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. These services are stored in FoundationDB.
Virtual Views Materialized Views
PieCloudDB support both materialized views and virtual views.