When a large number of records are inserted into a relation in a short period of time,

Question:

When a large number of records are inserted into a relation in a short period of time, it is often recommended that all indices be dropped, and recreated after the inserts have been completed.

a. What is the motivation for this recommendation?

b. Dropping and recreation of indices can be avoided by bulk-updating of the indices. Suggest how this could be done efficiently for B+-tree indices.

c. If the indices were write-optimized indices such as LSM trees, would this advice be meaningful?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database System Concepts

ISBN: 9780078022159

7th Edition

Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

See More Books

Question Posted: Jun 13, 2022 06:41 AM

See More Questions

If a publicly traded company has a large number of undiversified investors, along with some who are well diversified, can the undiversified investors earn a rate of return high enough to compensate...
A communications firm employs a large number of technical sales representatives who make personal visits to potential customers. For data collected on y = average amount of sales per call and x =...
A survey classified a large number of adults according to whether they were judged to need eyeglasses to correct their reading vision and whether they used eyeglasses when reading. The proportions...
Listing 8.4 checks whether a solution is valid by checking whether every number is valid in the board. Rewrite the program by checking whether every row, every column, and every small box has the...
In a two-way table, all of the observed frequencies are very close to the expected frequencies, so the x 2 test statistic is very small, and we fail to reject the null hypothesis of independence...
A mass-spring-damper system is described by the model m + c + kx = f (t) Where m = 0.25 slug, c = 2 lb-sec/ft, k = 25 lb/ft, and f(t) (lb) is the externally applied force shown in Figure. The forcing...
How can you use Excel to assist in project risk management? What other software can help project teams make better risk management decisions? LO.1
Roy Newburn borrowed money and bought a $49,000 truck from Treadwell Ford. A few months later, the truck developed transmission problems. Newburn learned that the truck had 170,000 more miles on it...
CK E-Com had net income of $136.000 under variable costing. Beginning and ending inventories were 1.260 units and 5,500 units. respectively. Fixed overhead cost was $3.10 per unit for both the...
The comparative balance sheet of Harris Industries Inc. at December 31, 2016 and 2015, is as follows: An examination of the income statement and the accounting records revealed the following...
Suppose that a database application does not appear to have a single bottleneck; that is, CPU and disk utilization are both high, and all database queues are roughly balanced. Does that mean the...
Suppose you are given a relation r(a, b, c). a. Give an example of a situation under which the performance of equality selection queries on attribute a can be greatly affected by how r is clustered....
Let V be the set of all infinite sequences {x n } = {x 1 , x 2 , x 3 , ....} of real numbers. Let addition of elements of V and multiplication by scalars be defined as follows: and (a) Show that V is...
The amounts of caffeine in a sample of five-ounce servings of brewed coffee are shown in the histogram. Number of 5-ounce servings S 25- 20 15 10 25 12 10 1 2 70.5 92.5 114.5 136.5 158.5 Caffeine (in...
Tom, David, Dale, and Murdock are four business students who want to rent a four- bedroom apartment together for the fall semester. They have identified the three factors important to them in...
Listed below, out of order, are the steps in an accounting cycle. 1. Prepare the unadjusted trial balance. 2. Post journal entries to general ledger accounts. 3. Analyze transactions from source...
Consider Quick Start QFD Matrix 2 above. Which two technical specifications are strongly correlated with each other? Quick Start QFD Matrix 2 Strong positive correlation Some positive correlation ==...
A cylindrical solenoid of length $\ell$ and radius $R$ has $n$ windings per unit length and carries a current $I$. (a) Use the inductance expression $L=\left(\mu_{0} N^{2} A ight) / \ell$...
In Exercise 31, the population mean salary is $72,000. Does the t-value fall between -t0.98 and t0.98? Data from Exercise 31: The annual earnings (in dollars) of 32 randomly selected magnetic...
Is it ethical to provide safety training in English to immigrant workers who speak little English, in order to reduce costs?
Devise a timestamp-based protocol that avoids the phantom phenomenon.
Suppose that we use the tree protocol of Section 16.1.5 to manage concurrent access to a B+-tree. Since a split may occur on an insert that affects the root, it appears that an insert operation...
Explain the difference between the three storage typesvolatile, nonvolatile, and stablein terms of I/O cost.
.Is bankruptcy on the part of the borrower a common risk that frequently interferes with a lenders efforts to work out a defaulted loan through either nonforeclosure means or foreclosure? Discuss.
For each of the following, compute the future value: Present Value Years Interest Rate $ 1 , 2 5 0 1 9 1 2 % $ 9 8 , 7 2 7 1 5 1 3 % $ 6 2 5 6 1 2 % $ 1 1 7 , 6 2 2 7 1 6 % 2 . For each of the...
Only need help on 4B and 5. Exercise 9-21 Breakeven Planning; Profit Planning (LO 9-2, 9-3] Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...

When a large number of records are inserted into a relation in a short period of time,

Question:

Step by Step Answer:

a The motivation for dropping and recreating indices when inserti...View the full answer

Database System Concepts

Students also viewed these Computer science questions