公开(公告)号：US10372699B2

公开(公告)日：2019-08-06

申请号：US15264978

申请日：2016-09-14

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Solmaz Kolahi ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Vasudha Krishnaswamy ,  Sanket Hase

IPC: G06F16/23

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 which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.

公开(公告)号：US20180253463A1

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

申请号：US15908782

申请日：2018-02-28

Applicant: Oracle International Corporation

Inventor： Mehul Bastawala ,  Vivekanandhan Raja

IPC: G06F17/30 ,  G06F15/18

CPC classification number: G06F16/2365 ,  G06F15/76 ,  G06F16/23 ,  G06F16/2322 ,  G06F16/2471 ,  G06F16/2477 ,  G06F16/27 ,  G06N20/00

Abstract: Techniques are described that are performed by one or more database management system (DBMS) of the plurality of DBMS nodes comprising one or more database servers performing database operations on one or more databases of the DBMS nodes. The techniques describe receiving, at a QC node, a distributed query that specifying a database of a target DBMS node. Without requesting from the target DBMS node a current logical timestamp of the DBMS node, calculating a synchronization timestamp for the distributed query. In one embodiment, the calculation of the synchronization timestamp for the distributed query is based on a current logical timestamp of the QC node and one or more previous logical timestamps of the target DBMS node that were received prior to the receiving the distributed query. The QC node sends a request to the target DBMS node to execute an operation of the query at the target DBMS node based on the synchronization timestamp. The QC node may receive result set(s) from all the target DBMS nodes based on the synchronization timestamp, and aggregate the final result set to return to the client application.

公开(公告)号：US09984096B2

公开(公告)日：2018-05-29

申请号：US15087895

申请日：2016-03-31

Applicant: Oracle International Corporation

Inventor： Paul Parkinson ,  Todd J. Little ,  Carol Colrain ,  Jean De Lavarene ,  Vivekanandhan Raja ,  Douglas Surber ,  Stefan Roesch ,  Nancy Ikeda ,  Kevin Neel

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F17/30227 ,  G06F9/46 ,  G06F9/466

Abstract: A system and method for reducing communications overhead in a distributed transaction processing environment such as an XA environment. In accordance with an embodiment communication overhead is reduced in a transaction start method by deferring a transaction start communication. The deferred transaction start communication is determined from a subsequent transaction processing communication thereby reducing the number of networks calls required for each transaction and enhancing system performance.

公开(公告)号：US20180075079A1

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

申请号：US15264978

申请日：2016-09-14

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Solmaz Kolahi ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Vasudha Krishnaswamy ,  Sanket Hase

IPC: G06F17/30

CPC classification number: G06F16/2322 ,  G06F16/2365

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 which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.

公开(公告)号：US11847110B2

公开(公告)日：2023-12-19

申请号：US17202024

申请日：2021-03-15

Applicant: Oracle International Corporation

Inventor： Sachin Vijaykumar Sonawane ,  Mahesh Baburao Girkar ,  Yunrui Li ,  Thomas Baby ,  Vivekanandhan Raja

IPC: G06F16/23 ,  G06F16/27 ,  G06F11/14

CPC classification number: G06F16/2365 ,  G06F16/2379 ,  G06F16/275 ,  G06F11/1458

Abstract: A database session in an active standby server on which an active standby database resides receives a DML statement. The session is suspended while the statement is redirected over a database link to a primary database on which the statement is executed. Information associated with execution of the statement is communicated to the session in the active standby server. Redo records describing changes to the contents of the primary database are applied to the active standby database and control is returned to the session. Prior to commitment of a transaction including the statement, a query directed to data to which the statement was directed is received at the active standby server from a client and executed on the active standby database absent use of a database link based on whether information associated with a database session associated with the client matches the information associated with execution of the statement.

公开(公告)号：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.

公开(公告)号：US20180060378A1

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

申请号：US15253630

申请日：2016-08-31

Applicant: Oracle International Corporation

Inventor： Kartik Kulkarni ,  Juan R. Loaiza ,  Vivekanandhan Raja ,  Kothanda Umamageswaran ,  Sanket Hase ,  Vasudha Krishnaswamy ,  Tirthankar Lahiri

IPC: G06F17/30

CPC classification number: G06F17/30371 ,  G06F17/30353 ,  G06F17/30368 ,  G06F17/30377 ,  G06F17/3056 ,  G06F17/30581

Abstract: A minimum value (MV) is computed for start timestamps that each correspond to an uncommitted transaction. In an embodiment, the MV is computed for a pluggable database that is open on at least first and second instances of a database. The MV is computed for the first instance as of a first current timestamp (CT). The MV and the first CT are communicated to a second instance that has a second CT. If the first and second CTs are equal, the second instance store the MV. If the first CT is bigger, the second CT also becomes equal to the first CT. If the first CT is smaller, the MV is discarded, and the first CT becomes equal to the second CT. In an embodiment, if the MV remains unchanged for a predetermined time period, a start timestamp corresponding to the MV is advanced to a current or future timestamp.

公开(公告)号：US20180060377A1

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

申请号：US15253626

申请日：2016-08-31

Applicant: Oracle International Corporation

Inventor： Kartik Kulkarni ,  Juan R. Loaiza ,  Vivekanandhan Raja ,  Kothanda Umamageswaran ,  Sanket Hase ,  Vasudha Krishnaswamy ,  Tirthankar Lahiri

IPC: G06F17/30

CPC classification number: G06F17/30371 ,  G06F17/30368 ,  G06F17/30377 ,  G06F17/3056

Abstract: A minimum value (MV) is computed for start timestamps that each correspond to an uncommitted transaction. In an embodiment, the MV is computed for a pluggable database that is open on at least first and second instances of a database. The MV is computed for the first instance as of a first current timestamp (CT). The MV and the first CT are communicated to a second instance that has a second CT. If the first and second CTs are equal, the second instance store the MV. If the first CT is bigger, the second CT also becomes equal to the first CT. If the first CT is smaller, the MV is discarded, and the first CT becomes equal to the second CT. In an embodiment, if the MV remains unchanged for a predetermined time period, a start timestamp corresponding to the MV is advanced to a current or future timestamp.

公开(公告)号：US09881048B2

公开(公告)日：2018-01-30

申请号：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: G06F17/30 ,  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.

公开(公告)号：US09639468B2

公开(公告)日：2017-05-02

申请号：US14506613

申请日：2014-10-04

Applicant: Oracle International Corporation

Inventor： Vivekanandhan Raja ,  Sanket Hase ,  Amit Ganesh ,  Vineet Marwah

IPC: G06F12/00 ,  G06F12/0815 ,  G06F17/30 ,  G06F15/78 ,  G06F12/1018 ,  G06F3/06

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 using bitmaps to indicate which items, in a set of items, are invalid. The bitmaps include an “active” bitmap and one or more “temporal clones”. The active bitmap indicates which items in the set are currently valid. The temporal clones are outdated versions of the active bitmap that indicate which items in the set were invalid at previously points in time. Temporal clones may not be very different from each other. Therefore, temporal clones may be efficiently compressed. For example, a bitmap may be selected as a “base bitmap”, and one or more other bitmaps are encoded using delta encoding. Run length encoding may then be applied to further compress the bitmap information. These bitmaps may then be used to determine which items are valid relative to past-version requests.