HOME JOURNALS CONTACT

Information Technology Journal

Year: 2004 | Volume: 3 | Issue: 1 | Page No.: 57-68
DOI: 10.3923/itj.2004.57.68
A Schema Comparison Approach to Determine Semantic Similarity among Schema Elements
Nayyer Masood

Abstract: A semantic based schema comparison approach is presented that generates semantic similarity assertions among schema elements of the component database of a federated database system. The schema comparison approach is a part of a schema analysis methodology ECCAM. The approach uses the interpretation assigned to component schemas and generates ranked semantic similarity assertions. These assertions may be used by the integrator to develop an integrated schema.

Fulltext PDF

How to cite this article
Nayyer Masood , 2004. A Schema Comparison Approach to Determine Semantic Similarity among Schema Elements. Information Technology Journal, 3: 57-68.

Keywords: semantic heterogeneithies, schema interpretation, semantic similarity and simularity assertions

REFERENCES
  • Sheth, A.P. and J.A. Larson, 1990. Federated database systems for managing distributed heterogeneous and autonomous databases. ACM Comput. Surv., 22: 183-236.
    CrossRef    Direct Link    

  • Garcia-Solace, M., F. Saltor and M. Castellanos, 1995. Semantic Heterogeneity in Multidatabase Systems. In: Object-Oriented Multidatabase Systems: A Solution for Advanced Applications, Bukhres, O.A. and A. Elmagarmid (Eds.). Prentice Hall Int. Ltd., Hertfordshire, UK., ISBN: 0-13-103813-3

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

  • Siegel, M. and S.E. Madnick, 1991. A metadata approach to resolving semantic conflicts. Proceedings of the 17th International Conference on Very Large Data Bases Sept. 3-6, Morgan Kaufmann Publishers Inc., San Francisco, CA. USA., pp: 133-145.

  • Yu, C., W. Sun, S. Dao and D. Keirsey, 1991. Determining relationships among attributes for interoperability of multi-databases systems. Proceedings of the 1st International Workshop on Interoperability in Multidatabase Systems, Apr. 7-9, IMS, Kyoto, Japan, pp: 251-257.

  • Fankhauser, P. and E.J. Neuhold, 1992. Knowledge based integration of heterogeneous databses. Proceedings of the IFIP WG 2.6 Database Semantics Conference on Interoperable Database Systems, Nov. 16-20, Amsterdam, The Netherlands, pp: 155-175.

  • Sheth, A.P., S.K. Gala and S.B. Navathe, 1993. On automatic reasoning for schema integration. Int. J. Intelligent Cooperative Inform. Syst., 2: 23-50.
    Direct Link    

  • Kashyap, V. and A. Sheth, 1996. Semantic and schematic similarities between database objects: A context based approach. Int. J. Very Large Data Bases, 5: 276-304.
    Direct Link    

  • Masood, N. and B. Eaglestone, 1998. Semantics based schema analysis. Proceedings of the 9th International Conference on Database and Expert Systems Applications, Aug. 24-28, Springer Verlag, London, UK., pp: 80-89.

  • Masood, N., 1999. Semantics based schema analysis. Ph.D. Thesis, University of Bradford, UK.

  • Masood, N. and B. Eaglestone, 2003. Component and federation concept models in a federated database system. Malaysian J. Comput. Sci., 16: 47-57.
    Direct Link    

  • Gruber, T.R., 1993. A translation approach to portable ontology specifications. Knowledge Acquisit., 5: 199-220.
    CrossRef    Direct Link    

  • Milo, T. and S. Zohar, 1999. Using schema matching to simplify heterogeneous data translation. Proceedings of the 24th International Conference on Very Large Data Bases, May 31-Jun. 3, Philadelphia, Pennsylvania, USA., pp: 215-226.

  • Palopoli, L., D. Sacca and D. Ursino, 1998. Semi-automatic semantic discovery of properties from database schema. Proceedings of the 1998 International Symposium on Database Engineering and Applications, Jul. 8-10, IEEE Computer Society, Washington DC. USA., pp: 244-253.

  • Mitra, P., G. Wiederhold and M. Kerson, 2000. A graph oriented model for articulation of ontology interdendencies. Proceedings of the 7th International Conference on Extending Database Technology: Advances in Database Technology, Mar. 27-31, Springer Verlag, London, UK., pp: 86-100.

  • Doan, A.H., P. Domingos and A. Levy, 2000. Learning source descriptions for data integration. Proceedings of a Workshop at the Conference of the American Association for Artificial Intelligence, (WCAAAI'00), USA., pp: 81-92.

  • Madhavan, J., P.A. Bernstein and E. Rahm, 2001. Generic schema matching with cupid. Proceedings of the 27th International Conference on very Large Data Bases, September 11-14, 2001, Roma, Italy, pp: 49-58.

  • Yan, L., R.J. Miller, L.M. Haas and R. Fagin, 2001. Data-driven understanding and refinement of schema mappings. Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data, May 21-24, ACM, New York, USA., pp: 485-496.

    • © Science Alert. All Rights Reserved