Data Warehouse Base Data Warehouse Basic Knowledge Investment Computer System The modern enterprise does not have its own computer system is unimaginable. Bank rely on computer systems to achieve currency electronics, and achieve fast liquidation between other banks, helping important customers to achieve services. Insurance companies rely on computer systems to achieve electronicization, claims, and can promptly understand significant claims and important customer dynamics. All companies that have already or prepared to invest in computer systems are a problem: "What is the ultimate goal of establishing a computer system?" Answer may be more diverse, but there is a one of the most important purposes, and the ultimate goal is definitely "let the company earn more money." Therefore, whether the computer system is successful or whether it is worth investing, the most important measurement standard should be "return on investment". The three stages of successful computer system should have three phases "constructive infrastructure, optimize system performance, realize the value of information. There are different investment rewards in each stage. Construct the infrastructure phase, that is, establish OLTP systems, The main purpose is to make a large number of transaction electronic. For example, the bank's free exchange of savings system, the front desk operator of this stage is liberated from heavy manual operations, and collects a lot of raw data, which in the future Development is a valuable wealth. The biggest beneficiaries at this stage are front-end operators. Optimize the system performance phase, in fact, the behavior of the first phase of investment. Because of the operation of the business system, system performance, security, reliability Subject to all aspects, the performance of the optimization system is to solve the situation such as performance unstable, and the system is affected by illegal attacks. If these conditions can be resolved in time, it may cause catastrophic consequences. At this stage, the biggest beneficiary is computer system maintenance Personnel; realize the value of information, which is to make full use of the potential information value of existing data, excavate data, providing decision-making for corporate decision-making. So, the biggest beneficiary this stage is a decision maker. How to achieve information value almost all industries In the face of fierce competition, the correct and timely decision-making is the most important aspect of the survival and development of the company. More and more companies realize that only the existing data can only achieve greater benefits. Daily Business applications generate a large amount of data, which will bring significant added value if it is used for decision support. If you add behavior analysis report, independent market survey, evaluation results, and consultant evaluation, the above treatment process The resulting benefits can be further enhanced. The data warehouse is a basis for summarizing this information, which in turn supports today's cutting-edge technologies and traditional query and reporting functions such as data discovement, multi-dimensional data analysis. These for maintaining leading in today's fierce competition is Important. Survey and research show that most companies do not lack data, but blocked over redundant data and data inconsistent; and they become more difficult to access, manage and use for decision support; their data is positive The speed increases. This way, the information center faces the growing demand for decision support, but development applications become more complex and costly. So how do you convert a lot of data into reliable, commercial information for Decision support? Data warehouse is widely recognized as the best solution. What is the purpose of establishing a data warehouse in a data warehouse is to effectively integrate the internal data and external data of the enterprise, which is a decision-making for the company. Analysts are used. Enterprise internal data refers to data collected through the business system, which may be distributed in different hardware, databases, network environments, serving different business units. For example, for a manufacturing industry, there may be Production data, sales data, financial data, market data, personnel data, etc., all of which are structurally, Independent, it is not conducive to corporate decision makers for comprehensive analysis and query.
If we are designed for decision-making, we will design the data to be structurally restructured, and consider the valuable resources of the company fully considering the interface of future scalability and external data. Realize true information value. For information on information in the data warehouse, users with different levels have different style. For example: Supervisor Information System (EIS): Provides rich interface, easy decision analysis, mainly suitable for high-level decision makers for enterprises. Online Analysis: OLAP: Flexible and rich analysis and query, you can analyze the operation of the company from different perspectives and predict the future. Mainly suitable for the middle leaders and business analysts of the enterprise. AD HOC Query: Provides flexible queries from multiple angles. Suitable for business analysts. Flexible Report: Provides a design of a flexible report. Suitable for people who make reports. What is a data warehouse processing data warehouse than a database. The database is a general platform for managing the data of the company; and the data warehouse is a concept, the construction process under this concept, we call it data warehouse processing. Therefore, the data warehouse is not a ready-made product that can be purchased (and the database is), it is a process of establishing. Data warehouse processing includes many aspects, we can divide them: data preparation: fully understand decision-making needs; design data warehouse structure by data warehouse method; mobile system data movement into data warehouse structure (copy, extract, cleaning ...) Data Warehouse Data Replication and Distribution to Small Scale Data Market; Data Prevention: The Supervisor Information System (EIS) for high-level decision makers; online analysis system (OLAP) facing decision-making analysts; serving various decision makers Uply, an AD Hoc; a flexible reporting system for reporting services; data shows a variety of flexible ways such as customer / server mode or browser mode. Process Management Data Warehouse requires good process management and methods. We look at the establishment of the data warehouse as the process, not as an engineering (Project). As a process, mainly based on several considerations: Adapt to business development: Enterprises may often need to conduct institutional, products, market adjustments in market environments, resulting in changes in decision-making models. For the establishment of the data warehouse, it is a new demand. The development of adaptation technology: computer technology has developed rapidly, new technologies continue to emerge, how to ensure that technology is not backward during data warehouse, protecting the original technical investment, best way to adopt process-oriented methods: from the top-down overall Design; from bottom to implement. Data Warehouse Investment Report (ROI) Application Data Warehouse Technology, Improve Enterprise Decision Support Mode, and has achieved the largest investment returns, which has become a consensus of most successful companies. With investigation, 85% of companies in Happiness 500 have been built or is building data warehouses, and the data warehouse is the fastest IT growth point. In 1996, global companies had investment in data warehouses reached $ 1.68 billion, and increased by 19.1% per year.
