Skip to Main Content
According to the management needs for scientific research projects, this paper propose a framework that combines data warehouse as the basis, OLAP, association rule, and apply it into the projects analysis of Science and Technology Bureau in Handan City. As a practical implementation of the framework, the Handan City Science and Technology Plan Project Implementation Survey System was developed. The system provided the administrator an convenient and effective data analysis envioronment and generated statistical reports which describes the execution status, distribution and trend of the projects in the form of summarizing table, broken line chart, pie chart and histogram. It performed refinement from multiple aspects such as annual projects distribution, funds, workload, number of the staff, benefits to provide management and decision-making related information to guide scientific research project.