Database Systems

Course guarantor:

Lecturer:

Tutor:

Supervisor:

Department of Construction Management and Economics

Synopsis:

Modeling of relational databases, basics of SQL language for creating relational database, manipulation of data in database, retrieving data from database. Principles of object-oriented modeling and its application in EXPRESS modeling language, STEP data format and their use in IFC data structure, structure and basic content of IFC data.

Requirements:

seminar papers, examination

Syllabus of lectures:

1. Principles of relational database modelling - basic concepts, E-R diagram

2. Modeling relational databases - normal forms, data model normalization

3. Modeling relational databases - attribute data types

4. SQL - connecting to a database, creating a database structure, manipulating data in a database

5. SQL - basics of data retrieval from a database

6. SQL - advanced database data retrieval

7. Basic principles of object-oriented problem solving and related basic concepts

8. Data format STEP (Standard for the Exchange of Product Model Data)

9. Advanced principles of object-oriented problem solving and related concepts

10. Fundamentals of the EXPRESS modeling language

11. Advanced parts of the EXPRESS modeling language

12. Using the EXPRESS modeling language and the STEP data format in IFC.

13. Summary of the basic content of IFC

Syllabus of tutorials:

1. E-R diagram - modelling user requirements

2. E-R diagram - data model normalization

3. E-R diagram - platform specific model

4. SQL - database structure creation, data manipulation in the database

5. E-R diagram - Analysis of existing database structure

6. SQL - database queries

7. Creating an object-oriented model

8. - 9. Creating a data file in STEP format

10. - 11. Creating an object-oriented data model in EXPRESS language

12. Editing an IFC file

13. Comparison of the designed object-oriented data model with the IFC data structure

Study Objective:

This course aims to provide basic knowledge of relational databases and knowledge of storing data of building information models according to the IFC standard, including storing data in the STEP format and the specification of the data structure in the EXPRESS modelling language. For these purposes, the principles of object-oriented problem solving on which the EXPRESS modelling language is based are also introduced.

Study materials:

[1] UNHELKAR, Bhuvan. Software engineering with UML. Boca Raton, [2018]. ISBN 978-1-138-29743-2.

[2] MySQL 8.0 Reference Manual, available from: https://dev.mysql.com/doc/refman/8.0/en/

[3] ISO 10303-11:2004 Industrial automation systems and integration -- Product data representation and exchange -- Part 11: Description methods: The EXPRESS language reference manual

[4] BUDD, Timothy, 1996. An Introduction to Object-Oriented Programming. . Subsequent edition. Reading, Mass: Addison-Wesley. ISBN 978-0-201-82419-3.

[5] ISO 10303-21 Industrial automation systems and integration Product data representation and exchange: Part 21: Implementation methods: Clear text encoding of the exchange structure. 2. ISO (International Organization for Standardization), 2002

[6] buildingSMART International Ltd., „ Industry Foundation Classes IFC2x Edition 3 Technical Corrigendum 1“, Available at: https://standards.buildingsmart.org/IFC/RELEASE/IFC2x3/TC1/HTML/ .

[7] ISO 10303-11:2004 Industrial automation systems and integration -- Product data representation and exchange -- Part 11: Description methods: The EXPRESS language reference manual

[8] ISO 10303-21: 2016, „Industrial automation systems and integration Product data representation and exchange Part 21: Implementation methods: Clear text encoding of the exchange structure,“ International Organization for Standardization, 2016, Available at: https://www.iso.org/standard/63141.html

[9] buildingSMART International Ltd., „Industry Foundation Classes 4.0.2.1 Version 4.0 - Addendum 2 - Technical Corrigendum 1“, Available at: https://standards.buildingsmart.org/IFC/RELEASE/IFC4/ADD2_TC1/HTML/ .

[10] buildingSMART International Ltd., „IFC 4.3.2.0 (IFC4X3_ADD2) official“, Available at: https://standards.buildingsmart.org/IFC/RELEASE/IFC4_3/ .

[11] Constructive Solid Geometry Methods. (b.r.). Available at: http://groups.csail.mit.edu/graphics/classes/6.837/F98/talecture/

[12] Examples of Attributes. Online. Available from: https://examples.yourdictionary.com/examples-of-attributes.html.

Note:

Further information:

Pro předmět bude k dispozici kurz v Moodle

No time-table has been prepared for this course

The course is a part of the following study plans:

• Digitalizace ve stavebnictví - prezenční forma studia (compulsory course in the program)