Answer all questions. Submit your answers in MS-Word as an attachment. 1. Define

Question

Answer all questions. Submit your answers in MS-Word as an attachment.

1. Define each of the following terms (Chapter 9 of your textbook):

data warehouse
data mart
reconciled data
derived data
online analytical processing
big data
star schema
snowflake schema

2. List three types of operations that can easily be performed with OLAP tools. No descriptions are required.

3. List and describe four characteristics of a data warehouse (Chapter 9 of your textbook).

Define each of the following terms (Chapter 10 of your textbook):

static extract
incremental extract
data steward
master data management
refresh mode

Explanation / Answer

1.Define the following terms

a)Dataware house

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process. Subject-Oriented: A data warehouse can be used to analyze a particular subject area.

b)Data Mart

A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts are small slices of the data warehouse.

c)Reconciled data

Data reconciliation is element level checking where each element is valid. This includes matching the source and reflecting an accurate, valid value.

d)Online Analytical Processing

OLAP (Online Analytical Processing) is the technology behind many Business Intelligence (BI) applications. OLAP is a powerful technology for data discovery, including capabilities for limitless report viewing, complex analytical calculations, and predictive “what if” scenario (budget, forecast) planning.

e)Big Data

Big data is a broad term for data sets so large or complex that traditional data processing applications are inadequate. Challenges include analysis, capture, data curation, search, sharing, storage, transfer, visualization, and information privacy. The term often refers simply to the use of predictive analytics or other certain advanced methods to extract value from data, and seldom to a particular size of data set. Accuracy in big data may lead to more confident decision making. And better decisions can mean greater operational efficiency, cost reduction and reduced risk.

f)Star Schema

A simple database design in which dimensional data are separated from fact or event data. A dimensional model is another name for star schema

g)Snowflake schema

An expanded version of a star schema in which all of the tables are fully normalized.

2. List three types of operations that can easily be performed with OLAP tools. No descriptions are required.

Operations are

1)Rollup

2)Drill down

3)Slice and dice

4)pivot(rotate)

3. List and describe four characteristics of a data warehouse

There are four key characteristics which separate the data warehouse from other major operational systems:

Define the following terms

In business,master data management (MDM) comprises the processes, governance, policies, standards and tools that consistently define and manage the critical data of an organization to provide a single point of reference.

4. Refresh mode

            An approach for populating the data warehouse that employs bulk rewriting of the target data at periodic intervals

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.