Data quality using artificial intelligence
Granted: January 21, 2025
Patent Number:
12204508
Embodiments improve data quality using artificial intelligence. Incoming data that includes a plurality of rows of data and a trained neural network that is configured to predict a data category for the incoming data can be received, where the neural network has been trained with training data including training features, and the training data includes labeled data categories. The incoming data can be processed, where the processing extracts features about the plurality of rows of data…
Upgrade of heterogeneous multi-instance database clusters
Granted: January 21, 2025
Patent Number:
12204500
A method, system, and computer program product for management of large multi-database installations. The method form commences by analyzing a multiple database installation to determine a set of candidate upgrade operations to apply to individual instances of heterogeneous databases in the multiple database installation, and then scheduling an order in which order to apply individual operations from among the set of candidate upgrade operations. In exemplary operation, the candidate…
Implementing graph search with in-structure metadata of a graph-organized file system
Granted: January 21, 2025
Patent Number:
12204494
Techniques are described herein for a graph-organized file system (GOFS) that represents a data graph using a plurality of gnode data structures and a plurality of edge entry data structures. Gnodes and edge entries both store one or more “in-structure” metadata values for graph component properties. A GOFS partition includes dedicated storage for “out-of-structure” graph component metadata values that are accessed using graph component identifiers. Search operations may use the…
Incremental stack walking
Granted: January 21, 2025
Patent Number:
12204436
Techniques for incremental stack walking are disclosed, including: performing a stack walk of a runtime stack, at least by traversing the runtime stack from a current frame to a root frame, to obtain a set of stack walking results; storing a cache of the set of stack walking results; and installing, on the runtime stack, a marker frame that marks a boundary of stack frames represented by the set of stack walking results.
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…
Configuring autosave triggers based on value metrics
Granted: January 14, 2025
Patent Number:
12198024
Techniques for configuring autosave triggers in a computing environment based on environment and data conditions are disclosed. A system trains a machine learning model based on data attributes and environmental attributes to generate autosave value triggers for a computing environment. The autosave value triggers are triggered by different conditions. For example, one autosave trigger may be triggered when an error condition is detected. Another may be triggered when a certain number of…
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…
Selecting a node group of a work group for executing a target transaction of another work group to optimize parallel execution of steps of the target transaction
Granted: January 14, 2025
Patent Number:
12197940
A computing network includes nodes of different work groups. Nodes of a work group are dedicated to transactions of the work group. If a node of a first work group is predicted to have an idleness window, a second work group may borrow the node to execute a transaction of the second work group. At least a subset of steps of the transaction may be categorized into a step group. Trees of a transaction may be categorized into one or more tree groups. A node is selected for executing a…
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…
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…
System and method for query resource caching
Granted: January 14, 2025
Patent Number:
12197444
Operations include determining whether to cache resources accessed by a query based on the execution time of the query. The system identifies a set of executions of a same query. The system determines a cumulative execution time for the set of executions of the same query. If the cumulative execution time exceeds a threshold value, then the system caches a resource used for execution of the query.
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…
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…
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…
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…
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…
