Data Integration and Warehousing Using H2O.

@article{DBLP:journals/debu/ZhouHKF95,
  author    = {Gang Zhou and
               Richard Hull and
               Roger King and
               Jean-Claude Franchitti},
  title     = {Data Integration and Warehousing Using H2O},
  journal   = {IEEE Data Eng. Bull.},
  volume    = {18},
  number    = {2},
  year      = {1995},
  pages     = {29-40},
  ee        = {db/journals/debu/ZhouHKF95.html},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

This paper presents a broad framework for data integration, that supports both data materialization and virtual view capabilities, and that can be used with legacy as well as modern database systems. The framework is based on "integration mediators", these are software components that use techniques generalized from active databases, such as triggering and rulebases. This permits the logic, especially for incremental maintenance of materialized data, of an integration mediator to be specified in a relatively declarative and modular fashion.

One specific focus of this paper is the development of a taxonomy of the solution space for supporting and maintaining integrated views. A second focus concerns providing support for intricate object matching criteria that specify when object representations (e.g., OIDs) in different databases correspond to the same object-in-the-world (or interchangeable ones).

Copyright © 1995 by the author(s). Abstract used with permission.

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/smod7592 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD2 or /dvd

Online Edition:

References

[AHV95]

Serge Abiteboul, Richard Hull, Victor Vianu: Foundations of Databases. Addison-Wesley 1995, ISBN 0-201-53771-0
Contents BibTeX

[ACHK93]

Yigal Arens, Chin Y. Chee, Chun-Nan Hsu, Craig A. Knoblock: Retrieving and Integrating Data from Multiple Information Sources. Int. J. Cooperative Inf. Syst. 2(2): 127-158(1993) BibTeX

[BDD+95]

...

[BLT86]

José A. Blakeley, Per-Åke Larson, Frank Wm. Tompa: Efficiently Updating Materialized Views. SIGMOD Conference 1986: 61-71 BibTeX

[Cha94]

...

[CH95]

Ti-Pin Chang, Richard Hull: Using Witness Generators to Support Bi-directional Update Between Object-Based Databases. PODS 1995: 196-207 BibTeX

[CW91]

Stefano Ceri, Jennifer Widom: Deriving Production Rules for Incremental View Maintenance. VLDB 1991: 577-589 BibTeX

[Dal95]

...

[DH84]

Umeshwar Dayal, Hai-Yann Hwang: View Definition and Generalization for Database Integration in a Multidatabase System. IEEE Trans. Software Eng. 10(6): 628-645(1984) BibTeX

[DHDD95]

Michael Doherty, Richard Hull, Marcia A. Derr, Jacques Durand: On Detecting Conflict Between Proposed Updates. DBPL 1995: 7 BibTeX

[DHR95]

...

[EK91]

Frank Eliassen, Randi Karlsen: Interoperability and Object Identity. SIGMOD Record 20(4): 25-29(1991) BibTeX

[FK93]

...

[FRV95]

Daniela Florescu, Louiqa Raschid, Patrick Valduriez: Using Heterogeneous Equivalences for Query Rewriting in Multidatabase Systems. CoopIS 1995: 158-169 BibTeX

[FWW+93]

...

[GHJ+93]

Shahram Ghandeharizadeh, Richard Hull, Dean Jacobs, Jaime Castillo, Martha Escobar-Molano, Shih-Hui Lu, Junhui Luo, Chiu Tsang, Gang Zhou: On Implementing a Language for Specifying Active Database Execution Models. VLDB 1993: 441-454 BibTeX

[GHJ94]

Shahram Ghandeharizadeh, Richard Hull, Dean Jacobs: Heraclitus: Elevating Deltas to be First-Class Citizens in a Database Programming Language. ACM Trans. Database Syst. 21(3): 370-426(1996) BibTeX

[GMS93]

Ashish Gupta, Inderpal Singh Mumick, V. S. Subrahmanian: Maintaining Views Incrementally. SIGMOD Conference 1993: 157-166 BibTeX

[HJ91]

Richard Hull, Dean Jacobs: Language Constructs for Programming Active Databases. VLDB 1991: 455-467 BibTeX

[IK93]

W. H. Inmon, Ch. Kelley: Rdb/VMS: Developing the Data Warehouse. QED Publishing Group/John Wiley 1993, ISBN 0-471-56920-8
BibTeX

[KAAK93]

William Kent, Rafi Ahmed, Joseph Albert, Mohammad A. Ketabchi, Ming-Chien Shan: Object Identification in Multidatabase Systems. DS-5 1992: 313-330 BibTeX

[WC95]

...

[WHW89]

...

[WHW90]

Surjatini Widjojo, Richard Hull, Dave Wile: A Specificational Approach to Merging Persistent Object Bases. POS 1990: 267-278 BibTeX

[Wie92]

Gio Wiederhold: Mediators in the Architecture of Future Information Systems. IEEE Computer 25(3): 38-49(1992) BibTeX

[ZGHW95]

Yue Zhuge, Hector Garcia-Molina, Joachim Hammer, Jennifer Widom: View Maintenance in a Warehousing Environment. SIGMOD Conference 1995: 316-327 BibTeX

[ZHKF95]

Gang Zhou, Richard Hull, Roger King, Jean-Claude Franchitti: Using Object Matching and Materialization to Integrate Heterogeneous Databases. CoopIS 1995: 4-18 BibTeX

Referenced by

1. Ruxandra Domenig, Klaus R. Dittrich: An Overview and Classification of Mediated Query Systems. SIGMOD Record 28(3): 63-72(1999)
2. Zoubida Kedad, Elisabeth Métais: Dealing with Semantic Heterogeneity During Data Integration. ER 1999: 325-339
3. Stella Gatziu, Arne Koschel, Günter von Bültzingsloewen, Hans Fritschi: Unbundling Active Functionality. SIGMOD Record 27(1): 35-40(1998)
4. Sofien Gannouni, Emmanuel Gleizer: Incremental View Maintenance for Data Warehousing. ADBIS 1996: 93-101
5. Jennifer Widom: Research Problems in Data Warehousing. CIKM 1995: 25-30