公开(公告)号：US20240126729A1

公开(公告)日：2024-04-18

申请号：US17966736

申请日：2022-10-14

Applicant: Oracle International Corporation

Inventor： ZHEN HUA LIU ,  JUAN R. LOAIZA ,  SUNDEEP ABRAHAM ,  SHUBHA BOSE ,  HUI JOE CHANG ,  SHASHANK GUGNANI ,  BEDA CHRISTOPH HAMMERSCHMIDT ,  TIRTHANKAR LAHIRI ,  YING LU ,  DOUGLAS JAMES MCMAHON ,  AUROSISH MISHRA ,  AJIT MYLAVARAPU ,  SUKHADA PENDSE ,  ANANTH RAGHAVAN

IPC: G06F16/21 ,  G06F16/2453 ,  G06F16/84

CPC classification number: G06F16/212 ,  G06F16/24534 ,  G06F16/86

Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.

公开(公告)号：US20190102412A1

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

申请号：US16135748

申请日：2018-09-19

Applicant: Oracle International Corporation

Inventor： ROGER DERMOT MACNICOL ,  XIA HUA ,  ALLISON HOLLOWAY ,  SHASANK KISAN CHAVAN ,  JESSE KAMP ,  MARIA COLGAN ,  TIRTHANKAR LAHIRI

IPC: G06F17/30

Abstract: Techniques herein use in-memory column vectors to process data that is external to a database management system (DBMS) and logically join the external data with data that is native to the DBMS. In an embodiment, a computer maintains a data dictionary for native data that is durably stored in an DBMS and external data that is not durably stored in the DBMS. From a client through a connection to the DBMS, the computer receives a query. The computer loads the external data into an in-memory column vector that resides in random access memory of the DBMS. Based on the query and the data dictionary, the DBMS executes a data join of the in-memory column vector with the native data. To the client through said connection, the computer returns results of the query based on the data join.

公开(公告)号：US20170212939A1

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

申请号：US15008297

申请日：2016-01-27

Applicant: Oracle International Corporation

Inventor： NILOY MUKHERJEE ,  KARTIK KULKARNI ,  TIRTHANKAR LAHIRI ,  VINEET MARWAH ,  JUAN LOAIZA

IPC: G06F17/30 ,  H04L12/24

CPC classification number: G06F16/2477 ,  H04L41/0668 ,  H04L41/12 ,  H04L43/0817

Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve redistributing the in-memory database object portions on changes to the clustered database system. Each node may maintain a mapping indicating which nodes in the clustered database system store which chunks, and timestamps indicating when each mapping entry was created or updated. A query coordinator may use the timestamps to select a database server instance with local in memory access to data required by a portion of a query to process that portion of the query.

公开(公告)号：US20240126743A1

公开(公告)日：2024-04-18

申请号：US17966730

申请日：2022-10-14

Applicant: Oracle International Corporation

Inventor： ZHEN HUA LIU ,  JUAN R. LOAIZA ,  SUNDEEP ABRAHAM ,  SHUBHA BOSE ,  HUI JOE CHANG ,  SHASHANK GUGNANI ,  BEDA CHRISTOPH HAMMERSCHMIDT ,  TIRTHANKAR LAHIRI ,  YING LU ,  DOUGLAS JAMES MCMAHON ,  AUROSISH MISHRA ,  AJIT MYLAVARAPU ,  SUKHADA PENDSE ,  ANANTH RAGHAVAN

IPC: G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/2379 ,  G06F16/24568

Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.

公开(公告)号：US20240126741A1

公开(公告)日：2024-04-18

申请号：US18223822

申请日：2023-07-19

Applicant: Oracle International Corporation

Inventor： VASUDHA KRISHNASWAMY ,  DIETER GAWLICK ,  TIRTHANKAR LAHIRI ,  WEIWEI GONG

IPC: G06F16/23

CPC classification number: G06F16/2343 ,  G06F16/2379

Abstract: A Lock-Free Reservation mechanism is provided. When a transaction issues an update that affects a value in a “reservable column” of a row, the database server does not immediately obtain a lock that covers the row. Instead, the database server adds a reservation to a reservation journal. At the time the transaction commits, a lock is obtained and the requested update is made. In one implementation, before adding the reservation to the reservation journal, the database server determines whether making the update would violate any constraints involving the reservable column. In one implementation, the constraint check not only takes into account the current value of the data item that is being updated and the amount of the update, but also pre-existing reservations in the reservation journal that affect the same data item.

公开(公告)号：US20240126728A1

公开(公告)日：2024-04-18

申请号：US17966724

申请日：2022-10-14

Applicant: Oracle International Corporation

Inventor： ZHEN HUA LIU ,  JUAN R. LOAIZA ,  SUNDEEP ABRAHAM ,  SHUBHA BOSE ,  HUI JOE CHANG ,  SHASHANK GUGNANI ,  BEDA CHRISTOPH HAMMERSCHMIDT ,  TIRTHANKAR LAHIRI ,  YING LU ,  DOUGLAS JAMES MCMAHON ,  AUROSISH MISHRA ,  AJIT MYLAVARAPU ,  SUKHADA PENDSE ,  ANANTH RAGHAVAN

IPC: G06F16/21 ,  G06F16/2453 ,  G06F16/84

CPC classification number: G06F16/212 ,  G06F16/24534 ,  G06F16/86

Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.

公开(公告)号：US20190197026A1

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

申请号：US16287569

申请日：2019-02-27

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: G06F16/21 ,  G06F16/27

CPC classification number: G06F16/211 ,  G06F16/21 ,  G06F16/278

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.

公开(公告)号：US20170116136A1

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

申请号：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: G06F12/14 ,  H04L9/06 ,  G06F17/30

CPC classification number: G06F12/1408 ,  G06F17/30315 ,  G06F17/3033 ,  G06F17/30424 ,  G06F17/30477 ,  G06F17/30867 ,  G06F2212/1052 ,  H04L9/0643

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.