Home arrow Oracle arrow Page 4 - Generic Architecture for Caching Table Data: Keeping It Real (and Small)

Conclusion - Oracle

In the third installment of this series we will add some more functionality to the cache that will alleviate some of the drawbacks that we discussed in earlier articles.

  1. Generic Architecture for Caching Table Data: Keeping It Real (and Small)
  2. Limit the size of the cache
  3. Showing the cache content
  4. Conclusion
By: Mark Vilrokx
Rating: starstarstarstarstar / 4
October 25, 2005

print this article



We have shown some techniques that can be used to manage the cache size and refresh records in the cache.  If we add this to the Caching Architecture we get the following:

  1. Create a cache.
  2. Create a procedure to empty the cache.
  3. Create a switch for the cache, a public procedure to “set” the switch and a function to verify what the switch is set to.
  4. Create a read, write and query procedure.
  5. Create Procedures to refresh the cache content.
  6. Create a global variable to store the maximum cache size, a public procedure to “set” the size and a function to verify what the size is set to.
  7. Create a data retrieval function.
  8. Create a log procedure.

In the next part of the series we will add procedures that monitor the effectiveness of our cache.

>>> More Oracle Articles          >>> More By Mark Vilrokx

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: