Chapter 1 Flashcards
In which domain dataware house falls
decision support systems
Do we do denormalization of data in dataware house
Yes
What is OLAP
Online analytical processing are several techniques to save time doing operation on big databases. There is summary stored in columns and there are all possible aggregate (answers) stored in tables. The answer should come in 5 seconds.
What is dimensional modelling
Dimensional modelling is to make database schema in a way that performance should not degrade. These schema are known as star schema
What is ETL
Extract, Transform and Load.
Data comes in dataware house from heterogeneous sources. It is very hard that every data is in same format. Cleaning and transforming data to load is called ETL.
What is indexing
Setting primary key on table
What is data mining
The practice of examining large data from pre-existing databases in order to generate new information.
Does data found in databases or in flat files inside dataware house
Flat files
What is secondary storage
Direct access memory
What are legacy systems
Old system converted into web
What is crisis of credibility
Multiple answers of same question
What is the solution of crisis of credibility
Dataware houses
