Pages having Table Partition tag
Alinous Elastic DB is a kind of distributed relational databases. The database consists of SQL Transaction, Sharding Management Engine, and Data Storage Engine.
You can configure the scalability of database, from local mode with single database server to full scaling mode.
Engine Components for Distributed Database
In addition to 3 parts of database engines, Transaction Monitor Engine is there. These components can be put on the cloud network.
Read "Architecture of Alinous Elastic DB" more
The Storage Engine of Distributed Database has records in it. The format have to resolve ACID status with the record's information.
Especially on using partitioning, the format is very important to make the performance high.
Data Format of Storage Records
There are two types of policies in database records management supporting ACID. When the records are changed, one of following operations are done.
- Update or Delete the record
- Add a new record with new version
MySQL uses the first method, and PostgreSQL uses second one. The Alinous Elastic DB uses the second method like PostgreSQL.
Read "Storage Records Data Format for Partitioning" more
Traditional Enterprise Relational Database has Partitioning function. It has partitioning information in the schema metadata. Alinous Elastic DB also have it.
And it is designed for Dynamic Table Partition on the distributed remote nodes.
Schema Information for Dynamic Partition Table
Generally, Relational Databases set partition information on creating schema. Actually most of them use CREATE TABLE Statement to set it.
But in this way, it is hard to update the partition keys.
Read "How Dynamic Partition Table Data Grows Up" more
Now, 2017/02/05. To make and manage partition table of database tables is essential to deal bigdata. Therefore I have to design the architecture now.
Whether dynamic maintenance of partitioning is possible or not is also up to the records format of storage engine.
Two Layer Partitioning of Tables
Alinous Elastic DB has 2 layer table data partitioning. By using this function, you can manage cold and hot data in different cloud section.
Read "Design of Dynamic Table Partitioning of Distributed Database" more