公开(公告)号：US10268746B2

公开(公告)日：2019-04-23

申请号：US15662061

申请日：2017-07-27

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

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.

公开(公告)号：US10268636B2

公开(公告)日：2019-04-23

申请号：US15268458

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Ankita Kumar ,  Sanket Hase

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2455 ,  G06F16/332

Abstract: Techniques are provided for maintaining and using row-level and column-level invalidation information for a copy of data items stored in-memory via a row-bitmap and column-bitmap. The row-bitmap and column-bitmap can be used to determine whether a database query can be processed using in-memory data or not. The row-bitmap and column-bitmap can thus improve the frequency with which database queries can be processed using in-memory data.

公开(公告)号：US20180081926A1

公开(公告)日：2018-03-22

申请号：US15268458

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Ankita Kumar ,  Sanket Hase

IPC: G06F17/30

CPC classification number: G06F17/30371 ,  G06F17/30315 ,  G06F17/30324 ,  G06F17/30377 ,  G06F17/3048 ,  G06F17/30654

Abstract: Techniques are provided for maintaining and using row-level and column-level invalidation information for a copy of data items stored in-memory via a row-bitmap and column-bitmap. The row-bitmap and column-bitmap can be used to determine whether a database query can be processed using in-memory data or not. The row-bitmap and column-bitmap can thus improve the frequency with which database queries can be processed using in-memory data.

公开(公告)号：US09798794B2

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

申请号：US15005610

申请日：2016-01-25

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.

公开(公告)号：US20160085834A1

公开(公告)日：2016-03-24

申请号：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: G06F17/30339 ,  G06F17/30377 ,  G06F17/30578

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.

Abstract translation: 为了优先重新填充内存中的压缩单元（IMCU），数据库服务器从数据库表将多个数据单元压缩到IMCU中。 响应于对数据库表内的多个数据单元中的任一个的改变，数据库服务器执行以下步骤：（a）使IMCU中的相应数据单元无效; （b）增加反映IMCU内有多少数据单位无效的IMCU的无效计数器; （c）接收针对所述数据库表的所述多个数据单元中的一个或多个的数据请求; （d）响应于接收到数据请求，递增IMCU的访问计数器; 以及（e）至少部分地基于无效计数器和访问计数器确定重新填充IMCU的优先级。

公开(公告)号：US20160034214A1

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

申请号：US14881356

申请日：2015-10-13

Applicant: Oracle International Corporation

Inventor： Jesse Kamp ,  Amit Ganesh ,  Vineet Marwah ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Allison L. Holloway ,  Sanket Hase ,  Shasank K. Chavan ,  Niloy Mukherjee ,  Teck Hua Lee ,  Michael J. Gleeson ,  Krishna Kunchithapadam

IPC: G06F3/06 ,  G06F11/20

CPC classification number: G06F17/30377 ,  G06F3/0619 ,  G06F3/065 ,  G06F3/0665 ,  G06F3/0689 ,  G06F11/2058 ,  G06F17/30315 ,  G06F17/30442 ,  G06F17/30575 ,  G06F17/30581 ,  G06F2201/80 ,  G06F2201/855

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.

公开(公告)号：US20150339343A1

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

申请号：US14819016

申请日：2015-08-05

Applicant: Oracle International Corporation

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

IPC: G06F17/30 ,  G06F11/14

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.

公开(公告)号：US20150088830A1

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

申请号：US14337179

申请日：2014-07-21

Applicant: Oracle International Corporation

Inventor： Jesse Kamp ,  Amit Ganesh ,  Vineet Marwah ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Allison L. Holloway ,  Sanket Hase ,  Shasank K. Chavan ,  Niloy Mukherjee ,  Teck Hua Lee ,  Michael J. Gleeson ,  Krishna Kunchithapadam

IPC: G06F17/30

CPC classification number: G06F17/30377 ,  G06F3/0619 ,  G06F3/065 ,  G06F3/0665 ,  G06F3/0689 ,  G06F11/2058 ,  G06F17/30315 ,  G06F17/30442 ,  G06F17/30575 ,  G06F17/30581 ,  G06F2201/80 ,  G06F2201/855

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

公开(公告)号：US20150088824A1

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

申请号：US14337045

申请日：2014-07-21

Applicant: Oracle International Corporation

Inventor： Jesse Kamp ,  Vineet Marwah ,  Amit Ganesh ,  Michael Gleeson ,  Maheswaran Venkatachalam ,  Allison Holloway ,  Niloy Mukherjee ,  Sanket Hase

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F3/0604 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0689 ,  G06F12/0815 ,  G06F12/1018 ,  G06F15/78 ,  G06F15/8007 ,  G06F15/8076 ,  G06F15/8084 ,  G06F17/30312 ,  G06F17/30377 ,  G06F17/30477 ,  G06F17/30595 ,  G06F2003/0697 ,  G06F2212/1021 ,  G06F2212/1032 ,  G06F2212/2542 ,  G06F2212/313

Abstract: Techniques are provided for granular load and refresh of columnar data. In an embodiment, a particular data object that contains particular data formatted different from column-major format is maintained, the particular data including first data and second data. First and second data objects contain the first and second data, respectively, organized in the column-major format. In response to changes being committed to the first data in the particular data object, invalidating one or more rows of the first data object. In response to a number of invalidated rows of the first data object exceeding a threshold, automatically performing a refresh operation on the first data object independent of any refresh operation on the second data object.

Abstract translation: 提供了粒度负载和刷新柱状数据的技术。 在一个实施例中，保持包含格式不同于列主格式的特定数据的特定数据对象，该特定数据包括第一数据和第二数据。 第一和第二数据对象分别包含以列主格式组织的第一和第二数据。 响应于对特定数据对象中的第一数据提交的更改，使第一数据对象的一行或多行无效。 响应于第一数据对象的多个无效行超过阈值，自动对第一数据对象执行刷新操作，而与第二数据对象上的任何刷新操作无关。