difference between multi relational OLAP & multidimensional
OLAP
Answer Posted / suresh
Sr Relational Modelling Multi-Dimensional Modelling
1 Relational models can be very complex with hundreds
of tables having long chains of relationship among them.
Multidimensional modeling are very simple. Each of
the dimension table has a direct relationship with the fact
table
2 Normal data modeling is quite flexible. The
Multidimensional modeling has a rigid structure
3 One of the goals of relational modeling is to
confirm to the rules of normalization. In a normalized
database each data value is stored only once.
Multidimensional modeling are radically
denormalized. The dimension tables have a high number of
repeated values in their fields.
4 Standard relational models are optimized for On
Line Transaction Processing. OLTP needs the ability to
efficiently update data. This is provided in a normalized
database that has each value stored only once.
Multidimensional modeling are optimized for On Line
Analytical Processing. OLAP needs the ability to retrieve
data efficiently. Efficient data retrieval requires a
minimum number of joins. This is provided with the simple
structure of relationship in a Multidimensional modeling,
where each dimension table is only a single join away from
the fact table.
5 SQL queries required to manipulate relational data
MDX queries required to manipulate multi-
dimensional data
6 Tables are units of relational data storage.
Cubes are units of multi-dimensional data storage.
7 Table fields of particular data type store the
actual data. Dimensions and measures stores actual data.
8 Table size is measured in number of record set.
Cube size is measured in number of Cellsets. In
this sense, MS Excel Pivot Table can accommodate 2,040,000
cellsets (8000 * 255). Considering the summary data to be
reported, this is reasonably large. Pivot Table can report
at the most 8000 different items.
Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
what is the pri request of binary search
Why is not creat swap partition in my system.
what is the differences between software engineering and other engineering disciplines.
program for inter process communicatin using message sharing in unix c
hi i am an CSE engg student and i cleared the PE exam of BEL 2012 both 24/07/012 and 01/08/2012 , so please if someone can help me with PE Interview question or subject or topics which i should cover that help me clear both Interview.PLZ help. my mail id is rjjkumar99@gmail.com
Why does the 'divisibility by 3' rule work?
Friends Any one tell me the best institute for the telecom protocol course
What is the main difference between binary and counting semaphore?
I want old SBI question papers plzzzzzzzzz
Tell me about urself? asked me qstns on my resume what about higher studies any plans? where do u find urself after 3-4
List three things you can do with the files you create by recording your voice on your computer
i want to know about the scope of IT engineers in ONGC
what is compiler
what is the difference betweeen far pointer and near pointer
what are the reseach done by itc brfore launching e-copal