SASMINT System for Database Interoperability in Collaborative Networks

Unal, Ozgul

doi:10.1007/11914853_7

Cited by 2 publications

(5 citation statements)

References 22 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…5. This F-measure value is used by Sampler in the following formula, in order to determine the weight of each metric [61]:…”

Section: Assigning Weights and Identifying The Selection Criteriamentioning

confidence: 99%

“…In this respect, the Semi Automatic Schema Matching and INTegration (SASMINT) approach and system [60][61][62] described in this paper is designed and implemented to enable semi-automated matching of relational schemas by using a combination of metrics and algorithms from Natural Language Processing (NLP) and Graph Theory. Furthermore, after the schema matching is executed, SASMINT allows its user to modify and approve the results.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Semi-automated schema integration with SASMINT

Unal

2009

Knowl Inf Syst

Self Cite

View full text Add to dashboard Cite

The emergence of increasing number of collaborating organizations has made clear the need for supporting interoperability infrastructures, enabling sharing and exchange of data among organizations. Schema matching and schema integration are the crucial components of the interoperability infrastructures, and their semi-automation to interrelate or integrate heterogeneous and autonomous databases in collaborative networks is desired. The Semi-Automatic Schema Matching and INTegration (SASMINT) System introduced in this paper identifies and resolves several important syntactic, semantic, and structural conflicts among schemas of relational databases to find their likely matches automatically. Furthermore, after getting the user validation on the matched results, it proposes an integrated schema. SASMINT uses a combination of a variety of metrics and algorithms from the Natural Language Processing and Graph Theory domains for its schema matching. For the schema integration, it utilizes a number of derivation rules defined in the scope of the research work explained in this paper. Furthermore, a derivation language called SASMINT Derivation Markup Language (SDML) is defined for capturing and formulating both the results of matching and the integration that can be further used, for example for federated query processing from independent databases. In summary, the paper focuses on addressing: (1) conflicts among schemas that make automatic schema matching and integration difficult, (2) the main components of the SASMINT approach and system, (3) in-depth exploration of SDML, (4) heuristic rules designed and implemented as part of the schema integration component of the SASMINT system, and (5) experimental evaluation of SASMINT.

show abstract

“…5. This F-measure value is used by Sampler in the following formula, in order to determine the weight of each metric [61]:…”

Section: Assigning Weights and Identifying The Selection Criteriamentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Semi-automated schema integration with SASMINT

Unal

2009

Knowl Inf Syst

Self Cite

View full text Add to dashboard Cite

show abstract

“…Considering the limitations of the previous work as addressed in Section IV, a system, called SemiAutomatic Schema Matching and INTegration (SASMINT), is proposed, capable of automatically resolving naming, structural, and semantic conflicts and semi-automatically integrating relational database schemas [3]. Since user input is required after the schema matching and schema integration, it is aimed to be used by database administrators or users who have sufficient knowledge about the domain as well as database schemas.…”

Section: The Sasmint Systemmentioning

confidence: 99%

“…A formal representation of the derivation language constructs, a variation of PEER derivation language [38], is given in [3]. There are two types of derivation for relational schemas: Table and Column Derivation.…”

Section: Schema Integration Step Of Sasmintmentioning

confidence: 99%

“…Another limitation of the previous approaches is that they typically do not combine different match algorithms in a flexible way. Taking these limitations into account, we propose the SASMINT (Semi Automatic Schema Matching and INTegration) system and approach [3][4][5]. SASMINT proposes a solution to automate the processes related to interlinking of heterogeneous relational databases, particularly focused on schema matching and schema integration in collaborative environments including different forms of collaborative networks.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Schema Matching and Integration for Data Sharing Among Collaborating Organizations

Unal¹

2009

JSW

Self Cite

View full text Add to dashboard Cite

Abstract-Schema matching and schema integration are important components of the data sharing infrastructure in Collaborative Networks. In order to achieve more accurate matching and integration results and enhance efficiency, it is required to provide some mechanisms to carry out these processes as automatically as possible. This paper addresses the problems and challenges related to schema matching and schema integration and introduces the Semi-Automatic Schema Matching and INTegration (SASMINT) system to automate these processes. Other systems aiming at database interoperability typically focus either on schema matching or on schema integration. On the other hand, the SASMINT system combines them and uses the results of schema matching for semi-automatic schema integration. SASMINT follows a composite approach in schema matching, which means it combines the results of variety of algorithms, making it a generic tool applicable for different types of schemas. It also proposes a Sampler component for helping the user to assign the weights to algorithms. Furthermore, SASMINT uses an XML-based derivation language to save the results of schema matching and schema integration, and also to define the components of integrated schemas, in order to further support automated query processing against integrated sources.

show abstract

SASMINT System for Database Interoperability in Collaborative Networks

Cited by 2 publications

References 22 publications

Semi-automated schema integration with SASMINT

Semi-automated schema integration with SASMINT

Schema Matching and Integration for Data Sharing Among Collaborating Organizations

Contact Info

Product

Resources

About