公开(公告)号：US11675761B2

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

申请号：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: G06F16/22 ,  G06F16/2458 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/21 ,  G06F16/248

CPC classification number: G06F16/221 ,  G06F16/219 ,  G06F16/2237 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/2456 ,  G06F16/2471 ,  G06F16/256

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.

公开(公告)号：US20230273910A1

公开(公告)日：2023-08-31

申请号：US18143768

申请日：2023-05-05

Applicant: Oracle International Corporation

Inventor： Roger Dermot MacNicol ,  Xia Hua ,  Allison Holloway ,  Shasank Kisan Chavan ,  Jesse Kamp ,  Maria Colgan ,  Tirthankar Lahiri

IPC: G06F16/22 ,  G06F16/2458 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/21 ,  G06F16/248

CPC classification number: G06F16/221 ,  G06F16/2471 ,  G06F16/2455 ,  G06F16/256 ,  G06F16/2237 ,  G06F16/219 ,  G06F16/2456 ,  G06F16/248

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.

公开(公告)号：US10474653B2

公开(公告)日：2019-11-12

申请号：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: G06F16/22 ,  G06F3/06 ,  G06F16/27 ,  G06F16/2455

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.

公开(公告)号：US10678788B2

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

申请号：US15331599

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Roger D. Macnicol ,  Viral Shah ,  Xia Hua ,  Jesse Kamp ,  Shasank K. Chavan ,  Maria Colgan ,  Tirthankar Lahiri ,  Adrian Tsz Him Ng ,  Krishnan Meiyyappan ,  Amit Ganesh ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Yiran Qin

IPC: G06F16/2453 ,  G06F16/22 ,  G06F3/06 ,  G06F12/0811 ,  G06F12/0897

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.

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

公开(公告)号：US20170116269A1

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

申请号：US15331599

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Roger D. Macnicol ,  Viral Shah ,  Xia Hua ,  Jesse Kamp ,  Shasank K. Chavan ,  Maria Colgan ,  Tirthankar Lahiri ,  Adrian Tsz Him Ng ,  Krishnan Meiyyappan ,  Amit Ganesh ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Yiran Qin

IPC: G06F17/30 ,  G06F12/0811 ,  G06F12/0897 ,  G06F3/06

CPC classification number: G06F16/24539 ,  G06F3/061 ,  G06F3/0647 ,  G06F3/065 ,  G06F3/067 ,  G06F12/0811 ,  G06F12/0897 ,  G06F16/22 ,  G06F16/221 ,  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.