Interested to Buy Any Domain ? << Click Here >> for more details...
What is an MDDB? What is the difference between MDDBs and
RDBMSs?
- 3 Answers
- 19771 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
What are the new features of informatica 9.x in developer level?
What is a stored procedure transformation?
Enlist few areas or real-time situations where informatica is required.
What are the components of workflow manager?
How can one identify whether mapping is correct or not without connecting session?
tell me about your project functionality
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the types of data warehouses?
What is decode in static cache?
Differentiate between a database and data warehouse?
Write the advantages of partitioning a session?
Explain how many types of dimensions are available in informatica?
What is an Integration service in Informatica?
What is meant by query override?
How to call shell scripts from informatica?
