Managing fragmented database in distributed database environment / Ainul Azila Che Fauzi ... [et al.]

• Main Authors: Che Fauzi, Ainul Azila, Wan Abdul Rahman, Wan Fariza, Fauzi, Auni, Weigelt, Florian
• Format: Article
• Language: English
• Published: 2021
• Subjects: Theory and method of social science statistics; Data processing. Including SPSS; Study and teaching
• Online Access: https://ir.uitm.edu.my/id/eprint/49083/1/49083.pdf; https://ir.uitm.edu.my/id/eprint/49083/; http://jmcs.com.my/
• Institution: Universiti Teknologi Mara

One of the mechanisms for managing data is replication since it improves data access and reliability. However, the amount of various data grows rapidly since technology is widely available at a low-cost. Problem arises when the transactions only work with a part of the database, not as a whole.This paper will discuss about a technique called database fragmentation. Fragmentation in distributed database is very useful in terms of usage, reliability and efficiency. Handling fragmented database replication becomes a challenging issue to administrators since the distributed database is scattered into split replica partitions or fragments. We address how to build a reliable system by using a distributed database fragmentation algorithm. The result shows that managing database replication with fragmentation will help a transaction to work with the specific part of the database rather than the entire database.