Oracle8i Index-Organized Table and its Application to New Domains
Summary: Oracle8i index-organized tables extend primary B+-trees with selective overflow for cold columns, logical primary-key rowids plus guess-DBAs for efficient secondary indexes, and key compression. Experiments quantify clustering and these trade-offs across Internet, e-commerce, and warehousing workloads. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Jagannathan Srinivasan (Oracle)
- 2. Eugene Inseok Chong (Oracle)
- 3. Ramkumar Krishnan (Oracle)
- 4. Souripriya Das (Oracle)
- 5. Mahesh Jagannath (Oracle)
- 6. Anh-Tuan Tran (Oracle)
- 7. Jayanta Banerjee (Oracle)
- 8. Chuck Freiwald (Oracle)
- 9. Aravind Yalamanchi (Oracle)
- 10. Samuel DeFazio (Oracle)
BibTeX Citation
@article{srinivasan_vldb00,
title = {{Oracle8i Index-Organized Table and its Application to New Domains}},
author = {Srinivasan, Jagannathan and Chong, Eugene Inseok and Krishnan, Ramkumar and Das, Souripriya and Jagannath, Mahesh and Tran, Anh-Tuan and Banerjee, Jayanta and Freiwald, Chuck and Yalamanchi, Aravind and DeFazio, Samuel},
journal = {PVLDB},
series = {{VLDB} '00},
pages = {285--296},
year = {2000}
}Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,244 | Efficient Index Compression in DB2 LUW | 2009 | VLDB | 7.6033499e-05 |
| 4,404 | Supporting Ontology-based Semantic Matching in RDBMS | 2004 | VLDB | 6.722108e-05 |
| 6,152 | Supporting RFID-based Item Tracking Applications in Oracle DBMS Using a Bitmap Datatype | 2005 | VLDB | 5.9573045e-05 |
| 12,428 | Pay-As-You-Go - An Adaptive Approach to Provide Full Context-Aware Text Search over Document Content | 2010 | SIGMOD | 5.093636e-05 |
| 12,871 | Developing an Indexing Scheme for XML Document Collections using the Oracle8i Extensibility Framework | 2001 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 104 | Improved Query Performance with Variant Indexes | 1997 | SIGMOD | 0.00033932213 |
| 643 | Materialized Views In Oracle | 1998 | VLDB | 0.00015372449 |
| 996 | A Heuristic Approach to Attribute Partitioning | 1979 | SIGMOD | 0.00012758481 |
| 1,587 | An Efficient Indexing Technique for Full-Text Database Systems | 1992 | VLDB | 0.00010269584 |
| 4,839 | Safely and Efficiently Updating References During On-line Reorganization | 1998 | VLDB | 6.4838601e-05 |
| 7,612 | Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse | 1999 | SIGMOD | 5.5834218e-05 |
| 8,505 | The Jungle Database Search Engine | 1999 | SIGMOD | 5.4129456e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,197 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD |
| 2 | 219 | A Study of Index Structures for Main Memory Database Management Systems | 1986 | VLDB |
| 3 | 11,003 | Automatic Indexing in Oracle | 2025 | VLDB |
| 4 | 924 | Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates | 1992 | SIGMOD |
| 5 | 3,217 | Quadtree and R-tree Indexes in Oracle Spatial: A Comparison using GIS Data | 2002 | SIGMOD |
| 6 | 964 | Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes | 2016 | SIGMOD |
| 7 | 5,715 | Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases | 2013 | VLDB |
| 8 | 1,813 | Main-Memory Index Structures with Fixed-Size Partial Keys | 2001 | SIGMOD |
| 9 | 9,233 | Indexing Medium-dimensionality Data in Oracle | 1999 | SIGMOD |
| 10 | 1,139 | Managing Intervals Efficiently in Object-Relational Databases | 2000 | VLDB |