Oracle International Corporation

Maria Colgan

Tirthankar Lahiri

Jesse Kamp

Shasank Kisan Chavan

Xia Hua

Roger Dermot Macnicol

Amit Ganesh

Juan R Loaiza

Kothanda Umamageswaran

Vivekanandhan Raja

Niloy Mukherjee

Krishnan Meiyyappan

Allison Holloway

Vasudha Krishnaswamy

Kartik Kulkarni

Viral Shah

Adrian Tsz Him Ng

Yiran Qin

Aditi Gupta

Roger D Macnicol

Roger Macnicol

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.

Performing in-memory columnar analytic queries on externally resident data

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.

Columnar caching in tiered storage

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.

Flexible in-memory column store placement

Growing community of inventors

Menlo Park, CA, United States of America

Maria Colgan