SYSTEM AND METHOD FOR PROVIDING A COMPOSITE VIEW OBJECT AND SQL BYPASS IN A BUSINESS INTELLIGENCE SERVER

SYSTEM AND METHOD FOR PROVIDING A COMPOSITE VIEW OBJECT AND SQL BYPASS IN A BUSINESS INTELLIGENCE SERVER

Systems and methods are described for performing a SQL bypass in a business intelligence (BI) server environment. The BI server initially receives a SQL query and constructs an extensible markup language (XML) representation of the SQL query. The XML representation is sent to an application server t...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: BOLSIUS ROGER, MASCARENHAS ALEXTAIR, ENG KENNETH, PAN HARVARD, VENKATASUBRAMANIAN RAGHURAM
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:Systems and methods are described for performing a SQL bypass in a business intelligence (BI) server environment. The BI server initially receives a SQL query and constructs an extensible markup language (XML) representation of the SQL query. The XML representation is sent to an application server that hosts an application developer framework (ADF). The ADF receives the XML representation of the SQL query and constructs a composite view object at runtime, to access the appropriate data. It then generates a database-specific query based on the composite view object and returns it to the BI server. The BI server replans the database-specific query and sends it to a database storing the data.