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:
Aug. 06, 2019
Filed:
May. 04, 2016
Oracle International Corporation, Redwood Shores, CA (US);
Shasank K. Chavan, Menlo Park, CA (US);
Aurosish Mishra, Belmont, CA (US);
Mohamed Zait, San Jose, CA (US);
Sunil P. Chakkappen, Foster City, CA (US);
Can Tuzla, San Mateo, CA (US);
Jiaqi Yan, San Carlos, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques are described for maintaining an expression statistics store that stores and updates metadata values for query expressions based on the occurrence of those query expressions within queries. In an embodiment, a database server instance receives a database query. In response, the database server instance identifies expressions within the database queries. The database server instance then determines whether an expression statistics store includes an entry for the particular expression. Responsive to determining that the expression statistics store includes an entry for the particular expression, the database server instance updates at least one metadata value in the entry based on the occurrence of the particular expression. Responsive to determining that the expression statistics store does not include an entry for the particular expression, the database server instance adds an entry for the particular expression.