« previous next »

Author Question: A DBMS periodically suspends all processing and synchronizes its files and journals through the use ... (Read 37 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?

According to the Migraine Research Foundation, migraines are the third most prevalent illness in the world. Women are most affected (18%), followed by children of both sexes (10%), and men (6%).

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Overview of RNA processing and posttranscriptional gene control Overview of RNA processing and posttranscriptional gene control
Files come in many different shapes and sizes. Never use a file without a handle. Files come in many different shapes and sizes. Never use a file without a handle.
The Location and Number of Food- and Beverage-Processing Facilities The Location and Number of Food- and Beverage-Processing Facilities
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
Steps in the processing and splicing of mRNA Steps in the processing and splicing of mRNA
Antigen Processing Antigen Processing
Video: Dendrite Animation

For a complete list of videos, visit our video library