The Research And Development Of Auto-coding Tool Based On Datawarehouse’s Structure Procedure

Within the practice of building an EDW, the job of ETL(Extract,Transfer,Load)was an essentional critical part.Mainly theory of ROLAP EDW consider usingSTRUCTURE PROCEDUREs (SPs) as THE ONE to accomplish ETL. The speed andquality of programming SPs probably equals the speed and quality of building EDW,hence SP s, the knot of the chain of producing data, describe historical changing ofdata integration,and the management of lifecycle of the knot itself describes morevivilly the source towards and the goal afterwards the knot.This document describes a tool, which’s design to accelerating developing SPs,improving developing efficiency,decreasing bugs count, can generate SPs’ SQL,annotation document,MAPPING document,stain description document,hierarchydescription ducoment based on configuration which operating by end-users.By analysising the requirement and designing the system, programming and test,this document focus on introducing the core source,and its behavior:such as the javaobjects’, which implement interfaces as mainstream developing mode, initializationand generating SQL.Using POI SDK to write EXCEL/WORD files,especially themethods above.This document discuss using integrate software knowledge and productenvironment well to research and develop this tool. In real product environment, thisapplication behave well as it suppose to generate SPs’ SQL、SPs’ innovationdocument,mapping document,strain description document,hierarchy descriptionducomen,saving time of writing documents,improve developing efficiency,decreaingbugs.