06167405 is referenced by 196 patents and cites 3 patents.

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.

Title
Method and apparatus for automatically populating a data warehouse system
Application Number
9/67101
Publication Number
6167405
Application Date
April 27, 1998
Publication Date
December 26, 2000
Inventor
Joseph K Picone
Phoenix
AZ, US
Jerry T Guhr
Phoenix
AZ, US
Kenneth R Rosensteel Jr
Phoenix
AZ, US
Agent
John S Solakian
Faith F Driscoll
Assignee
Bull HN Information Systems
MA, US
IPC
G06F 17/30
View Original Source