Method, system, and apparatus for exposing workbook ranges as data sources
First Claim
Patent Images
1. A method for exposing the contents of a workbook as a server data source, the method comprising:
- receiving a database query directed to a range within a workbook;
in response to the query, recalculating the range, generating a database representation of the recalculated range, performing the requested query on the database representation of the recalculated range to obtain a query result, and transmitting the query result as a response to the database query.
2 Assignments
0 Petitions
Accused Products
Abstract
A method, system, and apparatus are provided for exposing and utilizing workbook ranges as server data sources. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook including a range that includes data objects. The workbook may be published to a server computer where the specified data objects are exposed as server data sources. The server computer allows client applications to discover and connect to the data objects contained within the workbook as server data sources.
79 Citations
20 Claims
-
1. A method for exposing the contents of a workbook as a server data source, the method comprising:
-
receiving a database query directed to a range within a workbook;
in response to the query, recalculating the range, generating a database representation of the recalculated range, performing the requested query on the database representation of the recalculated range to obtain a query result, and transmitting the query result as a response to the database query. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A method for exposing the contents of a workbook as a server data source, the method comprising:
-
providing a facility for authoring a workbook having a range stored therein including one or more data objects;
generating metadata for the one or more data objects, said metadata for use by a server computer in responding to requests for the one or more data objects as a server data source; and
publishing the workbook and the metadata to the server computer, whereby the data objects are exposed at the server computer as server data sources. - View Dependent Claims (7, 8, 9)
-
-
10. A method for exposing and utilizing a range within a workbook as a server data source, the method comprising:
-
authoring a workbook having a range stored therein including one or more data objects;
generating metadata for the one or more data objects, said metadata for use by a server computer in responding to requests for the one or more data objects as a server data source;
publishing the workbook and the metadata to the server computer;
exposing the data objects as server data sources;
receiving a data source query at the server computer referencing data contained within one of the data objects;
in response to receiving the query, loading the workbook and calculating the workbook, including calculating the value of the data objects;
generating a database representation of the data objects utilizing the metadata;
performing the requested query on the database representation of the data objects to create a query result; and
responding to the query with the query result. - View Dependent Claims (11, 12, 13)
-
-
14. A system for exposing and utilizing a range within a workbook as a server data source, the system comprising:
-
a client computer operative to execute a spreadsheet application program for authoring a workbook having one or more ranges including one or more data objects, the spreadsheet application program further operative to publish the workbook to a server computer; and
a server computer operative to execute a server program for exposing the data objects contained in the workbook as server data sources and for receiving and responding to query requests directed to the server data sources. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification