Computer aided design of database internal schema

A large number of complexly interrelated parameters are involved at the internal schema level design of database systems. Consequently, a single design model is seen to be infeasible. A package of three aids is proposed to assist a designer in step by step design of internal schema. The three aids pertain to splitting of a relation, merging of relations, and access strategy selection for a relation.

[1]  B. Langefors,et al.  Some approaches to the theory of information systems , 1963 .

[2]  George U. Hubbard,et al.  Automated Logical Data Base Design: Concepts and Applications , 1977, IBM Syst. J..

[3]  S. J. Waters,et al.  CAM 01: A Precedence Analyser , 1976, Comput. J..

[4]  Jay F. Nunamaker,et al.  Computer-aided analysis and design of information systems , 1976, CACM.

[5]  Irving L. Traiger,et al.  System R: relational approach to database management , 1976, TODS.

[6]  Keki B. Irani,et al.  Automatic data base schema design and optimization , 1975, VLDB '75.

[7]  Vincent Y. Lum,et al.  A file organization evaluation model (FOREM) , 1968, IFIP Congress.

[8]  Charles H. Kriebel,et al.  Toward an Optimal Design of a Network Database from Relational Descriptions , 1978, Oper. Res..

[9]  Dennis G. Severance,et al.  The determination of efficient record segmentations and blocking factors for shared data files , 1977, TODS.

[10]  Steven L. Alter.  A model for automating file and program design in business application systems , 1979, CACM.

[11]  Toby J. Teorey,et al.  Analysis of storage structure performance for multiple data processing activities , 1976, ACM '76.

[12]  C. P. Wang,et al.  Segment Synthesis in Logical Data Base Design , 1975, IBM J. Res. Dev..

[13]  Bo Sundgren,et al.  Information systems architecture , 1975 .

[14]  Jay F. Nunamaker.  A methodology for the design and optimization of information processing systems , 1899 .

[15]  Dennis G. Severance,et al.  A Practical Approach to Selecting Record Access Paths , 1977, CSUR.

[16]  Gio Wiederhold,et al.  Database Design , 1977 .