« previous next »

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

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Timber in storage for later processing at a sawmill. Timber in storage for later processing at a sawmill.
Changes that occur during the processing of tyrosine pre-tRNA Changes that occur during the processing of tyrosine pre-tRNA
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
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
Video: Ionic bonds - role of ions in the body

For a complete list of videos, visit our video library