Interfacing with a relational database for multi-dimensional analysis via a spreadsheet application

Patent metadata

Field	Value
Publication number	US-10140352-B2
Application number	US-201414334556-A
Country	US
Kind code	B2
Filing date	Jul 17, 2014
Priority date	Jul 17, 2014
Publication date	Nov 27, 2018
Grant date	Nov 27, 2018

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.

First claim

What is claimed is:

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.

2. The system for providing the interface to the relational database of claim 1 , the system further comprising:
a user computer system configured to:
execute the spreadsheet application, wherein the spreadsheet application uses a software extension to communicate with the relational interface web server system; and

present, via a first plurality of cells of the spreadsheet, at least a portion of the translated query response, wherein the user computer system communicates with the relational interface web server system via a first network connection.

3. The system for providing the interface to the relational database of claim 1 , the system further comprising:
a relational database server system configured to:
store data using the plurality of tables, wherein the relational database server system is accessible by the relational interface web server system.

4. The system for providing the interface to the relational database of claim 1 , wherein the metadata comprises, for each of the plurality of attributes, an attribute data type and an attribute label.

5. The system for providing the interface to the relational database of claim 1 , wherein the processor-readable instructions of the relational interface web server system, when executed, further cause the one or more processors to:
receive a validation request for an authorization and an authentication of a user from the spreadsheet application;
in response to the validation request for the authorization and the authentication of the user, perform the authorization and the authentication of the user; and
provide an authorization response and an authentication response to the spreadsheet application.

6. The system for providing the interface to the relational database of claim 2 , wherein the user computer system is further configured to:
present, via a second plurality of cells of the spreadsheet, data retrieved from a multidimensional database distinct from the relational database, wherein the first plurality of cells and the second plurality of cells are presented concurrently.

7. The system for providing the interface to the relational database of claim 1 , wherein the processor-readable instructions of the relational interface web server system, when executed, further cause the one or more processors to:
obtain an available connection with the relational database from a connection pool.

8. The system for providing the interface to the relational database of claim 1 , wherein the processor-readable instructions of the relational interface web server system, when executed, further cause the one or more processors to:
receive, from the spreadsheet application, an indication of a selection of a cell from within the spreadsheet;
determine that the cell corresponds to hierarchical data;
retrieve, from the relational database, the hierarchical data; and
output the hierarchical data to the spreadsheet application.

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.

10. The method for providing the interface to the relational database of claim 9 , the method further comprising:
executing, by a user computer system, the spreadsheet application, wherein the spreadsheet application uses a software extension to communicate with the server system; and
presenting, by the user computer system via a first plurality of cells of the spreadsheet, at least a portion of the translated query response, wherein the user computer system communicates with the server system via a first network connection.

11. The method for providing the interface to the relational database of claim 9 , the method

Assignees

• Oracle Int Corp

Inventors

• Hariharan Sreeram
• Uppala Swathi
• Shirkol Mohammed Hussain
• Arora Usha
• Pathak Ashish
• Suleman Kashif
• Raman Ramchand

Classifications

• G06F17/30592

  Physics · mapped topic

• G06F17/301

  Physics · mapped topic

• G06F17/30595 Primary

  Physics · mapped topic

• G06F17/30997

  Physics · mapped topic

• G06F17/30389

  Physics · mapped topic