data exploration techniques correct answers -Online Analytical Processing (OLAP)
-MOLAP + MDBMS
how data must be stored correct answers -data must be first aggregated
-it must be summarized
-must be able to extract data quickly without a massive table
OLAP correct answers -aggregates infor...
ITSS 4351 Exam 1 || with Error-free Solutions.
data exploration techniques correct answers -Online Analytical Processing (OLAP)
-MOLAP + MDBMS
how data must be stored correct answers -data must be first aggregated
-it must be summarized
-must be able to extract data quickly without a massive table
OLAP correct answers -aggregates information from multiple systems
-stores in multi-dimensional format
-uses star schema and show flak schema concepts to store the data
-a technique can be used to slice and dice information for interrogation
why OLAP correct answers -data warehouse stores tactical information that answers for who,
what regarding past events
-ability to answer the what if and why questions
-enable decision making about future decisions
-transforms data into strategic information
star schema correct answers A data modeling technique used to map multidimensional decision
support data into a relational database
-called its name because diagram has points radiating from center
-provides logical view for multidimensional data models
components of star schema correct answers - facts
- dimensions
- attributes
- attribute hierarchies
fact table correct answers facts of a particular business process or interests used for strategic
decisions
-numeric figure used for measurement or metric of business process
attributes correct answers -used to provide descriptive characteristics about facts from dimension
table
-often used to search, filter, classify facts using dimension tables
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.