Editing Data warehouse (section)

=== Data marts ===
A [[data mart]] is a simple data warehouse focused on a single subject or functional area. Hence it draws data from a limited number of sources such as sales, finance or marketing. Data marts are often built and controlled by a single department in an organization. The sources could be internal operational systems, a central data warehouse, or external data.<ref>{{cite web |year=2007 |title=Data Mart Concepts |url=http://docs.oracle.com/html/E10312_01/dm_concepts.htm |publisher=Oracle}}</ref> As with warehouses, stored data is usually not normalized.

{| class="wikitable"
|+ Difference between data warehouse and {{nowrap|data mart}}
|-
! Attribute
! Data warehouse
! Data mart
|-
! style="text-align: left" | Scope of the data
| enterprise
| department
|-
! style="text-align: left" | Number of subject areas
| multiple
| single
|-
! style="text-align: left" | How difficult to build
| difficult
| easy
|-
! style="text-align: left" | Memory required
| larger
| limited
|}

Types of data marts include [[Data mart#Dependent data mart|dependent]], independent, and hybrid data marts.{{clarify |date=March 2017 |reason= }}