Forms approach to requirements specification for database design

ABSTRACT

One of the most difficult tasks in database design is the collection of relevant information needed for database design. This information can be separated into two categories: information about the processes which use, modify or produce the data, and information about the data which is used, modified, or produced by the processes. This paper describes a "forms" oriented requirements specification facility as a formal means for capturing the information crucial for database design. Both kinds of information are expressible by the proposed structured forms specification. Furthermore, not only the application usage, but also the integrity constraints that must be maintained in the database can be captured in a concise, unambiguous and machine manipulable manner. The concepts underlying the forms approach are few and simple, hence it is easy to use for the database designer and can be understood by non-computer specialists. This facilitates the cooperation from users to participate in the specification of database application requirements.

REFERENCES

• 1: M. M. Astrahan , M. W. Blasgen , D. D. Chamberlin , K. P. Eswaran , J. N. Gray , P. P. Griffiths , W. F. King , R. A. Lorie , P. R. McJones , J. W. Mehl , G. R. Putzolu , I. L. Traiger , B. W. Wade , V. Watson, System R: relational approach to database management, ACM Transactions on Database Systems (TODS), v.1 n.2, p.97-137, June 1976 [doi>10.1145/320455.320457]
• 2: {Blasgen79} Blasgen, M.W., et al., "System R: An Architectural Update, IBM Research Report, RJ2581, July 1979.
• 3: {Chamberlin76} Chamberlin, D.D., et al., "SEQUEL2: A Unified Approach to Data Definition, Manipulation, and Control," IBM Journal of Research and Development, Vol. 20, No. 6, November 1976.
• 4: {DBTG71} CODASYL Data Base Task Group April 1971 Report, ACM, New York.
• 5: {ERA CONF 79} Proceedings of the International Conference on Entity-Relationship Approach to Systems Analysis and Design, Los Angeles, California, (Edited by P. Chen), December 10--12, 1979.
• 6: {Hebalkar79} Hebalkar, P.G. and S.M. Zilles., "Graphical Representation and Analysis of Information System Design," IBM Research Report, RJ2465, January 1979.
• 7: {IMS79} IMS/VS Version 1 General Reference Manual, IBM Reference Manual Number GH20-1260-8, Ninth Edition (April 1979).
• 8: {Lefkovits79} Lefkovits, H.C., et al., "A Status Report on the Activities of the CODASYL End User Facilities Committee (EUFC)," (Issued August 1979), SIGMOD Record Volume 10, Nos. 2 and 3, February 1979.
• 9: {Lum79} Lum, V.Y., et al., "1978 New Orieans Data Base Design Workshop Report," Proceedings of the Fifth International Conference on Very Large Data Bases, Brazil, October 1979.
• 10: {Lum79A} Lum, V.Y., et al., "1978 New Orleans Data Base Design Workshop Report," IBM Research Report, RJ2554, July 1979.
• 11: {NYU SYM78} Proceedings of NYU Symposium on Database Design, May 18--19, 1978.
• 12: {QBE78} "Query-by-Example Terminal User's Guide," IBM Installed User Program, Program Number 5796-PKT, Publication Number SH20-2078-0.
• 13: Nan C. Shu , Barron C. Housel , Vincent Y. Lum, CONVERT: a high level translation definition language for data conversion, Communications of the ACM, v.18 n.10, p.557-567, Oct. 1975 [doi>10.1145/361020.361023]
• 14: {Shu82} Shu, N.C., et al., "Specification of Forms Processing and Business Procedures for Office Automation," IEEE Transactions on Software Engineering, Vol. SE-8, No. 5, September 1982.
• 15: {Teichroew71} Teichroew, D. and H. Sayani, "Automation of System Bullding," Datamation, pp. 25--30, August 1971.
• 16: {Teichroew77} Teichroew, D. and E.A. Hershey, III, "PSL/PSA: A Computer Aided Technique for Structured Documentation and Analysis of Information Processing Systems," IEEE Transactions on Software Engineering, Vol. SE-3, No. 1, January 1977.
• 17: {Wong & Shu80} Wong, H.K.T. and N.C. Shu. "Relational Database Scheme Design," IBM Research Report, RJ2688.