Two Techniques for On-Line Index Modification in Shared Nothing Parallel Databases
Summary: Two online index-modification techniques for shared-nothing DBs: OAT (one-at-a-time) and BULK (bulk). BULK: order-of-magnitude faster with sequential prefetch I/O; OAT uses ≤1 extra page; with 1–2 indexes OAT preserves transactional performance; for >2 indexes both degrade similarly. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 7 of 7 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,524 | Sorting And Indexing With Partitioned B-Trees | 2003 | CIDR | 0.00011516282 |
| 2,413 | Automated Partitioning Design in Parallel Database Systems | 2011 | SIGMOD | 8.8672223e-05 |
| 3,401 | Towards Self-Tuning Data Placement in Parallel Database Systems | 2000 | SIGMOD | 7.1400085e-05 |
| 4,878 | Safely and Efficiently Updating References During On-line Reorganization | 1998 | VLDB | 5.858048e-05 |
| 7,200 | Online B-Tree Merging | 2005 | SIGMOD | 4.8030945e-05 |
| 7,524 | On-line Reorganization in Object Databases | 2000 | SIGMOD | 4.7180617e-05 |
| 7,809 | Online Reorganization in Read Optimized MMDBS | 2011 | SIGMOD | 4.6448758e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 174 | ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes | 1990 | VLDB | 0.00038347904 |
| 875 | Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates | 1992 | SIGMOD | 0.00015719411 |
| 4,993 | Dynamic File Allocation in Disk Arrays | 1991 | SIGMOD | 5.7818647e-05 |
| 5,354 | Principles of Transaction-Based On-Line Reorganization | 1992 | VLDB | 5.5518586e-05 |
| 7,197 | Incremental File Reorganization Schemes | 1985 | VLDB | 4.8034535e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,845 | Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering | 2019 | VLDB | 0.00010338323 |
| 679 | Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems | 2012 | SIGMOD | 0.00018215154 |
| 3,595 | Database Buffer Size Investigation for OLTP Workloads | 1997 | SIGMOD | 6.9373987e-05 |
| 8,642 | Automatic Workload Driven Index Defragmentation | 2011 | VLDB | 4.4785896e-05 |
| 6,201 | Concurrency Control for Adaptive Indexing | 2012 | VLDB | 5.1600319e-05 |
| 9,258 | Main-Memory Operation Buffering for Efficient R-Tree Update | 2007 | VLDB | 4.3690661e-05 |
| 2,136 | A Generic Approach to Bulk Loading Multidimensional Index Structures | 1997 | VLDB | 9.4721139e-05 |
| 9,918 | Shared Load(ing): Efficient Bulk Loading into Optimized Storage | 2020 | CIDR | 4.2561557e-05 |
| 5,328 | An Evaluation of Generic Bulk Loading Techniques | 2001 | VLDB | 5.5665496e-05 |
| 1,312 | Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes | 2016 | SIGMOD | 0.00012652548 |