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

Analytical Data Warehouse

Major: Information Systems and Technologies
Code of Subject: 7.126.00.M.14
Credits: 5
Department: Information Systems and Networks
Lecturer: Prof. Berko Andrei Yulianovich
Semester: 2 семестр
Mode of Study: денна
Learning outcomes:
models and methods of designing and implementing data warehousing;
decisions on technology data warehousing;
the practical application of basic methods, tools and techniques of modern storage.
Required prior and related subjects:
Databases and knowledge bases organization
Summary of the subject:
The concept of data hypercube and its relationship with the universal relation. Operations of the data hypercube such as slice, rotate, rollup, rolldown. Information technology and the concept of data warehouses. Architecture of data warehouses. Metadata repositories. Data Integration. The quality of the data warehouse. Data Aggregation. Data storage systems. Virtualization storage. Technology access to storage. Extracting data repositories. Data warehouses tools.
Recommended Books:
Шаховська Н.Б., Пасічник В.В. Сховища даних. — Львів: Магнолія-2006. 2008. — 487 с.
Хранилища данных: шаги от идеи до внедрения, 2006, http://www.cnews.ru/newcom/index.shtml.
Конноли Т., Бэгг К., Страчан А. Базы данных: проектирование, реализация и сопровождение. Теория и практика. 2-е изд.: Пер. с англ. — М.: Издательский дом «Вильямс», 2000. — 1120 с.
Assessment methods and criteria:
Practical work (40%): written reports on laboratory work, design work, oral examination
Final control (60% test), testing (30%), oral examination (30%)