Design And Realization Of Statistical Querying System Of Sunspot Drawing Information

The Yunnan Astronomical Observatory of the Chinese Academy of Sciences has accumulated nearly 16,000 sunspot drawings over the years.Among them,digital data of sunspot drawings includes nearly 90,000 sunspot records,and more than one million effective records.In order to carry out scientific management and statistical analysis of these massive data,it is necessary to establish a perfect query and statistics system.The system provides a platform for data management,data retrieval,data statistical analysis,including sunspot information library,sunspot information query,sunspot information statistical analysis and other modules.With the data management system,long-period statistics can be made on the sunspot-related parameters.The establishment of this system will help to promote effective utilization and research of the historical data of sunspots in China's astronomical career.In this paper,the scientific significance of establishing the information query and statistics system of the hand drawing of sunspot of our country and the current research status of establishing the sunspot database in the world are described in detail,and the application prospect of building the information query and statistics system of the hand-painted map of sunspot in China is also introduced.Then the related technologies used in the system are introduced and analyzed,including the development environment,the architecture selection,the database and the various third party framework technologies.In the following system requirements analysis,the general description of the functional requirements,functional requirements and system function structure diagrams of the sunspot handwriting information query and statistics system are introduced,as well as the feasibility analysis of various aspects.Then the selection and design of the system are introduced,including the framework selection of the sunspot drawing information statistics querying system,the overall design scheme of the system,the module introduction,and the E-R diagram and table design in the database design.The last is the implementation and testing of the system,including detailed diagrams of each function module of the sunspot handwriting information system,core data structure and code,and UI display of corresponding functions.At the same time,some parameters of sunspot data were statistically analyzed.At the same time,some parameters of sunspot data were statistically analyzed.The establishment of the information statistics querying system of the drawing of sunspot is the first time to carry out a large-scale and complete historical data collection and online publication of the historical data of the hand-painted sunspot in China.It can not only provide digitalized data of hand painted sunspots,but also provide query and statistical analysis of related parameters in the hand drawing of sunspot.This greatly facilitates the use of historical sunspot data in China by users at home and abroad.