« previous next »

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

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

Amoebae are the simplest type of protozoans, and are characterized by a feeding and dividing trophozoite stage that moves by temporary extensions called pseudopodia or false feet.

Differences in the antigen-processing pathways between MHC molecules class I and class II. Differences in the antigen-processing pathways between MHC molecules class I and class II.
Client files are kept in alphabetical order in locked file cabinets. Client files are kept in alphabetical order in locked file cabinets.
Chewing & Swallowing: Food Processing Begins Chewing & Swallowing: Food Processing Begins
Chewing & Swallowing: Food Processing Begins Chewing & Swallowing: Food Processing Begins
Stages in memory processing. Stages in memory processing.
Alternative pre- mRNA processing of the rat-tropomyosin gene Alternative pre- mRNA processing of the rat-tropomyosin gene
Video: Summary of female reproductive cycle days 1-28

For a complete list of videos, visit our video library