Site home page
(news and notices)

Get alerts when Linktionary is updated

Book updates and addendums

Get info about the Encyclopedia of Networking and Telecommunicatons, 3rd edition (2001)

Download the electronic version of the Encyclopedia of Networking, 2nd edition (1996). It's free!

Contribute to this site

Electronic licensing info

 

 

Data Mart

Related Entries    Web Links    New/Updated Information

  
Search Linktionary (powered by FreeFind)

Note: Many topics at this site are reduced versions of the text in "The Encyclopedia of Networking and Telecommunications." Search results will not be as extensive as a search of the book's CD-ROM.

A data mart is a data warehouse for a single department or division of a company, as compared to a full-blown data warehouse, which attempts to store and make available all the data a company has available. Because full-blown data warehouses are difficult to implement, many companies start with data marts and then combine those data marts into data warehouses at a later date.

A data mart will have anywhere from 50 to 300 GB of data, while a data warehouse will house terabytes of data. A data mart is subject specific and usually departmental, while a data warehouse is a repository for an entire enterprise's data. Data marts are simpler to build and may take less than one year to build, while data warehouses are complex undertakings that may take over a year to build. The cost of a data mart is in the thousands of dollars, while the cost of a data warehouse is in the millions of dollars.

A company called Appsco Software Ltd. claims its software makes data mart construction easy. AppsMart is a rapid application development tool that simplifies data mart construction using most popular SQL Server database applications.




Copyright (c) 2001 Tom Sheldon and Big Sur Multimedia.
All rights reserved under Pan American and International copyright conventions.