2

I've heard both of these terms used frequently. What is the difference between a Data center vs. a Data warehouse? Are these terms interchangeable?

2 Answers 2

5

You may wish to check out Wikipedia on Data Center and Data Warehouse

A data center or datacenter (or datacentre), also called a server farm,1 is a facility used to house computer systems and associated components, such as telecommunications and storage systems.

and

Data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis

Also a Data Warehouse may host many Data Marts

A data mart is a subset of an organizational data store, usually oriented to a specific purpose or major data subject, that may be distributed to support business needs.

So there can be one or more Data Marts, that exist in a Data Warehouse that is hosted in a Data Center that may contain more than one Data Warehouse plus other services.

2
  • +1 for noticing Wikipedia has an entry for each.
    – KPWINC
    Sep 30, 2009 at 23:16
  • +1 thanks for introducing me to data marts... I often wondered about portions of data that companies (read Google) could sell Oct 1, 2009 at 1:08
2

A data center is a physical facility where (usually) multiple companies' computers are located. It is often so that servers can have a larger-bandwidth Internet connection than the company can get in their own facility, as well as having people dedicated to facilities management, including cooling, power, fire prevention, security, etc.

A data warehouse is a type of database, or a manner of using a database, to collect large amounts of data.

They are not even remotely interchangeable terms.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .