Data Warehouse Applications And Technology Research In Distributed Environments

Based on research of this subject-oriented multi-enterprise inventory management system platform, the system uses the same software many small and micro enterprises to provide daily management and operations analysis. Such companies currently provide daily service management software system needs urgent, the platform is generated in response to this demand.In this platform for each company to design a separate table space, there are69tables in the table space, describes the company’s business. Oracle database table space is a unique term, when you create the table space is assigned a user name to whom. Distributed Transaction means a transaction may involve multiple database systems operations. When an enterprise database systems need to increase the data increases, in such an operation environment of the transaction may involve the operation of a plurality of database systems.Daily management of enterprise data can be used for corporate business analysis, business analysis need to build a data warehouse. Data warehouse data from various database systems. For example, a platform for all corporate data multidimensional analysis. Data warehouse platform in the distributed multi-database environment is the main content of the research.The topics chosen for Oracle Warehouse Builder as a tool to build a data warehouse. Oracle Warehouse Builder (OWB) is a method used to design and deploy BI (Business Intelligence) applications, data warehouse (Data Warehouse) and data marts (Data marts) tool that provides ETL (extract, transform, and load), fully integrated relational and dimensional modeling, data quality, data auditing, and the entire life cycle of data and metadata management. OWB can extract data from various types of multi-source data, data warehousing, and provide automatic update feature, this topic is the use of this feature, the establishment of the enterprise data warehouse for multi-Invoicing platform for the distributed multi-database systems.From the experimental results OWB to build a data warehouse, the process is relatively standardized, easy to manage, update, suitable for the use of business analysis.