TRANSFORMATION OF COMPLEX DATA SOURCE RESULT SETS TO NORMALIZED SETS FOR MANIPULATION AND PRESENTATION

摘要

An enterprise business intelligence system includes a data access service. In one example, a method comprises receiving, with a data access service, a query and a report specification from an enterprise software application, wherein the data access service is positioned between the enterprise software application and a data source; creating a run tree that comprises a sequence of executable decoration nodes; executing the query on the data source, thereby providing a query result set comprising query results drawn from the data source that are responsive to the query; and executing the sequence of decoration nodes on the query result set, wherein each of the decoration nodes modifies the query result set, thereby producing a decorated result set based on the query result set and the one or more decoration nodes, wherein producing the decorated result set comprises associating each of one or more members or values in the query results with a corresponding position or a calculated member in the report specification.