The intrinsic problems of structural heterogeneity and an approach to their solution

VLDB Journal

Volumn 8, Issue 1, 1999, Pages 25-43

  Härder, Theo ^a   Sauter, Günter ^b   Thomas, Joachim ^c  

^a Rheinland Pfälzische Technische Universität Kaiserslautern Landau   (Germany)

^b DAIMLER AG   (Germany)

^c UBS AG   (Switzerland)

Author keywords

Heterogeneity; Legacy systems; Mapping language; Schema integration; Schema mapping; Updatable views

Indexed keywords

EID: 0033130096     PISSN: 10668888     EISSN: None     Source Type: Journal    
DOI: 10.1007/s007780050072     Document Type: Article

References (60)

1. Abiteboul S, Bonner AJ (1991) Objects and Views. In: Clifford J, King R (eds) Proc. ACM SIGMOD, 1991, Denver, Colo. SIGMOD Record 20(2), 1991, pp 238-247
2. Andersson M (1994) Extracting an Entity-Relationship Schema from a Relational Database Through Reverse Engineering. In: Loucopoulos P (ed) Proc. 13th Int. Conf. on the Entity Relationship Approach (In: LNCS 881), 1994, Manchester, UK. LNCS 881, Springer, Heidelberg, 1994, pp 403-419
3. Atkinson M, et al. (1989) The Object-Oriented Database System Manifesto. In: Kim W, Nicolas JM, Nishio S (eds) Proc. 1st Int. Conf. on Deductive and Object-Oriented Databases, 1989, Kyoto, Japan, 1989. North-Holland, Elsevier 1990, pp 223-240
4. Ahmed R, Rafii A (1990) Relational Schema Mapping and Query Translation in Pegasus. Technical Report HPL-DTD-90-12. Hewlett-Packard Laboratories, 1990, Palo Alto, Calif.
5. Bailey I (1995) EXPRESS-M Reference Manual. ISO Document TC 184/SC4/WG5 N243. International Organization for Standardization, Geneva, Switzerland
6. Bukhres OA, Elmagarmid AK (1996) Object-Oriented Multidatabase Systems. Prentice Hall, Englewood Cliffs, N.J.
7. Blakeley JA, Coburn N, Larson R-A (1989) Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates. ACM Trans Database Syst 14(3): 369-400
8. Batini C, Ceri S, Navathe S (1991) Conceptual Database Design: An Entity-Relationship Approach. Benjamin Cummings, New York
9. Bright MW, Hurson AR, Pakzad SH (1992) A Taxonomy and Current Issues in Multidatabase Systems. IEEE Comput 25(3): 50-60
10. Bright MW, Hurson AR, Pakzad S (1994) Automated Resolution of Semantic Heterogeneity in Multidatabases. ACM Trans Database Syst 19(2): 212-253
11. Blakeley JA (1997) Universal Data Access with OLE DB. Proc. IEEE Compcon '97, San Jose, IEEE Computer Society Press, 1997, Los Alamitos, Calif., pp 2-7
12. Batini C, Lenzerini M, Navathe SB (1986) A Comparative Analysis of Methodologies for Database Schema Integration. ACM Comput Surv 18(4): 323-364
13. Barsalou T, Siambela N, Keller AM, Wiederhold G (1991) Updating Relational Databases through Object-based Views. In: Clifford J, King R (eds) Proc. ACM SIGMOD, 1991, Denver, Colo., 1991, SIGMOD Record 20(2), pp 248-257
14. Cattell R (1996) The Object Database Standard: ODMG-93 (Release 1.2). Morgan Kaufmann, San Mateo, Calif.
15. Carey M, et al. (1995) Towards Heterogeneous Multimedia Information Systems: The Garlic Approach. In: Buhkhres OAk Özsu MT, Shan MC (eds) Proc. 5th Int. Workshop on Research Issues in Data Engineering: Distributed Object Management, 1995, Taipei, Taiwan, 1991, IEEE Computer Society Press, Los Alamitos, Calif., pp 124-131
16. Chomicki J, Litwin W (1992) Declarative Definition of Object-Oriented Multidatabase Mappings. In: Özsu MT, Dayal U, Valduriez P (eds) Distributed Object Management. Morgan Kaufmann, San Mateo, Calif., pp 375-392
17. Chiang RHL, Barron TM, Storey VC (1994) Reverse Engineering of Relational Databases: Extraction of an EER Model form a Relational Database. IEEE Trans Data Knowl Eng 10(12): 107-142
18. Chatterjee A, Segev A (1991) Data Manipulation in Heterogeneous Databases. SIGMOD Rec 20(4): 64-68
19. Drew R, King R, McLeod D, Rusinkiewicz M, Silberschatz A (1993) Report of the Workshop on Semantic Heterogeneity and Interoperation in Multidatabase Systems. SIGMOD Rec 22(3): 47-56
20. Dayal U (1983) Processing Queries Over Generalization Hierarchies in a Multidatabase System. In: Schkolnick M, Thanos C (eds) Proc. 9th VLDB Conf, 1983, Florence, Italy, 1982, Morgan Kaufmann, San Mateo, Calif., pp 342-353
21. Dupont Y (1994) Resolving Fragmentation Conflicts in Schema Integration. In: Loucopoulos P (ed) Proc. 13th Int. Conf. on the Entity-Relationship Approach, 1994, Manchester, UK. LNCS 881, Springer, Berlin Heidelberg New York, pp 513-532
22. Gotthard W, Lockemann PC, Neufeld A (1992) System-guided View Integration for Object-oriented Databases. IEEE Trans Knowl Data Eng 4(1): 1-22
23. Garcia-Solaco M, Saltor F, Castellanos M (1996) Semantic Heterogeneity in Multidatabase Systems. In: Bukhres OA, Elmagarmid AK (eds) Object-Oriented Multidatabase Systems - A Solution for Advanced Applications. Prentice Hall, Englewood Cliffs, N.J., pp 129-202
24. Hardwick M (1995) EXPRESS-V Language. Technical Report. Rensselaer Polytechnic Institute, Laboratory for Industrial Information Infrastructure, Troy, NY
25. Hainaut J-L, Tonneau C, Joris M, Chandelon M (1993) Transformation-based Database Reverse Engineering. In: Elmasri R, Kouramajian V, Thalheim B (eds) Proc. 12th Int. Conf. on Entity-Relationship Approach, 1993, Dallas, Tex., 1993, LNCS 823, Springer, Berlin Heidelberg New York, pp 364-374
26. IBM Corp. (1995) DataJoiner: A Multidatabase Server - Version 1. White Paper. IBM Corp., Armonk, N.J.; http://www.software.ibm.com/data/pubs/papers/
27. International Organization for Standardization (1994) Industrial automation systems and integration - Product data representation and exchange - Part 1: Overview and fundamental principles. Int. Standard, 1st edition. ISO 10303. International Organization for Standardization, Geneva, Switzerland
28. International Organization for Standardization (1994) Industrial automation systems and integration - Product data representation and exchange - Part 11: Description methods: The EXPRESS language reference manual. Int. Standard, 1st edition. ISO 10303. International Organization for Standardization, Geneva, Switzerland
29. International Organization for Standardization (1996) ISO 10303 - Industrial automation systems and integration -Product data representation and exchange - Part 22: Standard Data Access Interface. ISO Document TC 184/SC4/WG7. International Organization for Standardization, Geneva, Switzerland
30. International Organization for Standardization (1998) ISO 10303 - Industrial automation systems and integration -Product data representation and exchange - Part 214: Application Protocol: Core Data for Automotive Mechanical Design Processes. ISO Docurrent TC 184/SC4/WG3. International Organization for Standardization, Geneva, Switzerland
31. International Organization for Standardization (1998) EXPRESS-X Language Reference Manual. ISO Document TC 184/SC4/WG11 N052. International Organization for Standardization, Geneva, Switzerland; http://www.nist.gov/sc4/wg.qc/wg11/
32. Koh J-L, Chen ALP (1995) A Mapping Strategy for Querying Multiple Object Databases with a Global Object Schema. In: Buhkhres OA, Özsu MT, Shan MC (eds) Proc. IEEE Int. Workshop on Research Issues on Data Engineering -Distributed Data Management, 1995, IEEE Computer Society Press, Los Alamitos, Calif., pp 50-57
33. Kim W, Choi I, Gala S, Scheevel M (1995) On Resolving Schematic Heterogeneity in Multidatabase Systems. In: Kim W (ed) Modern Database Systems - The Object Model, Interoperability, and Beyond. Addison-Wesley, Reading, Mass., pp 521-550
34. Kaul M, Drostern K, Neuhold E (1990) ViewSystem: Integrating Heterogeneous Information Bases by Object-Oriented Views. Proc. 6th Int. Conf. on Data Engineering, 1990, Los Angeles, Calif., 1990, IEEE Computer Society Press, Los Alamitos, Calif., pp 2-10
35. Kent W (1991) Solving Domain Mismatch and Schema Mismatch Problems with an Object-Oriented Database Programming Language. In: Lohman GM, Sernadas A, Camps R (eds) Proc. 17th VLDB Conf, 1991, Barcelona, Spain, 1991, Morgan Kaufmann, San Mateo, Calif., pp 147-158
36. Klas W, Fankhauser P, Muth P, Rakow TC, Neuhold EJ (1996) Database Integration Using the Open Object-Oriented Database System VODAK. In: Bukhres O, Elmagarmid AK (eds) Object-oriented Multidatabase Systems: A Solution for Advanced Applications. Prentice Hall, Englewood Cliffs, N.J., 1996, Chapter 14
37. Krishnamurthy R, Litwin W, Kent W (1991) Language Features for Interoperability of Databases with Schematic Discrepancies. In: Clifford J, King R (eds) Proc. ACM SIGMOD, 1991, Denver, Colo. ACM Press, New York, pp 40-49
38. Kim W, Seo J (1991) Classifying Schematic and Data Heterogeneity in Multidatabase Systems. IEEE Comput 24(12): 12-18
39. Kashyap V, Sheth AP (1996) Semantic and Schematic Similarities Between Database Objects: A Context-Based Approach. VLDB J 5(4): 276-304
40. Langerak R (1990) View Updates in Relational Databases with an Independent Scheme. ACM Trans Database Syst 15(1): 40-66
41. Larson LA, Sheth AP (1991) Updating relational views using knowledge at view definition and view update time. Inf Syst 16(2): 145-168
42. Mattos NM (1991) An Approach to Knowledge Base Management (LNAI 513). Springer, Heidelberg
43. Missier P, Rusinkiewicz M (1993) Extending a Multidatabase Manipulation Language to Resolve Schema and Data Conflicts. Technical Report UH-CS-93-10. University Houston, Tex.
44. Premerlani WJ, Blaha MR (1994) An Approach for Reverse Engineering of Relational Databases. Commun ACM 37(5): 42-49
45. Pitoura E, Bukhres O, Elmagarmid A (1995) Object Orientation in Multidatabase Systems. Comput Surv 27(2): 141-195
46. Papakonstantinou Y, Garcia-Molina H, Ullman J (1996) MedMaker: A Mediation System Based on Declarative Specifications. In: Su SYW (ed) Proc. 12th Int. Conf. on Data Engineering, 1996, New Orleans, La., 1996, IEEE Computer Society Press, Los Alamitos, Calif., pp 132-141
47. Roth MT, Schwarz P (1997) Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources. In: Jarke M, Carey MJ et al (eds) Proc. 23rd VLDB; Conf, 1997, Athens, Greece, 1997, Morgan Kaufmann, San Mateo, Calif., pp 266-275
48. Roussopoulos N, Melvin Chen C, Kelley S, Delis A, Papakonstantinou Y (1995) The ADMS Project: View R Us. Data Eng Bull 18(2): 19-28
49. Sauter G (1996) The Mapping Language BRUTY - Reference Manual. Technical Report 173-96-007. Daimler-Benz AG, Research &Technology, Ulm, Germany
50. Sauter G (1996) Impacts of Heterogeneity on Interoperability. Technical Report 173-96-021. Daimler-Benz AG, Research & Technology, Ulm, Germany
51. Sauter G (1998) Interoperability of Database Systems with Structural Heterogeneity, (in German), Doctoral Thesis. Computer Science Dept., University of Kaiserslautern, St, Augustin, Germany
52. Sheth AP, Gala SK, Navathe SB (1993) On Automatic Reasoning for Schema Integration. Int J Intelligent Coop Inf Syst 2(1): 23-50
53. Sheth A, Larson JA (1990) Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. Comput Surv 22(3): 183-236
54. Spaccapietra S, Parent C, Dupont Y (1992) Model-Independent Assertions for Integration of Heterogeneous Schemas. VLDB J 1: 81-126
55. Sciore E, Siegel M, Rosenthal A (1994) Using Semantic Values to Facilitate Interoperability Among Heterogeneous Information Systems. ACM Trans Database Syst 19(2): 254-290
56. Scholl MH, Schek HJ, Tresch M (1992) Object Algebra and Views for Multi-Objectbases. In: Ozsu MT, Dayal U, Valduriez P (eds) Distributed Object Management. Morgan Kaufmann, San Mateo, Calif., pp 353-374
57. Tsai PSM, Chen ALP (1994) Concept Hierarchies for Database Integration in a Multidatabase System. Proc. 6th Int. COMAD, 1994, Bangalore, India
58. Vermeer MWW, Apers PAG (1995) Reverse Engineering of Relational Database Applications. In: Papazoglou MP (eds) Proc. Int. 14th Int. Conf. Object-Oriented and Entity-Relationship Modelling, 1995, Gold Coast, Australia, 1995, LNCS 1021, Springer, Berlin Heidelberg New York, pp 89-100
59. Widom J (1995) Research Problems in Data Warehousing. Proc. 4th Int. Conf. on Information and Knowledge Management, 1995, Baltimore, Md., 1995, pp 25-30
60. Zhou G, Hull R, King R, Franchitti J-C (1995) Using Object Matching and Materialization to Integrate Heterogeneous Databases. In: Laufmann S, Spaccapietra S, Yokoi T (eds) Proc. 3rd Int. Conf. on Cooperative Information Systems, Vienna, Austria, 1995, pp 4-18