Performing in-memory columnar analytic queries on externally resident data

RD MacNicol, X Hua, A Holloway, SK Chavan… - US Patent …, 2023 - Google Patents
2018-09-21 Assigned to ORACLE INTERNATIONAL CORPORATION reassignment
ORACLE INTERNATIONAL CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST …

Integrating Kafka data-in-motion with data-at-rest tables

R Hanckel, MD Yalavarthy, R Yan, C Cao - US Patent 11,170,002, 2021 - Google Patents
Techniques are described herein for analyzing data streams in conjunction with relational
database data in a DBMS. A database dictionary defines one or more columns for an …

Extracting structure and semantics from tabular data

X Chen, L Chiticariu, A Evfimievski… - US Patent …, 2023 - Google Patents
Chen et al.,“Integrating spreadsheet data via accurate and low-effort extraction,” in
Proceedings of the 20th ACM SIGKDD international conference on Knowledge discovery …

Technique of comprehensively support autonomous JSON document object (AJD) cloud service

ZH Liu, V Arora, Y Lu, S Krishnamurthy… - US Patent …, 2021 - Google Patents
The present invention relates to autonomous tuning of a data grid of documents in a
database. Herein are techniques for storage cells to autonomously maintain local indices …

Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP

ZH Liu, S Krishnamurthy, BC Hammerschmidt… - US Patent …, 2022 - Google Patents
Herein is a self-tuning database management system (DBMS) storing JavaScript object
notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an …

Storage-side scanning on non-natively formatted data

DM Potapov, K Meiyyappan, A Tsukerman… - US Patent …, 2021 - Google Patents
(57) ABSTRACT A storage system communicatively coupled to a database management
system (DBMS performs storage-side scan ning of data sources that are not stored in native …

Method for using a sematic model to transform SQL against a relational table to enable performance improvements

J Hartsing, R Venkatasubramanian, A Murphy… - US Patent …, 2022 - Google Patents
Herein, a computer stores metadata that defines an analytic view that is based on organizing
operation (s) that respectively specify organizing column (s) of organizing table (s), including …

Efficient evaluation of query expressions including grouping clauses

SK Chavan, D Lui, AL Holloway, SAK Lewis - US Patent 10,853,371, 2020 - Google Patents
Techniques related to efficient evaluation of query expressions including grouping clauses
are disclosed. Computing device (s) perform a method for aggregating a measure column …

Intelligent search engine

MK Vaananen - US Patent App. 17/431,738, 2022 - Google Patents
(57) ABSTRACT A search engine (200, 500, 800), method and a system for performing a
search is provided. The search engine (200, 500, 800) is connected to at least one mobile …

Memory efficient multi-versioned concurrency for a hypercube memory cache using formula snapshots

S Vemuri, D Lee - US Patent 12,204,519, 2025 - freepatentsonline.com
A system, method, and device for managing updates to a hypercube is provided. The
method includes (i) obtaining a hypercube comprising a plurality of locations, wherein a …