Database and Knowledge Base Organization

Major: Applied mathematics and computer science
Code of subject: 6.113.00.O.048
Credits: 6.00
Department: Applied Mathematics
Lecturer: Alieksieiev, Vladyslav I., PhD, Assoc. Prof., Associate Professor of department of Applied Mathematics
Semester: 4 семестр
Mode of study: денна
Learning outcomes: Understanding of the principles of relational and non-relational databases, knowledge of programming languages in relational databases, in particular SQL, ability to design a relational database for a given subject area, choose and apply the selected database, build and apply knowledge base or expert system. Willingness to study other disciplines in the field of information technology.
Required prior and related subjects: Prerequisites: Algorithms and programming part 1, Algorithms and programming part 2 Co-requisites: Programming of WEB-applications part 2, Cloud technologies and Calculations, Design and development of information systems, Cross-platform programming, Ultra-large databases (Big data)
Summary of the subject: The discipline "Organization of databases and knowledge" is part of the educational and professional training program for the first level of higher education "Bachelor" in the field of knowledge 11 - "Mathematics and Statistics" in specialty 113 - "Applied Mathematics" in the educational program "Applied Mathematics and Informatics ». This discipline is required. Taught in the second semester of the 2nd year (4th semester) in the amount of 180 hours. (6 ECTS credits) in particular: lectures - 45 hours, laboratory classes - 30 hours, independent work - 85 hours. The course includes 2 tests in the ANS. The discipline ends with an exam. The task of the discipline is practical mastering of the concept of relational databases, theoretical bases and principles of relational model of work with data, studying of language of structured queries (SQL), acquaintance with features of realization of relational model and syntax of SQL language in various DBMS (Oracle, MS SQL Server, MySQL / MariaDB, PostgreSQL), acquaintance with procedural extensions of various DBMS (Oracle PL \ SQL, MS Transact-SQL, etc.), incl. stored procedures and triggers, understanding transactions, problems of data integrity and organization of simultaneous access to data, forming an idea of ??the advanced capabilities of DBMS in working with special data types (XML, JSON, GIS, etc.), gaining knowledge about approaches and features of non-relational databases , the formation of understanding of the concepts of "knowledge" and "knowledge base", including forming an idea of ??expert systems, ontologies and systems based on rules, semantic networks, content management systems (content), as well as familiarity with the tools of design and work with databases and knowledge bases. As a result of studying the discipline, students should know: the basics of relational database theory; methodological approaches and stages of building information systems; technology for creating software products based on DBMS; basics of DBMS programming languages; structure of DBMS of different types (small, average, heavy); principles of using object-oriented approach in the development of information systems; open systems architecture. As a result of studying the discipline, students should be able to: apply the methodology of designing information systems; to create software of information systems with use of heavy DBMS; use universal means of interaction with various databases; use SQL; at the initial level to be able to administer relational databases; choose the most successful architectural solution based on relational or non-relational database; design, build and apply knowledge bases.
Assessment methods and criteria: Current control: - laboratory work (30%), - project implementation (5%), - 2 control works in VNS (10%). Examination control: - written exam (55%).
Recommended books: Basic: 1. C. J. Date. An Introduction to Database Systems, 8th edition. – Pearson/Addison-Wesley, 2006. 2. I. Ben-Gan. Microsoft SQL Server 2012 T-SQL Fundamentals. – O’Reilly, 2012. 3. T. Kyte. Oracle for Professionals. — Pearson/Wrox, 2002. 4. P. J. Sadalage, M. Fowler. NoSQL Distilled: А Brief Guide to the Emerging World of Polyglot Persistence. – Addison-Wesley, 2013. Auxiliary: 1. Hasso Plattner, Alexander Zeier. In-Memory Data Management: Technology and Applications, 2nd edition. – Springer, 2012. 2. Gaurav Vaish. Getting Started with NoSQL. – Packt Publishing, 2013. 3. W. H. Inmon. Building the Data Warehouse, 3rd edition. – John Wiley & Sons, Inc., New York, 2002.