|
| This Article | ||
| ||
| Share | ||
| Bibliographic References | ||
| Add to: | ||
| | ||
| Search | ||
| ||
17th International Conference on Data Engineering (ICDE'01)
B+-Tree Indexes with Hybrid Row Identifiers in Oracle8i
Heidelberg, Germany
April 02-April 06
ISBN: 0-7695-1001-9
| ASCII Text | x | ||
| Eugene Inseok Chong, Souripriya Das, Chuck Freiwald, Jagannathan Srinivasan, Aravind Yalamanchi, Mahesh Jagannath, Anh-Tuan Tran, Ramkumar Krishnan, "B+-Tree Indexes with Hybrid Row Identifiers in Oracle8i," Data Engineering, International Conference on, pp. 0341, 17th International Conference on Data Engineering (ICDE'01), 2001. | |||
| BibTex | x | ||
| @article{ 10.1109/ICDE.2001.914846, author = {Eugene Inseok Chong and Souripriya Das and Chuck Freiwald and Jagannathan Srinivasan and Aravind Yalamanchi and Mahesh Jagannath and Anh-Tuan Tran and Ramkumar Krishnan}, title = {B+-Tree Indexes with Hybrid Row Identifiers in Oracle8i}, journal ={Data Engineering, International Conference on}, volume = {0}, year = {2001}, isbn = {0-7695-1001-9}, pages = {0341}, doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2001.914846}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, } | |||
| RefWorks Procite/RefMan/Endnote | x | ||
| TY - CONF JO - Data Engineering, International Conference on TI - B+-Tree Indexes with Hybrid Row Identifiers in Oracle8i SN - 0-7695-1001-9 SP EP A1 - Eugene Inseok Chong, A1 - Souripriya Das, A1 - Chuck Freiwald, A1 - Jagannathan Srinivasan, A1 - Aravind Yalamanchi, A1 - Mahesh Jagannath, A1 - Anh-Tuan Tran, A1 - Ramkumar Krishnan, PY - 2001 VL - 0 JA - Data Engineering, International Conference on ER - | |||
Abstract: Most commercial database systems support B+-tree indexes using either 1) physical row identifiers, for example, DB2 or 2) logical row identifiers, for example, NonStop SQL. Physical row identifiers provide fast access to data. However, unlike logical row identifiers, they need to be updated whenever the row moves. This paper describes an alternate approach where hybrid row identifiers are used. A hybrid row identifier consists of two components: 1) a logical component, namely, the primary key of the base table row, and 2) a physical component, namely, the Database Block Address (DBA) of the row. By treating the DBA as a guess regarding where the row may be found, performance comparable to physical B+-tree indexes is attained for valid guess-DBAs. This scheme retains the logical index advantage of avoiding an immediate index update when the base table row moves. Instead, an online utility can be used to lazily fix the invalid guess-DBAs. This scheme has been used to implement B+-tree indexes for Oracle8i index-organized tables (primary B+-tree like structure) which encounter both row movement and table reorganization. It can also be applied to conventional tables that undergo some form of row movement such as replication or transportation of data. This paper discusses the following: 1) key concepts for supporting B+-tree indexes with hybrid row identifiers, 2) performance study comparing such indexes with physical B+-tree indexes, and 3) applicability of B+-tree indexes with hybrid row identifiers to speed up table replication (full-refresh), to increase index availability, and to support online table operations.
Citation:
Eugene Inseok Chong, Souripriya Das, Chuck Freiwald, Jagannathan Srinivasan, Aravind Yalamanchi, Mahesh Jagannath, Anh-Tuan Tran, Ramkumar Krishnan, "B+-Tree Indexes with Hybrid Row Identifiers in Oracle8i," icde, pp.0341, 17th International Conference on Data Engineering (ICDE'01), 2001
Usage of this product signifies your acceptance of the Terms of Use.
