This system is operated on the platform of unix ( ibm aix ), using powerdesigner as the modeling tool, based on the db storage of oracle9i, carried out etl works with datastage, built multi-dimension cube and laid out the result upfront by cognos . design and research of the whole dw system was deeply and particularly set forth here, this may make help to unicorn's dw project period 2 on theory 本系統(tǒng)以unix(ibmaix)操作系統(tǒng)為開發(fā)平臺,使用powerdesigner為建模工具,基于oracle9i的數(shù)據(jù)庫存儲,以datastage進行etl操作,以cognos作為多維立方體生成及前端展示工具,對整個數(shù)據(jù)倉庫系統(tǒng)的設(shè)計和研究做了深入的分析和詳細的闡述,為數(shù)據(jù)倉庫二期工作提出了理論上的幫助和建議。