Modern Database Management
Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
bartleby

Concept explainers

Question
Book Icon
Chapter 9, Problem 9.1RQ
Program Plan Intro

a. Definition of data warehouse.

Expert Solution
Check Mark

Explanation of Solution

Data warehouse is a large collection of data which is further used by companies for decision making process of management. The data collection is subject-oriented, integrated, time-variant and non-updateable.

Program Plan Intro

b. Definition of data mart.

Expert Solution
Check Mark

Explanation of Solution

Data mart: A data warehouse which is limited in scope is called data mart. The data stored in data warehouse is selected and summarized using extract, transform and load process.

Program Plan Intro

c. Definition of reconciled data.

Expert Solution
Check Mark

Explanation of Solution

Reconciled data: It is detailed and current data which act as single source for all decision support system. This type of data is stored for enterprise data warehouse and operational data store.

Program Plan Intro

d. Definition of derived data.

Expert Solution
Check Mark

Explanation of Solution

Derived data: Data which is being extracted, formatted and segregated for end-user decision support application is known as derived data.

Program Plan Intro

e. Definition of enterprise data warehouse.

Expert Solution
Check Mark

Explanation of Solution

Enterprise data warehouse: It is a centralized, integrated data warehouse which act as the control point and only source for all data which is being made available to end user for decision making.

Program Plan Intro

f. Definition of real-time data warehouse.

Expert Solution
Check Mark

Explanation of Solution

Real-time data warehouse: It is a type of data warehouse which stores data related to transaction in near real time feeds from system of records. It can analyze data and control business rules in near real time so that appropriate actions can be taken as per current business events. It typically stores moderate size database.

Program Plan Intro

g. Definition of star schema.

Expert Solution
Check Mark

Explanation of Solution

Star schema: It is a database design where in dimensional data is separated from fact or event data. It is simplest type of data warehouse schema. It is called star schema as it is in the shape of start and is similar to relational model where fact table is represented at the centre and multiple dimensional table are connected to the centre fact table.

Program Plan Intro

h. Definition of snowflake schema.

Expert Solution
Check Mark

Explanation of Solution

Snowflake schema: It is an extension to star schema where dimensional tables are normalized into several related tables. Normalization of dimensional tables splits this table into multiple tables and the schema diagram resembles that of snowflake.

Program Plan Intro

i. Definition of grain.

Expert Solution
Check Mark

Explanation of Solution

Grain: Grain is the description of level of details for a fact table. For example, suppose a fact table stores information related to sales of specific product in various locations on a daily basis. Then grain for this fact table will be “information of product sale by location and by day”

Program Plan Intro

j. Definition of conformed dimension.

Expert Solution
Check Mark

Explanation of Solution

Conformed dimension: It is a dimension in which multiple dimension tables which are associated with multiple fact tables has same business meaning and primary key with each fact table.

Program Plan Intro

k. Definition of static extract.

Expert Solution
Check Mark

Explanation of Solution

Static extractis a type of data extractionmethod used to capture a snapshot of required source of data at a point of time. It is used to fill the data warehouse during initial phases.

Program Plan Intro

l. Definition of incremental extract.

Expert Solution
Check Mark

Explanation of Solution

Incremental extract is also a type of data extraction method which captures only the changes that have occurred in the source data since the last capture. It is used for ongoing warehouse maintenance.

Program Plan Intro

m. Definition of refresh mode.

Expert Solution
Check Mark

Explanation of Solution

Refresh modeis a strategy used for filling the data warehouse with data where bulk rewriting of the target data is involved at periodic intervals. Target data are filled in data warehouse initially and then rewritten periodically by replacing the previous content.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Refer to page 80 for problems on white-box testing. Instructions: • Perform control flow testing for the given program, drawing the control flow graph (CFG). • Design test cases to achieve statement, branch, and path coverage. • Justify the adequacy of your test cases using the CFG. Link: [https://drive.google.com/file/d/1wKSrun-GlxirS3IZ9qo Hazb9tC440 AZF/view?usp=sharing]
Refer to page 10 for problems on parsing. Instructions: • Design a top-down parser for the given grammar (e.g., recursive descent or LL(1)). • Compute the FIRST and FOLLOW sets and construct the parsing table if applicable. • Parse a sample input string and explain the derivation step-by-step. Link: [https://drive.google.com/file/d/1wKSrun-GlxirS31Z9qoHazb9tC440 AZF/view?usp=sharing]
Refer to page 20 for problems related to finite automata. Instructions: • Design a deterministic finite automaton (DFA) or nondeterministic finite automaton (NFA) for the given language. • Minimize the DFA and show all steps, including state merging. • Verify that the automaton accepts the correct language by testing with sample strings. Link: [https://drive.google.com/file/d/1wKSrun-GlxirS31Z9qo Hazb9tC440AZF/view?usp=sharing]

Chapter 9 Solutions

Modern Database Management

Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage