What kind of costs are involved in Data Marting?
Data Marting involves hardware & software cost, network access cost, and time cost.
What are the reasons for partitioning?
Partitioning is done for various reasons such as easy management, to assist backup recovery, to enhance performance.
What language is the base of DMQL?
DMQL is based on Structured Query Language (SQL).
Which language is used for defining Schema Definition?
Data Mining Query Language (DMQL) is used for Schema Definition.
Out of star schema and snowflake schema, whose dimension table is normalized?
Snowflake schema uses the concept of normalization.
What is Normalization?
Normalization splits up the data into additional tables.
How many fact tables are there in a star schema?
There is only one fact table in a star Schema.
How many dimensions are selected in dice operation?
For dice operation two or more dimensions are selected for a given cube.
Dice is a sub-cube from the OLAP cube by selecting two or more dimensions
List the functions performed by OLAP.
OLAP performs functions such as roll-up, drill-down, slice, dice, and pivot.
Which one is faster, Multidimensional OLAP or Relational OLAP?
Multidimensional OLAP is faster than Relational OLAP.