公路客运售票系统数据仓库的设计与实现  

Design and implementation of road passenger ticket system data warehouse

作　　者：张海[1] 刘永山[1] 白立宏[1] 

机构地区：[1]燕山大学信息科学与工程学院,河北秦皇岛066004

出　　处：《燕山大学学报》2010年第1期80-84,共5页Journal of Yanshan University

基　　金：工业和信息化部2007电子信息产业发展基金资助项目

摘　　要：公路运输企业的信息化工作已从管理信息系统发展到决策支持系统,而数据仓库是决策支持系统的核心。本文分析客运售票业务系统的现状和存在的问题,设计实现了一个数据仓库系统,利用SQL Server 2005提供的SSIS工具构建ETL package,保证存入到数据仓库中的数据的质量,用SSAS来实现OLAP数据分析,用SSRS来实现智能报表功能。系统通过在多个运输公司的实际应用,取得了良好的效果,为客运企业管理者提供准确的决策信息。The informationization task has been developed from management system to decision-making system in the road transport company, while data warehouse is the core of this decision-making system. The present situation and the existing problems of the road passenger ticket system are analyzed and a data warehouse is constructed. In order to ensure the data quality of data warehouse, the ETL package is constructed by the SSIS tool integrated in SQL Server 2005. The OLAP data analysis is implemented by the SSAS and the intelligent reporting is implemented by the SSRS. The system achieved good effect by the actual applications in a number of transportation companies, which can provide accurate decision-making information for the passenger enterprise managers.

关 键 词：公路客运售票系统 数据仓库 ETL 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]