Cache Data Dependency on Database

Note

This feature is only available in NCache Enterprise Edition.

Nowadays, most applications that heavily use database calls incorporate distributed caching to the cache-expensive query result set, which helps to boost application performance and scalability. For this purpose, you would like any data changes in the database to invalidate and remove cache data. NCache provides a mechanism to invalidate data, when changes occur in the database in real time. NCache provides notification-based database dependencies to cater to this issue.

Working on Database Dependencies

In database dependency, NCache uses data change notifications provided by database servers to invalidate cache data. NCache receives database notifications, whenever underlying data changes occur in the database. So NCache immediately invalidates the corresponding cached item and keeps the cache synchronized with a database.

In This Section

Cache Data Dependency on SQL Server
Explains how to use the SQL dependency feature for the purpose of synchronizing cache with Microsoft SQL Server 2005/2008.

Cache Data Dependency on Oracle Database
Explains how to use the Oracle dependency feature for the purpose of synchronizing cache with Oracle database.

NCache Polling-Based Dependency with OleDB
Explains how to use the OleDb dependency feature for the purpose of synchronizing cache with OleDb.

CLR Procedures in SQL Server with Cache
Explains how to write the CLR stored procedures for database to synchronize cache with the database.