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

Gurantor departmentDepartment of Computer ScienceCredits6
Subject guarantorprof. Ing. Michal Krátký, Ph.D.Subject version guarantorprof. 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 prof. 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
Part-time 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

Other requirements

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

Full-time form (validity from: 2012/2013 Winter semester, validity until: 2012/2013 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 45 (45) 23
                Semestrální projekt - 1. část Semestral project 22  11
                Semestrální projekt - 2. část Semestral project 23  12
        Examination Examination 55  28 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.Zaměření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

Assessment of instruction



2012/2013 Winter
2011/2012 Winter
2010/2011 Winter