The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 26, 2018
Filed:
Aug. 11, 2015
Oracle International Corporation, Redwood Shores, CA (US);
Michael J. Gleeson, Saratoga, CA (US);
Jesse Kamp, Castro Valley, CA (US);
Vineet Marwah, San Ramon, CA (US);
Tirthankar Lahiri, Palo Alto, CA (US);
Juan R. Loaiza, Woodside, CA (US);
Sanket Hase, Mountain View, CA (US);
Niloy Mukherjee, San Jose, CA (US);
Sujatha Muthulingam, San Ramon, CA (US);
Atrayee Mullick, Santa Clara, CA (US);
Allison L. Holloway, San Carlos, CA (US);
ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US);
Abstract
To prioritize repopulation of in-memory compression units (IMCU), a database server compresses, into an IMCU, a plurality of data units from a database table. In response to changes to any of the plurality of data units within the database table, the database server performs the steps of: (a) invalidating corresponding data units in the IMCU; (b) incrementing an invalidity counter of the IMCU that reflects how many data units within the IMCU have been invalidated; (c) receiving a data request that targets one or more of the plurality of data units of the database table; (d) in response to receiving the data request, incrementing an access counter of the IMCU; and (e) determining a priority for repopulating the IMCU based, at least in part, on the invalidity counter and the access counter.