Ви переглядаєте архівну версію офіційного сайту НУЛП (2005-2020р.р.). Актуальна версія: https://lpnu.ua

  1. Education
  2. Majors

The Theory of Database and Knowledge Base Systems

Major: Computer Sciences
Code of Subject: 7.122.04.E.74
Credits: 5
Department: Information Systems and Networks
Lecturer: Ph.D., Associate Professor Veres Oleh Mykhailovych
Semester: 1 семестр
Mode of Study: денна
Learning outcomes:
• know the place and the role of databases in modern computer systems;
• know the theoretical bases of data bases, the basic principles and methods of design of modern databases;
• know the search methods and data processing;
• to know the language of the description and data manipulation.
• have the idea of contemporary trends in the development of database management systems and knowledge;
• ability to describe and characterize the improved data model;
• ability to build a model of a comprehensive modular system databases;
• ability to choose appropriate tools and data structures for the implementation of modern databases.
Required prior and related subjects:
• Database and Knowledge Base Organization;
• Database and Knowledge Base Management Systems;
• Distributed Database Systems and Knowledge.
Summary of the subject:
The theory of relational databases: relational operators, relational algebra, functional dependency, functional dependencies. Database and database schema, a normal form for the database. Multivalued dependency, addiction and normal form. Tuple variables and properly constructed. Undefined value, heterogeneous information and other databases. Some of the properties of the database schema, the existence of the program to the full reduction. Syntax conditions for database schemas, acyclic hypergraph, wood joints, property quasi charging sections, the equivalence conditions. Improved data model-features and applications. Object and object-relational databases. Processing XML documents in a database. Multimedia database. Spatial databases and GIS. NoSQL database. Active and temporal database. Deductive databases. The knowledge base. Mobile database. Domain database.
Recommended Books:
1) Д.Мейер Теория реляционных баз данных: Пер. с англ. - М.: Мир, 1987. - 608 с., ил.
2) Берко А. Ю. Системи баз даних та знань. Книга 1. Організація баз даних та знань: підручник [для студ. вищ. навч. закл.] / Берко А. Ю., Верес О. М., Пасічник В.В. – 2-е вид. – Львів : „Магнолія 2006”, 2015. – 440 с. — (Серія «Комп’ютинґ»).
3) Берко А. Ю. Системи баз даних та знань. Книга 2.Системи управління базами даних та знань: підручник. / Берко А. Ю., Верес О. М., Пасічник В.В. – Львів: «Магнолія 2006», 2013. – 584с.
Assessment methods and criteria:
• Current control (40%): written reports on laboratory work, essay, oral examination;
• Final control (60% of exam): in written, verbally.