Interfacing with a relational database for multi-dimensional analysis via a spreadsheet application
First Claim
1. A system for providing an interface to a relational database, the system comprising:
- a relational interface web server system, comprising;
one or more processors; and
a memory communicatively coupled with and readable by the one or more processors and having stored therein processor-readable instructions which, when executed by the one or more processors, cause the one or more processors to;
receive a first eXtensible Markup Language (“
WL”
)-based message from a spreadsheet application, the first XML-based message defining a layout, the layout identifying a plurality of attributes of the relational database and the layout identifying a mapping of the plurality of attributes to a plurality of columns in a spreadsheet of the spreadsheet application;
in response to receiving the first WL-based message defining the layout, generate and submit a first database query to fetch metadata associated with the plurality of attributes from the relational database;
receive, from the relational database in response to the first database query, the metadata comprising a data type value for at least one of the plurality of attributes;
transmit the metadata to the spreadsheet application for the spreadsheet application to format the spreadsheet of the spreadsheet application in accordance with the metadata;
after transmitting the metadata to the spreadsheet application, receive, from the spreadsheet application, a second XML-based message comprising a request for data stored in the relational database;
in response to receiving the second XML-based message comprising the request, generate and submit a second database query to retrieve the data indicated in the request from a plurality of tables in the relational database;
receive, from the relational database in response to the second database query, a query response comprising the data indicated in the request;
translate the query response in accordance with the layout and the metadata; and
output the translated query response to the spreadsheet application for the spreadsheet application to interpret and present via the spreadsheet.
1 Assignment
0 Petitions
Accused Products
Abstract
Systems, methods, and computer-readable mediums are presented that may provide for an interface to a relational database. A request may be received for data stored in a relationship database, wherein the request is received from a spreadsheet application. In response to the request for data stored in the relational database, a plurality of tables in the relational database may be accessed to retrieve the data indicated in the request. The retrieved data may be translated from the plurality of tables of the relational database into a format for output to the spreadsheet application. The translated data may be output to the spreadsheet application.
-
Citations
20 Claims
-
1. A system for providing an interface to a relational database, the system comprising:
a relational interface web server system, comprising; one or more processors; and a memory communicatively coupled with and readable by the one or more processors and having stored therein processor-readable instructions which, when executed by the one or more processors, cause the one or more processors to; receive a first eXtensible Markup Language (“
WL”
)-based message from a spreadsheet application, the first XML-based message defining a layout, the layout identifying a plurality of attributes of the relational database and the layout identifying a mapping of the plurality of attributes to a plurality of columns in a spreadsheet of the spreadsheet application;in response to receiving the first WL-based message defining the layout, generate and submit a first database query to fetch metadata associated with the plurality of attributes from the relational database; receive, from the relational database in response to the first database query, the metadata comprising a data type value for at least one of the plurality of attributes; transmit the metadata to the spreadsheet application for the spreadsheet application to format the spreadsheet of the spreadsheet application in accordance with the metadata; after transmitting the metadata to the spreadsheet application, receive, from the spreadsheet application, a second XML-based message comprising a request for data stored in the relational database; in response to receiving the second XML-based message comprising the request, generate and submit a second database query to retrieve the data indicated in the request from a plurality of tables in the relational database; receive, from the relational database in response to the second database query, a query response comprising the data indicated in the request; translate the query response in accordance with the layout and the metadata; and output the translated query response to the spreadsheet application for the spreadsheet application to interpret and present via the spreadsheet. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
9. A method for providing an interface to a relational database, the method comprising:
-
receiving, by a server system, a first eXtensible Markup Language (“
XML”
)-based message from a spreadsheet application, the first XML-based message defining a layout, the layout identifying a plurality of attributes of the relational database and the layout identifying a mapping of the plurality of attributes to a plurality of columns in a spreadsheet of the spreadsheet application;in response to receiving the first XML-based message defining the layout, generating and submitting, by the server system, a first database query to fetch metadata associated with the plurality of attributes from the relational database; receiving, by the server system from the relational database in response to the first database query, the metadata comprising a data type value for at least one of the plurality of attributes; transmitting, by the server system, the metadata to the spreadsheet application for the spreadsheet application to format the spreadsheet of the spreadsheet application in accordance with the metadata; after transmitting the metadata to the spreadsheet application, receiving, by the server system from the spreadsheet application, a second WL-based message comprising a request for data stored in the relational database; in response to receiving the second XML-based message comprising the request, generating and submitting, by the server system, a second database query to retrieve the data indicated in the request from a plurality of tables in the relational database; receiving, by the server system from the relational database in response to the second database query, a query response comprising the data indicated in the request; translating, by the server system, the query response in accordance with the layout and the metadata; and outputting, by the server system, the translated query response to the spreadsheet application for the spreadsheet application to interpret and present via the spreadsheet. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A non-transitory processor-readable medium for providing an interface to a relational database, comprising processor-readable instructions configured to cause one or more processors to:
-
receive a first eXtensible Markup Language (“
XML”
)-based message from a spreadsheet application, the first XML-based message defining a layout, the layout identifying a plurality of attributes of the relational database and the layout identifying a mapping of the plurality of attributes to a plurality of columns in a spreadsheet of the spreadsheet application;in response to receiving the first XML-based message defining the layout, generate and submit a first database query to fetch metadata associated with the plurality of attributes from the relational database; receive, from the relational database in response to the first database query, the metadata comprising a data type value for at least one of the plurality of attributes; transmit the metadata to the spreadsheet application for the spreadsheet application to format the spreadsheet of the spreadsheet application in accordance with the metadata; after transmitting the metadata to the spreadsheet application, receive, from the spreadsheet application, a second XML-based message comprising a request for data stored in the relational database; in response to receiving the second XML-based message comprising the request, generate and submit a second database query to retrieve the data indicated in the request from a plurality of tables in the relational database; receive, from the relational database in response to the second database query, a query response comprising the data indicated in the request; translate the query response in accordance with the layout and the metadata; and output the translated query response to the spreadsheet application for the spreadsheet application to interpret and present via the spreadsheet. - View Dependent Claims (18, 19, 20)
-
Specification