Database Systems 1

Course guarantor:

Lecturer:

Tutor:

Supervisor:

Department of Computer Science

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. Data modeling basics, E-R diagrams, relational model

2. Data model creation process

3. Querying in relational databases, SQL basics

4. Advanced queries, aggregation functions, nested queries

6. Itegrity constraints, referential integrity, normal forms

7. Transactions, their serializability, locking, isolation levels, transaction deadlock

8. Indices, efficient implementation of tree/like structures in relational databases

9. Object-relational mapping, JPA 2.0

10. Advanced techniques of JPA 2.0

11. Geographic information, spatial inexing techniques

12. Data warehouses

13. Recovery from errors, data replication, high availability, load balancing

14. Modern trends of database systems

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., Valenta M.: Databázové systémy, Nakladatelství ČVUT, Praha, 2013, ISBN 978-80-01-05212-9

2. Rob P., Coronel C.: Database Systems: Design, Implementation & Management, Thomson Course Technology,2004

3. Lake R., Burgraff D., Trninic M., Rae L.: Geography Mark-Up Language: Foundation for the Geo-Web, Willey, 2004

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: