Automating Logical File Design.

George U. Hubbard, Norman Raver: Automating Logical File Design. VLDB 1975: 227-253
  author    = {George U. Hubbard and
               Norman Raver},
  editor    = {Douglas S. Kerr},
  title     = {Automating Logical File Design},
  booktitle = {Proceedings of the International Conference on Very Large Data
               Bases, September 22-24, 1975, Framingham, Massachusetts, USA},
  publisher = {ACM},
  year      = {1975},
  pages     = {227-253},
  ee        = {db/conf/vldb/HubbardR75.html},
  crossref  = {DBLP:conf/vldb/75},
  bibsource = {DBLP,}


Data base design is currently a costly and time consuming activity. Part of this overall design is concerned with the logic of the underlying network structure, and this part is commonly called logical design. Logical design involves a tedium of calculations which can be automated on a program and used as a design tool. The basic approach is applicable to a wide variety of data base handlers, such as IMS, the DBTC proposal, CIS, and others. The approach has been prototyped and a version suitable for IMS is now being used (DBDA) as a program product.

This paper describes the basic concepts and how they can be applied to IMS, DBTG or relational implementations. The data structuree needed to support a particular application program is called the local view, aud input to the design tool is the collection of all local views. Local views are constructed using certain primitives which the integration ot the local views.

The diagnostics of the design tool program will partially depend on the data base handler. Each handler, (IMS, DBTG, etc.) has different network restrictions which limit the local views which can be generated from the network. Different network restrictions result in different diagnostics. There is no relational data base handler to evaluate for network restrictions.

Copyright © 1975 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

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

Douglas S. Kerr (Ed.): Proceedings of the International Conference on Very Large Data Bases, September 22-24, 1975, Framingham, Massachusetts, USA. ACM 1975
Contents BibTeX



Referenced by

  1. Vincent Y. Lum, Sakti P. Ghosh, Mario Schkolnick, Robert W. Taylor, D. Jefferson, Stanley Y. W. Su, James P. Fry, Toby J. Teorey, B. Yao, D. S. Rund, B. Kahn, Shamkant B. Navathe, D. Smith, L. Aguilar, W. J. Barr, P. E. Jones: 1978 New Orleans Data Base Design Workshop Report. VLDB 1979: 328-339
  2. Keki B. Irani, Subir Purkayastha, Toby J. Teorey: A Designer for DBMS-Processable Logical Database Structures. VLDB 1979: 219-231
  3. Barron C. Housel, Vance E. Waddle, S. Bing Yao: The Functional Dependency Model for Logical Database Design. VLDB 1979: 194-208
  4. Stanley Y. W. Su, Der Her Lo: A Semantic Association Model for Conceptual Design. ER 1979: 169-192
  5. Benn R. Konsynski, Michael V. Mannino: Information Resource Specification and Design Language. ER 1979: 339-352
  6. Elias Berelian, Keki B. Irani: Evaluation and Optimization. VLDB 1977: 545-555
  7. Janis A. Bubenko Jr.: IAM: An Inferential Abstract Modeling Approach to Design of Conceptual Schema. SIGMOD Conference 1977: 62-74
  8. Beverly K. Kahn: A Method for Describing Information Required by the Database Design Process. SIGMOD Conference 1976: 53-64
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sat May 16 23:44:52 2009