Interfacing with a Relational Database for Multi-Dimensional Analysis via a Spreadsheet Application

摘要

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.

主权项

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; anda 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 request 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, accessing a plurality of tables in the relational database to retrieve the data indicated in the request;translate the retrieved data from the plurality of tables of the relational database into a format for output to the spreadsheet application; andoutput the translated data to the spreadsheet application.