Summary of Study |
Summary of Branches |
All Subject Groups |
All Subjects |
List of Roles |
Explanatory Notes
Instructions
B4B36DS1 |
Database Systems 1 |
Roles: | |
Extent of teaching: | 2P+2C |
Department: | 13136 |
Language of teaching: | CS |
Guarantors: | |
Completion: | Z,ZK |
Lecturers: | |
Credits: | 6 |
Tutors: | |
Semester: | L |
Anotation:
Database Systems and their architecture, query languages, transactions, object-relational mapping
Study targets:
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.
Course outlines:
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 |
Exercises outline:
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 |
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.
Keywords:
Conceptual and logical data model, transactions, transaction isolation levels, normal forms, query language, SQL, JPA, high availability, geographical information systems, GIS, data warehouses
Subject is included into these academic programs:
Program |
Branch |
Role |
Recommended semester |
Page updated 29.3.2024 14:51:28, semester: Z/2024-5, Z,L/2023-4, Send comments about the content to the Administrators of the Academic Programs |
Proposal and Realization: I. Halaška (K336), J. Novák (K336) |