Oracle Patent Grants

Extensible attributes for data warehouses

Granted: April 23, 2024
Patent Number: 11966409
Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.

Systems and methods for memory tracing in asset managing systems

Granted: April 23, 2024
Patent Number: 11968212
The present embodiments relate to implementing change data on no-master NoSQL data stores. An optimized node can be identified from a plurality of NoSQL data storage nodes and a specialized node can be connected (e.g., collocated) to the optimized node. The specialized node can maintain change data capture (CDC) data provided by client nodes in a hash map that can be used as a point of truth for coordinating CDC data across the plurality of NoSQL data storage nodes. The plurality of…

System and method to use queue pair 1 for receiving multicast based announcements in multiple partitions in a high performance computing environment

Granted: April 23, 2024
Patent Number: 11968132
Systems and methods for using queue pair 1 (QP1) for receiving multicast based announcements in multiple partitions in a high performance computing. In accordance with an embodiment, by extending the scope of QP1 to also include receiving and sending multicast packets in any partition defined for the port, it is possible to implement generic MC based announcement and discovery without requiring the complexity of unique QPs for individual partitions, nor any update of QP configuration as…

Synchronizing communication channel state information for high flow availability

Granted: April 23, 2024
Patent Number: 11968080
For a communication channel having a first endpoint in a customer on-premise network and a second endpoint on a primary host machine in a cloud service provider infrastructure, the primary host machine determines a change in a state information of the communication channel and identifies a backup host machine for the communication channel. The primary host machine causes the change in the state information to be replicated to the backup host machine, wherein the replicated state…

Voice communication analysis system

Granted: April 23, 2024
Patent Number: 11967307
Techniques are disclosed for applying a trained machine learning model to incoming voice communications to determine whether the voice communications are genuine or not genuine. The trained machine learning model may identify vocal attributes within the target call and use the identified attributes, and the training, determine whether the target call is genuine or not genuine. An applied trained machine learning model may include multiple different types of trained machine learning…

System and method for determination of recommendations and alerts in an analytics environment

Granted: April 23, 2024
Patent Number: 11966870
In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for determination of recommendations and alerts in such environments. A data pipeline or process can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse…

Rapid sorting-based supply assignment tool for order fulfillment with short supply

Granted: April 23, 2024
Patent Number: 11966868
Systems, methods, and other embodiments for sorting-based assignment to optimize order fulfillment with short supply. One embodiment includes identifying a set of one or more distributions within a series of days. Sorting all demands of a first priority level occurring in the series of days by ascending order of size of the demand. For each demand of the first priority level in sorted order, (a) selecting an initial distribution during which the demand is scheduled to be fulfilled from…

Implementing a type restriction that restricts to a singleton value or zero values

Granted: April 23, 2024
Patent Number: 11966798
A type restriction contextually modifies an existing type descriptor. The type restriction is imposed on a data structure to restrict the values that are assumable by the data structure. The type restriction does not cancel or otherwise override the effect of the existing type descriptor on the data structure. Rather the type restriction may declare that a value of the data structure's type is forbidden for the data structure. Additionally or alternatively, the type restriction may…

Cluster bootstrapping for distributed computing systems

Granted: April 23, 2024
Patent Number: 11966754
A distributed computing system is described that leverages a nearline storage layer to minimize the downtime required for bootstrapping a new computing cluster in the distributed computing system. The system executes a computing cluster comprising a set of computing nodes and determines a set of one or more data segments to be written to a nearline storage system. The system writes the data segments to the nearline storage system. In certain examples, the system receives a request to…

System and method for providing a hybrid set-based extract, load, and transformation of data

Granted: April 23, 2024
Patent Number: 11966410
In accordance with an embodiment, described herein is a system and method for loading and transforming data to a cloud database, using a hybrid set-based extract, load, transform approach. During the loading and transforming of large amounts of data, from one or more data sources, a data synchronization application sends small batches of data, in parallel streams, to the database, which operates as a transformation engine to load the data. Each stream can be associated with a separate…

Processing top-K queries on data in relational database systems

Granted: April 23, 2024
Patent Number: 11966399
Techniques for processing top-K queries are provided. In one technique, a database statement is received that requests top-K results related to a database object and that indicates two columns thereof: a first column by which to partition a result set and a second column by which to order the result set. A buffer is generated. For each of multiple rows in the database object: a first key value that associated with a first value in the first column of said each row is identified; a second…

Generating external identifiers for data entities using a data catalog system

Granted: April 23, 2024
Patent Number: 11966384
A data catalog system is disclosed that provides capabilities for uniquely identifying and retrieving data entities stored in diverse data sources managed by an organization. The data catalog system includes capabilities for generating a unique external identifier for a data entity (e.g., a data asset or a data object) by identifying a set of immutable configuration parameters associated with the data asset and identifying a set of data object attributes that uniquely identify data…

Efficient usage of one-sided RDMA for linear probing

Granted: April 23, 2024
Patent Number: 11966356
Systems and methods for reducing latency of probing operations of remotely located linear hash tables are described herein. In an embodiment, a system receives a request to perform a probing operation on a remotely located linear hash table based on a key value. Prior to performing the probing operation, the system dynamically predicts a number of slots for a single read of the linear hash table to minimize total cost for an average probing operation. The system determines a hash value…

Fast and accurate anomaly detection explanations with forward-backward feature importance

Granted: April 23, 2024
Patent Number: 11966275
The present invention relates to machine learning (ML) explainability (MLX). Herein are local explanation techniques for black box ML models based on coalitions of features in a dataset. In an embodiment, a computer receives a request to generate a local explanation of which coalitions of features caused an anomaly detector to detect an anomaly. During unsupervised generation of a new coalition, a first feature is randomly selected from features in a dataset. Which additional features in…

Techniques for concurrent data value commits

Granted: April 16, 2024
Patent Number: 11960476
The present disclosure relates to a system and techniques for preventing corruption of snapshot data by limiting the visibility of committed data. To do this, the system may maintain an index that indicates the highest transaction identifier value such that no future commits will have a transaction identifier less than or equal to the indexed transaction identifier value. In embodiments, if a read is performed, only transactions having a transaction identifier less than or equal to the…

Techniques for automatically configuring minimal cloud service access rights for container applications

Granted: April 16, 2024
Patent Number: 11962599
A computer system may receive one or more requests for access to one or more cloud services and may store the one or more requests in a request log. The computer system may receive one or more access rules applicable to cloud service access rights. The computer system may aggregate the one or more requests of the request log to determine access requirements for a container, the container being configured to store one or more applications. The computer system may generate and store…

Automated enhancement of opportunity insights

Granted: April 16, 2024
Patent Number: 11960977
Techniques for enhancing actionable opportunities through machine learning are disclosed. In some embodiments, a system includes an event listener for detecting an opportunity to perform an action using one or more computing resources. When a new opportunity is detected, the system generates a set of search criteria, which is used to search a set of external web resources for current events. The system may then generate, using a machine learning model as a function of one or more…

Automated runbook operation recommendations

Granted: April 16, 2024
Patent Number: 11960929
Techniques for recommending runbook operations during a runbook generation process are disclosed. A system recommends operations for including in the runbook based on attributes of a detected event. The system presents event attributes associated with the detected event to a user in a runbook generation interface. When the user selects an event attribute, the system presents a set of candidate runbook operations associated with the event attribute. Based on user selections of runbook…

Discourse parsing using semantic and syntactic relations

Granted: April 16, 2024
Patent Number: 11960844
Systems, devices, and methods of the present invention involve discourse trees. In some aspects, a system creates a discourse tree by identifying elementary discourse units in text. The discourse tree includes nodes, each nonterminal node representing a rhetorical relationship between two elementary discourse units and each terminal node associated with an elementary discourse unit. The system identifies, in a reference sentence of the discourse tree, a rhetorical relation of type…

Distributed and blockchain-based ledgers for data cloud services

Granted: April 16, 2024
Patent Number: 11960477
Techniques are described herein for managing transactions between data consumers and data providers using a blockchain. In some embodiments, a blockchain network receive smart contracts that govern access rights to data sets provided by blockchain members and smart contracts that execute blockchain transactions based on the usage of data sets. When a data set is provided to a blockchain member through the blockchain network, usage of the data set may be tracked. Responsive to detecting…