摘要 |
A system for applying spreadsheet and database operations to one or more original worksheets resulting in a new worksheet representative of the spreadsheet and database operations. The system includes a relational algebra engine, a re-mapping engine, and a computation engine. The relational algebra engine performs relational algebra operations contained in the original worksheet(s) and creates a temporary results table. The relational algebra engine also creates a mapping table correlating the original worksheet cells with the temporary results table. The re-mapping engine adjusts spreadsheet operations that refer to original worksheet cells to refer to the temporary results table. The re-mapping engine then creates a re-mapped worksheet containing the adjusted spreadsheet operations and the results of the relational algebra operations. Finally, the computation engine reads the re-mapped worksheet and recalculates spreadsheet values that have been adjusted to create the new worksheet. |