loading...
Extensible Indexing: a Framework for Integrating Domain-Specific Indexing Schemes into Oracle8i
San Diego, California February 28-March 03
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2000.83939616th International Conference on Data ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Jagannathan Srinivasan, Oracle Corporation
Ravi Murthy, Oracle Corporation
Seema Sundara, Oracle Corporation
Nipun Agarwal, Oracle Corporation
Samuel DeFazio, Oracle Corporation
Extensible Indexing is a SQL-based framework that allows users to define domain-specific indexing schemes, and integrate them into the Oracle8i server. Users register a new indexing scheme, the set of related operators, and additional properties through SQL data definition language extensions. The implementation for an indexing scheme is provided as a set of Oracle Data Cartridge Interface (ODCIIndex) routines for index-definition, index-maintenance, and index-scan operations. An index created using the new indexing scheme, referred to as domain index, behaves and performs analogous to those built natively by the database system. Oracle8i server implicitly invokes user-supplied index implementation code when domain index operations are performed, and executes user-supplied index scan routines for efficient evaluation of domain-specific operators.This paper provides an overview of the framework and describes the steps needed to implement an indexing scheme. The paper also presents a case study of Oracle Cartridges (InterMedia Text, Spatial, and Visual Information Retrieval), and Daylight (Chemical compound searching) Cartridge, which have implemented new indexing schemes using this framework and discusses the benefits and limitations.
Citation:
Jagannathan Srinivasan, Ravi Murthy, Seema Sundara, Nipun Agarwal, Samuel DeFazio, "Extensible Indexing: a Framework for Integrating Domain-Specific Indexing Schemes into Oracle8i," icde, pp.91, 16th International Conference on Data Engineering (ICDE'00), 2000
Usage of this product signifies your acceptance of the Terms of Use.


Suggestions