The 78 CODASYL database model: a comparison with preceding specifications

  • Authors:
  • Mary E. S. Loomis

  • Affiliations:
  • The University of Arizona, Tucson, Arizona

  • Venue:
  • SIGMOD '80 Proceedings of the 1980 ACM SIGMOD international conference on Management of data
  • Year:
  • 1980

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper compares the database model specified by the CODAYSL Data Definition Language Committee in its 1978 Journal of Development and the prior model, known familiarly as the CODASYL DBTG model, as specified in 1973 and 1971. The primary achievement of the 78 model appears to be increased potential for data independence by separation of external model and internal model considerations. The external model is described by a DDL; the internal model is described by a DSDL. Additionally, there is enhanced potential for data integrity via more explicit expression of data integrity constraints in the DDL. Conversion of a database from 73 model CODASYL DBMS support to 78 model support is discussed with emphasis on DSDL capabilities. The range of options in the DSDL open to the database designer for specifications of internal storage structures is surveyed. Several conclusions are drawn regarding implementation of support for the 78 model.