Warehouse Data Versus Operational Data
Operational database systems deal with handling many users and transactions. These are often referred to as Online Transactional Processing systems (or OLTP). Users might be constantly adding, updating, and querying information in these production systems.
An example of an OLTP is a typical order-entry application. A customer calls a sales representative and orders some products from a catalog. The sales associate can pull up the order entry screen and enter the line items the customer desires. The order is placed, which triggers inventory allocations and so on. This small part of the process has generated many records, and many transactions have taken place. This OLTP system requires transactions to be ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
