The ORM Foundation

Get the facts!

ppt P02 Modeling Slowly Changing Dimensions in ORM

Downloads: 55 File Size: 338kB
Posted By: Ken Evans Views: 1,721
Date Added: Wed, Oct 26 2011

Abstract. A data warehouse is a subject oriented, integrated, non-volatile, and time variant collection of data in support of management's decisions. Dimensional modeling is a design technique used extensively in the design and construction of data warehouses. To account for different requirements there are several standard variations designers may utilize in their dimensional designs such as outriggers, bridge tables, mini-dimensions, slowly changing dimension techniques, etc. Our focus in this paper is on the representation of the dimensional schema as an ORM schema where slowly changing dimension techniques Types 1 and 2 are used. We examine the nature of the ORM schema - its objects, roles, constraints, rules and transactions.


Presented by:


         Ron McFadyen, University of Winnipeg (Canada)


No comments exist for this file.
© 2008-2020 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service