Interested to Buy Any Domain ? << Click Here >> for more details...
difference between multi relational OLAP & multidimensional
OLAP
- 1 Answers
- 20079 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
what is the difference between public static void main (String args[]) and static public void main(String args[]) in java?
i can access command prompt in my pc. when i type cmd in run,message comes-you are restricted.contact admin. why is it so? how can acces it by just logging in as a user and not as admin.?????
how the parting surface is selected in injection mould
A bar of steel 24 mm in diameter was subjected to a tensile load of 60 kNs and measured extension on a 20-cm gauge length was 0.009 cm and the change in diameter was 0.00375 cm. Calculate the Bulk modulus?
find the net id and host id of the following IPV4 117.34.3.8 and 132.57.8.6
What is Campus selection process of patni at Adcet,Ashta at 24th dec 2010.Also give apti syllabus.
which type of casting enforces type safety
Hi All... PLease send me if anyone have "Information Security Officer" Aptitude papers. Please Mail me at mannusanghi@gmail.com
how to make resume and what should I include in it?
Please send the details and fee for Intools training course..I would like to do the course in second week of jUNE 2010.
What is diff b/w TON and BTU for Air conditioner?
What is the difference between command line argument and input taking from the user?
Briefly describe an experience of yours that illustrates your ability to clearly articulate and explain technical issues in a nontechnical manner
what size shaft is required to transmit 100 hp @1000 RPM ,if max shear stress is 10,000 PSI,angle of twist must be less than 1' /ft/shaft is made of steel.
plz plz help me "how can i face dell varcent round"....? plzzzzzzzz help me friends.....?
