BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 12, Problem 10RQ
Textbook Problem
710 views

Describe the different types of database requests and transactions.

Program Plan Intro

Distributed Database Management System (DDBMS):

  • The database management system supports the database distributed over the numerous different sites.
  • Distributed DBMS manages the storage and processing of logically associated data across the connected systems wherein both “data” and “processing functions” are distributed between various sites.

Database Request:

A Database request is equal to single SQL (Structured Query Language) statement in an application program.

Database transaction:

A database transaction defines one or more SQL statements that executed successfully or aborted.

Explanation of Solution

Different types of database request and transaction:

There are two different types of database request are given below:

  • Remote request
  • Remote transaction

Remote request:

  • Remote request is a database function that permits the application to submit SQL statements which reference to a single remote database processing site.
  • In other word, it accesses the data which is located at only one remote data processing site.

Remote transaction:

  • Remote transaction is a set of numerous database requests which access the data at only one remote database processing site...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
If the C.I.A. triad is incomplete, why is it so commonly used in security?

Principles of Information Security (MindTap Course List)

What are the major components of a building?

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What is the difference between a detail report, a summary report, and an exception report?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

Explain what occurs when you synchronize computers and mobile devices.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

What are some skills that entry-level welders need?

Welding: Principles and Applications (MindTap Course List)

List three IGPs (interior gateway protocols).

Network+ Guide to Networks (MindTap Course List)