Database Reference
In-Depth Information
OLTP databases
OLAP databases
CUD
Short, fast inserts and updates initiated
by users.
Periodic long running jobs
refreshing the data.
Queries
Usually works on smaller volumes of
data, executes simpler queries.
Often complex queries in-
volving aggregations and
slicing and dicing on multi-
dimensional structure.
Throughput Usually very fast due to relatively smal-
ler data volumes and quicker running
queries.
Usually run in batches and
in higher volumes; may take
several hours depending on
volumes.
Storage
capacity
Relatively small as historical data is
archived.
Requires larger storage
space due to the volumes
involved.
Schema
design
Highly normalized with many tables.
Typically denormalized with
fewer tables; use of star
and/or snowflake schemas.
Backup
and recov-
ery
Requires rigorous backup religiously;
operational data is critical to run the
business; data loss is likely to entail sig-
nificant monetary loss and legal liability.
Instead of regular backups,
some environments may
consider simply reloading
the OLTP data as a recov-
ery method.
Search WWH ::
Custom Search