A Distribution Management System for Relational Databases in Cloud Environments
Sze-Yao, Li -, Chunming, Yuh-Shihng Chang, Yuan-Yu, Tsai Tsai, Seth, Chen Chen, Jonathan Jonathan, Wen-Lung · Acta Scientiarum Naturalium Universitatis Sunyatseni · 2013
For a transaction processing system to operate effectively and efficiently in cloud environments, it is important to distribute huge amount of data while guaranteeing the ACID (atomic, consistent, isolated, and durable) properties. Moreover, database partition and migration tools can help transplanting conventional relational database systems to the cloud environment rather than rebuilding a new system. This paper proposes a database distribution management (DBDM) system, which partitions or replicates the data according to the transaction behaviors of the application system. The principle strategy of DBDM is to keep together the data used in a single transaction, and thus, avoiding massive transmission of records in join operations. The proposed system has been implemented successfully. The preliminary experiments show that the DBDM performs the database partition and migration effectively. Also, the DBDM system is modularly designed to adapt to different database management system (DBMS) or different partition algorithms.