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
23:12 Chegg content://org.teleg + 5G 5G 80% New question A feed of 60 mol% methanol in water at 1 atm is to be separated by dislation into a liquid distilate containing 98 mol% methanol and a bottom containing 96 mol% water. Enthalpy and equilibrium data for the mixture at 1 atm are given in Table Q2 below. Ask an expert (a) Devise a procedure, using the enthalpy-concentration diagram, to determine the minimum number of equilibrium trays for the condition of total reflux and the required separation. Show individual equilibrium trays using the the lines. Comment on why the value is Independent of the food condition. Recent My stuff Mol% MeOH, Saturated vapour Table Q2 Methanol-water vapour liquid equilibrium and enthalpy data for 1 atm Enthalpy above C˚C Equilibrium dala Mol% MeOH in Saturated liquid TC kJ mol T. "Chk kot) Liquid T, "C 0.0 100.0 48.195 100.0 7.536 0.0 0.0 100.0 5.0 90.9 47,730 928 7,141 2.0 13.4 96.4 Perks 10.0 97.7 47,311 87.7 8,862 4.0 23.0 93.5 16.0 96.2 46,892 84.4…
You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, and country. You want to retrieve the first 3 letters of each country name. You decide to use the SUBSTR function to retrieve the first 3 letters of each country name, and use the AS command to store the result in a new column called new_country.  You write the SQL query below. Add a statement to your SQL query that will retrieve the first 3 letters of each country name and store the result in a new column as new_country.
We are considering the RSA encryption scheme. The involved numbers are small, so the communication is insecure.  Alice's public key (n,public_key) is (247,7). A code breaker manages to factories  247 = 13 x 19  Determine Alice's secret key. To solve the problem, you need not use the extended Euclid algorithm, but you may assume that her private key is one of the following numbers 31,35,55,59,77,89.
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