DEV Community

Cover image for Database Management Systems 5
Adrian Brown
Adrian Brown

Posted on

Database Management Systems 5


Following the last post on OLTP vs OLAP, Indexing, and Hashing we will now cover something outside the bounds of a database management system and that follows OLAP from our last post.

In this blog post we will start by covering data warehouses and what they are. The overall objective for a data warehouse and its subset of properties as well.

In short, you will wrap up this series by learning the importance of data in our database environment and what will serve as structured vs unstructured data.


By the end of this tutorial, you will understand

  • Data Warehouse
  • Data Mining
  • Structured vs Unstructured Data

Core Concepts

Data Warehouse

With DWH being separate from the DBMS as a whole we can understand its use for storing huge amounts of data that typically will be collected from a variety of sources.

An ordinary database system will store data and for specific purposes in relation to transactional process's where as a DWH will do the same with the intent for analytical purposes.

Also, whats cool to note is data marts since this typically will live among the variety of vocabulary words one might hear when discussing data warehouses.

In short, a data mart is a subset of the data that makes up a data warehouse.

Data Mining

“Data Mining” can be referred to as knowledge mining from data, knowledge extraction, data/pattern analysis, data archaeology, and data dredging.

This process is what makes up an ETL process or parts of it for that matter. The sole purpose of mining the data from a DWH is to carry out extraction of useful data in bulk. This data can help make decisions or look over trends within a business.

Structured vs Unstructured Data
  1. Structured data is data with addressable information for effective analysis

  2. Unstructured data is data with unorganized or defined schema that isn't a good fit for a typical relational database.

This concludes my series on database management systems, I hope you enjoyed reading and found some stuff to be useful or maybe things I could improve on! If you want to reach out to me feel free to do so via github

Top comments (0)