基于数据仓库的科学仪器设备数据分析系统

Scientific instrument and equipment data analysis system based on data warehouse

如何节省在科学仪器设备管理工作中对数据分析投入的人力物力并提高管理效率是科技管理部门十分关注的问题。利用数据仓库技术可以对现有的科学仪器设备数据进行多维分析,以便有效利用分析数据辅助管理者决策。文章据此分析了科学仪器设备数据源,提出了分析主题,通过模型设计、ETL功能以及OLAP功能的设计,实现了一个基于数据仓库的科学仪器设备数据分析系统。系统的开发研究证明了数据仓库技术在科学仪器设备管理上应用的可行性,并为进一步建立基于数据仓库的科技数据决策支持系统打下了基础。

How to save the manpower and material resources of data analysis and improve the efficiency of management in scientific instruments and equipment management work is one of the focuses of the management department of science and technology. The data warehouse technology can be used to make multi -dimensional analysis of the exiting data of scientific instruments and equipment, so as to make use of the analysis data to help managers make decisions effectively. Based on the technology, this paper analyzes the data sources of scientific instruments and e- quipment, proposes the analysis theme, and implements a data analysis system of scientific instruments and equipment based on data warehouse by designing data model, Extract Transform Load （ETL） and Online Analytical Processing （OLAP） model. The research and development of this system proves the feasibility of the application of data warehouse in scientific instruments and equipment management work, furthermore, it builds a foundation for the science and technology data decision support system based on data warehouse.