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

公开(公告)号：US11113250B2

公开(公告)日：2021-09-07

申请号：US16544570

申请日：2019-08-19

Applicant: Oracle International Corporation

Inventor： Liang Guo ,  Vivekanandhan Raja ,  Amit Ganesh ,  Joshua Gould

IPC: G06F17/00 ,  G06F16/185 ,  G06F16/21 ,  G06F16/22 ,  G06F16/27 ,  G06F16/11 ,  G06F3/06

Abstract: Techniques for activity tracking, data classification, and in-database archiving are described. Activity tracking refers to techniques that collect statistics related to user access patterns, such as the frequency or recency with which users access particular database elements. The statistics gathered through activity tracking can be supplied to data classification techniques to automatically classify the database elements or to assist users with manually classifying the database elements. Then, once the database elements have been classified, in-database archiving techniques can be employed to move database elements to different storage tiers based on the classifications. However, although the techniques related to activity tracking, data classification, and in-database archiving may be used together as described above; each technique may also be practiced separately.

公开(公告)号：US10949413B2

公开(公告)日：2021-03-16

申请号：US15885281

申请日：2018-01-31

Applicant: Oracle International Corporation

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

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

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.

公开(公告)号：US10248685B2

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

申请号：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

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.

公开(公告)号：US20180144023A1

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

申请号：US15877125

申请日：2018-01-22

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.

公开(公告)号：US20180096010A1

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

申请号：US15281718

申请日：2016-09-30

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Jesse Kamp ,  Tirthankar Lahiri ,  Maria Colgan ,  Vivekanandhan Raja ,  Vasudha Krishnaswamy ,  Aditi Gupta ,  Kartik Kulkarni

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F16/221 ,  G06F3/0604 ,  G06F3/064 ,  G06F3/067 ,  G06F16/2282 ,  G06F16/24552 ,  G06F16/27

Abstract: Techniques are described herein for distributing distinct portions of a database object across volatile memories of selected nodes of a plurality of nodes in a clustered database system. The techniques involve storing a unit-to-service mapping that associates a unit (a database object or portion thereof) to one or more database services. The one or more database services are mapped to one or more nodes. The nodes to which a service is mapped may include nodes in disjoint database systems, so long as those database systems have access to a replica of the unit. The database object is treated as in-memory enabled by nodes that are associated with the service, and are treated as not in-memory enabled by nodes that are not associated with the service.

公开(公告)号：US20180081767A1

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

申请号：US15273273

申请日：2016-09-22

Applicant: Oracle International Corporation

Inventor： Xiaoming He ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Sanket Hase

IPC: G06F11/14 ,  G06F3/06 ,  G06F17/30

Abstract: Techniques are described for maintaining coherency of a portion of a database object mirrored in a particular node of a database. The techniques involve maintaining invalidation logs which identify transactions that have committed to a database. Based on the invalidation logs, the particular node generates invalid-row ID metadata which identifies, for each system change number, one or more rows that are not transactionally consistent with data stored in the database object as of said system change number.

公开(公告)号：US20170322999A1

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

申请号：US15662061

申请日：2017-07-27

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.