USING CORRESPONDENCE ASSERTIONS TO SPECIFY THE SEMANTICS OF VIEWS IN AN OBJECT-RELATIONAL DATA WAREHOUSE

Valéria Magalhães Pequeno, Joaquim Nunes Aparício

Abstract

An information integration system provides a uniform query interface for collecting of distributed and heterogeneous, possibly autonomous, information sources, giving users the illusion that they interrogate a centralized and homogeneous information system. One approach that has been used for integrating data from multiple databases consists in creating integrated views, which allows for queries to be made against them. Here, we propose the use of Correspondence Assertions (CAs) to formally specify the relationship between the integrated view schema and the source database schemas. In this way, CAs are used to assert that the semantic of some schema’s components are related to the semantic of some components of another schema. Our formalism has the advantages of proving a better understanding of the semantic of integrated view, and of helping to automate some aspects of data integration.

References

  1. Batini, C. et al. (1986). A comparative analysis of methodologies for database schema integration. ACM Computing Surveys, 18(4):323-364.
  2. Carey, M. J. et al. (1995). Towards heterogeneous multimedia information systems: The Garlic approach. In International Workshop on Research Issues in Data Engineering - Distributed Object Management, pages 124-131.
  3. Cattell, R. et al. (2000). The object database standard ODMG 3.0. Morgan Kaufmann Publishers.
  4. Chamberlin, D. D. (1996). Using the new DB2 - IBM's object-relational database system. Morgan Kaufmann.
  5. Codd, E. F. (1970). A relational model of data for large shared data banks. In Communications of the ACM, pages 377-387.
  6. Czejdo, B. D. et al. (2001). Design of a data warehouse over object-oriented and dynamically evolving data sources. In 12th International Workshop on Database and Expert Systems Applications, pages 128-132.
  7. da Costa, J. P. (2002). Gerando tradutores para a atualizac¸a˜o de banco de dados através de vis o˜es de objetos. Master's thesis, Federal University of Ceara, Brazil.
  8. Doan, A. et al. (2003). Object matching for information integration: a profiler-based approach. In Proc. of Workshop on Information Integration on the Web.
  9. dos Santos, C. (1994). Design and implementation of an object-oriented view mechanism. Technical report, Institut National de Recherche en Informatique et en Automatique, France.
  10. Fortier, P. (1999). SQL3 - Implementing the SQL foundation standar. McGraw-Hill, EUA.
  11. Goasdoué, F. et al. (2000). The use of CARIN language and algorithms for information integration: the PICSEL system. International Journal of Cooperative Information Systems, 9(4):383-401.
  12. Gray, J. et al. (1995). Data cube: A relational aggregation operator generalizing group-by, cross-tab, and subtotals. Technical Report msr-tr-95-22, Microsoft.
  13. Iqbal, S. et al. (2003). Distributed heterogeneous relational data warehouse in a grid environment. The Computing Research Repository (CoRR) cs.DC/0306109.
  14. Lóscio, B. F. (1998). Atualizac¸a˜o de múltiplas bases de dados através de mediadores. Master's thesis, Federal University of Ceara, Brazil.
  15. Pequeno, V. M. and Aparício, J. N. (2003). A formal model for object-relational databases. In Proceedings of the 5th International Conference on Enterprise Information Systems(ICEIS), volume 1, pages 327-333.
  16. Pequeno, V. M. and Aparício, J. N. (2004). Using correspondence assertion to specify the semantics of views in an object-relational data warehouse. Technical report, New University of Lisbon.
  17. Subrahmanian, V. et al. (1995). HERMES: A heterogeneous reasoning and mediator system. Technical report, University of Maryland.
  18. V. Harinarayan, A. Rajaraman, J. U. (1996). Implementing data cubes efficiently. In Proceedings of the ACM SIGMOD Conference.
  19. Vidal, V. et al. (2001). Using correspondence assertions for specifying the semantics of XML-based mediators. In Workshop on Information Integration on the Web, volume 3(11).
  20. Vidal, V. and Pequeno, V. (2000). Self-maintanance of match classes in integrated views. In Anais do XV Simpósio Brasileiro de Banco de Dados, Brasil.
  21. Wiederhold, G. (1992). Mediators in the architecture of future information systems. In IEEE Computer, volume 25(3), pages 38-49.
  22. Zhou, G. et al. (1996). Generating data integration mediators that use materialization. Journal of Intelligent Information Systems, 6(2/3):199-221.
Download


Paper Citation


in Harvard Style

Magalhães Pequeno V. and Nunes Aparício J. (2005). USING CORRESPONDENCE ASSERTIONS TO SPECIFY THE SEMANTICS OF VIEWS IN AN OBJECT-RELATIONAL DATA WAREHOUSE . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 219-225. DOI: 10.5220/0002507602190225


in Bibtex Style

@conference{iceis05,
author={Valéria Magalhães Pequeno and Joaquim Nunes Aparício},
title={USING CORRESPONDENCE ASSERTIONS TO SPECIFY THE SEMANTICS OF VIEWS IN AN OBJECT-RELATIONAL DATA WAREHOUSE},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2005},
pages={219-225},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002507602190225},
isbn={972-8865-19-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - USING CORRESPONDENCE ASSERTIONS TO SPECIFY THE SEMANTICS OF VIEWS IN AN OBJECT-RELATIONAL DATA WAREHOUSE
SN - 972-8865-19-8
AU - Magalhães Pequeno V.
AU - Nunes Aparício J.
PY - 2005
SP - 219
EP - 225
DO - 10.5220/0002507602190225