CA2508933C - Method, system, and apparatus for exposing workbook ranges as data sources - Google Patents
Method, system, and apparatus for exposing workbook ranges as data sources Download PDFInfo
- Publication number
- CA2508933C CA2508933C CA2508933A CA2508933A CA2508933C CA 2508933 C CA2508933 C CA 2508933C CA 2508933 A CA2508933 A CA 2508933A CA 2508933 A CA2508933 A CA 2508933A CA 2508933 C CA2508933 C CA 2508933C
- Authority
- CA
- Canada
- Prior art keywords
- workbook
- data
- server
- metadata
- computer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 230000002776 aggregation Effects 0.000 claims description 25
- 238000004220 aggregation Methods 0.000 claims description 25
- 238000003860 storage Methods 0.000 claims description 20
- 230000004044 response Effects 0.000 claims description 11
- 230000008569 process Effects 0.000 description 8
- 230000006870 function Effects 0.000 description 6
- 238000004590 computer program Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F15/00—Digital computers in general; Data processing equipment in general
- G06F15/16—Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
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.
Description
METHOD, SYSTEM, AND APPARATUS FOR EXPOSING
WORKBOOK RANGES AS DATA SOURCES
FIELD OF THE INVENTION
This invention relates to exposing workbook contents and/or ranges as 5 data sources.
BACKGROUND OF THE INVENTION
When building workbooks, users of spreadsheet application programs often utilize data from a number of different sources. For instance, when creating a workbook within a spreadsheet application program, a user may import data from another workbook, may enter data into the workbook manually, or may obtain data by executing queries on a relational database or on an on-line analytical processing ("OLAP") cube. Once the data has been entered from any of these sources, a user typically arranges the data in the desired configuration within the workbook.
At the end of this process, the user has created a workbook that includes a tabular range of data upon which meaningful numerical analysis may be performed.
In order for other users to access the contents of the workbook, copies of the workbook or portions of it may be made. For instance, in many scenarios the workbook is sent to other users via an electronic mail ("e-mail") message. The users that receive the workbook can then perform analysis on the workbook or add the data contained in the workbook to another workbook. Alternatively, the workbook may be stored on a file share where multiple users can access the contents of the workbook. In order to share the contents of the workbook, ranges of data may also be copied and pasted into other documents.
Although these traditional methods for sharing a workbook allow multiple users to access the contents of a workbook, these methods are not without their drawbacks. First, it is very difficult to administer multiple copies of a workbook that may be duplicated many times across multiple computers and network domains. In particular, it is very difficult for a system administrator to ensure that the workbook is secure and that it is frequently backed up. Moreover, in the case of a file share, it may be very difficult for multiple users to simultaneously access the workbook.
For example, if the author of the original workbook needs to update it, then it is extremely difficult to track all the users that use it and have them update their copies. In many cases, the spreadsheet client application locks the workbook when it is opened by one user, thereby preventing others from accessing the file. Additionally, identical functions may be performed on different copies of the workbook, thereby causing duplication of effort and reducing productivity.
It is with respect to these considerations and others that the various embodiments of the present invention have been made.
BRIEF SUMMARY OF THE INVENTION
According to one aspect of the present invention, there is provided a method for exposing data objects of a workbook as a server data source, comprising:
generating metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a first server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprises analyzing the data objects to identify the following:
data types, measures, hierarchy, and default aggregations, and wherein setting the properties comprises indicating a first default aggregation as a count for a string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata;
publishing the workbook and the metadata to the first server computer, wherein publishing comprises programmatically generating a spreadsheet and sending the spreadsheet to the first server computer through a server application program interface, wherein the workbook is parsed for ranges including the data objects by a spreadsheet server application executing on the first server computer, and wherein user-specified data objects from among the data objects are exposed at the first server computer as server data sources; and connecting to the data object exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer.
WORKBOOK RANGES AS DATA SOURCES
FIELD OF THE INVENTION
This invention relates to exposing workbook contents and/or ranges as 5 data sources.
BACKGROUND OF THE INVENTION
When building workbooks, users of spreadsheet application programs often utilize data from a number of different sources. For instance, when creating a workbook within a spreadsheet application program, a user may import data from another workbook, may enter data into the workbook manually, or may obtain data by executing queries on a relational database or on an on-line analytical processing ("OLAP") cube. Once the data has been entered from any of these sources, a user typically arranges the data in the desired configuration within the workbook.
At the end of this process, the user has created a workbook that includes a tabular range of data upon which meaningful numerical analysis may be performed.
In order for other users to access the contents of the workbook, copies of the workbook or portions of it may be made. For instance, in many scenarios the workbook is sent to other users via an electronic mail ("e-mail") message. The users that receive the workbook can then perform analysis on the workbook or add the data contained in the workbook to another workbook. Alternatively, the workbook may be stored on a file share where multiple users can access the contents of the workbook. In order to share the contents of the workbook, ranges of data may also be copied and pasted into other documents.
Although these traditional methods for sharing a workbook allow multiple users to access the contents of a workbook, these methods are not without their drawbacks. First, it is very difficult to administer multiple copies of a workbook that may be duplicated many times across multiple computers and network domains. In particular, it is very difficult for a system administrator to ensure that the workbook is secure and that it is frequently backed up. Moreover, in the case of a file share, it may be very difficult for multiple users to simultaneously access the workbook.
For example, if the author of the original workbook needs to update it, then it is extremely difficult to track all the users that use it and have them update their copies. In many cases, the spreadsheet client application locks the workbook when it is opened by one user, thereby preventing others from accessing the file. Additionally, identical functions may be performed on different copies of the workbook, thereby causing duplication of effort and reducing productivity.
It is with respect to these considerations and others that the various embodiments of the present invention have been made.
BRIEF SUMMARY OF THE INVENTION
According to one aspect of the present invention, there is provided a method for exposing data objects of a workbook as a server data source, comprising:
generating metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a first server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprises analyzing the data objects to identify the following:
data types, measures, hierarchy, and default aggregations, and wherein setting the properties comprises indicating a first default aggregation as a count for a string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata;
publishing the workbook and the metadata to the first server computer, wherein publishing comprises programmatically generating a spreadsheet and sending the spreadsheet to the first server computer through a server application program interface, wherein the workbook is parsed for ranges including the data objects by a spreadsheet server application executing on the first server computer, and wherein user-specified data objects from among the data objects are exposed at the first server computer as server data sources; and connecting to the data object exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer.
2 According to another aspect of the present invention, there is provided a method for exposing and utilizing data objects within a workbook as a server data source, comprising: generating metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a first server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprises analyzing the data objects to identify the following: data types, measures, hierarchy, and default aggregations, and wherein setting the properties comprises indicating a first default aggregation as a count for a string field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata; publishing the workbook and the metadata to the first server computer, wherein the workbook is parsed for ranges including the data objects by a spreadsheet server application executing on the first server computer;
exposing the data objects as server data sources; connecting to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer; receiving a data source query at the first server computer referencing data contained within one of the data objects; in response to receiving the data source query, loading the workbook and calculating the workbook, including calculating a value of the data objects; generating a temporary database representation of the data objects utilizing the metadata, wherein the temporary database representation comprises an OLAP cube; performing the data source query on the database representation of the data objects to create a query result; and responding to the query with the query result.
According to still another aspect of the present invention, there is provided a system for exposing and utilizing data objects within a workbook as a server data source, the system comprising: a client computer configured to execute a spreadsheet application program for authoring a workbook having data objects, wherein the spreadsheet application program generates metadata utilized by a server application and publishes the workbook to a first server computer, wherein publishing comprises programmatically generating a spreadsheet, wherein the spreadsheet application program is further configured to generate metadata for the data objects by automatically identifying the metadata in the workbook and 2a = 51028-47 setting properties for the identified metadata, wherein the metadata is utilized by a server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprising analyzing the data objects to identify the following:
data types, measures, hierarchy, and default aggregations, wherein setting the properties comprises indicating a first default aggregation as a count for the string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata, wherein the spreadsheet application is further configured to connect to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer; and the first server computer configured to receive the spreadsheet from the client computer through a server application program interface, to parse the workbook for ranges including the data objects, and to execute a server program for exposing user specified objects from among 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.
According to a further aspect of the present invention, there is provided a computer-readable storage medium having computer-executable instructions stored thereon that, when executed by a computer, will cause the computer to perform a method as described above or below.
According to a further aspect of the present invention, there is provided a computer-controlled apparatus configured to perform a method as described above or below.
Some embodiments of the present invention provide a method, system, and apparatus for exposing workbook ranges as data sources. By exposing ranges within a workbook as server data sources, structured access may be easily had to the contents of the workbook by any application program capable of connecting to and querying a server data source. Moreover, because workbook ranges are exposed as server data sources when the workbook is published, any user capable of operating a spreadsheet application program can easily create enterprise level data sources.
2b = 51028-47 -According to one aspect of the invention, a system is provided for exposing the contents of a workbook as a server data source and for utilizing the server data source. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook. The workbook may include one or more ranges that include data objects. As defined herein, a data object includes any object within a worksheet that is utilized to store data. For instance, data objects may include, but are not limited to, an arbitrary range of cells, pivot tables, data exploration objects ("DOEs"), lists, databases, and query tables.
The spreadsheet application program may also be operative to generate metadata for each of the data objects when the worksheet is authored. The metadata may be saved with the worksheet. The metadata may be utilized by a server computer 2c when receiving and responding to requests to access the data objects within the workbook as server data sources. Creation of metadata for the data objects may be performed in an automated fashion by the spreadsheet application program when the data is created, when the data is published, or in response to a user request to generate the metadata. A facility may also be provided for allowing a user to edit the metadata.
The spreadsheet application program is further operative to publish a workbook to a server computer. When a workbook is published to a server computer, a user may specify that some, none, or all of the data objects within a workbook be exposed as server data sources. The workbook is then transmitted to the server computer where the specified data sources are exposed as server data sources.
According to aspects of the invention, the system also includes a server computer operative to execute a server program for exposing data objects within a workbook as server data objects. As used herein, the terms "data source" and "server data source" refer specifically to a database upon which queries may be executed. This definition includes relational databases (such as those that may be built and queried using the Structured Query Language ("SQL")), hierarchical databases, multidimensional databases (such as an OLAP cube), or databases that combine aspects of relational and multi-dimensional databases (such as the Unified Dimensional Model ("UDM")). The definition also includes databases that may be queried via Web services. As also used herein the term "data source query" means a query directed to a data source, such as an SQL query.
Once the workbook data objects have been exposed, client applications may discover and connect to the data objects as server data sources. When a query is issued against a data object as a server data source, the server computer is operative to recalculate the workbook. If the workbook contains a reference to another data source, any data necessary to recalculate the workbook may be retrieved from the data source prior to the recalculation. Once the workbook has been recalculated, the server computer is operative to generate a representation (such as a database representation) of the identified data object. This may include, for instance, generating a temporary database or cube corresponding to the identified data object.
exposing the data objects as server data sources; connecting to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer; receiving a data source query at the first server computer referencing data contained within one of the data objects; in response to receiving the data source query, loading the workbook and calculating the workbook, including calculating a value of the data objects; generating a temporary database representation of the data objects utilizing the metadata, wherein the temporary database representation comprises an OLAP cube; performing the data source query on the database representation of the data objects to create a query result; and responding to the query with the query result.
According to still another aspect of the present invention, there is provided a system for exposing and utilizing data objects within a workbook as a server data source, the system comprising: a client computer configured to execute a spreadsheet application program for authoring a workbook having data objects, wherein the spreadsheet application program generates metadata utilized by a server application and publishes the workbook to a first server computer, wherein publishing comprises programmatically generating a spreadsheet, wherein the spreadsheet application program is further configured to generate metadata for the data objects by automatically identifying the metadata in the workbook and 2a = 51028-47 setting properties for the identified metadata, wherein the metadata is utilized by a server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprising analyzing the data objects to identify the following:
data types, measures, hierarchy, and default aggregations, wherein setting the properties comprises indicating a first default aggregation as a count for the string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata, wherein the spreadsheet application is further configured to connect to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer; and the first server computer configured to receive the spreadsheet from the client computer through a server application program interface, to parse the workbook for ranges including the data objects, and to execute a server program for exposing user specified objects from among 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.
According to a further aspect of the present invention, there is provided a computer-readable storage medium having computer-executable instructions stored thereon that, when executed by a computer, will cause the computer to perform a method as described above or below.
According to a further aspect of the present invention, there is provided a computer-controlled apparatus configured to perform a method as described above or below.
Some embodiments of the present invention provide a method, system, and apparatus for exposing workbook ranges as data sources. By exposing ranges within a workbook as server data sources, structured access may be easily had to the contents of the workbook by any application program capable of connecting to and querying a server data source. Moreover, because workbook ranges are exposed as server data sources when the workbook is published, any user capable of operating a spreadsheet application program can easily create enterprise level data sources.
2b = 51028-47 -According to one aspect of the invention, a system is provided for exposing the contents of a workbook as a server data source and for utilizing the server data source. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook. The workbook may include one or more ranges that include data objects. As defined herein, a data object includes any object within a worksheet that is utilized to store data. For instance, data objects may include, but are not limited to, an arbitrary range of cells, pivot tables, data exploration objects ("DOEs"), lists, databases, and query tables.
The spreadsheet application program may also be operative to generate metadata for each of the data objects when the worksheet is authored. The metadata may be saved with the worksheet. The metadata may be utilized by a server computer 2c when receiving and responding to requests to access the data objects within the workbook as server data sources. Creation of metadata for the data objects may be performed in an automated fashion by the spreadsheet application program when the data is created, when the data is published, or in response to a user request to generate the metadata. A facility may also be provided for allowing a user to edit the metadata.
The spreadsheet application program is further operative to publish a workbook to a server computer. When a workbook is published to a server computer, a user may specify that some, none, or all of the data objects within a workbook be exposed as server data sources. The workbook is then transmitted to the server computer where the specified data sources are exposed as server data sources.
According to aspects of the invention, the system also includes a server computer operative to execute a server program for exposing data objects within a workbook as server data objects. As used herein, the terms "data source" and "server data source" refer specifically to a database upon which queries may be executed. This definition includes relational databases (such as those that may be built and queried using the Structured Query Language ("SQL")), hierarchical databases, multidimensional databases (such as an OLAP cube), or databases that combine aspects of relational and multi-dimensional databases (such as the Unified Dimensional Model ("UDM")). The definition also includes databases that may be queried via Web services. As also used herein the term "data source query" means a query directed to a data source, such as an SQL query.
Once the workbook data objects have been exposed, client applications may discover and connect to the data objects as server data sources. When a query is issued against a data object as a server data source, the server computer is operative to recalculate the workbook. If the workbook contains a reference to another data source, any data necessary to recalculate the workbook may be retrieved from the data source prior to the recalculation. Once the workbook has been recalculated, the server computer is operative to generate a representation (such as a database representation) of the identified data object. This may include, for instance, generating a temporary database or cube corresponding to the identified data object.
3 Once the representation has been generated, the server computer is operative to perform the requested query on the representation. The result of the query is then returned to the requesting client application program. In this manner, for instance, a user can easily author a workbook and publish the workbook to a server computer where its data objects may be exposed as server data sources. Other users utilizing database client applications, such as an OLAP client, can then discover the data sources contained in the workbook and issue native queries against the data sources.
The invention may be implemented as a computer process, a computing apparatus, or as an article of manufacture such as a computer program product or computer readable media. The computer program product may be a computer storage media readable by a computer system and encoding a computer program of instructions for executing a computer process. The computer program product may also be a propagated signal on a carrier readable by a computing system and encoding a computer program of instructions for executing a computer process.
These and various other features, as well as advantages, which characterize the present invention, will be apparent from a reading of the following detailed description and a review of the associated drawings.
BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS
FIGURE 1 is a computer network diagram illustrating aspects of several computer systems utilized in and provided by the various embodiments of the invention;
FIGURE 2 is a computer system architecture diagram illustrating aspects of a client computer system utilized in and provided by the various embodiments of the invention;
FIGURE 3 is a flow diagram illustrating aspects of a process for publishing a workbook range as a server data source according to one embodiment of the invention;
The invention may be implemented as a computer process, a computing apparatus, or as an article of manufacture such as a computer program product or computer readable media. The computer program product may be a computer storage media readable by a computer system and encoding a computer program of instructions for executing a computer process. The computer program product may also be a propagated signal on a carrier readable by a computing system and encoding a computer program of instructions for executing a computer process.
These and various other features, as well as advantages, which characterize the present invention, will be apparent from a reading of the following detailed description and a review of the associated drawings.
BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS
FIGURE 1 is a computer network diagram illustrating aspects of several computer systems utilized in and provided by the various embodiments of the invention;
FIGURE 2 is a computer system architecture diagram illustrating aspects of a client computer system utilized in and provided by the various embodiments of the invention;
FIGURE 3 is a flow diagram illustrating aspects of a process for publishing a workbook range as a server data source according to one embodiment of the invention;
4 = 51331-220 FIGURE 4 is a screen diagram illustrating an aspect of the invention for providing a facility through which a user can edit metadata associated with data objects in a range of a workbook; and FIGURE 5 is a flow diagram illustrating aspects of a process for receiving and responding to requests for workbook ranges as server data sources according to one embodiment of the invention.
DETAILED DESCRIPTION OF THE INVENTION
Referring now to the drawings, in which like numerals represent like elements, various aspects of the present invention will be described. In particular, FIGURE 1 and the corresponding discussion are intended to provide a brief, general description of a suitable computing environment in which embodiments of the invention may be implemented. While the invention will be described in the general context of program modules that execute in conjunction with program modules that run on an operating system on a personal computer, those skilled in the art will recognize that the invention may also be implemented in combination with other types of computer systems and program modules.
Generally, program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types. Moreover, those skilled in the art will appreciate that the invention may be practiced with other computer system configurations, including hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, mainframe computers, and the like. The invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.
Referring now to FIGURE 1, an illustrative operating environment for the several embodiments of the invention will be described. As shown in FIGURE
1, a network 10 interconnects a client computer 2 and several server computers 12A-12C. It
DETAILED DESCRIPTION OF THE INVENTION
Referring now to the drawings, in which like numerals represent like elements, various aspects of the present invention will be described. In particular, FIGURE 1 and the corresponding discussion are intended to provide a brief, general description of a suitable computing environment in which embodiments of the invention may be implemented. While the invention will be described in the general context of program modules that execute in conjunction with program modules that run on an operating system on a personal computer, those skilled in the art will recognize that the invention may also be implemented in combination with other types of computer systems and program modules.
Generally, program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types. Moreover, those skilled in the art will appreciate that the invention may be practiced with other computer system configurations, including hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, mainframe computers, and the like. The invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.
Referring now to FIGURE 1, an illustrative operating environment for the several embodiments of the invention will be described. As shown in FIGURE
1, a network 10 interconnects a client computer 2 and several server computers 12A-12C. It
5 = 51331-220 should be appreciated that the network 10 may comprise any type of computing network, including a local area network or a wide area network, such as the Internet.
The network 10 provides a medium for enabling communication between the client computer 2, the server computers 12A-12C, and potentially other computer systems connected to or accessible through the network 10.
The client computer 2 comprises a general purpose desktop or laptop computer capable of executing one or more application programs. In particular, according to the various embodiments of the invention, the computer 2 is operative to execute a spreadsheet client application 4. As known to those skilled in the art, the spreadsheet client application program 4 provides functionality for creating budgets, performing financial forecasting, and other finance and numeric-related tasks.
In order to provide this functionality, data values may be organized using cells and the relationships between the cells may be defined using formulas. A change to one cell produces changes to related cells. Spreadsheet programs usually provide graphing capabilities for output and a variety of formatting options for text, numeric values, and graph features.
According to embodiments of the invention, the spreadsheet client application 4 may be utilized to create a workbook 6. The workbook 6 is a file that is created by a spreadsheet program that contains one or more worksheets (a worksheet may also be referred to herein as a ("spreadsheet"). A worksheet is a single page organized into rows and columns within the spreadsheet program and appearing on screen and used for constructing a single table.
Worksheets within the workbook 6 may include one or more ranges that include data objects. As defined herein, a data object includes any object within a worksheet that is utilized to store data. For instance, data objects may include, but are not limited to, an arbitrary range of cells, pivot tables, DOEs, lists, databases, and query tables. As will be described more fully herein, each of these data objects may be exposed as a server data source available from the server 12A. Other types of data objects utilized within a workbook may also be exposed as a server data source.
The network 10 provides a medium for enabling communication between the client computer 2, the server computers 12A-12C, and potentially other computer systems connected to or accessible through the network 10.
The client computer 2 comprises a general purpose desktop or laptop computer capable of executing one or more application programs. In particular, according to the various embodiments of the invention, the computer 2 is operative to execute a spreadsheet client application 4. As known to those skilled in the art, the spreadsheet client application program 4 provides functionality for creating budgets, performing financial forecasting, and other finance and numeric-related tasks.
In order to provide this functionality, data values may be organized using cells and the relationships between the cells may be defined using formulas. A change to one cell produces changes to related cells. Spreadsheet programs usually provide graphing capabilities for output and a variety of formatting options for text, numeric values, and graph features.
According to embodiments of the invention, the spreadsheet client application 4 may be utilized to create a workbook 6. The workbook 6 is a file that is created by a spreadsheet program that contains one or more worksheets (a worksheet may also be referred to herein as a ("spreadsheet"). A worksheet is a single page organized into rows and columns within the spreadsheet program and appearing on screen and used for constructing a single table.
Worksheets within the workbook 6 may include one or more ranges that include data objects. As defined herein, a data object includes any object within a worksheet that is utilized to store data. For instance, data objects may include, but are not limited to, an arbitrary range of cells, pivot tables, DOEs, lists, databases, and query tables. As will be described more fully herein, each of these data objects may be exposed as a server data source available from the server 12A. Other types of data objects utilized within a workbook may also be exposed as a server data source.
6 It should be appreciated that, according to one embodiment of the invention, the spreadsheet client application 4 comprises the EXCEL
spreadsheet application program from MICROSOFT CORPORATION of Redmond, Washington.
It should be appreciated, however, that the various aspects of the invention described herein may be utilized with other spreadsheet application programs from other manufacturers. Moreover, although the inventive aspects described herein are presented in the context of a spreadsheet application program, it should be appreciated that other types of application programs may also be utilized to embody the various aspects of the invention.
According to other embodiments of the invention, the client computer 2 may also be operative to execute an OLAP client application 8. The OLAP client application 8 comprises an application program capable of connecting to, querying, and utilizing data from an OLAP data source. For instance, the OLAP client application 8 may connect to the server computer 12B through the network 10. Through database software executing on the server computer 12B, the OLAP client application 8 may issue queries against the data source 16. The server computer 12B is then operative to receive and respond to the queries from the OLAP client application 8.
As will be described in greater detail below, the OLAP client application 8 may also issue queries against a workbook 6. In order to enable this functionality, the spreadsheet client application 4 may publish the workbook 6 to a repository 14 maintained by a file server computer 12C and accessible to the server computer 12A.
The spreadsheet server application 13 executing on the server computer 12A may then parse the workbook 6 for ranges including data objects and expose the data objects as server data sources. The OLAP client application 8 may then connect to the data sources exposed by the spreadsheet server application 12A in the same manner that it would connect to a dedicated OLAP data source, such as that provided by the server computer 12B. It should be appreciated that the spreadsheet client application 4 may act as a consumer of data from a data source in the same manner as the OLAP
client application 8. It should also be appreciated that the computer 2 may be operative to execute additional client applications for querying and consuming data from other types
spreadsheet application program from MICROSOFT CORPORATION of Redmond, Washington.
It should be appreciated, however, that the various aspects of the invention described herein may be utilized with other spreadsheet application programs from other manufacturers. Moreover, although the inventive aspects described herein are presented in the context of a spreadsheet application program, it should be appreciated that other types of application programs may also be utilized to embody the various aspects of the invention.
According to other embodiments of the invention, the client computer 2 may also be operative to execute an OLAP client application 8. The OLAP client application 8 comprises an application program capable of connecting to, querying, and utilizing data from an OLAP data source. For instance, the OLAP client application 8 may connect to the server computer 12B through the network 10. Through database software executing on the server computer 12B, the OLAP client application 8 may issue queries against the data source 16. The server computer 12B is then operative to receive and respond to the queries from the OLAP client application 8.
As will be described in greater detail below, the OLAP client application 8 may also issue queries against a workbook 6. In order to enable this functionality, the spreadsheet client application 4 may publish the workbook 6 to a repository 14 maintained by a file server computer 12C and accessible to the server computer 12A.
The spreadsheet server application 13 executing on the server computer 12A may then parse the workbook 6 for ranges including data objects and expose the data objects as server data sources. The OLAP client application 8 may then connect to the data sources exposed by the spreadsheet server application 12A in the same manner that it would connect to a dedicated OLAP data source, such as that provided by the server computer 12B. It should be appreciated that the spreadsheet client application 4 may act as a consumer of data from a data source in the same manner as the OLAP
client application 8. It should also be appreciated that the computer 2 may be operative to execute additional client applications for querying and consuming data from other types
7 of databases. It should further be appreciated that in an alternative embodiment, the functions of the computer 2 described above may be divided among two computing devices. For instance, one computing device may be operative to execute the spreadsheet application 4 for publishing the workbook 6 while the other computing device may be operative to execute client applications for consuming data.
As used herein, the terms "data source" and "server data source" refer specifically to a database upon which queries may be executed. This definition includes relational databases (such as SQL databases), hierarchical databases, multidimensional databases (such as an OLAP cube), or databases that combine aspects of relational and multidimensional databases (such as the UDM). The definition also includes databases that may be queried via Web services. As also used herein the term "data source query"
means a query directed to a data source, such as an SQL query.
The spreadsheet server application 13 comprises a server-based application program that may execute without the use of a display screen (headless).
The spreadsheet server application 13 is operative to perform many of the functions of the spreadsheet client application 4 on a server computer. For instance, the spreadsheet server application 13 can load and calculate a workbook 6. As will be described herein, the spreadsheet server application 13 also provides functionality for exposing ranges within a workbook 6 to compatible clients via the network 10. Additional details regarding the various functions performed by the spreadsheet client application 4 and the spreadsheet server application 13 will be provided below with respect to FIGURES
2-5.
Referring now to FIGURE 2, an illustrative computer architecture for a computer 2 utilized in the various embodiments of the invention will be described. The computer architecture shown in FIGURE 2 illustrates a conventional desktop or laptop computer, including a central processing unit 5 ("CPU"), a system memory 7, including a random access memory 9 ("RAM") and a read-only memory ("ROM") 11, and a system bus 12 that couples the memory to the CPU 5. A basic input/output system containing the basic routines that help to transfer information between elements within the computer, such as during startup, is stored in the ROM 11. The computer 2 further
As used herein, the terms "data source" and "server data source" refer specifically to a database upon which queries may be executed. This definition includes relational databases (such as SQL databases), hierarchical databases, multidimensional databases (such as an OLAP cube), or databases that combine aspects of relational and multidimensional databases (such as the UDM). The definition also includes databases that may be queried via Web services. As also used herein the term "data source query"
means a query directed to a data source, such as an SQL query.
The spreadsheet server application 13 comprises a server-based application program that may execute without the use of a display screen (headless).
The spreadsheet server application 13 is operative to perform many of the functions of the spreadsheet client application 4 on a server computer. For instance, the spreadsheet server application 13 can load and calculate a workbook 6. As will be described herein, the spreadsheet server application 13 also provides functionality for exposing ranges within a workbook 6 to compatible clients via the network 10. Additional details regarding the various functions performed by the spreadsheet client application 4 and the spreadsheet server application 13 will be provided below with respect to FIGURES
2-5.
Referring now to FIGURE 2, an illustrative computer architecture for a computer 2 utilized in the various embodiments of the invention will be described. The computer architecture shown in FIGURE 2 illustrates a conventional desktop or laptop computer, including a central processing unit 5 ("CPU"), a system memory 7, including a random access memory 9 ("RAM") and a read-only memory ("ROM") 11, and a system bus 12 that couples the memory to the CPU 5. A basic input/output system containing the basic routines that help to transfer information between elements within the computer, such as during startup, is stored in the ROM 11. The computer 2 further
8 includes a mass storage device 24 for storing an operating system 18, application programs, and other program modules, which will be described in greater detail below.
The mass storage device 24 is connected to the CPU 5 through a mass storage controller (not shown) connected to the bus 12. The mass storage device 24 and its associated computer-readable media provide non-volatile storage for the computer 2.
Although the description of computer-readable media contained herein refers to a mass storage device, such as a hard disk or CD-ROM drive, it should be appreciated by those skilled in the art that computer-readable media can be any available media that can be accessed by the computer 2.
By way of example, and not limitation, computer-readable media may comprise computer storage media and communication media. Computer storage media includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storage of information such as computer-readable instructions, data structures, program modules or other data. Computer storage media includes, but is not limited to, RAM, ROM, EPROM, EEPROM, flash memory or other solid state memory technology, CD-ROM, digital versatile disks ("DVD"), or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can be accessed by the computer 2.
According to various embodiments of the invention, the computer 2 may operate in a networked environment using logical connections to remote computers through a network 10, such as the Internet. The computer 2 may connect to the network 10 through a network interface unit 20 connected to the bus 12. It should be appreciated that the network interface unit 20 may also be utilized to connect to other types of networks and remote computer systems. The computer 2 may also include an input/output controller 22 for receiving and processing input from a number of other devices, including a keyboard, mouse, or electronic stylus (not shown in FIGURE 2).
Similarly, an input/output controller 22 may provide output to a display screen, a printer, or other type of output device.
The mass storage device 24 is connected to the CPU 5 through a mass storage controller (not shown) connected to the bus 12. The mass storage device 24 and its associated computer-readable media provide non-volatile storage for the computer 2.
Although the description of computer-readable media contained herein refers to a mass storage device, such as a hard disk or CD-ROM drive, it should be appreciated by those skilled in the art that computer-readable media can be any available media that can be accessed by the computer 2.
By way of example, and not limitation, computer-readable media may comprise computer storage media and communication media. Computer storage media includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storage of information such as computer-readable instructions, data structures, program modules or other data. Computer storage media includes, but is not limited to, RAM, ROM, EPROM, EEPROM, flash memory or other solid state memory technology, CD-ROM, digital versatile disks ("DVD"), or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can be accessed by the computer 2.
According to various embodiments of the invention, the computer 2 may operate in a networked environment using logical connections to remote computers through a network 10, such as the Internet. The computer 2 may connect to the network 10 through a network interface unit 20 connected to the bus 12. It should be appreciated that the network interface unit 20 may also be utilized to connect to other types of networks and remote computer systems. The computer 2 may also include an input/output controller 22 for receiving and processing input from a number of other devices, including a keyboard, mouse, or electronic stylus (not shown in FIGURE 2).
Similarly, an input/output controller 22 may provide output to a display screen, a printer, or other type of output device.
9 As mentioned briefly above, a number of program modules and data files may be stored in the mass storage device 24 and RAM 9 of the computer 2, including an operating system 18 suitable for controlling the operation of a networked personal computer, such as the WINDOWS XP operating system from MICROSOFT
CORPORATION of Redmond, Washington. The mass storage device 24 and RAM 9 may also store one or more program modules. In particular, the mass storage device 24 and the RAM 9 may store a spreadsheet client application 4 and an OLAP client application 8, as described above. The mass storage device 24 and RAM 9 may also store a workbook 6 created by the spreadsheet client application 4.
According to one embodiment of the invention, the spreadsheet application program 4 is also be operative to generate metadata 26 for each of the data objects contained within a workbook. The metadata 26 may be automatically generated by the spreadsheet client application 4 or authored by hand by a user. The metadata 26 may be stored within the workbook 6 and saved with the workbook. The metadata may be utilized by the server computer 12A when receiving and responding to requests to access the data objects within the workbook as server data sources. As an example, the spreadsheet application program 10 may create metadata 26 for a field in a workbook entitled "ZIP CODE." The metadata 26 may indicate the name of the field and may set a data type for the field as a number. The metadata 26 may also indicate that the default aggregation for the field is a "sum." This process may be performed in an automated fashion by the spreadsheet application program 4 when the data source is created, when the data source is published, or in response to a user request to generate the metadata.
It should be appreciated that, in embodiments of the invention, the spreadsheet client application program 4 is operative to provide a facility for allowing a user to edit the metadata 26 created by the spreadsheet application program 4 for the data objects contained in a workbook 6. For instance, using the above example, a user may deem it inappropriate to generate a sum of zip codes. Accordingly, the user may utilize a facility provided by the spreadsheet client application 4 to edit the metadata 26 to indicate that the default aggregation for the "ZIP CODE" field should not be a sum, but should rather be a count. The modified metadata 26 may then be persisted to the workbook 6 and published to the server computer 12A. In this manner, the server computer 12A can better respond to data source requests for data contained in this field.
An illustrative user interface for editing the metadata 26 generated for the data objects in a workbook by the spreadsheet client application 4 will be described in greater detail below with respect to FIGURE 4.
It should be appreciated that the server computers 12A-12C may include many of the conventional computing components illustrated in FIGURE 2 and described above. Additionally, the server computer 12A may be operative to store and execute a spreadsheet server application 13. The file server computer 12C may be operative to store and execute a file server application 28 for receiving and responding to requests for files stored in the repository 14, such as a workbook 6. It should be appreciated that the server computers 12A-12C may include other conventional components not illustrated in FIGURE 2 but known to those skilled in the art.
Referring now to FIGURE 3, an illustrative routine 300 will be described illustrating a process performed by the spreadsheet client application program 4 for publishing a workbook range as a server data source. When reading the discussion of the routines presented herein, it should be appreciated that the logical operations of various embodiments of the present invention are implemented (1) as a sequence of computer implemented acts or program modules running on a computing system and/or (2) as interconnected machine logic circuits or circuit modules within the computing system. The implementation is a matter of choice dependent on the performance requirements of the computing system implementing the invention. Accordingly, the logical operations illustrated in FIGURES 3 and 5, and making up the embodiments of the present invention described herein are referred to variously as operations, structural devices, acts or modules. It will be recognized by one skilled in the art that these operations, structural devices, acts and modules may be implemented in software, in firmware, in special purpose digital logic, and any combination thereof without deviating from the scope of the present invention as recited within the claims set forth herein.
= 51331-220 The routine 300 begins at operation 302, where a user utilizes the spreadsheet client application 4 to author the workbook 6. In particular, as described herein, the user may utilize the various facilities provided by the spreadsheet client application 4 to create data objects within the workbook including ranges of cells, pivot tables, DOEs, lists, databases, query tables, and other data objects. The user also may manually enter data or create a query in the workbook 6 of a data source 16.
The various functions and methodologies that may be utilized within a spreadsheet client application 4 to create a workbook 6 are virtually unlimited and well-known to those skilled in the art.
From operation 302, the routine 300 continues to operation 304, where the spreadsheet client application 4 generates the metadata 26 for use by the server application 13 in responding to requests to access the workbook 6 as a data source. In particular, the spreadsheet client application 4 may analyze the various data sources contained within the workbook 6 to identify data that may be utilized to describe the various data sources within the workbook 6. For instance, with respect to a relational data source, the spreadsheet client application 4 may identify the names of the columns and the various data types of the data sources contained with the workbook 6.
With respect to multidimensional data sources, the spreadsheet client application 4 may identify measures, hierarchy, and default aggregations for the various data sources.
Values for these properties may also be set by the spreadsheet client application 4 in an intelligent manner. For instance, with respect to a string data field, the spreadsheet client application 4 may indicate the default aggregation as being a count. With regard to numeric data fields, the spreadsheet client application 4 may set the default aggregation to being a sum. Other types of intelligent decisions may be made by the spreadsheet client application 4 to identify metadata within the workbook 6 and to set properties for the metadata.
From operation 304, the routine 300 continues to operation 306, where the spreadsheet client application 4 determines whether a user has made a request to edit the metadata generated by the spreadsheet client application 4. As described briefly above, the spreadsheet client application 4 may provide a user interface for editing the generated metadata. This may be useful, for instance, to allow a user to override the intelligent decisions made by the spreadsheet client application 4 when identifying metadata within the workbook 6 and setting various properties on the metadata.
If, at operation 306, the spreadsheet client application 4 determines that a request to edit the metadata has been received, the routine 300 branches to operation 308. At operation 308, the spreadsheet client application 4 receives edited metadata from the user. An illustrative user interface for permitting a user to edit the metadata will be described in greater detail below with respect to FIGURE 4. From operation 308, the routine 300 continues to operation 310.
If, at operation 306, the spreadsheet client application 4 determines that a request to edit the metadata has not been received, the routine 300 continues to operation 310. At operation 310, the metadata 26 generated by the spreadsheet client application 4, and potentially edited by the user, is saved with the workbook 6. Saving of the workbook 6 may occur automatically or may occur in response to a user request.
From operation 310, the routine 300 continues to operation 312, where the workbook 6, including the metadata 26, is published to the spreadsheet server application 13. Publication of the workbook 6 may occur in response to a user command or may occur automatically. For instance, publication of the workbook may include uploading a spreadsheet to the server computer 12A or programmatically generating a spreadsheet and sending it to the server computer 12A through the server application program interface ("API"). When the workbook 6 is published to the spreadsheet server application 13, the workbook 6 is stored in the repository 14. The spreadsheet server application 13 is also notified of the existence of the workbook 6 and the various data objects contained with the workbook may then be exposed as server data sources. It should be appreciated that the user may be permitted to specify which of the various data objects within the workbook 6 are exposed by the spreadsheet server application 13 as data sources. Alternatively, all of the data objects within a workbook 6 may be exposed as data objects or a user may be permitted to indicate that no data objects within the workbook 6 are exposed as data sources.
Once the workbook 6 has been propagated to the repository 14 and analyzed by the spreadsheet server application 13, database client applications, such as the OLAP client application 8 or the spreadsheet client application 4, may be utilized to query the contents of the workbook 6 as a data source. Additional details regarding the various functions performed by the spreadsheet server application 13 in order to expose the contents of the workbook 6 as a data source and to receive and respond to data source query requests will be described in greater detail below with respect to FIGURE
5. From operation 312, the routine 300 continues to operation 314, where it ends.
Referring now to FIGURE 4, an illustrative user interface will be described for allowing a user to edit the metadata generated by the spreadsheet client application 4 for the various data sources contained within a workbook 6.
shows a user interface window 30 including a number of user interface components for editing the metadata. In particular, a list box 32 is provided that lists each of the available fields 34A-34N for the data sources contained in the workbook 6.
Relationships between the various fields 34A-34N may be illustrated within the list box 32 to indicate the relationships between the various fields identified by the spreadsheet client application 4. For instance, as shown in FIGURE 4, the time, year, month, and date fields may be indented from one another to indicate the hierarchy among the various fields.
Several user interface buttons 36A-36F may also be provided to allow the user to arrange the order and hierarchy of the fields 34A-34N shown in the list box 32. For instance, the user interface buttons 36A-36D, allow the user to arrange the various fields up, down, right, or left, respectively. User interface button 36E may be utilized to copy one of the fields 34A-34N and the user interface button 36F
may be utilized to create a new data field.
As also shown in FIGURE 4, one of the fields identified in the list box 32 may be selected by a user and the properties for the field may be shown in the user interface window 30. For instance, as shown in FIGURE 4, the field 34N
representing a zip code has been selected. Accordingly, the field name is displayed utilizing text 38.
The data type and aggregation assigned to the zip code field by the spreadsheet client application 4 are also shown. A dropdown menu 40A may be provided for changing the properties of the data type from a number to a string, for instance.
Similarly, a dropdown menu 40B may be provided for allowing a user to change the value of the aggregation field from a sum to a count. It should be appreciated that other types of editing operations may be permitted through the user interface window 30 other than those illustrated in FIGURE 4 and described herein. When a user has completed editing, the button 42 may be selected to persist the modifications or the button 44 may be selected to cancel the changes.
Turning now to FIGURE 5, an illustrative routine 500 will be described illustrating the operation of the spreadsheet server application 13 for receiving and responding to requests for workbook ranges as data sources. The routine 500 begins at operation 502, where the spreadsheet server application 13 exposes the various ranges of workbooks contained within the repository 14 as server data sources.
According to one embodiment of the invention, the data sources are exposed through a data connection manager such as the one described in the concurrently filed United States Patent application publication No. US 2005/0278307 entitled "Method, System, and Apparatus for Discovering and Connecting to Data Sources". Alternatively, the data sources contained within the workbook stored within the repository 14 may be exposed utilizing other types of analysis server interfaces, such as UDM. Once the spreadsheet server application 13 has exposed the various data sources, a client application such as the OLAP client application 8 or the spreadsheet client application 4 may discover sources and issue requests querying the various data sources.
The routine 500 continues from operation 502 to operation 504, where the spreadsheet server application 13 receives a request to connect to a workbook as a server data source. For instance, at operation 506, a spreadsheet server application 13 may receive a native query against a data object contained within a range of a workbook. For instance, the OLAP client application may issue a native OLAP
query to the spreadsheet server application 13. Alternatively, other types of queries may be issued to the spreadsheet server application 13 such as ODB, ODBC, XML-A, and SQL
queries. Other types of standards for querying a database known to those skilled in the art may also be utilized.
At operation 508, the spreadsheet server application 13 loads the workbook 6 containing the data source to which a query has been directed. Once the workbook 6 has been loaded by the spreadsheet server application 13, the routine 500 continues to operation 510, where the spreadsheet server application 13 determines whether the workbook 6 includes a reference to another data source. For instance, as described briefly above, the workbook may include a reference to a data source, such as the data source 16.
If the workbook 6 includes a reference to another data source, the routine 500 branches to operation 512, where the spreadsheet server application 13 queries the data source 16 for any data needed to calculate the workbook 6. Once this data is received by the spreadsheet server application 13, the workbook 6 is updated with the received data.
If, at operation 510, it is determined that the workbook 6 does not include a reference to another data source, the routine 500 continues to operation 514.
At operation 514, the spreadsheet server application 13 recalculates the contents of the workbook 6. It will be appreciated that the recalculation of the contents of the workbook may be a "big value-add." A "big value-add" enables spreadsheet calculations in a server data source. From operation 514, the routine 500 continues to operation 516, where the spreadsheet server application 13 generates a database representation of the recalculated workbook. In particular, a temporary database representation, such as a relational database or OLAP cube, is generated by the spreadsheet server application 13. The database representation is generated temporarily in order to perform the requested query over the identified data source.
Once the database representation of the requested workbook has been generated, the routine 500 continues to operation 518, where the spreadsheet server application 13 performs the requested query on the database representation of the recalculated workbook. In response to performing the query, a query result is generated that satisfies the initial query received from the client application. From operation 518, the routine 500 continues to operation 520, where the spreadsheet server application 13 responds to the original query request with the identified query result. From operation 520, the routine 500 continues to operation 522, where it ends.
Based on the foregoing, it should be appreciated that the various embodiments of the invention include a method, system, apparatus, and computer-readable medium for exposing and utilizing ranges within a workbook as server data sources. The above specification, examples and data provide a complete description of the manufacture and use of the composition of the invention. Since many embodiments of the invention can be made without departing from the scope of the invention, the invention resides in the claims hereinafter appended.
CORPORATION of Redmond, Washington. The mass storage device 24 and RAM 9 may also store one or more program modules. In particular, the mass storage device 24 and the RAM 9 may store a spreadsheet client application 4 and an OLAP client application 8, as described above. The mass storage device 24 and RAM 9 may also store a workbook 6 created by the spreadsheet client application 4.
According to one embodiment of the invention, the spreadsheet application program 4 is also be operative to generate metadata 26 for each of the data objects contained within a workbook. The metadata 26 may be automatically generated by the spreadsheet client application 4 or authored by hand by a user. The metadata 26 may be stored within the workbook 6 and saved with the workbook. The metadata may be utilized by the server computer 12A when receiving and responding to requests to access the data objects within the workbook as server data sources. As an example, the spreadsheet application program 10 may create metadata 26 for a field in a workbook entitled "ZIP CODE." The metadata 26 may indicate the name of the field and may set a data type for the field as a number. The metadata 26 may also indicate that the default aggregation for the field is a "sum." This process may be performed in an automated fashion by the spreadsheet application program 4 when the data source is created, when the data source is published, or in response to a user request to generate the metadata.
It should be appreciated that, in embodiments of the invention, the spreadsheet client application program 4 is operative to provide a facility for allowing a user to edit the metadata 26 created by the spreadsheet application program 4 for the data objects contained in a workbook 6. For instance, using the above example, a user may deem it inappropriate to generate a sum of zip codes. Accordingly, the user may utilize a facility provided by the spreadsheet client application 4 to edit the metadata 26 to indicate that the default aggregation for the "ZIP CODE" field should not be a sum, but should rather be a count. The modified metadata 26 may then be persisted to the workbook 6 and published to the server computer 12A. In this manner, the server computer 12A can better respond to data source requests for data contained in this field.
An illustrative user interface for editing the metadata 26 generated for the data objects in a workbook by the spreadsheet client application 4 will be described in greater detail below with respect to FIGURE 4.
It should be appreciated that the server computers 12A-12C may include many of the conventional computing components illustrated in FIGURE 2 and described above. Additionally, the server computer 12A may be operative to store and execute a spreadsheet server application 13. The file server computer 12C may be operative to store and execute a file server application 28 for receiving and responding to requests for files stored in the repository 14, such as a workbook 6. It should be appreciated that the server computers 12A-12C may include other conventional components not illustrated in FIGURE 2 but known to those skilled in the art.
Referring now to FIGURE 3, an illustrative routine 300 will be described illustrating a process performed by the spreadsheet client application program 4 for publishing a workbook range as a server data source. When reading the discussion of the routines presented herein, it should be appreciated that the logical operations of various embodiments of the present invention are implemented (1) as a sequence of computer implemented acts or program modules running on a computing system and/or (2) as interconnected machine logic circuits or circuit modules within the computing system. The implementation is a matter of choice dependent on the performance requirements of the computing system implementing the invention. Accordingly, the logical operations illustrated in FIGURES 3 and 5, and making up the embodiments of the present invention described herein are referred to variously as operations, structural devices, acts or modules. It will be recognized by one skilled in the art that these operations, structural devices, acts and modules may be implemented in software, in firmware, in special purpose digital logic, and any combination thereof without deviating from the scope of the present invention as recited within the claims set forth herein.
= 51331-220 The routine 300 begins at operation 302, where a user utilizes the spreadsheet client application 4 to author the workbook 6. In particular, as described herein, the user may utilize the various facilities provided by the spreadsheet client application 4 to create data objects within the workbook including ranges of cells, pivot tables, DOEs, lists, databases, query tables, and other data objects. The user also may manually enter data or create a query in the workbook 6 of a data source 16.
The various functions and methodologies that may be utilized within a spreadsheet client application 4 to create a workbook 6 are virtually unlimited and well-known to those skilled in the art.
From operation 302, the routine 300 continues to operation 304, where the spreadsheet client application 4 generates the metadata 26 for use by the server application 13 in responding to requests to access the workbook 6 as a data source. In particular, the spreadsheet client application 4 may analyze the various data sources contained within the workbook 6 to identify data that may be utilized to describe the various data sources within the workbook 6. For instance, with respect to a relational data source, the spreadsheet client application 4 may identify the names of the columns and the various data types of the data sources contained with the workbook 6.
With respect to multidimensional data sources, the spreadsheet client application 4 may identify measures, hierarchy, and default aggregations for the various data sources.
Values for these properties may also be set by the spreadsheet client application 4 in an intelligent manner. For instance, with respect to a string data field, the spreadsheet client application 4 may indicate the default aggregation as being a count. With regard to numeric data fields, the spreadsheet client application 4 may set the default aggregation to being a sum. Other types of intelligent decisions may be made by the spreadsheet client application 4 to identify metadata within the workbook 6 and to set properties for the metadata.
From operation 304, the routine 300 continues to operation 306, where the spreadsheet client application 4 determines whether a user has made a request to edit the metadata generated by the spreadsheet client application 4. As described briefly above, the spreadsheet client application 4 may provide a user interface for editing the generated metadata. This may be useful, for instance, to allow a user to override the intelligent decisions made by the spreadsheet client application 4 when identifying metadata within the workbook 6 and setting various properties on the metadata.
If, at operation 306, the spreadsheet client application 4 determines that a request to edit the metadata has been received, the routine 300 branches to operation 308. At operation 308, the spreadsheet client application 4 receives edited metadata from the user. An illustrative user interface for permitting a user to edit the metadata will be described in greater detail below with respect to FIGURE 4. From operation 308, the routine 300 continues to operation 310.
If, at operation 306, the spreadsheet client application 4 determines that a request to edit the metadata has not been received, the routine 300 continues to operation 310. At operation 310, the metadata 26 generated by the spreadsheet client application 4, and potentially edited by the user, is saved with the workbook 6. Saving of the workbook 6 may occur automatically or may occur in response to a user request.
From operation 310, the routine 300 continues to operation 312, where the workbook 6, including the metadata 26, is published to the spreadsheet server application 13. Publication of the workbook 6 may occur in response to a user command or may occur automatically. For instance, publication of the workbook may include uploading a spreadsheet to the server computer 12A or programmatically generating a spreadsheet and sending it to the server computer 12A through the server application program interface ("API"). When the workbook 6 is published to the spreadsheet server application 13, the workbook 6 is stored in the repository 14. The spreadsheet server application 13 is also notified of the existence of the workbook 6 and the various data objects contained with the workbook may then be exposed as server data sources. It should be appreciated that the user may be permitted to specify which of the various data objects within the workbook 6 are exposed by the spreadsheet server application 13 as data sources. Alternatively, all of the data objects within a workbook 6 may be exposed as data objects or a user may be permitted to indicate that no data objects within the workbook 6 are exposed as data sources.
Once the workbook 6 has been propagated to the repository 14 and analyzed by the spreadsheet server application 13, database client applications, such as the OLAP client application 8 or the spreadsheet client application 4, may be utilized to query the contents of the workbook 6 as a data source. Additional details regarding the various functions performed by the spreadsheet server application 13 in order to expose the contents of the workbook 6 as a data source and to receive and respond to data source query requests will be described in greater detail below with respect to FIGURE
5. From operation 312, the routine 300 continues to operation 314, where it ends.
Referring now to FIGURE 4, an illustrative user interface will be described for allowing a user to edit the metadata generated by the spreadsheet client application 4 for the various data sources contained within a workbook 6.
shows a user interface window 30 including a number of user interface components for editing the metadata. In particular, a list box 32 is provided that lists each of the available fields 34A-34N for the data sources contained in the workbook 6.
Relationships between the various fields 34A-34N may be illustrated within the list box 32 to indicate the relationships between the various fields identified by the spreadsheet client application 4. For instance, as shown in FIGURE 4, the time, year, month, and date fields may be indented from one another to indicate the hierarchy among the various fields.
Several user interface buttons 36A-36F may also be provided to allow the user to arrange the order and hierarchy of the fields 34A-34N shown in the list box 32. For instance, the user interface buttons 36A-36D, allow the user to arrange the various fields up, down, right, or left, respectively. User interface button 36E may be utilized to copy one of the fields 34A-34N and the user interface button 36F
may be utilized to create a new data field.
As also shown in FIGURE 4, one of the fields identified in the list box 32 may be selected by a user and the properties for the field may be shown in the user interface window 30. For instance, as shown in FIGURE 4, the field 34N
representing a zip code has been selected. Accordingly, the field name is displayed utilizing text 38.
The data type and aggregation assigned to the zip code field by the spreadsheet client application 4 are also shown. A dropdown menu 40A may be provided for changing the properties of the data type from a number to a string, for instance.
Similarly, a dropdown menu 40B may be provided for allowing a user to change the value of the aggregation field from a sum to a count. It should be appreciated that other types of editing operations may be permitted through the user interface window 30 other than those illustrated in FIGURE 4 and described herein. When a user has completed editing, the button 42 may be selected to persist the modifications or the button 44 may be selected to cancel the changes.
Turning now to FIGURE 5, an illustrative routine 500 will be described illustrating the operation of the spreadsheet server application 13 for receiving and responding to requests for workbook ranges as data sources. The routine 500 begins at operation 502, where the spreadsheet server application 13 exposes the various ranges of workbooks contained within the repository 14 as server data sources.
According to one embodiment of the invention, the data sources are exposed through a data connection manager such as the one described in the concurrently filed United States Patent application publication No. US 2005/0278307 entitled "Method, System, and Apparatus for Discovering and Connecting to Data Sources". Alternatively, the data sources contained within the workbook stored within the repository 14 may be exposed utilizing other types of analysis server interfaces, such as UDM. Once the spreadsheet server application 13 has exposed the various data sources, a client application such as the OLAP client application 8 or the spreadsheet client application 4 may discover sources and issue requests querying the various data sources.
The routine 500 continues from operation 502 to operation 504, where the spreadsheet server application 13 receives a request to connect to a workbook as a server data source. For instance, at operation 506, a spreadsheet server application 13 may receive a native query against a data object contained within a range of a workbook. For instance, the OLAP client application may issue a native OLAP
query to the spreadsheet server application 13. Alternatively, other types of queries may be issued to the spreadsheet server application 13 such as ODB, ODBC, XML-A, and SQL
queries. Other types of standards for querying a database known to those skilled in the art may also be utilized.
At operation 508, the spreadsheet server application 13 loads the workbook 6 containing the data source to which a query has been directed. Once the workbook 6 has been loaded by the spreadsheet server application 13, the routine 500 continues to operation 510, where the spreadsheet server application 13 determines whether the workbook 6 includes a reference to another data source. For instance, as described briefly above, the workbook may include a reference to a data source, such as the data source 16.
If the workbook 6 includes a reference to another data source, the routine 500 branches to operation 512, where the spreadsheet server application 13 queries the data source 16 for any data needed to calculate the workbook 6. Once this data is received by the spreadsheet server application 13, the workbook 6 is updated with the received data.
If, at operation 510, it is determined that the workbook 6 does not include a reference to another data source, the routine 500 continues to operation 514.
At operation 514, the spreadsheet server application 13 recalculates the contents of the workbook 6. It will be appreciated that the recalculation of the contents of the workbook may be a "big value-add." A "big value-add" enables spreadsheet calculations in a server data source. From operation 514, the routine 500 continues to operation 516, where the spreadsheet server application 13 generates a database representation of the recalculated workbook. In particular, a temporary database representation, such as a relational database or OLAP cube, is generated by the spreadsheet server application 13. The database representation is generated temporarily in order to perform the requested query over the identified data source.
Once the database representation of the requested workbook has been generated, the routine 500 continues to operation 518, where the spreadsheet server application 13 performs the requested query on the database representation of the recalculated workbook. In response to performing the query, a query result is generated that satisfies the initial query received from the client application. From operation 518, the routine 500 continues to operation 520, where the spreadsheet server application 13 responds to the original query request with the identified query result. From operation 520, the routine 500 continues to operation 522, where it ends.
Based on the foregoing, it should be appreciated that the various embodiments of the invention include a method, system, apparatus, and computer-readable medium for exposing and utilizing ranges within a workbook as server data sources. The above specification, examples and data provide a complete description of the manufacture and use of the composition of the invention. Since many embodiments of the invention can be made without departing from the scope of the invention, the invention resides in the claims hereinafter appended.
Claims (13)
1. A method for exposing data objects of a workbook as a server data source, comprising:
generating metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a first server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprises analyzing the data objects to identify the following: data types, measures, hierarchy, and default aggregations, and wherein setting the properties comprises indicating a first default aggregation as a count for a string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata;
publishing the workbook and the metadata to the first server computer, wherein publishing comprises programmatically generating a spreadsheet and sending the spreadsheet to the first server computer through a server application program interface, wherein the workbook is parsed for ranges including the data objects by a spreadsheet server application executing on the first server computer, and wherein user-specified data objects from among the data objects are exposed at the first server computer as server data sources; and connecting to the data object exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer.
generating metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a first server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprises analyzing the data objects to identify the following: data types, measures, hierarchy, and default aggregations, and wherein setting the properties comprises indicating a first default aggregation as a count for a string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata;
publishing the workbook and the metadata to the first server computer, wherein publishing comprises programmatically generating a spreadsheet and sending the spreadsheet to the first server computer through a server application program interface, wherein the workbook is parsed for ranges including the data objects by a spreadsheet server application executing on the first server computer, and wherein user-specified data objects from among the data objects are exposed at the first server computer as server data sources; and connecting to the data object exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer.
2. The method of Claim 1, further comprising:
receiving a request from a user to edit the metadata for data objects; and in response to the request to edit the metadata, providing a facility for allowing a user to edit the metadata.
receiving a request from a user to edit the metadata for data objects; and in response to the request to edit the metadata, providing a facility for allowing a user to edit the metadata.
3. The method of Claim 1, wherein the metadata is editable.
4. A method for exposing and utilizing data objects within a workbook as a server data source, comprising:
generating metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a first server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprises analyzing the data objects to identify the following: data types, measures, hierarchy, and default aggregations, and wherein setting the properties comprises indicating a first default aggregation as a count for a string field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata;
publishing the workbook and the metadata to the first server computer, wherein the workbook is parsed for ranges including the data objects by a spreadsheet server application executing on the first server computer;
exposing the data objects as server data sources;
connecting to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer;
receiving a data source query at the first server computer referencing data contained within one of the data objects;
in response to receiving the data source query, loading the workbook and calculating the workbook, including calculating a value of the data objects;
generating a temporary database representation of the data objects utilizing the metadata, wherein the temporary database representation comprises an OLAP
cube;
performing the data source query on the database representation of the data objects to create a query result; and responding to the query with the query result.
generating metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a first server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprises analyzing the data objects to identify the following: data types, measures, hierarchy, and default aggregations, and wherein setting the properties comprises indicating a first default aggregation as a count for a string field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata;
publishing the workbook and the metadata to the first server computer, wherein the workbook is parsed for ranges including the data objects by a spreadsheet server application executing on the first server computer;
exposing the data objects as server data sources;
connecting to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer;
receiving a data source query at the first server computer referencing data contained within one of the data objects;
in response to receiving the data source query, loading the workbook and calculating the workbook, including calculating a value of the data objects;
generating a temporary database representation of the data objects utilizing the metadata, wherein the temporary database representation comprises an OLAP
cube;
performing the data source query on the database representation of the data objects to create a query result; and responding to the query with the query result.
5. The method of Claim 4, further comprising prior to calculating the workbook:
determining whether the workbook contains a reference to a data source;
in response to determining that that the workbook contains a reference to a data source, retrieving data from the data source necessary to calculate the workbook; and calculating the workbook, including calculating the value of the data objects in view of the data retrieved from the data source.
determining whether the workbook contains a reference to a data source;
in response to determining that that the workbook contains a reference to a data source, retrieving data from the data source necessary to calculate the workbook; and calculating the workbook, including calculating the value of the data objects in view of the data retrieved from the data source.
6. A system for exposing and utilizing data objects within a workbook as a server data source, the system comprising:
a client computer configured to execute a spreadsheet application program for authoring a workbook having data objects, wherein the spreadsheet application program generates metadata utilized by a server application and publishes the workbook to a first server computer, wherein publishing comprises programmatically generating a spreadsheet, wherein the spreadsheet application program is further configured to generate metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprising analyzing the data objects to identify the following: data types, measures, hierarchy, and default aggregations, wherein setting the properties comprises indicating a first default aggregation as a count for the string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata, wherein the spreadsheet application is further configured to connect to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer; and the first server computer configured to receive the spreadsheet from the client computer through a server application program interface, to parse the workbook for ranges including the data objects, and to execute a server program for exposing user specified objects from among 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.
a client computer configured to execute a spreadsheet application program for authoring a workbook having data objects, wherein the spreadsheet application program generates metadata utilized by a server application and publishes the workbook to a first server computer, wherein publishing comprises programmatically generating a spreadsheet, wherein the spreadsheet application program is further configured to generate metadata for the data objects by automatically identifying the metadata in the workbook and setting properties for the identified metadata, wherein the metadata is utilized by a server computer in responding to requests for the data objects stored in the workbook as a server data source, the server data source comprising a multidimensional database, wherein identifying the metadata comprising analyzing the data objects to identify the following: data types, measures, hierarchy, and default aggregations, wherein setting the properties comprises indicating a first default aggregation as a count for the string data field in the metadata and setting a second default aggregation as a sum for a numeric data field in the metadata, wherein the spreadsheet application is further configured to connect to the data objects exposed at the first server computer as server data sources in a manner identical to connecting to a dedicated OLAP data source provided by a second server computer; and the first server computer configured to receive the spreadsheet from the client computer through a server application program interface, to parse the workbook for ranges including the data objects, and to execute a server program for exposing user specified objects from among 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.
7. The system of Claim 6, wherein the spreadsheet application program is further configured to provide a facility for allowing a user to edit the metadata.
8. The system of Claim 7, further comprising a second client computer configured to execute an application program for issuing queries against a server data source, and wherein the server program is further configured to receive and respond to a database query from the second client computer to the server data source.
9. The system of Claim 8, wherein responding to a database query from the second client computer comprises:
recalculating the workbook;
generating a temporary database representation of the recalculated workbook, wherein the temporary database representation comprises an OLAP cube;
performing the database query on the database representation of the recalculated workbook to obtain a query result; and transmitting the query result to the second client computer as a response to the database query.
recalculating the workbook;
generating a temporary database representation of the recalculated workbook, wherein the temporary database representation comprises an OLAP cube;
performing the database query on the database representation of the recalculated workbook to obtain a query result; and transmitting the query result to the second client computer as a response to the database query.
10. The system of Claim 9, wherein responding to a database query from the second client computer further comprises:
determining whether the workbook contains a reference to a data source;
in response to determining that the workbook contains a reference to a data source, retrieving from the data source the data necessary to calculate the workbook; and recalculating the workbook utilizing the data retrieved from the data source.
determining whether the workbook contains a reference to a data source;
in response to determining that the workbook contains a reference to a data source, retrieving from the data source the data necessary to calculate the workbook; and recalculating the workbook utilizing the data retrieved from the data source.
11. The system of Claim 10, wherein the application executing on the second client computer comprises an OLAP client application.
12. A computer-readable storage medium having computer-executable instructions stored thereon that, when executed by a computer, cause the computer to perform the method of any one of Claims 1 to 5.
13. A computer-controlled apparatus configured to perform the method of any one of Claims 1 to 5.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US10/858,175 US7664804B2 (en) | 2004-06-01 | 2004-06-01 | Method, system, and apparatus for exposing workbook ranges as data sources |
| US10/858,175 | 2004-06-01 |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CA2508933A1 CA2508933A1 (en) | 2005-12-01 |
| CA2508933C true CA2508933C (en) | 2015-10-06 |
Family
ID=35063258
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA2508933A Active CA2508933C (en) | 2004-06-01 | 2005-05-31 | Method, system, and apparatus for exposing workbook ranges as data sources |
Country Status (20)
| Country | Link |
|---|---|
| US (1) | US7664804B2 (en) |
| EP (1) | EP1605367B1 (en) |
| JP (1) | JP4907906B2 (en) |
| KR (1) | KR101122947B1 (en) |
| CN (1) | CN100547586C (en) |
| AU (1) | AU2005202284B2 (en) |
| BR (1) | BRPI0501959B1 (en) |
| CA (1) | CA2508933C (en) |
| CO (1) | CO5710208A1 (en) |
| EG (1) | EG23841A (en) |
| HK (1) | HK1085818A1 (en) |
| IL (1) | IL168620A (en) |
| MX (1) | MXPA05005856A (en) |
| MY (1) | MY142330A (en) |
| NO (1) | NO332884B1 (en) |
| NZ (1) | NZ540421A (en) |
| RU (1) | RU2406147C2 (en) |
| SG (1) | SG117588A1 (en) |
| TW (1) | TWI411928B (en) |
| ZA (1) | ZA200504159B (en) |
Families Citing this family (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7226791B2 (en) * | 2003-06-02 | 2007-06-05 | Bristol-Myers Squibb Company | Polynucleotides encoding novel guanylate binding proteins (GBP's) |
| US7664804B2 (en) | 2004-06-01 | 2010-02-16 | Microsoft Corporation | Method, system, and apparatus for exposing workbook ranges as data sources |
| US7991804B2 (en) * | 2004-07-30 | 2011-08-02 | Microsoft Corporation | Method, system, and apparatus for exposing workbooks as data sources |
| US8578399B2 (en) | 2004-07-30 | 2013-11-05 | Microsoft Corporation | Method, system, and apparatus for providing access to workbook models through remote function cells |
| US7533139B2 (en) * | 2004-09-27 | 2009-05-12 | Microsoft Corporation | Method and system for multithread processing of spreadsheet chain calculations |
| US8055995B2 (en) * | 2005-03-11 | 2011-11-08 | Orangescape Technologies Limited | System and method of defining a hierarchical datamodel and related computation and instruction rules using spreadsheet like user interface |
| EP1955143A4 (en) * | 2005-11-15 | 2011-04-27 | Rockwell Automation Inc | Integrated programmer reference for industrial control device data |
| US8032821B2 (en) * | 2006-05-08 | 2011-10-04 | Microsoft Corporation | Multi-thread spreadsheet processing with dependency levels |
| US7937426B2 (en) * | 2006-06-30 | 2011-05-03 | Mircosoft Corporation | Interval generation for numeric data |
| US20080046861A1 (en) * | 2006-08-15 | 2008-02-21 | Grieser Maria A | Method and interface for creating a workbook to implement a business process |
| US20080126395A1 (en) * | 2006-11-28 | 2008-05-29 | Ocyrhoe Technologies Ltd | Automatically creating a relational database from a spreadsheet |
| US20080229184A1 (en) * | 2007-03-15 | 2008-09-18 | Microsoft Corporation | Private sheets in shared spreadsheets |
| US20080243763A1 (en) * | 2007-03-27 | 2008-10-02 | International Business Machines Corporation | System, method and program to provide data to another program |
| US10133719B2 (en) * | 2007-09-28 | 2018-11-20 | Microsoft Technology Licensing, Llc | Spreadsheet workbook part libraries |
| US20090089315A1 (en) * | 2007-09-28 | 2009-04-02 | Tractmanager, Inc. | System and method for associating metadata with electronic documents |
| US8121975B2 (en) * | 2008-02-20 | 2012-02-21 | Panorama Software Inc. | Creating pivot tables from tabular data |
| US8281233B2 (en) | 2009-06-15 | 2012-10-02 | Microsoft Corporation | Architecture to expose internal business data on a website |
| US8458186B2 (en) * | 2009-11-06 | 2013-06-04 | Symantec Corporation | Systems and methods for processing and managing object-related data for use by a plurality of applications |
| US20110161796A1 (en) * | 2009-12-31 | 2011-06-30 | Edward Charles Laikin | FormDB: a process to create a forms database in Excel without user programming |
| US20110225579A1 (en) * | 2010-03-12 | 2011-09-15 | Nikhil Khandelwal | Configurable software deployment |
| US9952893B2 (en) | 2010-11-03 | 2018-04-24 | Microsoft Technology Licensing, Llc | Spreadsheet model for distributed computations |
| US10140352B2 (en) * | 2014-07-17 | 2018-11-27 | Oracle International Corporation | Interfacing with a relational database for multi-dimensional analysis via a spreadsheet application |
| CN109815235B (en) * | 2018-12-29 | 2021-10-15 | 东软集团股份有限公司 | Method and device for generating data source, storage medium and electronic equipment |
| US11886916B2 (en) | 2020-06-30 | 2024-01-30 | Microsoft Technology Licensing, Llc | System for adaptive multithreaded recalculation operations |
Family Cites Families (58)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP3107826B2 (en) * | 1992-06-16 | 2000-11-13 | サムスン エレクトロニクス カンパニー リミテッド | HDTV recording and playback system with reverse compatibility |
| US5437006A (en) * | 1993-01-27 | 1995-07-25 | Microsoft Corporation | Spreadsheet command/function capability from a dynamic-link library |
| US5701451A (en) * | 1995-06-07 | 1997-12-23 | International Business Machines Corporation | Method for fulfilling requests of a web browser |
| US5893123A (en) * | 1995-06-22 | 1999-04-06 | Tuinenga; Paul W. | System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet |
| US6157934A (en) * | 1995-10-24 | 2000-12-05 | Ultimus, L.L.C. | Method and apparatus for using distributed spreadsheets in a client/server architecture for workflow automation |
| US5890174A (en) * | 1995-11-16 | 1999-03-30 | Microsoft Corporation | Method and system for constructing a formula in a spreadsheet |
| US6055548A (en) * | 1996-06-03 | 2000-04-25 | Microsoft Corporation | Computerized spreadsheet with auto-calculator |
| US5937406A (en) * | 1997-01-31 | 1999-08-10 | Informix Software, Inc. | File system interface to a database |
| US5933818A (en) | 1997-06-02 | 1999-08-03 | Electronic Data Systems Corporation | Autonomous knowledge discovery system and method |
| US6282548B1 (en) * | 1997-06-21 | 2001-08-28 | Alexa Internet | Automatically generate and displaying metadata as supplemental information concurrently with the web page, there being no link between web page and metadata |
| US6012057A (en) * | 1997-07-30 | 2000-01-04 | Quarterdeck Corporation | High speed data searching for information in a computer system |
| US6094651A (en) * | 1997-08-22 | 2000-07-25 | International Business Machines Corporation | Discovery-driven exploration of OLAP data cubes |
| US5974416A (en) * | 1997-11-10 | 1999-10-26 | Microsoft Corporation | Method of creating a tabular data stream for sending rows of data between client and server |
| JP2000067143A (en) * | 1998-08-26 | 2000-03-03 | Toshiba Corp | Data base system |
| US6269377B1 (en) * | 1998-09-21 | 2001-07-31 | Microsoft Corporation | System and method for managing locations of software components via a source list |
| US6430585B1 (en) * | 1998-09-21 | 2002-08-06 | Rn2R, L.L.C. | Noise tolerant conductance-based logic gate and methods of operation and manufacturing thereof |
| US6317750B1 (en) * | 1998-10-26 | 2001-11-13 | Hyperion Solutions Corporation | Method and apparatus for accessing multidimensional data |
| US6640234B1 (en) * | 1998-12-31 | 2003-10-28 | Microsoft Corporation | Extension of formulas and formatting in an electronic spreadsheet |
| US7032030B1 (en) * | 1999-03-11 | 2006-04-18 | John David Codignotto | Message publishing system and method |
| US6532458B1 (en) * | 1999-03-15 | 2003-03-11 | Microsoft Corporation | Sampling for database systems |
| US6549907B1 (en) * | 1999-04-22 | 2003-04-15 | Microsoft Corporation | Multi-dimensional database and data cube compression for aggregate query support on numeric dimensions |
| US6549935B1 (en) * | 1999-05-25 | 2003-04-15 | Silverbrook Research Pty Ltd | Method of distributing documents having common components to a plurality of destinations |
| US6411313B1 (en) * | 1999-06-14 | 2002-06-25 | Microsoft Corporation | User interface for creating a spreadsheet pivottable |
| US6701485B1 (en) * | 1999-06-15 | 2004-03-02 | Microsoft Corporation | Binding spreadsheet cells to objects |
| US6456999B1 (en) * | 1999-06-22 | 2002-09-24 | Microsoft Corporation | Aggregations size estimation in database services |
| US6477536B1 (en) * | 1999-06-22 | 2002-11-05 | Microsoft Corporation | Virtual cubes |
| US6446059B1 (en) * | 1999-06-22 | 2002-09-03 | Microsoft Corporation | Record for a multidimensional database with flexible paths |
| US6631497B1 (en) * | 1999-07-19 | 2003-10-07 | International Business Machines Corporation | Binding data from data source to cells in a spreadsheet |
| US6920443B1 (en) * | 1999-09-21 | 2005-07-19 | International Business Machines, Corporation | Method, system, program, and data structure for transforming database tables |
| US6898603B1 (en) * | 1999-10-15 | 2005-05-24 | Microsoft Corporation | Multi-dimensional data structure caching |
| US6493718B1 (en) * | 1999-10-15 | 2002-12-10 | Microsoft Corporation | Adaptive database caching and data retrieval mechanism |
| US6473750B1 (en) * | 1999-10-15 | 2002-10-29 | Microsoft Corporation | Adaptive query execution in a distributed database system |
| US7185279B2 (en) | 2000-01-07 | 2007-02-27 | Master Mine Software, Inc. | Data mining and reporting |
| AU2001236901A1 (en) * | 2000-02-11 | 2001-08-20 | David A Keeney Jr. | Method and system for distributing and collecting spreadsheet information |
| GB0011426D0 (en) * | 2000-05-11 | 2000-06-28 | Charteris Limited | A method for transforming documents written in different XML-based languages |
| US6632249B2 (en) * | 2000-06-23 | 2003-10-14 | Microsoft Corporation | Method for providing web-based services to an application program module |
| AU2002222963B2 (en) * | 2000-07-13 | 2007-05-10 | Oracle International Corporation | Performing spreadsheet-like calculations in a database system |
| US6944662B2 (en) * | 2000-08-04 | 2005-09-13 | Vinestone Corporation | System and methods providing automatic distributed data retrieval, analysis and reporting services |
| US7082569B2 (en) * | 2001-01-17 | 2006-07-25 | Outlooksoft Corporation | Systems and methods providing dynamic spreadsheet functionality |
| US6684206B2 (en) * | 2001-05-18 | 2004-01-27 | Hewlett-Packard Development Company, L.P. | OLAP-based web access analysis method and system |
| US20020188629A1 (en) * | 2001-05-21 | 2002-12-12 | Burfoot Daniel C. | System, protocol, and methods for the creation of distributed spreadsheets |
| US7761403B2 (en) * | 2001-06-20 | 2010-07-20 | Oracle International Corporation | Run-time optimizations of queries with SQL spreadsheet |
| US7177855B2 (en) * | 2001-06-20 | 2007-02-13 | Oracle International Corporation | Compile-time optimizations of queries with SQL spreadsheet |
| US7251776B2 (en) * | 2001-07-13 | 2007-07-31 | Netview Technologies, Inc. | System and method for efficiently and flexibly utilizing spreadsheet information |
| US20030195762A1 (en) * | 2002-04-12 | 2003-10-16 | David Gleason | Automated workflow |
| JP3868331B2 (en) * | 2002-05-20 | 2007-01-17 | 株式会社読売新聞東京本社 | Database registration apparatus and method |
| US7266763B2 (en) * | 2002-11-26 | 2007-09-04 | Microsoft Corporation | User defined spreadsheet functions |
| US20040103365A1 (en) * | 2002-11-27 | 2004-05-27 | Alan Cox | System, method, and computer program product for an integrated spreadsheet and database |
| US7530012B2 (en) * | 2003-05-22 | 2009-05-05 | International Business Machines Corporation | Incorporation of spreadsheet formulas of multi-dimensional cube data into a multi-dimensional cube |
| US7299223B2 (en) * | 2003-07-16 | 2007-11-20 | Oracle International Corporation | Spreadsheet to SQL translation |
| US7233956B2 (en) * | 2003-08-12 | 2007-06-19 | International Business Machines Corporation | Method and apparatus for data migration between databases |
| US7240052B2 (en) * | 2003-09-09 | 2007-07-03 | Iac Search & Media, Inc. | Refinement of a search query based on information stored on a local storage medium |
| US7664804B2 (en) | 2004-06-01 | 2010-02-16 | Microsoft Corporation | Method, system, and apparatus for exposing workbook ranges as data sources |
| US8578399B2 (en) | 2004-07-30 | 2013-11-05 | Microsoft Corporation | Method, system, and apparatus for providing access to workbook models through remote function cells |
| US7991804B2 (en) * | 2004-07-30 | 2011-08-02 | Microsoft Corporation | Method, system, and apparatus for exposing workbooks as data sources |
| US20060069617A1 (en) * | 2004-09-27 | 2006-03-30 | Scott Milener | Method and apparatus for prefetching electronic data for enhanced browsing |
| US7712049B2 (en) * | 2004-09-30 | 2010-05-04 | Microsoft Corporation | Two-dimensional radial user interface for computer software applications |
| US20060112123A1 (en) * | 2004-11-24 | 2006-05-25 | Macnica, Inc. | Spreadsheet user-interfaced business data visualization and publishing system |
-
2004
- 2004-06-01 US US10/858,175 patent/US7664804B2/en active Active
-
2005
- 2005-05-17 SG SG200503165A patent/SG117588A1/en unknown
- 2005-05-17 IL IL168620A patent/IL168620A/en unknown
- 2005-05-18 TW TW094116168A patent/TWI411928B/en not_active IP Right Cessation
- 2005-05-23 ZA ZA200504159A patent/ZA200504159B/en unknown
- 2005-05-24 AU AU2005202284A patent/AU2005202284B2/en not_active Ceased
- 2005-05-27 MY MYPI20052414A patent/MY142330A/en unknown
- 2005-05-27 CN CNB2005100896528A patent/CN100547586C/en active Active
- 2005-05-30 NZ NZ540421A patent/NZ540421A/en not_active IP Right Cessation
- 2005-05-30 EG EG2005050260A patent/EG23841A/en active
- 2005-05-30 KR KR1020050045690A patent/KR101122947B1/en active IP Right Grant
- 2005-05-31 BR BRPI0501959-1A patent/BRPI0501959B1/en not_active IP Right Cessation
- 2005-05-31 CA CA2508933A patent/CA2508933C/en active Active
- 2005-05-31 RU RU2005116632/08A patent/RU2406147C2/en active
- 2005-05-31 NO NO20052613A patent/NO332884B1/en not_active IP Right Cessation
- 2005-05-31 EP EP05104661.3A patent/EP1605367B1/en active Active
- 2005-06-01 CO CO05053195A patent/CO5710208A1/en not_active Application Discontinuation
- 2005-06-01 MX MXPA05005856A patent/MXPA05005856A/en active IP Right Grant
- 2005-06-01 JP JP2005161207A patent/JP4907906B2/en active Active
-
2006
- 2006-05-18 HK HK06105755.8A patent/HK1085818A1/en not_active IP Right Cessation
Also Published As
| Publication number | Publication date |
|---|---|
| AU2005202284A1 (en) | 2005-12-15 |
| US20050267853A1 (en) | 2005-12-01 |
| HK1085818A1 (en) | 2006-09-01 |
| JP2006004418A (en) | 2006-01-05 |
| CN1758247A (en) | 2006-04-12 |
| ZA200504159B (en) | 2006-08-30 |
| NZ540421A (en) | 2006-11-30 |
| NO20052613L (en) | 2005-12-02 |
| KR20060046285A (en) | 2006-05-17 |
| MY142330A (en) | 2010-11-15 |
| BRPI0501959A (en) | 2006-01-24 |
| KR101122947B1 (en) | 2012-03-22 |
| TW200604862A (en) | 2006-02-01 |
| RU2005116632A (en) | 2006-11-20 |
| EP1605367A2 (en) | 2005-12-14 |
| RU2406147C2 (en) | 2010-12-10 |
| CN100547586C (en) | 2009-10-07 |
| EP1605367A3 (en) | 2006-07-26 |
| AU2005202284B2 (en) | 2011-01-27 |
| EP1605367B1 (en) | 2016-11-02 |
| CA2508933A1 (en) | 2005-12-01 |
| SG117588A1 (en) | 2005-12-29 |
| BRPI0501959B1 (en) | 2017-10-10 |
| JP4907906B2 (en) | 2012-04-04 |
| CO5710208A1 (en) | 2006-12-29 |
| IL168620A (en) | 2010-11-30 |
| US7664804B2 (en) | 2010-02-16 |
| MXPA05005856A (en) | 2005-12-05 |
| TWI411928B (en) | 2013-10-11 |
| NO332884B1 (en) | 2013-01-28 |
| EG23841A (en) | 2007-10-16 |
| NO20052613D0 (en) | 2005-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2508933C (en) | Method, system, and apparatus for exposing workbook ranges as data sources | |
| US7991804B2 (en) | Method, system, and apparatus for exposing workbooks as data sources | |
| US6594672B1 (en) | Generating multidimensional output using meta-models and meta-outlines | |
| AU2005202285B2 (en) | Method, system, and apparatus for providing access to workbook models through remote function calls | |
| JP4921785B2 (en) | Managing and using data in computer-generated documents | |
| US7992078B2 (en) | Apparatus and method for creating publications from static and dynamic content | |
| US7305656B2 (en) | Content management framework for use with a system for application development | |
| US7617444B2 (en) | File formats, methods, and computer program products for representing workbooks | |
| US20060265396A1 (en) | Personalizable information networks | |
| US20060265394A1 (en) | Personalizable information networks | |
| US20060265377A1 (en) | Personalizable information networks | |
| US20050262439A1 (en) | Automatic web publishing | |
| JP2023501098A (en) | Data preparation using semantic roles | |
| US7620889B2 (en) | Method and system for linking data ranges of a computer-generated document with associated extensible markup language elements | |
| US20060265395A1 (en) | Personalizable information networks | |
| US7587416B2 (en) | Advanced desktop reporting | |
| US7546526B2 (en) | Efficient extensible markup language namespace parsing for editing | |
| WO2006124268A2 (en) | Personalizable information networks | |
| Anderson et al. | The Role of the Data Warehouse in the Archive | |
| AU2005203341A1 (en) | Facilitating Fast Response Joins Across Heterogenous Data Sources | |
| Üstünkaya | Fuzzy querying im XML databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request |