Interested to Buy Any Domain ? << Click Here >> for more details...
What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 19630 Views
- I also Faced
- E-Mail Answers
Answer Posted / sri ram
MDDB stands for Multi Dimensional Database
MDDB: In MDDB, it views data in mutidimensional
(Perspective)i.e.,through various dimensions at a time with
the help of cubes developed using dimensions and stores
data in multidimensional i.e., stores data in power cubes.
In power cubes, each axis is a dimension and each member of
dimension is column.
In MDDB, at a glance we can see the dimensions and data
present in the dimensions
RDDB: In RDDB, it views data in two dimensional and stores
data in two dimensional i.e., in rows and columns in a
table .
In RDDB, we can just see the rows and columns, but only
after issuing select over that u can see the data.
Storage wise:
suppose I have 3 dimensions and 9 rows of data then
in MDDB: takes 9 cells to store the data
in RDDB: takes 27 cells to store the data
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the sequence generator transformation in informatica?
What do you mean incremental aggregation?
How can you define user defied event?
What is the difference between informatica 7.0 and 8.0?
How do you set a varible in incremental aggregation
How does the aggregator transformation handle null values?
Quickly characterize reusable change?
Explain lookup transformation is active in informatica
Briefly explain the aggregator transformation?
What is the difference between router and filter?
What do you mean by channel change?
Performance tuning in UNIX for informatica mappings?
How to generate sequence numbers without using the sequence generator transformation?
