Syllabus of lectures:
- Procedural extensions of SQL: PL/SQL, T-SQL, stored procedures, triggers (5 lectures).
- Functional analysis of an information system, design of forms of the user interface (1 lecture).
- Transactions, ACID, log (1 lecture).
- Transactions, concurrency control (2 lectures): locking, versioning, transaction isolation levels.
- Data layer of an information system, object-relational mapping (ORM) (1 lecture): JDBC, ADO.NET.
- Integration of ORM and forms of an application (1 lecture).
- Physical implementation of database systems (1 lecture): query evaluation plan, heap table, index.
- Object-relational data model (1 lecture).
Syllabus of computer exercises:
- Procedural extensions of SQL: PL/SQL, T-SQL (5 exercises).
- Test on procedural extensions of SQL (2 exercises).
- Functional analysis of an information system, design of forms of the user interface (1 exercise).
- Description of nontrivial functions (transactions) using minispecifications (1 exercise).
- Implementation of object-relational mapping (1 exercise).
- Implementation of transactions (1 exercise).
- Integration of ORM and forms of an application (1 exercise).
- Transaction isolation levels (1 exercise).
Project:
- Functional analysis of an information system, design of forms of the user interface.
- Implementation of object-relational mapping.
- Implementation of transactions.
- Integration of ORM and forms of an application.
- Procedural extensions of SQL: PL/SQL, T-SQL, stored procedures, triggers (5 lectures).
- Functional analysis of an information system, design of forms of the user interface (1 lecture).
- Transactions, ACID, log (1 lecture).
- Transactions, concurrency control (2 lectures): locking, versioning, transaction isolation levels.
- Data layer of an information system, object-relational mapping (ORM) (1 lecture): JDBC, ADO.NET.
- Integration of ORM and forms of an application (1 lecture).
- Physical implementation of database systems (1 lecture): query evaluation plan, heap table, index.
- Object-relational data model (1 lecture).
Syllabus of computer exercises:
- Procedural extensions of SQL: PL/SQL, T-SQL (5 exercises).
- Test on procedural extensions of SQL (2 exercises).
- Functional analysis of an information system, design of forms of the user interface (1 exercise).
- Description of nontrivial functions (transactions) using minispecifications (1 exercise).
- Implementation of object-relational mapping (1 exercise).
- Implementation of transactions (1 exercise).
- Integration of ORM and forms of an application (1 exercise).
- Transaction isolation levels (1 exercise).
Project:
- Functional analysis of an information system, design of forms of the user interface.
- Implementation of object-relational mapping.
- Implementation of transactions.
- Integration of ORM and forms of an application.