The Method to Resolve Schema Discrepancy of a Heterogeneous Database System

Schema integration is an important discipline for constructing a heterogeneous database system. The task becomes particularly challenging when involves the resolution of naming, structural and semantic conflicts. We present a method to integrating tables with structural conflict via the global metadata database (GMDB) and rule base. The method let user pose fuzzy query and comes back all possible results.

[1]  Sandra Geisler,et al.  Automatic generation of mediated schemas through reasoning over data dependencies , 2011, 2011 IEEE 27th International Conference on Data Engineering.

[2]  Arnon Rosenthal,et al.  Using semantic values to facilitate interoperability among heterogeneous information systems , 1994, TODS.

[3]  Philip A. Bernstein,et al.  Merging Models Based on Given Correspondences , 2003, VLDB.

[4]  Maurizio Lenzerini,et al.  Data integration: a theoretical perspective , 2002, PODS.

[5]  Sudha Ram,et al.  Information systems interoperability: What lies beneath? , 2004, TOIS.

[6]  Renée J. Miller,et al.  Composing local-as-view mappings: closure and applications , 2010, ICDT '10.

[7]  Phokion G. Kolaitis,et al.  Semi-Automatic Schema Integration in Clio , 2007, VLDB.

[8]  Georg Gottlob,et al.  Normalization and Optimization of Schema Mappings , 2009, Proc. VLDB Endow..

[9]  Tok Wang Ling,et al.  An ontology based approach to the integration of entity-relationship schemas , 2006, Data Knowl. Eng..

[10]  Philip A. Bernstein,et al.  Schema merging and mapping creation for relational sources , 2008, EDBT '08.

[11]  Wei-Pang Yang,et al.  Integration of Relations with Conflicting Schema Structures in Heterogeneous Database Systems , 1998, Data Knowl. Eng..

[12]  Sudha Ram,et al.  Combining schema and instance information for integrating heterogeneous data sources , 2007, Data Knowl. Eng..

[13]  Erhard Rahm,et al.  Generic schema matching, ten years later , 2011, Proc. VLDB Endow..

[14]  Phokion G. Kolaitis,et al.  Interactive generation of integrated schemas , 2008, SIGMOD Conference.

[15]  Renée J. Miller,et al.  Leveraging data and structure in ontology integration , 2007, SIGMOD '07.

[16]  Laks V. S. Lakshmanan,et al.  SchemaSQL: An extension to SQL for multidatabase interoperability , 2001, ACM Trans. Database Syst..

[17]  Laks V. S. Lakshmanan,et al.  Schema mapping and query translation in heterogeneous P2P XML databases , 2010, The VLDB Journal.