Web-based spreadsheet interaction with large data set

Patent metadata

Field	Value
Publication number	US-9256589-B2
Application number	US-201313756198-A
Country	US
Kind code	B2
Filing date	Jan 31, 2013
Priority date	Apr 21, 2009
Publication date	Feb 9, 2016
Grant date	Feb 9, 2016

Abstract

A computer-implemented method for presenting data is disclosed. The method includes receiving at a data server sub-system, from a browser on a remote client computing system, a request for data stored in a central data store; retrieving the requested data from the central data store and providing data corresponding to the requested data to a spreadsheet presentation sub-system that is in communication with the data server sub-system and with the browser on the remote client computing system; and providing a document key to the browser on the remote client computing system so that the browser can request from the presentation sub-system a spreadsheet document that displays the data corresponding to the requested data.

First claim

What is claimed is:

1. A method comprising:
providing, by a data server system to a spreadsheet server system, access to data stored in a data store;
populating, at the spreadsheet server system, a spreadsheet document based on the data;
providing, by the data server system to a browser on a client computing system, a time stamp associated with a time of populating the spreadsheet document and a document key identifying the spreadsheet document;
receiving, at the spreadsheet server system from the browser, changes to the spreadsheet document;
obtaining, by the data server system from the spreadsheet server system the changes based on comparing the time stamp with a second time stamp corresponding to an initiation of a save command; and
mapping changes in cells on the spreadsheet document to data structures in the central data store, the changes made in the spreadsheet document by a user of the client computing system; and
updating information in the central data store to reflect the changes.

2. The method of claim 1 , further comprising:
converting the changes into a format for storing in the data store.

3. The method of claim 1 , further comprising:
identifying errors in the data, wherein the spreadsheet server system communicates the errors to the browser.

4. The method of claim 1 , wherein the spreadsheet server system generates the time stamp.

5. The method of claim 1 , wherein the step of obtaining the changes is in response to requesting, by the data server system from the spreadsheet server, the changes based on the time stamp.

6. The method of claim 1 , wherein the data server system communicates with the browser via a web page, and wherein the spreadsheet server communicates with the browser via a frame within the webpage.

7. The method of claim 1 , wherein the document key identifying the spreadsheet document is served from a first domain that is different from a second domain that serves the spreadsheet document.

8. The method of claim 1 , wherein the data server system performs validation of the data.

9. The method of claim 1 , wherein the data server system does not maintain state information for the spreadsheet document.

10. A system comprising:
a data server system configured to communicate with a client computing system and to provide one or more web pages to the client computing system;
a spreadsheet server system, in communication with the data server system, configured to receive data from the data server system, to populate a spreadsheet document based on the data for presentation of the spreadsheet document on the one or more web pages provided to the client computing system, and to receive changes to the spreadsheet document from the client computing system; and
a data store, in communication with the data server system, configured to store the data;
wherein the data server system is further configured to provide access to the data stored in the data store, to provide a time stamp associated with a time of populating the spreadsheet document and a document key identifying the spreadsheet document, to map the changes in cells on the spreadsheet document to data structures in the central data store, the changes made in the spreadsheet document by a user of the client computing system;
wherein the spreadsheet server is further configured to compare the time stamp with a second time stamp corresponding to an initiation of a save command; and
updating information in the central data store to reflect the changes.

11. The system of claim 10 wherein the data server is further configured to convert the changes into a format for storing in the data store.

12. The system of claim 10 , wherein the spreadsheet server system is further configured to communicate identified errors in the data to the browser.

13. The system of claim 10 , wherein the spreadsheet server system is further configured to generate the time stamp.

14. The system of claim 10 , wherein the data server is further configured to obtain the changes in response to the data server system requesting from the spreadsheet server, the changes based on the time stamp.

15. The system of claim 10 , wherein the data server system is further configured to communicate with the browser via a web page, and wherein the spreadsheet server is further configured to communicate with the browser via a frame within the webpage.

16. The system of claim 10 , wherein the data server system is further configured to perform validation of the data.

17. The system of claim 10 , wherein the data server system is further configured to not maintain state information for the spreadsheet document.

Assignees

• Google Inc

Inventors

• Chitilian Varouj A
• Lloyd Zachary
• Harm Michael W

Classifications

• G06F40/18 Primary

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

• H04L69/329

  in the application layer [OSI layer 7] · CPC title

• H04L29/08072

  Electricity · mapped topic

• G06F17/246 Primary

  Physics · mapped topic