Registering for and retrieving database table change information that can be used to invalidate cache entries

Abstract

A server provides Web responses that can include content from data tables in a database. The server maintains a cache (e.g., in system memory) that can store content (including content from data tables) so as to increase the efficiency of subsequently providing the same content to satisfy client Web requests. The server monitors data tables for changes and, when a change in a particular data table occurs, invalidates cached entries that depend on a particular data table. Further, in response to a client Web request for a Web response, the server assigns a database cache dependency to at least a portion of a constructed Web response (e.g., to content retrieved from a data table) based on commands executed during construction of the Web response. The at least a portion of the constructed Web response is subsequently cached in a cache location at the server.

Description

technical field [0001] The present invention relates to managing cache content. More particularly, the invention relates to database table change information for registering and retrieving data that can be used to invalidate cached records. Background technique [0002] Computer systems and related technologies affect many aspects of society. Indeed, the capabilities of computer systems that process information have changed the way we live and work. Computer systems now typically perform a series of major tasks (eg, word processing, tabulation, and database management) that take precedence over manually performed computer systems. Recently, computer systems have been coupled to each other via wired or wireless computer networks through which computer systems can communicate electronically and share data. As a result, many tasks performed in computers (eg, voice communications, accessing electronic mail, electronic conferencing, web browsing) involve electronic communicati...

AI Technical Summary

Problems solved by technology

In a multi-server environment, pre-emptive removal of cached content can lead to an unnecessary burden on shared database resources, so it is important to limit scalability.

Therefore, it is beneficial to rely on mechanisms for formulating records in the cache and invalidating cached records based on table changes in the database.

Images