Administrative tool and physical execution plan interface for plug-in architecture of business intelligence platform using data source cartridges

A computer system including one or more processors configured to execute federated database manager functional program code, where the federated database manager functional program code includes a code generation functional component and a framework functional component, with the federated database manager functional program code, when executed by the one or more processors, causing the computer system to perform the steps of:

• receiving, by the federated database manager functional program code, 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 program code 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 program code, 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.

A method performed by a federated database manager functional component executed by a computer system, where an updated federated database includes a legacy federated database of data sources and an added data source not included in the legacy federated database, where the federated database manager functional component includes an administrative tool functional component having a file layer representing tables and columns of data sources in the legacy federated database and a framework functional component, the method comprising:

• retrieving, by the framework functional component, metadata of the added data source from a data source cartridge functional component associated with the added data source;
• updating, by the administrative tool functional component, the file layer to include the metadata of the added data source;
• and
• presenting, by the administrative tool functional component, tables and columns of data sources included in both the legacy federated database and the added data source.

A computer system including one or more processors configured to execute federated database manager functional program code, where an updated federated database includes a legacy federated database of data sources and an added data source not included in the legacy federated database, where the federated database manager functional program code includes an administrative tool functional component having a file layer representing tables and columns of data sources in the legacy federated database and a framework functional component, with the federated database manager functional program code, when executed by the one or more processors, causing the computer system to perform the steps of:

• retrieving, by the framework functional component, metadata of the added data source from a data source cartridge functional component associated with the added data source;
• updating, by the administrative tool functional component, the file layer to include the metadata of the added data source;
• and
• presenting, by the administrative tool functional component, tables and columns of data sources included in both the legacy federated database and the added data source.

One or more non-transitory computer readable storage media storing federated database manager functional program code for execution by one or more processors, where the federated database manager functional program code includes a code generation functional component and a framework functional component, where the federated database manager functional program code, when executed by the one or more processors, performs the following acts:

• receiving, by the federated database manager functional program code, 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 program code 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 program code, 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.