Best Answer

What Is a Database?

In a database, information is organized into tables. Rows and columns make up the structure of a table. Attributes are shown in the columns. Attributes such as ID, name, city, location, mark1, mark2, etc. can be found in the student table in the school database. In the database, each row represents a distinct individual. In this case, each row represents a single student's whole record collection. Maintaining a database is usually a good idea because it helps keep track of information. There may be different tables for teachers, students, courses, and so on in a school database.

The software that assists in the management of databases is known as a database management system (DBMS). Database management systems (DBMSs) such as MySQL, MSSQL, Oracle, and PostgreSQL are among the most used. Structured Query Language (SQL) can be used by the user to perform database operations. OLTP, or Online Transactional Processing, refers to the method used to run database queries online. Because of this, OLTP is used by a database. Overall, a database helps to organize a collection of information.

What is a Data Warehouse?

The use of Business Intelligence (BI) can help businesses grow. It transforms raw data into information that may be used for business analysis. As a result, end users benefit from better business insights. Support for the business intelligence process is provided by using a data warehouse. Oracle, MySQL, and other databases can be used by a corporation. In some databases, it is not possible to see the data directly. This problem can be solved with a data warehouse. Integration and processing are carried out on the data it collects and processes. A visual representation of this data is possible. Subject-oriented, integrated, time-variant and nonvolatile are the characteristics of data warehouses.

Difference Between Database and Data Warehouse

Data Type

Detailed data can be found in the database, whereas summary data can be found in the data warehouse.

Processing Method

While OLTP is used in databases, OLAP is used in data warehouses to analyze data (OLAP).


Data warehouses and databases are two separate tools that can be used to conduct basic business functions.

Speed and Accuracy

Using a data warehouse instead of a database is faster and more accurate.


A database's primary focus is on serving a specific business need. Subject-oriented data warehousing. Instead of storing information based on a certain application, it organizes it according to the business topic.

Tables and Joins

Normalized tables and joins in a database make them more difficult to understand. This reduces the amount of redundant data. Contrarily, denormalized data warehousing tables and joins are much easier to work with. Analytical inquiries can take a long time to answer, so here is a way to speed up the process.

Design Method

A database can be designed with the help of entity relationship modeling. The development of a data warehouse is made easier by the use of data modeling techniques.

User Avatar


Lvl 5
โˆ™ 2022-03-07 12:27:28
This answer is:
User Avatar
Study guides

What are advantages of Database Approach

What is a network that covers a large geographical area such as a city country or world

What is the worlds largest wan

What is a network server

See all cards
87 Reviews
More answers
User Avatar

Wiki User

โˆ™ 2010-11-27 07:45:13

A DBMS is a Database management System, it consists of the tools needed to access or build a database. A Data Warehouse is merely a collection of data from one or more sources collected together to enhance the the activities of data mining, which is performed with a DBMS or a RDBMS*.

*Relational Database Management System

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the difference between DBMS and Data warehouse?
Write your answer...
Still have questions?
magnify glass
Related questions

What difference between DBMS and Data warehousing?

what is difference between traditional DBMS and data warehousing?

Difference between traditional and latest DBMS package?

Traditional FPS and DBMS both are different from each other. In DBMS there is security of data as well as integrated data while this is not in FPS.

Difference between centralized and distributed dbms?

A centralized DBMS, or database management system, has data maintained and stored in one location. A distributed DBMS has data stored in storage devices that are in other locations.

Difference between file processing and dbms?

DBMS overcomes all the disadvantage of traditional FPS. The main difference between FPS and DBMS is that FPS do not support data sharing, data security and non redundancy.

What is the difference between DBMS and file management system?

File system is the traditional method where data is stored and retrieved from files. But modern DBMS stores data in the database tables and retrieves them.

What is the difference between relation and relationship in dbms?

Relationship is purely a construct of the er data model.Relation is a structure of the relational data model.

What is the need of rdbms?

A DBMS stores data in a table where the entries are filed under a specific category and are properly indexed. This allowed programmers to have a lot more structure when saving or retrieving data. A relational database contains data in more than one table. Each table contains a database that is then linked to other tables with respect to their relationships. Read more: Difference Between DBMS and RDMS | Difference Between | DBMS vs RDMS

Difference between data warehouse and datamart?

A data warehouse has multiple functional areas whereby a centralized organizational unit is responsible for implementing it. On the contrary, data marts focus on particular functional areas hence are simple forms of a data warehouse.

What is the difference between controlled redundancy and uncontrolled redundancy?

Redundancy is controlled when the dbms ensures that multiple copies of the same data are consistent. If the dbms has no control over this, uncontrolled redundancy.

What are the key relationships between data warehouse and data mining?

Data warehouse is the database on which we apply data mining.

Difference between database and datawarehouse?

A database is used to store data while a data warehouse is mostly used to facilitate reporting and analysis.

What is difference between Schema and Subschema?

SCHEMA is the physical arrangement of the data as it appears in the DBMS. SUB-SCHEMA is the logical view of the data as it appears to the application program.

People also asked