Online Transaction Processing (OLTP) systems
GPTKB entity
Statements (50)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:database
|
| gptkbp:abbreviation |
OLTP
|
| gptkbp:acceptsPaymentMethod |
delete
insert update read |
| gptkbp:architecture |
distributed systems
client-server |
| gptkbp:backupRequirement |
frequent backups
|
| gptkbp:characteristic |
ensure data integrity in multi-access environments
support concurrent users support high volume of short online transactions support real-time processing use ACID properties |
| gptkbp:contrastsWith |
Online Analytical Processing (OLAP) systems
|
| gptkbp:dataAccessPattern |
random access
index-based access |
| gptkbp:dataGranularity |
detailed
|
| gptkbp:dataHistory |
current data
|
| gptkbp:dataNormalization |
high
|
| gptkbp:dataRedundancy |
minimized
|
| gptkbp:dataWarehouseSource |
OLTP systems
|
| gptkbp:example |
airline reservation systems
banking systems order entry systems retail sales systems |
| gptkbp:failureRecovery |
essential
|
| gptkbp:frequency |
frequent
|
| gptkbp:hasModel |
relational database management system
|
| https://www.w3.org/2000/01/rdf-schema#label |
Online Transaction Processing (OLTP) systems
|
| gptkbp:industry |
banking
retail telecommunications travel |
| gptkbp:numberOfVolumes |
large number of small transactions
|
| gptkbp:period |
milliseconds to seconds
|
| gptkbp:purpose |
manage transaction-oriented applications
|
| gptkbp:queryType |
simple queries
predefined queries |
| gptkbp:requires |
high availability
data consistency fast response time fast query processing |
| gptkbp:securityRequirement |
high
|
| gptkbp:size |
horizontal scaling possible
|
| gptkbp:targetUser |
end users
database administrators clerks |
| gptkbp:bfsParent |
gptkb:OLTP_Table_Compression
|
| gptkbp:bfsLayer |
8
|