RECOMMENDING JOIN OPERATIONS OF RELATIONAL DATA AMONG TABLES BASED ON OPTIMIZATION MODEL

    公开(公告)号:US20240320223A1

    公开(公告)日:2024-09-26

    申请号:US18123473

    申请日:2023-03-20

    摘要: A computer-implemented method, system and computer program product for recommending join operations of relational data among different tables. Relationships between one or more pairs of columns of relational data for one or more pairs of tables are identified by determining the semantic similarity between each pair of columns of relational data. The data content join converge for each of the identified relationships in connection with joining the tables involved in such identified relationships is determined. Furthermore, a join strength (indication of the degree that the relational data in the paired columns match) is calculated for each of the identified relationships based on the semantic similarity and the data content join coverage for such identified relationships. Based on the calculated join strength as well as other factors, a combination optimization algorithm identifies the best join combinations of relational data of the tables among a set of tables.

    Systems and methods for geospatial correlation

    公开(公告)号:US12038895B1

    公开(公告)日:2024-07-16

    申请号:US18476990

    申请日:2023-09-28

    申请人: Black Cape Inc.

    摘要: Disclosed are methods, systems and non-transitory computer readable memory for geospatial correlation. For instance, a method may include: obtaining a plurality of records, wherein each record has a key value that points to the record in a database, and each of the plurality of records includes at least data for an observation of an entity; and generating an index based on the plurality of records. The generating the index may include: determining a plurality of observations based on the plurality of records, an observation including a device identifier and time-and-geolocation data for a record of the plurality of records; encoding the plurality of observations into a plurality of spacetime hashes; and forming a search data structure of the index for a plurality of key values based on the plurality of spacetime hashes, wherein the search data structure groups subsets of the plurality of spacetime hashes.

    Compiling optimized database statements

    公开(公告)号:US11989177B1

    公开(公告)日:2024-05-21

    申请号:US18186066

    申请日:2023-03-17

    摘要: Compiling optimized database statements including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface in response to a user manipulating the graphical user interface on the client computing system, wherein the state specification is in a standard file format and describes modifications to a plurality of visual elements of the graphical user interface; compiling, by the query compiler, a database statement from the state specification such that a limit clause within the database statement is processed by a database before at least one join clause; and sending, by the query compiler, the optimized database statement to a database on a cloud-based data warehouse.

    DATA AGGREGATOR GRAPHICAL USER INTERFACE
    5.
    发明公开

    公开(公告)号:US20240126749A1

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

    申请号:US18495325

    申请日:2023-10-26

    摘要: Systems and methods for generating a data aggregator interactive graphical user interface. An interactive graphical user interface (GUI) includes a selectable symbol region, a query region and a data results region. The selectable symbol region displays predefined symbols. The query region displays user input fields for generating queries. The system receives user input associated with the user input fields of the query region to form a filter set. The data results region is automatically updated responsive to the user input, to display one or more data values from among one or more databases associated with the filter set. The system receives a subscription request to save the filter set as a user-customized query. A custom symbol is created responsive to the subscription request that is associated with the filter set. The the selectable symbol region is updated to display the custom symbol together with the predefined symbols.

    Database auto-documentation systems and methods

    公开(公告)号:US11928106B2

    公开(公告)日:2024-03-12

    申请号:US17649459

    申请日:2022-01-31

    申请人: INTUIT INC.

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

    Systems and methods using generic database search models

    公开(公告)号:US11928096B2

    公开(公告)日:2024-03-12

    申请号:US17124187

    申请日:2020-12-16

    申请人: SAP SE

    发明人: Thomas Mueller

    摘要: A computer system includes one or more database search models configured to search data contained in a plurality of database tables. The one or more database search models can include a plurality of structural containers and one or more search enabling containers. The plurality of structural containers can represent objects having a structural relationship and contain property data of the objects. The property data of the objects can be obtained from the plurality of database tables. The plurality of structural containers can be shared by the one or more database search models. The one or more search enabling containers can correspond to the one or more database search models and specify a scope for searching data and a format for presenting search results.