ADMINISTRATIVE TOOL AND PHYSICAL EXECUTION PLAN INTERFACE FOR PLUG-IN ARCHITECTURE OF BUSINESS INTELLIGENCE PLATFORM USING DATA SOURCE CARTRIDGES

摘要

Embodiments implement a plug-in architecture supporting adding new data sources to a legacy federated database without the need to recode a federated database manager software module. The federated database manager software module includes an administrative tool and a plug-in framework for interfacing with a data source cartridge. The data source cartridge supplies metadata including a feature table of a newly added data source to the framework and creates a physical query for the newly added data source based on an execution plan generated by the federated database manager software module. The administrative tool generates presentation panes including new data sources added to the legacy federated database.

主权项

1. A method performed by a federated database manager functional component executed by a computer system, where the federated database manager functional component includes a code generation functional component and a framework functional component, the method comprising:
receiving, by the federated database manager functional component, a logical query to an updated federated database where the updated federated database includes a legacy federated database of data sources and an added data source not included in the legacy federated database; retrieving, by the framework functional component, metadata from a data source cartridge functional component associated with the added data source; generating, by the federated database manager functional component and using at least a portion of the metadata retrieved from the data source cartridge functional component, a physical execution plan for the logical query with the physical execution plan including at least one logical query to the added data source; processing, by the code generation functional component, the physical execution plan to produce physical queries in native form to communicate with data sources in the legacy federated database; branching, by the federated database manager functional component, the at least one logical query to the added data source to the framework functional component which converts a branched logical query to an extensible markup language (XML) representation; and transferring, by the framework functional component, the XML representation to the data source cartridge functional component which processes the XML representation to produce a physical query in native form to the added data source.