We will send you updates on Dimensional Modeling and E-R Modeling In The Data Warehouse and also updates on other new papers uploaded into this site. Click here to Subscribe to Paper Presentations for Engineering Students by Email and recieve daily updates.
Abstract: Dimensional Modeling (DM) is a favorite modeling technique in data warehousing. In DM, a model of tables and relations is constituted with the purpose of optimizing decision support query performance in relational databases, relative to a measurement or set of measurements of the outcome(s) of the business process being modeled. In contrast, conventional E-R models are constituted to (a) remove redundancy in the data model, (b) facilitate retrieval of individual records having certain critical identifiers, and (c) therefore, optimize On-line Transaction Processing (OLTP) performance.
0 comments:
Post a Comment