ACM SIGMOD Anthology VLDB dblp.uni-trier.de

Incremental Reorganization of Relational Databases.

Victor M. Markowitz, Johann A. Makowsky: Incremental Reorganization of Relational Databases. VLDB 1987: 127-135
@inproceedings{DBLP:conf/vldb/MarkowitzM87,
  author    = {Victor M. Markowitz and
               Johann A. Makowsky},
  editor    = {Peter M. Stocker and
               William Kent and
               Peter Hammersley},
  title     = {Incremental Reorganization of Relational Databases},
  booktitle = {VLDB'87, Proceedings of 13th International Conference on Very
               Large Data Bases, September 1-4, 1987, Brighton, England},
  publisher = {Morgan Kaufmann},
  year      = {1987},
  isbn      = {0-934613-46-X},
  pages     = {127-135},
  ee        = {db/conf/vldb/MarkowitzM87.html},
  crossref  = {DBLP:conf/vldb/87},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

The evolution of an information system is reflected in data modeling by database reorganization. Entity-Relationship (ER) consistency expresses the capability of relational databases to model information oriented systems. A relational schema consisting of relational schemes, together with key and inclusion dependencies, is said to be ER-consistent if it complies with an entity-relationship structure, meaning that it is representableby an ER-Diagram. For ER- consistent schemas the basic restructuring manipulations are the addition and removal of relation schemes, coupled with the modification of the key and inclusion dependencies. Recently we have defined a set of incremental and reversible schema restructuring manipulations as the translates of a set of vertex-oriented ER-Diagram transformations. For non-empty database states the schema restructuring manipulations must be associated with state mappings, and this leads us to the definition of database reorganization operations; database reorganization operations consist of compatible pairs of incremental restructuring manipulations and entity-bounded state mappings. For the specification of ER-consistent database state mappings, we propose an Entity-Relationship Calculus.

Copyright © 1987 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.


Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Peter M. Stocker, William Kent, Peter Hammersley (Eds.): VLDB'87, Proceedings of 13th International Conference on Very Large Data Bases, September 1-4, 1987, Brighton, England. Morgan Kaufmann 1987, ISBN 0-934613-46-X
Contents BibTeX

References

[AC]
Paolo Atzeni, Peter P. Chen: Completeness of Query Languages for the Entity-Relationship Model. ER 1981: 109-122 BibTeX
[CCE]
Douglas M. Campbell, David W. Embley, Bogdan D. Czejdo: A Relationally Complete Query Language for an Entity-Relationship Model. ER 1985: 90-97 BibTeX
[CH]
Ashok K. Chandra, David Harel: Computable Queries for Relational Data Bases. J. Comput. Syst. Sci. 21(2): 156-178(1980) BibTeX
[CV]
Marco A. Casanova, Vânia Maria Ponte Vidal: Towards a Sound View Integration Methodology. PODS 1983: 36-47 BibTeX
[Chen]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[FV]
Patrick C. Fischer, Dirk Van Gucht: Determining when a Structure is a Nested Relation. VLDB 1985: 171-180 BibTeX
[MMR]
Johann A. Makowsky, Victor M. Markowitz, Nimrod Rotics: Entity-Relationship Consistency for Relational Schemas. ICDT 1986: 306-322 BibTeX
[Mar]
...
[MR]
Victor M. Markowitz, Yoav Raz: An entity-relationship algebra and its semantic description capabilities. Journal of Systems and Software 4(2-3): 147-162(1984) BibTeX
[PS]
Christine Parent, Stefano Spaccapietra: An Algebra for a General Entity-Relation1hip Model. IEEE Trans. Software Eng. 11(7): 634-643(1985) BibTeX
[Pir]
Alain Pirotte: High Level Data Base Query Languages. Logic and Data Bases 1977: 409-436 BibTeX
[Sci]
Edward Sciore: Inclusion Dependencies and the Universal Instance. PODS 1983: 48-57 BibTeX
[ST]
Ben Shneiderman, Glenn Thomas: An Architecture for Automatic Relational Database System Conversion. ACM Trans. Database Syst. 7(2): 235-257(1982) BibTeX
[TL]
...

Referenced by

  1. Altigran Soares da Silva, Alberto H. F. Laender, Marco A. Casanova: An Approach to Maintaining Optimized Relational Representations of Entity-Relationship Schemas. ER 1996: 292-308
  2. Takao Miura: Desktop Schema Evolution - Editing Schema. DASFAA 1991: 61-68
  3. Victor M. Markowitz, Johann A. Makowsky: Incremental Restructuring of Relational Schemas. ICDE 1988: 276-284
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:45:34 2009