Oracle Patent Grants

Database connection refresh for server instances and live database updates

Granted: June 11, 2024
Patent Number: 12007957
Threads and kernels across multiple server instances may maintain static connections to a database during operation. To apply a patch or other upgrade to the database, a notification may be sent to the database system that causes the database system to redirect new incoming connection requests for the database to a backup database. A second notification may also be sent to each of the server instances where threads maintain active connections to the database. These threads may be allowed…

Session state tracking

Granted: June 11, 2024
Patent Number: 12007941
Techniques are disclosed herein for identifying, recording and restoring the state of a database session and various aspects thereof. A session template data structure is generated that includes session attribute values describing various aspects of the session that is established between a client system and a database management system (DBMS and enables the client system to issue to the DBMS commands for execution. Based on the session attribute values, DBMS may generate a template…

System and method for database replication benchmark testing using a pipeline-based microservices model

Granted: June 11, 2024
Patent Number: 12007866
In accordance with an embodiment, described herein is a system and method for database replication benchmark testing. The system can include one or more microservices configured to collect performance metrics from a testing environment, and a plurality of workload configurations that define different types of pipelines. Each pipeline can be used to execute a workload, and use different techniques to handle errors during the execution of the pipeline. A pipeline control manager can…

Configurable entity-based undo and redo operations

Granted: June 11, 2024
Patent Number: 12007843
Techniques for UNDO and REDO operations in a computer-user interface are disclosed. The techniques enables users to configure entities for UNDO and REDO operations. The techniques also enable users to roll back individual entity to an immediate previous state in one UNDO operation and subsequently to the other previous states. Other entities are not affected by the UNDO operations to the entity.

Geometric aging data reduction for machine learning applications

Granted: June 11, 2024
Patent Number: 12007759
Techniques for geometric aging data reduction for machine learning applications are disclosed. In some embodiments, an artificial-intelligence powered system receives a first time-series dataset that tracks at least one metric value over time. The system then generates a second time-series dataset that includes a reduced version of a first portion of the time-series dataset and a non-reduced version of a second portion of the time-series dataset. The second portion of the time-series…

Datacenter level power management with reactive power capping

Granted: June 11, 2024
Patent Number: 12007734
Disclosed techniques relate to managing power within a power distribution system. Power consumption corresponding to devices (e.g., servers) that receive power from an upstream device (e.g., a bus bar) may be monitored (e.g., by a service) to determine when power consumption corresponding to those devices breaches (or approaches) a budget threshold corresponding to an amount of power allocated to the upstream device. If the budget threshold is breached, or is likely to be breached, the…

System and method for upgrading sparkline cluster with zero downtime

Granted: June 4, 2024
Patent Number: 12001431
The present embodiments relate to updating a dataflow interactive cluster with zero downtime. A request to update a first dataflow cluster can be received, and a second dataflow cluster can be generated as a replacement cluster to execute received queries. Generating the second dataflow cluster can include identifying a second series of executor nodes that are configured to execute queries from the gateway node via a second driver node. A first update to a configuration of a host…

Using semantic frames for intent classification

Granted: June 4, 2024
Patent Number: 12002456
The present disclosure relates to chatbot systems, and more particularly, to techniques for identifying an intent for an utterance based on semantic framing. For an input utterance, a semantic frame is generated. The semantic frame includes semantically relevant grammatical relations and corresponding words identified in the utterance. The semantically relevant grammatical relations define context and relationships of words in the utterance. The semantic frame is used to identify an…

Enhanced user selection for communication workflows using machine-learning techniques

Granted: June 4, 2024
Patent Number: 12001984
The present disclosure relates to systems and methods for intelligently selecting users for inclusion in workflows. In some examples, machine-learning techniques can be executed to intelligently expand the set of user profiles included in a workflow. The intelligent selection of new user profiles may be continuously performed over time intervals, thereby enhancing the computational efficiency and accuracy of expanding the user profiles selected for inclusion in the workflow.

Allocation of cloud-based resources for backup/recovery services

Granted: June 4, 2024
Patent Number: 12001886
Disclosed is an improved system, method, and computer program product to allocate backup devices for a database system, where an appropriate appliance can be automatically allocated to accommodate backups. The allocation selects an appliance that effectively balances space allocation needs of the database with overall performance effects on a multi-tenant backup system that handles multiple databases of varying sizes.

Detection of feedback control instability in computing device thermal control

Granted: June 4, 2024
Patent Number: 12001254
Systems, methods, and other embodiments associated with detecting feedback control instability in computer thermal controls are described herein. In one embodiment, a method includes for a set of dwell time intervals, wherein the dwell time intervals are associated with a range of periods of time from an initial period to a base period, executing a workload that varies from minimum to maximum over the period on a computer during the dwell time interval; recording telemetry data from the…

Duplication elimination in depth based searches for distributed systems

Granted: June 4, 2024
Patent Number: 12001425
Systems and methods for improving evaluation of graph queries through depth first traversals are described herein. In an embodiment, a multi-node system evaluates against graph data a graph query that specifies a particular pattern to match by determining, at a first node of the multi-node system, in a particular instance of evaluating the graph query, that one or more first vertices on the first node match a first portion of the graph query and that a second vertex that is to be…

Hierarchal data structure modification

Granted: June 4, 2024
Patent Number: 12001415
Techniques for modifying hierarchal-structured data of one hierarchal data structure based on a modification to another hierarchal data structure are disclosed. A system determines that a modification has been made, or is requested to be made, to a particular hierarchal data structure. The system analyzes a set of rules to determine whether the modification of the hierarchal data structure triggers another modification to an additional hierarchal data structure. The additional hierarchal…

ROWID decoding: an alternative to dictionary decoding

Granted: June 4, 2024
Patent Number: 12001414
Techniques described herein propose a new RIDDecode operator in a QEP that uses ROWID lookup and fetch, instead of dictionary decoding, to retrieve decoded values, in order to reduce memory pressure and speed up processing.

Techniques for efficient migration of key-value data

Granted: June 4, 2024
Patent Number: 12001408
The present disclosure relates to a system and techniques for enabling migration of data between data storage devices without disruption to an application that relies upon the data. In some embodiments, this may involve the insertion of a redirect command into a mutation log. Upon receiving a transaction that relates to a data value, a transactor host may access the mutation log. Upon detecting the redirect command, the transactor host may generate a new mutation log in a second memory…

Method and system to implement directory reads for a database file system

Granted: June 4, 2024
Patent Number: 12001406
Disclosed is an improved approach to access the contents of database file system. The contents of the database file system can be acquired and stored in a directory buffer. A parallel tree structure is used to retrieve directory contents quickly and in a consistent fashion.

Techniques for replication checkpointing during disaster recovery

Granted: June 4, 2024
Patent Number: 12001404
Techniques are described for checkpointing multiple key ranges in parallel and concurrently during file storage replications between file systems in different cloud infrastructure regions. In certain embodiments, multiple range threads processing multiple key ranges, one thread per key range, create checkpoints for their respective key ranges in parallel and concurrently after processing a per-determined number of B-tree keys. In certain embodiments, each thread requests a lock from a…

System and method for providing correlated content organization in an enterprise content management system based on a training set

Granted: June 4, 2024
Patent Number: 12001389
Described herein are systems and methods for providing a correlated content organization in a content management system based upon a training set. In accordance with an embodiment, the systems and methods described herein can build a training set based upon observations of received inputs to determine patterns that are used often in content merges. Once a pattern is established, the systems and methods can provide indications of proposed merges based upon the training set and rules…

Dynamically configurable motherboard

Granted: June 4, 2024
Patent Number: 12001350
According to certain implementations, a motherboard is provided that enables operation as either multiple independent single-processor systems or a single multiple-processor system. In response to a request to configure the motherboard as multiple independent single-processor systems, a control block is implemented for each processor attached to the motherboard, where the control blocks configure the processors to boot and operate independently of each other, and the processors utilize…

System for tuning a java virtual machine

Granted: June 4, 2024
Patent Number: 12001269
Techniques are described for tuning a Java Virtual Machine (JVM) in an automated manner. The automated tuning may be performed to improve a JVM's performance including to prevent it from failing. An auto-tuning system is described that can auto-detect one or more anomalous conditions for a JVM, and in response, take one or more corrective actions to auto-tune the JVM to avoid or reduce/mitigate any adverse impacts of the detected anomalous conditions. A corrective action taken for a JVM…