US 10,120,895 B2Granted

Mirroring, in memory, data from disk to improve query performance

AssigneeOracle International Corporation

InventorsJesse 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

Life of this patent

Estimating the term…

patentgrep

Loading patent…

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.

Claims38

Dependent claims

A method comprising:

maintaining, on persistent storage, a database that is accessible to a database server running on one or more computer systems;
wherein the database includes persistent-format data, stored on the persistent storage, in a persistent format;
converting, by the one or more computer systems, the persistent-format data to a mirror format to produce mirror-format data;
storing, by the one or more computer systems, the mirror-format data within volatile memory;
wherein the mirror format is different from the persistent format;
wherein, within the volatile memory, the mirror-format data is accessible to the database server;
wherein each data item in the mirror-format data is a copy of a corresponding data item in the persistent-format data;
receiving, by the database server, a request to execute a database command that requires a required set of data items;
and
during execution of the database command:
the database server obtaining a first subset of data items, of the required set of data items, from the persistent-format data, and
the database server obtaining a second subset of data items, of the required set of data items, from the mirror-format data;
wherein, when the database server receives the request to execute the database command, a current version of each data item in the second subset of data items exists in both the persistent-format data and the mirror-format data;
wherein the first subset of data items is obtained from the persistent-format data based on the database server determining that obtaining the first subset of data items, for execution of the database command, from the persistent-format data would be more efficient than obtaining the first subset of data items, for execution of the database command, from the mirror-format data.

11 more elements

A method comprising:

maintaining, on persistent storage, a database that is accessible to a database server running on one or more computer systems;
wherein the database includes persistent-format data, stored on the persistent storage, in a persistent format;
converting, by the one or more computer systems, the persistent-format data to a mirror format to produce mirror-format data;
storing, by the one or more computer systems, the mirror-format data within volatile memory;
wherein the mirror format is different from the persistent format;
wherein, within the volatile memory, the mirror-format data is accessible to the database server;
wherein each data item in the mirror-format data is a copy of a corresponding data item in the persistent-format data;
receiving, by the database server, a request to execute a database command that requires a required set of data items;
and
during execution of the database command:
the database server obtaining a first subset of data items, of the required set of data items, from the persistent-format data, and
the database server obtaining a second subset of data items, of the required set of data items, from the mirror-format data based on the database server determining that obtaining the second subset of data items, for execution of the database command, from the mirror-format data would be more efficient than obtaining the second subset of data items, for execution of the database command, from the persistent-format data;
wherein, when the database server receives the request to execute the database command, a current version of each data item in the second subset of data items exists in both the persistent-format data and the mirror-format data.

10 more elements

One or more non-transitory computer-readable media storing instructions which, when executed by one or more processors, cause:

maintaining, on persistent storage, a database that is accessible to a database server running on one or more computer systems;
wherein the database includes persistent-format data, stored on the persistent storage, in a persistent format;
converting the persistent-format data to a mirror format to produce mirror-format data;
storing the mirror-format data within volatile memory;
wherein the mirror format is different from the persistent format;
wherein, within the volatile memory, the mirror-format data is accessible to the database server;
wherein each data item in the mirror-format data is a copy of a corresponding data item in the persistent-format data;
receiving, by the database server, a request to execute a database command that requires a required set of data items;
and
during execution of the database command:
the database server obtaining a first subset of data items, of the required set of data items, from the persistent-format data, and
the database server obtaining a second subset of data items, of the required set of data items, from the mirror-format data;
wherein, when the database server receives the request to execute the database command, a current version of each data item in the second subset of data items exists in both the persistent-format data and the mirror-format data;
wherein the first subset of data items is obtained from the persistent-format data based on the database server determining that obtaining the first subset of data items, for execution of the database command, from the persistent-format data would be more efficient than obtaining the first subset of data items, for execution of the database command, from the mirror-format data.

11 more elements

One or more non-transitory computer-readable media storing instructions which, when executed by one or more processors, cause:

maintaining, on persistent storage, a database that is accessible to a database server running on one or more computer systems;
wherein the database includes persistent-format data, stored on the persistent storage, in a persistent format;
converting the persistent-format data to a mirror format to produce mirror-format data;
storing the mirror-format data within volatile memory;
wherein the mirror format is different from the persistent format;
wherein, within the volatile memory, the mirror-format data is accessible to the database server;
wherein each data item in the mirror-format data is a copy of a corresponding data item in the persistent-format data;
receiving, by the database server, a request to execute a database command that requires a required set of data items;
and
during execution of the database command:
the database server obtaining a first subset of data items, of the required set of data items, from the persistent-format data, and
the database server obtaining a second subset of data items, of the required set of data items, from the mirror-format data based on the database server determining that obtaining the second subset of data items, for execution of the database command, from the mirror-format data would be more efficient than obtaining the second subset of data items, for execution of the database command, from the persistent-format data;
wherein, when the database server receives the request to execute the database command, a current version of each data item in the second subset of data items exists in both the persistent-format data and the mirror-format data.

10 more elements

Dependencies are inferred from the claim text.

Facts

Application: 15/877,125Filed 22 Jan 2018 · continuation
Priority: 21 Sep 2013
Published: US 2018/0144023 A124 May 2018
Granted: 6 Nov 2018
Term ends: Not estimatedThe source records don’t support an estimate.

Classification13 codes

G06F 16/2379
Updating: updates performed during online database operations; commit processing
G06F 3/0619
Improving the reliability of storage systems: in relation to data integrity, e.g. data losses, bit errors
G06F 3/065
Horizontal data movement in storage systems, i.e. moving data in between storage devices or systems: replication mechanisms
G06F 3/0665
Virtualisation aspects: at area level, e.g. provisioning of virtual or logical volumes

Family

Application61/880,852Us provisional application · filed 21 Sep 2013
Application61/955,574Us provisional application · filed 19 Mar 2014
Application14/337,179Parent of this continuation · filed 21 Jul 2014
Application14/881,356Parent of this continuation · filed 13 Oct 2015
US 9,292,564 B2Parent of this continuation · filed 22 Mar 2016
US 2018/0144023 A1Pre-grant publication · published 24 May 2018
US 9,881,048 B2Parent of this continuation
US 2015/0088830 A1Published application
US 2016/0034214 A1Published application
US 10,120,895 B2This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key