Data integration in data warehousing

International Journal of Cooperative Information Systems

Volumn 10, Issue 3, 2001, Pages 237-271

  Calvanese, Diego ^a   De Giacomq, Giuseppe ^a   Lenzerini, Maurizio ^a   Nardi, Daniele ^a   Rosati, Riccardo ^a  

^a SAPIENZA UNIVERSITY OF ROME   (Italy)

Author keywords

Automated reasoning; Data integration; Data reconciliation; Data Warehousing; Local as view approach; Query rewriting

Indexed keywords

EID: 0035588024     PISSN: 02188430     EISSN: None     Source Type: Journal    
DOI: 10.1142/S0218843001000345     Document Type: Article

References (64)

1. W. H. Inmon, Building the Data Warehouse, 2nd end. (John Wiley & Sons, 1996).
2. R. Hull, Managing semantic heterogeneity in databases: A theoretical perspective, Proc. PODS'97, 1997.
3. G. Wiederhold, Mediators in the architecture of future information systems, IEEE Comput. 25, 3 (1992) 38-49.
4. J. D. Ullman, Information integration using logical views, Proc. ICDT'97, LNCS (Springer-Verlag, 1997) 19-40.
5. R. Hull and G. Zhou, A framework for supporting data integration using the materialized and virtual approaches, Proc. ACM SIGMOD (1996) 481-492.
6. M. Jarke, M. Lenzerini, Y. Vassiliou and P. Vassiliadis (eds.), Fundamentals of Data Warehouses (Springer-Verlag, 1999).
7. B. Devlin, Data Warehouse: From Architecture to Implementation (Addison Wesley Publ. Co., Reading, MA, 1997).
8. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi and R. Rosati, Source integration in data warehousing, Proc. DEXA '98 (IEEE Computer Society Press, 1998) 192-197.
9. The Data Warehouse Quality Project http://www.dbnet.ece.ntua.gr/∼dwq/, 1999.
10. C. Batini, M. Lenzerini and S. B. Navathe, A comparative analysis of methodologies for database schema integration, ACM Computing Surveys 18, 4 (1986) 323-364.
11. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi and R. Rosati, Source integration in data warehousing, Technical Report DWQ-UNIROMA-002, DWQ Consortium, October 1997.
12. A. Y. Levy, A. O. Mendelzon, Y. Sagiv and D. Srivastava, Answering queries using views, Proc. PODS'95 (1995) 95-104.
13. S. Abiteboul and O. Duschka, Complexity of answering queries using materialized views, Proc. PODS'98 (1998) 254-265.
14. H. Galhardas, D. Florescu, D. Shasha and E. Simon, An extensible framework for data cleaning, Technical Report 3742, INRIA, Rocquencourt, 1999.
15. J. Hammer, H. Garcia-Molina, J. Widom, W. Labio and Y. Zhuge, The Stanford data warehousing project, IEEE Bull. Data Eng. 18, 2 (1995) 41-48.
16. J. Widom, Special issue on materialized views and data warehousing, IEEE Bull. Data Eng. 18, 2, 1995.
17. A. Gupta and I. S. Mumick, Maintenance of materialized views: Problems, techniques and applications, IEEE Bull. Data Eng. 18, 2 (1995) 3-18.
18. G. Zhou, R. Hull and R. King, Generating data integration mediators that use materializations, J. Intell. Inf. Syst. 6 (1996) 199-221.
19. G. Zhou, R. Hull, R. King and J.-C. Franchitti, Using object matching and materialization to integrate heterogeneous databases, Proc. CoopIS'95 (1995) 4-18.
20. Y. Papakonstantinou, H. Garcia-Molina and J. Widom, Object exchange across heterogeneous information sources, Proc. ICDE'95 (1995) 251-260.
21. C. H. Goh, S. Bressan, S. E. Madnick and M. D. Siegel, Context interchange: New features and formalisms for the intelligent integration of information, ACM Trans. Inf. Sys. 17, 3 (1999) 270-293.
22. A. Rajaraman, Y. Sagiv and J. D. Ullman, Answering queries using templates with binding patterns, Proc. PODS'95, 1995.
23. D. Srivastava, S. Dar, H. V. Jagadish and A. Levy, Answering queries with aggregation using views, Proc. VLDB'96 (1996) 318-329.
24. F. N. Afrati, M. Gergatsoulis and T. Kavalieros, Answering queries using materialized views with disjunction, Proc. ICDT'99, Lecture Notes in Computer Science (Springer-Verlag, 1999) 435-452.
25. O. M. Duschka and M. R. Genesereth, Answering recursive queries using views, Proc. PODS'97 (1997) 109-116.
26. C. Beeri, A. Y. Levy and M.-C. Rousset, Rewriting queries using views in description logics, Proc. PODS'97 (1997) 99-108.
27. J. Gryz, Query folding with inclusion dependencies, Proc. ICDE'98 (1998) 126-133.
28. O. M. Duschka and A. Y. Levy, Recursive plans for information gathering, Proc. IJCAI'97 (1997) 778-784.
29. S. Cohen, W. Nutt and A. Serebrenik, Rewriting aggregate queries using views, Proc. PODS'99 (1999) 155-166.
30. S. Grumbach, M. Rafanelli and L. Tininini, Querying aggregate data, Proc. PODS'99 (1999) 174-184.
31. G. Grahne and A. O. Mendelzon, Tableau techniques for querying information sources through global schemas, Proc. ICDT'99, Lectures Notes in Computer Science (Springer-Verlag, 1999) 332-347.
32. D. Calvanese, G. De Giacomo, M. Lenzerini and M. Y. Vardi, Rewriting of regular expressions and regular path queries, Proc. PODS'99 (1999) 194-204.
33. D. Calvanese, G. De Giacomo, M. Lenzerini and M. Y. Vardi, Answering regular path queries using views, Proc. ICDE 2000 (2000) 389-398.
34. D. Calvanese, G. De Giacomo, M. Lenzerini and M. Y. Vardi, Query processing using views for regular path queries with inverse, Proc. PODS 2000 (2000) 58-66.
35. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi and R. Rosati. A principled approach to data integration and reconciliation in data warehousing, Proc. DMDW'99, CEUR Electronic Workshop Proceedings. http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/, 1999.
36. D. Calvanese, G. De Giacomo and R. Rosati, Data integration and reconciliation in data warehousing: Conceptual modeling and reasoning support, Network Inf. Sys. 2 (1999) 4.
37. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi and R. Rosati, Description logic framework for information integration, Proc. KR'98 (1998) 2-13.
38. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi and R. Rosati, Schema and data integration methodology for DWQ, Technical Report DWQ-UNIROMA-004, DWQ Consortium, September 1998.
39. A. Borgida, Description logics in data management, IEEE Trans. Knowledge Data Eng. 7, 5 (1995) 671-682.
40. F. M. Donini, M. Lenzerini, D. Nardi and A. Schaerf, Reasoning in description logics, ed. G. Brewka, Principles of Knowledge Representation, Studies in Logic, Language and Information (CSLI Publications, 1996) 193-238.
41. T. Catarci and M. Lenzerini, Representing and using interschema knowledge in cooperative information systems, J. Intell. Cooperative Inf. Sys. 2, 4 (1993) 375-398.
42. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi and R. Rosati, Information integration: Conceptual modeling and reasoning support, Proc. CoopIS'98 (1998) 280-291.
43. D. Calvanese, G. De Giacomo and M. Lenzerini, On the decidability of query containment under constraints, Proc. PODS'98 (1998) 149-158.
44. S. M. Trisolini, M. Lenzerini and D. Nardi, Data integration and warehousing in Telecom Italia, Proc. ACM SIGMOD (1999) 538-539.
45. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi and R. Rosati, Use of the reconciliation tool at Telecom Italia, Technical Report DWQ-UNIROMA-007, DWQ Consortium, October 1999.
46. R. Bayardo and R. Schrag, Using CSP look-back techniques to solve real-world SAT instances, Proc. AAAI'97 (AAAI Press/The MIT Press, 1997) 203-208.
47. H. Zhang, SATO: An efficient prepositional prover, Proc. CADE'97, Lectures Notes in Computer Science, 1997.
48. J. Crawford and L. Auton, Experimental results on the crossover point in random 3SAT, Artificial Intelligence 81, 1&2 (1996) 31-57.
49. D. Theodoratos, S. Ligoudistianos and T. Sellis, Designing the global Data Warehouse with SPJ views, Proc. CAiSE'99 (1999).
50. A. Sheth and V. Kashyap, So far (schematically) yet so near (semantically) Proc. IFIP DS-5 Conf. Semantics Interoperable Database Sys. (Elsevier, 1992).
51. D. Calvanese, G. De Giacomo, M. Lenzerini and M. Y. Vardi, View-based query processing and constraint satisfaction, Proc. LICS 2000 (2000) 361-371.
52. P. A. Bernstein and T. Bergstraesser, Meta-data support for data transformations using microsoft repository, IEEE Bull. Data Eng. 22, 1 (1999) 9-14.
53. S. Heiler, W.-C. Lee and G. Mitchell, Repository support for metadata-based legacy migration, IEEE Bull. Data Eng. 22, 1 (1999) 37-42.
54. J. M. Hellerstein, M. Stonebraker and R. Caccia, Independent, open enterprose data integration, IEEE Bull. Data Eng. 22, 1 (1999) 43-49.
55. S. Abiteboul, S. Cluet and T. Milo, Correspondence and translation for heterogeneous data, Proc. ICDT'97 (1997) 351-363.
56. R. Domenig and K. R. Dittrich, An overview and classification of mediated query systems, SIGMOD Record 28, 3 (1999) 63-72.
57. Y. Papakonstantinou, H. Garcia-Molina and J. D. Ullman, MedMaker: A mediation system based on declarative specifications, ed. S. Y. W. Su, Proc. ICDE'96 (1996) 132-141.
58. S. Abiteboul, S. Cluet, T. Milo, P. Mogilevsky, J. Simeéon and S. Zohar, Tools for data translation and integration, IEEE Bull. Data Eng. 22, 1 (1999) 3-8.
59. S. Cluet, C. Delobel, J. Simeéon and K. Smaga, Your mediators need data conversion!, Proc. VLDB'98 (1999) 279-290.
60. C. H. Goh, S. E. Madnick and M. Siegel, Context interchange: Overcoming the challenges of large-scale interoperable database systems in a dynamic environment, Proc. CIKM'94 (1994) 337-346.
61. L. L. Yang and M. T. Ozsu, Conflict tolerant queries in AURORA, Proc. CoopIS'99 (1999) 279-290.
62. W. W. Cohen, Some practical observations on the integration of web information, Proc. WebDB'99 (1999) 55-60.
63. M. Jarke, R. Gallersdoerfer, M. Jeusfeld, M. Staudt and S. Eherer, Conceptbase -A deductive object manager for meta databases, J. Intell Inf. Sys. 4 (1995) 2.
64. Z. Kedad and E. Métais, Dealing with semantic heterogeneity during data integration, ER99, Lecture Notes in Computer Science, 1728 (Springer-Verlag, 1999) 325-339.