Tel-Aviv University - Computer Science System Seminar

Tuesday, February 23, 4-6

Room 324
Kaplun Building

Extending the power of Informix' Object Relational DBMS using Virtual Table & Index Interfaces.

Roy Gvirtsman

Comsoft, Informix Center Israel

Informix ORDBMS can be extended by adding new abstract data types (ADT) to its kernel and new user defined routines (UDRs) in C to manipulate them. These can be used as building blocks for the implementation of new Primary and Secondary access methods using the Virtual Table Interface (VTI) and Virtual Index Interface (VII) respectively. The new virtual tables can provide an interface to any data using the relational paradigm. The new virtual indices can dramatically speed-up access to ADTs and data that can not be efficiently accessed via B-Trees. We will use B-Trees and R-Trees (index for spatial data) as examples.