Dangerous chemical rapid identification method based on multiple databases

Abstract

The invention belongs to the field of dangerous chemical rapid identification, relates to a database technology, and aims to solve the problems that a traditional dangerous chemical identification method cannot establish and use a rapid identification database according to a queried and identified result, and cannot establish an auxiliary identification database for production, transportation and storage processes to help identify dangerous chemicals. The dangerous chemical rapid identification method comprises the following steps of establishing a standard identification database, querying chemical information of an identification object through an index, judging whether the chemical is a dangerous chemical or not, establishing a rapid identification database for switching use, and establishing an auxiliary identification database for auxiliary judgment. According to the method, the standard identification database and the rapid identification database are used in a switching manner, and the auxiliary identification database is used for assisting identification, so that the judgment efficiency of dangerous chemicals and the success rate of querying related records are improved.

Description

Technical Field

[0001] The invention belongs to the field of rapid identification of hazardous chemicals, relates to database technology, and specifically is a rapid identification method of hazardous chemicals based on multiple databases. Background Art

[0002] Hazardous chemicals refer to highly toxic chemicals and other chemicals that have properties such as toxicity, corrosion, explosion, combustion, and combustion-supporting, and are harmful to the human body, facilities, and the environment. With the development of the chemical industry, a large number of hazardous chemicals are produced, stored, transported, and used. They play a key role in many fields such as chemical raw materials, pesticides, and medicines. For example, in the pharmaceutical industry, the synthesis of many raw materials requires the use of corrosive or toxic hazardous chemicals.

[0003] During the production, storage, transportation and use of chemicals, due to their flammable, explosive, toxic and harmful properties, once accidents such as leakage, explosion or fire occur, they often cause serious damage to human life, property safety and the environment; in on-site emergency response, staff need to spend a lot of time sampling and testing unknown chemicals, and then compare and analyze them based on limited information or a single chemical database, which may lead to missing the best time for emergency response.

[0004] Traditional hazardous chemical identification methods mainly rely on manual inspection and single database query, which has the problem of low identification efficiency. In addition, a single database may have defects such as incomplete information. It is often impossible to establish and use a rapid identification database based on the results of the query and identification, nor is it possible to establish an auxiliary identification database for the production, transportation and storage processes to help identify hazardous chemicals, resulting in the inability to meet the needs of comprehensive and rapid identification of hazardous chemicals.

[0005] In view of the above technical problems, this application proposes a solution. Summary of the invention

[0006] The purpose of the present invention is to provide a method for rapid identification of hazardous chemicals based on multiple databases to solve the problem that the traditional method for identifying hazardous chemicals cannot establish and use a rapid identification database based on the results of the query and identification, and cannot establish an auxiliary identification database for the production, transportation and storage processes to help identify hazardous chemicals;

[0007] The technical problem to be solved by the present invention is how to provide a method for rapid identification of hazardous chemicals based on multiple databases, which can establish and use a rapid identification database based on the results of the query and identification, and establish an auxiliary identification database for the production, transportation and storage processes to help identify hazardous chemicals.

[0008] The purpose of the present invention can be achieved through the following technical solutions:

[0009] A method for rapid identification of hazardous chemicals based on multiple databases comprises the following steps:

[0010] Step 1: Collect comprehensive chemical information, establish a standard identification database based on the collected chemical information data, and establish primary and secondary indexes for the database;

[0011] Step 2: Mark the chemical to be identified as an identification object, and query the chemical information of the identification object through the index;

[0012] Step 3: Obtain the infrared spectrum of the identification object and determine the chemical formula of the identification object;

[0013] Step 4: Determine whether the identified object is a hazardous chemical based on its chemical information, and mark the identified object as a hazardous chemical as an object that can be quickly identified;

[0014] Step 5: Obtain the chemical information of the rapidly identifiable objects, and establish a rapid identification database according to the chemical information of the rapidly identifiable objects, and add a data column with the attribute "number of identifications" to record the number of identifications of each rapidly identifiable object;

[0015] Step 6: Before searching the database, use the standard identification database or the quick identification database through judgment;

[0016] Step 7: Obtain the production information, transportation information and storage information of the chemicals, and establish an auxiliary identification database based on the production information, transportation information and storage information to assist in identifying hazardous chemicals.

[0017] Furthermore, the specific process of establishing the standard identification database in step 1 includes: collecting comprehensive chemical information through an authoritative chemical catalog, the chemical information including the name, molecular formula, physical properties, chemical properties and hazardous properties of the chemical; wherein the physical properties include melting point, boiling point, density and solubility, the chemical properties include oxidizability, reducibility and acidity and alkalinity, and the hazardous properties include flammability, explosiveness, toxicity and corrosivity; when establishing the standard identification database according to the collected chemical information data, a relational database is created with the type of chemical information as the column data of the data table, and a row of records in the data table represents a piece of chemical information, wherein if the chemical has a certain hazardous property, the corresponding column data of its flammability, explosiveness, toxicity or corrosivity is marked as "yes", and if the chemical does not have a hazardous property, the corresponding column data of its flammability, explosiveness, toxicity and corrosivity is marked as "no"; at the same time, the name column in the column data is marked as the primary index when querying using the table, and the chemical formula column in the column data is marked as the secondary index when querying using the table.

[0018] Furthermore, the specific process of querying chemical information through index in step 2 includes: if the name of the identification object is known, querying the chemical information of the identification object through the primary index in the standard identification database; if the name of the identification object is unknown, first obtain the chemical formula of the identification object through step 3, and then query the chemical information of the identification object through the secondary index in the standard identification database.

[0019] Furthermore, the specific process of obtaining the chemical formula of the unknown chemical in step three includes: obtaining an infrared spectrum of the identification object through a Fourier infrared spectrometer, determining the functional groups and chemical bond types of the molecules according to the specific position and intensity of the absorption peaks, and further narrowing the range for comparison with the standard spectra of known compounds. If the characteristics of the absorption peak positions, shapes and intensities of the two are consistent, it is determined that the chemical formula of the identification object is the same as the chemical formula of the known compound.

[0020] Furthermore, the specific process of determining hazardous chemicals in step 4 includes: if the data columns of flammability, explosiveness, toxicity and corrosivity in the chemical information of the identification object are all "No", then the identification object is determined not to be a hazardous chemical; if the data columns of flammability, explosiveness, toxicity or corrosivity in the chemical information of the identification object contain "Yes", then the identification object is determined to be a hazardous chemical, and the identification object is marked as a quickly identifiable object.

[0021] Furthermore, the specific process of establishing a rapid identification database in step five includes: obtaining chemical information of rapidly identifiable objects, and establishing a rapid identification database according to the chemical information of rapidly identifiable objects, wherein the column data of the data table of the database is consistent with the column data of the standard identification database, and a data column with the attribute of "number of identifications" is added to record the number of identifications of each rapidly identifiable object, and whenever an identified object is judged to be a hazardous chemical, the number of identifications is increased by 1; at the same time, whenever the number of identifications of a rapidly identifiable object is updated, the data table of the rapid identification database is sorted in descending order according to the number of identifications.

[0022] Furthermore, the specific process of switching the use of the database in step six includes: when the hazardous chemical judgment is made by querying the chemical information of the identification object, the number of times the database is used for query and identification is marked as the total query number CC; if the standard identification database is queried first, and the query result shows that the identification object does not have a record in the fast identification database, then the query is marked as a normal query, and the number of normal queries PC is increased by 1; if the query result shows that the identification object already has a record in the fast identification database, that is, the number of identifications is not 0, then the query is marked as a slow query, and the number of slow queries MC is increased by 1; if the fast identification database is queried first, and the query result shows that the identification object already has a record in the fast identification database, that is, the number of identifications is not 0, then the query is marked as a fast query, and the number of fast queries KC is increased by 1; if the query result shows that the identification object does not have a record in the fast identification database, then the query is marked as an error query, and the number of error queries WC is increased by 1; the number of slow queries MC is compared with the total number of queries CC. The slow query ratio MB is calculated by the row ratio. Before the next query is performed through the standard recognition database, the slow query ratio MB is compared with the preset slow query threshold MBmax: if the slow query ratio MB is less than the slow query threshold MBmax, the database first queried is still the standard recognition database; if the slow query ratio MB is greater than or equal to the slow query threshold MBmax, the database first queried is switched to the fast recognition database; the fast query number KC is calculated by the ratio of the total query number CC to obtain the fast query ratio KB, and the error query number WC is calculated by the ratio of the total query number CC to obtain the error query ratio WB. Before the next query is performed through the fast recognition database, the fast query ratio KB and the error query ratio WB are compared with the fast query threshold KBmax and the error query threshold WBmax respectively: if the fast query ratio KB is less than the fast query threshold KBmax and the error query ratio is greater than or equal to the error query threshold WBmax, the database first queried is switched to the standard recognition database.

[0023] Furthermore, the specific process of establishing an auxiliary identification database for auxiliary judgment in step seven includes: obtaining the production information, transportation information and storage information of the chemical, the production information includes the production company, production line, production date, chemical name and hazardous properties; the transportation information includes the transportation quantity, transportation date, transportation route, chemical name and hazardous properties; the storage information includes the storage warehouse, storage quantity, storage date, chemical name and hazardous properties; establishing an auxiliary identification database according to the production information, transportation information and storage information, the auxiliary identification database includes a production database, a transportation database and a storage database; if the chemical needs to be identified as a hazardous chemical during the production, transportation and storage of the chemical, first query the auxiliary identification database to obtain the hazardous information of the chemical. If the relevant records cannot be queried, then determine the hazardous chemical by querying the standard identification database or the rapid identification database.

[0024] The present invention has the following beneficial effects:

[0025] 1. By establishing primary and secondary indexes for the standard identification database, chemical information of identification objects with known names and unknown chemical formulas can be quickly queried, improving the efficiency of database query and hazardous chemical judgment;

[0026] 2. By establishing a quick identification database based on the results of the query and sorting them according to the number of recognitions, the query efficiency when using the quick identification database query is improved;

[0027] 3. By judging the ratio of slow query, fast query and wrong query when using the standard identification database and the fast identification database, it is ensured that the fast identification database is used for query as much as possible, which improves the efficiency of judging hazardous chemicals and the success rate of querying relevant records;

[0028] 4. By establishing an auxiliary identification database for the production, transportation and storage processes of chemicals, the auxiliary identification database is used first when identifying hazardous chemicals in the production, transportation and storage environments, thereby improving the efficiency of identifying hazardous chemicals. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0030] Figure 1 is a flow chart of a method according to an embodiment of the present invention;

[0031] Figure 2 Schematic diagram of the data table structure of an embodiment of the present invention. DETAILED DESCRIPTION

[0032] The technical scheme of the present invention will be clearly and completely described below in conjunction with the embodiments. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0033] like Figure 1-2 As shown, a method for rapid identification of hazardous chemicals based on multiple databases includes the following steps:

[0034] Step 1: Establish a standard identification database: Collect comprehensive chemical information through authoritative chemical catalogs. Chemical information includes the name, molecular formula, physical properties, chemical properties and hazardous properties of chemicals. Among them, physical properties include melting point, boiling point, density and solubility, chemical properties include oxidizability, reducibility and acidity and alkalinity, and hazardous properties include flammability, explosiveness, toxicity and corrosivity. When establishing a standard identification database according to the collected chemical information data, create a relational database with the type of chemical information as the column data of the data table. A row of records in the data table represents a piece of chemical information. If the chemical has a certain hazardous property, the corresponding column data of its flammability, explosiveness, toxicity or corrosivity is marked as "yes". If the chemical does not have a hazardous property, the corresponding column data of its flammability, explosiveness, toxicity and corrosivity is marked as "no". At the same time, the name column in the column data is marked as the primary index when querying using the table, and the chemical formula column in the column data is marked as the secondary index when querying using the table.

[0035] Step 2: Query chemical information through index: Mark the chemical to be identified as an identification object. If the name of the identification object is known, query the chemical information of the identification object through the primary index in the standard identification database; if the name of the identification object is unknown, first obtain the chemical formula of the identification object through step 3, and then query the chemical information of the identification object through the secondary index in the standard identification database; by establishing a primary index and a secondary index for the standard identification database, it is possible to quickly query the chemical information of the identification object with a known name and an unknown chemical formula, thereby improving the efficiency of database query and the efficiency of hazardous chemical judgment;

[0036] Step 3: Obtain the chemical formula of the unknown chemical: Obtain the infrared spectrum of the identification object through Fourier infrared spectrometer, determine the functional group and chemical bond type of the molecule according to the specific position and intensity of the absorption peak, and further narrow the range and compare it with the standard spectrum of the known compound. If the characteristics of the absorption peak position, shape and intensity of the two are consistent, it is determined that the chemical formula of the identification object is the same as the chemical formula of the known compound;

[0037] Step 4: Determine hazardous chemicals: Determine the chemical information retrieved through the index. If the data columns of flammability, explosiveness, toxicity and corrosivity in the chemical information of the identified object are all "no", then the identified object is determined not to be a hazardous chemical; if the data columns of flammability, explosiveness, toxicity or corrosivity in the chemical information of the identified object contain "yes", then the identified object is determined to be a hazardous chemical and the identified object is marked as a quickly identifiable object;

[0038] Step 5: Establish a rapid identification database: obtain chemical information of rapidly identifiable objects, and establish a rapid identification database according to the chemical information of rapidly identifiable objects. The column data of the data table of the database is consistent with the column data of the standard identification database, and a data column with the attribute "number of identifications" is added to record the number of identifications of each rapidly identifiable object. Whenever an identified object is determined to be a hazardous chemical, the number of identifications is increased by 1; at the same time, whenever the number of identifications of a rapidly identifiable object is updated, the data table of the rapid identification database is sorted in descending order according to the number of identifications; by establishing a rapid identification database based on the results of the query and sorting it according to the number of identifications, the query efficiency when using the rapid identification database for query is improved;

[0039] Step 6: Database use switching: When determining hazardous chemicals by querying the chemical information of the identified object, the number of times the database is used for query and identification is marked as the total query number CC;

[0040] If the standard recognition database is queried first, and the query result shows that the recognition object does not exist in the fast recognition database, then the query is marked as a normal query, and the number of normal queries PC is increased by 1; if the query result shows that the recognition object already exists in the fast recognition database, that is, the number of recognitions is not 0, then the query is marked as a slow query, and the number of slow queries MC is increased by 1;

[0041] If the quick identification database is queried first, and the query result shows that the identification object already has a record in the quick identification database, that is, the number of identifications is not 0, then the query is marked as a quick query, and the number of quick queries KC is increased by 1; if the query result shows that the identification object does not have a record in the quick identification database, then the query is marked as an error query, and the number of error queries WC is increased by 1;

[0042] The slow query ratio MB is calculated by the ratio of the number of slow queries MC to the total number of queries CC. Before the next query is made through the standard recognition database, the slow query ratio MB is compared with the preset slow query threshold MBmax: if the slow query ratio MB is less than the slow query threshold MBmax, the database to be queried first is still the standard recognition database; if the slow query ratio MB is greater than or equal to the slow query threshold MBmax, the database to be queried first is switched to the fast recognition database;

[0043] The fast query ratio KB is calculated by calculating the ratio of the number of fast queries KC to the total number of queries CC, and the error query ratio WB is calculated by calculating the ratio of the number of wrong queries WC to the total number of queries CC. Before the next query is made through the fast identification database, the fast query ratio KB and the error query ratio WB are compared with the fast query threshold KBmax and the error query threshold WBmax respectively: if the fast query ratio KB is less than the fast query threshold KBmax and the error query ratio is greater than or equal to the error query threshold WBmax, the database to be queried first is switched to the standard identification database; by judging the ratio of slow query, fast query and error query when using the standard identification database and the fast identification database, it is ensured that the fast identification database is used for querying as much as possible, thereby improving the judgment efficiency of hazardous chemicals and the success rate of querying relevant records;

[0044] Step 7: Establish an auxiliary identification database for auxiliary judgment: obtain the production information, transportation information and storage information of the chemicals. The production information includes the production company, production line, production date, chemical name and hazardous properties; transportation information includes transportation quantity, transportation date, transportation route, chemical name and hazardous properties; storage information includes storage warehouse, storage quantity, storage date, chemical name and hazardous properties; establish an auxiliary identification database according to the production information, transportation information and storage information. The auxiliary identification database includes a production database, a transportation database and a storage database; if it is necessary to identify the chemicals as hazardous chemicals during the production, transportation and storage of chemicals, first query the auxiliary identification database to obtain the hazardous information of the chemicals. If the relevant records cannot be queried, then determine the hazardous chemicals by querying the standard identification database or the rapid identification database; by establishing an auxiliary identification database for the production, transportation and storage processes of chemicals, the auxiliary identification database is used first when identifying hazardous chemicals in the production, transportation and storage environments, thereby improving the efficiency of judging hazardous chemicals.

[0045] A method for rapid identification of hazardous chemicals based on multiple databases. When working, a standard identification database is established by collecting comprehensive chemical information, a primary index and a secondary index are established for the data table of the database, the chemical to be identified is marked as an identification object, the chemical information of the identification object is queried through the index, and whether it is a hazardous chemical is determined based on the chemical information, and the identification object is marked as a rapidly identifiable object, the chemical information of the rapidly identifiable object is obtained, and a rapid identification database is established according to the chemical information of the rapidly identifiable object, and before using the database for query, it is determined whether to use the standard identification database or the rapid identification database; finally, an auxiliary identification database is established based on the production information, transportation information and storage information of the chemical to help identify hazardous chemicals in the production, transportation and storage environments.

[0046] The above contents are merely examples and explanations of the structure of the present invention. The technicians in this technical field may make various modifications or additions to the specific embodiments described or replace them in a similar manner. As long as they do not deviate from the structure of the invention or exceed the scope defined by the claims, they should all fall within the protection scope of the present invention.

[0047] In the description of this specification, the description with reference to the terms "one embodiment", "example", "specific example", etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described can be combined in any one or more embodiments or examples in a suitable manner.

[0048] The preferred embodiments of the present invention disclosed above are only used to help explain the present invention. The preferred embodiments do not describe all the details in detail, nor do they limit the invention to only specific implementation methods. Obviously, many modifications and changes can be made according to the content of this specification. This specification selects and specifically describes these embodiments in order to better explain the principles and practical applications of the present invention, so that those skilled in the art can understand and use the present invention well. The present invention is limited only by the claims and their full scope and equivalents.

Claims

1. A method for rapid identification of hazardous chemicals based on multiple databases, characterized in that: The following steps are involved: Step 1: Collect comprehensive chemical information, establish a standard identification database based on the collected chemical information data, and establish primary and secondary indexes for the database; Step 2: Mark the chemical to be identified as an identification object, and query the chemical information of the identification object through the index; Step 3: Obtain the infrared spectrum of the identification object and determine the chemical formula of the identification object; Step 4: Determine whether the identified object is a hazardous chemical based on its chemical information, and mark the identified object as a hazardous chemical as an object that can be quickly identified; Step 5: Obtain the chemical information of the rapidly identifiable objects, and establish a rapid identification database according to the chemical information of the rapidly identifiable objects, and add a data column with the attribute "number of identifications" to record the number of identifications of each rapidly identifiable object; Step 6: Before searching the database, use the standard identification database or the quick identification database through judgment; Step 7: Obtain the production information, transportation information and storage information of the chemicals, and establish an auxiliary identification database based on the production information, transportation information and storage information to assist in the identification of hazardous chemicals.

2. The method for rapid identification of hazardous chemicals based on multiple databases according to claim 1 is characterized in that: The specific process of establishing the standard identification database in step 1 includes: collecting comprehensive chemical information through an authoritative chemical catalog, the chemical information includes the name, molecular formula, physical properties, chemical properties and hazardous properties of the chemical; wherein the physical properties include melting point, boiling point, density and solubility, the chemical properties include oxidizability, reducibility and acidity and alkalinity, and the hazardous properties include flammability, explosiveness, toxicity and corrosivity; when establishing the standard identification database according to the collected chemical information data, a relational database is created with the type of chemical information as the column data of the data table, and a row of records in the data table represents a piece of chemical information, wherein if the chemical has a certain hazardous property, the corresponding column data of its flammability, explosiveness, toxicity or corrosivity is marked as "yes", and if the chemical does not have a hazardous property, the corresponding column data of its flammability, explosiveness, toxicity and corrosivity is marked as "no"; at the same time, the name column in the column data is marked as the primary index when querying using the table, and the chemical formula column in the column data is marked as the secondary index when querying using the table.

3. The method for rapid identification of hazardous chemicals based on multiple databases according to claim 2 is characterized in that: The specific process of querying chemical information through index in step 2 includes: if the name of the identification object is known, querying the chemical information of the identification object through the primary index in the standard identification database; if the name of the identification object is unknown, first obtain the chemical formula of the identification object through step 3, and then query the chemical information of the identification object through the secondary index in the standard identification database.

4. The method for rapid identification of hazardous chemicals based on multiple databases according to claim 3 is characterized in that: The specific process of obtaining the chemical formula of the unknown chemical in step three includes: obtaining the infrared spectrum of the identification object through a Fourier infrared spectrometer, determining the functional group and chemical bond type of the molecule based on the specific position and intensity of the absorption peak, and further narrowing the range for comparison with the standard spectrum of the known compound. If the characteristics of the absorption peak position, shape and intensity of the two are consistent, it is determined that the chemical formula of the identification object is the same as the chemical formula of the known compound.

5. The method for rapid identification of hazardous chemicals based on multiple databases according to claim 4 is characterized in that: The specific process of determining hazardous chemicals in step 4 includes: if the data columns of flammability, explosiveness, toxicity and corrosivity in the chemical information of the identification object are all "no", then the identification object is determined not to be a hazardous chemical; if the data columns of flammability, explosiveness, toxicity or corrosivity in the chemical information of the identification object contain "yes", then the identification object is determined to be a hazardous chemical, and the identification object is marked as a quickly identifiable object.

6. The method for rapid identification of hazardous chemicals based on multiple databases according to claim 5 is characterized in that: The specific process of establishing a rapid identification database in step 5 includes: obtaining chemical information of rapidly identifiable objects, and establishing a rapid identification database according to the chemical information of rapidly identifiable objects. The column data of the data table of the database is consistent with the column data of the standard identification database, and a data column with the attribute "number of identifications" is added to record the number of identifications of each rapidly identifiable object. Whenever an identified object is judged to be a hazardous chemical, the number of identifications is increased by 1. At the same time, whenever the number of identifications of a rapidly identifiable object is updated, the data table of the rapid identification database is sorted in descending order according to the number of identifications.

7. The method for rapid identification of hazardous chemicals based on multiple databases according to claim 6 is characterized in that: The specific process of switching the use of the database in step six includes: when the hazardous chemical judgment is made by querying the chemical information of the identification object, the number of times the database is used for query and identification is marked as the total query number CC; if the standard identification database is queried first, and the query result shows that the identification object does not have a record in the rapid identification database, then the query is marked as a normal query, and the number of normal queries PC is increased by 1; if the query result shows that the identification object already has a record in the rapid identification database, that is, the number of identifications is not 0, then the query is marked as a slow query, and the number of slow queries MC is increased by 1; if the rapid identification database is queried first, and the query result shows that the identification object already has a record in the rapid identification database, that is, the number of identifications is not 0, then the query is marked as a fast query, and the number of fast queries KC is increased by 1; if the query result shows that the identification object does not have a record in the rapid identification database, then the query is marked as an error query, and the number of error queries WC is increased by 1; the number of slow queries MC is compared with the total number of queries CC. The slow query ratio MB is calculated by the value. Before the next query is performed through the standard recognition database, the slow query ratio MB is compared with the preset slow query threshold MBmax: if the slow query ratio MB is less than the slow query threshold MBmax, the database first queried is still the standard recognition database; if the slow query ratio MB is greater than or equal to the slow query threshold MBmax, the database first queried is switched to the fast recognition database; the fast query number KC is calculated by the ratio of the total query number CC to obtain the fast query ratio KB, and the error query number WC is calculated by the ratio of the total query number CC to obtain the error query ratio WB. Before the next query is performed through the fast recognition database, the fast query ratio KB and the error query ratio WB are compared with the fast query threshold KBmax and the error query threshold WBmax respectively: if the fast query ratio KB is less than the fast query threshold KBmax and the error query ratio is greater than or equal to the error query threshold WBmax, the database first queried is switched to the standard recognition database.

8. The method for rapid identification of hazardous chemicals based on multiple databases according to claim 7 is characterized in that: The specific process of establishing an auxiliary identification database for auxiliary judgment in step seven includes: obtaining the production information, transportation information and storage information of the chemical, the production information includes the production company, production line, production date, chemical name and hazardous properties; transportation information includes transportation quantity, transportation date, transportation route, chemical name and hazardous properties; storage information includes storage warehouse, storage quantity, storage date, chemical name and hazardous properties; establishing an auxiliary identification database according to the production information, transportation information and storage information, the auxiliary identification database includes a production database, a transportation database and a storage database; if the chemical needs to be identified as a hazardous chemical during the production, transportation and storage of the chemical, first query the auxiliary identification database to obtain the hazardous information of the chemical. If the relevant records cannot be queried, then determine the hazardous chemical by querying the standard identification database or the rapid identification database.

Images