Method and system for authentication
Granted: October 5, 2021
Patent Number:
11140142
Systems and methods for performing authentication may include encrypting, by a server computing system, a question based on a first password associated with a user and based on successful verification of user identification to generate an encrypted question; transmitting, by the server computing system, the encrypted question to a user computing system; receiving, by the server computing system, an encrypted response from the user computing system, the encrypted response associated with…
Distributed security introspection
Granted: October 5, 2021
Patent Number:
11138311
A graph representation of a designated application may be created. The graph representation may include nodes that each represent a computer programming code statement associated with the designated application as well as edges that each represent a logical linkage between two or more computer programming code statements. A determination may be made as to whether the designated application constitutes an unacceptable security risk by comparing the designated graph representation with a…
Org sync async subscribe emails
Granted: October 5, 2021
Patent Number:
11138228
Disclosed are some implementations of systems, apparatus, methods and computer program products for performing an asynchronous subscription process that enables a secondary organization to subscribe to receive data from a primary organization. A primary organization provides publish data indicating fields to which a secondary organization can subscribe. The secondary organization provides subscription data that indicates published fields to which the secondary organization has…
Enabling multiple third-party data services to update custom data objects
Granted: October 5, 2021
Patent Number:
11138222
A system receives an object selection, and outputs the object. The system receives a first service selection, outputs the first service's object, receives a second service selection, and outputs the second service's object. The system receives selections of the object's first field and the first service object's field, and stores first metadata that maps between the object's first field and the first service object's field. The system receives selections of the object's second field and…
Metric determination for an interaction data stream using multiple databases
Granted: October 5, 2021
Patent Number:
11138204
Techniques are disclosed for generating metrics for a stream of interaction data. In some embodiments, a computing system receives a stream of interaction data that is based on user interactions with one or more computing systems, where the stream of interaction data includes information for multiple interaction characteristics including an interaction category. In response to receiving additional interaction information in the stream of interaction data, the computing system may…
Techniques for determining and presenting dataset join candidates
Granted: October 5, 2021
Patent Number:
11138202
Examples are described herein that relate to determining a level of relatedness between datasets. An approximation can be made of whether an entry in a first dataset appears in a same row as an entry in a second dataset. The approximation can be made by grouping entries in the second dataset together and determining an occurrence that an entry occurs in a same row as any of the entries in a grouping of entries. A test of independence between datasets can be made based at least on the…
Maintaining data across query executions of a long-running query
Granted: October 5, 2021
Patent Number:
11138196
Disclosed herein are system, method, and computer program product embodiments for a query processing system. An embodiment operates by receiving a query associated with a table. An ordered index with entries that include key values that uniquely identifies a corresponding record in the table is determined. A last key value is initialized to store a minimum value for a data type of the key value. The query is executed as a union-all of a plurality of queries. While a count of selected…
Systems and methods for translating n-ary trees to binary query trees for query execution by a relational database management system
Granted: October 5, 2021
Patent Number:
11138195
A method for obtaining query response data by a relational database management system (RDBMS) is provided. The method receives a user input query, by a processor associated with the RDBMS, wherein the user input query comprises a query request for a set of data; formats the user input query into a second query language suitable for communication between the RDBMS and a query response interface associated with a second data storage external to the RDBMS, by the processor, to generate a…
Techniques for processing database tables using indexes
Granted: September 28, 2021
Patent Number:
11132383
Techniques are disclosed relating to processing data stored within database tables in a parallelized manner. In various embodiments, a computer system maintains a database having a database table storing data for a plurality of tenants and an index structure storing indexes for accessing data stored in the database table. In some embodiments, the computer system receives, from a particular tenant, a request to perform a task that includes operating on particular data. In some…
Smart column selection for table operations in data preparation
Granted: September 28, 2021
Patent Number:
11132501
A computer implemented method of providing suggestions of related columns for a table operation in a data management system is provided. In one embodiment, the method includes storing, by a processor, a table having a plurality of rows and a plurality of columns, metadata associated with the plurality of columns, and data stored within the plurality of rows and the plurality of columns; receiving, by a processor, a table operation selected by a system or user; processing, by a processor,…
Maintaining data consistency between transactional and non-transactional data stores
Granted: September 28, 2021
Patent Number:
11132354
Embodiments regard maintaining data consistency between transactional and non-transactional data stores. Embodiments may include receiving a request to archive a set of data stored in a first data store, recording a high water mark in the first data store for the set of data, and archiving the set of data. Archiving the set of data may include copying the set of data into a second data store and inserting a high water mark for the set of data in the first data store and the second data…
Display screen or portion thereof with animated graphical user interface
Granted: September 28, 2021
Patent Number:
D931891
Display screen or portion thereof with graphical user interface
Granted: September 21, 2021
Patent Number:
D931312
Caching techniques for a database change stream
Granted: September 21, 2021
Patent Number:
11126625
Techniques are disclosed relating to caching techniques for processing a database change stream. A caching module of a computer system may receive change records from a change stream that includes a plurality of records indicating changes to a database table. The change stream may include change records for multiple shards and is accessible by providing one or more position indicators for one or more of the multiple shards to request one or more change records and an updated position…
Computerized implementation framework to abstract data object definitions across multiple computing environments
Granted: September 21, 2021
Patent Number:
11126618
Methods, systems, and devices supporting a data model abstraction framework are described. Some platforms (e.g., a multi-tenant cloud computing platform) may manage data across a number of persistent systems (e.g., cloud platforms, data stores, packages, etc.). To efficiently manage data across such systems, a platform may implement a metadata-driven abstraction layer. The abstraction layer may support a number of interface objects and interface fields, which may operate as abstracted…
Streamlined creation and updating of olap analytic databases
Granted: September 21, 2021
Patent Number:
11126616
The technology disclosed relates to creating and frequently updating multiple online analytic processing (OLAP) analytic databases from an online transaction processing (OLTP) transaction updatable system that includes transaction commit, rollback, and field level security capabilities. It also relates to transparently decoupling extraction from rebuilding of frequently updated OLAP analytic databases from the OLTP transaction updatable system.
Techniques and architectures for partition mapping in a multi-node computing environment
Granted: September 21, 2021
Patent Number:
11126608
Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is…
Change data capture using nested buckets
Granted: September 21, 2021
Patent Number:
11126603
Systems and techniques are disclosed relating to management of a database. A method may include maintaining, by a computer system, a multi-tenant database operable to store a plurality of objects. Each object may be capable of including up to a maximum potential number of definable fields. Each field may have an associated index number that has been assigned sequentially. The method may include receiving user-defined data values for a subset of the maximum potential number of fields of a…
Proactive load-balancing using retroactive work refusal
Granted: September 21, 2021
Patent Number:
11126467
A method by a computing system implementing a node within a cluster of nodes to load balance among the cluster of nodes using retroactive refusal. Each of the nodes within the cluster of nodes is capable of processing work items. The method includes accepting a work item to be processed by the node, monitoring a resource utilization of the node, determining whether the resource utilization of the node exceeds a predetermined threshold, and retroactively refusing the work item in response…
Policy-based management of disk storage for consumer storge buckets
Granted: September 21, 2021
Patent Number:
11126351
In a cloud computing environment, a storage space management system provides for uniform collection of usage statistics for storage disks and storage consumers, including usage statistics for a consumers' storage buckets, where a storage bucket represents a logical container of files, objects or other types of stored data for a given consumer. The system enables automated evaluation of space usage policy against the collected statistics. The system enforces the evaluated policy…
