公开(公告)号：EP3423954A1

公开(公告)日：2019-01-09

申请号：EP17711830.4

申请日：2017-02-27

Applicant: Oracle International Corporation

Inventor： GARVEY, Dustin ,  SHAFT, Uri ,  WONG, Lik ,  GANESH, Amit

IPC: G06F17/18 ,  G06Q10/04 ,  G06F21/55 ,  H04L29/06

公开(公告)号：EP3047400B1

公开(公告)日：2018-12-12

申请号：EP14786387.2

申请日：2014-09-15

Applicant: Oracle International Corporation

Inventor： RAJA, Vivekanandhan ,  HASE, Sanket ,  GANESH, Amit ,  MARWAH, Vineet ,  SU, Shuang ,  MULLICK, Atrayee ,  PENDSE, Sukhada

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.

公开(公告)号：EP3365811A1

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

申请号：EP16788924.5

申请日：2016-10-22

Applicant: Oracle International Corporation

Inventor： MACNICOL, Roger D. ,  SHAH, Viral ,  HUA, Xia ,  KAMP, Jesse ,  CHAVAN, Shasank K. ,  COLGAN, Maria ,  LAHIRI, Tirthankar ,  NG, Adrian Tsz Him ,  MEIYYAPPAN, Krishnan ,  GANESH, Amit ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  QIN, Yiran

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F3/061 ,  G06F3/0647 ,  G06F3/065 ,  G06F3/067 ,  G06F12/0811 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/30315 ,  G06F2212/1016 ,  G06F2212/163 ,  G06F2212/225

Abstract: Techniques are provided for storing in in-memory unit (IMU) in a lower-storage tier and copying the IMU to DRAM when needed for query processing. Techniques are also provided for copying IMUs to lower tiers of storage when evicted from the cache of higher tiers of storage. Techniques are provided for implementing functionality of IMUs within a storage system, to enable database servers to push tasks, such as filtering, to the storage system where the storage system may access IMUs within its own memory to perform the tasks. Metadata associated with a set of data may be used to indicate whether an IMU for the data should be created by the database server machine or within the storage system.

公开(公告)号：EP3345101A1

公开(公告)日：2018-07-11

申请号：EP16741444.0

申请日：2016-06-30

Applicant: Oracle International Corporation

Inventor： KRISHNAPPA, Chinmayi ,  MARWAH, Vineet ,  GANESH, Amit

IPC: G06F17/30

CPC classification number: G06F12/12 ,  G06F12/0802 ,  G06F17/3048 ,  G06F17/30569 ,  H03M7/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. Selection of data to be maintained in the volatile memory may be based on various factors. Once selected the data may also be compressed to save space in the volatile memory. The compression level may depend on one or more factors that are evaluated for the selected data. The factors for the selection and compression level of data may be periodically evaluated, and based on the evaluation, the selected data may be removed from the volatile memory or its compression level changed accordingly.

公开(公告)号：EP2901323A1

公开(公告)日：2015-08-05

申请号：EP13776657.2

申请日：2013-09-27

Applicant: Oracle International Corporation

Inventor： MARWAH, Vineet ,  LAKSHMANAN, Hariharan ,  MYLAVARAPU, Ajit ,  GAHARWAR, Prashant ,  GANESH, Amit

IPC: G06F17/30

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.

公开(公告)号：EP2901322A1

公开(公告)日：2015-08-05

申请号：EP13776651.5

申请日：2013-09-27

Applicant: Oracle International Corporation

Inventor： GUO, Liang ,  RAJA, Vivekanandhan ,  GANESH, Amit ,  GOULD, Joshua

IPC: G06F17/30

CPC classification number: G06F17/30221 ,  G06F3/0649 ,  G06F17/30073 ,  G06F17/30289 ,  G06F17/30306 ,  G06F17/30312 ,  G06F17/30575

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.

公开(公告)号：EP2788901A1

公开(公告)日：2014-10-15

申请号：EP12809022.2

申请日：2012-12-07

Applicant: Oracle International Corporation

Inventor： ELLISON, Lawrence J. ,  GANESH, Amit ,  MARWAH, Vineet ,  KAMP, Jesse ,  PATTHAK, Anindya C. ,  CHAVAN, Shasank K. ,  GLEESON, Michael J. ,  HOLLOWAY, Allison L. ,  BHATTACHARYYA, Manosiz

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F9/3887 ,  G06F17/30339 ,  G06F17/30595

Abstract: Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.

公开(公告)号：EP1504375B1

公开(公告)日：2009-03-25

申请号：EP03726523.8

申请日：2003-04-29

Applicant: Oracle International Corporation

Inventor： GANESH, Amit ,  VEMURI, Srinivas, S. ,  BAMFORD, Roger, J.

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F9/466 ,  G06F17/30362 ,  Y10S707/99955

Abstract: Techniques are provided for providing a data item to a transaction in a multi-versioning system in which the data item may exist on multiple versions of a data block, and were versioning is performed at the granularity of the data block. According to one aspect of the invention, the technique involves locating, within volatile memory, a first version of a data block that includes a first version of the data item. It is then determined whether the first version of the data item is usable by the transaction without respect to whether the first version of the data block is generally usable by the transaction. If the first version of the data item is usable by the transaction, then the data item is established as a candidate that can be provided to the transaction. Thus, the data item within a block may be considered a candidate to be provided to a transaction even when the version of the data block on which the data item resides would otherwise disqualify the data block from being seen by that transaction. If the first version of the data item is not usable by the transaction, then a version of the data item that is usable by the transaction is obtained from a second version of the data block that is different from the first version.

公开(公告)号：EP1402414B1

公开(公告)日：2007-06-13

申请号：EP02731965.6

申请日：2002-05-29

Applicant: Oracle International Corporation

Inventor： GANESH, Amit ,  BAMFORD, Roger

IPC: G06F17/30

CPC classification number: G06F17/30548 ,  Y10S707/99952 ,  Y10S707/99954

Abstract: Techniques are provided for determining which data item version to supply to a query. According to the techniques, the determination is made by associating a new field, which indicates the time a data item version was current, with each data item version; associating a new field with each query, which indicates the last change that the query must see made by the transaction to which the query belongs; and determining which data item version to use to answer the query based, in part, on a comparison between the values of the two new fields.