« previous next »

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

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

rRNA processing rRNA processing
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.
All computer systems perform four basic functions: input, processing, storage, and output. All computer systems perform four basic functions: input, processing, storage, and output.
Applications and Processing of Ceramics Applications and Processing of Ceramics
Transcription and processing of the major ribosomal RNAs in eukaryotes Transcription and processing of the major ribosomal RNAs in eukaryotes
Posttranscriptional RNA processing in eukaryotes Posttranscriptional RNA processing in eukaryotes
Video: Calvin cycle (The light-independent reactions )

For a complete list of videos, visit our video library