Study on Data Warehouse System in Remote Monitor System for Crane
LV Hui-juan · Microcomputer Information · 2009
From the perspective of performance prediction analysis, this article researched the data processing methods for remote monitoring system of big amount of large cranes based on OLAP methods in the network environment amounts. Real-time status monitoring database is established using ER model ; Through data ETL (extraction, transformation, and loading) on the status monitoring database, data warehouse is constructed for the performance analysis and trends forecasting; From the perspective of forecasts and analysis, the Crane Equipment Model, time and functional parameters multidimensional cubes are structured; By peacekeeping information sections, segmentation and coring operation, identified concern blocks are obvious; Time-series analysis method is used to evaluate the XX state and to forecast the trend.