Popis předmětu - AE4B33DS

Přehled studia | Přehled oborů | Všechny skupiny předmětů | Všechny předměty | Seznam rolí | Vysvětlivky               Návod
AE4B33DS Database Systems
Role:  Rozsah výuky:2P+2C
Katedra:13136 Jazyk výuky:EN
Garanti:  Zakončení:Z,ZK
Přednášející:  Kreditů:6
Cvičící:  Semestr:L

Anotace:

Database Systems, Web Applications

Výsledek studentské ankety předmětu je zde: AE4B33DS

Cíle studia:

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.

Osnovy přednášek:

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)

Osnovy cvičení:

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

Literatura:

1. Kroha, P.: Objects and Databases. McGraw-Hill Book Company, London, 1993

Požadavky:

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.

Poznámka:

Rozsah výuky v kombinované formě studia: 14p+6c

Klíčová slova:

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

Předmět je zahrnut do těchto studijních plánů:

Plán Obor Role Dop. semestr


Stránka vytvořena 29.3.2024 14:50:58, semestry: L/2023-4, Z/2024-5, Z/2023-4, připomínky k informační náplni zasílejte správci studijních plánů Návrh a realizace: I. Halaška (K336), J. Novák (K336)