FACILITATING SPREADSHEET AND DATABASE VIEWS ON COMMON DATA STORE

• US 20100211862A1
• Filed: 02/18/2009
• Published: 08/19/2010
• Est. Priority Date: 02/18/2009
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Miller, Andrew, Greenberg, Steven, Covington, Clinton, Lindhorst, Gregory, Parish, Dan, Megiddo, Eran
• Application Number:
  US12/388,353
• Publication Number:
  US 20100211862A1
• Time in Patent Office: Days
• US Class Current: 715/212
• CPC Class Codes: G06F 16/957 Browsing optimisation, e.g. caching or content distillation
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Users of spreadsheet/database web services are provided with a seamless experience of being able to interact with a single set of data both as a spreadsheet and as a database. Tables or datasheets in spreadsheet services and database services are linked with a read/write connection to a common data store. In addition to enabling the users to view the data in a companion user interface and edit employing the companion user interface'"'"'s elements and operations, changes made in the data are reflected in both services through the common data store.

Claims

1. A method to be executed at least in part in a computing device for rendering spreadsheet data through database user interface and database data through spreadsheet user interface, the method comprising:

receiving a request for rendering database data through a spreadsheet user interface at a web service;

retrieving data from a common data store, wherein spreadsheet tables and database datasheets are linked with a read/write connection to the common data store;

enabling rendering of the database data through the spreadsheet user interface at a requesting user'"'"'s client application through a web front end service; and

storing edited data at the common data store.

2. The method of claim 1, wherein rendering the database data through the spreadsheet user interface includes enabling the user to view and edit the database data through spreadsheet user interface elements at the user'"'"'s client application.

3. The method of claim 1, wherein the database data is rendered through the spreadsheet user interface without requiring an installation of a program at the user'"'"'s client computing device.

4. The method of claim 1, wherein the user is enabled to edit the database data through the spreadsheet user interface while maintaining an integrity of the database data.

5. The method of claim 1, further comprising:

enabling rendering of the spreadsheet data through a database user interface at a requesting user'"'"'s client application through another web front end service.

6. The method of claim 5, further comprising:

enabling editing of the spreadsheet data through the database user interface at the requesting user'"'"'s client application through the other web front end service.

7. The method of claim 1, wherein respective web front end services enable the user to navigate seamlessly between a spreadsheet user interface and a database user interface to view and to edit data stored in the common data store.

8. The method of claim 1, wherein the web service is arranged to auto-generate and syndicate forms from retrieved data in table format.

9. A system for providing spreadsheet and database functionality service, the system comprising:

a first web front end (WFE) server configured to;

in response to receiving a request from a browsing application for rendering database data through a spreadsheet user interface, forward the request to a backend server managing the database data at a common data store;

receive requested database data from the backend server; and

provide the database data to the browsing application for rendering through the spreadsheet user interface;

the backend server configured to;

retrieve the database data from the common data store through a query processor; and

forward the requested database data to the first WFE server.

10. The system of claim 9, wherein the backend server is further configured to cache the retrieved database data.

11. The system of claim 9, wherein the first WFE server is further configured to enable the browsing application provide the user options for at least one from a set of:

analyzing, modifying, extracting values from, performing calculations on, and generating charts from the database data.

12. The system of claim 9, wherein the first WFE server is further configured to provide the database data to a client application capable of processing the database data employing spreadsheet operations in response to call from the client application.

13. The system of claim 9, wherein the first WFE server is configured to communicate with the browsing application through one of:

direct communication and indirect communication facilitated by another web server.

14. The system of claim 9, the system further comprising:

a second web front end (WFE) server configured to;

in response to receiving a request from the browsing application for rendering spreadsheet data through a database user interface, forward the request to the backend server managing the database data at the common data store;

receive requested spreadsheet data from the backend server; and

provide the spreadsheet data to the browsing application for rendering through the database user interface.

15. The system of claim 14, wherein the first and second WFE servers are scalable independently from the backend server.

16. The system of claim 14, wherein the first WFE server, the second WFE server, and the backend server are part of a hosted sharing service maintaining user documents and enabling spreadsheet and database functionality on the maintained documents.

17. A computer-readable storage medium with instructions stored thereon for providing spreadsheet and database related web services, the instructions comprising:

receiving a request for rendering one of;

spreadsheet data through a database user interface and database data through a spreadsheet user interface;

forwarding the request to one of a spreadsheet services front end server and a database services front end server;

forwarding the request from the one of the spreadsheet services front end server and the database services front end server to a backend server for retrieval and processing;

retrieving data from a common data store, wherein spreadsheet data and database data are linked with a read/write connection to the common data store; and

forwarding the retrieved data through the one of the spreadsheet services front end server and the database services front end server to a backend server to a requesting client application for rendering.

18. The computer-readable medium of claim 17, wherein the instructions further comprise:

enabling a user to view and edit the requested spreadsheet data through the database user interface and database data through the spreadsheet user interface, wherein a navigation between the user interfaces is seamless.

19. The computer-readable medium of claim 18, wherein the user is enabled to share the one of the database data and the spreadsheet data with other users of a web service managing the common data store.

20. The computer-readable medium of claim 17, wherein the data is table format.