Data warehouse
|
Users perform numerous, complex queries that process large volumes of data. Response time, accuracy, and availability are key issues.
These queries (SELECT statements) range from a fetch of a few records to queries that sort thousands of records from many different tables.
|
General Purpose or Transaction processing
|
Many concurrent users perform numerous transactions that require rapid access to data. Availability, speed, concurrency, and recoverability are key issues.
Transactions consist of reading (SELECT statements), writing (INSERT and UPDATE statements), and deleting (DELETE statements) data in database tables.
|