Browse Prior Art Database

In memory query processing using cache include columns

IP.com Disclosure Number: IPCOM000033302D
Original Publication Date: 2004-Dec-06
Included in the Prior Art Database: 2004-Dec-06

Publishing Venue

IBM

Abstract

Object-relational extensions to database systems allow the extension of a standard relational database system with specialized support for new types of objects. Important examples of such new datatypes include text, images, audio, and video. To search on these multimedia data indexes are built that are stored outside of the scope of the database. In a database SQL query a predicate (e.g. CONTAINS) can be used to search on this text index. When such a query is executed a join between the text search results and the database table is necessary. The idea to solve the "Join Problem" described above is to use "Cache Include Columns". That is the data which will be retrieved by the application is cached in memory together with the primary keys of the search table. When issuing the text search query the result data is fetched directly from the cache thus avoiding a join completely.