Data Storage Technologies

Major: Computer Science
Code of subject: 6.122.15.E.054
Credits: 5.00
Department: Information Systems and Technologies
Lecturer: teacher Yalechko V.
Semester: 6 семестр
Mode of study: денна
Learning outcomes: As a toolkit in the course is studied MySQL database. It is in the environment of this product that students learn to develop information and analytical systems, to integrate data from different sources into a data warehouse. Mastering such knowledge will enable the automation of information processing, automation of object management. Such knowledge can be applied by a future specialist both during further education and after receiving higher education in his professional activities.
Required prior and related subjects: - organization of databases and knowledge; - systems and technologies of database management; - information management systems and technologies in ecological monitoring.
Summary of the subject: Relational database. Codd rules. Manage multidimensional data representation. Ideology and concept. Codd rules. The notion of a data warehouse. Problem of building data warehouses. Using technology "data flow" to retrieve data in the repository. Using OLAP technologies for data analysis.
Assessment methods and criteria: Laboratory work - 30. Control work - 20. Oral questioning - 30. Writing work -20.
Порядок та критерії виставляння балів та оцінок: 100-88 points - certified with an “excellent” grade - High level: the student demonstrates an in-depth mastery of the conceptual and categorical apparatus of the discipline, systematic knowledge, skills and abilities of their practical application. The mastered knowledge, skills and abilities provide the ability to independently formulate goals and organize learning activities, search and find solutions in non-standard, atypical educational and professional situations. The applicant demonstrates the ability to make generalizations based on critical analysis of factual material, ideas, theories and concepts, to formulate conclusions based on them. His/her activity is based on interest and motivation for self-development, continuous professional development, independent research activities, implemented with the support and guidance of the teacher. 87-71 points - certified with a grade of “good” - Sufficient level: involves mastery of the conceptual and categorical apparatus of the discipline at an advanced level, conscious use of knowledge, skills and abilities to reveal the essence of the issue. Possession of a partially structured set of knowledge provides the ability to apply it in familiar educational and professional situations. Aware of the specifics of tasks and learning situations, the student demonstrates the ability to search for and choose their solution according to the given sample, to argue for the use of a particular method of solving the problem. Their activities are based on interest and motivation for self-development and continuous professional development. 70-50 points - certified with a grade of “satisfactory” - Satisfactory level: outlines the mastery of the conceptual and categorical apparatus of the discipline at the average level, partial awareness of educational and professional tasks, problems and situations, knowledge of ways to solve typical problems and tasks. The applicant demonstrates an average level of skills and abilities to apply knowledge in practice, and solving problems requires assistance, support from a model. The basis of learning activities is situational and heuristic, dominated by motives of duty, unconscious use of opportunities for self-development. 49-00 points - certified with a grade of “unsatisfactory” - Unsatisfactory level: indicates an elementary mastery of the conceptual and categorical apparatus of the discipline, a general understanding of the content of the educational material, partial use of knowledge, skills and abilities. The basis of learning activities is situational and pragmatic interest.
Recommended books: 1. Б.Керниган, Д.Ритчи. Язык программирования С. – Санкт-Петербург, 2001. – 300 с. 2. Б.Л.Голуб, Є.М.Шукайло. Методичний посібник до вивчення дисципліни “Програмування та алгоритмічні мови”. Методичний посібник. – Видавничий центр НАУ, 2003. – 64 с. 3. Перминов Г.И. Хранилища данных. Интернет-университет информационных технологий - ИНТУИТ.ру, 2009 4. Чубукова И.А. Data Mining. БИНОМ. Лаборатория знаний, Интернетуниверситет информационных технологий -ИНТУИТ.ру, 2008.