摘要 |
PURPOSE: A customer information data warehouse and a marketing database system for a bank are provided to realize the quality improvement of the customer analysis and the efficient scientific marketing and to instantly meet a change of the work environment and the user's need. CONSTITUTION: The system comprises an account section tape writer(1) writing the various kinds of information of the customer in a tape, an account section transformation programming part(2) transforming the information of the tape writing part into the data, a source file writer(3) writing the source file by receiving the information from the transformation part, and an ETT(Extraction, Transformation, Transportation) programming part(4) carrying out the programming by receiving the customer information. A target file writer(7) writes a target file for loading the information programmed by the ETT programming part. A loading file writer(8) writes the data for loading to an information system. The information section comprises the tables(9,10,11) of businesses and an E-R(Entity-Relation) modeling part(12) modeling the tables by each business into the tables for each business.
|