Implementation of Tuned Schema Merging Approach
Journal Title: Mehran University Research Journal of Engineering and Technology - Year 2018, Vol 37, Issue 4
Abstract
Schema merging is a process of integrating multiple data sources into a GCS (Global Conceptual Schema). It is pivotal to various application domains, like data ware housing and multi-databases. Schema merging requires the identification of corresponding elements, which is done through schema matching process. In this process, corresponding elements across multiple data sources are identified after the comparison of these data sources with each other. In this way, for a given set of data sources and the correspondence between them, different possibilities for creating GCS can be achieved. In applications like multi-databases and data warehousing, new data sources keep joining in and GCS relations are usually expanded horizontally or vertically. Schema merging approaches usually expand GCS relations horizontally or vertically as new data sources join in. As a result of such expansions, an unbalanced GCS is created which either produces too much NULL values in response to global queries or a result of too many Joins causes poor query processing. In this paper, a novel approach, TuSMe (Tuned Schema Merging) techniqueis introduced to overcome the above mentioned issue via developing a balanced GCS, which will be able to control both vertical and horizontal expansion of GCS relations. The approach employs a weighting mechanism in which the weights are assigned to individual attributes of GCS. These weights reflect the connectedness of GCS attributes in accordance with the attributes of the principle data sources. Moreover, the overall strength of the GCS could be scrutinized by combining these weights. A prototype implementation of TuSMe shows significant improvement against other contemporary state-of-the-art approaches.
Authors and Affiliations
Nayyer Masood, Gul Jabeen
Keywords
Related Articles
- EP ID EP394633
- DOI 10.22581/muet1982.1804.05
- Views 116
- Downloads 0
Evaluation of Mesh of Liberation of Zard Koh and Kulli Koh Iron Ores of Pakistan
Liberation size plays a significant role to select a correct and successful concentration method for natural iron ores. This paper aims to evaluate the liberation size of two newly discovered iron ores, namely Zard Koh a...
Job Satisfaction Analysis of Faculty Members in Public Sector Engineering Universities: An Empirical Investigation
Most of the researchers have conducted study on the job satisfaction of the faculty members in Non? Engineering Universities only few have paid their attention in the Public Sector Engineering Universities. This study is...
Optimization of Power Plant for Telecom Sector Based on Embedded System
Modern Telecom Sector is eventually facing exceptionally tough challenges because of continuous and unexpected increase in power density requirement for the communicating machinery and equipment. To fulfil the power requ...
Impairment of Water Quality of Phuleli Canal, Sindh Pakistan: A Review
Supply of quality water has been recognized as one of the water management practices. Clean water is not only essential for drinking and irrigation but also affects eco-services, groundwater aquifer and soil conditions....
Vibration Analysis of Cracked Composite Laminated Plate: A Review
Composites are one of the rapidly consuming materials due to their utmost attractive applications ranging from the aerospace to the agricultural products. The composite structures usually experience vibration during serv...