Modern Database Management (12th Edition)
Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
bartleby

Concept explainers

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

Define each of the following terms:

a. data warehouse

b. data mart

c. reconciled data

d. derived data

e. enterprise data warehouse

f. real-time data warehouse

g. star schema

h. snowflake schema

i. grain

j. conformed dimension

Expert Solution & Answer
Check Mark

Explanation of Solution

Data warehouse: It 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.

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.

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.

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

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.

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.

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 center and multiple dimensional table are connected to the center fact table.

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

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”

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.

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
this project is NOT for graded(marks) purposes, please help me with the introduction. give me answers for the project. i will include an image explaining everything about the project.
Java Graphics (Bonus In this lab, we'll be practicing what we learned about GUIs, and Mouse events. You will need to implement the following: A GUI with a drawing panel. We can click in this panel, and you will capture those clicks as a Point (see java.awt.Point) in a PointCollection class (you need to build this). The points need to be represented by circles. Below the drawing panel, you will need 5 buttons: O о о ○ An input button to register your mouse to the drawing panel. A show button to paint the points in your collection on the drawing panel. A button to shift all the points to the left by 50 pixels. The x position of the points is not allowed to go below zero. Another button to shift all the points to the right 50 pixels. " The x position of the points cannot go further than the You can implement this GUI in any way you choose. I suggest using the BorderLayout for a panel containing the buttons, and a GridLayout to hold the drawing panel and button panels. Regardless of how…
also provide the number of moves(actions) made at state A and moves(actions) made state B. INCLUDE Java program required(this question is not graded)
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
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education