Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Q1: Information package diagrams are very helpful in the data warehouse. discuss that.

Q1: Information package diagrams are very helpful in the data warehouse. discuss that.

Principles of Information Systems (MindTap Course List)
Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Big Data
Section5.4: Big Data
Problem 2CTQ
See similar textbooks
icon
Related questions
icon
Concept explainers
Question
a |Asiacell 2 data warehouse... data warehouse - 2nd monthly exam Q1: Information package diagrams are very helpful in the data warehouse. discuss that. Q2: What is the main difference between fact table and dimension tables? Q3: select the correct choices (select one only) for the following questions: 1. An extranet • is completely open as the Internet. • is not completely open like the Internet. • it is restricted just for internal use like an intranet. • all the above 2. in MOLAP Model, data for analysis is stored in: • a relational form • rows and columns • a large multidimensional array • none of the above 3. Roll-Up Technique means: • moving data into the OLAP system • manages large amounts of historical data. • provide summaries and aggregations. • all the above 4. Intranet is: • a private network • more secure than the internet • restricted just for internal use. • all the above 5. The response time in OLTP systems is: Very slow • Very fast • Slow than OLAP systems • Depends on analysis processing. Q4: what database design adopted in the OLAP system? Q5: Give an example of a hybrid OLAP server. Q6: does foreign Keys and primary keys are same? explain that.
Transcribed Image Text:a |Asiacell 2 data warehouse... data warehouse - 2nd monthly exam Q1: Information package diagrams are very helpful in the data warehouse. discuss that. Q2: What is the main difference between fact table and dimension tables? Q3: select the correct choices (select one only) for the following questions: 1. An extranet • is completely open as the Internet. • is not completely open like the Internet. • it is restricted just for internal use like an intranet. • all the above 2. in MOLAP Model, data for analysis is stored in: • a relational form • rows and columns • a large multidimensional array • none of the above 3. Roll-Up Technique means: • moving data into the OLAP system • manages large amounts of historical data. • provide summaries and aggregations. • all the above 4. Intranet is: • a private network • more secure than the internet • restricted just for internal use. • all the above 5. The response time in OLTP systems is: Very slow • Very fast • Slow than OLAP systems • Depends on analysis processing. Q4: what database design adopted in the OLAP system? Q5: Give an example of a hybrid OLAP server. Q6: does foreign Keys and primary keys are same? explain that.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Design of User Interface
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
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS