Title
Implementation of extended indexes in POSTGRES
Abstract
The vaunted "Spartan simplicity" of the relational model can limit the usefulness of the relational database management system (RDBMS) for non-traditional applications. For example, there is no natural way to model a keyword index for bibliographic informational retrieval (IR), or any other index whose key values are computed from column values, in a standard RDBMS. The extended indexing proposed in [LYNC88a] is intended to support applications that require indexes on computed values. This paper reports on an implementation of this type of indexing using the POSTGRES extensible database management system [STON86a], focusing on two issues: general problems, and the features in POSTGRES that proved helpful in the solution of these problems.
Year
DOI
Venue
1991
10.1145/122642.122643
SIGIR Forum
Keywords
Field
DocType
bibliographic informational retrieval,extended indexing,spartan simplicity,relational database management system,postgres extensible database management,column value,computed value,standard rdbms,keyword index,relational model,database management system,information retrieval,indexation
Data mining,Spartan,Information retrieval,Relational database,Computer science,Search engine indexing,Database design,Relational database management system,Relational model,Database
Journal
Volume
Issue
Citations 
25
1
6
PageRank 
References 
Authors
5.03
6
1
Name
Order
Citations
PageRank
Paul M. Aoki11194264.37