Research On Integration Of Heterogeneous Data And Logistics System In Sets Of Electrical Equipment Enterprise

Basing on the research on heterogeneous data source and information systems of sets of electric apparatus enterprises, we have set up integrating framework of the heterogeneous data source, formed integrating strategies and fulfilled the whole technology. After researching on the data-abstracting , data-integrating , data-treating and analyzing , we come up with the algorithm about the distributed file increment updating , designing and the low cost loading method based on the oracle, the enterprise data loading. In terms of the current situation in enterprise, choosing logistic flow as our center and using cost-saving and system-optimizing strategies, we have promoted the comprehensive competition ability of the group of enterprises. The cost of logistics in enterprises can be effectively supervised and controlled by applying rough set theory to comprehensively evaluating the logistics system. Here, we extract the logistic flow information by using OWB(ORACLE WAREHOUSE BUILDER ) and AWM (ANALYTIC WORKSPACE MANAGER) and then build the star model for the key information by using ETL (EXTRAC TRANSFORMATION AND LOADING) .Furthermore, we have developed the management decision inquiry prototype system based on internet, which has already been applied to the set of electric apparatus. The conclusion is as following:Basing on internet, integrated the heterogeneous data source of enterprise and set up the data warehouse. This can provide an effective solution to the transform from distributed dispersing independent information system to internet-based uniform dada management model.Apply ORACLE technology to integrating the heterogeneous data source and designing the low-cost batch data transplant. Basing on ORACLE, through analyzing the heterogeneous data source such as SQLSERVER,MYSQL , etc, build the T-D-M transform model and fulfilled the batch heterogeneous data transforming and loading.Apply the character-model-match technology and date-filter method to the procedure of loading the increment, batch data. After analyzing the classic match algorithm, we have designed DIFF-MATCH algorithm and middle-match algorithm, which are efficient in loading the batch data of some sequential and short character-string set. Moreover , it can also be applied to the SQL file-match by using ORACLE optimizing query.Logistics system in enterprise is a local and microcosmic logistics data managing system , under the whole enterprise supply chain. In sets of appliance enterprises,...