Constructing and Maintaining Scientific Database Views in the Framework of the Object-Protocol Model.

@inproceedings{DBLP:conf/ssdbm/ChenKMS97a,
  author    = {I-Min A. Chen and
               Anthony Kosky and
               Victor M. Markowitz and
               Ernest Szeto},
  editor    = {Yannis E. Ioannidis and
               David M. Hansen},
  title     = {Constructing and Maintaining Scientific Database Views in the
               Framework of the Object-Protocol Model},
  booktitle = {Ninth International Conference on Scientific and Statistical
               Database Management, Proceedings, August 11-13, 1997, Olympia,
               Washington, USA},
  publisher = {IEEE Computer Society},
  year      = {1997},
  isbn      = {0-8186-7952-2},
  pages     = {237-248},
  ee        = {db/conf/ssdbm/ChenKMS97a.html},
  crossref  = {DBLP:conf/ssdbm/97},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Scientific databases (ScDBs) are used to archive and retrieve data describing objects of scientific inquiry. Since these ScDBs must provide continuous and efficient access to large communities of scientists, they are often developed with reliable commercial relational database management systems (DBMSs) or file systems. However, relational DBMSs and flat files do not provide constructs for representing directly ScDB-specific objects and experimental procedures, and therefore they are often hard to develop, maintain, and explore. In this paper, we present a retrofitting tool for constructing and maintaining ScDB views using an object-oriented data model, and describe our experience with retrofitting ScDBs that have been originally developed using relational DBMSs and file systems.

The retrofitting tool is part of a data management toolkit based on the Object-Protocol Model (OPM). The OPM toolkit provides facilities for developing databases defined using OPM and for querying and browsing such ScDBs in terms of OPM constructs. The OPM retrofitting tool allows constructing (one or several) OPM views for ScDBs that have not been originally developed with the OPM tools. ScDBs with native OPM schemas or retrofitted OPM views can be browsed and queried via OPM interfaces, reorganized, or incorporated into an OPM-based database federation.

Copyright © 1997 by The Institute of Electrical and Electronic Engineers, Inc. (IEEE). 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/An2-5 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/aDVD1 or /dvd

Online Edition: IEEE Computer Society DL

Printed Edition

References

[1]

Serge Abiteboul, Anthony J. Bonner: Objects and Views. SIGMOD Conference 1991: 238-247 BibTeX

[2]

François Bancilhon, Claude Delobel, Paris C. Kanellakis (Eds.): Building an Object-Oriented Database System, The Story of O2. Morgan Kaufmann 1992, ISBN 1-55860-169-4
Contents BibTeX

[3]

Jay Banerjee, Hong-Tai Chou, Jorge F. Garza, Won Kim, Darrell Woelk, Nat Ballou, Hyoung-Joo Kim: Data Model Issues for Object-Oriented Applications. ACM Trans. Inf. Syst. 5(1): 3-26(1987) BibTeX

[4]

Peter Buneman, Susan B. Davidson, Kyle Hart, G. Christian Overton, Limsoon Wong: A Data Transformation System for Biological Data Sources. VLDB 1995: 158-169 BibTeX

[5]

...

[6]

...

[7]

...

[8]

I-Min A. Chen, Victor M. Markowitz: Modeling Scientific Experiments with an Object Data Model. ICDE 1995: 391-400 BibTeX

[9]

I-Min A. Chen, Victor M. Markowitz: An Overview of the Object-Protocol Model (OPM) and OPM Data Management Tools. Inf. Syst. 20(5): 393-418(1995) BibTeX

[10]

...

[11]

Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX

[12]

...

[13]

Kathi Hogshead Davis, Adarsh K. Arora: Converting A Relational Database Model into an Entity-Relationship Model. ER 1987: 271-285 BibTeX

[14]

Nathan Goodman: An Object-Oriented DBMS War Story: Developing a Genome Mapping Database in C++. Modern Database Systems 1995: 216-237 BibTeX

[15]

Michael Hammer, Dennis McLeod: Database Description with SDM: A Semantic Database Model. ACM Trans. Database Syst. 6(3): 351-386(1981) BibTeX

[16]

Richard Hull, Roger King: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Comput. Surv. 19(3): 201-260(1987) BibTeX

[17]

Paul Johannesson: A Method for Transforming Relational Schemas Into Conceptual Schemas. ICDE 1994: 190-201 BibTeX

[18]

David Maier: The Theory of Relational Databases. Computer Science Press 1983, ISBN 0-914894-42-0
Contents BibTeX

[19]

Victor M. Markowitz, Johann A. Makowsky: Identifying Extended Entity-Relationship Object Structures in Relational Schemas. IEEE Trans. Software Eng. 16(8): 777-790(1990) BibTeX

[20]

...

[21]

...

[22]

William J. Premerlani, Michael R. Blaha: An Approach for Reverse Engineering of Relational Databases. Commun. ACM 37(5): 42-49, 134(1994) BibTeX

[23]

Elke A. Rundensteiner: Multiview: A Methodology for Supporting Multiple Views in Object-Oriented Databases. VLDB 1992: 187-198 BibTeX

[24]

...

Referenced by

1. Zoé Lacroix: Object Views through Search Views of Web Datasources. ER 1999: 176-187
2. Anthony Kosky, I-Min A. Chen, Victor M. Markowitz, Ernest Szeto: Exploring Heterogeneous Biological Databases: Tools and Applications. EDBT 1998: 499-513
3. I-Min A. Chen, Anthony Kosky, Victor M. Markowitz, Ernest Szeto: Developing and Accessing Scientific Databases with the Object-Protocol (OPM) Data Management Tools. SSDBM 1997: 114-115
4. Zoé Lacroix, Claude Delobel, Philippe Brèche: Object Views and Database Restructuring. DBPL 1997: 180-201