US Patent:
20110066791, Mar 17, 2011
Inventors:
Kiran Badrinarain Goyal - Foster City CA, US
Neil J.S. Macnaughton - Los Gatos CA, US
Eugene Ho - Fremont CA, US
Adam Y. Lee - San Jose CA, US
Vipin Gokhale - San Ramon CA, US
Wei-Ming Hu - Palo Alto CA, US
Juan R. Loaiza - Woodside CA, US
Kothanda Umamageswaran - Sunnyvale CA, US
Bharat C.V. Baddepudi - San Jose CA, US
Boris Erlikhman - Mountain View CA, US
Alexander Tsukerman - Foster City CA, US
Selcuk Aya - Redwood City CA, US
Roger Hansen - San Francisco CA, US
Adrian Ng - Menlo Park CA, US
Assignee:
ORACLE INTERNATIONAL CORPORATION - REDWOOD SHORES CA
International Classification:
G06F 12/00
US Classification:
711103, 711118, 711E12001
Abstract:
Techniques are provided for using an intermediate cache between the shared cache of a database server and the non-volatile storage of a storage system. The intermediate cache may be local to the machine upon which the database server is executing, or may be implemented within the storage system. In one embodiment, the database system includes both a DB server-side intermediate cache, and a storage-side intermediate cache. The caching policies used to populate the intermediate cache are intelligent, taking into account factors that may include which database object an item belongs to, the item type of the item, a characteristic of the item; or the database operation in which the item is involved.