You do not have permission to edit this page, for the following reasons:

This IP address has been blocked from editing Wikipedia.
This does not affect your ability to read Wikipedia pages.
Most people who see this message have done nothing wrong. Some kinds of blocks restrict editing from specific service providers or telecom companies in response to recent abuse or vandalism, and can sometimes affect other users who are unrelated to that abuse. Review the information below for assistance if you do not believe that you have done anything wrong.

The IP address or range 34.205.0.0/16 has been blocked (disabled) by ‪ST47‬ for the following reason(s):

The IP address that you are currently using has been blocked because it is believed to be a web host provider. To prevent abuse, web hosts may be blocked from editing Wikipedia.
You will not be able to edit Wikipedia using a web host provider because it hides your IP address, much like a proxy or VPN.
We recommend that you attempt to use another connection to edit. For example, if you use a proxy or VPN to connect to the internet, turn it off when editing Wikipedia. If you edit using a mobile connection, try using a Wi-Fi connection, and vice versa. If you are using a corporate internet connection, switch to a different Wi-Fi network. If you have a Wikipedia account, please log in.
If you do not have any other way to edit Wikipedia, you will need to request an IP block exemption.

How to appeal if you are confident that your connection does not use a web host's IP address:
If you are confident that you are not using a web host, you may appeal this block by adding the following text on your talk page: ((unblock|reason=Caught by a web host block but this host or IP is not a web host. My IP address is _______. Place any further information here. ~~~~)). You must fill in the blank with your IP address for this block to be investigated. Your IP address can be determined here. Alternatively, if you wish to keep your IP address private you can use the unblock ticket request system. There are several reasons you might be editing using the IP address of a web host (such as if you are using VPN software or a business network); please use this method of appeal only if you think your IP address is in fact not a web host.

Administrators: The IP block exemption user right should only be applied to allow users to edit using web host in exceptional circumstances, and they should usually be directed to the functionaries team via email. If you intend to give the IPBE user right, a CheckUser needs to take a look at the account. This can be requested most easily at SPI Quick Checkuser Requests. Unblocking an IP or IP range with this template is highly discouraged without at least contacting the blocking administrator.

This block will expire on 05:44, 30 September 2026.

Even when blocked, you will usually still be able to edit your user talk page, as well as email administrators and other editors.

For information on how to proceed, please read the FAQ for blocked users and the guideline on block appeals. The guide to appealing blocks may also be helpful.

Other useful links: Blocking policy · Help:I have been blocked
Your IP address is in a range that has been blocked on all Wikimedia Foundation wikis. The block was made by ‪Jon Kolbert‬. The reason given is Open proxy/Webhost: See the help page if you are affected .
- Start of block: 05:38, 21 February 2024
- Expiry of block: 05:38, 21 February 2029
Your current IP address is 34.205.141.108. The blocked range is 34.205.0.0/16. Please include all above details in any queries you make. If you believe you were blocked by mistake, you can find additional information and instructions in the No open proxies global policy. Otherwise, to discuss the block please post a request for review on Meta-Wiki. You could also send an email to the stewards VRT queue at stewards@wikimedia.org including all above details.

You can view and copy the source of this page:

((confused|Enterprise service bus))
((Multiple issues|
((weasel|date=December 2010))
((cleanup|date=December 2010))
))

The '''enterprise bus matrix''' is a [[data warehouse]] planning tool and model created by [[Ralph Kimball]], and is part of the data warehouse bus architecture. The matrix is the logical definition of one of the core concepts of Kimball’s approach to [[dimensional modeling]] [[conformed dimension]].<ref>((cite web|url=http://www.kimballgroup.com/2003/09/15/design-tip-49-off-the-bench/ |archive-url=https://archive.today/20130216080251/http://www.kimballgroup.com/2003/09/15/design-tip-49-off-the-bench/ |url-status=dead |archive-date=2013-02-16 |title=Design Tip #49: Off The Bench |publisher=Kimball Group |date=2003-09-15 |accessdate=2015-05-22 ))</ref>

The bus matrix defines part of the data warehouse bus architecture and is an output of the [[business requirements]] phase in [[the Kimball lifecycle]]. It is applied in the following phases of [[dimensional modeling]] and development of the data warehouse. The matrix can be categorized as a hybrid model, being part technical design tool, part project management tool and part communication tool<ref name="Kimball">Kimball, Ralph & Ross, Margy; The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition John Wiley & Sons, 2002</ref>

==Background==
The need for an enterprise bus matrix stems from the way one goes about creating the overall data warehouse environment. Historically there have been two approaches: a structured, centralized and planned approach and a more loosely defined, department specific approach, in which solutions are developed in a more independent matter. Autonomous projects can result in a range of isolated stove pipe data marts. Naturally each approach has its issues; the visionary approach often struggles with long delivery cycles and lack of reaction time as needs emerge and scope issues arise. On the other hand, the development of isolated data marts leads to [[stovepipe system]]s that lack synergy in development. Over time this approach will lead to a so-called data-mart-in-a-box architecture<ref>[http://www.mimno.com/avoiding-mistakes3.html#6] ((webarchive |url=https://web.archive.org/web/20100704220014/http://www.mimno.com/avoiding-mistakes3.html#6 |date=July 4, 2010 ))</ref> where [[interoperability]] and lack of cohesion is apparent, and can hinder the realization of an overall enterprise data warehouse. As an attempt to handle this issue, [[Ralph Kimball]] introduced the enterprise bus.

==Description==
The bus matrix purpose is one of high abstraction and visionary planning on the data warehouse architectural level. By dictating coherency in the development and implementation of an overall data warehouse the bus architecture approach enables an overall vision of the broader enterprise integration and consistency while at the same time dividing the problem into more manageable parts<ref name="Kimball" /> – all in a technology and software independent manner.<ref>((cite web|url=http://www.b-eye-network.com/view/713 |title=Data Warehouse: Ralph Kimball's Vision by Katherine Drewek |publisher=Beyenetwork |date=2005-03-16 |accessdate=2015-05-22))</ref>

The bus matrix and architecture builds upon the concept of conformed dimensions, creating a structure of common dimensions that ideally can be used across the enterprise by all business processes related to the data warehouse and the corresponding fact tables from which they derive their context. According to Kimball and Margy Ross's article “Differences of Opinion”<ref>((cite web|url=http://intelligent-enterprise.informationweek.com/showArticle.jhtml;jsessionid=0OVJNEHMPRXGRQE1GHRSKH4ATMY32JVN?articleID=17800088 |title=Enterprise Software News, Analysis, & Advice - InformationWeek |publisher=Intelligent-enterprise.informationweek.com |date= |accessdate=2015-05-22))</ref> "''The Enterprise Data warehouse built on the bus architecture ”identifies and enforces the relationship between business process metrics (facts) and descriptive attributes (dimensions)''”.

The concept of a [[Bus (computing)|bus]] is well known in the language of [[information technology]], and is what reflects the conformed dimension concept in the data warehouse, creating the skeletal structure where all parts of a system connect, ensuring [[interoperability]] and consistency of data, and at the same time considers future expansion. This makes the conformed dimensions act as the integration ‘glue’, creating a robust backbone of the enterprise Data Warehouse.<ref>((cite web|url=http://intelligent-enterprise.informationweek.com/showArticle.jhtml;jsessionid=GMS3H4SOBFQBBQE1GHOSKH4ATMY32JVN?articleID=17800088&pgno=2 |title=Enterprise Software News, Analysis, & Advice - InformationWeek |publisher=Intelligent-enterprise.informationweek.com |date= |accessdate=2015-05-22))</ref>

==Establishment and applicability==
((cleanup|section|reason=refers to figures not present|date=June 2022))
Figure 1<ref>((cite web |url=http://www.widama.us/Documents/Kimball-DimensionalModeling.PDF |title=Dimensional Modeling Overview |author=Bob Becker |publisher=Widama.is |accessdate=2015-05-22 |url-status=dead |archiveurl=https://web.archive.org/web/20130322224742/http://www.widama.us/Documents/Kimball-DimensionalModeling.PDF |archivedate=2013-03-22 ))</ref> shows the base for a single document planning tool for the whole of the data warehouse implementation - a graphical overview of the enterprises core business processes or events each correspond to a measurement table of facts, that typically is complemented by a major source system in the horizontal rows. In the vertical columns the groups of contextual data is found as the common, conformed dimensions.

In this way the shared dimensions are defined, as each process indicates what dimensions it applies to through the cells figure 2.<ref name="Kimball" /> By this definition and coordination of conformed dimensions and processes the development of the overall data DW bus architecture is realized.<ref name="Kimball" /> The matrix identifies the shared dimensions related to processes and fact tables, and can be a tool for planning, prioritizing what needs to be approached, coordinating implementation and communicating the importance for conformed dimensions.

Kimball extends the matrix bus in detail as seen in figure 3<ref name="Kimball"/> by introducing the other steps of the datawarehouse methodology; the [[fact table]]s, [[granularity]], and at last the description of the needed facts. Description of the fact tables, granularity and fact instances of each process, structuring and specifying what is needed across the enterprise in a more specific matter, further exemplifying how the matrix can be used as a planning tool.

== See also ==
* [[The Kimball lifecycle]], a high-level sequence tasks used to design, develop and deploy a data warehouse or business intelligence system
==References==
((Reflist))

((Data warehouses))

((DEFAULTSORT:Enterprise bus matrix))
[[Category:Business intelligence terms]]
[[Category:Data management]]
[[Category:Data warehousing]]

Pages transcluded onto the current version of this page (help):

Enterprise bus matrix (edit)
Template:Ambox (view source) (template editor protected)
Template:Category handler (view source) (protected)
Template:Cite web (view source) (protected)
Template:Cleanup (view source) (template editor protected)
Template:Confused (view source) (extended confirmed protected)
Template:DMC (view source) (template editor protected)
Template:DMCA (view source) (template editor protected)
Template:Data warehouses (edit)
Template:Dated maintenance category (view source) (template editor protected)
Template:Dated maintenance category (articles) (view source) (template editor protected)
Template:Distinguish (view source) (template editor protected)
Template:FULLROOTPAGENAME (view source) (template editor protected)
Template:Hlist/styles.css (view source) (protected)
Template:Main other (view source) (protected)
Template:Multiple issues (view source) (template editor protected)
Template:Multiple issues/styles.css (view source) (template editor protected)
Template:Navbox (view source) (template editor protected)
Template:Navbox with collapsible groups (view source) (template editor protected)
Template:Ns has subpages (view source) (protected)
Template:Reflist (view source) (protected)
Template:Reflist/styles.css (view source) (protected)
Template:SUBJECTSPACE formatted (view source) (template editor protected)
Template:Terminate sentence (view source) (template editor protected)
Template:Weasel (view source) (template editor protected)
Template:Webarchive (view source) (template editor protected)
Module:Arguments (view source) (protected)
Module:Category handler (view source) (protected)
Module:Category handler/blacklist (view source) (protected)
Module:Category handler/config (view source) (protected)
Module:Category handler/data (view source) (protected)
Module:Category handler/shared (view source) (protected)
Module:Check for unknown parameters (view source) (protected)
Module:Citation/CS1 (view source) (protected)
Module:Citation/CS1/COinS (view source) (protected)
Module:Citation/CS1/Configuration (view source) (protected)
Module:Citation/CS1/Date validation (view source) (protected)
Module:Citation/CS1/Identifiers (view source) (protected)
Module:Citation/CS1/Utilities (view source) (protected)
Module:Citation/CS1/Whitelist (view source) (protected)
Module:Citation/CS1/styles.css (view source) (protected)
Module:Distinguish (view source) (template editor protected)
Module:Format link (view source) (template editor protected)
Module:Hatnote (view source) (template editor protected)
Module:Hatnote/styles.css (view source) (template editor protected)
Module:Hatnote list (view source) (template editor protected)
Module:Message box (view source) (protected)
Module:Message box/ambox.css (view source) (protected)
Module:Message box/configuration (view source) (protected)
Module:Namespace detect/config (view source) (protected)
Module:Namespace detect/data (view source) (protected)
Module:Navbar (view source) (protected)
Module:Navbar/configuration (view source) (protected)
Module:Navbar/styles.css (view source) (protected)
Module:Navbox (view source) (template editor protected)
Module:Navbox/configuration (view source) (template editor protected)
Module:Navbox/styles.css (view source) (template editor protected)
Module:Navbox with collapsible groups (view source) (template editor protected)
Module:Ns has subpages (view source) (protected)
Module:String (view source) (protected)
Module:TableTools (view source) (protected)
Module:Text (view source) (template editor protected)
Module:Unsubst (view source) (protected)
Module:Webarchive (view source) (template editor protected)
Module:Webarchive/data (view source) (template editor protected)
Module:Yesno (view source) (protected)

Return to Enterprise bus matrix.

Retrieved from "https://en.wikipedia.org/wiki/Enterprise_bus_matrix"