Course detail
Database Systems and Cloud Storages
FSI-VDC-KAcad. year: 2024/2025
The course provides an introduction to DBS.
It deals with the following topics:
Data processing, redundancy, inconsistency, integrity, security, data sharing.
Index-sequential organisation. Relationship integrity constraints.
DBS architecture, data models. Entity-relationship model, relational algebra.
MySQL Workbench.
Theoretical fundamentals of information system design. Functional dependencies, normal forms, decomposition theorem.
Structured Query Language (SQL).
Web databases. HTML, PHP and MySQL.
Data security.
Clouds and grids.
NoSQL databases.
Language of instruction
Czech
Number of ECTS credits
5
Mode of study
Not applicable.
Guarantor
Entry knowledge
Successful completion of the course "Database Systems" is conditional on basic knowledge of algoritmization.
Rules for evaluation and completion of the course
The course-unit credit is awarded on condition of having implemented a nontrivial database application in HTML/PHP/MySQL. The exam has a written form and tests knowledge of students in database design, relational algebra, SQL, and programming in HTML/PHP/MySQL environment.
Since the attendance at seminars is required, it will be checked systematically by the teacher supervising the seminar. If a student misses a seminar, an excused absence can be compensated for via make-up topics of exercises.
Since the attendance at seminars is required, it will be checked systematically by the teacher supervising the seminar. If a student misses a seminar, an excused absence can be compensated for via make-up topics of exercises.
Aims
The course aims to acquaint the students with basic database technologies for an efficient design and management of applications with large data structures in web environment.
The course familiarises students with theoretical aspects of database application design and its implementation in web environment including programming in PHP and MySQL. They will be able to create an application for an efficient management of large scale data structures and they also will learn to use cloud services.
The course familiarises students with theoretical aspects of database application design and its implementation in web environment including programming in PHP and MySQL. They will be able to create an application for an efficient management of large scale data structures and they also will learn to use cloud services.
Study aids
Not applicable.
Prerequisites and corequisites
Not applicable.
Basic literature
Connoly, T.M. and Begg, C.E.: Database Systems : A Practical Approach to Design, Implementation and Management. Pearson Education, 2004 (4th edition).
Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition).
Fortier, P.J.: Database Systems Handbook. McGraw-Hill, 1997.
Holubová, I, Kosek, J., Minařík, K., Novák, D.: Big Data a NoSQL databáze. Grada, Praha, 2015.
Lacko, L.: SQL. Hotová řešení pro SQL Server, Oracle a MySQL. Computer Press, Brno, 2003.
Pratt, J.P.: A Guide to SQL. Course Technology, 2003 (6th edition).
Redmond, E., Wilson, J. R.: Seven Databases in Seven Weeks. A Guide to Modern Databases and the NoSQL. Movement-Pragmatic Bookshelf, 2012.
Stanoevska-Slabeva, K., Wozniak, T., Ristol, S. (eds.): Grid and Cloud Computing. A Business Perspective on Technology and Applications. Springer-Verlag, Berlin, 2010.
Ullman, L.: PHP and MySQL for Dynamic Web Sites. Pearson Education, 2003 (český překlad: PHP a MySQL: Názorný průvodce tvorbou dynamických www stránek. Computer Press, Brno, 2004).
Velte, T. A., Velte, T. J., Elsenpeter, R: Cloud Computing. A Practical Approach. McGraw Hill, New York, 2010.
Williams, H.E. and Lane, D.: Web Database Applications with PHP and MySQL. O’Reilly, 2002 (český překlad: Programujeme webové aplikace pomocí PHP a MySQL. Computer Press, Praha, 2002).
Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition).
Fortier, P.J.: Database Systems Handbook. McGraw-Hill, 1997.
Holubová, I, Kosek, J., Minařík, K., Novák, D.: Big Data a NoSQL databáze. Grada, Praha, 2015.
Lacko, L.: SQL. Hotová řešení pro SQL Server, Oracle a MySQL. Computer Press, Brno, 2003.
Pratt, J.P.: A Guide to SQL. Course Technology, 2003 (6th edition).
Redmond, E., Wilson, J. R.: Seven Databases in Seven Weeks. A Guide to Modern Databases and the NoSQL. Movement-Pragmatic Bookshelf, 2012.
Stanoevska-Slabeva, K., Wozniak, T., Ristol, S. (eds.): Grid and Cloud Computing. A Business Perspective on Technology and Applications. Springer-Verlag, Berlin, 2010.
Ullman, L.: PHP and MySQL for Dynamic Web Sites. Pearson Education, 2003 (český překlad: PHP a MySQL: Názorný průvodce tvorbou dynamických www stránek. Computer Press, Brno, 2004).
Velte, T. A., Velte, T. J., Elsenpeter, R: Cloud Computing. A Practical Approach. McGraw Hill, New York, 2010.
Williams, H.E. and Lane, D.: Web Database Applications with PHP and MySQL. O’Reilly, 2002 (český překlad: Programujeme webové aplikace pomocí PHP a MySQL. Computer Press, Praha, 2002).
Recommended reading
Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition).
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Addison Wesley, 4th edition, 2003.
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Addison Wesley, 4th edition, 2003.
Elearning
eLearning: currently opened course
Classification of course in study plans
- Programme N-AIŘ-K Master's 2 year of study, summer semester, compulsory
Type of course unit
Guided consultation in combined form of studies
17 hod., compulsory
Teacher / Lecturer
Syllabus
1. Introduction to DBS. Data sorting. Drawbacks of the classical file processing.
2. Database systems, data definition language (DDL) and data manipulation language (DML). Database system architecture. Physical and logical independence. Data models. Integrity constraints for relationships.
3. Relational algebra, basic operations, relational algebra as a query language.
4. Design of data structures. Normal forms of relations.
5. Structured Query Language (SQL). SQL SELECT. Aggregate functions. Multisegment aggregate key.
6. SQL. Subqueries. Multiple opening a table, relationship 1 to N within one table. Nested aggregations, query implementation using a sequence of queries.
7. SQL. Computing with NULL value. Existential and universal qualifier in SQL. Crosstab query. Update (action) queries. Definition queries.
8. Web databases. Communications among HTML, PHP and MySQL.
9. PHP. Data types, string functions, text and binary files, file locking.
10. Assignment statement, conditional statements, loop statements, user-defined functions, call by value and reference. Objects in PHP.
11 MySQL. User rights, data types, functions in MySQL, calling MySQL queries in PHP, password coding, realisation of complex database applications in criteria forms, insertion, updates and deletion of data.
12. NoSQL databases.
13. Clouds and grids.
2. Database systems, data definition language (DDL) and data manipulation language (DML). Database system architecture. Physical and logical independence. Data models. Integrity constraints for relationships.
3. Relational algebra, basic operations, relational algebra as a query language.
4. Design of data structures. Normal forms of relations.
5. Structured Query Language (SQL). SQL SELECT. Aggregate functions. Multisegment aggregate key.
6. SQL. Subqueries. Multiple opening a table, relationship 1 to N within one table. Nested aggregations, query implementation using a sequence of queries.
7. SQL. Computing with NULL value. Existential and universal qualifier in SQL. Crosstab query. Update (action) queries. Definition queries.
8. Web databases. Communications among HTML, PHP and MySQL.
9. PHP. Data types, string functions, text and binary files, file locking.
10. Assignment statement, conditional statements, loop statements, user-defined functions, call by value and reference. Objects in PHP.
11 MySQL. User rights, data types, functions in MySQL, calling MySQL queries in PHP, password coding, realisation of complex database applications in criteria forms, insertion, updates and deletion of data.
12. NoSQL databases.
13. Clouds and grids.
Guided consultation
35 hod., optionally
Teacher / Lecturer
Syllabus
Seminars in computer labs:
1. HTML. References, tables, frames.
2. HTML. Pictures, forms, cascade styles.
3. Organisation of web application HTML-PHP-MySQL.
4. Installation of web environment using local disc – WampServer, console communication.
5. Table creation and definition of item properties (data types, primary key, null values, string sort).
6. Modification of table structure, insertion into table and its modification (update and delete operation).
7. PHP. User-defined functions.
8. PHP. File processing, e-mail sending.
9. PHP. Pictures in PHP, creation of .pdf files.
10. MySQL. Connection to MySQL in PHP, selection of database, specification of SQL statement from data sent from a form and execution of the SQL statement.
11. MySQL. Evaluation of SQL SELECT query and formatting of the results into table.
12. Realisation of web application (e-shop, information and reservation system, …)
12. Review and practice - SQL: subqueries, realisation of 'at least 1', 'none' and 'all' expressions.
13. Clouds and grids, software support.
1. HTML. References, tables, frames.
2. HTML. Pictures, forms, cascade styles.
3. Organisation of web application HTML-PHP-MySQL.
4. Installation of web environment using local disc – WampServer, console communication.
5. Table creation and definition of item properties (data types, primary key, null values, string sort).
6. Modification of table structure, insertion into table and its modification (update and delete operation).
7. PHP. User-defined functions.
8. PHP. File processing, e-mail sending.
9. PHP. Pictures in PHP, creation of .pdf files.
10. MySQL. Connection to MySQL in PHP, selection of database, specification of SQL statement from data sent from a form and execution of the SQL statement.
11. MySQL. Evaluation of SQL SELECT query and formatting of the results into table.
12. Realisation of web application (e-shop, information and reservation system, …)
12. Review and practice - SQL: subqueries, realisation of 'at least 1', 'none' and 'all' expressions.
13. Clouds and grids, software support.
Elearning
eLearning: currently opened course