Presenting a selected table of data as a spreadsheet and transforming the data using a data flow graph

Patent metadata

Field	Value
Publication number	US-9727550-B2
Application number	US-201514701405-A
Country	US
Kind code	B2
Filing date	Apr 30, 2015
Priority date	Apr 30, 2015
Publication date	Aug 8, 2017
Grant date	Aug 8, 2017

Abstract

The present disclosure includes techniques pertaining to computer implemented systems and methods for transforming data. In one embodiment, data sources are specified by a user and copies of specified data are received in local storage. Data is presented to the user as a spreadsheet of columns and rows and the user manipulates the data in the spreadsheet. The user manipulations are automatically translated into data flow objects and a data flow graph, which is executed to transform the data. The modified data is presented to the user.

First claim

What is claimed is:

1. A computer-implemented method comprising:
accessing, by a computer system, a plurality of transactional data stores, wherein particular transactional data stores are selected by a user;
establishing, by the computer system, data connections to selected transactional data stores;
selecting, by the user, one or more particular tables of data in the plurality of transactional data stores;
extracting, by a computer system, the one or more selected tables of data from the plurality of transactional data stores and storing the data from the one or more particular tables in a local data store;
presenting the data from the one or more selected tables as one or more spreadsheets to the user, the spreadsheets comprising a plurality of columns and rows;
receiving a plurality of spreadsheet manipulations, by the user, to transform the data in at least one spreadsheet;
automatically, by the computer system, based on to the spreadsheet manipulations, generating a plurality of data flow objects, the data flow objects being automatically configured to produce a data flow graph to cause data from the transactional data stores to be transformed according to the spreadsheet manipulations;
automatically transforming, by the computer system, after each spreadsheet manipulation by the user, the data from the one or more selected tables according to the data flow graph to produce modified data; and
presenting the modified data to the user in the spreadsheet.

2. The method of claim 1 further comprising:
generating, in response to the plurality of spreadsheet manipulations, a plurality of corresponding actions, wherein each action corresponds to a manipulation of spreadsheet data by the user;
automatically generating, based on each action, one or more data flow objects corresponding to each particular action; and
storing each action in an action history data structure.

3. The method of claim 2 further comprising storing an indicator, associated with each action, specifying whether the action is active or inactive, wherein the user selectively activates or deactivates the action by changing said indicator through a user interface.

4. The method of claim 2 further comprising generating a data record in a statistics data structure each time an action is generated, wherein the data record comprises a first field linking the record to the action history data structure, a second field linking the record to a worksheet definition data structure, and a third field linking the record to a project information data structure to generate usage statistics.

5. The method of claim 1 further comprising storing information about the spreadsheet in a worksheet definition data structure comprising information about columns, a link to the data, and a link to the modified data.

6. The method of claim 1 wherein particular transactional data stores are selected by a user across a plurality of computer systems through a plurality of networks.

7. The method of claim 6 wherein a user selects tables in the transactional data stores across the plurality of computer systems through the plurality of networks using a browser configured to identify data tables in remote transactional data stores, and wherein the browser prompts the user to specify particular tables and particular columns of data within the tables to be extracted.

8. The method of claim 1 wherein the computer system comprises a software system for performing said method steps.

9. A computer system comprising:
one or more processors; and
a non-transitory computer readable medium having stored thereon one or more programs, which when executed by the one or more processors, causes the one or more processors to:
access a plurality of transactional data stores, wherein particular transactional data stores are selected by a user;
establish data connections to selected transactional data stores;
select, by the user, one or more particular tables of data in the plurality of transactional data stores;
extract the one or more selected tables of data from the plurality of transactional data stores and storing the data from the one or more particular tables in a local data store;
present the data from the one or more selected tables as one or more spreadsheets to the user, the spreadsheets comprising a plurality of columns and rows;
receive a plurality of spreadsheet manipulations, by the user, to transform the data in at least one spreadsheet;
automatically, based on to the spreadsheet manipulations, generate a plurality of data flow objects, the data flow objects being automatically configured to produce a data flow graph to cause data from the transactional data stores to be transformed according to the spreadsheet manipulations;
automatically transform after each spreadsheet manipulation by the user, the data from the one or more selected tables according to the data flow graph to produce modified data; and
present the modified data to the user in the spreadsheet.

10. The computer system of claim 9 wherein the one or more programs further cause the one or more processors to:
generate, in response to the plurality of spreadsheet manipulations, a plurality of corresponding actions, wherein each action corresponds to a manipulation of spreadsheet data by the user;
automatically generate, based on each action, one or more data flow objects corresponding to each particular action; and
store each action in an action history data structure.

11. The computer system of claim 10 wherein the one or more programs further cause the one or more processors to:
store an indicator, associated with each action, specifying whether the action is active or inactive, wherein the user selectively activates or deactivates the action by changing said indicator through a user interface.

12. The computer system of claim 9 wherein the one or more programs further cause the one or more processors to:
generate a data record in a statistics data structure each time an action is generated, wherein the data record comprises a first field linking the record to the action history data structure, a second field linking the record to a worksheet definition data structure, and a third field linking the record to a project information data structure to generate usage statistics.

13. The computer system of claim 9 wherein the one or more programs further cause the one or more processors to:
storing information about the spreadsheet in a worksheet definition data structure comprising information about columns, a link to the data, and a link to the modified data.

14. The computer system of claim 9 wherein particular transactional data stores are selected by a user across a plurality of computer systems through a plurality of networks.

15. A non-transitory computer readable storage medium storing one or more programs, the one or more programs comprising instructions for:
accessing a plurality of transactional data stores, wherein particular transactional data stores are selected by a user;
establishing data connections to selected transactional data stores;
selecting, by the user, one or more particular tables of data in the plurality of transactional data stores;
extracting the one or more selected tables of data from the plurality of transactional data stores and storing the data from the one or more particular tables in a local data store;
presenting the data from the one or more selected tables as one or more spreadsheets to the user, the spreadsheets comprising a plurality of columns and rows;
receiving a plurality of spreadsheet manipulations, by the user, to transform the

Assignees

• Sap Se

Inventors

• He Min
• Saito Ricardo
• SEAH Vei Ming
• STORTZ Barbara
• Culp Daniel

Classifications

• G06T11/26 Primary

  Drawing of charts or graphs · CPC title

• G06F16/2465

  Query processing support for facilitating data mining operations in structured databases · CPC title

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title

• G06F17/30539

  Physics · mapped topic