Method and system for facilitating information exchange

• US 7,430,710 B2
• Filed: 10/25/2005
• Issued: 09/30/2008
• Est. Priority Date: 05/30/2000
• Status: Expired due to Term

• Current Assignee: Outlooksoft Corporation (SAP SE)
• Original Assignee: Outlooksoft Corporation (SAP SE)
• Inventors: Voshell, Perlie E., Cho, Charles J.
• Primary Examiner(s): Hong; Stephen
• Assistant Examiner(s): Faber; David
• Application Number:
  US11/257,858
• Publication Number:
  US 20060036957A1
• Time in Patent Office: 1,071 Days
• Field of Search: 715503-504, 715/513, 715/212, 715/213, 715/215, 715/234, 709217-219
• US Class Current: 715/212
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e., non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.

Claims

1. A system for facilitating efficient database-related information exchanges across a network, the system comprising:

a client computer in communications with a network, the client computer comprising;

memory; and

a processor at least partially executing a spreadsheet-based application program configured to;

receive a request for data associated with a spreadsheet-based application program;

determine whether data responsive to the request is available in the memory of the client computer;

if data responsive to the request is not entirely available in the memory at the client computer, store the request until at least one additional request for data associated with the spreadsheet-based application program is received;

combine the stored request with the at least one additional request for data to form a single query;

transmit the single query to a server across the network requesting the data associated with the stored request and the at least one additional request;

receive the data responsive to the single query from the server across the network in response to transmitting the single query; and

render at least part of a spreadsheet based on the data received.

2. The system of claim 1, wherein the processor is further configured to render at least part of the spreadsheet based on the data responsive to the requests that is available in the memory of the client computer and data received in response to the single query.

3. The system of claim 1, wherein the server accesses a centralized data and document repository.

4. The system of claim 1, wherein the processor is further configured to store the data received in response to the single query in a cache.

5. The system of claim 4, wherein the data responsive to the single query is stored in the cache before providing the data to the spreadsheet-based application program for use in rendering the at least one spreadsheet.

6. The system of claim 1, wherein the processor is further configured to verify that a user of the client computer has authorization before providing the data responsive to the single query to the client computer.

7. The system of claim 1, wherein the spreadsheet-based application program is operable in the absence of communications with the server across the network.

8. The system of claim 7, wherein, in the absence of communication with the server across the network, the spreadsheet-based application program uses data stored in a cache to render at least part of the spreadsheet.

9. A method for facilitating efficient database-related information exchanges across a network, the method comprising:

providing a spreadsheet-based application program at a client computer, the client computer being in communication with the network;

receiving a request for data associated with the spreadsheet-based application program;

determining whether data responsive to the request is available at the client computer;

if data responsive to the request is not entirely available in the client computer, storing the request until at least one additional request for data associated with the spreadsheet-based application program is received;

combining the stored request with the at least one additional request for data to form a single query;

transmitting the single query to a server across the network requesting the data associated with the stored request and the at least one additional request;

receiving the data at the client computer that is responsive to the single query, wherein the data is received across the network; and

rendering at least part of a spreadsheet based on the data received.

10. The method of claim 9, further comprising rendering the at least part of the spreadsheet based on data responsive to the requests that is available at the client computer and data received in response to the single query from across the network.

11. The method of claim 9, further comprising storing the data received in response to the single query in a cache.

12. The method of claim 11, wherein the data responsive to the single query is stored in the cache before providing the data to the spreadsheet-based application program for use in rendering the at least one spreadsheet.

13. The method of claim 9, further comprising verifying that a user of the client computer has authorization before providing the data responsive to the single query to the client computer.

14. The method of claim 9, wherein the spreadsheet-based application program is operable in the absence of communications across the network.

15. The method of claim 14, wherein, in the absence of communication across the network, the spreadsheet-based application program uses data stored in a cache to render the spreadsheet.