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...
Slopes Inc. manufactures and sells snowboards. Slopes manufacture a single model, the Pipex. In the summer of 2012, Slopess accountant gathered the following data to prepare budgets for 2013. These...
How do CRM and the use of databases in selling enhance closing and follow-up?
What is the control requirement of 351? Describe the effect of the following in satisfying this requirement: a. A shareholder renders only services to the corporation for stock. b. A shareholder...
! Required information [The following information applies to the questions displayed below.] Camille Sikorski was divorced in 2018. She currently provides a home for her 15-year-old daughter Kaly....
Allie has bought a new apple orchard. The orchard has a single file of trees, numbered from 1 to N. Each tree has a certail number of ripe apples. Allie has a rule she wants to follow. She wants to...
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....
What changes to the economy will lead the aggregate supply curve to shift? What changes will lead to a movement along the aggregate supply curve? Provide a few examples to illustrate your answer.
What does the following functions do? a. int mystry (struct node* head) { int count = 0; } b. struct node* current = head; while (current != NULL) { count++; current = current->next } return (count);...
Like any human undertaking, projects need to be performed and delivered under certain constraints. Use a project that you are familiar with and discuss the triple constraints that the project was...
I want us to explore different tools we may use and why. Using either a past project or one you have researched for this course, identify at least one quantitative tool and one qualitative...
Discuss how both motivation and a lack of motivation can impact different criminal justice organizations. What theories can be utilized to explain how criminal justice leaders can better motivate...
1. According to the case, which BlackBerry division seemed to have "potential"? BlackBerry Division Research and Development Division Security Enterprise Division All of the answers are correct. None...
The graph of the shaded area at right shows all possible combinations of two numbers, x and y. Use the graph and basic area formulas to answer each question. Express each answer to the nearest 0.001....
Using thermodynamic data from Appendix 4, calculate G at 258C for the process: 2SO 2 (g) + O 2 (g) 88n 2SO 3 (g) where all gases are at 1.00 atm pressure. Also calculate DG8 at 258C for this same...
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.
If Allison's Form W-2 reported $5,000 of employer-paid dependent care benefits in box 10, how much would her Child and Dependent Care Credit be?
What strategies can leaders employ to foster a culture of ethical integrity within organizations, integrating principles of ethical leadership theory and transformational leadership approaches ?
What ethical considerations arise in the context of leadership succession planning and executive compensation, balancing organizational interests with individual rights and fairness principles?

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