460-4010/01 – Information Systems and Data Warehousing (ISDS)

Gurantor departmentDepartment of Computer ScienceCredits6
Subject guarantordoc. Ing. Michal Krátký, Ph.D.Subject version guarantordoc. Ing. Michal Krátký, Ph.D.
Study levelundergraduate or graduateRequirementOptional
Year1Semesterwinter
Study languageCzech
Year of introduction2010/2011Year of cancellation2012/2013
Intended for the facultiesFEIIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAS064 Ing. Václav Bašniar
KRA28 doc. Ing. Michal Krátký, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 10+0

Subject aims expressed by acquired skills and competences

Graduate Course knows the standard methodology, methods and tools for the development of large information systems, lead is used in practice in the development of IS in the team co-investigator, can describe the issue of data warehousing, the origin, use, difference from operational databases, knows the methods of data modeling data warehouses and their implementation, practically can analyze and implement a data warehouse from a specified operational database is able to describe the differences between operational and other types of IS.

Teaching methods

Lectures
Tutorials
Project work

Summary

Methods of knowledge about the development of traditional operational information systems (OLTP), practical process analysis, design implementation, implementation, documentation and final presentation of a large IS. Theory and practice of data warehouses (DW) as a new type of database, OLAP and decision support systems. DS developmental stages, concrete examples of how analysis is made DS.

Compulsory literature:

Ponniah, P.: Warehousing Fundamentals: A Comprehensive Guide for IT Professionals. Copyright © 2001 John Wiley & Sons, Inc. ISBNs: 0-471-41254-6 (Hardback); 0-471-22162-7 (Electronic)

Recommended literature:

Lacko, L.: Datové sklady, analýza OLAP a dolování dat. Computer Press, Brno 2003. Richta, K.- Sochor, J.: Softwarové inženýrství. Skriptum VUT Praha.

Way of continuous check of knowledge in the course of semester

Continuous assessment: Team processing and presentation of information system analysis. IS Implementation Team and its presentation. Presentation of analysis of the data warehouse.

E-learning

Další požadavky na studenta

Additional requirements are placed on the student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Lectures: Team development of information systems. Control of work, types of solvers, types of project teams. The life cycle of information systems. To specification - functional and non-functional requirements. Analysis of the data, functional, timing, methods and tools Design implementation, system and object-oriented design, design analysis. Implementation. Testing. Documentation. Maintenance IS Cycle of creation and use of information, OLTP, data warehousing, OLAP. The structure of data warehouse metadata. Analysis of the data warehouse. Data analysis, conceptual, multidimensional modeling, dimensions and facts, aggregation. Star schema, constellations and other schemes. Methods of data warehouse implementations. Mining knowledge from databases. User interface, presentation and visualization of data and analysis results. Text database .. Projects: Team development of a larger information system. Processing of entries and analysis. Changing the assignment and analysis between the teams. Implementation of IS according to foreign studies, documentation of information systems. Analysis of the data warehouse implemented IS Computer Labs: Analysis of the data warehouse for the IS Work on SQL Server DS Development in SQL Server Documentation DS

Conditions for subject completion

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2012/2013 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Optional study plan
2012/2013 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Optional study plan
2012/2013 (N2647) Information and Communication Technology (2612T059) Mobile Technology P Czech Ostrava 1 Optional study plan
2012/2013 (N2647) Information and Communication Technology (2612T059) Mobile Technology K Czech Ostrava 1 Optional study plan
2011/2012 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Optional study plan
2011/2012 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Optional study plan
2011/2012 (N2647) Information and Communication Technology (2612T059) Mobile Technology P Czech Ostrava 1 Optional study plan
2011/2012 (N2647) Information and Communication Technology (2612T059) Mobile Technology K Czech Ostrava 1 Optional study plan
2010/2011 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology P Czech Ostrava 1 Optional study plan
2010/2011 (N2647) Information and Communication Technology (2612T025) Computer Science and Technology K Czech Ostrava 1 Optional study plan
2010/2011 (N2647) Information and Communication Technology (2612T059) Mobile Technology P Czech Ostrava 1 Optional study plan
2010/2011 (N2647) Information and Communication Technology (2612T059) Mobile Technology K Czech Ostrava 1 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner