Oracle Patent Grants

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.

Systems and methods for detecting long term seasons

Granted: June 4, 2024
Patent Number: 12001926
Techniques for machine-learning of long-term seasonal patterns are disclosed. In some embodiments, a network service receives a set of time-series data that tracks metric values of at least one computing resource over time. Responsive to receiving the time-series data, the network service detects a subset of metric values that are outliers and associated with a plurality of timestamps. The network service maps the plurality of timestamps to one or more encodings of at least one encoding…

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.

Techniques for unifying ETL filter operators

Granted: June 4, 2024
Patent Number: 12001447
Techniques are provided for unifying filter operators in exchange, transform, load (ETL) plans. Such a technique includes a method that may include receiving, by a computer system, an ETL plan including a split operator and a plurality of filter operators. The may include identifying, by the computer system, that the plurality of filter operators are configured to act on data output by the split operator in the ETL plan. The method may include generating, by the computer system, a…

Predicting future query rewrite patterns for materialized views

Granted: May 28, 2024
Patent Number: 11995081
Techniques for a database management system to predict when in the future a materialized view will be used for query rewrite. This is a followed by an approach that uses the quiet rewrite pattern prediction to determine an optimized schedule for refreshing the materialized view. The approach combines the query rewrite pattern prediction with a quiet period prediction for the materialized view and an estimated refresh duration for the materialized view to determine the optimized refresh…

Protection of online applications and webpages using a blockchain

Granted: May 28, 2024
Patent Number: 11997210
Systems, methods, and other embodiments associated with protecting online content are described. In one embodiment, a method includes generating a hashed code, and generating an encrypted and signed hash. The method may also include transmitting the encrypted and signed hash and the domain to a blockchain, causing: the blockchain to request validation the encrypted and signed hash by a terminal associated with a registrar of the domain; and the terminal associated with the registrar to:…

Enhanced network load allocation and variant selection for multivariate testing

Granted: May 28, 2024
Patent Number: 11997001
The present disclosure relates to systems and methods that enhance multivariate testing of interface variants by intelligently allocating network traffic to increase the speed at which samples sizes reach statistical significance. More particularly, the present disclosure relates to systems and methods that intelligently select interface variants to test against a control interface in a manner that efficiently reduces the uncertainty of sample sizes (e.g., the variance of the sample…

Language agnostic code classification

Granted: May 28, 2024
Patent Number: 11995439
A system may include a computer processor and a repository configured to store a first code fragment including language features represented in a first programming language, and a second code fragment including language features represented in a second programming language. The system may further include a universal code fragment classifier, executing on the computer processor and configured to generate a first universal abstract syntax tree for the first code fragment and a second…

Interfacing with web service attachments in spreadsheets

Granted: May 28, 2024
Patent Number: 11995392
A computer-implemented method interfaces with a remote attachment from a spreadsheet program on a client device. A first area in the spreadsheet associates with a top-level object in a web server, and a second area associates with a descendant object. On a first user interaction with a cell in the second area, a user interface item is shown, allowing uploading and/or downloading the attachment. When the user interacts to upload or download, the program uploads (or queues for upload) a…

Nested query execution tool

Granted: May 28, 2024
Patent Number: 11995072
Techniques for executing operations associated with sub-sets of queries in a set of nested queries are disclosed. A graphical user interface displays individual sub-queries as separate visual representations. Based on detecting a selection, a system executes a selected query in the set of nested queries, without executing parent queries in the set of nested queries. Based on detecting another selection, the system exports a selected query without exporting parent queries of the selected…

Dynamic hierarchical placement of consolidated and pluggable databases in autonomous environments

Granted: May 28, 2024
Patent Number: 11994963
Herein are resource-constrained techniques that plan ahead for resiliently moving pluggable databases between container databases after a failure in a high-availability database cluster. In an embodiment that has a database cluster that hierarchically contains many pluggable databases in many container databases in many virtual machines, a computer identifies many alternative placements that respectively assign each pluggable database instance (PDB) to a respective container database…

System and method for transaction recovery in a multitenant application server environment

Granted: May 28, 2024
Patent Number: 11994959
In accordance with an embodiment, described herein is a system and method for transaction recovery in a multitenant application server environment. At least one resource manager associated with a partition can be designated as a determiner resource for that partition only, in order to support eliminating transaction logs (TLOG) in processing a two-phase commit transaction. A transaction manager can prepare all other resource managers in the mid-tier transactional system before the…

Efficient compilation of graph queries including complex expressions on top of sql based relational engine

Granted: May 21, 2024
Patent Number: 11989178
Techniques support graph pattern matching queries inside a relational database management system (RDBMS) that supports SQL execution. The techniques compile a graph pattern matching query into a SQL query that can then be executed by the relational engine. As a result, techniques enable execution of graph pattern matching queries on top of the relational engine by avoiding any change in the existing SQL engine.

Cloud scale multi-tenancy for RDMA over converged ethernet (RoCE)

Granted: May 21, 2024
Patent Number: 11991246
Techniques and apparatus for data networking are described. In one example, a method includes receiving a first Layer-2 Remote Direct Memory Access (RDMA) packet which includes a virtual local area network (VLAN) tag and a quality-of-service (QoS) data field; converting the first Layer-2 RDMA packet to a first Layer-3 encapsulated packet; and forwarding the first Layer-3 encapsulated packet to a switch fabric. In this method, the converting includes adding at least one header to the…

Avoiding hot spots during ingest where ingest ordering must be preserved

Granted: May 21, 2024
Patent Number: 11989530
Techniques are described herein for achieving physically dispersed item-dispersal patterns in queue tables that are used as circular buffers in a FIFO system. The techniques achieve the physically dispersed item-dispersal patterns while retaining FIFO semantics, efficient data ingest, efficient data access, and low latency for both fixed and variable-size ingest data. Because consecutively inserted rows are written to physically dispersed locations on persistent storage, lock contention…

Techniques for generating multi-modal discourse trees

Granted: May 21, 2024
Patent Number: 11989525
Methods for generating and utilizing a multi-modal discourse tree (MMDT) are provided herein. An extended discourse tree (EDT) may be generated (e.g., from a discourse tree (DT) or a communicative DT (CDT)) from a corpus of text. Data records (e.g., records contained numerical data) may be linked to the extended discourse tree to generate a multi-modal discourse tree. The multi-modal discourse tree may link any suitable text/records from disparate sources. For example, entities…

Composite entity for rule driven acquisition of input data to chatbots

Granted: May 21, 2024
Patent Number: 11989523
The present disclosure relates to chatbot systems, and more particularly, to techniques for obtaining data items for input to a chatbot. In certain embodiments, a chatbot system includes a component that can be invoked by a chatbot in the chatbot system to obtain data items needed by the chatbot. The component can be invoked based on a reference to the component in a dialog flow definition configured for the chatbot. The reference to the component can indicate a composite entity that the…

Secure boot partition for cloud compute nodes

Granted: May 21, 2024
Patent Number: 11989303
The present embodiments relate to a secure boot partition for a cloud computing device of a cloud computing system. The computing device of the cloud computing system can transmit a first request for a pre-boot execution environment executable from a smart network interface card (SmartNIC). The computing device can receive the pre-boot environment executable from the SmartNIC and verify the pre-boot execution environment executable. The computing device can execute the pre-boot execution…

Techniques of heterogeneous hardware execution for SQL analytic queries for high volume data processing

Granted: May 21, 2024
Patent Number: 11989179
The present invention relates to optimized access of a database. Herein are techniques to accelerate execution of any combination of ad hoc query, heterogenous hardware, and fluctuating workload. In an embodiment, a computer receives a data access request for data tuples and compiles the data access request into relational operators. A particular implementation of a particular relational operator is dynamically selected from multiple interchangeable implementations. Each interchangeable…