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

Database and Data Warehouse Technologies

Major: Information Systems and Technologies
Code of Subject: 7.126.01.E.25
Credits: 4
Department: Automated Control Systems
Lecturer: PhD, Associate professor Doroshenko Anastasiya
Semester: 2 семестр
Mode of Study: денна
Learning outcomes:
- Ability to apply the methods and tools of modern information technologies to design and develop databases and data warehouses for different industries;
- Ability to design databases and repositories using CASE tools, to manage IT project, using modern methodologies and software;
- Ability to design and develop intelligent components for information management systems using knowledge of machine learning and data mining techniques.
Required prior and related subjects:
Management of information systems development projects
Strategic analysis of information systems
Summary of the subject:
The course "Database Technologies and Data Warehousing" covers such topics as: studying different technologies of creation and work with databases, optimization of execution of requests to a database, new directions in creation and use of indexes, the concept of data warehouses, architectures of data warehouses, model of a typical Data Warehouse Design Project, Business Intelligence and Data Warehouse, Entity-Relationship Modeling, Multidimensional Modeling, ETL Process Design, and Development, Physical Data Warehouse Model
Recommended Books:
1. Watson, R. T. (2016). Data management, databases and organizations (6. ed.). John Wiley & Sons.
2. Elmasri, R., & Navathe, S.B. (2016). Fundamentals of Database Systems, 7th edition. New York: Pearson Education.
3. Provost, F. & Fawcett, T. (2013). Data Science for Business. Sebastopol: O'Reilly Media
4. Kitchin, R. (2014). Big Data, new epistemologies and paradigm shifts. Big Data & Society, 1(1), 2053951714528481.
5. Bob Bryla,? Kevin Loney (2013) Oracle Database 12c The Complete Reference. Oracle Press
6. Carlos Coronel, Steven Morris (2014) Database Systems: Design, Implementation, & Management
7. David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder (2017) Database Concepts (8th Edition) 8th Edition
8. GalitShmueli,? Peter C. Bruce,? InbalYahav,? Nitin R. Patel,? Kenneth C. Lichtendahl (2017) Data Mining for Business Analytics: Concepts, Techniques, and Applications in R. Wiley
9. Ralph Kimball, Margy Ross (2013) The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
10. Lawrence Corr and Jim Stagnitto (2011) Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to star schema
11. Matteo Golfarelli and Stefano Rizzi (2009) Data Warehouse Design: Modern Principles and Methodology
12. Erik Thomsen (2002) OLAP Solutions: Building Multidimensional Information Systems
Assessment methods and criteria:
Current control (35%): written reports on laboratory works.
Final control (65%) exam.