Query Optimization on Distributed Health Database DBD by Minimizing Attribute Involvement
N. Slamet Sudaryanto, Sudaryanto Sudaryanto, S. Maryani · Journal of Digital Information Management · 2018
Query optimization is an important task in the client / server environment of a distributed database, where large data locations are widely distributed, such as distribution of health epidemiology data based DBD on geographic information systems (GIS).In order to generate query optimization on a distributed database it is necessary to have a proper method on a particular query process function.The query process requires important attention especially in distributed databases, because the result of a cost-based query process (access fees and communication costs) is affected by the involvement of the number of attributes and sites visited.If a query can be decomposed into subqueries that require operations on a separate database (geographically) and can determine the exact site access sequence of a query process query circuit then the operating costs for the query process will be minimal.When a query process in a distributed database occurs, queries operations will search for data from various attributes in a scattered database table, whereas query processes often do not require all the attributes of the table.Therefore, in order to optimize the query required minimum query operation cost (communication cost and access cost).One way to minimize the cost of queries is to separate attributes that are not required by a query, thereby reducing the amount of time communication and access.Can not make mistakes in the separation of attributes, attributes should not be split indiscriminately, because if not appropriate it will result in