Oracle Patent Grants

Handling faulted database transaction records

Granted: January 14, 2025
Patent Number: 12197382
Database transaction records that are received for committing data to a database may be associated with one or more validation tasks. When one of the validation tasks fails, the fault is detected and processing of the transaction record is halted. Instead of terminating the transaction record and requiring the submitting system to reinitiate the process, the system may use a mapping table to determine whether an automatic resubmission is possible. A new transaction record may be…

Logical java card runtime environment

Granted: January 14, 2025
Patent Number: 12197974
Techniques are disclosed for generating a message stream configured to indicate a source of the various messages within the message stream. In particular, the indicators identify which interface the messages were received at a terminal (e.g., of a mobile handset). The terminal receives messages on various interfaces, and separates the messages received via different interfaces with interface switch indicators within the message stream. In one embodiment, the smart card receives a message…

Branch prediction for user interfaces in workflows

Granted: January 14, 2025
Patent Number: 12197946
Systems, methods, and other embodiments associated with branch prediction in workflows are described. In one embodiment, a branch predictor is configured to make branch predictions at decision elements of a workflow that executes serially, by at least: monitoring the workflow to identify when a decision element is encountered during execution. In response to encountering a first decision element in the workflow that includes a plurality of branch paths: (i) executing a prediction that…

Automatic layout of elements in a process flow on a 2-D canvas based on representations of flow logic

Granted: January 14, 2025
Patent Number: 12197843
Layouts for elements of a flowchart or flow diagram may use recursive algorithms that trace along each parent-child pathway to ensure that child elements always occur after parent elements in a horizontal spacing. Vertical spacing requirements may then be calculated for each element, along with a vertical space above a center line and a vertical space below a center line for each element. These vertical spacing requirements may then be used by a recursive algorithm to assign vertical…

Data recovery techniques using cloud consistency groups

Granted: January 14, 2025
Patent Number: 12197790
Techniques discussed herein relate to improved data recovery techniques within cloud computing environments. The disclosed techniques utilize consistency groups that are identified for volumes corresponding to a compute instance. A plurality of resource identifiers uniquely identifying a respective cloud computing resource of the cloud computing environment can be maintained. A cloud computing instance corresponding to a resource identifier may be identified and volume metadata…

Automated interleaved clustering recommendation for database zone maps

Granted: January 14, 2025
Patent Number: 12197469
A computer measures for each column in many rows, a respective frequency of statements that filter the column in a workload of database statements, a respective count of distinct values used for filtration on the column in each statement individually, a respective frequency of each of the counts of distinct values used for filtration on the column across all of the database statements, and a respective value range of the column for each of many storage zones. A respective efficiency is…

Using statement caching when implementing server based or proxy based pooling solutions

Granted: January 14, 2025
Patent Number: 12197443
Disclosed is an improved approach to implement cursor sharing in database systems, where a server-side mapping of cursor identifiers to SQL is maintained to allow for continued use of client-side statement caches even after connections and database sessions are returned to shared pools and then subsequently re-assigned. This avoids the need to clear the statement cache across session releases to the database session pools. Instead, applications can retain their statement cache while…

Outer semi join for disjunctive subquery unnesting

Granted: January 14, 2025
Patent Number: 12197439
A new type of table join operation, outer semi join (OSJ), is provided, which can be used by an optimizer layer and an execution layer of a database management system (DBMS). OSJ combines the semantics of both left outer-join and semi-join. The concept of an anti-join marker (AJM) is also introduced, which specifies whether a matching row was not found between joined tables for each result row in an OSJ operation. The OSJ operation supports unnesting of a class of disjunctive ANY, ALL,…

Subqueries in distributed asynchronous graph queries

Granted: January 14, 2025
Patent Number: 12197436
A graph processing engine is provided for executing a graph query comprising a parent query and a subquery nested within the parent query. The subquery uses a reference to one or more correlated variables from the parent query. Executing the graph query comprises initiating execution of the parent query, pausing the execution of the parent query responsive to the parent query matching the one or more correlated variables in an intermediate result set, generating a subquery identifier for…

Error prediction using database validation rules and machine learning

Granted: January 14, 2025
Patent Number: 12197416
Embodiments predict errors using database validation rules. Validation rules can be defined that include business logic for validating transactions performed on a database with a data model. Transactions can be performed using the database, where the database is in a post-transaction state after performance of the transactions. The database can be validated in the post-transaction state by performing the defined business logic for a subset of validation rules, where at least one…

Thread-local garbage collection

Granted: January 14, 2025
Patent Number: 12197324
Techniques are described herein for performing thread-local garbage collection. The techniques include automatic profiling and separation of private and shared objects, allowing for efficient reclamation of memory local to threads. In some embodiments, threads are assigned speculatively-private heaps within memory. Unless there is a prior indication that an allocation site yields shared objects, then a garbage collection system may assume and operate as if such allocations are private…

Custom stream partitioning services

Granted: January 7, 2025
Patent Number: 12189658
Techniques are disclosed for partitioning received data for use in a data stream. Data is received during a period of time at a device, such as a data partitioner. The device a) determines that a first subset of the data is for a first system component, b) a second subset of the data is for a second system component, and c) a third subset of the data is for the first system component. Also, determines that a first stream partition is mapped to the first system component and a second…

Methods, systems, and computer readable media for delegated authorization at security edge protection proxy (SEPP)

Granted: January 7, 2025
Patent Number: 12192764
A method for delegated authorization at a security edge protection proxy (SEPP) includes intercepting, from a consumer network function (NF) that does not support access token based authorization, a service based interface (SBI) service request for accessing a service provided by a producer NF that requires access token based authorization. The method further includes operating as an access token authorization client to obtain a first access token on behalf of the consumer NF. The method…

Methods, systems, and computer readable media for sharing key identification and public certificate data for access token verification

Granted: January 7, 2025
Patent Number: 12192351
A method for sharing key identification (key ID) and public certificate data for access token verification comprises, at a network function (NF) repository function (NRF) including at least one processor, receiving, from a producer NF, an NF registration message including key ID version information. In response to detecting the key ID version information, sending, to the producer NF, an NF registration response message including a current key ID version value, at least one digital…

Chatbot for defining a machine learning (ML) solution

Granted: January 7, 2025
Patent Number: 12190254
The present disclosure relates to systems and methods for an intelligent assistant (e.g., a chatbot) that can be used to enable a user to generate a machine learning system. Techniques can be used to automatically generate a machine learning system to assist a user. In some cases, the user may not be a software developer and may have little or no experience in either machine learning techniques or software programming. In some embodiments, a user can interact with an intelligent…

Cooperative garbage collection barrier elision

Granted: January 7, 2025
Patent Number: 12190112
Techniques are disclosed for eliding load and store barriers while maintaining garbage collection invariants. Embodiments described herein include techniques for identifying an instruction, such as a safepoint poll, that checks whether to pause a thread between execution of a dominant and dominated access to the same data field. If a poll instruction is identified between the two data accesses, then a pointer for the data field may be recorded in an entry associated with the poll…

Just-in-time data object permission restriction and action implementation

Granted: January 7, 2025
Patent Number: 12189796
An instruction is received to define or modify a permission constraint corresponding to one or more file. A period of time is determined, where the period is one during which the defined or modified permission constraint is to apply to the one or more files. It is determined that the one or more files are to be deleted following completion of the period of time. A permission-instruction data set representing the permission constraint and a flag indicating that the one or more files are…

Runtime-tailored security policies for applications

Granted: January 7, 2025
Patent Number: 12189759
Techniques are described herein for function-level limiting of privileges for a target application. Privileges dependencies for different functions of an application are determined based on static evaluation of the code base. A call graph with nodes representing the application functions is established, and the nodes are associated with the determined privilege dependencies. The graph is modified using iterative backward dataflow analysis to associate the nodes in the graph with…

Signal synthesizer data pump system

Granted: January 7, 2025
Patent Number: 12189715
The disclosed system produces synthetic signals for testing machine-learning systems. During operation, the system generates a set of N composite sinusoidal signals, wherein each of the N composite sinusoidal signals is a combination of multiple constituent sinusoidal signals with different periodicities. Next, the system adds time-varying random noise values to each of the N composite sinusoidal signals, wherein a standard deviation of the time-varying random noise values varies over…

Conversion and migration of key-value store to relational model

Granted: January 7, 2025
Patent Number: 12189665
Systems, methods, and other embodiments associated with migrating key-value data to a relational database. A method comprises retrieving a namespace from a key-value store and querying the key-value store for a kind category associated with the namespace. The key-value store is accessed and data entities are retrieved that are associated with the kind category that is defined with the namespace identifier. Property names and associated property values are identified in the data entities.…