Session B: Information Systems and Data Warehouse
Martin Malík, Tomá Kamrád: Information systems Conception of University of Ostrava

8. The Integration of the existing IS

In the course of setting individual systems we managed to integrate database environment into the Oracle platform and SQL platform. In those systems where it wasn‘t possible the automated transition bridges have been created. There was a necessity to create an integrated code book of persons (personnel classification) with a unique ID number in the frame of the University, respectively to have a possibility of maintaining the code book in an up-to-date status automatically via individual systems. Two accounting subsystems are related, namely the specification of access rights of a particular person and user account parameters on the UO‘s servers. The access rights are defined in the user account database on the Oracle, information on accounts et al. will be deposited in the NDS and accessible via LDAP service. In practice it will look as following.

From a student‘s point of view: At a moment of his/her enrolment in studies there is automatically performed a record of his/her identification data into the integrated code book of persons (personnel classification) from IS Student, the following record is performed into a subsystem of user account parameters, where these parameters are set regarding a specialization the student has enrolled in. In addition, after collecting the ID card an allocation of the card and a record into the access rights subsystem is performed. In case of termination of studies a prompt for record cancellation is set automatically for the records of this nature.

From an employee‘s point of view: At a moment of registering the employee into the Personnel IS the system activity is analogical, access rights et al. are configured according to an executive and working position.

The WWW account administration client operates over the above mentioned subsystems. Through PHP it approaches information deposited in charts of access rights and account parameters, ensures topicality of configuration of individual user account parameters and generating alias files for the electronic mail.

Thereby the simplification of access rights administration in the frame of the UO will occur and last but not least the access to services provided in the frame of the University network for users themselves will be simplified. The idea of building the whole system is such that each employee or a student will be allocated with only one user name and password for the access to all services he/she is entitled to use regarding the working position (specialization).

Currently there is ongoing work on development and launching of an integrated WWW system that would present data provided by individual IS in an integrated way.



© This publication and its compilation in form and content is copyrighted. Every realization which is not explicitly allowed by copyright law requires a written agreement. Especially, this holds for reprography and processing / storing by electronic systems.

EUNIS Proceeding DTD Version 1.0
HTML - Version create: Fri Mar 23 15:30:43 2001