Logo ČVUT
ČESKÉ VYSOKÉ UČENÍ TECHNICKÉ V PRAZE
STUDIJNÍ PLÁNY
2018/2019

Database and Knowledge-based Systems

Přihlášení do KOSu pro zápis předmětu Zobrazit rozvrh
Kód Zakončení Kredity Rozsah Jazyk výuky
E371079 Z,ZK 5 3+1
Přednášející:
Jiří Bíla (gar.), Vladimír Hlaváč
Cvičící:
Jiří Bíla (gar.), Vladimír Hlaváč
Předmět zajišťuje:
ústav přístrojové a řídící techniky
Anotace:

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

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.

Požadavky:

see lectures

Osnova přednášek:

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.

Osnova cvičení:

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.

Cíle studia:
Studijní materiály:

Bíla, Král : Databázové a znalostní systémy. ČVUT, Praha, 1999.

Vysoký, P.: Fuzzy řízení. ČVUT, Praha, 1999.

Mařík, V. a kol.: Umělá inteligence, díl 2., kap. 1., 2., 3. a 9. ACADEMIA, Praha, 1997

ISRD Group: Introuction to Database Management Systems. Tata McGraw-Hill Education, 2006.

Connoly,T.,Begg,C.: Database systems. A Practical Approach to Design, Implementation, and Management. Pearson Education, 1995 (or 2005).

Rajasekaran, S., Vijayalakshmi, G.A.: Neural Networks, Fuzzy Logic, and Genetic Algorithms. Prentice-Hall of India, 2003.

Poznámka:
Rozvrh na zimní semestr 2018/2019:
Rozvrh není připraven
Rozvrh na letní semestr 2018/2019:
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
Po
Út
St
místnost T4:C1-308
Bíla J.
Hlaváč V.

13:15–15:00
(přednášková par. 1)
Dejvice
Laboratoř 12110.3 - 308
místnost T4:C1-308
Bíla J.
Hlaváč V.

15:00–16:45
(přednášková par. 1
paralelka 1)

Dejvice
Laboratoř 12110.3 - 308
Čt

Předmět je součástí následujících studijních plánů:
Platnost dat k 16. 6. 2019
Aktualizace výše uvedených informací naleznete na adrese http://bilakniha.cvut.cz/cs/predmet1642906.html