Requirements analysis for a database administration support environment
This paper identifies and defines the facilities needed to enable database administration to organise and control the construction and operational running of a database system. The data requirements needed to support these facilities, termed control data, are discussed and are defined by means of an entity-attribute-relationship conceptual data model for a control database. This control database forms the core of a database administration support environment (DBASE).
The paper discusses the facilities required from a DBASE for the effective analysis, design, implementation and operational running of a software system making use of a database management system. The need for features such as service and session control, restructuring and reorganisation, and integrity checking is justified. Examples based on the draft international standard for the database language NDL are used to illustrate the expositions in the paper. A comparison is made between a DBASE and both a data dictionary system and an integrated project support environment.
This paper is based on the work of the BCS/CODASYL DDLC Database Administration Working Group.
KeywordsDatabase management system database administrator support environment storage allocation
Unable to display preview. Download preview PDF.
- Alexander, Kerridge, Robinson et al 1984.H H Alexander, J M Kerridge, H M Robinson et al, An Architecture and Language Syntax for Distributed Databases for the Network Model, Proc. Third British National Conference on Databases, Leeds Polytechnic, July 1984, Cambridge University Press, Cambridge, 1984.Google Scholar
- Alvey 1982.The Alvey Committee, A Programme for Advanced Information Technology, HMSO, London, 1982.Google Scholar
- CCA 1982.Computer Corporation of America, An Architecture for Database Management Standards, US Department of Commerce, National Bureau of Standards, NBS Special Publication 500-86, 1982.Google Scholar
- Chapman & Robinson 1983.J M Chapman & H M Robinson, A Database Administration Support Environment, in G M Bull (ed), Real Time Programming 1983, Pergamon, Oxford, 1983.Google Scholar
- DBTG 1971.CODASYL Data Base Task Group, Report, Association for Computing Machinery, April 1971.Google Scholar
- DDLC 1981.CODASYL Data Description Language Committee, Journal of Development 1981, Secretariat of the Canadian Government EDP Standards Committee, 1981.Google Scholar
- DDSWP 1982.British Computer Society, Data Dictionary Systems Working Party, Journal of Development, British Computer Society, London, 1982.Google Scholar
- DEC 1977.Digital Equipment Corporation, Administrator's Procedures Manual Data Base Management System (DBMS-10), 1977.Google Scholar
- Fitzgerald, Kerridge, Robinson et al 1982.G Fitzgerald, J M Kerridge, H M Robinson et al, A Reference Model and Abstract Syntax for Distributed Databases, Proc. Second British National Conference on Databases, University of Bristol, July 1982.Google Scholar
- Howe 1983.D R Howe, Data Analysis for Data Base Design, Edward Arnold, London, 1983.Google Scholar
- ISO 1982.ISO/TC97/SC5/WG3, Concepts and Terminology for the Conceptual Schema and the Information Base, Publication No ISO/TC97/SC5-N695, (ed) J J van Griethuysen, 15 March 1982.Google Scholar
- ISO 1986.Database language NDL, (draft for development), International Standards Organisation, Document ISO/DIS 8907, 1986.Google Scholar
- Kerridge, Chapman, Robinson et al 1985.J M Kerridge, J M Chapman, H M Robinson, et al, An Access Control System for Database Languages, Proc. Fourth British National Conference on Databases, University of Keele, July 1985, Cambridge University Press, Cambridge, 1985.Google Scholar
- MacDonald & Palmer 1982.I G MacDonald & I R Palmer, System Development in a Shared Data Environment, the D2S2 Methodology, in T W Olle, H G Sol & A A Stuart-Verijn (eds), Information Systems Design Methodologies: A Comparative Review, North-Holland, Amsterdam, 1982.Google Scholar
- Manhood 1980.D W Manhood (ed), Storage Level Control in a CODASYL database: Part II, Computer Bulletin, Series II, Vol.26, 1980.Google Scholar
- Newton & Robinson 1985.M A Newton & H M Robinson, Evolving Information Systems: the Database Approach, in L Evans (ed), Designing for Systems Maturity, Pergamon Infotech, Oxford, 1985.Google Scholar
- Open University 1980.M352 Course Team, Computer-based Information Systems, The Open University, Walton Hall, 1980.Google Scholar
- Robinson 1981.H M Robinson, Database Analysis and Design, Chartwell-Bratt, Bromley, 1981.Google Scholar
- Smith & Smith 1977.J M Smith & D C P Smith, Database Abstractions: Aggregation and Generalisation, ACM TODS, 2, 6, June 1977.Google Scholar
- Zahran 1981.F S Zahran, A universal data model holder for a data dictionary system, Computer Journal, 24, 3August 1981.Google Scholar
- Zahran 1982.F S Zahran, Structured analysis of data dictionary systems and their environments, Proc. Second British National Conference on Databases, University of Bristol, July 1982.Google Scholar