Query Generation Based On A Logical Data Model With One-to-One Joins

    公开(公告)号:US20240211479A1

    公开(公告)日:2024-06-27

    申请号:US18599389

    申请日:2024-03-08

    申请人: ThoughtSpot, Inc.

    摘要: 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.

    CACHING SCHEME FOR REAL-TIME DELIVERY OF OPTIMAL VEHICLE DATA

    公开(公告)号:US20240202759A1

    公开(公告)日:2024-06-20

    申请号:US18430186

    申请日:2024-02-01

    申请人: RunMyLease Inc

    摘要: In a caching scheme for real-time delivery of vehicle data, an application host receives a request for the vehicle data for a specific vehicle to be displayed on a website, where the vehicle data includes optimal price data for the specific vehicleThe application host retrieves a response to the request from an application cache or a database cache, if the response exists there. If not, then the application host calculates the optimal price data by determining whether meta data for the specific vehicle matches parameter values in one or more pricing rules. If so, the application host identifies the pricing rule that has the highest number of parameter values. The optimal price data for the specific vehicle is then calculated by applying the formula in this pricing rule and returned in the response.

    SEARCH IN A DATA MARKETPLACE
    67.
    发明公开

    公开(公告)号:US20240202203A1

    公开(公告)日:2024-06-20

    申请号:US18085452

    申请日:2022-12-20

    申请人: Snowflake Inc.

    摘要: A search engine of a data exchange may receive from a user, a query comprising a set of search terms, and retrieve a set of data listings based on the search terms of the query. A data ranking module of the search engine may analyze each of the set of retrieved data listings to determine, for each of the set of retrieved data listings, a set of listing-specific signals and a set of external signals. Listing-specific signals may correspond to attributes or characteristics of data/content within a data listing, while external signals may correspond to a measure of activity in the data exchange that involves a data listing. Based on the listing-specific signals and the external signals analyzed for each retrieved data listing, the set of retrieved data listings may be ordered and presented to the user.

    Trimming blackhole clusters
    70.
    发明授权

    公开(公告)号:US12013855B2

    公开(公告)日:2024-06-18

    申请号:US18313753

    申请日:2023-05-08

    申请人: AMPERITY, INC.

    摘要: Disclosed are techniques for trimming large clusters of related records. In one embodiment, a method is disclosed comprising receiving a set of clusters, each cluster in the clusters including a plurality of records. The method extracts an oversized cluster in the set of clusters and performs a breadth-first search (BFS) on the oversized cluster to generate a list of visited records. The method terminates the BFS upon determining that the size of the list of visited records exceeds a maximum size and generates a new cluster from the list of visited records and adding the new cluster to the set of clusters. By recursively performing BFS traverse over the oversized cluster and extracting smaller new clusters from it, the oversized cluster is eventually partitioned into a set of sub-clusters with the size smaller than the predefined threshold.