Talk:Data mart

From Wikipedia, the free encyclopedia
Jump to: navigation, search
WikiProject Computing (Rated Start-class)
WikiProject icon This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 ???  This article has not yet received a rating on the project's importance scale.
 
WikiProject Databases / Computer science  (Rated C-class, High-importance)
WikiProject icon This article is within the scope of WikiProject Databases, a collaborative effort to improve the coverage of database related articles on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 High  This article has been rated as High-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Computer science (marked as High-importance).
 

tzeh 5.jan.2004 wrote


A data mart is not a (logical) part of a data warehose (as described in the entry "data warehouse").

A data mart (physical) extract of the data warehouse which is made for separate purpuses.

These purposes may be:

  • special structure: e.g. OLAP für multidimensional analysis
  • special content: e.g. reduced parts of a huge data warehouse analogue to an user view
  • performance: separate handling on separete processional units (computers)
  • security: opening data for more or other users


Clean Up?[edit]

Is there anyway to request that this articled be cleaned up? The differing opinions of this Imnon person splashed about on the page give the otherwise straight-forward article an appearance of having been tagged by graffiti artists.

~~Flora

The article, which is opnionated and not factual, needs to be rewritten.

Martyn R Jones

Biased discussion[edit]

I've marked this article as needing a Neutral Point Of View. I've just starting to read up on the subjects of Data Warehousing and Data Marts, so I'm not yet capable of fixing this article.

Meanwhile, read some articles by the "opponent": http://www.dbmsmag.com/artin303.html#A000024

Michel Jansen

sorry, but you are basically saying that this article is not neutral but that you have no idea why. If you can't correct it or know what to add, then remove the NPOV banner--38.98.68.18 14:11, 21 September 2006 (UTC)
IMO, The NPOV should remain, if only for the simple reason that Kimball has a quite different definition for datamarts, and since he bases his whole DWH approach on data marts it's sort of crucial to incorporate his POV. If only, because so many existing data marts are built on those principles. RonaldKunenborg (talk) 14:12, 9 July 2009 (UTC)

Biased[edit]

This article is biased. I think the Inmon "school of thought" is too pretentious. Mention of his name and a link to http://en.wikipedia.org/wiki/Bill_Inmon are both definitely in order given the significance of his contributions to the field, but he is by no means the sole authority on the subject. Just as important are references to Dr. Ralph Kimball and his work.

The Misconceptions section needs references.

Under 'Dependent Data Mart' there is a sentence reading "[...] a data warehouse team is inept and unable to create a usable data warehouse." I argue that 'unable' alone would convey the same meaning and in fact be more applicable: ineptitude can certainly be a cause for inability but I don't think this article should speculate on that matter.

--Ralgara 17:38, 26 July 2006 (UTC)

Wrong! The importance of Kimball is in the field of dimensional modeling and SQL, not in data warehousing. —Preceding unsigned comment added by 83.34.66.146 (talk) 15:53, 9 September 2007 (UTC)

Excuse me? Did you even google Kimball? Try reading 'The Data Warehouse Lifecycle Toolkit' or any of his other numerous books on the subject. There are just as many data warehouses based on his ideas as there are on those of Inmon. Nowadays they grow closer, but still. Divorcing dimensional modelling and SQL from the concept of datawarehousing seems weird to me as well, unless you restrict the definition of 'data warehouse' to just the storage area for the data. In most definitions it's a bit more involved than just that. RonaldKunenborg (talk) 14:16, 9 July 2009 (UTC)

Data Mart Complexity[edit]

It appears to me that the article is trying to convey too much meaning.

The concept linking seperate Data Marts (DM) to provide the functionality of an Enterprise Data Warehouse (EDW) is a comparison of Centralised vs Federated warehousing architectures and seems much less relevant to a posting on DM.

The comment on the Bill Inmon bias is valid. His views are pivotal but need to be ballanced with other major contributors.

My apologies for not feeling sufficiently competent to offer a re-write and only this comment. It does need help.

--HooglBoogl 08:31, 25 September 2006 (UTC)

Merge[edit]

Propose merging this with Data warehouse article. Comments? SqlPac 14:44, 17 May 2007 (UTC)

Definitely NOT to be merged. As pointed out on top, data marts and data warehouses are distinct entities, not to be confused. The fact that the distinction is often unclear makes this article more important.Nshuks7 20:32, 1 November 2007 (UTC)

A Data Mart is a component in Enterprise Data Warehousing, and is a subject that probably deserves its own article. However, it would be wise to treat the subject in terms of information management, data integration and IT engineering terms, rather than focusing too much on the more "pragmatic" and somewhat limiting approach of building data marts with no corresponding data warehouse. Martyn R Jones

Sounds wonderful! Feel free to Be Bold and contribute a treatment of the subject in terms of information management, data integration and IT engineering terms!SqlPac (talk) 20:33, 28 June 2008 (UTC)

star schema and snowflake schema Articles Badly in Need of Help[edit]

The articles for star schema and snowflake schema, which might be considered "sister articles" for this one are badly in need of help. I'm posting the request here because I figure the good people editing this article will have be more likely to take an interest in these other related articles. Thanks. SqlPac (talk) 05:13, 24 June 2008 (UTC)

Copyright problem removed[edit]

Prior content in this article duplicated one or more previously published sources. The material was copied from: http://searchsqlserver.techtarget.com/definition/data-mart. Infringing material has been rewritten or removed and must not be restored, unless it is duly released under a compatible license. (For more information, please see "using copyrighted works from others" if you are not the copyright holder of this material, or "donating copyrighted materials" if you are.) For legal reasons, we cannot accept copyrighted text or images borrowed from other web sites or published material; such additions will be deleted. Contributors may use copyrighted publications as a source of information, but not as a source of sentences or phrases. Accordingly, the material may be rewritten, but only if it does not infringe on the copyright of the original or plagiarize from that source. Please see our guideline on non-free text for how to properly implement limited quotations of copyrighted text. Wikipedia takes copyright violations very seriously, and persistent violators will be blocked from editing. While we appreciate contributions, we must require all contributors to understand and comply with these policies. Thank you. NortyNort (Holla) 11:00, 3 June 2011 (UTC)