1. Vertical Fragmentation Impacts in the Performance and Management Database Health Information System (Comparative Study of Fragmentation Vertically Algorithm).
- Author
-
Nurhendratno, S. S. and Setyowati, M.
- Subjects
ACCESS to information ,DISTRIBUTED databases ,ALGORITHMS ,FRAGMENTATION reactions ,DATABASES - Abstract
The cost and the speedness of data access on a query depend on the numbers of attributes. In fact the query function will search for data from various attributes in the database table, whereas not all the attributes are needed on the accessed tables. To avoid the not necessary attributes, Vertical Fragmentation methods can be used. The purpose of this research aims to compare the vertical fragmentation of database tables using Bond Energy algorithm and Graph-Based Vertical Partitioning algorithm to create a distributed database. The results of both algorithms will determine which attributes will be avoided. Then, the results of the two algorithms are compared and evaluated using Partition Evaluator to show the amount of the access data costs that are used, so to find which is the better algorithm to be applied. Based on some experimental results, GBVP algorithm showed a better performance with higher Partition Evaluator value respectively at 4,98; 10,41; 17,95; 4,64; and 14,07 as well as the lower value of execution time respectively at 0,003; 0,002; 0,002; 0,002; 0,003 and 0,003. [ABSTRACT FROM AUTHOR]
- Published
- 2023
- Full Text
- View/download PDF