2004 | OriginalPaper | Chapter
Database Performance
Author : William Smith
Published in: Systems Building with Oracle
Publisher: Macmillan Education UK
Included in: Professional Book Archive
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Online transaction processing (OLTP) applications define performance in terms of throughput. These applications must sometimes process millions of very small transactions per day. Decision support systems define performance in terms of response time. Demands on the database that are made by DSS applications vary between a query that fetches only a few records, or a massive query that fetches and sorts hundreds of thousands of records from different tables.