Proceedings of the eleventh international conference on Information and knowledge management
Oracle8i Index-Organized Table and Its Application to New Domains
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Developing an Indexing Scheme for XML Document Collection using the Oracle8i Extensibility Framework
Proceedings of the 27th International Conference on Very Large Data Bases
Interval Sequences: An Object-Relational Approach to Manage Spatial Data
SSTD '01 Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases
Object-Relational Indexing for General Interval Relationships
SSTD '01 Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases
Joining interval data in relational databases
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Object-relational management of complex geographical objects
Proceedings of the 12th annual ACM international workshop on Geographic information systems
Analyzing theme, space, and time: an ontology-based approach
GIS '06 Proceedings of the 14th annual ACM international symposium on Advances in geographic information systems
Supporting ontology-based semantic matching in RDBMS
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
A User-Defined Index for Containment Queries in XML
ICCSA '09 Proceedings of the International Conference on Computational Science and Its Applications: Part II
Pay-as-you-go: an adaptive approach to provide full context-aware text search over document content
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Flexible and extensible preference evaluation in database systems
ACM Transactions on Database Systems (TODS)
| Hi-index | 0.00 |
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.