Data Warehouse Technology In Decision Support Systems In Research And Analysis

Now facing voluminous information, how to help people collect, choose and store message of interest and the more important is how to help users to find the relation between new concept and them in the information increasing day by day. And enabling it to promise thus the automation of information processing is used in decision support. It has already become the focus question of the information technology (IT).But data warehouse (DW) and data mining (DM) technology let computer help people carry on intelligence, automatic extraction and refine valuable knowledge from magnanimity information, reveal and relationship and law including objective world behind these data in store from it. And it is used in macroscopically to aid decision and solve the practical problem in the social development.The proposition of the data warehouse is taking development at full speed of relation data base, undertaking the parallel processing of and distributed technology as foundation, Solve possession a large amount of data but useful information poor( Data rich-Information poor) comprehensive solution that information technology exist in developmentOnline Analysis Processing and go on technology that analyses to multidimensional data, from analyses it way obtain analysis datum of aid decision that user need from various visual angles.If data warehouse lay particular emphasis on and store and manage facing decision theme datum, so on-line to analyze, process and lay particular emphasis on data of warehouse, Changing into the aid decision information.ODS (Data Operational store) is one available some of structure, system of warehouse. ODS possesses some characteristics of some characteristics and OLTP systems of the data warehouse , It is the data" who faces the theme, integrates, or close to present, constantly changeably at present"Because DSS is peculiar: Can't fully understand the demand; the demand change is great; Implement time long cycle, but the customer demands tobecome effective and wait for the characteristic soonAt the time of making BI systematic scheme of the enterprise layer, should consider on the issue that there is a great deal of, In a situation that the fish and bear's paw must hold concurrently, make the choice.In this paper, analyzing the technology of planning, modeling, ETL etc about DSS based on DW, and discussing the advantage and disadvantage of different plan.To sum up, the above-mentioned data base technology and data warehouse technology regard as DSS whole foundation of solution, data mining with on-line extension technology and data technology come and support, namely based on DB +DW + OLAP + DM of best feasible scheme comprehensive to have at present. The above-mentioned data base technology and data warehouse technology regard as DSS whole foundation of solution, Excavate with on-line extension technology and data technology stand, namely DSS based on + DW + OLAP + DM of DB is the best feasible scheme at present.