System and method for automatic generation of extract, transform, load (ETL) asserts
Granted: October 31, 2023
Patent Number:
11803798
In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for automatic generation of asserts in such environments. A data pipeline or process, such as, for example an extract, transform, load (ETL) 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…
Machine learning model to identify and predict health and safety risks in electronic communications
Granted: October 31, 2023
Patent Number:
11803797
Systems, methods, and other embodiments associated with a machine learning system that monitors and detects health and safety risks in electronic correspondence related to a target field are described. In one embodiment, a method includes monitoring email communications over a network to identify an email associated with a target field. A machine learning classifier is initiated that is configured to classify text from the email with a risk as being related to a safety risk or a…
System and method for query resource caching
Granted: October 31, 2023
Patent Number:
11803547
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.
Method and system for defining an adaptive polymorphic data model
Granted: October 31, 2023
Patent Number:
11803540
Some embodiments process data as defined by a polymorphic data model. A server may provide the polymorphic data model to a client application from a datastore. The functionality or features of the client application may be controlled as a function of the polymorphic data model. The client application may thus provide different functionalities when provided with different polymorphic data models. Updates to the polymorphic data model may be used to update the client application's…
Transitioning between thread-confined memory segment views and shared memory segment views
Granted: October 31, 2023
Patent Number:
11803487
Techniques for transitioning between memory segment views include: instantiating a first memory segment view that confines access to a memory segment to a first thread; receiving a request to transition ownership of the memory segment to a second thread; responsive to receiving the request to transition ownership of the memory segment to the second thread: instantiating a second memory segment view that permits access to the memory segment by the second thread; copying metadata from the…
Branch prediction for user interfaces in workflows
Granted: October 31, 2023
Patent Number:
11803419
Systems, methods, and other embodiments associated with branch prediction in workflows are described. In one embodiment, a method includes inputting a workflow and serially progressing through the workflow in a flow sequence and in response to the flow sequence encountering a first decision element in the workflow that includes a plurality of branch paths: (i) executing a prediction that predicts a resulting path of the first decision element to predict a first user interface from the…
Efficient direct convolution using SIMD instructions
Granted: October 31, 2023
Patent Number:
11803377
A computer comprising one or more processors offering vector instructions may implement a direct convolution on a source data set. The source data set may be one-dimensional or multi-dimensional. For a given vector width, w, of the vector instructions, w consecutive data elements of the output data set are computed in parallel using vector instructions. For multi-dimensional data sets, multiple vectors of the output data set are computed for a single load of a set of vectors from the…
Cross-regional replication of keys
Granted: October 24, 2023
Patent Number:
11799839
Discussed herein is a technique for replication of keys across regions of a cloud infrastructure. A first vault is created in a first region. The first vault stores a plurality of records, each of which is associated with a key and corresponding metadata. A second region, different from the first region, is selected where replication of the plurality of records is desired. A second vault is created in the second region. The plurality of records are relayed from the first vault to the…
Propagating permissions on a resource hierarchy of a process
Granted: October 24, 2023
Patent Number:
11799867
Permissions on a resource hierarchy of a process are propagated. The resource hierarchy of the process is accessed. The resource hierarchy includes multiple nodes arranged in level and each of the nodes is associated with a separate resource from a plurality of resources. A permission for a user is propagate from a first node to one or more lower nodes arranged below the first node in the resource hierarchy. The user is enabled to interact with each resource associated with the first…
Providing intercommunication within a system that uses disparate authentication technologies
Granted: October 24, 2023
Patent Number:
11799841
A custom client authenticator is installed on non-server entity. The custom client authenticator authorizes communication between a client application of a client and requested entities of a server. A native authentication technology for the client is different than a native authentication technology for the server. The custom client authenticator is registered in a descriptor file that is accessible by the server. The custom client authenticator generates an authorization token for the…
Method and system for failure prediction in cloud computing platforms
Granted: October 24, 2023
Patent Number:
11797414
The present disclosure relates to system and techniques for prediction of failures in resources deployed in a data plane of a cloud based infrastructure. The resource are selected from a plurality of cloud based resources arranged in a hierarchical manner and allocated to a client device. A predictor employs a first prediction model to obtain a first prediction of a failure of a resource, and a second prediction model to obtain a second prediction of the failure of the resource. Weights…
Using constraint programming to obtain a machine maintenance schedule for maintenance tasks
Granted: October 24, 2023
Patent Number:
11797951
Information about a set of maintenance tasks and time windows includes a cost value per task per time window. Based on the information, a data model generator generates a data model, including task elements; time elements; cost elements; a total cost element; a constraint that requires each task element be assigned a time window from a respective domain, such that each time element is assigned a task count from a respective domain; a constraint that requires each cost element be assigned…
Prognostic-surveillance technique that dynamically adapts to evolving characteristics of a monitored asset
Granted: October 24, 2023
Patent Number:
11797882
We describe a system that performs prognostic-surveillance operations based on an inferential model that dynamically adapts to evolving operational characteristics of a monitored asset. During a surveillance mode, the system receives a set of time-series signals gathered from sensors in the monitored asset. Next, the system uses an inferential model to generate estimated values for the set of time-series signals, and then performs a pairwise differencing operation between actual values…
Navigating electronic documents using domain discourse trees
Granted: October 24, 2023
Patent Number:
11797773
Navigating text using an extended discourse tree. In an example, a method accesses an extended discourse tree that includes a first discourse tree for a first document and a second discourse tree for a second document. The method determines a first elementary discourse unit that is responsive to a query from a user device and a corresponding first position. The method further determines a set of navigation options including a first rhetorical relationship between the first elementary…
Regular expression generation based on positive and negative pattern matching examples
Granted: October 24, 2023
Patent Number:
11797582
Disclosed herein are techniques related to automated generation of regular expressions. In some embodiments, a regular expression generator may receive input data comprising one or more character sequences. The regular expression generator may convert character sequences into a sets of regular expression codes and/or span data structures. The regular expression generator may identify a longest common subsequence shared by the sets of regular expression codes and/or spans, and may…
System and method for real time data aggregation in a virtual cube in a multidimensional database environment
Granted: October 24, 2023
Patent Number:
11797559
In accordance with an embodiment, described are systems and methods for real time data aggregation in a virtual cube in a multidimensional database. A method can provide, at a computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, a data source associated with the multidimensional cube, and at least one source of real-time data accessible by…
Techniques for linking data to provide improved searching capabilities
Granted: October 24, 2023
Patent Number:
11797549
A machine-learning model may be previously trained with a supervised learning algorithm to identify whether a pair of labels provided as input are similar. A locality sensitive hashing forest (LSH) may be generated for the set of candidate labels. When a user later identifies an input label (e.g., by search query, by interface selection, etc.) the input label may be used to query the LSH forest to identify a subset of the candidate labels. This subset may be used to generate respective…
Accelerated building and probing of hash tables using symmetric vector processing
Granted: October 24, 2023
Patent Number:
11797539
The present invention relates to hash join acceleration. In an embodiment, a computer receives a request to join build data rows with probe data rows. Each data row is associated with a respective join key value. From multiple buckets of a hash table, a bucket is selected that contains entries of multiple respective join key values in respective locations within the bucket. Whether or not the bucket contains an entry of the join key value of a build data row is detected. While building,…
Efficient SQL-based graph random walk
Granted: October 24, 2023
Patent Number:
11797534
Embodiments generate random walks through a directed graph that is represented in a relational database table. Each row of the graph table represents a directed edge in the graph and includes a source vertex and a destination vertex. Each row is further augmented to (a) indicate the number of outbound edges starting from the destination vertex in the row and (b) include an identifier that distinguishes the edge from other outbound edges starting from the same source vertex. An SQL query…
ROWID elimination rewrite
Granted: October 24, 2023
Patent Number:
11797520
Techniques described herein propose a ROWID Elimination Rewrite that uses functional dependencies to substitute and/or eliminate ROWID pseudo-columns referenced in a query in order to reduce memory pressure and speed up processing.
