Patent Number: 6,167,405

Title: Method and apparatus for automatically populating a data warehouse system

Abstract: A method and system for facilitating the creation of warehouse requests in a data warehouse system. During the design of the data warehouse tables, a repository tool is used for storing a number of new objects such as source and target databases, source and target tables and warehouse requests that are graphically defined and linked together by an administrator with the repository tool. The resulting visual design is so drawn so as to serve as input for each warehouse request to be generated. The administrator invokes a data replication component that operatively couples to the repository tool signaling that the warehouse request is to be implemented. The data replication component automatically creates the different subcomponents of the request by accessing various links stored by the repository tool and displays a visual representation of the subcomponents and their relationships to each other to the administrator. Thereafter, the replication component provides access to menu screens for enabling the administrator to visualize each of the subcomponents of the request and their properties for enabling modifications to be made to such subcomponents for completing configuration of all request subcomponents. Subsequently, the warehouse request can be scheduled to execute and populate the warehouse tables.

Inventors: Rosensteel, Jr.; Kenneth R. (Phoenix, AZ), Guhr; Jerry T (Phoenix, AZ), Picone; Joseph K. (Phoenix, AZ)

Assignee: Bull HN Information Systems Inc.

International Classification: G06F 17/30 (20060101); G06F 017/30 ()

Expiration Date: 12/26/2017