Abstract: An apparatus includes a task selector to receive an indication of a database task to be performed, wherein the database task includes a set of subtasks; a source selector to receive an indication of a source device to perform the set of subtasks, and to retrieve from the source device an indication of a processing environment currently available within the source device that includes an identity and version level of a database routine of the source device; and an instruction generator to determine a set of languages able to be interpreted by the database routine based on the identity and version level, select a language of the set of languages in which to generate instructions for each subtask based on the processing environment, and generate and transmit the instructions to the source device.

Abstract: An apparatus includes a task selector to receive an indication of a database task to be performed, wherein the database task includes first and second subtasks; a source selector to receive an indication of a source device to perform the first and second subtasks, and to retrieve from the source device an indication of a processing environment currently available within the source device that includes an identity and version level of a database routine of the specified source device; and an instruction generator to determine a set of languages able to be interpreted by the database routine based on the identity and version level, determine whether to perform the first and second subtasks in parallel based on the processing environment, select a language in which to generate instructions to perform the first subtask based on the determination, and generate and transmit the instructions to the source device.

Abstract: An apparatus includes a task selector to receive an indication of a database task to be performed, wherein the database task includes a set of subtasks; a source selector to receive an indication of a source device to perform the set of subtasks, and to retrieve from the source device an indication of a processing environment currently available within the source device that includes an identity and version level of a database routine of the source device; and an instruction generator to determine a set of languages able to be interpreted by the database routine based on the identity and version level, select a language of the set of languages in which to generate instructions for each subtask based on the processing environment, and generate and transmit the instructions to the source device.

Abstract: An apparatus includes a task selector to receive an indication of a database task to be performed, wherein the database task includes first and second subtasks; a source selector to receive an indication of a source device to perform the first and second subtasks, and to retrieve from the source device an indication of a processing environment currently available within the source device that includes an identity and version level of a database routine of the specified source device; and an instruction generator to determine a set of languages able to be interpreted by the database routine based on the identity and version level, determine whether to perform the first and second subtasks in parallel based on the processing environment, select a language in which to generate instructions to perform the first subtask based on the determination, and generate and transmit the instructions to the source device.

Abstract: Data warehousing systems and methods are described herein. In one example methodology, a plurality of transformation templates are stored in a transformation library, each transformation template including software objects that describe how to transform extracted data prior to loading the data into the data warehouse. A unique identifier may be associated with each of the plurality of transformation templates. Using this unique identifier, an instance of at least one of the plurality of transformation templates may be instantiated into a data transformation process by mapping the software objects of the transformation template into the instance of the transform using code segments. The code segments of the data transformation process are then executed to transform and load the extracted data into the data warehouse.

Abstract: Data warehousing systems and methods are described herein. In one example methodology, a plurality of transformation templates are stored in a transformation library, each transformation template including software objects that describe how to transform extracted data prior to loading the data into the data warehouse. A unique identifier may be associated with each of the plurality of transformation templates. Using this unique identifier, an instance of at least one of the plurality of transformation templates may be instantiated into a data transformation process by mapping the software objects of the transformation template into the instance of the transform using code segments. The code segments of the data transformation process are then executed to transform and load the extracted data into the data warehouse.