公开(公告)号：US10372706B2

公开(公告)日：2019-08-06

申请号：US15146798

申请日：2016-05-04

Applicant: Oracle International Corporation

Inventor： Shasank K. Chavan ,  Aurosish Mishra ,  Mohamed Zait ,  Sunil P. Chakkappen ,  Can Tuzla ,  Jiaqi Yan

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2455 ,  G06F12/0802

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.

公开(公告)号：US20170031967A1

公开(公告)日：2017-02-02

申请号：US15146798

申请日：2016-05-04

Applicant: Oracle International Corporation

Inventor： Shasank K. Chavan ,  Aurosish Mishra ,  Mohamed Zait ,  Sunil P. Chakkappen ,  Can Tuzla ,  Jiaqi Yan

IPC: G06F17/30

CPC classification number: G06F16/2454 ,  G06F12/0802 ,  G06F16/2255 ,  G06F16/2282 ,  G06F16/23 ,  G06F16/2393 ,  G06F16/2453 ,  G06F16/2455 ,  G06F2212/60

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.

Abstract translation: 描述了用于维护表达式统计存储的技术，该表达式统计存储根据查询中的那些查询表达式的出现来存储和更新查询表达式的元数据值。 在一个实施例中，数据库服务器实例接收数据库查询。 作为响应，数据库服务器实例标识数据库查询中的表达式。 然后，数据库服务器实例确定表达式统计信息存储是否包含特定表达式的条目。 响应于确定表达式统计存储器包括特定表达式的条目，数据库服务器实例基于特定表达式的出现来更新条目中的至少一个元数据值。 响应于确定表达式统计信息存储不包含特定表达式的条目，数据库服务器实例为特定表达式添加条目。