Operational databases (a.k.a. OLTP On Line Transaction Processing),
on the other hand,
are used to manage more dynamic bits of data. These types
of databases allow you to do more than simply view archived data.
Operational databases allow you to modify that data (add,
change or delete data).
These types of databases are usually
used to track real-time information. For example,
a company might have an operational database used to track warehouse/stock
quantities. As customers order products from an online
web store, an operational database can be used to keep track
of how many items have been sold and when the company will
need to reorder stock.
Table of Contents