Database Query Processing Patents (Class 707/769)
  • Patent number: 11972215
    Abstract: A method for providing automated support services by utilizing artificial intelligence is disclosed. The method includes receiving, via a graphical user interface, a request from a user; parsing, by using syntax analysis, the request; identifying, from the parsed request, a factor by using a model such as a machine learning model, the factor including a request context and a request sentiment; associating the request with a category corresponding to the factor; determining, by using the model, whether the request can be automatically resolved based on the factor and the category; and initiating at least one action based on a result of the determining.
    Type: Grant
    Filed: November 17, 2020
    Date of Patent: April 30, 2024
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Kevin J McNamara, Eugene Mariotti
  • Patent number: 11972018
    Abstract: Computer-readable media, methods, and systems are provided for purpose-based processing of personal data within an information retrieval framework. A data subject may request information relating to their personal data such that the data subject is identified within the information retrieval framework and an information report is generated based on the personal data of the data subject and its purpose assignment and data category assignment. The information report is provided to the data subject such that the data subject may review how their personal data is processed and organized within the information retrieval framework.
    Type: Grant
    Filed: January 24, 2022
    Date of Patent: April 30, 2024
    Assignee: SAP SE
    Inventors: Saritha Palli, Naved Ahmed
  • Patent number: 11971930
    Abstract: Aspects of the disclosure relate to a hybrid metaverse environment. A computing platform may synchronize, using edge nodes and with a physical repository server, a soft document repository. The computing platform may receive, via a metaverse application interface, an event processing request. The computing platform may identify, based on the event processing request and using a machine learning model, documents needed to execute the event processing request. The computing platform may update a request queue to identify the event processing request and the documents. The computing platform may access, using an edge node and via the soft document repository, the physical repository server to obtain document images corresponding to the identified documents, and may update a response queue to include the obtained document images. The computing platform may send, to an enterprise user device, a haptic alert indicating that the event processing request is ready for processing.
    Type: Grant
    Filed: August 18, 2022
    Date of Patent: April 30, 2024
    Assignee: Bank of America Corporation
    Inventors: Saurabh Arora, Sandeep Chauhan
  • Patent number: 11972012
    Abstract: Implementations of the present disclosure include receiving, by a database system, a query, providing, by the database system, a set of checker objects including one or more inner checker objects and an outer checker object, each checker object corresponding to a nested sub-query of the query, providing, by the database system, an authorization list associated with the outer checker object, and executing an authorization check on the query at least partially by: adding collected objects of each inner checker object to the authorization list, adding collected objects of the outer checker object to the authorization list, and determining authorization of an entity based on the authorization list.
    Type: Grant
    Filed: August 31, 2021
    Date of Patent: April 30, 2024
    Assignee: SAP SE
    Inventor: Yinghua Ouyang
  • Patent number: 11967431
    Abstract: Hierarchical data objects are generated via a computer-based system for applying a series of rules to establish episode-specific data objects reflecting a plurality of discrete claim records before further dissecting the generated episode-specific data objects prior to finalization of those episode-specific data objects to identify claim records within the episode-specific data objects that are eligible for generation of one or more sub-episodes within the episode-specific data objects. The identified sub-episodes are reflected within the episode-specific data object to designate complete episodes of care that additionally reflect interactions with the corresponding parent episode.
    Type: Grant
    Filed: May 22, 2020
    Date of Patent: April 23, 2024
    Assignee: Optum, Inc.
    Inventors: Peter N. Toensing, Bob Martin
  • Patent number: 11966419
    Abstract: The present disclosure provides a computer-implemented method for scoring and visualizing combined search results, comprising: (a) performing a plurality of individual searches on data objects stored in a database, wherein the data objects are stored in defined fixed data structures; (b) combining the plurality of individual searches into a combined search; (c) determining a weight for each of the individual searches; and (d) obtaining a search result of the combined search, wherein the search result of the combined search comprises scores associated with a subset of the data objects.
    Type: Grant
    Filed: June 22, 2020
    Date of Patent: April 23, 2024
    Assignee: DataWalk Spólka Akcyjna
    Inventors: Krystian Piecko, Bartosz Kolasa
  • Patent number: 11966387
    Abstract: Method, computer program product, and computer system are provided. Traffic is collected against a NoSQL database by an activity collector. A database transaction log is periodically extracted and analyzed. The collected traffic and the analyzed database transaction log are input to building a knowledge base of database access patterns. Current traffic is captured and used to compute an activity threshold. Traffic is directed to a workload processor based on the activity threshold. Traffic is directed to an intensive insert/update/delete (IUD) processor in response to the activity threshold exceeding a configured threshold. A plurality of temporary shards is generated along with an adaptive key and adaptive index in the plurality of temporary shards. The intensive IUD processor traffic is re-directed to the plurality of temporary shards while the activity threshold exceeds the configured threshold.
    Type: Grant
    Filed: September 20, 2022
    Date of Patent: April 23, 2024
    Assignee: International Business Machines Corporation
    Inventors: Peng Hui Jiang, Jun Su, Guang Han Sui, Di Li Hu
  • Patent number: 11966959
    Abstract: In an approach to providing a notification of content to a marketplace subscriber, one or more computer processors monitor a query for content in an online marketplace. One or more computer processors determine that the content was not found. One or more computer processors receive new content to the online marketplace. One or more computer processors determine that the new content corresponds to the query for which the content was not found. One or more computer processors send a notification of the new content.
    Type: Grant
    Filed: September 23, 2020
    Date of Patent: April 23, 2024
    Assignee: International Business Machines Corporation
    Inventors: Lisa Seacat DeLuca, Chandler Maskal
  • Patent number: 11966936
    Abstract: Systems and methods for executing queries on a bitmap index are disclosed. The system may receive a first data stream from a database and generate a bitmap index based on the first data stream. The system may receive an input selection of one or more data conditions from a user device and generate a Boolean expression based on the input selection. The system may query the bitmap index using the Boolean expression and generate a bitmap vector. The system may output a first data subset represented by the generated bitmap vector to a graphical user interface. The bitmap index may include probabilistic entries, and the system may validate the probabilistic entries by receiving a second data stream, identifying one or more entries correlated to the probabilistic entries, determining a divergence between the identified entries and the probabilistic entries, and updating parameters of a classifier model associated with the probabilistic entries.
    Type: Grant
    Filed: May 11, 2021
    Date of Patent: April 23, 2024
    Assignee: CAPITAL ONE SERVICES, LLC
    Inventors: Swapnil Shinde, William Ibekwe, Sarah Schmidt, David Welgus
  • Patent number: 11968481
    Abstract: Embodiments of the present disclosure provide a video playback method and a terminal device. The method is applied to a first terminal device including N screens, and includes: obtaining M video files and configuration information of the M video files, where the configuration information is used for indicating a screen identifier associated with each of the M video files; and playing K video files in the M video files on K screens in the N screens according to the configuration information, where both N and K are positive integers, and M is an integer greater than or equal to 2.
    Type: Grant
    Filed: July 27, 2021
    Date of Patent: April 23, 2024
    Assignee: VIVO MOBILE COMMUNICATION CO., LTD.
    Inventor: Xiongzhou Lin
  • Patent number: 11961521
    Abstract: Disclosed herein are system, apparatus, article of manufacture, method and/or computer program product embodiments, and/or combinations and sub-combinations thereof, for providing voice control using multiple digital assistants. In some embodiments, a voice platform operates to receive a voice input from a user. The voice platform selects a digital assistant from a plurality of digital assistants based on a trigger word. The voice platform then generates an intent from the voice input using the selected digital assistant. The voice platform then transmits the intent to a media device for processing.
    Type: Grant
    Filed: March 23, 2023
    Date of Patent: April 16, 2024
    Assignee: Roku, Inc.
    Inventors: Anthony John Wood, David Stern, Gregory Mack Garner
  • Patent number: 11960452
    Abstract: Various embodiments set forth techniques for maintaining replicas of a data set. The techniques include storing, by a first node, a first replica of the data set on the first node; storing, by a second node, a second replica of the data set on the second node; and performing, by the first node and based on first metadata associated with the first replica, a first data management activity on the first replica that changes a first format of the first replica so that the first format of the first replica is different from a second format of the second replica.
    Type: Grant
    Filed: October 29, 2021
    Date of Patent: April 16, 2024
    Assignee: NUTANIX, INC.
    Inventors: Tabrez Parvez Memon, Harshit Agarwal, Amod Vilas Jaltade, Sreejith Mohanan
  • Patent number: 11960544
    Abstract: A computer implemented method processes a query. A number of processor units processes the query to identify a result set in response to receiving the query from a first client. The number of processor units stores, the result set in a shared cache assigned to a group of clients, wherein result set stored in the shared cache is accessible by the group of clients. The number of processor units returns the result set to a second client in the group of clients from the shared cache in response to receiving the query from the second client in the group of clients.
    Type: Grant
    Filed: October 28, 2021
    Date of Patent: April 16, 2024
    Assignee: International Business Machines Corporation
    Inventors: Sheng Yan Sun, Shuo Li, Xiaobo Wang, Hong Mei Zhang
  • Patent number: 11960549
    Abstract: Data is collected from a network graph, wherein the collected data is useful for training a machine learning model on a query domain. A domain-specific template corresponding to the query domain is received, the domain-specific template defining one or more classifiers to guide collection of content relevant to the query domain from the network graph. A collection starting point is analyzed based on the one or more classifiers of the domain-specific template to identify one or more relevant instances of the content. The one or more identified relevant instances of the content are added to a contextual protocol package. Each identified relevant instance of the content is analyzed based on the one or more classifiers of the domain-specific template to identify one or more additional relevant instances of the content. The one or more identified additional relevant instances of the content are added to the contextual protocol package.
    Type: Grant
    Filed: March 29, 2022
    Date of Patent: April 16, 2024
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Yu Zhang, Pankaj Sharma, Manish Shukla, Grigoriy A Orlov
  • Patent number: 11961109
    Abstract: Systems and methods for customer journey optimization in email marketing are described. The systems and methods may identify a plurality of messages for a first time period, wherein the plurality of messages are categorized according to a plurality of messages types, identify user information for a customer, wherein the user information includes user interaction data, determine a message type from the plurality of message types for the first time period based on the user information, wherein the message type is determined using a decision making model comprising a deep Q-learning neural network, select a message from the plurality of messages based on the determined message type, and transmit the message to the customer during the first time period based on the selection.
    Type: Grant
    Filed: January 14, 2020
    Date of Patent: April 16, 2024
    Assignee: ADOBE INC.
    Inventors: Lei Zhang, Jun He, Tingting Xu, Jalaj Bhandari, Wuyang Dai, Zhenyu Yan
  • Patent number: 11956315
    Abstract: A method, computer program product, and computing system for defining a communication computing system within a computing network, wherein the computing network includes a plurality of disparate platforms configured to provide information concerning various topics; and exposing an endpoint within the computing network that provides directory assistance to enable one or more specific disparate platforms, included within the plurality of disparate platforms, to communicate with the communication computing system.
    Type: Grant
    Filed: November 3, 2021
    Date of Patent: April 9, 2024
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: David Rubin, George N. Kustas, Michael T. Trombly
  • Patent number: 11954224
    Abstract: Embodiments of the present disclosure describe systems, methods, and computer program products for redacting sensitive data within a database. An example method can include receiving a masking policy for a column of a database, the masking policy identifying a category of sensitive data, examining a column of a database to identify a category of sensitive data in a first location of the column, and, in response to a data query accessing the column, the first location of the column exceeding a threshold probability of comprising sensitive data, executing a redaction operation to redact the category of sensitive data from the first location of the column to generate redacted data for a response to the data query.
    Type: Grant
    Filed: August 29, 2023
    Date of Patent: April 9, 2024
    Assignee: SNOWFLAKE INC.
    Inventors: Yimeng Li, Carl Yates Perry, Raghavendran Ramakrishnan, Frantisek Rolinek, Yunqiao Zhang
  • Patent number: 11947514
    Abstract: A method for processing non-standardized data in a relational database may include identifying, within a sequence of operations forming a query pipeline for executing a query, a first operation ingesting a non-standardized data. In response to identifying the first operation ingesting the non-standardized data, a second operation may be inserted before the first operation. The non-standardized data may be output by a third operation preceding the first operation or a source external to the query pipeline. The second operation may serialize the non-standardized data for ingestion by the first operation, for example, by generating a relational table populated by the non-standardized data. The query may be executed by performing the sequence of operations included in the query pipeline. Related systems and computer program products are also provided.
    Type: Grant
    Filed: April 29, 2022
    Date of Patent: April 2, 2024
    Assignee: SAP SE
    Inventors: Stefan Noll, Paul Willems
  • Patent number: 11947527
    Abstract: Techniques for generating an interactive visualization tool for building nested queries are disclosed. The interactive nested query visualization tool allows a user to observe, analyze, and modify query characteristics and attributes of a set of nested queries. A system displays an interactive visual depiction of a set of nested queries. Visual representations of the nested queries are positioned relative to each other based on the relationships between the nested queries. The system displays, simultaneously with the set of nested queries, editable fields for a selected query. The system modifies a functionality of a user interface based on which of the nested queries is selected.
    Type: Grant
    Filed: September 30, 2021
    Date of Patent: April 2, 2024
    Assignee: Oracle International Corporation
    Inventors: Prashant Singh, Rasika Vaidya Kaura, Henrik Michael Ammer
  • Patent number: 11947545
    Abstract: Systems and methods for configuring data stream filtering are disclosed. In one embodiment, a method for data stream processing comprises receiving an incoming dataset stream at a data stream processing environment, wherein the dataset stream comprises a data stream; configuring with a streaming data filter configuration tool, one or more filter parameters for a data filter that receives the data stream; computing with the streaming data filter configuration tool, one or more filter statistics estimates based on the filter parameters, wherein the filter statistics estimates are computed from sample elements of a representative sample of the data stream retrieved from a representative sample data store; outputting to a workstation user interface the filter statistics estimates; and configuring the data filter to apply the filter parameters to the data stream in response to an instruction from the workstation user interface.
    Type: Grant
    Filed: March 2, 2022
    Date of Patent: April 2, 2024
    Assignee: Adobe Inc.
    Inventors: Jonathan Ko, Ayush Tyagi, Fan Du, Yi Jin, Keshav Vadrevu
  • Patent number: 11949689
    Abstract: A unified authentication system for decentralized identity platforms is disclosed. In various embodiments, a request comprising one or more identity claims and a digital address is received. The digital address is used to verify, via a verification node associated with a digital address provider, the one or more identity claims. Access to a service is provided, in response to the request, based at least in part on a response from the verification node indicating the one or more identity claims have been verified. The verification node is configured to obtain consent, in real time, from a user with which the digital address is associated, prior to providing said response indicating the one or more identity claims have been verified.
    Type: Grant
    Filed: August 11, 2020
    Date of Patent: April 2, 2024
    Assignee: ADI Association
    Inventors: Ramesh Kesanupalli, Soonhyung Lee, Changsoo Kim, Mark Chen, Jason S. Burnett, Kiran Pandurang Addepalli
  • Patent number: 11947541
    Abstract: A method may include receiving a definition of a table user-defined function (TUDF) in a graph query language. The table user-defined function may be created based on the definition. For example, the creation of the table user-defined function may include checking and compiling the definition to generate executable code associated with the table user-defined function. Upon receiving a query including a relational query language statement invoking the table user-defined function, such as a structured query language select statement, the query may be executed on at least a portion of a graph data stored in a database. The executing of the query may include calling the executable code to execute the table user-defined function included in the relational query language statement. Related systems and computer program products are also provided.
    Type: Grant
    Filed: September 13, 2022
    Date of Patent: April 2, 2024
    Assignee: SAP SE
    Inventors: Gerald Franz, Romans Kasperovics, Umang Rawat, Roland Sedler
  • Patent number: 11949744
    Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for enhancing online user privacy. Methods can include receiving tag information specifying a given publisher identifier for a publisher and a given client identifier assigned to a user of the client device by the publisher. A given service identifier assigned to the user by the service apparatus is obtained. A mapping between the given service identifier to the given client identifier is created. A list of client identifiers assigned to a set of users by the publisher is received. A list of matched service identifiers corresponding to the list of client identifiers are stored. Multiple content requests are received from multiple different client devices accessing services provided by the service apparatus. Responses to the content requests are based on whether the client devices provide service identifiers that are included in the list of matched service identifiers.
    Type: Grant
    Filed: April 11, 2022
    Date of Patent: April 2, 2024
    Assignee: Google LLC
    Inventors: Yuewei Wang, Shashank Chaudhary, Onur Soysal, Michael Ortega-Binderberger
  • Patent number: 11941364
    Abstract: In an approach for routing a user analytic request to a registry of analytics models and data sources and operationalizing the user analytic request, a processor receives a user analytic request. A processor applies natural language processing to the user analytic request. A processor associates a first set of vectors and a second set of vectors from the user analytic request to one or more analytics models and data sources by utilizing a plurality of domain-specific ontologies and a plurality of knowledge bases. A processor performs a semantic search for one or more concepts in the one or more analytics models and data sources. A processor receives the one or more concepts found in the one or more analytics models and data sources. A processor selects an analytics model to process the user analytic request. A processor executes the analytics model. A processor outputs a result to the user.
    Type: Grant
    Filed: September 1, 2021
    Date of Patent: March 26, 2024
    Assignee: International Business Machines Corporation
    Inventors: Sushain Pandit, Andrew T. Penrose, Rory O Donnell, Charles Daniel Wolfson
  • Patent number: 11941028
    Abstract: Embodiments are directed to distributing records among storage partitions by maintaining a table of records. The table of records can be indexed based on an original partitioning key in the table of records. A plurality of counters can be initialized with each counter associated with a sub-range in a total range of key values for a secondary index partitioning key. Each record of the table of records can be read and a count of records in the associated sub-range can be accumulated in each counter. The number of records per partition can be determined based on the total number of records in the total range of key values and the number of available partitions and the records can be distributed to the available partitions in the storage system based on the number of records in each sub-range.
    Type: Grant
    Filed: January 10, 2019
    Date of Patent: March 26, 2024
    Assignee: Box, Inc.
    Inventor: Nawab Zada Asad Iqbal
  • Patent number: 11941350
    Abstract: Embodiments of systems and methods for the conversion of documents to reusable content types are disclosed herein. Embodiments may extract the content and metadata of the original document and identify a set of reusable resources from the content and metadata. These reusable resources can each be one of a set of content types common across a plurality of document authoring platforms. Each of the content types may be represented using a content type object associated with that content type. The reusable resources identified by the parsing of the content and metadata of the original document may thus be represented with corresponding reusable objects in a content type format common to a plurality of document authoring tools.
    Type: Grant
    Filed: February 15, 2023
    Date of Patent: March 26, 2024
    Assignee: Open Text Holdings, Inc.
    Inventors: Vaibhav Pradip Pande, Paritosh Tomar
  • Patent number: 11941013
    Abstract: Systems and methods for automated techniques that generate queryable database table ownership attribution information in real-time. In addition to generating ownership attribution information, system and methods provide a novel framework for creating bi-partite graphs and generating insightful graph data.
    Type: Grant
    Filed: July 28, 2022
    Date of Patent: March 26, 2024
    Assignee: INTUIT INC.
    Inventors: Saikiran Sri Thunuguntla, Sreenivasulu Nallapati, Vijaykumar Hiremath, Vasanth Kumar Jagadeesh
  • Patent number: 11941052
    Abstract: A method including detecting a webpage accessed by a user on a computing device via a browser. Content on the webpage is determined, and a model is applied to the content to determine a plurality of keyword sets. A network search is performed based on each of the plurality of keyword sets to generate a plurality of search results. The plurality of search results are compared to the content, and the plurality of search results are compared to each other. A factualness of the content is determined based on the comparing of the plurality of search results to the content and based on the comparing of the plurality of the search results to each other, and the user is notified via the browser of the factualness of the content.
    Type: Grant
    Filed: June 8, 2021
    Date of Patent: March 26, 2024
    Assignee: Avast Software s.r.o.
    Inventors: Dan Martinec, Yury Kasimov, Juyong Do
  • Patent number: 11941001
    Abstract: Methods and systems are provided for converting a loop (e.g., a cursor loop) to a declarative Structured Query Language (SQL) query that invokes a custom aggregate function. The loop includes a select query and a loop body that includes a program fragment that can be evaluated over a result set of the select query one row at a time. The system verifies that the loop body does not modify a persistent state of the database. A custom aggregate function that expresses the loop body is automatically constructed according to a contract. An aggregate class comprising aggregation methods of the contract are used to construct the aggregate function based on results of static analysis. The select query is automatically rewritten to form a declarative SQL query that invokes the custom aggregate function. The declarative SQL query may be executed by a database management system (DBMS) SQL server.
    Type: Grant
    Filed: September 14, 2022
    Date of Patent: March 26, 2024
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Karthik Saligrama Ramachandra, Surabhi Gupta, Sanket Jayant Purandare
  • Patent number: 11941464
    Abstract: In some embodiments, methods and systems use a client application that resides on a client device (e.g., comprising private and secure access credentials). Using the client application, a user may authorize and/or accept a plurality of configuration files. Upon acceptance, the client application is capable of connecting to any interface predefined in the plurality of configuration files (e.g., corresponding to a predetermined list of network systems). The configuration files is downloaded from a package repository or included during software installation.
    Type: Grant
    Filed: February 23, 2022
    Date of Patent: March 26, 2024
    Assignee: Coinbase, Inc.
    Inventor: Christopher Brown
  • Patent number: 11934927
    Abstract: Systems and methods for managing input and output error of a machine learning (ML) model in a database system are presented herein. A set of test queries is executed on a first version of a database system to generate first test data, wherein the first version of the system comprises a ML model to generate an output corresponding to a function of the database system. An error model is trained based on the first test data and second test data generated based on a previous version of the system. The error model determines an error associated with the ML model between the first and previous versions of the system. The first version of the system is deployed with the error model, which corrects an output or an input of the ML model until sufficient data has been produced by the error model to retrain the ML model.
    Type: Grant
    Filed: December 22, 2022
    Date of Patent: March 19, 2024
    Assignee: Snowflake Inc.
    Inventors: Orestis Kostakis, Qiming Jiang, Boxin Jiang
  • Patent number: 11934803
    Abstract: Disclosed are various approaches for workflow service application searching. In some aspects, a search query is entered through a search element of a workflow application on a client device. A request is transmitted from a workflow application to a workflow service, to search within an application based on the search query. Application content corresponding to the search query and the application is received from the workflow service. A search result is provided based on the application content and without opening the application on the client device.
    Type: Grant
    Filed: September 28, 2021
    Date of Patent: March 19, 2024
    Assignee: VMware, Inc.
    Inventors: Lin Lv, Chaoting Xuan, Xinda Yan, Qimin Yao, Yunxia Cheng, Qian Liu
  • Patent number: 11928112
    Abstract: Systems and methods are provided that use a trained process to reply to a request comprising query data defining a query and context data defining contextual factors for the query from a device. The query is answered by one or more selected APIs of a plurality of APIs that invoke respective services to prepare a response. The trained process determines an execution plan responsive to the query data and the context data and is configured using training to define execution plans comprising selected APIs where a particular API is selected for the plan if it answers at least a portion of the query and the selected APIs together prepare the response optimized for the device according to the context data. The plan is provided to an execution component to execute the plan using the selected APIs and send the response to the requesting device.
    Type: Grant
    Filed: April 23, 2021
    Date of Patent: March 12, 2024
    Assignee: The Toronto-Dominion Bank
    Inventors: Milos Dunjic, Martin Albert Lozon, David Samuel Tax, Arthur Carroll Chow, Peter Glen Nairn, Edward James Hood, John Jong-Suk Lee, Arun Victor Jagga
  • Patent number: 11928106
    Abstract: Systems and methods are described for automatically documenting queries and dynamically populating interactive graphical user interfaces with query recommendations. A computing system receives an initial query from an interactive graphical user interface and asynchronously parses the query for strings matching predetermined phrases. In response to determining that the initial query recites strings matching the predetermined phrases, the system extracts metadata and identifies a table name in the initial query, and modifies a table data in key-value data structure corresponding to the table. Subsequent queries related to the initial query cause the system to asynchronously populate the graphical user interface with query recommendations related to the initial query.
    Type: Grant
    Filed: January 31, 2022
    Date of Patent: March 12, 2024
    Assignee: INTUIT INC.
    Inventors: Sheer Dangoor, Aviv Ben Arie
  • Patent number: 11928114
    Abstract: Systems and methods for query generation based on a logical data model with one-to-one joins are described. For example, methods may include accessing a join graph representing tables in a database; receiving a first query; selecting a connected subgraph of the join graph that includes the two or more tables referenced in the first query; accessing an indication that a directed edge of the connected subgraph corresponds to a one-to-one join; modifying the connected subgraph based on the indication to obtain a modified subgraph; generating one or more leaf queries based on the modified subgraph; generating a query graph that specifies joining of results from queries based on the one or more leaf queries; invoking a transformed query on the database that is based on the query graph and the queries based on the one or more leaf queries.
    Type: Grant
    Filed: April 21, 2020
    Date of Patent: March 12, 2024
    Assignee: ThoughtSpot, Inc.
    Inventors: Naman Shah, Rakesh Kothari, Vaibhav Agarwal
  • Patent number: 11928118
    Abstract: Systems and methods for assigning scores to objects based on evaluating triggering conditions applied to datasets produced by search queries in data aggregation and analysis systems. An example method includes causing display of a user interface for generating a correlation search, the correlation search comprising a search query, a triggering condition to be applied to a dataset produced by the search query, and one or more actions to be performed when the dataset produced by the search query satisfies the triggering condition, wherein the one or more actions comprise at least modifying a score assigned to an object to which the dataset produced by the search query pertains.
    Type: Grant
    Filed: June 6, 2022
    Date of Patent: March 12, 2024
    Assignee: Splunk Inc.
    Inventors: Lucas Murphey, David Hazekamp
  • Patent number: 11929181
    Abstract: A method includes initiating an online video call between a healthcare provider device and a patient device, receiving a request to place a phone call from the healthcare provider device to the patient device from within the online video call, and initiating the phone call between the healthcare provider device and the patient device from within the online video call.
    Type: Grant
    Filed: April 5, 2022
    Date of Patent: March 12, 2024
    Assignee: Doximity, Inc.
    Inventors: Bruno Paladini Miranda, Jey Balachandran, Rob Malko, Jeremiah Konoske, Joel Davis
  • Patent number: 11928090
    Abstract: Techniques and structures to facilitate anomaly detection, including receiving performance metric data at a database system having a plurality of data point values, processing the plurality of data point values via an optimized Extreme Studentized Deviate (ESD) test to detect one or more anomalous data point values within the plurality of data point values, including storing a first set of values representing the largest values of the plurality of data point values and a second set of values representing the smallest values of the plurality of data point values, receiving a first of the plurality of data point values, determining whether the first data point value is to be included in the first set of values or the second set of values and determining that the first data point value is not an anomalous data point value upon a determination that the first data point value is not to be inserted into the first set of values or the second set of values and generating an incident alert upon a detection of one or m
    Type: Grant
    Filed: January 30, 2019
    Date of Patent: March 12, 2024
    Assignee: Salesforce, Inc.
    Inventor: Amey Ruikar
  • Patent number: 11924507
    Abstract: A process adapts user-initiated search queries. The process executes at a client device with a microphone. The process downloads audio fingerprints from a remote server for a plurality of video programs, and downloads information that correlates the audio fingerprint to the video programs. The audio fingerprints are preselected according to relevancy criteria, including stored user preferences and prior search queries by the user. The audio fingerprints and correlating information are stored locally. The process detects ambient sound using the microphone and computes one or more sample audio fingerprints from the detected ambient sound. The process matches a sample audio fingerprint to a locally stored audio fingerprint and uses the correlating information to identify a first video program corresponding to the matched sample audio fingerprint. The process then receives user input to initiate a search query. The process provides auto-complete suggestions for the search query based on the first video program.
    Type: Grant
    Filed: December 20, 2021
    Date of Patent: March 5, 2024
    Assignee: GOOGLE LLC
    Inventors: Ant Oztaskent, Yaroslav Volovich, Ingrid McAulay Trollope
  • Patent number: 11922325
    Abstract: A semantic document generation and search system is described. The semantic document extraction system generates a knowledge graph representing a collection of documents, each document being represented as a sub-graph of the knowledge graph being linked to each other by common terms of a plurality of document terms. The system extracts a first filter criterion based on the plurality of terms of the sub-graphs representing the collection of documents, receives a first search value for the first filter criterion, and identifies a subset of sub-graphs, of the knowledge graph, that include a term corresponding to the first filter criterion and having a term value corresponding to the first search value. The system prunes the knowledge graph to include only the identified subset of sub-graphs, and extracts and outputs a subset of the collection of documents corresponding to the subset of sub-graphs included in the pruned knowledge graph.
    Type: Grant
    Filed: May 27, 2022
    Date of Patent: March 5, 2024
    Assignee: LEGISLATE TECHNOLOGIES LIMITED
    Inventor: Charles Brecque
  • Patent number: 11921618
    Abstract: An information handling system may include at least one processor and a memory. The information handling system may be configured to: execute an application comprising a plurality of microservices on the at least one processor, wherein the application is configured to service external requests by executing a plurality of application programming interface (API) calls among the plurality of microservices; and for each API call: determine a span ID associated with such API call; determine a trace ID associated with a particular external request that is associated with such API call; and log the span ID and the trace ID.
    Type: Grant
    Filed: December 21, 2021
    Date of Patent: March 5, 2024
    Assignee: Dell Products L.P.
    Inventors: Qing Li, Xiaojun Wu, Haijun Zhong, Muzhar S. Khokhar
  • Patent number: 11922323
    Abstract: A method for deep reinforcement learning using a neural network model includes receiving a distribution including a plurality of related tasks. Parameters for the reinforcement learning neural network model is trained based on gradient estimation associated with the parameters using samples associated with the plurality of related tasks. Control variates are incorporated into the gradient estimation by automatic differentiation.
    Type: Grant
    Filed: April 25, 2019
    Date of Patent: March 5, 2024
    Assignee: Salesforce, Inc.
    Inventor: Hao Liu
  • Patent number: 11921692
    Abstract: In some embodiments, the present disclosure provides an exemplary method that may include steps of receiving input data from at least one external data aggregator; utilizing a trained machine learning algorithm to generate a database of known queries; receiving subsequent input data from the at least one external aggregator; automatically updating the database of known queries associated with the plurality of users; utilizing the trained machine learning algorithm to perform a cross-reference analysis to determine a presence of a data record within the database of known queries; dynamically removing the data record from the database of known queries; utilizing the trained machine learning algorithm to predict a trigger associated with the presence of the at least one data record; and instructing a computing device to initiate a verification of the presence of the at least one data record.
    Type: Grant
    Filed: September 16, 2022
    Date of Patent: March 5, 2024
    Assignee: Capital One Services, LLC
    Inventors: Shabnam Kousha, Joshua Edwards, Lin Ni Lisa Cheng, Tyler Maiman, Asher Smith-Rose
  • Patent number: 11924073
    Abstract: A method provides for receiving network traffic from a host having a host IP address and operating in a data center, and analyzing a malware tracker for IP addresses of hosts having been infected by a malware to yield an analysis. When the analysis indicates that the host IP address has been used to communicate with an external host infected by the malware to yield an indication, the method includes assigning a reputation score, based on the indication, to the host. The method can further include applying a conditional policy associated with using the host based on the reputation score. The reputation score can include a reduced reputation score from a previous reputation score for the host.
    Type: Grant
    Filed: August 16, 2021
    Date of Patent: March 5, 2024
    Assignee: Cisco Technology, Inc.
    Inventors: Sunil Kumar Gupta, Navindra Yadav, Michael Standish Watts, Ali Parandehgheibi, Shashidhar Gandham, Ashutosh Kulshreshtha, Khawar Deen
  • Patent number: 11914664
    Abstract: A computer-implemented method, computer program product, and computer system for accessing content on a web page. The method accesses a displayed web page in a web browser of a user computing device and receives a search term for content within the web page. The method accesses contextual information held locally on the user computing device and scans the web page to identify one or more portions of content of the web page relevant to the search term and the contextual information. The method provides a display on the user computing device with links to the relevant web page content.
    Type: Grant
    Filed: February 8, 2022
    Date of Patent: February 27, 2024
    Assignee: International Business Machines Corporation
    Inventors: Paul Taylor, Gary Stuart Bettesworth, Matthew John Comer, Daniel Del Piccolo
  • Patent number: 11911697
    Abstract: A virtual-environment-based object construction method is disclosed for a computer device. The method includes displaying an environment interface corresponding to a virtual environment, receiving a three-dimensional (3D) model input operation, the 3D model input operation being used for inputting a target 3D model of a target object, receiving a position input operation, the position input operation being used for determining a display position of the target object in the virtual environment, and displaying the target object at the display position according to the 3D model input operation and the position input operation, the target object being obtained by filling with voxel blocks within a contour range of the target 3D model.
    Type: Grant
    Filed: May 28, 2021
    Date of Patent: February 27, 2024
    Assignee: TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED
    Inventor: Chao Shen
  • Patent number: 11907214
    Abstract: Implementations set forth herein relate to conditionally caching responses to automated assistant queries according to certain contextual data that may be associated with each automated assistant query. Each query can be identified based on historical interactions between a user and an automated assistant, and—depending on the query, fulfillment data can be cached according to certain contextual data that influences the query response. Depending on how the contextual data changes, a cached response stored at a client device can be discarded and/or replaced with an updated cached response. For example, a query that users commonly ask prior to leaving for work can have a corresponding assistant response that depends on features of an environment of the users. This unique assistant response can be cached, before the users provide the query, to minimize latency that can occur when network or processing bandwidth is unpredictable.
    Type: Grant
    Filed: January 30, 2023
    Date of Patent: February 20, 2024
    Assignee: GOOGLE LLC
    Inventors: Benedict Liang, Bryan Christopher Horling, Lan Huo, Anarghya Mitra
  • Patent number: 11910049
    Abstract: Systems and methods are described herein for providing supplemental content to a group of users when the group of users is disinterested in content from a live content stream. When users are disinterested in a segment of the live content, the users will be provided with supplemental content to consume during the not interesting portion of the live content while other users that are viewing the live content will continue to receive the live content stream. After the segment of the live content is completed, the group of users will resume consumption of the live content stream.
    Type: Grant
    Filed: June 30, 2022
    Date of Patent: February 20, 2024
    Assignee: Rovi Guides, Inc.
    Inventors: Dylan Matthew Wondra, Jean Michelle Somlo, Michaela Schlocker Logan, Mario Miguel Sanchez, William L Thomas
  • Patent number: 11899660
    Abstract: A method for writing data to a cloud-based database for optimized cloud-based database query execution may include a table writer computer program executed by a local electronic device: (1) receiving table data comprising rows and columns, a schema for the table, and a primary-key for the table; (2) creating a footer for the table, the footer comprising the schema and the primary-key; (3) sorting the rows of the table data using the primary-key; (4) dividing the sorted columns of the table data into a plurality of datapages based on a datapage size; (5) identifying sparse indices for each datapage, wherein the sparse indices comprising a minimum value, a maximum value, a starting row index, an ending row index for each datapage; (6) writing each datapage to cloud storage; (7) inserting the sparse indices into the footer for the table data; and (8) writing the footer to cloud storage.
    Type: Grant
    Filed: July 18, 2022
    Date of Patent: February 13, 2024
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Narayana R Tummala, Marco Pistoia, Pranav Deshpande, Elvir Azanli, Joseph W. Ligman, Frank Schaffa
  • Patent number: 11899644
    Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.
    Type: Grant
    Filed: July 8, 2022
    Date of Patent: February 13, 2024
    Assignee: Oracle International Corporation
    Inventors: Zhen Hua Liu, Sriram Krishnamurthy, Beda C. Hammerschmidt, Douglas J. McMahon, Hui Joe Chang, Ying Lu, Joshua Spiegel, Srikrishnan Suresh, Vikas Arora, Geeta Arora, Sundeep Abraham, Hui Zhang, Alfonso Colunga Sosa