System and method for adaptive database caching

Details System and method for adaptive database caching System and method for adaptive database caching

2008-07-01

2008-07-01

Mizrahi, Diane D (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

10902583

ABSTRACT:
A local database cache enabling persistent, adaptive caching of either full or partial content of a remote database is provided. Content of tables comprising a local cache database is defined on per-table basis. A table is either: defined declaratively and populated in advance of query execution, or is determined dynamically and asynchronously populated on-demand during query execution. Based on a user input query originally issued against a remote DBMS and referential cache constraints between tables in a local database cache, a Janus query plan, comprising local, remote, and probe query portions is determined. A probe query portion of a Janus query plan is executed to determine whether up-to-date results can be delivered by the execution of a local query portion against a local database cache, or whether it is necessary to retrieve results from a remote database by executing a remote query portion of Janus query plan.

REFERENCES:
patent: 6122636 (2000-09-01), Malloy et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6493718 (2002-12-01), Petculescu et al.
patent: 6598058 (2003-07-01), Bird et al.
patent: 2002/0091712 (2002-07-01), Martin et al.
patent: 2003/0195941 (2003-10-01), Amiri et al.
patent: 2003/0208505 (2003-11-01), Mullins et al.
patent: 2003/0208510 (2003-11-01), Doyle et al.
patent: 2004/0153576 (2004-08-01), Hansmann et al.
patent: 2005/0256834 (2005-11-01), Millington et al.
Qiong Luo et al., “Middle-tier database cache for e-business”, 2002, ACM Press, NY, NY, pp. 600-611.
“Adaptive, Fine-Grained Sharing in a Client-Server OODBMS: A Callback-Based Approach;” Zaharioudakis et al.;ACM Transactions on Database Systems; vol. 22, No. 4; Dec. 1997; pp. 570-627.
“An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results;” Kalnis et al.;ACM SIGMOD; Jun. 2002; pp. 25-36.
“Dynamic Adaptive File Management in a Local Area Network;” Yang et al.;20thInternational Conference on Distributed Computing Systems(ICDCS); IEEE Proceedings; Apr. 2000.
“An Effective Wrapper Architecture to Heterogeneous Data Source;” Wang et al.;Proceedings of the 17thInternational Conference on Advanced Information Networking and Applications(AINA); Mar. 2003; pp. 1-4.
“A Highly Configurable and Adaptable Process Scheduler;” Shaffer et al.;IBM Technical Disclosure Bulletin; Apr. 2001; p. 630.
“MODEC: a Multi-Granularity Mobile Object-Oriented Database Caching Mechanism, Prototype and Performance;” Chan et al.;Distributed and Parallel Databases; vol. 7, No. 3; Jul. 1999; pp. 343-372.
“On Adaptive Caching in Mobile Databases;” Leong et al.;Proceedings of the 1997 ACM Symposium on Applied Computing; 1997; pp. 302-309.

Affiliated with

Also associated with

Rating

System and method for adaptive database caching does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for adaptive database caching, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for adaptive database caching will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3918538