Classification Based on Access Pattern
Learn about OLTP and OLAP databases and DBMS classification based on access patterns.
Types of systems
Before we can understand classification of DBMS on access patterns, we need to understand the different types of systems.
Online systems
Online systems wait for a request from a client. Once the request arrives, it processes the demand to produce a response. Online systems are called request/response systems since the client is waiting for a response from the system. The prime requirement for online systems is response with millisecond latency.
Typical applications of online systems include web applications and transactional systems.