Data Warehouse, Data Mart, Online Analytical Processing (olap), Decision Support Systems Patents (Class 707/600)
-
Patent number: 12198816Abstract: A system is configured for retrieving first patient medical information about a first patient, and performing a first data conversion procedure including performing a translation procedure and a coding procedure. The system is further configured for adding to the database a record of an association between the predetermined code and the first patient medical information. The system is also configured for retrieving second patient medical information about a second patient, comparing the second patient medical information with records in the database, and determining a level of confidence that the second patient medical information matches the first patient medical information. If the determined level of confidence exceeds a first predetermined threshold, the system omits the translation procedure.Type: GrantFiled: October 16, 2023Date of Patent: January 14, 2025Assignee: Healthcare Interactive, Inc.Inventor: Henry H. Cha
-
Patent number: 12105732Abstract: A method for executing a query on a target database against the most recent source data is disclosed. The method comprises maintaining linked—i.e., at least partially synchronized—databases comprising a source and a target database. The method comprises receiving a direct query against a table in the target database, the query comprising a request for using the most recent source data and requesting by the target database from the source database a status about latest data regarding the table. Upon the status indicating that data in the table do not correspond to the most recent data, the method comprises waiting up to a predefined time period for the most recent data of the table to be synchronized from the source database to the target database, and upon the data of the table not being synchronized within the predefined time period, the method comprises issuing a timeout signal.Type: GrantFiled: April 6, 2022Date of Patent: October 1, 2024Assignee: International Business Machines CorporationInventors: Vassil Radkov Dimov, Daniel Martin, Christian Michel, Namik Hrle
-
Patent number: 12093374Abstract: A system and method for providing cybersecurity incident response utilizing a large language model. The method includes: mapping a received incident input into a scenario of a plurality of scenarios, each scenario including a plurality of sub-scenarios; generating a query based on the received incident input and a selection of a sub-scenario of the plurality of sub-scenarios; executing the query on a security database, the security database including a representation of the computing environment; and initiating a mitigation action based on a result of the executed query.Type: GrantFiled: April 29, 2024Date of Patent: September 17, 2024Assignee: Wiz, Inc.Inventors: Alon Schindel, Barak Sharoni, Amitai Cohen, Ami Luttwak, Roy Reznik, Yinon Costica
-
Patent number: 12038921Abstract: A method includes executing a program that specifies operations and accessing a translation file that includes instructions for translating the language of the program into a language of a database. The translation file specifies operations in the language of the program that are supported by the database and the semantic meaning of the supported operations in the language of the database. Operations of the program that are unsupported by the database are processed by the program. Operations of the program that are supported by the database are determined from the translation file, and a portion of the program representing the supported operations is translated, using the translation file, into the language of the database and transmitted to the database. Data resulting from execution, within the database, of the translated portion of the program representing the operations that are supported by the database is received by the program.Type: GrantFiled: September 4, 2020Date of Patent: July 16, 2024Assignee: Ab Initio Technology LLCInventors: Garth Dickie, Ian Schechter
-
Patent number: 11966686Abstract: The present disclosure provides for predictive query processing for complex system lifecycle management by identifying a seed document including natural language text describing an issue with a complex system; creating a synthesized document for the seed document by: removing portions of the seed document determined to satisfy filtering rules; identifying a first term set included in the natural language text that map to terminology identified in a data dictionary; extracting term-order data based on locations of the first term set in the natural language text; and including the first term set and the term-order data in the synthesized document; identifying, from a corpus of historic electronic documents, a first document set that are related to the seed document based on the term-order data included in the synthesized document; and outputting at least a portion of the first set of historic electronic documents.Type: GrantFiled: June 17, 2019Date of Patent: April 23, 2024Assignee: THE BOEING COMPANYInventors: Robert Santoso, Keith Pete Cai, Jay J. Patel
-
Patent number: 11960487Abstract: Methods and systems for using dispersed cached data stored in multiple database nodes for serving database access requests are described herein. Upon receiving a request for data from a requesting device, a first application server determines whether the requested data is stored in a local cache memory. If it is determined that the requested data is not stored in the local cache memory, without accessing a local, first database, the first application server determines that the requested data is stored in a cache memory of a second application server, wherein the second application server stores at least a portion of the data from a second database in its cache memory. The first application server retrieves the requested data from the cache memory of the second application server and provides the retrieved data to the requesting device.Type: GrantFiled: May 10, 2021Date of Patent: April 16, 2024Assignee: PAYPAL, INC.Inventor: Shanmukh Sista
-
Patent number: 11938983Abstract: A train position estimation device which calculates the position of a vehicle traveling on a predetermined path and comprises a surroundings shape measurement unit that is installed in the vehicle and measures the shape of the surroundings of the current location of the vehicle and a map storage unit for storing surroundings shape data at positions measured in advance, the train position estimation device being characterized by comprising a start position estimation unit for storing the probability of presence of the vehicle at each position; a map retrieval section determination device for outputting surroundings shape data for each position in descending order of presence probability; and a matching processing device that compares the surroundings shape data for the current location with the retrieved surroundings shape data and outputs the position for which the difference therebetween is equal to or less than a predetermined threshold value.Type: GrantFiled: January 28, 2019Date of Patent: March 26, 2024Assignee: HITACHI, LTD.Inventors: Yuhi Tsutsumi, Atsushi Oda, Keiichi Katsuta, Kazuo Tokuyama
-
Patent number: 11907138Abstract: 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: GrantFiled: December 31, 2021Date of Patent: February 20, 2024Assignee: QUALCOMM IncorporatedInventors: Hiral Nandu, Subbarao Palacharla, George Patsilaras, Alain Artieri, Simon Peter William Booth, Vipul Gandhi, Girish Bhat, Yen-Kuan Wu, Younghoon Kim
-
Patent number: 11907220Abstract: 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: GrantFiled: December 18, 2020Date of Patent: February 20, 2024Assignee: International Business Machines CorporationInventors: Al Chakra, Ruiping Li, Terence P. Purcell, Lily Zhou
-
Patent number: 11899690Abstract: 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: GrantFiled: September 2, 2019Date of Patent: February 13, 2024Assignee: NIPPON TELEGRAPH AND TELEPHONE CORPORATIONInventor: Satoru Yagi
-
Patent number: 11886278Abstract: 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: GrantFiled: January 21, 2022Date of Patent: January 30, 2024Assignee: Discover Financial ServicesInventors: Dhineshkumar Pachamuthu, Abdul Nafeez Mohammad, Vivek Mathew, Sara Bonefas
-
Patent number: 11790117Abstract: 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: GrantFiled: June 4, 2021Date of Patent: October 17, 2023Assignee: Anonos IP LLCInventors: Malcolm Gary LaFever, Ted N. Myerson, Steven Mason
-
Patent number: 11755398Abstract: 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: GrantFiled: January 26, 2022Date of Patent: September 12, 2023Assignee: DELL PRODUCTS L.P.Inventor: Bina Thakkar
-
Patent number: 11741300Abstract: 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: GrantFiled: November 3, 2017Date of Patent: August 29, 2023Assignee: DROPBOX, INC.Inventors: Gabriel Silk, Andrew Udell, Arjun Mahadevan
-
Patent number: 11734072Abstract: 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: GrantFiled: December 31, 2020Date of Patent: August 22, 2023Assignee: Nuvolo Technologies CorporationInventor: Collin Parker
-
Patent number: 11709813Abstract: 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: GrantFiled: June 10, 2021Date of Patent: July 25, 2023Assignee: JPMORGAN CHASE BANK, N.A.Inventors: Ilya Slavin, Michelle Roberts, Ian Bone, Fernando Nitz
-
Patent number: 11704339Abstract: 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: GrantFiled: February 11, 2022Date of Patent: July 18, 2023Assignee: Workday, Inc.Inventors: Ngoc Nguyen, Darren Kermit Lee, Shuyuan Chen, Ritu Jain, Francis Wang
-
Patent number: 11675793Abstract: 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: GrantFiled: November 2, 2017Date of Patent: June 13, 2023Assignee: Intelligent Operations ASInventors: Øystein Drivflaadt, Stein Fredriksen
-
Patent number: 11675806Abstract: 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: GrantFiled: March 5, 2021Date of Patent: June 13, 2023Assignee: Snowflake Inc.Inventors: Leonidas Galanis, Alexander Miller, William Waddington, Khaled Yagoub
-
Patent number: 11669535Abstract: 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: GrantFiled: November 18, 2021Date of Patent: June 6, 2023Assignee: International Business Machines CorporationInventors: Daniel Martin, Christian Wilhelm Paul Hoerst, Jens Müller, Johannes Severin Kern, Kevin Pelletier, Vassil Radkov Dimov, Namik Hrle
-
Patent number: 11630692Abstract: 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: GrantFiled: March 24, 2022Date of Patent: April 18, 2023Assignee: Oracle International CorporationInventors: Tanvir Singh Mundra, Christopher Richard Newcombe, Nathaniel Martin Glass
-
Patent number: 11625415Abstract: 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: GrantFiled: April 20, 2020Date of Patent: April 11, 2023Assignee: MicroStrategy IncorporatedInventor: Scott Cappiello
-
Patent number: 11556524Abstract: 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: GrantFiled: April 6, 2021Date of Patent: January 17, 2023Assignee: AT&T Global Network Services Deutschland GmbHInventor: Joern Amand Franz
-
Patent number: 11526464Abstract: 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: GrantFiled: March 29, 2019Date of Patent: December 13, 2022Assignee: DROPBOX, INC.Inventor: Ashish Gandhi
-
Patent number: 11520752Abstract: 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: GrantFiled: March 27, 2019Date of Patent: December 6, 2022Assignee: International Business Machines CorporationInventors: John Rooney, Peter Urbanetz
-
Patent number: 11475017Abstract: 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: GrantFiled: March 5, 2019Date of Patent: October 18, 2022Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Benjamin Walter Martens, Nicholas Anthony Swanson
-
Patent number: 11455287Abstract: 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: GrantFiled: August 1, 2013Date of Patent: September 27, 2022Assignee: TIBCO Software Inc.Inventors: Steven Hillion, Yi-Ling Chen, Zhe Dong, Yong-Sheng Yu, Yong Zhao
-
Patent number: 11436232Abstract: 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: GrantFiled: January 22, 2021Date of Patent: September 6, 2022Assignee: Ocient Holdings LLCInventors: George Kondiles, Daniel Coombs
-
Patent number: 11366873Abstract: 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: GrantFiled: August 28, 2019Date of Patent: June 21, 2022Assignee: Insignio Technologies, Inc.Inventor: Robert F. Scannell, Jr.
-
Patent number: 11366822Abstract: 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 thatType: GrantFiled: November 7, 2017Date of Patent: June 21, 2022Assignee: UNIVERSITY-INDUSTRY COOPERATION GROUP OF KYUNG HEE UNIVERSITYInventors: Sung Young Lee, Ali Taqdir
-
Patent number: 11362900Abstract: 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: GrantFiled: June 11, 2021Date of Patent: June 14, 2022Assignee: Strata Identity, Inc.Inventors: Eric Olden, Christopher Marie, Carl Eric Leach
-
Patent number: 11361003Abstract: 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: GrantFiled: October 26, 2016Date of Patent: June 14, 2022Assignee: salesforcecom, inc.Inventors: Guangyu Zhu, Robin Glinton
-
Patent number: 11354711Abstract: 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: GrantFiled: March 28, 2019Date of Patent: June 7, 2022Assignee: Innoplexus AGInventors: Gunjan Bhardwaj, Abhijit Keskar
-
Patent number: 11348136Abstract: 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: GrantFiled: December 16, 2019Date of Patent: May 31, 2022Assignee: TATARI, INC.Inventors: Michael D. Swinson, Lin O'Driscoll, Wei Chen
-
Patent number: 11327795Abstract: 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: GrantFiled: November 6, 2020Date of Patent: May 10, 2022Assignee: Oracle International CorporationInventors: Tanvir Singh Mundra, Christopher Richard Newcombe, Nathaniel Martin Glass
-
Patent number: 11314780Abstract: 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: GrantFiled: October 23, 2019Date of Patent: April 26, 2022Assignee: Built Data LLCInventor: Brett Grendahl
-
Patent number: 11294876Abstract: 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: GrantFiled: June 1, 2017Date of Patent: April 5, 2022Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Midda Dharmika Srinivasulu, Ambuj Saxena, Amrita Patil
-
Patent number: 11294883Abstract: 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: GrantFiled: September 16, 2014Date of Patent: April 5, 2022Assignee: Siemens AktiengesellschaftInventors: Matteo Bardini, Andrea Boero, Davide Mini
-
Patent number: 11294922Abstract: 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: GrantFiled: June 26, 2020Date of Patent: April 5, 2022Inventor: Stephen Barry Glickman
-
Patent number: 11294924Abstract: 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: GrantFiled: July 16, 2015Date of Patent: April 5, 2022Assignee: TABLEAU SOFTWARE, INC.Inventors: Justin Talbot, Ross Thomas Bunker, Robin Stewart, Bora Beran
-
Patent number: 11263226Abstract: 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: GrantFiled: December 2, 2019Date of Patent: March 1, 2022Assignee: BANK OF AMERICA CORPORATIONInventors: Saisrikanth Chitty, Gaurav Bansal
-
Patent number: 11256690Abstract: 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: GrantFiled: April 22, 2020Date of Patent: February 22, 2022Assignee: salesforce.com, inc.Inventors: Danil Dvinov, Parth Vijay Vaishnav, Chenghung Ker
-
Patent number: 11226941Abstract: 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: GrantFiled: November 20, 2019Date of Patent: January 18, 2022Assignee: SAP SEInventor: Torsten Krause
-
Patent number: 11226970Abstract: 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: GrantFiled: September 28, 2018Date of Patent: January 18, 2022Assignee: HITACHI VANTARA LLCInventors: Tomoya Wada, Winnie Cheng, Rohit Mahajan, Alex Mylnikov
-
Patent number: 11163764Abstract: 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: GrantFiled: June 1, 2018Date of Patent: November 2, 2021Assignee: International Business Machines CorporationInventors: Yet-San Lam, Malcolm Singh
-
Patent number: 11157496Abstract: 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: GrantFiled: June 1, 2018Date of Patent: October 26, 2021Assignee: International Business Machines CorporationInventors: Yet-San Lam, Malcolm Singh
-
Patent number: 11157466Abstract: 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: GrantFiled: September 4, 2018Date of Patent: October 26, 2021Assignee: salesforce.com, inc.Inventors: Benjamin Busjaeger, Michael Sgroi, Scott D. Hansma
-
Patent number: 11119458Abstract: 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: GrantFiled: November 18, 2019Date of Patent: September 14, 2021Assignee: Johnson Controls Tyco IP Holdings LLPInventors: Gerald A. Asp, Youngchoon Park, Peter A. Craig
-
Patent number: 11106647Abstract: 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: GrantFiled: February 21, 2019Date of Patent: August 31, 2021Assignee: QLIKTECH INTERNATIONAL ABInventor: Håkan Wolgé
-
Patent number: 11086963Abstract: 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: GrantFiled: December 5, 2018Date of Patent: August 10, 2021Assignee: eBay Inc.Inventors: Deepak Kumar Vasthimal, Pavan Kumar Srirama, Arun Kumar Akkinapalli