Answered: database that backs up an application…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

A database that backs up an application is usually called an OLTP DB. Online TRANSACTIONAL Process.

What level of granularity do you think it is at?

Expert Solution

Step 1 Introduction

OLTP(Online TRANSACTIONAL Process) :

OLTP System handle with operational data.

Operational data are those data contained in the operation of a particular system.

OLTP (Online Transactions Processing Databases), are used to manage dynamic data in real-time.

Characteristics of OLTP:

• Short simple transactions.
• Relatively frequent updates.
• Transactions access only a small fraction of the database.

OLTP Description:

It is characterized by large numbers of short online transactions.
OLTP is an online database modifying system.
OLTP uses traditional DBMS.
Insert, Update, and Delete information from the database.
OLTP and its transactions are the sources of data.
OLTP database must maintain data integrity constraints.
It's response time is in a millisecond.
The data in the OLTP database is always detailed and organized.
Allow read/write operations.
It is a market-orientated process.
Queries in this process are standardized and simple.
Complete backup of the data combined with incremental backups.
DB design is an application-oriented example: Database design changes with the industry like retail, airline, banking, etc.
It is used by Data critical users like clerk, DBA & Data Base professionals.
It is designed for real time business operations.
Transaction throughput is the performance metric.
This kind of Database user allows thousands of users.

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions