« previous next »

Author Question: A DBMS periodically suspends all processing and synchronizes its files and journals through the use ... (Read 25 times)

j.rubin

  • Hero Member
  • *****
  • Posts: 557
on: Jul 7, 2018
A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:
 
  A) checkpoint facility.
  B) backup facility.
  C) recovery manager.
  D) database change log.

Question 2

What is parallel query processing and how is it useful?
 
  What will be an ideal response?
Modern Database Management ¦ Hoffer, Venkataraman, Topi ¦ 13th Edition
Buy Test-Bank


epscape

  • Sr. Member
  • ****
  • Posts: 335
Reply #1 on: Jul 7, 2018
Answer to Question 1

A

Answer to Question 2

Since many of today's computers have either multiple processors or multi-core processors, many database management systems have introduced parallel query processing. With parallel query processing, a query can be broken apart and partitions can be run separately on each processor. The partitions have to be defined in advance by the database designer. The advantage to parallel query processing is speed, since the query can be done in much less time in parallel. The query has to be tuned to achieve the best degree of parallelism.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

In 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Processing of an mRNA molecule after transcription. Processing of an mRNA molecule after transcription.
Client files are kept in alphabetical order in locked file cabinets. Client files are kept in alphabetical order in locked file cabinets.
Results from Kliegl's study show that older adults can learn complex information-processing Results from Kliegl's study show that older adults can learn complex information-processing
Chewing & Swallowing: Food Processing Begins Chewing & Swallowing: Food Processing Begins
Processing, sorting, and transport of proteins synthesized in a human cell Processing, sorting, and transport of proteins synthesized in a human cell
The processing of ribosomal and transfer RNA The processing of ribosomal and transfer RNA
Video: PET Scan Animation

For a complete list of videos, visit our video library