Data Mart

Data Mart : A subset of enterprise data along with software to extract data from a data warehouse or operational data store, summarise and store it, and to analyse and present information to support trend analysis and tactical decisions and processes. The scope can be that of a complete data subject such as Customer or Product Sales, or of a particular business area or line of business, such as Retail Sales. A data mart architecture, whether subject or business area, must be an enterprise-consistent architecture. 

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 21-Jan-2009 11:09

---

These advertisers support this free service

---

Data Mart - 1) A subset of highly summarized data from the data warehouse designed to support the specific requirements of an organization. 2) A small database warehouse.

[Category=Data Management ]

Source: Northwest Database Services, 07 November 2009 11:41:55, http://www.nwdatabase.com/database-glossary-d.htm

---

Data Mart - A repository of data gathered from operational data and other sources. The data may derive from an enterprise-wide database or data warehouse or from more specialized sources. The emphasis of a data mart is on meeting the expectations and needs of a particular group of users, so it may be designed to assist them in performing analysis and understanding the content.

[Category=Data Governance ]

Source: The Data Governance Institute, 26 November 2009 08:56:32, http://www.datagovernance.com/glossary-governance/

---

Data Mart - Also Known As: Local Data Warehouse or Datamart

A database that has the same characteristics as a data warehouse, but is usually smaller and is focused on the data for one division or one workgroup within an enterprise.

There are three different (and somewhat contradictory) views of the place of the data mart in the world of data warehousing. 1. The data warehouse gathers all the information from the various legacy systems. Specialized data marts are then created with a subset of the information in the data warehouse. These data marts are easier to use because they only have the particular information the specific user group needs. The use of several data marts also allows the querying load to be spread among several different computers. This can reduce network traffic.

2. Free-standing data marts are created, independent from a data warehouse. The information for the data mart probably comes from just one legacy system. It is quicker and cheaper to build a separate data mart instead of building an enterprise-wide data warehouse with data marts derived from it. The drawback of this solution is that the company's data is not integrated (and thereby violates one of Bill Inmon's original defining characteristics of the data warehouse). If several separate data marts are built using this strategy, they will usually contain data that is duplicated and inconsistent.

3. The data mart is the prototype or the first step of a data warehousing process. An enterprise picks the division or group that would most benefit from data-based knowledge. A data mart is built with that group's data. Additional types of information are added to the data mart as time goes on until it is turned into a data warehouse.

New terminology is often created and developed for marketing purposes. The term 'data mart' probably has a marketing advantage over the term 'data warehouse'. The whole data warehousing process is about creating data-based knowledge and bringing that knowledge to people. A warehouse is a place where things are stored away. A mart is a convenient place to buy something. Most data warehousing professionals (including myself) include ready access to information as a defining characteristic of the term 'data warehouse'. I think, though, that the term 'data mart' captures this sense of data availability more effectively.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 06 May 2010 10:00:01, SDG Computing, now offline

---

Data Marts - is a repository of data gathered from operational data and other sources that is designed to serve a particular community of knowledge workers. The emphasis of a data mart is on meeting the specific demands of a particular group of knowledge users in terms of analysis, content, presentation, and ease-of-use.

[Category=Data Cleansing ]

Source: X4DB, 16 May 2010 10:50:06, http://www.x4db.com/glossary.html

---

Data Mart - A subset of the data resource, usually oriented to a specific purpose or major data subject, that may be distributed to support business needs.

[Category=Information Management ]

Source: Information-Management.com, 11 June 2010 11:02:24, http://www.information-management.com/glossary/d.html

---

Data Mart - A subset of the data resource, usually oriented to a specific purpose or major data subject, that may be distributed to support business needs. The concept of a data mart can apply to any data whether they are operational data, evaluational data, spatial data, or metadata.

[Category=Data Warehousing ]

Source: Sun.com, 23 July 2010 11:24:56, http://www.sun.com/third-party/dw/brochures/67198.Acrobat.pdf

---

Data Mart - A subset of the data resource, usually oriented to a specific purpose or major data subject, that may be distributed to support business needs.

[Category=Data Management ]

Source: DataMentors, 17 August 2010 09:18:09, http://www.datamentors.com/News-and-Resources/Glossary.html

---

Data Mart - A data warehouse data class organized for a business functional area or department. The database contains data summarized at multiple levels of granularity and may be designed using relational or multidimensional database structures.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 20 November 2010 08:04:25, http://www.aexis.eu/DataWarehouse-Glossary/

---

Data Mart - A data mart is a logical subset of related information, usually built around one or a few business processes, or a specific subject area.  An example is the Student Income Data Mart, which holds student and income details for UofT Graduate and Undergraduate Students.

[Category=Business Intelligence ]

Source: University of Toronto Business Intelligence, 24 October 2012 09:35:37, http://www.utbi.utoronto.ca/gethelp/glossary.htm

---

Data Mart - A data mart (DM) is a specialized version of a data warehouse (DW). Like data warehouses, data marts contain a snapshot of operational data that helps business people to strategise based on analyses of past trends and experiences. The key difference is that the creation of a data mart is predicated on a specific, predefined need for a certain grouping and configuration of select data. A data mart configuration emphasizes easy access to relevant information.

[Category=Business Intelligence ]

Source: ElegantJ BI Business Intelligence, 28 October 2012 09:31:43, http://www.elegantjbi.com/resources/glossary_a.htm

---

Data Mart - A data mart is typically a smaller, more focused version of a data warehouse (see below). Data marts bring together data for a single business unit or user group for the purposes of analysis. For instance, you might create a data mart to analyze the operational processing times by step and product for a single business unit. This might help management glean knowledge of long running steps or maybe justify a new piece of equipment.

[Category=Business Intelligence ]

Source: Deanna Dicken, 07 November 2012 09:42:59, http://www.databasejournal.com/features/mssql/article.php/3919011/Business-Intelligence-Terminology-101.htm  

---

data mart (datamart) - A data mart is a repository of data gathered from operational data and other sources that is designed to serve a particular community of knowledge workers. In scope, the data may derive from an enterprise-wide database or data warehouse or be more specialized. The emphasis of a data mart is on meeting the specific demands of a particular group of knowledge users in terms of analysis, content, presentation, and ease-of-use. Users of a data mart can expect to have data presented in terms that are familiar.

In practice, the terms data mart and data warehouse each tend to imply the presence of the other in some form. However, most writers using the term seem to agree that the design of a data mart tends to start from an analysis of user needs and that a data warehouse tends to start from an analysis of what data already exists and how it can be collected in such a way that the data can later be used. A data warehouse is a central aggregation of data (which can be distributed physically); a data mart is a data repository that may derive from a data warehouse or not and that emphasizes ease of access and usability for a particular designed purpose. In general, a data warehouse tends to be a strategic but somewhat unfinished concept; a data mart tends to be tactical and aimed at meeting an immediate need.

One writer, Marc Demerest, suggests combining the ideas into a Universal Data Architecture (UDA). In practice, many products and companies offering data warehouse services also tend to offer data mart capabilities or services.

Related glossary terms: Binary Large Object (BLOB), data structure, catalog, CMAScript (European Computer Manufacturers Association Script), Visual FoxPro, segment, block, flat file

[Category=Data Management ]

Source: WhatIs.com, 20 July 2013 10:35:07, http://whatis.techtarget.com/glossary/Data-and-Data-Management

---

data mart - The access layer of a data warehouse used to provide data to users.

[Category=Big Data ]

Source: DataInformed, 23 October 2013 09:40:48, http://data-informed.com/glossary-of-big-data-terms/