In memory query processing using cache include columns
Original Publication Date: 2004-Dec-06
Included in the Prior Art Database: 2004-Dec-06
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.