COMETT DATABASE ADMINISTRATION

COMETT Database Administration Problems, Concepts, Issues COMETT is a collaborative programme organized by the Commission of the European Community. It is concerned with further education in technology through cooperative ventures between industry and universities. The goal of the programme is to produce highly qualified personnel in order to improve the competitiveness of European industry. The further education series "Database Administration" forms part of the COMETT-Project EXDACO of the UETP-Ruhr. The leading organizer of the seminars is the Laboratory for Databases, which is integrated in the Department of Practical Computer Science I of the University of Hagen (FernUniversitaet). Coordinator of the English session is the Rutherford Appleton Laboratory. The lecturers of the seminars come from consultancies, the University and the application area. Content and Goals: The Database Management System (DBMS) - as the central kernel of complex application systems - determines the efficiency of the whole system. The management of this critical part of the system has to be done by the database administrator (DBA). The database administrator is faced with the following tasks: -application oriented data modelling -security of data -access control -system performance -archiving of data -integration of old data and systems In the past, sets of data grew in isolation from each other. An integrated view of all data of an enterprise was often missing. The introduction of database technonolgy in some areas has led to data from different disciplines being integrated. For example data relating to 'orders' may be held in an 'orders database', while the data relating to the 'manufacturing process' may be held in a different database. The two databases contain common information and so to make full use of the data, connections between the two must be set up and maintained. These problems lead to the requirement of an organisation-wide data model and an experienced database system support team. Frequently, the task of a database administrator has been taken over by an application programmer who in course of time became a specialist for his/her specific database management system. But the scenario described above requires the administartor to perform tasks which are beyond the management of a single database management system: -The involvement of the DBA in the data modelling process requires knowledge about Structured Analysis (SA) and the Entity Relationship Approach (ER). -Dealing with different database categories, e.g. to migrate from the world of hierarchical data (e.g. IMS) to relational database management systems (e.g. DB2). -Assessment of modern database concepts, e.g. object-oriented databases -Use of CASE-tools during design and operation of databases -Observing of standards, e.g. the ISO/IEC SQL standard -Comparison of different database management systems and tools for developing applications (e.g. 4GL-tools) -Assessment of distributed database systems. The seminars focus on imparting knowledge on database management in a broad and vendor independent fashion. Participation will be certified by the University of Hagen. Seminars, Dates and Lecturers 2/9/93-3/9/93 Relational Databases: State of the Art and Perspectives of Future Developments Dr. Wolfgang Wilkes (University of Hagen [FernUniversitaet]) Stefan Schilling (icons GmbH) 4/10/93-5/10/93 Object-Oriented Database Systems: A Rational Investigation Prof. Dr. Gunter Schlageter (University of Hagen [FernUniversitaet]) Juergen Feldkamp (University of Hagen [FernUniversitaet]) 20/10/93-22/10/93 Database Security: Technical and Legal Aspects Thomas Berkel (University of Hagen [FernUniversitaet]) Josef Lang (debis AG) Britta Cramer (Institut fuer Informationstechnologie und Bildung GmbH) 4/11/93-5/11/93 How to Use CASE for Data Base Design: Methods and Tools Dieter Pfleiderer (Hessische Zentrale fuer Datenverarbeitung) 8/11/93-9/11/93 Organisation of the Reengineering Processes Klaus Hoffmeister (Deutsche Lufhansa AG) 15/11/93-16/11/93 Distributed Database Systems: Concepts and Implementation Aspects Prof. Dr. Peter Dadam (University of Ulm) 17/11/93-18/11/93 Database and Presentation Layers Friedrich Tontsch (upto GmbH) 25/11/93-26/11/93 Corporate - Wide Data Management: Objectives and Tasks from the View of the Practitioner Dr. Andreas Meier (CSS Versicherung) 6/12/93-9/12/93 Database Design: From Structured Analysis to 4GL-Applications? Dr. Wolfgang Wilkes (University of Hagen [FernUniversitaet]) Stefan Schilling (icons GmbH) Norbert Schulte-Bausenhagen (icons GmbH) Konrad Reichenbaecher (Deutsche Lufthansa AG) 13/12/-14/12/93 From Mainframes to UNIX-Networks Dieter Wendel (Deutsche Lufthansa AG) Seminar I: 2/9/93-3/9/93 Relational Databases: State of the Art and Perspectives of Future Developments Objective: Relational database systems have become increasing popular and are in process of replacing the former paradigms of hierarchical and network-oriented databases. After its introduction into the market some 8 or 10 years ago, various products, e.g. DB2, ORACLE, INGRES and SYBASE have converged with respect to the features which they provide. This has been supported by strong standardization activities. The goal of the two day seminar is to give an overview on the current state-of-the-art relational database technology. In particular, new concepts in the areas of integrity control and programming of the database kernel will be introduced and compared with each other (e.g. stored procedures, triggers, constraints). In addition to the overview of available systems the participant will get a view of future development trends. Contents: Tasks and basic concepts of database systems -Comparison of the relational, the hierarchical, and the network-oriented data models -Illustration of the different models by means of a example -Trends in development (object-orientation, distribution, etc.) Overview of the market -Criteria and aspects for a comparison -Evaluation of various systems with respect to these criteria and aspects Impacts of new concepts to the tasks of the database administrator -Description of referential integrity -Possibilities to program the database kernel -Definition of access control systems - Distribution Lecturers: Stephan Schilling is managing director of icons@@