公开(公告)号：US20170116230A1

公开(公告)日：2017-04-27

申请号：US15299418

申请日：2016-10-20

Applicant: Oracle International Corporation

Inventor： Mohamed ZAIT ,  Sunil Parrokkaren CHAKKAPPEN ,  Jiaqi YAN

IPC: G06F17/30

Abstract: Systems for database system management. A method embodiment commences upon intercepting a feature or command that is issued from a software application that interfaces with a database management system. Rules are used to identify that the feature or command is of a first type (e.g., an older type). The feature or command is analyzed to determine if it is a candidate to be modified or upgraded to implement a newer feature or command of a second type (e.g., a newer type). Modifications are made to the old feature or command of the first type to implement a new feature or command of a second type. The new feature or command of the second type is sent to the database management system for processing.

公开(公告)号：US20160378829A1

公开(公告)日：2016-12-29

申请号：US14753179

申请日：2015-06-29

Applicant: Oracle International Corporation

Inventor： David VENGEROV ,  Mohamed ZAIT ,  Sunil P. CHAKKAPPEN ,  Andre MENCK

IPC: G06F17/30

CPC classification number: G06F16/24545

Abstract: A system performs database management. The system receives a request for a query of a plurality of tables under a join condition on an attribute and determines a uniform mapping that maps a domain of the attribute into a set of numbers, where the domain of the attribute includes all attribute values taken by the attribute in the tables. Then, for a row in a table, the system includes the row into a synopsis of the table if the row includes an attribute value that is mapped by the uniform mapping to a number less than an inclusion probability associated with the table. The system obtains a plurality of synopsis for the tables by repeating the including for all rows in the table and for all tables, and determines, based on the plurality of synopsis, an estimate join size of the tables under the join condition.

Abstract translation: 系统执行数据库管理。 系统在属性的接合条件下接收对多个表的查询的请求，并且确定将属性的域映射成一组数字的统一映射，其中属性的域包括由 表中的属性。 然后，对于表中的一行，如果行包含通过统一映射映射到小于与表相关联的包含概率的数字的属性值，则系统将行包含在表的概要中。 系统通过对表中的所有行重复包括表和所有表来获得表的多个概要，并且基于多个概要确定在连接条件下的表的估计连接大小。

公开(公告)号：US20150088857A1

公开(公告)日：2015-03-26

申请号：US14557213

申请日：2014-12-01

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Allison LEE ,  Mohamed ZAIT ,  Yali ZHU

IPC: G06F17/30

CPC classification number: G06F16/24545

Abstract: An improved method, system, and computer program product is disclosed that provides a hybrid approach to optimization which allows different subsets of data accessed by a query to be optimized with different access paths and execution approaches. Transformations may be performed to re-write the query, which restructures the query in a way that facilitates the hybrid optimization process. Multiple transformations may be interleaved to produce an efficient re-written query.

Abstract translation: 公开了一种改进的方法，系统和计算机程序产品，其提供了优化的混合方法，其允许通过不同的访问路径和执行方法来优化由查询访问的不同的数据子集。 可以执行转换以重新编写查询，其以促进混合优化过程的方式重新构建查询。 可以交织多个变换以产生有效的重写查询。