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 126
- Downloads 0
Analysis of Brain Tumors Due to the Usage of Mobile Phones
The impact of cellular phone radiation on human health is the subject of current mindfulness and is an outcome of the huge increase in phone usage throughout the world. Phones use electromagnetic radiation in the microwa...
Application of Differential Evolution for Wind Turbine Micrositing
WTM (Wind Turbine Micrositing) has been an important topic of discussion in recent times. A number of Evolutionary Algorithms have been applied to the WTM problem. The DEA (Differential Evolution Algorithm) is used for a...
Application of ABM to Spectral Features for Emotion Recognition
ER (Emotion Recognition) from speech signals has been among the attractive subjects lately. As known feature extraction and feature selection are most important process steps in ER from speech signals. The aim of present...
A Symmetric RZ-DPSK Based Colorless NG-PON using Optical Carrier Suppression Scheme
In this paper a simultaneous transmission of a 10 Gbps RZ-DPSK data signal for downstream as well as for upstream is proposed and successfully simulated. An OCS (Optical Carrier Suppression) scheme for generation of seco...
Thermodynamic Analysis of Combined Vapor Compression and Vapor Absorption Refrigeration System
Two of the popular refrigeration cycles, VC (Vapor Compression), and VA (Vapor Absorption) are used extensively for refrigeration purposes. In this paper, a system is proposed that works using both cycles powered by an I...