Data base administration: classical pattern, some experiences and trends

ABSTRACT

This three part paper covers the growth and classical patterns of data base administration along with a survey of some currently practicing data base administrators. As a result, some trends and evolutions of the data base administrator position are presented.

After a brief historical introduction, the paper first sets forth basic definitions and organizational considerations for the DBA function. Interfaces, both internal and external are defined and the associated problems are discussed. The functions and responsibilities of the DBA are presented along with the tools available for carrying them out as recommended by various committees including CODASYL, GUIDE/SHARE and other reports.

Then, a survey of organizations utilizing data base administrators is presented. The survey looks at organizations of varying sizes and commitments to data base technology. The results of the survey try to show how the previous recommendations are reflected in reality. An attempt to rationalize the plans and the actual status of the DBA in an organization is carried out.

Finally, from the survey results and from projections provided by the data base administrators themselves, some trends in the evolution of their functions are outlined. In light of these projections an attempt is made to review some of the recommendations currently put forward.

REFERENCES

• 1: ANSI/X3/SPARC, "Study Group on Data Base Management Systems", Interim Report 75-02-08, FDT---Bulletin of ACM-SIGMOD, Vol. 7, No. 2, February 1975.
• 2: Auerbach, "Data Base Administrator", Part 1, Doc No. 3-06-04, Auerbach Publishing Company, Philadelphia, 1975.
• 3: Cagan, C., Data Management Systems, J. Wiley, Inc., New York, 1973.
• 4: Canning, Richard G., "The Data Base Administrator's Function", EDP Analyzer Vol. 10, No. 11, November 1972.
• 5: Canning, Richard G., "The Cautious Path to Data Base", EDP Analyzer Vol. 11, No. 6, June 1973.
• 6: CODASYL Programming Committee, "Data Base Task Group Report", ACM, New York, April 1971.
• 7: CORPORATE Codasyl Systems Committee, Introduction to “feature analysis of generalized data base management systems”, Communications of the ACM, v.14 n.5, p.308-318, May 1971 [doi>10.1145/362588.362590]
• 8: Paul G. Comba, Needed: distributed control, Proceedings of the 1st International Conference on Very Large Data Bases, September 22-24, 1975, Framingham, Massachusetts [doi>10.1145/1282480.1282508]
• 9: C.J. J. Date, An Introduction to Database Systems, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1981
• 10: De Blasis, J. P. and T. H. Johnson, "Data Base Administrators: Review of Current Recommendations vs. Current Practice", Decision Sciences Department Working Paper 76-03-03, The Wharton School, University of Pennsylvania, Philadelphia, 1976.
• 11: Diebold Research Program, "Organizing for Data Base Management", The Diebold Group Inc., Doc. S16, New York, December 1974.
• 12: Guide-Share Data Base Requirements Group, "Data Base Management System Requirements", Share Inc., New York, November 1970.
• 13: Guide-Share, "The Data Base Administrator", Data Base Administration Project, IBM DB/DC Systems Center, Palo Alto CA, November 1972.
• 14: Johnson, T. H. and J. P. De Blasis, "Data Base Administrators: A Report From Survey", Decision Sciences Working Paper 76-04-04, The Wharton School, University of Pennsylvania, Philadelphia, 1976.
• 15: Johnson, Thomas and J. P. De Blasis, "Very Large Data Base Administration: Organizational Implications From a Survey", Decision Sciences Working Paper 76-04-06, The Wharton School, University of Pennsylvania, Philadelphia, 1976.
• 16: Katzan, Harry, Computer Data Management and Data Base Technology, Van Nostrand, New York, 1975.
• 17: Lyon, John K., "The Role of the Data Base Administration", Data Base Vol. 3, No. 4, ACM-SIGMOD, New York, Winter 1971.
• 18: James Martin, Computer Database Organization, 2nd Ed, Prentice Hall PTR, Upper Saddle River, NJ, 1977
• 19: Morgan, Howard L., "Report on The Very Large Data Base Conference", Communications of the ACM, New York, November 1975.
• 20: Richard L. Nolan, Managing the Data Resource Function, West Publishing Co., St. Paul, MN, 1982
• 21: Donald H. Sanders, Computers and Management in a Changing Society, McGraw-Hill, Inc., New York, NY, 1974
• 22: Sanfield, Stuart H., "Data Base Administration: One Approach", Internal Report, Wyeth Laboratories, Philadelphia, 1976.
• 23: Secrest, Richard, "The Data Base Administrator", in The Information System Handbook by F. W. McFarland and R. L. Nolan (Ed.), Dow Jones, Irwin, Homewood IL, 1975.
• 24: Jay-Louise Weldon, Data Base Administration, Perseus Books, Cambridge, MA, 1981