Patent ID: 9020882
Filing Date: 2015-04-28
Classification: G06F

Abstract:
1. A method comprising: storing, by a processor at a middleware database system, a dimensional transform table, wherein each record in the dimensional transform table comprises a dimension field that identifies at least one dimension of extracted data from at least one of a plurality of data sources and a dimensional transform field that stores an operation for transforming data from the at least one dimension, wherein the dimensional transform table comprises a data source field identifying a data source which contributes the at least one dimension of the extracted data, and is stored at the middleware database system without storing data from the plurality of data sources at the middleware database system; receiving, by the middleware database system, a data request from at least one application at a system that is separate from the middleware database system; identifying, by the middleware database system, a record from the data source field of the dimensional transform table that corresponds to a subset of the plurality of data sources and to a dimension of data from the subset of the plurality of data sources in view of the data request and the dimension field of the record; extracting, by the middleware database system, data corresponding to the dimension of data from the subset of the plurality of data sources for the identified record; and performing, by the middleware database system, the operation from the dimensional transform field of the dimensional transform table for the identified record on the extracted data to generate a transformed dimensional output comprising a three-dimensional data block, the three dimensional data block generated by combining a plurality of dimensions hosted in a respective plurality of data sources.