up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question

71% accept rate
feedback

2 Answers

up vote 4 down vote accepted

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.

link|improve this answer
+1 for noticing Wikipedia has an entry for each. – KPWINC Sep 30 '09 at 23:16
+1 thanks for introducing me to data marts... I often wondered about portions of data that companies (read Google) could sell – Jenko Oct 1 '09 at 1:08
feedback

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.