Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2019/2020

Database and Knowledge-based Systems

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
2371091 Z,ZK 4 2P+2C Czech
Lecturer:
Jiří Bíla (guarantor), Vladimír Hlaváč
Tutor:
Jiří Bíla (guarantor), Vladimír Hlaváč
Supervisor:
Department of Instrumentation and Control Engineering
Synopsis:

Basic data models. Types and examples of database systems. Management of database systems. Design of database systems - examples. Programming techniques. Language SQL. SQL for ORACLE. Fundamentals of programming in database systems MS ACCESS and ORACLE.

Introduction in knowledge-based systems. Examples of applying knowledge-based systems in Engineering. Knowledge-based systems developed on principles of formal logic. Principles of Prolog. Knowledge-based systems with uncertainty calculus. Formal description of uncertainty. Fuzzy set theory. Computations with fuzzy sets. Linguistic approximation. Fuzzy logic. Types of fuzzy logic implications and inferences. Rule-based systems. Principles of Data-mining in databases. Expert systems - modular structure. Examples of expert systems: ETS, NEST, CLIPS, FEL-EXPERT, TRACER.

Requirements:
Syllabus of lectures:

P1. Introduction. General operations with information provided by data-base systems.

P2. E - R conceptual model. Limitations for relations defined in DBS.

P3. Models of Data-base System Management. Relational data-base systems. Codd

Characteristics (rules) for relational data-base systems. Set and relation operations in

relation data-base system.

P4. Architectures of Database System Management in personal computers. Systems

„client/server“.

P5. Data-base application program languages. Structured language - SQL.

P6. Programming in the system MS Access.

P7. Programming in the system of ORACLE-type..

P8. Data-based and Knowledge-Based systems. Operations with knowledge. Decision and

Control paradigms. Operations with uncertainties. Theory of fuzzy sets.

P9. Operations with fuzzy sets. Fuzzy numbers and computing with fuzzy numbers.

Linguistic variable.

P10. Fuzzy logic. Compositional rule and fuzzy inference. Types of fuzzy implications and

their properties.

P11. Rule-based systems. (Examples.)

P12. Types and kinds of knowledge representation. Expert system - modular structure.

Inference engine and its co-operations with knowledge-base. System ETS.

P13. Expert systems - examples (FELExpert, TRACER, XCON/XSELL, KEE, NEST,

G2).

P14. Future of database and knowledge systems. Conclusions of lectures.

Syllabus of tutorials:

C1. Fundamentals of work with Data-base systems.

C2. Data-based systems for non-programmers.

C3. Introduction in data-base system MS ACCESS. Realisation of set and relational

operations.

C4. Structured language - SQL. Assignment of semester tasks.

C5. Programming in MS ACCESS.

C6. Programming in data-base system ORACLE.

C7. Programming in ACCESS versus programming in ORACLE.

C8. Fuzzy numbers, computing with fuzzy numbers.

C9. Fuzzy logic. Compositional rule and fuzzy inference. Types of fuzzy implications and

their properties.

C10. Rule-based systems. Expert system ETS. Assignment of semester tasks.

C11. Expert system ETS - examples. Expert system NEST.

C12. Expert system NEST.

C13. Assistance and testing of results of semester tasks.

C14. Testing of semester tasks. Conclusion of the semester.

Study Objective:

P1. Introduction. General operations with information provided by data-base systems., P2. E - R conceptual model. Limitations for relations defined in DBS., P3.Models of Data-base System Management. Relational data-base systems. Codd, Characteristics (rules) for relational data-base systems. Set and relation operations in, relation data-base system., P4. Architectures of Database System Management in personal computers. Systems, „client/server“., P5. Data-base application program languages. Structured language - SQL., P6. Programming in the system MS Access., P7. Programming in the system of ORACLE-type.., P8. Data-based and Knowledge-Based systems. Operations with knowledge. Decision and, Control paradigms. Operations with uncertainties. Theory of fuzzy sets., P9. Operations with fuzzy sets. Fuzzy numbers and computing with fuzzy numbers., Linguistic variable., P10. Fuzzy logic. Compositional rule and fuzzy inference. Types of fuzzy implications and, their properties., P11. Rule-based systems. (Examples.), P12. Types and kinds of knowledge representation. Expert system - modular structure., Inference engine and its co-operations with knowledge-base. System ETS., P13. Expert systems - examples (FELExpert, TRACER, XCON/XSELL, KEE, NEST,, G2)., P14. Future of database and knowledge systems. Conclusions of lectures.

Study materials:

1. Oppel, Andy: Databases. A Beginner's Guide. The McGraw Hill Companies, 2009. (recommended)

2. ISRD Group: Introduction to Database Management Systems. Tata McGraw-Hill Education, 2006. (available on the Google books, try www.google.cz/?q=tata+radqcdrkrxbqb )

3. Kruse, R., Gebhardt, J., Klawonn, F.: Foundations of Fuzzy Systems. B.G. Teubner, Stuttgart, 1994.

4. Bruno, N.: Automated Physical Database Design and Tuning. CRC Press, Taylor & Francais Group, 2011.

5. Chao, Lee: Database Development and Management. Taylor & Francais Group, 2006.

6. Lecture notes on www.fs.cvut.cz/prt/dks/

Note:
Time-table for winter semester 2019/2020:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
roomT4:C1-308
Bíla J.
Hlaváč V.

14:15–15:45
(lecture parallel1)
Dejvice
Laboratoř 12110.3 - 308
roomT4:C1-308
Bíla J.
Hlaváč V.

16:00–17:30
(parallel nr.1)
Dejvice
Laboratoř 12110.3 - 308
Tue
Fri
Thu
Fri
Time-table for summer semester 2019/2020:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2020-01-24
For updated information see http://bilakniha.cvut.cz/en/predmet3054106.html