Types of Databases

What is a database? As you probably know, a database is an organized collection of data used to model some type of organization or organizational process. It really doesn’t matter whether you’re using paper or a computer program to collect and store the data. As long as you’re collecting and storing data in some organized manner for a specific purpose, you’ve got a database. Throughout the remainder of this discussion, we’ll assume that you’re using a computer program to collect and maintain your data.

In general, two types of databases are used in database management: operational databases and analytical databases.

Operational databases are the backbone of many companies, organizations, and institutions throughout the world ...

Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.