公开(公告)号：US08838894B2

公开(公告)日：2014-09-16

申请号：US14101306

申请日：2013-12-09

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Cetin Ozbutun ,  Juan Loaiza ,  Kirk Bradley

IPC: G06F13/16 ,  G06F3/06

CPC classification number: G06F3/0689 ,  G06F3/0604 ,  G06F3/064 ,  G06F12/0207 ,  G06F12/0246 ,  G06F12/0607 ,  G06F2212/7208

Abstract: A method, device, and computer readable medium for striping rows of data across logical units of storage with an affinity for columns is provided. Alternately, a method, device, and computer readable medium for striping columns of data across logical units of storage with an affinity for rows is provided. When data of a logical slice is requested, a mapping may provide information for determining which logical unit is likely to store the logical slice. In one embodiment, data is retrieved from logical units that are predicted to store the logical slice. In another embodiment, data is retrieved from several logical units, and the data not mapped to the logical unit is removed from the retrieved data.

Abstract translation: 提供了一种方法，设备和计算机可读介质，用于跨逻辑存储单元条带化数据行，并且具有对列的亲和性。 或者，提供了一种方法，设备和计算机可读介质，用于以对行进行亲和度的跨存储的逻辑单元条带化数据列。 当请求逻辑片的数据时，映射可以提供用于确定哪个逻辑单元可能存储逻辑片的信息。 在一个实施例中，从预测存储逻辑片的逻辑单元检索数据。 在另一个实施例中，从多个逻辑单元检索数据，并且从所检索的数据中去除未映射到逻辑单元的数据。

公开(公告)号：US08627006B2

公开(公告)日：2014-01-07

申请号：US13633091

申请日：2012-10-01

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Cetin Ozbutun ,  Juan Loaiza ,  Kirk Bradley

IPC: G06F13/16

CPC classification number: G06F3/0689 ,  G06F3/0604 ,  G06F3/064 ,  G06F12/0207 ,  G06F12/0246 ,  G06F12/0607 ,  G06F2212/7208

Abstract: A method, device, and computer readable medium for striping rows of data across logical units of storage with an affinity for columns is provided. Alternately, a method, device, and computer readable medium for striping columns of data across logical units of storage with an affinity for rows is provided. When data of a logical slice is requested, a mapping may provide information for determining which logical unit is likely to store the logical slice. In one embodiment, data is retrieved from logical units that are predicted to store the logical slice. In another embodiment, data is retrieved from several logical units, and the data not mapped to the logical unit is removed from the retrieved data.

公开(公告)号：US10089357B2

公开(公告)日：2018-10-02

申请号：US14864776

申请日：2015-09-24

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ashok Shivarudraiah ,  Garret Swart ,  Cetin Ozbutun

IPC: G06F17/30

Abstract: A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table.

公开(公告)号：US20140164696A1

公开(公告)日：2014-06-12

申请号：US14101306

申请日：2013-12-09

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Cetin Ozbutun ,  Juan Loaiza ,  Kirk Bradley

IPC: G06F3/06

CPC classification number: G06F3/0689 ,  G06F3/0604 ,  G06F3/064 ,  G06F12/0207 ,  G06F12/0246 ,  G06F12/0607 ,  G06F2212/7208

Abstract: A method, device, and computer readable medium for striping rows of data across logical units of storage with an affinity for columns is provided. Alternately, a method, device, and computer readable medium for striping columns of data across logical units of storage with an affinity for rows is provided. When data of a logical slice is requested, a mapping may provide information for determining which logical unit is likely to store the logical slice. In one embodiment, data is retrieved from logical units that are predicted to store the logical slice. In another embodiment, data is retrieved from several logical units, and the data not mapped to the logical unit is removed from the retrieved data.

Abstract translation: 提供了一种方法，设备和计算机可读介质，用于跨逻辑存储单元条带化数据行，并且具有对列的亲和性。 或者，提供了一种方法，设备和计算机可读介质，用于以对行进行亲和度的跨存储的逻辑单元条带化数据列。 当请求逻辑片的数据时，映射可以提供用于确定哪个逻辑单元可能存储逻辑片的信息。 在一个实施例中，从预测存储逻辑片的逻辑单元检索数据。 在另一个实施例中，从多个逻辑单元检索数据，并且从所检索的数据中去除未映射到逻辑单元的数据。

公开(公告)号：US11907218B1

公开(公告)日：2024-02-20

申请号：US17886804

申请日：2022-08-12

Applicant: Oracle International Corporation

Inventor： Sunil P. Chakkappen ,  Mohamed Ziauddin ,  Cetin Ozbutun ,  Palash Sharma ,  Yiqiong Zhang ,  Zhan Li

IPC: G06F16/2453 ,  G06F16/958

CPC classification number: G06F16/24542 ,  G06F16/972

Abstract: Techniques for automatically preventing execution plan regressions are provided. In one technique, in a first user database session, in response to receiving a first database statement, a first execution plan is generated and, while executing the first execution plan, first performance data that indicates one or more first performance metrics of executing the first execution plan is recorded. In response to receiving a second database statement, where the first execution plan may be used to generate a result for the second database statement, a second execution plan is generated and second performance data that indicates one or more second performance metrics of executing the second execution plan is recorded. A comparison between the first performance data and the second performance data is performed. Based on the comparison, it is determined whether the second execution plan will be stored for future use to process a database statement.

公开(公告)号：US20240054127A1

公开(公告)日：2024-02-15

申请号：US17886804

申请日：2022-08-12

Applicant: Oracle International Corporation

Inventor： Sunil P. Chakkappen ,  Mohamed Ziauddin ,  Cetin Ozbutun ,  Palash Sharma ,  Yiqiong Zhang ,  Zhan Li

IPC: G06F16/2453 ,  G06F16/958

CPC classification number: G06F16/24542 ,  G06F16/972

Abstract: Techniques for automatically preventing execution plan regressions are provided. In one technique, in a first user database session, in response to receiving a first database statement, a first execution plan is generated and, while executing the first execution plan, first performance data that indicates one or more first performance metrics of executing the first execution plan is recorded. In response to receiving a second database statement, where the first execution plan may be used to generate a result for the second database statement, a second execution plan is generated and second performance data that indicates one or more second performance metrics of executing the second execution plan is recorded. A comparison between the first performance data and the second performance data is performed. Based on the comparison, it is determined whether the second execution plan will be stored for future use to process a database statement.

公开(公告)号：US20130024612A1

公开(公告)日：2013-01-24

申请号：US13633091

申请日：2012-10-01

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Cetin Ozbutun ,  Juan Loaiza ,  Kirk Bradley

IPC: G06F12/00

CPC classification number: G06F3/0689 ,  G06F3/0604 ,  G06F3/064 ,  G06F12/0207 ,  G06F12/0246 ,  G06F12/0607 ,  G06F2212/7208

Abstract: A method, device, and computer readable medium for striping rows of data across logical units of storage with an affinity for columns is provided. Alternately, a method, device, and computer readable medium for striping columns of data across logical units of storage with an affinity for rows is provided. When data of a logical slice is requested, a mapping may provide information for determining which logical unit is likely to store the logical slice. In one embodiment, data is retrieved from logical units that are predicted to store the logical slice. In another embodiment, data is retrieved from several logical units, and the data not mapped to the logical unit is removed from the retrieved data.

Abstract translation: 提供了一种方法，设备和计算机可读介质，用于跨逻辑存储单元条带化数据行，并且具有对列的亲和性。 或者，提供了一种方法，设备和计算机可读介质，用于以对行进行亲和度的跨存储的逻辑单元条带化数据列。 当请求逻辑片的数据时，映射可以提供用于确定哪个逻辑单元可能存储逻辑片的信息。 在一个实施例中，从预测存储逻辑片的逻辑单元检索数据。 在另一个实施例中，从多个逻辑单元检索数据，并且从所检索的数据中去除未映射到逻辑单元的数据。