公开(公告)号：US11567934B2

公开(公告)日：2023-01-31

申请号：US15958517

申请日：2018-04-20

Applicant: Oracle International Corporation

Inventor： Mehul Bastawala ,  Atrayee Mullick ,  George Eadon ,  Ramesh Kumar

IPC: G06F16/2453 ,  G06F12/0891 ,  G06F16/23

Abstract: An approach for implementing function semantic based partition-wise SQL execution and partition pruning in a data processing system is provided. The system receives a query directed to a range-partitioned table and determines if operation key(s) of the query include function(s) over the table partitioning key(s). If so, the system obtains a set of values corresponding to each partition by evaluating the function(s) on a low bound and/or a high bound table partitioning key value corresponding to the partition. The system may then compare the sets of values corresponding to different partitions and determine whether to aggregate results obtained by executing the query over the partitions based on the comparison. The system may also determine whether to prune any partitions from processing based on a set of correlations between the set of values for each partition and predicate(s) of the query including function(s) over the table partitioning key(s).

公开(公告)号：US20190325052A1

公开(公告)日：2019-10-24

申请号：US15958517

申请日：2018-04-20

Applicant: Oracle International Corporation

Inventor： Mehul Bastawala ,  Atrayee Mullick ,  George Eadon ,  Ramesh Kumar

IPC: G06F17/30 ,  G06F12/0891

Abstract: An approach for implementing function semantic based partition-wise SQL execution and partition pruning in a data processing system is provided. The system receives a query directed to a range-partitioned table and determines if operation key(s) of the query include function(s) over the table partitioning key(s). If so, the system obtains a set of values corresponding to each partition by evaluating the function(s) on a low bound and/or a high bound table partitioning key value corresponding to the partition. The system may then compare the sets of values corresponding to different partitions and determine whether to aggregate results obtained by executing the query over the partitions based on the comparison. The system may also determine whether to prune any partitions from processing based on a set of correlations between the set of values for each partition and predicate(s) of the query including function(s) over the table partitioning key(s).

公开(公告)号：US10216781B2

公开(公告)日：2019-02-26

申请号：US14983496

申请日：2015-12-29

Applicant: Oracle International Corporation

Inventor： Sanket Hase ,  Neil MacNaughton ,  Vivekanandhan Raja ,  Atrayee Mullick ,  Vineet Marwah ,  Amit Ganesh

IPC: G06F12/14 ,  G06F17/30 ,  G06F12/084 ,  G06F12/0868 ,  G06F12/0875

Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for chunks of data stored in memory in each particular node in the cluster by tracking locks granted by a lock manager. During a pre-loading operation, each given node requests a set of shared locks associated with the chunks of data to be store in the given node's memory. When a request to release one of these shared locks occurs, the in-memory copy of those data items may be invalidated in the node releasing its shared lock.

公开(公告)号：US20160350363A1

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

申请号：US14983481

申请日：2015-12-29

Applicant: Oracle International Corporation

Inventor： Vivekanandhan Raja ,  Atrayee Mullick ,  Sanket Hase ,  Sukhada Pendse ,  Amit Ganesh ,  Vineet Marwah ,  Neil MacNaughton

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F3/065 ,  G06F17/30353 ,  G06F17/30362 ,  G06F17/30371

Abstract: Techniques are herein described for loading a portion of a database object into volatile memory without blocking database manipulation language transactions. The techniques involve invalidating data items loaded from blocks affected by a transaction, referred to as a straddling transaction that started before the load time and committed after the load time. Identifying these straddling transactions involves reviewing one or more transaction lists associated with the set of data items loaded in memory. The transaction list may be read in reverse temporal order of commit to identify a transaction meeting the criteria of starting before the load start, not committing before the load time, and affecting a data item loaded in memory.

Abstract translation: 这里描述了将数据库对象的一部分加载到易失性存储器中而不阻止数据库操作语言事务的技术。 这些技术涉及使由事务影响的块加载的数据项无效，称为在加载时间之前启动并在加载时间后提交的跨接事务。 识别这些跨越事务涉及查看与加载在存储器中的数据项集相关联的一个或多个事务列表。 交易列表可以以提交的反时间顺序读取，以识别满足在加载开始之前开始的准则的事务，而不是在加载时间之前提交，并影响加载到存储器中的数据项。

公开(公告)号：US20150088822A1

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

申请号：US14337183

申请日：2014-07-21

Applicant: Oracle International Corporation

Inventor： Vivekanandhan Raja ,  Sanket Hase ,  Amit Ganesh ,  Vineet Marwah ,  Shuang Su ,  Atrayee Mullick ,  Sukhada Pendse

IPC: G06F17/30

CPC classification number: G06F17/30371 ,  G06F17/30324 ,  G06F17/30356 ,  G06F17/30507 ,  G06F17/30578 ,  G06F17/30581

Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

Abstract translation: 提供的技术用于以一种格式持续保持数据，但使数据库可以以多种格式提供给数据库服务器。 例如，数据可用于查询处理的格式之一是基于磁盘格式，而数据可用于查询处理的另一种格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中，以减少与保持数据与数据的磁盘格式副本同步的开销。

公开(公告)号：US20150088811A1

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

申请号：US14337182

申请日：2014-07-21

Applicant: Oracle International Corporation

Inventor： Sanket Hase ,  Vivekanandhan Raja ,  Amit Ganesh ,  Vineet Marwah ,  Sukhada Pendse ,  Shuang Su ,  Atrayee Mullick

IPC: G06F17/30

CPC classification number: G06F17/30592 ,  G06F17/30088 ,  G06F17/30185 ,  G06F17/30345

Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

Abstract translation: 提供的技术用于以一种格式持续保持数据，但使数据库可以以多种格式提供给数据库服务器。 例如，数据可用于查询处理的格式之一是基于磁盘格式，而数据可用于查询处理的另一种格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中，以减少与保持数据与数据的磁盘格式副本同步的开销。

公开(公告)号：US10067974B2

公开(公告)日：2018-09-04

申请号：US14983481

申请日：2015-12-29

Applicant: Oracle International Corporation

Inventor： Vivekanandhan Raja ,  Atrayee Mullick ,  Sanket Hase ,  Sukhada Pendse ,  Amit Ganesh ,  Vineet Marwah ,  Neil MacNaughton

IPC: G06F17/30 ,  G06F3/06

Abstract: Techniques are herein described for loading a portion of a database object into volatile memory without blocking database manipulation language transactions. The techniques involve invalidating data items loaded from blocks affected by a transaction, referred to as a straddling transaction that started before the load time and committed after the load time. Identifying these straddling transactions involves reviewing one or more transaction lists associated with the set of data items loaded in memory. The transaction list may be read in reverse temporal order of commit to identify a transaction meeting the criteria of starting before the load start, not committing before the load time, and affecting a data item loaded in memory.

公开(公告)号：US10007691B2

公开(公告)日：2018-06-26

申请号：US14823393

申请日：2015-08-11

Applicant: Oracle International Corporation

Inventor： Michael J. Gleeson ,  Jesse Kamp ,  Vineet Marwah ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Sanket Hase ,  Niloy Mukherjee ,  Sujatha Muthulingam ,  Atrayee Mullick ,  Allison L. Holloway

IPC: G06F17/30

CPC classification number: G06F16/2282 ,  G06F16/2379 ,  G06F16/273

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.

公开(公告)号：US20170344593A1

公开(公告)日：2017-11-30

申请号：US15169013

申请日：2016-05-31

Applicant: Oracle International Corporation

Inventor： Atrayee Mullick ,  Niloy Mukherjee ,  Sanket Hase ,  Tirthankar Lahiri ,  Juan Loaiza

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F16/2329 ,  G06F11/1446 ,  G06F11/1451 ,  G06F16/128 ,  G06F16/1873 ,  G06F16/2358 ,  G06F16/24552 ,  G06F16/258 ,  G06F16/273 ,  G06F2201/80 ,  G06F2201/84

Abstract: Techniques for non-disruptive versioning of in-memory units in a database are provided. A database server generates and maintains a first IMU that reflects changes made to a mirrored-data-set up to a first snapshot time, and a second IMU that reflects changes made to the mirrored-data-set up to a second snapshot time. During a first period, the database server responds to updates to first data items in the mirrored data by storing first staleness metadata that indicates that the copies of the first data items in the first IMU are stale. During a second period, the database server responds to updates to second data items in the mirrored data by storing second staleness metadata that indicates that the copies of the second data items in the second IMU are stale. The database server responds to a request by accessing the first IMU or the second IMU.

公开(公告)号：US09323799B2

公开(公告)日：2016-04-26

申请号：US14337182

申请日：2014-07-21

Applicant: Oracle International Corporation

Inventor： Sanket Hase ,  Vivekanandhan Raja ,  Amit Ganesh ,  Vineet Marwah ,  Sukhada Pendse ,  Shuang Su ,  Atrayee Mullick

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC classification number: G06F17/30592 ,  G06F17/30088 ,  G06F17/30185 ,  G06F17/30345

Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

Abstract translation: 提供的技术用于以一种格式持续保持数据，但使数据库可以以多种格式提供给数据库服务器。 例如，数据可用于查询处理的格式之一是基于磁盘格式，而数据可用于查询处理的另一种格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中，以减少与保持数据与数据的磁盘格式副本同步的开销。