ACM SIGMOD Anthology VLDB dblp.uni-trier.de

View Management in Distributed Data Base Systems.

Elisa Bertino, Laura M. Haas, Bruce G. Lindsay: View Management in Distributed Data Base Systems. VLDB 1983: 376-378
@inproceedings{DBLP:conf/vldb/BertinoHL83,
  author    = {Elisa Bertino and
               Laura M. Haas and
               Bruce G. Lindsay},
  editor    = {Mario Schkolnick and
               Costantino Thanos},
  title     = {View Management in Distributed Data Base Systems},
  booktitle = {9th International Conference on Very Large Data Bases, October
               31 - November 2, 1983, Florence, Italy, Proceedings},
  publisher = {Morgan Kaufmann},
  year      = {1983},
  isbn      = {0-934613-15-X},
  pages     = {376-378},
  ee        = {db/conf/vldb/BertinoHL83.html},
  crossref  = {DBLP:conf/vldb/83},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

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 ...

The structure of data to be stored by a Data Base Management System (DBMS) is usually decided by a database administrator. Individual users and applications are generally interested in only a subset of the data stored in the database. Often, they wish to see this subset structured in a way which reflects their particular needs. Since it is not generally possible to structure a database so as to please all of its users, some mechanism is needed whereby each user can view the data according to his (her) own requirements. The representation of the data structure as seen by a user is often referred to as an external schema; the view mechanism is a means by which a DBMS can support various external schemas.

Besides providing users with tailored views of the data the view mechanism contributes to [Chamberlin75]:

In relational DBMS, a view is defined as a "virtual table" derived by a specific query on one or more base tables. The ralational operations join, restrict and project as well as statistical summaries of tables may be used to define a view. Access rights may be granted and revoked on views just as though they were ordinary tables. This allows users to selectively share data, preventing unauthorized users from reading sensitive information.

SQL/DS [SQL81] and INGRES [STonebraker76] are examples of relational DBMS`s that provide the view facility.

In this abstract the implementation of views in distributed relational DBMS`s is discussed. Section 2 briefly reviews view management in a single-site DBMS. In section 3, the view concept is extended to a distributed DBMS (DDBMS) and two types of views are introduced: shorthand views and protecting views. Finally section 4 outlines view management in a DDBMS.

Printed Edition

Mario Schkolnick, Costantino Thanos (Eds.): 9th International Conference on Very Large Data Bases, October 31 - November 2, 1983, Florence, Italy, Proceedings. Morgan Kaufmann 1983, ISBN 0-934613-15-X
Contents CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

References

[Chamberlin75]
...
[Ng82]
...
[Rothnie80]
James B. Rothnie Jr., Philip A. Bernstein, Stephen Fox, Nathan Goodman, Michael Hammer, Terry A. Landers, Christopher L. Reeve, David W. Shipman, Eugene Wong: Introduction to a System for Distributed Databases (SDD-1). ACM Trans. Database Syst. 5(1): 1-17(1980) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[SQL81]
...
[Stonebraker76]
Michael Stonebraker, Eugene Wong, Peter Kreps, Gerald Held: The Design and Implementation of INGRES. ACM Trans. Database Syst. 1(3): 189-222(1976) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Stonebraker77]
Michael Stonebraker, Erich J. Neuhold: A Distributed Database Version of INGRES. Berkeley Workshop 1977: 19-36 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Williams81]
R. Williams, Dean Daniels, Laura M. Haas, George Lapis, Bruce G. Lindsay, Pui Ng, Ron Obermarck, Patricia G. Selinger, Adrian Walker, Paul F. Wilms, Robert A. Yost: R*: An Overview of the Architecture. JCDKB 1982: 1-27 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

Copyright © Fri Mar 12 17:22:46 2010 by Michael Ley (ley@uni-trier.de)