Data Warehouse, Data Mart, Online Analytical Processing (olap), Decision Support Systems Patents (Class 707/600)
  • Patent number: 11907220
    Abstract: A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.
    Type: Grant
    Filed: December 18, 2020
    Date of Patent: February 20, 2024
    Assignee: International Business Machines Corporation
    Inventors: Al Chakra, Ruiping Li, Terence P. Purcell, Lily Zhou
  • Patent number: 11907138
    Abstract: Various embodiments include methods and devices for implementing a criterion aware cache replacement policy by a computing device. Embodiments may include updating a staling counter, writing a value of a local counter to a system cache in association with a location in the system cache for with data, in which the value of the local counter includes a value of the staling counter when (i.e., at the time) the associated data is written to the system cache, and using the value of the local counter of the associated data to determine whether the associated data is stale.
    Type: Grant
    Filed: December 31, 2021
    Date of Patent: February 20, 2024
    Assignee: QUALCOMM Incorporated
    Inventors: Hiral Nandu, Subbarao Palacharla, George Patsilaras, Alain Artieri, Simon Peter William Booth, Vipul Gandhi, Girish Bhat, Yen-Kuan Wu, Younghoon Kim
  • Patent number: 11899690
    Abstract: This invention makes it possible to analyze data with a focus on an event as a source of information on the data and state transition of the event.
    Type: Grant
    Filed: September 2, 2019
    Date of Patent: February 13, 2024
    Assignee: NIPPON TELEGRAPH AND TELEPHONE CORPORATION
    Inventor: Satoru Yagi
  • Patent number: 11886278
    Abstract: A computing platform may be installed with software technology for creating and executing user-defined anomaly detection rules that configures the computing platform to: (1) receive, from a client device, data defining a given anomaly detection rule that has been created by a user, wherein the given anomaly detection rule comprises at least one anomaly condition that is to be applied to at least one streaming event queue, (2) store a data representation of the given anomaly detection rule in a data store, (3) convert the data representation of the given anomaly detection rule to a streaming query statement, (4) iteratively apply the streaming query statement to the at least one streaming event queue, and (5) while iteratively applying the streaming query statement, make at least one determination that the at least one anomaly condition is satisfied and then cause at least one anomaly notification to be issued to the user.
    Type: Grant
    Filed: January 21, 2022
    Date of Patent: January 30, 2024
    Assignee: Discover Financial Services
    Inventors: Dhineshkumar Pachamuthu, Abdul Nafeez Mohammad, Vivek Mathew, Sara Bonefas
  • Patent number: 11790117
    Abstract: Systems, computer-readable media, and methods for improving data privacy/anonymity and data value, wherein data related to a data subject can be used and stored, while minimizing re-identification risk by unauthorized parties and enabling data related to the data subject to be disclosed to an authorized party by granting access only to the data relevant to that authorized party's purpose, time period, place, and/or other criterion via the obfuscation of specific data values. The techniques described herein maintain this level of privacy/anonymity, while still empowering Data Subjects, e.g., consumers or customers of such authorized parties, by enabling them to request or specify their desired level of engagement with various business entities. Data Subjects may then receive privacy-respectful, trusted communication, e.g.
    Type: Grant
    Filed: June 4, 2021
    Date of Patent: October 17, 2023
    Assignee: Anonos IP LLC
    Inventors: Malcolm Gary LaFever, Ted N. Myerson, Steven Mason
  • Patent number: 11755398
    Abstract: The described technology is generally directed towards processing time series (e.g., device telemetry) data, including identifying missing data (gaps in the time series data), and delayed data. The time series data are converted to ternary data, e.g., zero if timely, one if delayed or two if missing, and counts are obtained for each. If the missing data and/or delayed counts are significant, e.g., exceed a threshold percentage of the total data, the time series data indicates a problem that can be narrowed down to a more specific cause. For example, the time series data can be filtered by customer products/offers and customer locations, and if a filtered dataset's ternary data are similar to the problematic data, as determined via unsupervised clustering as similarity data (occurring at a similar time), the potential problem or problems can be narrowed to a potential cause based on that filtered dataset's similarity.
    Type: Grant
    Filed: January 26, 2022
    Date of Patent: September 12, 2023
    Assignee: DELL PRODUCTS L.P.
    Inventor: Bina Thakkar
  • Patent number: 11741300
    Abstract: A collaborative content management system allows for the mutual-synchronization of content within a spreadsheet and within a document in which a set of spreadsheet cells are embedded. When a user modifies the embedded set of cells, the spreadsheet is updated to reflect the modification. A set of tasks, for instance each associated with descriptive text and one or more interactive elements, can be incorporated into a set of spreadsheet cells such that a user can interact with the tasks. A data value from a spreadsheet cell can be embedded into a document such that when the spreadsheet is updated and the data value changes, the corresponding embedded data value within the document can be changed. Spreadsheets can also include comments that can be navigated using a movable interface element that changes position within the spreadsheet based on a location of a set of cells corresponding to a comment.
    Type: Grant
    Filed: November 3, 2017
    Date of Patent: August 29, 2023
    Assignee: DROPBOX, INC.
    Inventors: Gabriel Silk, Andrew Udell, Arjun Mahadevan
  • Patent number: 11734072
    Abstract: Systems and techniques for managing and executing digital workflows are described. A technique described includes obtaining a job record from a job queue from a first server; assigning a node associated with a second server to handle a task indicated by the job record; operating, at the second server, a first action block in the node to produce output results in response to executing the task and to forward the output results to batch blocks; operating, at the second server, the batch blocks in the node to respectively accumulate different batch groups of the output results; operating, at the second server, the batch blocks in the node to respectively forward the different batch groups of the output results to respective second action blocks; and operating, at the second server, the second action blocks in the node to respectively process the different batch groups of the output results.
    Type: Grant
    Filed: December 31, 2020
    Date of Patent: August 22, 2023
    Assignee: Nuvolo Technologies Corporation
    Inventor: Collin Parker
  • Patent number: 11709813
    Abstract: A system and method for automatic generation of a data tree structure are disclosed. A database stores contract metadata associated with a plurality of contracts. The metadata includes relationship information data regarding parentage and/or child relationship between a particular contract and other contracts among the plurality of contracts. A processor operatively connects to the database via a communication network and accesses the database via the communication network to retrieve the contract metadata including the relationship information data. The processor also implements a search engine; stores the retrieved contract metadata including the relationship information data onto the search engine for creating a linkage between data points; and automatically generates, based on the created linkage between the data points, both an application programming interface (API) and a data tree structure that displays inter-dependency between two or more sets of contracts among the plurality of contracts.
    Type: Grant
    Filed: June 10, 2021
    Date of Patent: July 25, 2023
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Ilya Slavin, Michelle Roberts, Ian Bone, Fernando Nitz
  • Patent number: 11704339
    Abstract: A system for updating a hypercube includes an interface and a processor. The interface is configured to receive an indication to update a cell of the hypercube. The processor is configured to determine a primary dimension value associated with the cell; determine a group of dependencies based at least in part on the primary dimension value, wherein a dependency of the group of dependencies comprises one or more primary dimension values and a pattern; for the dependency of the group of dependencies, determine a set of source locations based at least in part on the one or more primary dimension values and the pattern; and mark the set of source locations as invalid.
    Type: Grant
    Filed: February 11, 2022
    Date of Patent: July 18, 2023
    Assignee: Workday, Inc.
    Inventors: Ngoc Nguyen, Darren Kermit Lee, Shuyuan Chen, Ritu Jain, Francis Wang
  • Patent number: 11675806
    Abstract: A hybrid network-based database system for handling OLTP and OLAP queries using decoupled compute and storage devices. A set of decoupled compute instances perform transactions on an OLTP database, and the data is replicated to an OLAP database, which is managed by another set of decoupled compute instances. Further, in response to queries, the database system can retrieve data from the OLTP and OLAP database for merging and processing according to the query.
    Type: Grant
    Filed: March 5, 2021
    Date of Patent: June 13, 2023
    Assignee: Snowflake Inc.
    Inventors: Leonidas Galanis, Alexander Miller, William Waddington, Khaled Yagoub
  • Patent number: 11675793
    Abstract: The inventions and its embodiments (hereafter called “the System”) are intended for use by any user in any situation where the amount of data is too extensive to effectively make sense of it in traditional manners or by use of traditional technology. Source data may be provided by one or many network computers and their inherent applications and/or data repositories. Information is made available to the users in intuitive contexts without moving, copying or manipulating the source data. Raw source data is extracted, analyzed, improved and normalized through a curating process for use by the System. All metadata are connected through a multidimensional, non-linear relational network, the fixed layer, based on a persistent relational network that includes any existing or emerging contextual information in the form of structured metadata.
    Type: Grant
    Filed: November 2, 2017
    Date of Patent: June 13, 2023
    Assignee: Intelligent Operations AS
    Inventors: Øystein Drivflaadt, Stein Fredriksen
  • Patent number: 11669535
    Abstract: Creating at a target database system, a target table and a history table each having a set of attributes of a source table in addition to at least one time attribute, wherein the time attribute of a record indicates the time when the record is valid. Receiving a request for applying a change of the source table to the target table. The request comprises a time value generated by the source database system indicating a time of the change. The change to the target table and the time value may be assigned to the time attribute of the current version and previous version of the record. The previous version of the record may be stored in the history table. The target table and the history table may be used to process a redirected query comprising a selection criterion on the time attribute.
    Type: Grant
    Filed: November 18, 2021
    Date of Patent: June 6, 2023
    Assignee: International Business Machines Corporation
    Inventors: Daniel Martin, Christian Wilhelm Paul Hoerst, Jens Müller, Johannes Severin Kern, Kevin Pelletier, Vassil Radkov Dimov, Namik Hrle
  • Patent number: 11630692
    Abstract: Techniques are disclosed for efficient utilization worker threads in a workflow-as-a-service (WFaaS) environment. A client device may request a workflow for execution by the client device. The client device may receive the requested workflow and initialize a set of worker threads to execute the workflow and a set of heartbeater threads to monitor the set of worker threads. Upon receiving an indication of a processing delay, the client device may capture the state of the workflow, suspend execution of the workflow, and store the workflow in a temporary queue. While the processing delay persists, the client device may use the set of worker threads to execute other tasks. When the processing delay terminates, the client device may resume execution of the workflow.
    Type: Grant
    Filed: March 24, 2022
    Date of Patent: April 18, 2023
    Assignee: Oracle International Corporation
    Inventors: Tanvir Singh Mundra, Christopher Richard Newcombe, Nathaniel Martin Glass
  • Patent number: 11625415
    Abstract: Data engine integration and data refinement are described. The actions include receiving, by a data refinement engine, a request for data. The actions include determining a first amount of processing to be performed by the data refinement engine and a second amount of processing to be performed by one or more processors of a data source that include a plurality of data nodes. The actions include transmitting, by the data refinement engine, code to the plurality of data nodes of instructions associated with the second amount of processing. The actions include receiving, by the data refinement engine and from the plurality of data nodes, unprocessed first data and processed second data. The actions include processing, by the data refinement engine, the unprocessed first data. The actions include, in response to the request for data, transmitting, by the data refinement engine, the processed first data and the processed second data.
    Type: Grant
    Filed: April 20, 2020
    Date of Patent: April 11, 2023
    Assignee: MicroStrategy Incorporated
    Inventor: Scott Cappiello
  • Patent number: 11556524
    Abstract: Aspects of the subject disclosure may include, for example, a processing system performing a method of receiving a plurality of data change transactions, wherein each data change transaction of the plurality of data change transactions comprises data object values, identifying by the processing system, data change groups indicating correlated data flows between databases by comparing data object values of the plurality of data change transactions, and determining data mappings of data objects stored in databases by statistical analysis of the correlated data flows. Other embodiments are disclosed.
    Type: Grant
    Filed: April 6, 2021
    Date of Patent: January 17, 2023
    Assignee: AT&T Global Network Services Deutschland GmbH
    Inventor: Joern Amand Franz
  • Patent number: 11526464
    Abstract: A non-transitory computer-readable storage media storing program instructions which, when executed by one or more processors, cause the one or more processors to perform: receiving a query to the distributed file system; determining a particular partition, associated with the data warehouse system, targeted by the query; accessing a repository associated with the data warehouse system to determine whether a partition-to-cluster mapping entry for the particular partition targeted by the query exists in the repository; in response to a determination that the entry for the particular partition exists in the repository, obtaining, from the entry for the particular partition, an identifier of a particular cluster to which the particular partition is assigned by the entry for the particular partition, the particular cluster being one of a plurality of clusters of the distributed file system, each cluster of the plurality of clusters having one name node and a plurality of data nodes.
    Type: Grant
    Filed: March 29, 2019
    Date of Patent: December 13, 2022
    Assignee: DROPBOX, INC.
    Inventor: Ashish Gandhi
  • Patent number: 11520752
    Abstract: The present disclosure relates to a control system for remotely controlling a change data capture (CDC) system. The CDC system comprises a source computing system and target computing system. The target computing system is configured to store a copy of data of the source computing system. The source computing system and the target computing system are configured to execute coordinated actions using predefined agents in order identify a change to data of the source computing system and to propagate, and store the change to the target computing system. The control system is configured for dynamically installing User-Defined Functions, UDF functions, in the source and target systems in order to control the agents to perform the predefined actions.
    Type: Grant
    Filed: March 27, 2019
    Date of Patent: December 6, 2022
    Assignee: International Business Machines Corporation
    Inventors: John Rooney, Peter Urbanetz
  • Patent number: 11475017
    Abstract: A method for asynchronous data enrichment may include receiving a query that includes a request for information about an entity. The query may specify a particular time range. In response to receiving the query, event information that is associated with the entity and that corresponds to the specified time range may be combined with additional information that is relevant to the query and that corresponds to the specified time range. The event information may initially be written to a record in an append-only data store. The additional information may become available after the event information, such that the additional information is not included in the record in the append-only data store. Instead, the additional information may initially be written to one or more additional data stores. Both the event information and the additional information may be provided in response to the query.
    Type: Grant
    Filed: March 5, 2019
    Date of Patent: October 18, 2022
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Benjamin Walter Martens, Nicholas Anthony Swanson
  • Patent number: 11455287
    Abstract: Embodiments are described for a system and method to analyze data at a plurality of data sources. A data analytic workflow may be received. The data analytic workflow may include at least one operation to be performed on a plurality of data sets stored at a plurality of data sources. Instructions may be created based on the operation to be performed and a type of platform that operates the data sources. Furthermore, the instructions may be transmitted to the data sources such that the data sources may execute the operations on the data sets stored at the data sources.
    Type: Grant
    Filed: August 1, 2013
    Date of Patent: September 27, 2022
    Assignee: TIBCO Software Inc.
    Inventors: Steven Hillion, Yi-Ling Chen, Zhe Dong, Yong-Sheng Yu, Yong Zhao
  • Patent number: 11436232
    Abstract: A method for execution by a node of a computing device includes determining a plurality of queries for concurrent execution. A plurality of sets of segments required to execute the plurality of queries is determined, and a set of virtual segments in the plurality of sets of segments is determined. A subset of the set of virtual segments is be determined by identifying ones of the set of virtual segments that are required to execute multiple ones of plurality of queries. A locally rebuilt set of rows for each of the set of virtual segments is generated by utilizing a recovery scheme. For each one of the set of virtual segments included in the subset, in response to generating the locally rebuilt set of rows, concurrent partial execution of corresponding multiple ones of the plurality of queries is facilitated.
    Type: Grant
    Filed: January 22, 2021
    Date of Patent: September 6, 2022
    Assignee: Ocient Holdings LLC
    Inventors: George Kondiles, Daniel Coombs
  • Patent number: 11366822
    Abstract: The present invention relates to a method for mapping heterogeneous medical data, the method comprising the steps of: generating domain clinic model ontology that defines a concept of arbitrary medical data collected from individual clinics and a relationship between the medical data; if SNOMED CT ontology that defines the concept and relationship of the domain clinic model ontology and standardized medical terms is loaded and the concept included in the domain clinic model ontology and/or the SNOMED CT ontology has a degree of similarity equal to or greater than a preset threshold value, determining that the concept has been mapped and generating a DCM-SNOMED mapping file for the mapping information; if vMR ontology describing the concept and relationship of data models defined by the SNOMED CT ontology and Health Level 7 standard is loaded and the concept included in the SNOMED CT ontology and/or the vMR ontology has a degree of similarity equal to or greater than a preset threshold value, determining that
    Type: Grant
    Filed: November 7, 2017
    Date of Patent: June 21, 2022
    Assignee: UNIVERSITY-INDUSTRY COOPERATION GROUP OF KYUNG HEE UNIVERSITY
    Inventors: Sung Young Lee, Ali Taqdir
  • Patent number: 11366873
    Abstract: A personalized content system enables a user with a communications device to convert and/or passively receive pre-selected content from multiple resources. A communications device has hardware and software to provide input and transmission to convert content from any form of media. The converted content is created by retrieving a digital copy of a digital record associated with it, and processing the digital copy for at least a web-based personalized application. Conversion is based on input of a code such as a telephone number, server program address, and a set of and/or range of characters. The transmission is communicated to at least one server that recognizes the code, the originating telephone number associated with the communications device, the device identifier associated with the communications device, and combinations thereof. The server retrieves a digital record and processes content and outputs based on user input, a user and/or program profile, and combinations thereof.
    Type: Grant
    Filed: August 28, 2019
    Date of Patent: June 21, 2022
    Assignee: Insignio Technologies, Inc.
    Inventor: Robert F. Scannell, Jr.
  • Patent number: 11361003
    Abstract: This disclosure provides various techniques that may allow for clustering a set of data objects and creating a visualization of the clustered data. For example, a user may desire to cluster data objects in a dataset to form meaningful groupings of the data objects. This disclosure provides, in one example of data object clustering and visualization, that a plurality of groupings of the data objects may be determined in parallel. These groupings may be evaluated and a particular grouping selected based on the evaluating. Data useable to visualize the particular grouping may be generated.
    Type: Grant
    Filed: October 26, 2016
    Date of Patent: June 14, 2022
    Assignee: salesforcecom, inc.
    Inventors: Guangyu Zhu, Robin Glinton
  • Patent number: 11362900
    Abstract: Systems, methods, and storage media for controlling identity information across multiple identity domains in a distributed identity infrastructure are disclosed. Exemplary implementations may: transmit first identity information from a first identity domain to an identity information control system; use the identity information control system to translate the first identity information from the first format to a second format and from the second format to a third format; send the first identity information in the third format from the identity information control system to a second identity domain; and replace second identity information in the second identity domain with the first identity information.
    Type: Grant
    Filed: June 11, 2021
    Date of Patent: June 14, 2022
    Assignee: Strata Identity, Inc.
    Inventors: Eric Olden, Christopher Marie, Carl Eric Leach
  • Patent number: 11354711
    Abstract: A system and method for assessing valuation of a document. The system includes a server arrangement communicably coupled to a client device. The server arrangement is configured to obtain information pertaining to document and ontologically map to identify relevant entities and semantic inter-relationships between identified entities for the current research work in the document; access information about entities and semantic inter-relationships related to existing research work in technical field from publicly accessible knowledge; compare the entities and the semantic inter-relationships related to the current research work in the document with the entities and the semantic inter-relationships related to existing research work determine a novelty of the document; and determine an assessment value of the document, based on the determined novelty of the document with respect to the publicly accessible knowledge, utilizing an expectation maximization algorithm.
    Type: Grant
    Filed: March 28, 2019
    Date of Patent: June 7, 2022
    Assignee: Innoplexus AG
    Inventors: Gunjan Bhardwaj, Abhijit Keskar
  • Patent number: 11348136
    Abstract: Embodiments of the present disclosure relate to data correlation of data pertaining to content distributed through distinct content delivery networks including offline networks and data related to user interaction with an online presence on the distributed computer network and uses for such correlated data, including to measure and quantify latent effects of the content distributed through a distinct content delivery network, such as an offline network, on user's interactions with the online presence on the distributed computer network.
    Type: Grant
    Filed: December 16, 2019
    Date of Patent: May 31, 2022
    Assignee: TATARI, INC.
    Inventors: Michael D. Swinson, Lin O'Driscoll, Wei Chen
  • Patent number: 11327795
    Abstract: Techniques are disclosed for efficient utilization worker threads in a workflow-as-a-service (WFaaS) environment. A client device may request a workflow for execution by the client device. The client device may receive the requested workflow and initialize a set of worker threads to execute the workflow and a set of heartbeater threads to monitor the set of worker threads. Upon receiving an indication of a processing delay, the client device may capture the state of the workflow, suspend execution of the workflow, and store the workflow in a temporary queue. While the processing delay persists, the client device may use the set of worker threads to execute other tasks. When the processing delay terminates, the client device may resume execution of the workflow.
    Type: Grant
    Filed: November 6, 2020
    Date of Patent: May 10, 2022
    Assignee: Oracle International Corporation
    Inventors: Tanvir Singh Mundra, Christopher Richard Newcombe, Nathaniel Martin Glass
  • Patent number: 11314780
    Abstract: An automated audit logger for producing a hyperindex visual chronicle of a construction project may include a receiver for receiving a data package including a sensor reading of a portion of a construction site relevant to a construction trade and a set of corresponding sensor metadata. The automated audit logger may also include an audit event creator for storing the sensor reading in an audit event entry of a data warehouse and a linking tool for updating a multi-faceted index of the data warehouse to link one or more members of the set of sensor metadata and a set of audit metadata to the audit event entry. The automated audit logger may also include an interface generator for constructing a user interface for displaying controlled subsets of the audit event entries and for serving the user interface to a user.
    Type: Grant
    Filed: October 23, 2019
    Date of Patent: April 26, 2022
    Assignee: Built Data LLC
    Inventor: Brett Grendahl
  • Patent number: 11294883
    Abstract: A method and a system import data into a table. The method includes providing the table with data identities and a primary key assigned to each of the data identities. A temporary copy of the table is provided and contains a data identity to be merged into the table. The table structure of the table and of the temporary copy is determined and the determined table structure is compared to the table structure of the temporary copy to decide which data identities have to be updated and/or imported. In the temporary copy a new column contains a final primary key of the related data identity for its transfer into the table. The data identities in the table that are present in the temporary copy are locked and an update function for the data identities having the same primary key in both the table and the temporary copy are executed.
    Type: Grant
    Filed: September 16, 2014
    Date of Patent: April 5, 2022
    Assignee: Siemens Aktiengesellschaft
    Inventors: Matteo Bardini, Andrea Boero, Davide Mini
  • Patent number: 11294922
    Abstract: A system, method and computer-readable medium for modeling relationships between query responses in a data set including receiving a selection of one or more first queries and one or more second queries, receiving a selection of one or more first strings and one or more second strings, determining one or more representative values corresponding to one or more intersections, each intersection corresponding to a unique combination of a first query, at least one second query, a first string, and at least one second string, and generating a three-dimensional representation including one or more indicators corresponding to the one or more intersections, a visual attribute of each indicator in the one or more indicators reflecting a representative value corresponding to that intersection and the one or more indicators being organized within the three-dimensional representation along three axes.
    Type: Grant
    Filed: June 26, 2020
    Date of Patent: April 5, 2022
    Inventor: Stephen Barry Glickman
  • Patent number: 11294876
    Abstract: In accordance with an embodiment, described herein is a system and method for generating a data cube for analytics. A map-reduce program running in a data processing cluster can read each line of a source data, and generate a key-value pair for each of a plurality of data combinations in that line of data. Values paired with the same key can be aggregated to generate one or more frequency values or one or more aggregate values, for representing the result of a query on the source data. Each query result can be stored in an output file, and can be encapsulated into a data cube cached in a distributed file system of the data processing cluster. The data cube can map a query from a client application to an output file, and can return a pre-computed result in the output file from the data cube to the client application.
    Type: Grant
    Filed: June 1, 2017
    Date of Patent: April 5, 2022
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Midda Dharmika Srinivasulu, Ambuj Saxena, Amrita Patil
  • Patent number: 11294924
    Abstract: A method displays a graphical user interface for a data visualization application. The user interface includes a schema information region that includes fields from a database. A user specifies a first aggregation using the interface. The first aggregation groups by a first set of fields and specifies an aggregated output field. The user also specifies a second aggregation. The second aggregation references the first aggregation and groups by a second set of fields. The set may include the aggregated output field. The second set is different from the first set. The method builds a visual specification based on the first and second aggregations. The method may retrieve tuples of data from the database using database queries generated from the visual specification, where each tuple includes data calculated based on the second aggregation. The method may display a data visualization, including the data calculated based on the second aggregation.
    Type: Grant
    Filed: July 16, 2015
    Date of Patent: April 5, 2022
    Assignee: TABLEAU SOFTWARE, INC.
    Inventors: Justin Talbot, Ross Thomas Bunker, Robin Stewart, Bora Beran
  • Patent number: 11263226
    Abstract: Systems, computer program products, and methods are described herein for providing real-time intelligence engine for data asset discovery. The present invention is configured to receive an indication that a first user has initiated a creation of a first multi-dimensional cube using a first computing node; initiate an asset recovery engine on the first computing device to: compare attributes associated with the first multi-dimensional cube with attributes associated with the multi-dimensional cubes stored on the first edge computing unit of the first computing node to determine a match; retrieve a first configuration file associated with the subset of the one or more multi-dimensional cubes stored on the first edge computing unit of the first computing node; and execute the creation of the first multi-dimensional cube based on the first configuration file using the first computing node.
    Type: Grant
    Filed: December 2, 2019
    Date of Patent: March 1, 2022
    Assignee: BANK OF AMERICA CORPORATION
    Inventors: Saisrikanth Chitty, Gaurav Bansal
  • Patent number: 11256690
    Abstract: Methods for splitting a plurality of records into subsets for parallel processing by separate threads are disclosed. In one embodiment, a plurality of records are added to a database. The adding includes tracking, for each unique value found in the plurality of records within a selected one of the sequence of fields, a statistic based on the values found in the plurality of records within a next one of the sequence of fields. Then a plurality of queries are generated, each includes a row value constructor (RVC) with a logical operation, a specific one of the unique values found within the selected one of the sequence of fields, and, for that specific value, the tracked statistic. Then a plurality of threads are caused to execute that each submit one of the queries and operate on a subset of the plurality of records responsive to execution of that query.
    Type: Grant
    Filed: April 22, 2020
    Date of Patent: February 22, 2022
    Assignee: salesforce.com, inc.
    Inventors: Danil Dvinov, Parth Vijay Vaishnav, Chenghung Ker
  • Patent number: 11226970
    Abstract: A method and system for tagging database columns are presented. The method includes receiving an input column name of at least one column in a database; performing signature matching of the input column name to contents of a seed table; determining a first confidence score for the signature matching; and tagging a matching value in the seed table as a tag for the input column name, when a first confidence score exceeds a first threshold value.
    Type: Grant
    Filed: September 28, 2018
    Date of Patent: January 18, 2022
    Assignee: HITACHI VANTARA LLC
    Inventors: Tomoya Wada, Winnie Cheng, Rohit Mahajan, Alex Mylnikov
  • Patent number: 11226941
    Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program queries a set of databases to identify a first set of database schemas. Each database schema in the first set of database schemas is configured for a database in the set of databases. The program further queries an inventory data storage for a second set of database schemas. The program also compares the first set of database schemas and the second set of database schemas. Based on the comparison, the program further determines whether to deactivate database schemas in the set of databases.
    Type: Grant
    Filed: November 20, 2019
    Date of Patent: January 18, 2022
    Assignee: SAP SE
    Inventor: Torsten Krause
  • Patent number: 11163764
    Abstract: A computer-implemented method for balancing storage utilization and query processing in a distributed database. In one embodiment, the method receives a set of queries to perform on a database; determines a uniqueness score and a usage score based on the set of queries for each column of each data table in the database; normalizes the usage score and the uniqueness score to generate a normalized usage score and a normalized uniqueness score; multiplies the normalized uniqueness score by a first weight factor to produce a weighted uniqueness score; multiplies the normalized usage score by a second weight factor to produce a weighted usage score; combines the weighted uniqueness score and the weighted usage score to generate a combined column score; selects a column having a highest combined column score; and recreates the plurality of data tables of the database on the plurality of nodes using the column as a new distribution key.
    Type: Grant
    Filed: June 1, 2018
    Date of Patent: November 2, 2021
    Assignee: International Business Machines Corporation
    Inventors: Yet-San Lam, Malcolm Singh
  • Patent number: 11157496
    Abstract: A computer-implemented method for balancing storage utilization and query processing in a distributed database. In one embodiment, the computer-implemented method receives a set of queries to perform on a database that is distributed among a plurality of nodes. The database includes a plurality of data tables that each includes a plurality of columns and a plurality of rows. The computer-implemented method determines a uniqueness score and a join score for each column of each data table in the database based on the set of queries. The computer-implemented method determines a new distribution key based on the uniqueness score and the join score for each column of each data table in the database. The computer-implemented method recreates the plurality of data tables of the database on the plurality of nodes using the new distribution key for execution of the set of queries.
    Type: Grant
    Filed: June 1, 2018
    Date of Patent: October 26, 2021
    Assignee: International Business Machines Corporation
    Inventors: Yet-San Lam, Malcolm Singh
  • Patent number: 11157466
    Abstract: In various embodiments, a computer system implements a service that stores a plurality of database templates that define data types supported for a non-relational database accessible to a plurality of applications. The service receives, from a developer of an application, a selection of one of the plurality of database templates to be used by the application. In response to the selection, the service issues a set of data definition language (DDL) instructions to provision the non-relational database with a schema that implements a particular data type defined by the selected template. Requests from the application to manipulate a value of the particular data type stored in the non-relational database system are serviced. In some embodiments, the servicing includes identifying a set of data manipulation language (DML) instructions to be executed and issuing the set of DML, instructions to the non-relational database.
    Type: Grant
    Filed: September 4, 2018
    Date of Patent: October 26, 2021
    Assignee: salesforce.com, inc.
    Inventors: Benjamin Busjaeger, Michael Sgroi, Scott D. Hansma
  • Patent number: 11119458
    Abstract: A building management system (BMS) includes building equipment, a data collector, a sample aggregator, and an application. The building equipment is operable to monitor and control a variable in the BMS and to provide raw data samples of the variable. The data collector is configured to collect the raw data samples from the building equipment and generate a raw data timeseries including a plurality of the raw data samples. The sample aggregator is configured to automatically generate a data rollup timeseries including a plurality of aggregated data samples. The aggregated data samples are generated by aggregating the raw data samples as the raw data samples are collected from the building equipment. Both timeseries are stored in a timeseries database. The application is configured to retrieve the raw data timeseries and the data rollup timeseries from the timeseries database in response to a request for timeseries data associated with the variable.
    Type: Grant
    Filed: November 18, 2019
    Date of Patent: September 14, 2021
    Assignee: Johnson Controls Tyco IP Holdings LLP
    Inventors: Gerald A. Asp, Youngchoon Park, Peter A. Craig
  • Patent number: 11106647
    Abstract: Provided are methods, systems, and computer readable media for user interaction with database methods and systems. In an aspect, a user interface can be generated to permit dynamic display generation to view data. The system can comprise a visualization component to dynamically generate one or more visual representations of the data to present in the state space.
    Type: Grant
    Filed: February 21, 2019
    Date of Patent: August 31, 2021
    Assignee: QLIKTECH INTERNATIONAL AB
    Inventor: Håkan Wolgé
  • Patent number: 11086963
    Abstract: An experimentation platform controls testing of features by an application server. Based on a user identifier, the experimentation platform determines which feature should be provided, and the application server provides the corresponding version of a user interface. If the user behavior data shows that using a tested feature results in an improvement, the tested feature will be adopted. To determine whether or not an improvement is observed, a statistically significant amount of data is gathered. The experimentation platform gathers data regarding user behavior for the feature versions and, in response, adjusts the frequency at which each version is served. Providing the proposed version to an increased percentage of users decreases the total number of page serves required to gather statistically significant data. The experimentation platform may provide an updated projected time to completion of testing based on the changed percentage of users receiving the proposed version.
    Type: Grant
    Filed: December 5, 2018
    Date of Patent: August 10, 2021
    Assignee: eBay Inc.
    Inventors: Deepak Kumar Vasthimal, Pavan Kumar Srirama, Arun Kumar Akkinapalli
  • Patent number: 11061926
    Abstract: Methods and systems for managing synchronization among databases are described. One method includes establishing a trigger within a transactional database storing a plurality of transaction records, the trigger having a trigger condition associated with storing a new transaction record in the transactional database. The method includes, in response to each occurrence of the trigger condition, storing a primary key of the new transaction record into a primary key table. The method also includes aggregating transaction record information into a transaction dataset, the transaction record information being from each of a plurality of transaction records that are associated with primary keys stored in the primary key table during a predetermined time period; and transmitting the transaction dataset to a remote analysis database as streaming data.
    Type: Grant
    Filed: October 2, 2018
    Date of Patent: July 13, 2021
    Assignee: Target Brands, Inc.
    Inventor: Deepa Sarasamma
  • Patent number: 11055974
    Abstract: Methods, systems, and apparatus, for defining and monitoring an event for a physical entity and the performance of an action in response to the occurrence of the event. A method includes receiving data indicating an event for a physical entity, the event specified in part by a physical environment feature for which the occurrence of the event is to be monitored by the data processing apparatus; receiving data indicating an action associated with the event and to be taken in response to the occurrence of the event; monitoring for the occurrence of the event for the physical entity; and in response to the occurrence of the event, causing the action associated with the event to be performed.
    Type: Grant
    Filed: December 16, 2019
    Date of Patent: July 6, 2021
    Assignee: GOOGLE LLC
    Inventors: Fergus Gerard Hurley, Robin Dua
  • Patent number: 11003693
    Abstract: An allocation of tables across a distributed database provides for taking into account existing table groups while also obtaining newly calculated table groups that are formed according to a new table group allocation. Such a new table group allocation may be desired to optimize workload balancing and/or data transfers for new workload patterns. Maintaining one or more types of existing table groups allows for the existing table groups to not be overwritten during allocation of the tables. An identification of tables is used, as well as a selected user-defined grouping option to indicate a mode for maintaining or replacing the existing table groups. An iterative process includes assigning, for each table, a group name and a group type.
    Type: Grant
    Filed: April 5, 2018
    Date of Patent: May 11, 2021
    Assignee: SAP SE
    Inventor: Antje Heinle
  • Patent number: 10992481
    Abstract: A computer-implemented method includes receiving, by an electronic device, a two-dimensional code generation request from a user operating the electronic device, the electronic device comprising secure element; obtaining, by the electronic device, two-dimensional code generation data, wherein the two-dimensional code generation data comprises account data of the user and timestamp data of the electronic device; obtaining, by the electronic device, signature data based on a predetermined signature algorithm stored in the secure element; and generating, by the electronic device, a target two-dimensional code based on the two-dimensional code generation data and the signature data.
    Type: Grant
    Filed: October 30, 2020
    Date of Patent: April 27, 2021
    Assignee: Advanced New Technologies Co., Ltd.
    Inventors: Qi Huang, Shengbo Zhao, Hui Liao, Zhiwei Wang, Yawen Wei
  • Patent number: 10977266
    Abstract: Disclosed herein are system, method, and computer program product embodiments for performing ad-hoc analytical queries of graph data. An embodiment operates by receiving a graph pattern for a subgraph of interest. The facts of interest are then selected from graph data based on the received graph pattern. Dimensions are then defined based on a dimension seed pattern and a set of level expressions, and measures are defined based on a computation function and an aggregation function. A graph cube is formed based on the selected facts and the defined dimensions and measures. Because the facts, dimensions, and measures of interest are defined at the time of an analytical query, a user does not have to define such facts, dimensions, and measures, or know which analytical queries will be of interest, at the time of data collection.
    Type: Grant
    Filed: May 15, 2015
    Date of Patent: April 13, 2021
    Assignee: SAP SE
    Inventors: Michael Rudolf, Hannes Voigt, Christof Bornhövd, Wolfgang Lehner
  • Patent number: 10965665
    Abstract: Systems and methods for network security are provided. Various embodiments of the present technology provide systems and methods for an identity security gateway agent that provides for privileged access. Embodiments include a system and method that uses a single sign-on (SSO) (or similar) mechanism to facilitate a user accessing web-based service providers, but separates the assertion and entire SSO process from the user credential.
    Type: Grant
    Filed: September 16, 2020
    Date of Patent: March 30, 2021
    Assignee: SAILPOINT TECHNOLOGIES, INC
    Inventors: Ryan Privette, Kris Keller
  • Patent number: 10956255
    Abstract: An automated agent may communicate with a user via a chat channel to proactively alert the user of an L1 IT support issue. The L1 IT support issue may be determined based on monitoring indications of human-initiated activities maintained by a system of record, and may, prior to the automated agent's alert, be unknown to the user. In some instances, a natural language understanding (NLU) module may be used to identify an entity and intent from the indications of human-initiated activities, and the L1 IT support issue may be determined based on the determined entity and intent. After alerting the user of the L1 IT support issue, the automated agent may inform, via the chat channel, the user of a remediation step available to address the L1 IT support issue. Upon obtaining the user's permission, the automated agent may perform the remediation step to address the L1 IT support issue.
    Type: Grant
    Filed: April 24, 2020
    Date of Patent: March 23, 2021
    Assignee: MOVEWORKS, INC.
    Inventors: Ahmed Al-Bahar, Sadish Ravi, Sunil Nagaraj, Dongxu Zhou, Vaibhav Nivargi, Varun Singh, Jiang Chen, Bhavin Nicholas Shah