Abstract
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.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
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.
The Alvey Committee, A Programme for Advanced Information Technology, HMSO, London, 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.
J M Chapman & H M Robinson, A Database Administration Support Environment, in G M Bull (ed), Real Time Programming 1983, Pergamon, Oxford, 1983.
CODASYL Data Base Task Group, Report, Association for Computing Machinery, April 1971.
CODASYL Data Description Language Committee, Journal of Development 1981, Secretariat of the Canadian Government EDP Standards Committee, 1981.
British Computer Society, Data Dictionary Systems Working Party, Journal of Development, British Computer Society, London, 1982.
Digital Equipment Corporation, Administrator's Procedures Manual Data Base Management System (DBMS-10), 1977.
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.
D R Howe, Data Analysis for Data Base Design, Edward Arnold, London, 1983.
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.
Database language NDL, (draft for development), International Standards Organisation, Document ISO/DIS 8907, 1986.
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.
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.
D W Manhood (ed), Storage Level Control in a CODASYL database: Part II, Computer Bulletin, Series II, Vol.26, 1980.
M A Newton & H M Robinson, Evolving Information Systems: the Database Approach, in L Evans (ed), Designing for Systems Maturity, Pergamon Infotech, Oxford, 1985.
M352 Course Team, Computer-based Information Systems, The Open University, Walton Hall, 1980.
H M Robinson, Database Analysis and Design, Chartwell-Bratt, Bromley, 1981.
J M Smith & D C P Smith, Database Abstractions: Aggregation and Generalisation, ACM TODS, 2, 6, June 1977.
F S Zahran, A universal data model holder for a data dictionary system, Computer Journal, 24, 3August 1981.
F S Zahran, Structured analysis of data dictionary systems and their environments, Proc. Second British National Conference on Databases, University of Bristol, July 1982.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1987 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Robinson, H., Emms, J. (1987). Requirements analysis for a database administration support environment. In: Nichols, H., Simpson, D. (eds) ESEC '87. ESEC 1987. Lecture Notes in Computer Science, vol 289. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0022130
Download citation
DOI: https://doi.org/10.1007/BFb0022130
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-18712-7
Online ISBN: 978-3-540-48117-1
eBook Packages: Springer Book Archive