Authors:
Tomasz M. Kowalski
;
Kamil Kuliberda
;
Jacek Wiślicki
and
Radosław Adamus
Affiliation:
Technical University of Lodz, Poland
Keyword(s):
Index maintenance, Automatic index updating, Indexing, Triggers, OODBMS, SBA, SBQL, ODRA.
Related
Ontology
Subjects/Areas/Topics:
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Object-Oriented Database Systems
Abstract:
In this paper, we describe a robust approach to the problem of the automatic index updating, i.e. maintaining cohesion between data and indices. Introducing object-oriented notions (classes, inheritance, polymorphism, class methods, etc.) in databases allows defining more complex selection predicates; nevertheless, in order to facilitate selection process through indices, index updating requires substantial revising. Inadequate index maintenance can lead to serious errors in query processing what has been shown on the example of Oracle 11g ORDBMS. The authors work is based on the Stack-Based Architecture (SBA) and has been implemented and tested in the ODRA (Object Database for Rapid Applications development) OODBMS prototype.