OLTP versus OLAP
Databases either fall into two broad categories. The first is OLTP, which stands for On Line Transaction Processing. These are what most people think of when they think of a database. They are usually designed for single record access. This is an important caveat. This single record can be updated, inserted, deleted, or selected. The …