TWM563600U - Sudden disaster immediate inspection system - Google Patents

Abstract

A sudden disaster immediate inspection system includes a disaster data downloading device, a disaster spreadsheet generating device, a structured query language data server and a disaster data matching server. The disaster data downloading device is used to download a disaster data, and the disaster spreadsheet generating device is connected to the disaster data downloading device to generate a disaster spreadsheet according to the disaster data. The structured query language data server connected to the disaster spreadsheet generating device to import the disaster spreadsheet. The disaster data matching server is connected to the structured query language data server to compare the disaster spreadsheet with loan data.

Description

Sudden disaster immediate inspection system

This new type relates to an immediate disaster detection system for sudden disasters, and in particular to an instant investigation system for sudden disasters of credit customers.

Taiwan is located in the subtropical zone and is located in the Pacific Rim earthquake zone. Therefore, it suffers from natural disasters such as typhoons, heavy rains, droughts, cold currents and earthquakes every year.

According to statistics from previous years, an average of 3-4 typhoons per year hit Taiwan in Taiwan, and an average of 24.4 earthquakes occurred on a scale greater than 5. As far as meteorological disasters are concerned, the annual loss of direct property caused by severe weather in Taiwan is about NT$15 billion per year. Among them, in the case of earthquake disasters, an average of one disaster occurred in about one year.

Some scholars have studied and observed that after 2018, earthquakes and volcanic eruptions in the Ring of Fire region continued, and the United Nations International Strategy for Disaster Reduction (UNISDR) was in 2018. 1 On the 23rd, it was posted on Twitter that the Pacific Rim belt is already active.

However, when a sudden disaster occurs, the distribution of the exposed and marked disaster blocks is often scattered due to the published message fragments. Therefore, it is difficult to obtain and grasp the complete and detailed disaster coverage and the degree of disasters of the individual loan households. Generally, it is only possible to perform comprehensive inventory, filtering and statistics by manual, which requires a lot of manpower and time cost investment, and the final comparison result is difficult to ensure completely correct.

Therefore, in the event of a sudden disaster, it can assist the affected households to actively rebuild, in order to effectively protect the lives and property of the people, and thus enhance the overall competitiveness of the country.

The novel content is intended to provide a simplified summary of the disclosure in order to provide a basic understanding of the disclosure. This Summary is not an extensive overview of the disclosure, and is not intended to identify key/critical elements of the novel embodiments or the scope of the invention.

One of the contents of this new content is to provide an emergency investigation system for sudden disasters, so that financial institutions can quickly understand the actual degree of disasters in the affected areas and provide financial assistance for the victims.

In order to achieve the above objectives, one of the technical aspects of the present invention relates to an emergency disaster detection system comprising a disaster data downloading device, a disaster test spreadsheet generating device, a structured query language data server, and a disaster data. Compare the server.

The disaster data downloading device is configured to download a disaster information, and the disaster test spreadsheet generating device is connected to the disaster data downloading device to generate a disaster trial spreadsheet according to the disaster 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 loan household data.

In addition, the sudden disaster detection system further includes a loan account data server connected to the disaster data comparison server to provide the aforementioned loan household information.

In an embodiment, the disaster recovery spreadsheet generating device includes a disaster area range spreadsheet generator to generate a disaster area trial calculation table according to the disaster data.

In an embodiment, the disaster recovery spreadsheet generating device includes a disaster-stricken list trial generator, and is connected to the disaster area range trial generator to generate a trial list of the disaster casualty list according to the disaster data.

In an embodiment, the sudden disaster recovery system further includes a disaster victim loan data output device connected to the disaster data comparison server to output a disaster victim loan data table according to the comparison result.

In an embodiment, the sudden disaster detection system further includes a disaster check and check check output device connected to the affected household loan data output device to output a disaster check check form according to the disaster victim loan data table. .

In an embodiment, the sudden disaster detection system further includes a financial assistance data output device, which is connected to the disaster check and check form output device. Set up a financial assistance data sheet based on the investigation and checklist and the subsidy method prescribed by the competent authority.

In an embodiment, the sudden disaster detection system further includes a disaster information publishing server connected to the disaster data downloading device to issue the disaster information.

In an embodiment, the disaster notification server includes a government unit disaster notification server or a civil unit disaster situation advertisement server.

Therefore, the above-mentioned sudden disaster detection system can facilitate financial institutions to use computer automated processing, quickly generate disaster check and checklists, and immediately transmit them to nearby branches within the scope of disasters, and immediately carry out inventory, filtering, tracking and return. In order to clarify and grasp the actual degree of disaster of credit customers and provide necessary financial assistance.

The basic spirit and other novel objects of the present invention, as well as the technical means and implementations of the present invention, can be readily understood by those of ordinary skill in the art.

100‧‧‧Instantaneous disaster detection system

101‧‧‧ Disaster Reporting Server

110‧‧‧ Disaster data downloading device

120‧‧‧ Disaster Trial Balance Generation Device

122‧‧‧Study area range trial generator

124‧‧‧Terrorist casualty list spreadsheet generator

130‧‧‧ Structured Query Language Data Server

140‧‧‧ Disaster data comparison server

150‧‧‧ loan account data server

160‧‧‧Resident household loan data output device

170‧‧‧Disaster check and checklist output device

180‧‧‧Financial Assistance Data Output Device

The above and other objects, features, advantages and embodiments of the present invention will be more apparent and understood. The description of the drawings is as follows: FIG. 1 shows an instant investigation of sudden disasters according to an embodiment of the present invention. Schematic diagram of the system.

The various features and elements in the figures are not drawn to scale, and are in the In addition, similar elements/components are referred to by the same or similar element symbols throughout the different drawings.

In order to make the description of the present disclosure more detailed and complete, the following description of the embodiments of the present invention and the specific embodiments thereof are set forth. The features of various specific embodiments, as well as the method steps and sequences thereof, are constructed and manipulated in the embodiments. However, other specific embodiments may be utilized to achieve the same or equivalent function and sequence of steps.

Unless otherwise defined in the specification, the meaning of the scientific and technical terms used herein is the same as that of ordinary skill in the art. In addition, the singular noun used in this specification covers the plural of the noun in the case of no conflict with the context; the plural noun of the noun is also included in the plural noun used.

In addition, the term "connected" as used herein may mean that two or more elements are in direct physical or electrical contact with each other, or indirectly in physical or electrical contact with each other, or that two or more elements are interoperable or Actions, or connections through the Internet, do not depart from the spirit and scope of the present invention. Furthermore, the components, devices, components, and servers used herein may be operated in separate computer mainframes or devices, and may be operated and integrated in one or more computer mainframes or devices. They do not deviate from the spirit and scope of this new model.

FIG. 1 is a schematic diagram showing an emergency disaster detection system according to an embodiment of the present invention. As shown in the figure, the sudden disaster disaster detection system 100 includes a disaster data downloading device 110 and a disaster trial data sheet. The device 120, a structured query language data server 130, a disaster data comparison server 140, and a loan home data server 150.

The disaster data downloading device 110 is connected to the disaster information publishing server 101 to download a disaster information. The disaster situation disclosure server 101 may be a government unit disaster situation announcement server, or a credible civil unit disaster situation announcement server.

The sudden detection and adjustment system for sudden disasters disclosed in the present invention can be applied to the situation of personnel, housing and property disaster losses caused by various sudden disasters or events, such as 103/07/31 Kaohsiung. Gas explosion accidents, the 105/02/06 Tainan earthquake and the 107/02/06 Hualien earthquake can also be extended to disasters such as windstorms, cold damage and epidemics.

When a sudden disaster occurs, the disaster data downloading device 110 can download the related disaster information and transmit it to the disaster-tested spreadsheet generating device 120 connected to the disaster data downloading device 110. The disaster data downloading device 110 downloads the statistics or other reference information of the disaster situation announced by the government, and after the screening, sizing, and editing by the disaster risking spreadsheet generating device 120, a disaster trial spreadsheet is generated according to the disaster information. The disaster recovery trial calculation device 120 includes a disaster area range trial generator 122 and a disaster victim list trial generator 124 connected to the disaster area range trial generator 122 to generate a disaster area trial calculation table according to the disaster data. And a trial list of disaster victims.

The structured query language (SQL; Structured Query Language) data server 130 is connected to the disaster-tested spreadsheet generating device 120 to import the disaster-stricken trial balance table of the disaster-tested spreadsheet and the name of the affected casualty. Single trial calculation. The disaster data comparison server 140 is connected to the structured query language data server 130 to perform comparison between the disaster trial spreadsheet and the loan household data.

The loan household data server 150 is connected to the disaster data comparison server 140 to provide the aforementioned loan household information. The disaster information comparison server 140 cross-compacts according to the loan household data of the loan household data server 150 and the data of the affected households in the structured query language data server 130, that is, screening the relevant financial institutions for housing and land as security. The relevant information of the individual loan households is compared with the trial area of the affected area and the trial list of the affected casualty list to check the corresponding loan details.

In an embodiment, the sudden disaster disaster detection system 100 further includes a disaster victim loan data output device 160 connected to the disaster data comparison server 140 to output a disaster victim loan data table according to the comparison result.

In an embodiment, the sudden disaster detection system 100 further includes a disaster check check output device 170 connected to the disaster victim loan data output device 160 to output a disaster check according to the disaster victim loan data table. Check the form to provide the nearest branch of the financial institution within the scope of the disaster, and immediately check, filter, track and report the actual damage degree of the credit customer.

In an embodiment, the sudden disaster detection system 100 further includes a financial assistance data output device 180 connected to the disaster check check output device 170 for checking and checking the checklist according to the disaster situation and the competent authority The subsidy method is to export a financial assistance data sheet to provide the necessary financial assistance for the affected customers.

In summary, an emergency disaster detection system disclosed in an embodiment of the present invention can be announced by the government in the event of a sudden disaster. The disaster data will be automatically processed by the computer, and the disaster check and checklist will be quickly generated and immediately transmitted to the nearby branches within the scope of the disaster, and the inventory, filtering, tracking and return will be immediately carried out to clarify and grasp the actual disaster degree of the credit customer and provide Financial assistance necessary. In addition, through the automation and system of SQL program integration, linking, screening, grouping and statistics processing procedures, can save manual and one-by-one review and comparison time and avoid human calculation and interpretation errors, can effectively improve disaster statistics Efficiency and correctness, while reducing labor costs.

The specific embodiments of the present invention are disclosed in the above embodiments, and are not intended to limit the present invention. Those of ordinary skill in the art to which the present invention pertains, without departing from the spirit and scope of the present invention, Various changes and modifications may be made thereto, and the scope of protection of the present invention is defined by the scope of the accompanying claims.

Claims (10)

An emergency disaster detection and control system includes: a disaster situation data downloading device for downloading a disaster situation data; a disaster recovery trial calculation device connected to the disaster data downloading device to generate a disaster trial spreadsheet according to the disaster situation data a structured query language data server connected to the disaster trial spreadsheet generating device for importing the disaster trial spreadsheet; and a disaster data matching server connected to the structured query language data server to perform the Comparison of the disaster trial balance sheet with the loan household data. The emergency disaster detection system according to claim 1 further includes a loan household data server connected to the disaster data comparison server to provide the loan household data. The sudden disaster disaster detection system according to claim 2, wherein the disaster diagnosis spreadsheet generating device comprises a disaster area range trial table generator, to generate a disaster area trial calculation table according to the disaster situation data. The sudden disaster disaster detection system according to claim 3, wherein the disaster recovery spreadsheet generating device comprises a disaster-stricken list trial generator, connected to the disaster area range trial generator, according to the disaster data, Generate a trial list of disaster victims. The emergency disaster detection system according to claim 4 further includes a disaster victim loan data output device connected to the disaster data comparison server to output a disaster victim loan data table according to the comparison result. The emergency disaster detection and control system according to claim 5 further includes a disaster situation check and check form output device, and is connected to the disaster victim loan data output device to output a disaster situation check according to the disaster victim loan data table. Check the checklist. The emergency disaster detection system according to claim 6 further includes a financial assistance data output device connected to the disaster situation check and check form output device, according to the disaster check check form and the competent authority The subsidy method is issued and a financial assistance data sheet is output. The emergency disaster detection system according to claim 1 further includes a disaster notification server connected to the disaster data downloading device to issue the disaster information. The emergency disaster detection system according to claim 8, wherein the disaster situation advertisement server comprises a government unit disaster situation advertisement server. The emergency disaster detection system according to claim 8, wherein the disaster situation advertisement server comprises a civil unit disaster situation announcement server.