TWI674507B - Sudden disaster immediate inspection system - Google Patents

Abstract

A sudden disaster real-time investigation and debugging system includes a disaster data downloading device, a disaster trial calculation table generating device, a structured query language data server, and a disaster data comparison server. The disaster situation data downloading device is used to download a disaster situation data, and the disaster trial table generating device is connected to the disaster situation data downloading device to generate a disaster trial calculation table based on the disaster situation data. The structured query language data server is connected to the disaster trial spreadsheet generating device to import the disaster trial spreadsheet. The disaster data comparison server is connected to the structured query language data server to compare the disaster trial spreadsheet with the loaner data.

Description

Instant disaster investigation and investigation system

The present invention relates to a system for instant investigation and investigation of sudden disasters, and in particular to a system for instant investigation and investigation of sudden disasters to credit customers.

Taiwan is located in the subtropical zone and is located on the Pacific Rim seismic belt. Therefore, it is subject to natural disasters such as typhoons, heavy rain, drought, cold currents, and earthquakes every year.

According to statistics over the years, Taiwan has an average of about 3 to 4 typhoons per year, and an average of 24.4 earthquakes with a scale greater than 5 occur. As far as meteorological disasters are concerned, the direct loss of property due to severe weather in Taiwan averages about NT $ 15 billion per year, and in terms of earthquake disasters, an average of one catastrophic earthquake occurs about one year.

Some scholars have researched and observed that after entering 2018, earthquakes and volcanic eruptions in the Ring of Fire region continued.The United Nations International Strategy for Disaster Reduction (UNISDR) in 2018 1 A post was posted on Twitter on May 23 stating that the Pacific Rim is already active.

However, when sudden disasters occur, the exposed and marked disaster blocks are often scattered due to the fragment of information published, so it is difficult to obtain and grasp the complete and detailed information on the extent and extent of disasters of individual loaners in real time. Generally, comprehensive inventory, filtering, and statistics can only be performed manually, which requires a lot of labor and time investment, and the final comparison result is difficult to guarantee complete accuracy.

Therefore, how to assist the affected households to actively rebuild in the event of a sudden disaster, so as to effectively protect the safety of people's lives and property, and thereby improve the overall competitiveness of the country.

This summary is intended to provide a simplified summary of this disclosure so that readers may have a basic understanding of this disclosure. This summary is not a comprehensive overview of the disclosure, and it is not intended to indicate important / critical elements of the embodiments of the invention or to define the scope of the invention.

One of the objectives of the present invention is to provide a system for instant investigation and investigation of sudden disasters, so as to facilitate financial institutions to quickly understand the actual extent of the disaster in the affected area, and to provide financial assistance required by the victims.

In order to achieve the above object, a technical aspect of the present invention relates to a sudden disaster real-time investigation system including a disaster data downloading device, a disaster trial spreadsheet generating device, a structured query language data server, and a disaster data Match server.

The disaster situation data downloading device is used to download a disaster situation data, and the disaster trial table generating device is connected to the disaster situation data downloading device to generate a disaster trial calculation table based on the disaster situation data. The structured query language data server is connected to the disaster trial spreadsheet generating device to import the disaster trial spreadsheet. The disaster data comparison server is connected to the structured query language data server to compare the disaster trial spreadsheet with the loaner data.

In addition, the emergency disaster real-time investigation system further includes a loaner data server connected to the disaster data comparison server to provide the aforementioned loaner data.

In one embodiment, the device for generating a trial trial table includes a trial area generator for a disaster area to generate a trial area trial table based on disaster data.

In one embodiment, the device for generating a disaster trial list includes a trial list generator for disaster casualties, which is connected to the trial list generator for the disaster area to generate a trial casual list based on disaster data.

In one embodiment, the sudden disaster real-time investigation and checking system further includes a loan data output device for the affected household, which is connected to the disaster data comparison server to output a loan data table for the affected household according to the comparison result.

In one embodiment, the emergency disaster real-time investigation and adjustment system further includes a disaster situation investigation and checklist output device, which is connected to the disaster household loan data output device, so as to output a disaster situation inspection and checklist based on the disaster household loan information form. .

In one embodiment, the emergency disaster real-time investigation and adjustment system further includes a financial assistance data output device, which is connected to the disaster investigation and checklist output device. In order to export a financial assistance data sheet according to the disaster situation investigation and checklist and the subsidy method issued by the competent authority.

In one embodiment, the emergency disaster real-time investigation system further includes a disaster situation announcement server connected to the disaster situation data downloading device to release the disaster situation data.

In one embodiment, the disaster situation announcement server includes a government unit disaster situation announcement server or a private unit disaster situation announcement server.

Therefore, the above-mentioned instant disaster investigation and investigation system can facilitate financial institutions to use computerized automatic processing to quickly generate disaster investigation and investigation checklists and immediately transmit them to nearby branches within the disaster area for immediate inspection, filtering, tracking and reporting. In order to clarify and master the actual disaster extent of the credit customers and provide necessary financial assistance.

After referring to the following embodiments, those with ordinary knowledge in the technical field to which the present invention pertains can easily understand the basic spirit and other inventive objectives of the present invention, as well as the technical means and implementation aspects adopted by the present invention.

100‧‧‧ Instant Disaster Investigation and Investigation System

101‧‧‧ disaster announcement server

110‧‧‧ Disaster information download device

120‧‧‧ disaster generating table generating device

122‧‧‧ Affected area generator

124‧‧‧ Trial table generator for disaster casualties list

130‧‧‧ Structured Query Language Data Server

140‧‧‧Compare server for disaster data

150‧‧‧loan account information server

160‧‧‧Loan data output device for victims

170‧‧‧ Disaster investigation checklist output device

180‧‧‧ Financial assistance data output device

In order to make the above and other objects, features, advantages, and embodiments of the present invention more comprehensible, the description of the drawings is as follows: FIG. 1 is a diagram illustrating an instantaneous disaster investigation and investigation according to an embodiment of the present invention. Schematic of the system.

According to the usual operation method, various features and components in the figure are not drawn to scale. The drawing method is to present the specific features and components related to the present invention in an optimal way. In addition, between different drawings, the same or similar element symbols are used to refer to similar elements / components.

In order to make the description of this disclosure more detailed and complete, the following provides an illustrative description of the implementation mode and specific embodiments of the present invention; but this is not the only form of implementing or using the specific embodiments of the present invention. The embodiments include the features of a plurality of specific embodiments, as well as the method steps and their order for constructing and operating these specific embodiments. However, other specific embodiments can also be used to achieve the same or equal functions and sequence of steps.

Unless otherwise defined in this specification, the meanings of scientific and technical terms used herein are the same as those understood and used by those having ordinary knowledge in the technical field to which the present invention pertains. In addition, when not in conflict with the context, the singular noun used in this specification covers the plural form of the noun; and the plural noun used also covers the singular form of the noun.

In addition, as used herein, "connected" may mean that two or more elements are in direct physical or electrical contact with each other, or indirectly make physical or electrical contact with each other, or that two or more elements are in operation with each other or Actions, or connections through a network, do not depart from the spirit and scope of the present invention. Furthermore, the components such as systems, devices, components, and servers used in this article can be run on each independent computer host or device, or they can be operated and integrated in one or more computer hosts or devices. Without departing from the spirit and scope of the invention.

FIG. 1 is a schematic diagram of an instant disaster investigation and investigation system according to an embodiment of the present invention. As shown in the figure, the instantaneous disaster real-time investigation system 100 includes a disaster information downloading device 110 and a disaster trial spreadsheet. A health device 120, a structured query language data server 130, a disaster data comparison server 140, and a loaner data server 150.

The disaster situation data downloading device 110 is connected to a disaster situation announcement server 101 via the network to download a disaster situation data. Among them, the disaster situation announcement server 101 may be a government unit disaster situation announcement server, or a private unit disaster situation announcement server with credibility.

The instant disaster investigation and investigation system disclosed by the present invention can be used to investigate and investigate the loss of personnel, houses and property caused by various sudden disasters or events, such as Kaohsiung 103/07/31 The gas explosion accident, the Tainan earthquake of 105/02/06, and the Hualian earthquake of 107/02/06 can also be extended to disasters such as wind, cold and epidemic.

When a sudden disaster occurs, the disaster situation data downloading device 110 may download the relevant disaster situation data and transmit it to the disaster trial table generating device 120 connected to the disaster situation data downloading device 110. The disaster data downloading device 110 downloads the statistical data or other reference information published by the government on the disaster situation, and after filtering, rectifying and editing the disaster trial table generating device 120, it generates a disaster trial calculation table based on the disaster data. The disaster trial table generating device 120 includes a disaster area range trial table generator 122 and a disaster casualty list trial table generator 124 connected to the disaster area range trial table generator 122 to generate a disaster area trial table based on the disaster situation data. And a trial list of disaster casualties.

Structured Query Language (SQL; Structured Query Language) data server 130 is connected to the disaster trial spreadsheet generating device 120 to import the disaster trial spreadsheet and the names of the disaster casualties Single trial balance. The disaster data comparison server 140 is connected to the structured query language data server 130 to compare the disaster trial calculation table with the loaner data.

The loan account information server 150 is connected to the disaster data comparison server 140 to provide the aforementioned loan account information. The disaster data comparison server 140 performs cross-comparison based on the loaner data of the loaner data server 150 and the data of the affected households in the structured query language data server 130, that is, to screen the relevant financial institutions for housing and land as guarantee Relevant data of individual loan households are compared with the imported disaster area range trial table and disaster casualty list trial table to query the corresponding loan details.

In one embodiment, the emergency disaster real-time surveying and checking system 100 further includes an affected household loan data output device 160 connected to the affected data comparison server 140 to output an affected household loan data table according to the comparison result.

In one embodiment, the emergency disaster real-time investigation and adjustment system 100 further includes a disaster situation investigation and checklist output device 170, which is connected to the affected household loan data output device 160 to output a disaster situation investigation and adjustment according to the affected household loan information form. Checklists to provide immediate branches of financial institutions located within the disaster area to conduct immediate inspection, filtering, tracking, and reporting to credit customers of the actual level of disaster.

In one embodiment, the emergency disaster real-time investigation and adjustment system 100 further includes a financial assistance data output device 180, which is connected to the disaster investigation and investigation checklist output device 170, so as to be issued according to the disaster investigation and investigation checklist and the competent authority. The subsidy method outputs a financial assistance data sheet to provide the necessary financial assistance to the affected customers in a timely manner.

To sum up, a sudden disaster instant investigation system disclosed in an embodiment of the present invention can refer to the government announcement when a sudden disaster occurs. The disaster situation information is automatically processed by the computer, and a disaster situation investigation and checklist is quickly generated, which is immediately transmitted to the nearby branches within the disaster area, and it is immediately checked, filtered, tracked and reported to clarify and grasp the actual disaster extent of the credit customers and provide Necessary financial assistance. In addition, through SQL program automation and systematic integration, linking, filtering, grouping, and statistical processing procedures, it can save time for manual review and comparison and avoid artificial calculation and interpretation errors, which can effectively improve disaster data statistics. Efficiency and correctness, while reducing labor costs.

Although the above embodiments disclose specific examples of the present invention, they are not intended to limit the present invention. Those with ordinary knowledge in the technical field to which the present invention pertains should not deviate from the principles and spirit of the present invention. Various changes and modifications can be made to it, so the scope of protection of the present invention shall be defined by the scope of the accompanying patent application.

Claims (8)

An instant disaster investigation and investigation system includes: a disaster data downloading device to download a disaster data; a disaster trial table generating device connected to the disaster data downloading device to generate a disaster trial calculation table based on the disaster data A structured query language data server connected to the disaster trial table generating device to import the disaster trial table; a disaster data comparison server connected to the structured query language data server to perform the disaster Comparison of the trial balance with the loaner's data; and a loaner's data server connected to the disaster data comparison server to provide the loaner's data, wherein the disaster trial table generating device includes a disaster area range trial table A generator to generate a trial area of the affected area based on the disaster information. The system for real-time investigation and investigation of sudden disasters according to claim 1, wherein the disaster trial table generating device includes a disaster casualty list trial table generator, which is connected to the disaster area range trial table generator, according to the disaster information, Generate a trial spreadsheet of the list of disaster casualties. The sudden disaster real-time surveying system as described in claim 2, further includes a loan data output device for the affected household, which is connected to the disaster data comparison server to output a loan data table for the affected household according to the comparison result. The system for real-time investigation and investigation of sudden disasters as described in claim 3 further includes a disaster situation investigation checklist output device connected to the disaster household loan data output device to output a disaster situation investigation according to the disaster household loan data form Inspection checklist. The emergency disaster real-time investigation and adjustment system as described in claim 4, further includes a financial assistance data output device connected to the disaster investigation and investigation checklist output device, so that the disaster investigation and investigation checklist and the competent authority may order The subsidy method issued will output a financial assistance data sheet. The system for real-time investigation and investigation of sudden disasters as described in claim 1, further includes a disaster situation announcement server connected to the disaster situation data downloading device to publish the disaster situation data. The system for real-time investigation and investigation of sudden disasters according to claim 6, wherein the disaster situation announcement server includes a government unit disaster situation announcement server. The sudden disaster real-time investigation system according to claim 6, wherein the disaster situation announcement server includes a civil unit disaster situation announcement server.