What is the difference between a database and a data warehouse? Take a small representative database from any organization and try to convert it into a data warehouse. What are the visible advantages that you can make out?

Chuck Kelley's Answer:

Your question does not quite fit. A data warehouse is a logical construct which specifies how the data is used that is physically implemented in a database. A database is the physical aspects of your data regardless of whether that data is used for OLTP, OLAP, MDM, etc.

Anne Marie Smith's Answer:

A data warehouse is a computer system designed for archiving and analyzing an organization's historical data, such as sales, salaries or other information from day-to-day operations. It is much more than just a database, since a data warehouse includes tools that are used to take data from existing data sources (databases, flat files, etc.) load that chosen data into the data warehouse, give access to the data for users and perform maintenance on the data warehouse. A database is a collection of records stored in a computer in a systematic way, so that a computer program can use it to perform operations. A database can be designed for transactional work or for decision-making (e.g., a data warehouse database). Most data warehouses combine data from multiple sources from multiple periods of time (spanning several years in many cases), so taking one database from an organization and converting it to a data warehouse is not a practical approach.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access