Subjects
Applied Mathematics for Electrical Engineering - 3130908
Complex Variables and Partial Differential Equations - 3130005
Engineering Graphics and Design - 3110013
Basic Electronics - 3110016
Mathematics-II - 3110015
Basic Civil Engineering - 3110004
Physics Group - II - 3110018
Basic Electrical Engineering - 3110005
Basic Mechanical Engineering - 3110006
Programming for Problem Solving - 3110003
Physics Group - I - 3110011
Mathematics-I - 3110014
English - 3110002
Environmental Science - 3110007
Software Engineering - 2160701
Data Structure - 2130702
Database Management Systems - 2130703
Operating System - 2140702
Advanced Java - 2160707
Compiler Design - 2170701
Data Mining And Business Intelligence - 2170715
Information And Network Security - 2170709
Mobile Computing And Wireless Communication - 2170710
Theory Of Computation - 2160704
Semester
Semester - 1
Semester - 2
Semester - 3
Semester - 4
Semester - 5
Semester - 6
Semester - 7
Semester - 8
Data Mining And Business Intelligence
(2170715)
DMBI-2170715
Winter-2018
Question-1-b
BE | Semester-
7
Winter-2018
|
03/12/2018
Q1) (b)
4 Marks
Explain various features of Data Warehouse?
Following are the features of Data Warehouse
Subject-oriented
Integrated
Time-variant
Nonvolatile
Subject-oriented :
A data warehouse is organized around major subjects, such as customer, supplier, product, and sales
Rather than concentrating on the day-to-day operations and transaction processing of an organization, a data warehouse focuses on the modeling and analysis of data for decision makers.
Data warehouses typically provide a simple and concise view around particular subject issues by excluding data that are not useful in the decision support process
Integrated :
A data warehouse is usually constructed by integrating multiple heterogeneous sources, such as relational databases, flat files, and on-line transaction records.
Data cleaning and data integration techniques are applied to ensure consistency in naming conventions, encoding structures, attribute measures, and so on.
Time-variant :
Data are stored to provide information from a historical perspective (e.g., the past 5–10 years).
Every key structure in the data warehouse contains, either implicitly or explicitly, an element of time
Nonvolatile :
A data warehouse is always a physically separate store of data transformed from the application data found in the operational environment.
Due to this separation, a data warehouse does not require transaction processing, recovery, and concurrency control mechanisms
Questions
Go to Question Paper
Q1
(a)
Q1
(b)
Q1
(c)
Q2
(a)
Q2
(b)
Q2
(c)
Q2
(c)
Q3
(a)
Q3
(b)
Q3
(c)
Q3
(a)
Q3
(b)
Q3
(c)
Q4
(a)
Q4
(b)
Q4
(c)
Q4
(a)
Q4
(b)
Q4
(c)
Q5
(a)
Q5
(b)
Q5
(c)
Q5
(a)
Q5
(b)
Q5
(c)