-
公开(公告)号:US11086894B1
公开(公告)日:2021-08-10
申请号:US16452394
申请日:2019-06-25
Applicant: Amazon Technologies, Inc.
Inventor: Anupam Srivastava , Syed Kamran Masood , Adam Bosworth , Ian Eslick , Joseph Rozenfeld , Rajesh Goli
IPC: G06F17/00 , G06F16/248 , G06F16/904 , G06F16/22
Abstract: In response to a determination that a first logical table is to be created in a data sheet, a respective row identifier is generated and stored for individual rows of the first logical table. To indicate a relationship between a particular cell of another logical table and a particular row of the first logical table, the row identifier of the particular row is stored. After a modification of a value stored in the particular row, the row identifier is used to determine an updated value to be displayed in the particular cell of the other logical table.
-
公开(公告)号:US11816100B2
公开(公告)日:2023-11-14
申请号:US17542244
申请日:2021-12-03
Applicant: Amazon Technologies, Inc.
Inventor: Anupam Srivastava , Syed Kamran Masood , Adam Bosworth , Ian Eslick , Mohammad Asif Ali Khan , Joseph Rozenfeld
CPC classification number: G06F16/2393 , G06F16/2282 , G06F16/24
Abstract: A descriptor of a dynamically materialized view is stored. The descriptor includes a query to select a subset of cells from a data sheet, and a result of executing the query. In response to an update directed to the data sheet, the result stored in the descriptor is modified based on re-executing the query, and a notification is transmitted to an execution platform at which an application whose output depends on the dynamically materialized view runs.
-
公开(公告)号:US11755606B2
公开(公告)日:2023-09-12
申请号:US17396315
申请日:2021-08-06
Applicant: Amazon Technologies, Inc.
Inventor: Anupam Srivastava , Syed Kamran Masood , Adam Bosworth , Ian Eslick , Joseph Rozenfeld , Rajesh Goli
IPC: G06F17/00 , G06F16/248 , G06F16/904 , G06F16/22
CPC classification number: G06F16/248 , G06F16/2282 , G06F16/904
Abstract: In response to a determination that a first logical table is to be created in a data sheet, a respective row identifier is generated and stored for individual rows of the first logical table. To indicate a relationship between a particular cell of another logical table and a particular row of the first logical table, the row identifier of the particular row is stored. After a modification of a value stored in the particular row, the row identifier is used to determine an updated value to be displayed in the particular cell of the other logical table.
-
公开(公告)号:US20220092059A1
公开(公告)日:2022-03-24
申请号:US17542244
申请日:2021-12-03
Applicant: Amazon Technologies, Inc.
Inventor: Anupam Srivastava , Syed Kamran Masood , Adam Bosworth , Ian Eslick , Mohammad Asif Ali Khan , Joseph Rozenfeld
Abstract: A descriptor of a dynamically materialized view is stored. The descriptor includes a query to select a subset of cells from a data sheet, and a result of executing the query. In response to an update directed to the data sheet, the result stored in the descriptor is modified based on re-executing the query, and a notification is transmitted to an execution platform at which an application whose output depends on the dynamically materialized view runs.
-
公开(公告)号:US11714796B1
公开(公告)日:2023-08-01
申请号:US17090755
申请日:2020-11-05
Applicant: Amazon Technologies, Inc.
Inventor: Anupam Srivastava , Adrian Kwok , Venkata Rao Pedapati , Helbert Fonseca Maich
IPC: G06F16/22 , G06F16/2455 , G06F16/901 , G06F16/25 , G06F40/18
CPC classification number: G06F16/2282 , G06F16/24565 , G06F16/252 , G06F16/9024 , G06F40/18
Abstract: Systems and methods are described to generate reverse dependency lists for cells in a workbook data store. In one aspect, a system populates, for a first cell in the data store, a reverse dependency list identifying a second cell, wherein the second cell comprises a second cell value that depends, at least in part, on a first cell value of the first cell. The system then detects a change to cell information for the first cell, and based on the detected change to the cell information: marks the second cell for recalculation based on the second cell being identified in the reverse dependency list for the first cell and the detected change to the cell information. For each marked cell, the system performs recalculation on the marked cell, performs recalculation recursively on any cells on which the marked cell depends, and stores recalculated cell values in a recalculated cache.
-
公开(公告)号:US11500839B1
公开(公告)日:2022-11-15
申请号:US17039968
申请日:2020-09-30
Applicant: Amazon Technologies, Inc.
Inventor: Venkata Rao Pedapati , Adrian Kwok , Anupam Srivastava , Wilfred Xavier Zhi Zhiang Wee , Helbert Fonseca Maich
IPC: G06F16/22 , G06F40/18 , G06F16/2455 , G06F16/93
Abstract: Aspects are described to generate indexing on columns including links to other columns in a different table. One aspect describes a computer-implemented method comprising identifying, for a workbook comprising a plurality of cells and tables stored in a spreadsheet structure, a query comprising a formula, parsing the formula to identify, as one operand, a heterogeneous column of links in a first table of the plurality of tables to a column in a second table of the plurality of tables and at least one operator, automatically generating a virtual column for the heterogeneous column, the virtual column being inaccessible to a user, storing the generated virtual column, evaluating the function of the virtual column for each row of the first table, generating an inaccessible virtual index for the virtual column, storing the virtual index, and evaluating the formula based on the virtual index to generate a result.
-
公开(公告)号:US11194793B1
公开(公告)日:2021-12-07
申请号:US16452401
申请日:2019-06-25
Applicant: Amazon Technologies, Inc.
Inventor: Anupam Srivastava , Syed Kamran Masood , Adam Bosworth , Ian Eslick , Mohammad Asif Ali Khan , Joseph Rozenfeld
Abstract: A descriptor of a dynamically materialized view is stored. The descriptor includes a query to select a subset of cells from a data sheet, and a result of executing the query. In response to an update directed to the data sheet, the result stored in the descriptor is modified based on re-executing the query, and a notification is transmitted to an execution platform at which an application whose output depends on the dynamically materialized view runs.
-
公开(公告)号:US20210365446A1
公开(公告)日:2021-11-25
申请号:US17396315
申请日:2021-08-06
Applicant: Amazon Technologies, Inc.
Inventor: Anupam Srivastava , Syed Kamran Masood , Adam Bosworth , Ian Eslick , Joseph Rozenfeld , Rajesh Goli
IPC: G06F16/248 , G06F16/904 , G06F16/22
Abstract: In response to a determination that a first logical table is to be created in a data sheet, a respective row identifier is generated and stored for individual rows of the first logical table. To indicate a relationship between a particular cell of another logical table and a particular row of the first logical table, the row identifier of the particular row is stored. After a modification of a value stored in the particular row, the row identifier is used to determine an updated value to be displayed in the particular cell of the other logical table.
-
-
-
-
-
-
-