US 10,891,433 B2
Data transformation for time period associated data
Wendy Yang, Danville, CA (US); Dylan Owen, Oakland, CA (US); Kevin Chan, Oakland, CA (US); Jonathan David Ruggiero, Danville, CA (US); Daniel G. Rabe, Lafayette, CO (US); and Sayan Chakraborty, Niwot, CO (US)
Assigned to Workday, Inc., Pleasanton, CA (US)
Filed by Workday, Inc., Pleasanton, CA (US)
Filed on May 22, 2017, as Appl. No. 15/601,788.
Prior Publication US 2018/0336174 A1, Nov. 22, 2018
Int. Cl. G06F 16/25 (2019.01); G06F 40/18 (2020.01); G06Q 40/00 (2012.01); G06Q 10/00 (2012.01)
CPC G06F 40/18 (2020.01) [G06F 16/258 (2019.01); G06Q 10/00 (2013.01); G06Q 40/12 (2013.12)] 21 Claims
OG exemplary drawing
 
1. A system for data transformation, comprising:
a database;
a spreadsheet storage of a spreadsheet for planning, wherein the database is synchronized with the spreadsheet;
an interface configured to:
receive, from the database, a database datum associated with a large time period;
receive, from the database, an indication that data associated with the database datum has changed to updated data; and
a processor configured to:
generate a plurality of spreadsheet data based at least in part on the database datum, wherein each spreadsheet datum is associated with one of a set of small time periods, wherein each spreadsheet datum is an allocated portion of an aggregate of the database datum associated with the set of small time periods, wherein the plurality of spreadsheet data is stored in the spreadsheet storage, and wherein the spreadsheet storage is separate from the database;
provide the plurality of spreadsheet data for display in the spreadsheet;
determine whether to update the displayed spreadsheet in response to the indication that the data associated with the database datum has changed; and
in response to determining not to update the displayed spreadsheet, create a new spreadsheet, wherein creating the new spreadsheet comprises:
aggregating an updated database datum associated with the set of small time periods to obtain an updated aggregate, wherein the updated database datum comprises the updated data; and
updating a spreadsheet datum associated with a small time period of the set of small time periods based at least in part on the updated aggregate to obtain an updated spreadsheet datum.