Transaction processing

A set of 30 flashcards that encompass key concepts and terms related to database transaction processing, catering to students preparing for an exam.

Database Application

A program that uses a database to perform tasks like storing, retrieving, updating, and managing data.

Transaction

A set of read and write operations that must either commit or abort.

ACID Properties

A set of properties (Atomicity, Consistency, Isolation, Durability) that ensure reliable processing of database transactions.

Atomicity

The property that ensures every transaction is a logical unit of work, either committing all operations or aborting.

Consistency

A property that ensures a transaction moves the database from one consistent state to another.

Isolation

The property that ensures a transaction is not aware of any other transactions until it commits.

Durability

Once a transaction commits, its work cannot be lost due to a future failure.

Transaction Schedule

A sequence in which the read and write operations of two or more transactions are executed.

Lost Update Problem

Occurs when two transactions read the same data, and one updates it after the other has read it.

Dirty Read Problem

Happens when a transaction reads data that has not yet been committed by another transaction.

Non-Repeatable Read

Occurs when a transaction reads the same row twice and gets different data each time due to updates by another transaction.

Serial Schedule

A transaction schedule where transactions are executed one after another without overlap.

Non-Serial Schedule

A schedule in which two or more transactions are executed in an interleaved manner.

Serializable Schedule

A non-serial schedule that produces the same results as a serial schedule.

Concurrency Control

The management of simultaneous operations on a database without conflicting.

Database Recovery

Techniques used to restore a database to a correct state after a failure.

INSERT Command

SQL command used to add records to a database table.

UPDATE Command

SQL command used to modify existing records in a database table.

SELECT Command

SQL command used to query and retrieve data from a database.

DELETE Command

SQL command used to remove records from a database table.

Customer Record

A database entry that contains information about a customer.

Order Record

A database entry that contains information about a customer order.

Inventory Level

The quantity of a particular item available in stock.

Payment Record

A database entry that contains information regarding payments made by customers.

Registration Record

An entry that documents a student's registration for a course.

Charitable Donation

A financial contribution made to a charitable organization.

Fundraising Campaign

An organized effort to raise funds for a specific cause or project.

Pre-requisites Check

A process of confirming if a student meets the necessary requirements for course enrollment.

Seat Availability Check

A query to determine if there are available seats for a course or event.

Product Inventory Decrement

The action of reducing the count of an item available for sale after a purchase.

Responsibility of DBMS

To ensure data integrity and consistency in the database through proper transaction scheduling.

Read Operation

An action that retrieves data from the database.

Write Operation

An action that modifies or adds data to the database.