-
公开(公告)号：US11455079B2
公开(公告)日：2022-09-27
申请号：US16180777
申请日：2018-11-05
IPC分类号： G06F3/0483 , G06F3/0485 , G06F9/451 , G06F16/245 , G06F40/114 , G06F40/18 , G06F3/0482
摘要： Nested pagination for presenting a data set in a graphical user interface (GUI) including receiving a request for the data set to present in a GUI, wherein the request comprises a group name identifying a nested group of rows in the data set; selecting an anchor point from the data set using the group name, wherein the anchor point is within the group of rows identified by the group name; selecting, using the anchor point, a subset of the data set for presentation in the GUI, wherein the subset of the data set comprises the anchor point; and presenting the subset of the data set in the GUI.
-
公开(公告)号：US11281687B2
公开(公告)日：2022-03-22
申请号：US16745729
申请日：2020-01-17
发明人： Max H. Seiden , Jason D. Frantz , Donald Huang
IPC分类号： G06F17/00 , G06F16/25 , G06F16/2452
摘要： Compiling a database query including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface comprising a worksheet, wherein the worksheet is a presentation of a data set from a data warehouse; converting, by the query compiler, the state specification into a worksheet algebra including determining a first order of operations for elements within the state specification, wherein the worksheet algebra comprises the first order of operations over a nested table; converting, by the query compiler, the worksheet algebra into a database query; and sending the database query to the data warehouse.
-
公开(公告)号：US11163770B2
公开(公告)日：2021-11-02
申请号：US16822402
申请日：2020-03-18
IPC分类号： G06F16/00 , G06F16/2453 , G06F16/22 , G06F16/23 , G06F16/21 , G06F40/177
摘要： Enabling editable tables on a cloud-based data warehouse including receiving, by a query manager, a client-provided table; receiving, by the query manager from a query manager client, a request to create a referencing worksheet using, as data sources, the client-provided table and a database table on a cloud-based data warehouse; storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse, wherein the schema storage location is a storage location on the cloud-based data warehouse to which the query manager has read and write access, and wherein the database table is external to the schema storage location; generating, by the query manager, a database query to create the referencing worksheet, wherein the database query targets the client-provided table in the schema storage location and the database table; and issuing, by the query manager, the database query to the cloud-based data warehouse.
-
公开(公告)号：US12118005B2
公开(公告)日：2024-10-15
申请号：US17682866
申请日：2022-02-28
发明人： Jason D. Frantz , Max H. Seiden , James L. Gale , Kenneth Truong
IPC分类号： G06F15/16 , G06F16/23 , G06F16/2455
CPC分类号： G06F16/2456 , G06F16/2365
摘要： Maintaining cardinality of rows while joining worksheets from a database including receiving a request to join, to a first worksheet, a second worksheet from the database; for each row in the first worksheet: generating a join row for data from the second worksheet on the database; in response to determining that there is at least one matching row in the second worksheet on the database: compare a maximum value and a minimum value for each column in each row of the at least one matching row; if the maximum value and the minimum value match, store a matching value in a corresponding column of the join row; and if the maximum value and the minimum value do not match, store a multiple value indication in the corresponding column of the join row; and presenting the join row adjacent to a corresponding row in the first worksheet.
-
公开(公告)号：US11782903B2
公开(公告)日：2023-10-10
申请号：US17080374
申请日：2020-10-26
CPC分类号： G06F16/2379 , G06F16/2282
摘要： Database writeback using an intermediary statement generator including receiving, by a statement generator, a table update request to update a table within a database on a cloud-based data warehouse, wherein the table update request comprises an update value and a selection of a row and a column from the table; verifying, by the statement generator, that the selection is updatable; generating, by the statement generator based on the selection and in response to the verification, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value; and sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse, wherein the table of the database is updated in response to receiving the update database statement.
-
公开(公告)号：US10810192B2
公开(公告)日：2020-10-20
申请号：US16133888
申请日：2018-09-18
IPC分类号： G06F16/242 , G06F16/22 , G06F16/2455 , G06F16/248 , G06F40/18
摘要： Generating a database query to dynamically aggregate rows of a data set including determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set; receiving a calculation for a third column within the spreadsheet structure; determining that the third column is on a same hierarchical level as the first column; and in response to determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
-
公开(公告)号：US11989177B1
公开(公告)日：2024-05-21
申请号：US18186066
申请日：2023-03-17
发明人： Max H. Seiden , Deepanshu Utkarsh
IPC分类号： G06F16/242 , G06F16/245 , G06F16/2453
CPC分类号： G06F16/2428 , G06F16/2423 , G06F16/2454
摘要： 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.
-
公开(公告)号：US11886432B2
公开(公告)日：2024-01-30
申请号：US16921464
申请日：2020-07-06
IPC分类号： G06F16/00 , G06F16/2453 , G06F16/28 , G06F21/62 , G06F16/2455 , G06F21/31 , G06F16/248
CPC分类号： G06F16/24542 , G06F16/248 , G06F16/24553 , G06F16/283 , G06F21/31 , G06F21/6218
摘要： Managing database queries using a deconstructed cloud database including receiving, by a communications manager of the deconstructed cloud database, a state specification from a client computing system; converting, by a query optimizer of the deconstructed cloud database, the state specification into a query plan comprising a database query targeting an offloaded execution engine; retrieving, by a dispatcher of the deconstructed cloud database, query results from the offloaded execution engine using the database query; and presenting, by the communications manager, the query results to the client computing system.
-
公开(公告)号：US11860873B2
公开(公告)日：2024-01-02
申请号：US17081669
申请日：2020-10-27
发明人： James L. Gale , Kenneth Truong , Max H. Seiden , Stipo Josipovic
IPC分类号： G06F17/00 , G06F16/2455 , G06F16/25 , G06F16/248
CPC分类号： G06F16/24552 , G06F16/248 , G06F16/254
摘要： Dashboard loading using a filtering query from a cloud-based data warehouse cache, including determining that a filtered result for a first filtering query is stored in a cache of a cloud-based data warehouse; sending, in response to the filtered result being stored in the cache, to the cloud-based data warehouse, a request for the filtered result from the cache; and providing, based on the filtered result for the first filtering query, one or more dashboard visualizations.
-
公开(公告)号：US11281672B2
公开(公告)日：2022-03-22
申请号：US16822241
申请日：2020-03-18
发明人： Max H. Seiden , Jason D. Frantz
IPC分类号： G06F16/00 , G06F16/2455 , G06F16/908 , G06F16/903
摘要： Join key propagation including receiving a request to generate a referencing worksheet linked from a data source worksheet, wherein the data source worksheet is a presentation of a data set organized in columns from two data source tables joined using a join key, and wherein the referencing worksheet presents at least a subset of the data set presented by the data source worksheet; retrieving data source worksheet metadata and the join key using a reference to the data source worksheet metadata in the request; determining an additional column from the two data source tables to add to the referencing worksheet, wherein the additional column is excluded from the data source worksheet; and creating, using the data source worksheet metadata and the join key, the referencing worksheet presenting the columns from the two data source tables with the additional column.
-
-
-
-
-
-
-
-
-
搜索结果
23 条记录 (耗时 0.015 秒)
