Data Management on using Distributed Database
Data in the database grows up every day. Therefore continuous data management is essential for database administration.
There are some solution to manage data which becomes too big.
- Move old data into NoSQL storage, and delete them in the Relational Database Management System
- Make Table Partition to separate old data and new hot data
The first way is popular but there are some problems. That is because to detect hot data, which is accessed frequently, and cold data, which is old and accessed not frequently, is difficult.
It is tough task to maintain data with external storage to analyse data.
But by using Dynamic Table Partition, we can manage big data on Relational Database.