Information and Database Systems Design

Lecturer:

Tutor:

Supervisor:

Department of Cybernetics

Synopsis:

The course is focused on methodology of information system design and implementation. The attention is paid to standardized formal software analysis and design methods, the graphical design language UML and some its extensions. Further, the course deals with transaction processing, multi-process and multi-threaded systems and component architecture. The course deals also with legacy systems, i.e. the design of systems, which co-exist and cooperate with existing information systems. Finally, the students will be introduced into problems of data warehousing and geographical information systems.

Requirements:

Presence according general regulations, succesful test.

Syllabus of lectures:

1. Introduction into database systems, data model

2. Relational data model

3. Object-oriented databases

4. Normal forms, query languages

5. SQL language

6. SQL language

7. Computational process, thread, component

8. Object-oriented analysis and design, UML

9. Client-server architecture, multi-tier architecture

10. Component architecture, CORBA, COM+

11. Concurrent database access, transactions

12. Distributed databases, data replication

13. Data warehousing

14. Geographical information systems

Syllabus of tutorials:

1. Seminar organization, safety, establishing working groups

2. Development environment - instruction I

3. Development environment - instruction II

4. Best data model design practice

5. Solving a project in groups - data model design I

6. Interactive queries

7. Best practice of database application design

8. Solving a project in groups - application design

9. Solving a project in groups - application implementation I

10. Solving a project in groups - application implementation II

11. Concurrent data access

12. Data replication system presentation

13. Interactive demonstration of data warehouse

14.

Study Objective:

Study materials:

[1] Pratt, P.J., Adamski, J.J.: Database Systems Management and Design MIT Press, Cambridge 1990

[2] Kroha, P.: Objects and databases. The McGraw-Hill international series in software engineering, McGraw-Hill Book Company, London 1993

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: