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,296 | Efficient Index Compression in DB2 LUW | 2009 | VLDB | 7.4473548e-05 |
| 4,492 | Supporting Ontology-based Semantic Matching in RDBMS | 2004 | VLDB | 6.5773612e-05 |
| 6,283 | Supporting RFID-based Item Tracking Applications in Oracle DBMS Using a Bitmap Datatype | 2005 | VLDB | 5.8236456e-05 |
| 12,719 | Pay-As-You-Go - An Adaptive Approach to Provide Full Context-Aware Text Search over Document Content | 2010 | SIGMOD | 4.9793485e-05 |
| 13,161 | Developing an Indexing Scheme for XML Document Collections using the Oracle8i Extensibility Framework | 2001 | VLDB | 4.9793485e-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 |
|---|---|---|---|---|
| 107 | Improved Query Performance with Variant Indexes | 1997 | SIGMOD | 0.00033460288 |
| 648 | Materialized Views In Oracle | 1998 | VLDB | 0.00015151422 |
| 1,013 | A Heuristic Approach to Attribute Partitioning | 1979 | SIGMOD | 0.00012519456 |
| 1,624 | An Efficient Indexing Technique for Full-Text Database Systems | 1992 | VLDB | 0.00010045219 |
| 4,959 | Safely and Efficiently Updating References During On-line Reorganization | 1998 | VLDB | 6.3390968e-05 |
| 7,755 | Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse | 1999 | SIGMOD | 5.4590631e-05 |
| 8,672 | The Jungle Database Search Engine | 1999 | SIGMOD | 5.2915387e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,233 | Multi-Dimensional Clustering: A New Data Layout Scheme in DB2 | 2003 | SIGMOD |
| 2 | 229 | A Study of Index Structures for Main Memory Database Management Systems | 1986 | VLDB |
| 3 | 8,771 | Automatic Indexing in Oracle | 2025 | VLDB |
| 4 | 951 | Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates | 1992 | SIGMOD |
| 5 | 971 | Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes | 2016 | SIGMOD |
| 6 | 3,253 | Quadtree and R-tree Indexes in Oracle Spatial: A Comparison using GIS Data | 2002 | SIGMOD |
| 7 | 5,827 | Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases | 2013 | VLDB |
| 8 | 1,841 | Main-Memory Index Structures with Fixed-Size Partial Keys | 2001 | SIGMOD |
| 9 | 9,405 | Indexing Medium-dimensionality Data in Oracle | 1999 | SIGMOD |
| 10 | 1,128 | Managing Intervals Efficiently in Object-Relational Databases | 2000 | VLDB |