Interested to Buy Any Domain ? << Click Here >> for more details...
difference between multi relational OLAP & multidimensional
OLAP
- 1 Answers
- 20190 Views
- I also Faced
- E-Mail Answers
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
can anyone help me with an article or a few pointers on what are the industry expectations from Fresh engineers in today's market scenario
plz plz help me "how can i face dell varcent round"....? plzzzzzzzz help me friends.....?
A polynomials in mamory can be represented by____________
what are the artifacts in coding phase in SDLC????
Write a program in ‘C’ language that will perform the following operation on static stack. 1. push 2. pop 3. Display 4. Exit Create separate functions for each operation. The push() should accept one argument of structure type and will not return any thing. The pop() function will not receive any argument & return structure type value. The stack & top must be declare as external variable. Each element of stack will contain the following information Roll No, Std Name, Course. Use do-while loop & switch case for generating the above menu. The format of the output should is given below: S.No. Roll No. Student Name Course 1 cse01 Anil Singh B.Tech
What is the allowable load carrying capacity of a circular column section of 400 mm diameter reinforced with 6x25 mm diameter bars adequately tied with spirals? Consider concrete of grade M25 and steel of grade Fe 415.
what are the steps u follow to create an custom idoc program in which environment u create the program?
i m doing my 3rd yr with only 6 month left to complete it..within this 6 months which is the best nd useful oracle certification program should i do??pls help me out!!
Difference in NS and TIA type HRC fuses
How do trains go around bends?
what is the need for oobs
what is the concept of c++ class
What is meant by relay & co-ordination at substation engineering ?
when there is a parametrized constructor, and an object is created with no arguments. will the default constructor be called?
what is the use of typedef in c language?
