Forest fire database management system and method

Abstract

The invention relates to the technical field of databases, and discloses a forest fire database management system and method, and the system comprises an input module which is used for inputting forest fire data, and carrying out the data storage through an Sql Server database; the query module is used for inputting query keywords to query forest fire data, and the query keywords comprise a fire site, fire time and a fire extinguishing year; the statistical display module is used for counting forest fire data and outputting a statistical table and a statistical chart; and the printing module is used for printing the statistical table and the statistical chart. According to the method, data entry, query, analysis and output are seamlessly combined, the working efficiency is improved, the error rate of manual operation is reduced, the method is suitable for comprehensive management and deep mining of forest fire information by forestry departments and research institutions, and powerful support is provided for improvement of forest fire prevention and emergency response capabilities.

Description

Technical Field

[0001] The present invention relates to the technical field of databases, and more particularly, to a forest fire database management system and method. Background Art

[0002] Forest fires are one of the main threats faced by global forest ecosystems, and their destructive impact on the ecological environment and social economy is extremely significant. Especially in the context of intensified climate change, the frequency and intensity of forest fires are increasing continuously, and the importance of fire monitoring, prevention and control, and management is becoming increasingly prominent. However, traditional fire data management methods mainly rely on paper records or decentralized storage, which have problems such as low data management efficiency, inconvenient query, and difficult statistical analysis, and are difficult to meet the needs of modern disaster prevention and mitigation work. With the rapid development of information technology, database management systems have gradually become effective tools for fire information management. Among them, relational databases (such as SqlServer) are widely used in various data-intensive scenarios due to their high data processing capabilities and flexible query functions.

[0003] Existing forest fire data management technologies have many problems, mainly reflected in the inefficiency of data storage and processing methods, the complexity of information query and statistical analysis, and the lack of result display. Traditional fire data mostly rely on manual records or decentralized storage, lacking a unified platform for integrated management, resulting in difficult data access, easy loss or duplication, low efficiency, and inability to quickly locate specific fire information. In terms of statistical analysis, due to the lack of automated tools, it often relies on manual calculation and chart making, which is prone to human errors, and the result display form is single, making it inconvenient to comprehensively analyze data trends and laws. In addition, the lack of an effective statistical result output and sharing mechanism leads to the lack of intuitiveness of the basis for prevention and control decisions.

[0004] Therefore, it is necessary to provide a forest fire database management system and method to solve the problems of inefficient data storage, complex query and statistical analysis, and insufficient result display in existing forest fire data management technologies. Summary of the Invention

[0005] In view of this, the present invention proposes a forest fire database management system and method, aiming to solve the problems of inefficient data storage, complex query and statistical analysis, and insufficient result display in existing forest fire data management technologies.

[0006] On the one hand, the present invention proposes a forest fire database management system, including:

[0007] An input module for inputting forest fire data and storing the data using a Sql Server database;

[0008] A query module for inputting query keywords to query forest fire data, where the query keywords include: the location of the fire, the time of the fire, and the year of fire extinguishment;

[0009] A statistical display module for statistically analyzing forest fire data and outputting statistical tables and statistical charts;

[0010] A printing module for printing the statistical tables and statistical charts.

[0011] Furthermore, the input module includes:

[0012] A batch import unit for inputting an Excel table in which several forest fire data are recorded;

[0013] A single entry unit for inputting single-item forest fire data;

[0014] An information supplement unit for supplementing and improving incomplete forest fire data.

[0015] Furthermore, when the query module does not input query keywords, all forest fire data are displayed in the query window.

[0016] Furthermore, the statistical tables include:

[0017] Forest fire loss statistical tables, forest fire cause statistical tables, forest fire distribution statistical tables, forest fire category statistical tables, forest fire type statistical tables, and forest type statistical tables.

[0018] In some embodiments of the present application, the statistical charts include:

[0019] Annual change statistical charts of forest fires, monthly change statistical charts, daily change statistical charts, and regional change statistical charts.

[0020] Furthermore, the annual change statistical charts include frequency annual change statistical charts, affected forest area annual change statistical charts, and burned area annual change statistical charts;

[0021] The monthly change statistical charts include frequency monthly change statistical charts, affected forest area monthly change statistical charts, and burned area monthly change statistical charts;

[0022] The daily change statistical charts include daily change frequency statistical charts, affected forest area daily change statistical charts, and burned area daily change statistical charts;

[0023] The regional change statistical charts include regional frequency change statistical charts, regional affected forest area change statistical charts, and regional burned area change statistical charts.

[0024] Compared with the prior art, the beneficial effects of the present invention are as follows: The forest fire database management system can greatly improve the management and utilization efficiency of fire data. Through the input module, users can conveniently enter fire-related data into the system, and realize the efficient storage and management of data based on the reliability and scalability of the Sql Server database. The query module supports quickly locating target data through key fields (such as the fire location, fire time, and extinguishing year), meeting the multi-dimensional query needs of users for historical data, and greatly saving time. The statistical display module can automatically generate statistical tables and statistical charts, providing strong support for users to intuitively display the distribution and trend of fire data, helping to discover patterns, optimize resource allocation, and formulate scientific prevention and control strategies. The printing module enables the statistical results to be generated into physical reports at any time, facilitating sharing and archiving. Overall, the system seamlessly combines data entry, query, analysis, and output, not only improving work efficiency but also reducing the error rate of manual operations. It is applicable to the comprehensive management and in-depth mining of forest fire information by forestry departments and research institutions, providing strong support for enhancing forest fire prevention and emergency response capabilities.

[0025] On the other hand, the present application also provides a method for managing a forest fire database, including:

[0026] Input forest fire data and store the data using the Sql Server database;

[0027] Input query keywords to query forest fire data, where the query keywords include: fire location, fire time, and extinguishing year;

[0028] Statistical forest fire data and output statistical tables and statistical charts;

[0029] Print the statistical tables and statistical charts.

[0030] It can be understood that a forest fire database management system and method provided by the present application have the same beneficial effects, which will not be elaborated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] By reading the detailed description of the preferred embodiments below, various other advantages and benefits will become clear to those of ordinary skill in the art. The drawings are only for the purpose of showing the preferred embodiments and are not considered to be a limitation of the present invention. Moreover, throughout the drawings, the same reference numerals are used to represent the same components. In the drawings:

[0032] Figure 1 is a functional block diagram of the forest fire database management system provided by an embodiment of the present invention;

[0033] Figure 2Schematic diagram of the forest fire database management system provided by the embodiments of the present invention;

[0034] Figure 3 Schematic diagram of the forest fire data imported by the batch import unit provided by the embodiments of the present invention;

[0035] Figure 4 Schematic diagram before the batch import unit provided by the embodiments of the present invention imports;

[0036] Figure 5 Schematic diagram after the batch import unit provided by the embodiments of the present invention finishes importing;

[0037] Figure 6 Schematic diagram of the single entry unit provided by the embodiments of the present invention;

[0038] Figure 7 Schematic diagram of the information supplement entry unit provided by the embodiments of the present invention;

[0039] Figure 8 Schematic diagram of the query module provided by the embodiments of the present invention;

[0040] Figure 9 Schematic diagram of the statistical display module provided by the embodiments of the present invention;

[0041] Figure 10 Schematic diagram of the forest fire loss statistics provided by the embodiments of the present invention;

[0042] Figure 11 Schematic diagram of the forest fire cause statistics provided by the embodiments of the present invention;

[0043] Figure 12 Schematic diagram of the forest fire distribution statistics provided by the embodiments of the present invention;

[0044] Figure 13 Schematic diagram of the forest fire category statistics provided by the embodiments of the present invention;

[0045] Figure 14 Schematic diagram of the forest type statistics provided by the embodiments of the present invention;

[0046] Figure 15 Statistical graph of the interannual change of the number of times provided by the embodiments of the present invention;

[0047] Figure 16 Statistical graph of the interannual change of the damaged forest area provided by the embodiments of the present invention;

[0048] Figure 17 Statistical graph of the interannual change of the burned area provided by the embodiments of the present invention;

[0049] Figure 18Statistical chart of the change in the area of damaged forests in the regions provided by the embodiments of the present invention;

[0050] Figure 19 Statistical chart of the change in the number of times in the regions provided by the embodiments of the present invention;

[0051] Figure 20 Statistical chart of the change in the burned area in the regions provided by the embodiments of the present invention;

[0052] Figure 21 Flowchart of the forest fire database management method provided by the embodiments of the present invention. Detailed implementation manners

[0053] Hereinafter, exemplary embodiments of the present disclosure will be described in more detail with reference to the accompanying drawings. Although the exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided so that the present disclosure can be more thoroughly understood and the scope of the present disclosure can be completely conveyed to those skilled in the art. It should be noted that, without conflict, the embodiments in the present invention and the features in the embodiments can be combined with each other. Hereinafter, the present invention will be described in detail with reference to the drawings and in conjunction with the embodiments.

[0054] In some embodiments of the present application, referring to Figure 1 and Figure 2 as shown, this embodiment provides a forest fire database management system, including:

[0055] An input module, configured to input forest fire data and store the data using an Sql Server database;

[0056] Referring to Figure 8 , a query module, configured to input query keywords to query forest fire data, where the query keywords include: the location of the fire, the time of the fire, and the year of extinguishing the fire;

[0057] Referring to Figure 9 , a statistical display module, configured to statistically process forest fire data and output statistical tables and statistical charts;

[0058] A printing module, configured to print the statistical tables and statistical charts.

[0059] It is understandable that the forest fire database management system can greatly improve the management and utilization efficiency of fire data. Through the input module, users can conveniently input fire-related data into the system, and realize the efficient storage and management of data based on the reliability and scalability of the Sql Server database. The query module supports quickly locating target data through key fields (such as the fire location, fire time, and extinguishing year), meeting the users' multi-dimensional query needs for historical data, and greatly saving time. The statistical display module can automatically generate statistical tables and statistical charts, providing strong support for intuitively showing the distribution and trend of fire data for users, helping to discover patterns, optimize resource allocation, and formulate scientific prevention and control strategies. The printing module enables the statistical results to generate physical reports at any time, facilitating sharing and archiving. Generally speaking, the system seamlessly combines data input, query, analysis, and output, not only improving work efficiency but also reducing the error rate of manual operations. It is applicable to the comprehensive management and in-depth mining of forest fire information by forestry departments and research institutions, providing strong support for improving forest fire prevention and emergency response capabilities.

[0060] In some embodiments of the present application, the input module includes:

[0061] Refer to Figures 3 - 5 , a batch import unit for inputting an excel table in which several forest fire data are recorded;

[0062] Refer to Figure 6 , a single entry unit for inputting single-item forest fire data;

[0063] Refer to Figure 7 , an information supplement unit for supplementing and perfecting incomplete forest fire data previously.

[0064] It is understandable that the input module of the present invention greatly improves the flexibility and efficiency of data input through three different input methods. The batch import unit supports batch input of a large amount of forest fire data by importing an Excel table, avoiding the cumbersome work of inputting item by item, greatly improving the speed and accuracy of data import, and being applicable to the management needs of large-scale data. The single entry unit is suitable for inputting single-item fire data, facilitating the processing of individual fire incidents, and ensuring the accuracy and integrity of the data. The information supplement unit can supplement and modify incomplete or incorrect data previously input, ensuring the continuous update and improvement of the data, and reducing the risk of data loss or inconsistency. This diversified input method enables the system to adapt to different data collection needs, improves the usability of the system and the integrity of data management, and helps to more accurately support the analysis and decision-making of forest fires.

[0065] In some embodiments of the present application, when the query module does not input a query keyword, the query window displays all forest fire data.

[0066] See Figures 9 - 14 , in some embodiments of the present application, the statistical table includes:

[0067] Forest fire loss statistical table, forest fire cause statistical table, forest fire distribution statistical table, forest fire category statistical table, forest fire type statistical table, and forest type statistical table.

[0068] In some embodiments of the present application, the statistical chart includes:

[0069] Annual change statistical chart of forest fires, monthly change statistical chart, daily change statistical chart, and regional change statistical chart.

[0070] It can be understood that the query and statistical functions of the present invention provide highly flexible and comprehensive data analysis capabilities. When the query module does not input a query keyword, it can display all forest fire data, facilitating users to comprehensively view and analyze the entire dataset and quickly obtain global information. The statistical table covers multi-dimensional data analysis such as forest fire losses, causes, distributions, categories, types, and forest types, providing the ability to conduct in-depth statistics and understanding of fire data from multiple perspectives, helping users identify potential patterns and trends. The statistical chart shows changes in different dimensions such as annual, monthly, daily, and regional, providing users with a more intuitive trend analysis and facilitating the identification of spatio-temporal patterns of fire occurrence. The integration of these statistical functions greatly enhances the visualization and operability of data, helps provide accurate fire prevention and control basis for decision-makers, and strengthens the dynamic monitoring and management of forest fires.

[0071] See Figures 15 - 20 , in some embodiments of the present application, the annual change statistical chart includes the annual change statistical chart of the number of times, the annual change statistical chart of the affected forest area, and the annual change statistical chart of the burned area;

[0072] The monthly change statistical chart includes the monthly change statistical chart of the number of times, the monthly change statistical chart of the affected forest area, and the monthly change statistical chart of the burned area;

[0073] The daily change statistical chart includes the daily change statistical chart of the number of times, the daily change statistical chart of the affected forest area, and the daily change statistical chart of the burned area;

[0074] The regional change statistical chart includes the regional change statistical chart of the number of times, the regional change statistical chart of the affected forest area, and the regional change statistical chart of the burned area.

[0075] It can be understood that through the refined statistical charts, the spatio-temporal analysis of forest fire data by the present invention is more comprehensive and accurate. The inter-annual change statistical chart includes the inter-annual changes in the number of times, the affected forest area, and the burned area, which can help analyze the long-term trends and scale changes of fire occurrences and provide a basis for adjusting annual prevention and control strategies. The monthly change statistical chart, by counting the number of fires, the affected forest area, and the burned area each month, facilitates the identification of seasonal changes and potential high-incidence months, and further optimizes resource allocation and early warning mechanisms. The daily change statistical chart provides the changes in daily fire data, helping to monitor the frequency and affected range of fires in the short term and ensuring a quick response. The regional change statistical chart, through regional analysis, reveals the fire occurrence patterns in different regions, facilitating the adoption of regional prevention and control measures. Overall, these refined statistical charts provide multi-dimensional fire data analysis, enhance the readability of the data and the decision-making support ability, and contribute to more accurately predicting fire trends, evaluating the prevention and control effects, and implementing scientific forest fire management.

[0076] Preferably, the forest fire database management system is a software for managing forest fire information. The database management system is based on forest fire information, uses the Sql Server database for data storage, and is programmed with the PowerBuilder language. It can realize functions such as the statistics, calculation, and plotting of forest fire data. This database management system has a powerful data storage function, accurate calculation and plotting of fire data, and is easy to operate. It can provide convenient and accurate services for the management of forest fire information and is an essential office software for forest fire prevention work departments.

[0077] On the other hand, referring to Figure 21 as shown, the present application also provides a forest fire database management method, which is applied to the above-mentioned forest fire database management system and includes the following steps:

[0078] S100. Input forest fire data and use the Sql Server database for data storage;

[0079] S200. Input query keywords to query forest fire data, where the query keywords include: the location of the fire, the time of the fire, and the year of extinguishment;

[0080] S300. Statistic the forest fire data and output statistical tables and statistical charts;

[0081] S400. Print the statistical tables and statistical charts.

[0082] It is understandable that the forest fire database management method provided by this application realizes the efficient management and comprehensive analysis of forest fire data through a series of systematic steps, and has significant application advantages. In step S100, the Sql Server database is used to store forest fire data, which not only improves the stability and scalability of data storage, but also supports the efficient management of massive data, laying a solid foundation for subsequent analysis. In step S200, users can quickly retrieve specific fire events by inputting key query words (such as the location of the fire, the time of the fire, and the year of extinguishing the fire), greatly improving the efficiency and accuracy of data query. In addition, step S300 provides users with a comprehensive and intuitive data display by statistically analyzing fire data and generating multi-dimensional statistical tables and statistical charts, including information on the causes, distributions, and types of forest fires, etc., and at the same time supports the analysis of inter-annual, monthly, and regional change trends, helping users to understand fire patterns and optimize prevention and control measures. Finally, step S400 realizes the print output of statistical results, facilitating report generation and sharing, and enhancing the flexibility of data utilization. Overall, this method organically combines data input, query, statistics, and output, not only improving the efficiency of forest fire management, but also providing strong technical support for scientific decision-making, and is an important tool for forest fire prevention and control and management.

[0083] Those skilled in the art should understand that the embodiments of this application can be provided as a method, a system, or a computer program product. Therefore, this application can adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, this application can adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0084] This application is described with reference to the flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to the embodiments of this application. It should be understood that each flow and / or block in the flowcharts and / or block diagrams can be implemented by computer program instructions, and the combination of flows and / or blocks in the flowcharts and / or block diagrams can also be implemented by computer program instructions. These computer program instructions can be provided to the processors of general-purpose computers, special-purpose computers, embedded processors, or other programmable data processing devices to generate a machine, so that the instructions executed by the processors of the computer or other programmable data processing devices generate a device for realizing the functions specified in Figure 1 one or more of the flows or multiple flows and / or blocks Figure 1 one or more of the blocks or multiple blocks.

[0085] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to operate in a particular manner, such that the instructions stored in the computer-readable memory produce a manufacture including an instruction device that implements the functions specified in one or more of the flows Figure 1 one or more flows and / or boxes Figure 1 specified in the boxes.

[0086] These computer program instructions can also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer-implemented process, whereby the instructions executed on the computer or other programmable apparatus provide steps for implementing the functions specified in one or more of the flows Figure 1 one or more flows and / or boxes Figure 1 specified in the boxes.

[0087] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit them. Although the present invention has been described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications or equivalent replacements can still be made to the specific embodiments of the present invention. Any modification or equivalent replacement that does not depart from the spirit and scope of the present invention shall be covered by the protection scope of the claims of the present invention.

Claims

1. A forest fire database management system, characterized in that: include: Input module, used to input forest fire data and use SqlServer database for data storage; A query module, used to input query keywords to query forest fire data, wherein the query keywords include: fire location, fire time and fire extinguishing year; Statistical display module, used to count forest fire data and output statistical tables and charts; The printing module is used to print the statistical tables and statistical graphs.

2. The forest fire database management system according to claim 1, characterized in that: The input module comprises: A batch import unit is used to input an Excel table, in which a number of forest fire data are recorded; A single entry unit for entering single forest fire data; The information supplement unit is used to supplement and improve previously incomplete forest fire data.

3. The forest fire database management system according to claim 1, characterized in that: When no query keyword is input into the query module, the query window displays all forest fire data.

4. The forest fire database management system according to claim 1, characterized in that: The statistical table includes: Statistics table of forest fire losses, causes of forest fires, distribution of forest fires, categories of forest fires, types of forest fires and forest types.

5. The forest fire database management system according to claim 1, characterized in that: The statistical graphs include: Statistical charts of annual, monthly, daily and regional changes in forest fires.

6. The forest fire database management system according to claim 5, characterized in that: The inter-annual variation statistical graphs include inter-annual variation statistical graphs of the number of times, inter-annual variation statistical graphs of the affected forest area and inter-annual variation statistical graphs of the burned area; The monthly change statistics graphs include the monthly change statistics graphs of the number of times, the monthly change statistics graphs of the affected forest area and the monthly change statistics graphs of the burned area; The daily change statistics graph includes a daily change frequency statistics graph, a daily change statistics graph of damaged forest area and a daily change statistics graph of burned area; The regional change statistics chart includes a regional frequency change statistics chart, a regional damaged forest area change statistics chart and a regional burned area change statistics chart.

7. A forest fire database management system method, applied to the forest fire database management system according to any one of claims 1 to 6, characterized in that: include: Input forest fire data and use SqlServer database for data storage; Enter query keywords to query forest fire data, wherein the query keywords include: fire location, fire time and fire extinguishing year; Collect forest fire data and output statistical tables and charts; Print the statistical table and statistical graph.

Images