Database Systems

The course is a substitute for:

Managerial Information Systems (X33MIS)

Lecturer:

Zdeněk Kouba (gar.), Kamil Matoušek

Tutor:

Zdeněk Kouba (gar.), Kamil Matoušek, Martin Řimnáč, Marek Šmíd

Supervisor:

Department of Cybernetics

Synopsis:

Database Systems and their architecture, query languages, transactions, object-relational mapping

Requirements:

The web page of the course is http://cw.felk.cvut.cz/doku.

php/courses/a4b33ds/start^

^

The requirements for successful completion of the course

are published on that page.

Syllabus of lectures:

1.Basic information system architectures (client-server, multi-tier, thin client), analysis of information flows, UML use-case diagrams

2.Basic data modeling, E-R diagrams, relational model, database access API, JDBC

3.Integrity constraints, referential integrity, normal forms

4.Querying in relational databases, SQL basics, referential integrity in SQL

5.Advanced queries, aggregation functions, nested queries

6.Cursor, view, stored procedures, triggers

7.Transactions, their serializability, locking, isolation levels, transaction deadlock, its prevention and resolution

8.UML class diagrams, sequence diagrams

9.Object-relational mapping, object persistence and access API (JPA)

10.Design of multithreaded applications and guidelines for their implementation, UML activity diagrams

11.Basic design patterns

12.Overview of component architectures (CORBA, COM, EJB) and communication protocols (RPC, RMI, IIORB, JMS, http, web services)

13.Design of a distributed system with component architecture, web-based interface

14.Enterprise applications and major design problems (load balancing, data replication)

Syllabus of tutorials:

1.Organization of labs, safety rules, making up working groups

2.Basics of relational modeling

3.Conceptual model creation

4.Application interface of a database, connection methods

5.Logical data model creation

6.Interactive query composition

7.Practical examples of transactional processing significance

8.Realization of selected data model in the relational database environment

9.Object-relational mapping

10.Autonomous work

11.Autonomous work

12.Autonomous work

13.Submission and presentation of the working group results

14.Submission and presentation of the working group results, credits

Study Objective:

The course is aimed at providing students with the basic

course of database system design. After the completion of

the course, the student is able to create conceptual and

logical models, he is able to actively use SQl query

language. Further on, he is able to design database

applications in Java using JDBC and JPA APIs.

Study materials:

[1] Pokorný, J., Halaška, I.: Databázové systémy. Praha, ČVUT, 1998

[2] Beneš, J.: Manažerské informační systémy. Automatizace, 2000

[3] Mařík, V. a kol.: Umělá inteligence IV. Praha, Academia, 2001

[4] Kroha, P.: Objects and Databases. McGraw-Hill Book Company, London, 1993

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue	roomKN:E-107 Kouba Z. Matoušek K. 09:15–10:45 (lecture parallel1) Karlovo nám. Zengerova posluchárna K1
Fri	roomKN:E-220 Řimnáč M. 12:45–14:15 (lecture parallel1 parallel nr.102) Karlovo nám. Laboratoř BIOroomKN:E-220 Řimnáč M. 14:30–16:00 (lecture parallel1 parallel nr.103) Karlovo nám. Laboratoř BIOroomKN:E-220 Řimnáč M. 16:15–17:45 (lecture parallel1 parallel nr.101) Karlovo nám. Laboratoř BIO
Thu
Fri	roomKN:E-220 Šmíd M. 07:30–09:00 (lecture parallel1 parallel nr.104) Karlovo nám. Laboratoř BIO

The course is a part of the following study plans:

• Otevřená informatika - Informatika a počítačové vědy (compulsory course of the specialization)
• Otevřená informatika - Softwarové systémy (compulsory course of the specialization)