Content deleted Content added
→Dimension Normalization: Capitalization |
No edit summary |
||
Line 1:
{{Page numbers improve|date=June 2018}}
{{Use dmy dates|date=July 2018}}
'''Dimensional modeling''' ('''DM''') is part of the ''Business Dimensional Lifecycle'' methodology developed by [[Ralph Kimball]] which includes a set of methods, techniques and concepts for use in [[data warehouse]] design.<ref name="ConBegg9"/>{{rp|1258-1260}}<ref name="MoodyKokink-1">{{cite web|url=http://neumann.hec.ca/sites/cours/6-060-00/MK_entreprise.pdf|title=From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design|id=Dimensional Modelling|access-date=3 July 2018|first1=Daniel L.|last1=Moody|first2=Mark A.R.|last2=Kortink|url-status=live|archive-url=https://web.archive.org/web/20170517164505/http://neumann.hec.ca/sites/cours/6-060-00/MK_entreprise.pdf|archive-date=17 May 2017|df=dmy-all}}</ref> The approach focuses on identifying the key [[business process]]es within a business and modelling and implementing these first before adding additional business processes, a bottom-up approach.<ref name="ConBegg9"/>{{rp|1258-1260}} An alternative approach from [[Bill Inmon|Inmon]] advocates a top down design of the model of all the enterprise data using tools such as [[entity-relationship model]]ing (ER).<ref name="ConBegg9">{{cite book|title=Database Systems - A Practical Approach to Design, Implementation and Management|first1=Thomas|last1=Connolly|first2=Carolyn|last2=Begg|publisher=Pearson|isbn=978-1-292-06118-4|edition=6th|at=Part 9 Business Intelligence|date=26 September 2014|df=dmy-all}}</ref>{{rp|1258-1260}}
==Description==
| |||