What is the difference between a database and a da

Question

What is the difference between a database and a data warehouse?

Aren't they the same thing, or at least written in the same thing (ie. Oracle RDBMS)?

Answer 1

Source for the Data warehouse can be cluster of Databases, because databases are used for Online Transaction process like keeping the current records..but in Data warehouse it stores historical data which are for Online analytical process.

Answer 2

DataBase :- OLTP(online transaction process)

• It is current data, up-to-date detailed data, flat relational isolated data.
• Entity relationship is used to design the database
• DB size 100MB-GB simple transaction or quires

Datawarehouse

• OLAP(Online Analytical process)
• It is about Historical data Star schema,snow flexed schema and galaxy
• schema is used to design the data warehouse
• DB size 100GB-TB Improved query performance foundation for DATA MINING DATA VISUALIZATION
• Enables users to gain a deeper understanding and knowledge about various aspects of their corporate data through fast, consistent, interactive access to a wide variety of possible views of the data

Answer 3

Check out this for more information.

From a previous link:

Database

1. Used for Online Transactional Processing (OLTP) but can be used for other purposes such as Data Warehousing. This records the data from the user for history.
2. The tables and joins are complex since they are normalized (for RDMS). This is done to reduce redundant data and to save storage space.
3. Entity – Relational modeling techniques are used for RDMS database design.
4. Optimized for write operation.
5. Performance is low for analysis queries.

Data Warehouse

1. Used for Online Analytical Processing (OLAP). This reads the historical data for the Users for business decisions.
2. The Tables and joins are simple since they are de-normalized. This is done to reduce the response time for analytical queries.
3. Data – Modeling techniques are used for the Data Warehouse design.
4. Optimized for read operations.
5. High performance for analytical queries.
6. Is usually a Database.

It's important to note as well that Data Warehouses could be sourced from zero to many databases.

Answer 4

A data warehouse is a TYPE of database.

In addition to what folks have already said, data warehouses tend to be OLAP, with indexes, etc. tuned for reading, not writing, and the data is de-normalized / transformed into forms that are easier to read & analyze.

Some folks have said "databases" are the same as OLTP -- this isn't true. OLTP, again, is a TYPE of database.

Other types of "databases": Text files, XML, Excel, CSV..., Flat Files :-)

Answer 5

Any data storage for application generally uses the database. It could be relational database or no sql databases which are currently trending.

Data warehouse is also database. We can call data warehouse database as specialized data storage for the analytical reporting purposes for the company. This data used for key business decision.

The organized data helps is reporting and taking business decision effectively.

Answer 6

Database:

Used for Online Transactional Processing (OLTP).

• Transaction-oriented.
• Application oriented.
• Current data.
• Detailed data.
• Scalable data.
• Many Users, Administrators / Operational.
• Execution time: short.

Data Warehouse:

Used for Online Analytical Processing (OLAP).

• Oriented analysis.
• Subject oriented.
• Historical data.
• Aggregated data.
• Static data.
• Not many users, manager.
• Execution time: long.