Differentiation between Dimensional Modeling and ER Modeling
Give a brief differentiation between Dimensional Modeling and ER Modeling?
Expert
Dimensional modeling is extremely flexible for the user viewpoint. Dimensional data model is mapped for making schemas. Whereas, ER Model is not mapped for making schemas and doesn’t employ in conversion of normalization of data into demoralized forms.
ER Model is employed for OLTP databases which utilizes any of the first or second or third normal forms, where as dimensional data model is used for data warehousing and uses third normal form.
ER model holds normalized data whereas Dimensional model holds denormalized data.
Explain the calculation contexts?
Why recursive relationships are not good? How do you solve them?
Illustrates the difference between a user’s defined function and a stored procedure?
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
Specify the major components of the Designer Interface?
What is Redundant Array of Inexpensive Disks controller technology?
Describe briefly the term maximum and minimum cardinality?
Give a brief introduction of the term real time data-warehousing?
Give definition of data structure?
Illustrates the quickest sorting method to use?
18,76,764
1929970 Asked
3,689
Active Tutors
1440774
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!