Portal Industrial Cartagena Colombia - Forum - Contacts

Members Login
    Remember Me  
Post Info TOPIC: Database vs Data Warehouse: Similarities & Differences


Status: Offline
Posts: 10
Database vs Data Warehouse: Similarities & Differences

What is a Database?

Database is an organized collection of facts or information that can be changed and retrieved. The key task of the database is to perform query processing.

This system is generally referred to as an online transaction processing system (OLTP). It is used in day-to-day operations of an organization. Database is also a part of your data solution, thus it is really important. 

What is a Database OLTP

What is a Data Warehouse?

Data Warehouse is where structured data acquired from many sources is stored for analysis and reporting. Because business decisions are based on data consolidation, analysis, and a variety of reporting, a data warehouse is critical to the process of making them. 

According to the decision-making system, data warehouses take vast amounts of heterogeneous data, then translate it into analytic reports before storing it.  

For instance, a business can store a variety of its employees’ information such as their names, addresses, salaries, and job descriptions, as well as information about the items and services it sells and the money it makes. There may be a need for data on sales growth and personnel performance to be sent to the top management.  

All of the data in the data warehouse will be examined using a decision-making system to obtain this information. A data warehouse serves this primary function. Future decision making can be aided by the utilization of the data warehouse. 

Similarity Between Database And Data Warehouse

Data is stored in both a database and a data warehouse. Storage systems are what you’re looking at. Typically, the bottom tier of a data warehouse is a relational database. Relational database systems are also databases, with data stored in rows and columns in relational database systems. 


Both database and data warehouse let multiple users access the same data at the same time. Many users can simultaneously access a single database or data warehouse. To get at the data, you’ll need to run queries in both the datawarehouse and the database. Complex queries can be used to access the data warehouse, but simple queries can be used to access the OLTP database. And finally, whether on-premises or in the cloud, a company’s data warehouse and database are available. Source: Database vs Data Warehouse (written by Synodus)


Synodus | Big data analytics


Status: Offline
Posts: 1


Dr Sarika Sethia is an ophthalmologist- cataract and refractive surgeon. Dr Sarika offers her esteemed clientele the most exclusive and state of art services and ensures that her clinic is updated with the latest advancements in technology.

Dr Sarika Sethia is best ophthalmologist in Pune. She holds numerous accolades to her name and keeps working hard to achieve more.
Indovision Cataract & Laser Eye Centre is one of the best We provide end-to-end eye care solutions following latest international standards.



Black fungal symptoms include blackish discoloration of the nose, proptosis, sinusitis and blurred vision.




Page 1 of 1  sorted by
Quick Reply

Please log in to post quick replies.

Create your own FREE Forum
Report Abuse
Powered by ActiveBoard