Object relational databases. Using object-oriented constructors in data modeling. Advanced features of data modelling. Object-oriented databases. ODMG standard. Multidimensional view on data and multidimensional modelling. Conceptual models. Organization of data at internal level. Use B-trees, bitmap indexes and their combinations as physical structures to solve star queries in a warehouse environment. Transactional processing in distributed databases. Advanced features of Oracle database. Data protection.
Terminated in academic year 2011/2012
Database systems
| Type of study | Doctoral |
|---|---|
| Language of instruction | Czech |
| Code | 157-0911/01 |
| Abbreviation | DS |
| Course title | Database systems |
| Credits | 0 |
| Coordinating department | Department of Systems Engineering and Informatics |
| Course coordinator | doc. Ing. Ludmila Kalužová, CSc. |
Subject syllabus
Literature
1.Connolly,T., Begg,C., Holowczak,R. (2008) Business Database Systems. Addison Wesley Publ. Comp., ISBN 978-1-4058-7437-3
2.Loney, K. (2009) ORACLE DATABASE 11g: The Complete Reference. Osborne McGraw-Hill Comp., ISBN 978-0-07-159875-0
2.Loney, K. (2009) ORACLE DATABASE 11g: The Complete Reference. Osborne McGraw-Hill Comp., ISBN 978-0-07-159875-0
Advised literature
1.Loney,K., Brylan,B. (2007) Oracle Database 11g DBA Handbook Osborne McGraw-Hill Comp., ISBN 978-0071496636
2.Koch, G., Loney, K. (2004): ORACLE DATABASE 10g The Complete Reference. Osborne McGraw-Hill Comp., Emeryville California, ISBN 0-07-225352-5
3. Date, C. J., (2003) An Introduction to Database Systems. 8th edition: Addison-Wesley Publishing Company, ISBN 0-32-119784-4
2.Koch, G., Loney, K. (2004): ORACLE DATABASE 10g The Complete Reference. Osborne McGraw-Hill Comp., Emeryville California, ISBN 0-07-225352-5
3. Date, C. J., (2003) An Introduction to Database Systems. 8th edition: Addison-Wesley Publishing Company, ISBN 0-32-119784-4