Dimensional modeling: Difference between revisions

Revision as of 20:24, 10 July 2018

Revision as of 20:38, 10 July 2018

Line 1:

{{under construction|comment=following a deprod (see history and talk) issues around [[WP:V|Verifiability]], [[WP:NPOV|Neutral Point of View]], [[WP:PRIMARY|primary sources]] arnd [[WP:SELFPUBLISH|self published sources]] remain and I believe the lede needs work. I have now obtained access to an independent book Begg/Connolly which covers the methodology in some detail and should be useful in reworking the article, but this revision is not trivial. Because of this the under construction template banner will continue remain in place for a few days longer than I would normally hope and I request forebearance. See talk also. Thankyou}}

{{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—12601258-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|dead-url=no|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> ItThe approach focuses on identifying the key business processes within a business and modelling and implementing these first before adding additional business processes, a bottom-up approach.<ref name="ConBegg9"/>{{rp|1258-1260}} is anAn alternative approach from [[Bill Inmon|Inmon]] who 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 Intellence|date=26 September 2014|df=dmy-all}}</ref>{{rp|1258-1260}}

==Description==