Database Systems 1

Semestr: Summer

Range: 2p+2c

Completion:

Credits: 6

Programme type: Bachelor

Study form: Fulltime

Course language: Czech

Summary:

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

Keywords:

Conceptual and logical data model, transactions, transaction isolation levels, normal forms, query language, SQL, JPA, high availability, geographical information systems, GIS, data warehouses

Course syllabus:

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

Seminar syllabus:

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

Literature:

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

Examiners:

Lecturers:

Instructors: