基于数据仓库的易制毒化学品分析系统

Analysis System of Precursor Chemicals Based on Data Warehouse

近年来,数据仓库技术飞速发展,已成为国内外学者的研究热点之一。目前,在易制毒化学品行业,企业数据仓库的研究还鲜见报道,易制毒化学品的数据仓库和一般行业的数据仓库相比有其独特的性质。主要是依托于《易制毒化学品监督管理信息系统》八省一市等9个数据库,结合易制毒化学品行业的业务流程,构建企业数据仓库,并对其数据进行可视化展示和数据深度分析,进而为企业和监管部门的决策提供充分的数据支持。Oracle数据库中包括湖北省和湖南省等全国八省一市的易制毒化学品交易数据。

In recent years, the data warehouse technology develops rapidly and has become one of research hotspot of scholars both at home and abroad. At present, in the precursor chemicals industry, the study of enterprise data warehouse is rarely reported. The data warehouse of precursor chemicals has its unique properties compared to the data warehouse of general industry. Based on the nine databases of eight provinces and one city of Precursor Chemicals Supervision and Administration Infomaation System, this paper establishes the enterprise data warehouse combining with the businegs processes of precursor chemicals industry, and performs data visualization display and data analysis to provide sufficient data support for decision making of enterprises and supervision and administration departments. The Oracle database includes the dealing data of precursor chemicaLs of eight provinces and one city of Hubei province, Hu＇ nan province, etc.