Administration and Autonomy in a Replication-Transparent Distributed DBMS.

Kenneth R. Abbott, Dennis R. McCarthy: Administration and Autonomy in a Replication-Transparent Distributed DBMS. VLDB 1988: 195-205

@inproceedings{DBLP:conf/vldb/AbbottM88,
  author    = {Kenneth R. Abbott and
               Dennis R. McCarthy},
  editor    = {Fran\c{c}ois Bancilhon and
               David J. DeWitt},
  title     = {Administration and Autonomy in a Replication-Transparent Distributed
               DBMS},
  booktitle = {Fourteenth International Conference on Very Large Data Bases,
               August 29 - September 1, 1988, Los Angeles, California, USA,
               Proceedings},
  publisher = {Morgan Kaufmann},
  year      = {1988},
  isbn      = {0-934613-75-3},
  pages     = {195-205},
  ee        = {db/conf/vldb/AbbottM88.html},
  crossref  = {DBLP:conf/vldb/88},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Administrative issues are of vital importance to organizations adopting distributed database technology. Most research systems and emerging commercial DDBMSs have assumed site autonomy as a guiding principle. This paper presents some general problems associated with autonomy and administration in a DDBMS, and discusses the incompatibility between replication transparency and site autonomy. In a DDBMS which supports replication transparency, the degree of site autonomy in a system should properly be a policy decision made by system administrators. Parameterization of the degree of site autonomy in a DDBMS involves careful design of a mechanism involving storage structures, operations, and authorization. A mechanism which extends the ANSI SQL authorization model is described, and examples of how users can use the mechanism to implement both centralized and decentralized administration policies are presented.

Copyright © 1988 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

Download PDF file (www.vldb.org, Darmstadt, Germany)
Download PDF file (www.acm.org, New York, USA)

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ...

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/vldb7588 or /cdrom

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

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

Printed Edition

François Bancilhon, David J. DeWitt (Eds.): Fourteenth International Conference on Very Large Data Bases, August 29 - September 1, 1988, Los Angeles, California, USA, Proceedings. Morgan Kaufmann 1988, ISBN 0-934613-75-3

References

[1]: ...
[2]: Henry MacKay Walker: Administering a Distributed Data Base Management System. SIGMOD Record 12(3): 86-99(1982)
[3]: Stefano Ceri, Giuseppe Pelagatti: Distributed Databases: Principles and Systems. McGraw-Hill Book Company 1984, ISBN 0-07-010829-3
[4]: ...
[5]: Arvola Chan, Umeshwar Dayal, Stephen Fox, Nathan Goodman, Daniel R. Ries, Dale Skeen: Overview of an Ada Compatible Distributed Database Manager. SIGMOD Conference 1983: 228-237
[6]: Bruce G. Lindsay: A Retrospective of R*: A Distributed Database Management System. Proceedings of the IEEE 75(5): 668-673(1987)
[7]: Olin Bray: IRM in a Decentralized/Distributed Environment. IEEE Database Eng. Bull. 9(2): 66-77(1986)
[8]: ...
[9]: ...
[10]: ...
[11]: Patricia P. Griffiths, Bradford W. Wade: An Authorization Mechanism for a Relational Database System. ACM Trans. Database Syst. 1(3): 242-255(1976)
[12]: ...
[13]: ...
[14]: Dean Daniels, Patricia G. Selinger, Laura M. Haas, Bruce G. Lindsay, C. Mohan, Adrian Walker, Paul F. Wilms: An Introduction to Distributed Query Compilation in R*. DDB 1982: 291-309
[15]: Elisa Bertino, Laura M. Haas, Bruce G. Lindsay: View Management in Distributed Data Base Systems. VLDB 1983: 376-378
[16]: Paul F. Wilms, Bruce G. Lindsay: A Database Authorization Mechanism Supporting Individual and Group Authorization. DDSS 1981: 273-292
[17]: Arvola Chan, Robert Gray: Implementing Distributed Read-Only Transactions. IEEE Trans. Software Eng. 11(2): 205-212(1985)