Article

An approach for identifying attribute correspondences in multilingual schemas

Authors:

Dongqing YangAuthors Info & Claims

SAC '06: Proceedings of the 2006 ACM symposium on Applied computing

Pages 1674 - 1678

https://doi.org/10.1145/1141277.1141673

Published: 23 April 2006 Publication History

Abstract

In this paper, we focus on a new problem in database integration---attribute correspondence identification in multilingual schemas, and give a rule-based method for the problem. Attribute correspondence identification in multilingual schemas involves the study of integrating schemas, designed in various languages, and returns the correspondences among those schemas. We first analyze the problem through two schemas of a large financial corporate of China. Based on the relationships of the attribute names of the schemas, a method of name-based attribute correspondence identification is proposed. And we give a computer-aided system to deal with the problem according to the method. The components and identifying procedure of the method have been discussed in detail in the paper. We have implemented a prototype, and the tool shows its effectiveness in application.

References

[1]

Li W, Clifton C., SemInt: a tool for identifying attribute correspondences in heterogeneous databases using neural network. Data Knowl Eng 33(1):49--84, 2000.

Digital Library

[2]

C. Parent, S. Spaccapietra, Database integration: An overview of issues and approaches, Commun. ACM 41(5):166--178, New York, 1998.

Digital Library

[3]

J. M. Smith, P. A. Bernstein, U. Dayal, N. Goodman, T. Landers, T. Lin, E. Wang, Multibase integrating heterogeneous distributed database systems, in: Proceeding of the National Computer Conference, pp. 487--499, 1981.

[4]

Sheth A., Larson J. Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Comput. Sur. 22(3):183--236, 1990.

Digital Library

[5]

D. McLeod, D. Heimbigner, A federated architecture for database systems, in: Proceedings of the National Computer Conference, Anaheim, CA, pp. 283--289, 1980.

Digital Library

[6]

S. Busse, R.-D. Kutsche, U. Leser, H. Weber, Federated Information Systems: concepts, terminology and architectures, Technical Report Nr. 99-9, TU Berlin, 1999.

[7]

Jose Samos, Felix Saltor, Jaume Sistac and Agusti Bardes. Database architecture for data warehousing: an evolutionary approach. In Proceedings of DEXA, pp.746--756, 1998.

Digital Library

[8]

J. A. Larson, S. B. Navathe, R. Elmasri, A theory of attribute equivalence in database with application to schema integration, IEEE Trans. Software Eng. 15 (4):449--463, 1989.

Digital Library

[9]

S. Hayne, S. Ram, Multi-user view integration system (MUVIS): An expert system for view integration, in Proceedings of the Sixth International Conference on Data Engineering, New York, pp. 402--409, 1990.

Digital Library

[10]

Castano S, De AntonellisV, De Capitani diVemercati, Global viewing of heterogeneous data sources. IEEE Trans Data Knowl Eng 13(2):277--297, 2001.

Digital Library

[11]

S. Bergamaschi, S. Castano, S. De Capitani di Vimercati, S. Montanari, and M. Vincini, An Intelligent Approach to Information Integration, in Proc. Int'l Conf. Formal Ontology in Information Systems, 1998.

[12]

G. A. Miller, WordNet: A Lexical Databases for English, Commun., ACM 38(11):39--41, 1995.

Digital Library

[13]

Bergamaschi S, Castano S, Vincini M, and Beneventano D. Semantic Integration of Heterogeneous Information Sources. Data Knowledge Engineering 36(3):215--249, 2001.

Digital Library

[14]

Robin Dhamankar, Yoonkyong Lee, AnHai Doan, Alon Halevy, Pedro Domingos, iMAP: Discovering Complex Semantic Matches between Database Schemas, SIGMOD 2004, pp.13--18, 2004.

Digital Library

[15]

S. S. Benkley, J. F. Fandozzi, E. M. Housman, G. M. Woodhouse. Data element tool-based analysis (DELTA). Technical Report MTR 95B0000147, The MITRE Corporation, Bedford, MA, December 1995.

[16]

Chen Zhaoxiong, Gao Qingshi, English-Chinese machine translation system IMT/EC, Proceedings of the 12th conference on Computational linguistics, Budapest, Hungry, 1988.

Digital Library

[17]

R. F. Simmons, Technologies for machine translation, FGCS, 2(2):83--94, 1986.

Digital Library

[18]

Maurizio Lenzerini: Principles of P2P Data Integration. In Proceedings of DIWeb 2004, pp.7--21, 2004.

[19]

Alon Y. Halevy, Naveen Ashish, Dina Bitton, Michael J. Carey, Denise Draper, Jeff Pollock, Arnon Rosenthal, Vishal Sikka: Enterprise information integration: successes, challenges and controversies. In Proceedings of SIGMOD 2005, pp.778--787, 2005.

Digital Library

[20]

P. Shvaiko and J. Euzenat. A survey of schema-based matching approaches. Journal on Data Semantics, IV, 146--171, 2005.

Digital Library

[21]

N. Noy. Semantic Integration: A survey of ontology-based approaches. SIGMOD Record, 33(4):65--70, 2004.

Digital Library

[22]

Aumuller, H. H. Do, S. Massmann, and E. Rahm. Schema and ontology matching with COMA++. In Proceedings of SIGMOD 2005, pp.906--908, 2005.

Digital Library

[23]

F. Giunchiglia, P. Shvaiko, M. Yatskevich. Semantic Schema Matching, In Proceedings of CoopIS 2005, pp.347--365, 2005.

Digital Library

Cited By

Yu PWang H(2011)A multilingual ontology-based approach to attribute correspondence identification2011 International Conference on Electrical and Control Engineering10.1109/ICECENG.2011.6057756(1896-1900)Online publication date: Sep-2011
https://doi.org/10.1109/ICECENG.2011.6057756
Wang HTong YTan STang SYang DSun G(2007)An adaptive approach to schema classification for data warehouse modelingJournal of Computer Science and Technology10.1007/s11390-007-9032-822:2(252-260)Online publication date: 1-Mar-2007
https://dl.acm.org/doi/10.1007/s11390-007-9032-8
Wang HTan STang SYang DTong Y(2006)Identifying Indirect Attribute Correspondences in Multilingual SchemasProceedings of the 17th International Conference on Database and Expert Systems Applications10.1109/DEXA.2006.69(652-656)Online publication date: 4-Sep-2006
https://dl.acm.org/doi/10.1109/DEXA.2006.69

Index Terms

An approach for identifying attribute correspondences in multilingual schemas
1. Computer systems organization
  1. Architectures
    1. Other architectures
      1. Heterogeneous (hybrid) systems
2. Information systems
  1. Data management systems

Recommendations

Identifying Indirect Attribute Correspondences in Multilingual Schemas
DEXA '06: Proceedings of the 17th International Conference on Database and Expert Systems Applications

A fundamental problem in schema integration is attribute correspondences identification. This paper studies a problem of identifying indirect attribute correspondences in multilingual schemas. As far as we know, previous researches of schema integration ...
Instance-based attribute identification in database integration

Abstract.Most research on attribute identification in database integration has focused on integrating attributes using schema and summary information derived from the attribute values. No research has attempted to fully explore the use of attribute ...
Integrating schemas of heterogeneous relational databases through schema matching
iiWAS '09: Proceedings of the 11th International Conference on Information Integration and Web-based Applications & Services

Database integration aims at providing a uniform and consistent view called global schema, over a set of autonomous and heterogeneous data sources, so that data residing in different sources can be accessed as if it was in a single schema. The ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences

SAC '06: Proceedings of the 2006 ACM symposium on Applied computing

April 2006

1967 pages

ISBN:1595931082

DOI:10.1145/1141277

Conference Chair:
Hisham M. Haddad
Kennesaw State University, Kennesaw, Georgia

Copyright © 2006 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGAPP: ACM Special Interest Group on Applied Computing

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 23 April 2006

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

SAC06

Sponsor:

SIGAPP

SAC06: The 2006 ACM Symposium on Applied Computing

April 23 - 27, 2006

Dijon, France

Acceptance Rates

Overall Acceptance Rate 1,650 of 6,669 submissions, 25%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

3
Total Citations
View Citations
264
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 26 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Yu PWang H(2011)A multilingual ontology-based approach to attribute correspondence identification2011 International Conference on Electrical and Control Engineering10.1109/ICECENG.2011.6057756(1896-1900)Online publication date: Sep-2011
https://doi.org/10.1109/ICECENG.2011.6057756
Wang HTong YTan STang SYang DSun G(2007)An adaptive approach to schema classification for data warehouse modelingJournal of Computer Science and Technology10.1007/s11390-007-9032-822:2(252-260)Online publication date: 1-Mar-2007
https://dl.acm.org/doi/10.1007/s11390-007-9032-8
Wang HTan STang SYang DTong Y(2006)Identifying Indirect Attribute Correspondences in Multilingual SchemasProceedings of the 17th International Conference on Database and Expert Systems Applications10.1109/DEXA.2006.69(652-656)Online publication date: 4-Sep-2006
https://dl.acm.org/doi/10.1109/DEXA.2006.69

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents