公开(公告)号：US10042781B2

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

申请号：US15268524

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Roger D. MacNicol ,  Tirthankar Lahiri ,  Kothanda Umamageswaran ,  Adrian Tsz Him Ng ,  Laura Liaoruo Wang ,  Krishnan Meiyyappan

IPC: G06F17/30 ,  G06F12/14 ,  H04L9/06

Abstract: Techniques are described herein for generating and using in-memory data structures to represent columns in data block sets. In an embodiment, a database management system (DBMS) receives a query for a target data set managed by the DBMS. The query may specify a predicate for a column of the target data set. The predicate may include a filtering value to be compared with row values of the column of the target data set. Prior to accessing data block sets storing the target data set from persistent storage, the DBMS identifies an in-memory summary that corresponds to a data block set, in an embodiment. The in-memory summary may include in-memory data structures, each representing a column stored in the data block set. The DBMS determines that a particular in-memory data structure exists in the in-memory summary that represents a portion of values of the column indicated in the predicate of the query. Based on the particular in-memory data structure, the DBMS determines whether or not the data block set can possibly contain the filtering value in the column of the target data set. Based on this determination, the DBMS skips or retrieves the data block set from the persistent storage as part of the query evaluation.

公开(公告)号：US10002148B2

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

申请号：US14806411

申请日：2015-07-22

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Mohamed Zait ,  Juan Loaiza ,  Vineet Marwah ,  Tirthankar Lahiri ,  Jiaqi Yan ,  Kartik Kulkarni

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F16/2282 ,  G06F3/0604 ,  G06F3/0644 ,  G06F3/0679 ,  G06F16/2456 ,  G06F16/278

Abstract: Techniques are described herein for distributing data from one or more partitioned tables across the volatile memories of a cluster. In memory copies of data from partitioned tables are grouped based on the data falling within the same partition criteria. These groups are used for assigning data from corresponding partitions to the same node when distributing data from partitioned tables across the volatile memories of a multi-node cluster. When a query requires a join between rows of partitioned tables, the work for the join query is divided into work granules that correspond to partition-wise join operations. Those partition-wise join operations are assigned to nodes by a query coordinator based on the partition-to-node mapping located in the node of the query coordinator.

公开(公告)号：US09639562B2

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

申请号：US13842843

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： John Raitto ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang

IPC: G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30442 ,  G06F17/30463 ,  G06F17/30575

Abstract: A method, apparatus, and system for automatically determining an optimal database subsection is provided. A database subsection is selected to optimize certain benefits when the database subsection is translated, transferred, and cached on an alternative database system, which may utilize a different technology or database engine that provides certain performance benefits compared to the original database system. Algorithms such as multi-path greedy selection and/or dynamic programming may provide optimal or near-optimal results. A host for the alternative database server may be shared with or otherwise located in close physical proximity to improve latency for a database application or client layer. Once the database subsection analysis is completed, a report may be generated and presented to the user, and an implementation script may also be created to automatically configure a client host to function as a cache or replacement system according various cache size configurations described in the report.

公开(公告)号：US20170116252A1

公开(公告)日：2017-04-27

申请号：US15253780

申请日：2016-08-31

Applicant: Oracle International Corporation

Inventor： Vasudha Krishnaswamy ,  Yunrui Li ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Mahesh B. Girkar ,  Sukhada Pendse ,  Kartik Kulkarni ,  Jing Zheng ,  Shruti Gautam ,  Henry Chau

IPC: G06F17/30

CPC classification number: G06F16/2379 ,  G06F16/275

Abstract: Techniques related to query execution against an in-memory standby database are disclosed. A first database includes PF data stored on persistent storage in a persistent format. The first database is accessible to a first database server that converts the PF data to a mirror format to produce MF data that is stored within volatile memory. The first database server receives, from a second database server, one or more change records indicating one or more transactions performed against a second database. The one or more change records are applied to the PF data, and a reference timestamp is advanced from a first to a second timestamp. The first database server invalidates any MF data that is changed by a subset of the one or more transactions that committed between the first and second timestamps.

公开(公告)号：US09292564B2

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

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

公开(公告)号：US20150088813A1

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

申请号：US14097575

申请日：2013-12-05

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Martin A. Reames ,  Kirk Edson ,  Neelam Goyal ,  Kao Makino ,  Anindya Patthak ,  Dina Thomas ,  Subhradyuti Sarkar ,  Chi-Kim Hoang ,  Qingchun Jiang

IPC: G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30289 ,  G06F17/30584

Abstract: Columns of a table are stored in either row-major format or column-major format in an in-memory DBMS. For a given table, one set of columns is stored in column-major format; another set of columns for a table are stored in row-major format. This way of storing columns of a table is referred to herein as dual-major format. In addition, a row in a dual-major table is updated “in-place”, that is, updates are made directly to column-major columns without creating an interim row-major form of the column-major columns of the row. Users may submit database definition language (“DDL”) commands that declare the row-major columns and column-major columns of a table.

Abstract translation: 表的列以存储器内DBA中的行主格式或列主格式存储。 对于给定的表，一列列以列主格式存储; 表的另一组列以行主格式存储。 这种存储表的​​列的方式在本文中被称为双主格式。 此外，双主表中的一行更新为“就地”，即直接对列主列进行更新，而不创建该行的主列列的主要行。 用户可以提交数据库定义语言（“DDL”）命令，声明表的行主列和列主列。