DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Star schema
|
|
|
Snow flake schema
|
|
|
Both Star and Snow flake Schema
|
|
|
Database
|
Detailed explanation-1: -A cube, which is derived from a cube model, precisely defines an OLAP cube and contains a subset of metadata objects that are based on the metadata objects in the cube model. Cubes are the primary OLAP objects that are queried against a Cubing Services Cube Server using the MDX query language.
Detailed explanation-2: -The data source for all Service Manager OLAP cubes is the data marts, which includes the data marts for both Operations Manager and Configuration Manager.
Detailed explanation-3: -For OLAP analysis, a cube model is built to represent a relational star schema or snowflake schema. A cube model contains metadata objects that describe relationships in the relational data.
Detailed explanation-4: -Data cubes are multidimensional data models that hold summarised or aggregated information in a way that makes it easier for online analytical processing (OLAP) tools to perform analyses quickly and efficiently. Data cubes save time in online research by storing computed data in a standardized format.
Detailed explanation-5: -Difference between Star Schema and data cubes: Star schema is a dimensional modeling technique. It contains, Dimensions and Facts (business measurements). Mostly used in Data warehouse technology. Data cube is a multi-dimensional table.