Dangerous chemical database design method and system

Abstract

The embodiment of the invention provides a dangerous chemical database design method and system, and belongs to the technical field of data processing. The system comprises a system management module, a database management module, a hazardous chemical data module, a scene adaptation module and a dynamic analysis and evaluation module. The system management module comprises a user management sub-module and a role management sub-module; the database management module comprises a hazardous chemical substance data management sub-module and a report data management sub-module; the hazardous chemical substance data management sub-module is used for newly adding, editing and deleting hazardous chemical substance data; the report data management sub-module is used for newly adding, editing and deleting report data; the hazardous chemical data module is used for storing data information of chemicals; the scene adaptation module is used for adapting to different management scenes; the dynamic analysis and evaluation module is used for generating a management scheme. According to the invention, customer groups can be analyzed according to basic data, customer resources can be developed in a targeted manner, and statistical data of chemical risk assessment can be summarized and processed.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a hazardous chemicals database design method and system. Background Art

[0002] With the development of the chemical industry and related industries, the types and quantities of chemicals have increased dramatically. These substances have entered people's lives and work through production, transportation, storage, and use. While the existence of chemicals has brought tremendous benefits to the development of modern society, they also pose serious threats to human health and the environment due to their inherent hazards. The proliferation of chemical databases has provided diverse user groups with more ways to access chemical information. However, current chemical databases generally focus on information on single chemicals, with limited information on mixed chemicals, making it difficult for users to access comprehensive chemical information. Summary of the Invention

[0003] The main purpose of the embodiments of the present application is to provide a hazardous chemicals database design method and system.

[0004] The technical solution adopted by the present invention is:

[0005] On the one hand, an embodiment of the present invention provides a hazardous chemicals database system, the system including a system management module, a database management module, a hazardous chemical data module, a scenario adaptation module, and a dynamic analysis and evaluation module;

[0006] The system management module includes a user management submodule and a role management submodule;

[0007] The user management submodule is used to manage user registration information; the role management submodule is used to set user roles and permissions;

[0008] The database management module includes a hazardous chemicals data management submodule and a report data management submodule;

[0009] The hazardous chemicals data management submodule is used to add, edit, and delete hazardous chemicals data; the report data management submodule is used to add, edit, and delete report data;

[0010] The hazardous chemical data module is used to store data information of chemicals;

[0011] The scenario adaptation module is used to adapt to different management scenarios; the management scenarios include hazardous chemical chemical parks and cross-border transportation;

[0012] The dynamic analysis and evaluation module is used to generate a management plan; the management plan includes an emergency response plan and an environmental protection plan; the emergency response plan includes leakage disposal and evacuation simulation; the environmental protection plan includes waste disposal recommendations and hazardous chemical safe storage recommendations.

[0013] Furthermore, the database management module also includes a hazardous chemicals data index submodule and a report data index submodule;

[0014] The hazardous chemicals data index submodule is used to provide retrieval of hazardous chemicals data;

[0015] The report data index submodule is used to query historical chemical report data.

[0016] Furthermore, the hazardous chemical data module includes hazardous chemical report data and basic data of hazardous chemicals;

[0017] The hazardous chemical report data includes the contract number information, sample name, production unit information, and hazard information of the hazardous chemicals;

[0018] The basic data of hazardous chemicals include the name of the chemical, CAS number, hazard category, health hazards, environmental hazards, transportation requirements, storage and usage precautions.

[0019] Furthermore, the hazardous chemicals database system further includes a login management module;

[0020] The login management module includes a user login submodule, a self-service registration submodule, and a password retrieval submodule;

[0021] The user login submodule is used to provide a function for registered users to enter their account number and password to log in to the system;

[0022] The self-service registration submodule is used to provide a registration channel for users;

[0023] The password retrieval submodule provides a retrieval function when the password is forgotten.

[0024] Furthermore, the hazardous chemicals database system also includes a personal management module;

[0025] The personal management module includes a homepage submodule, a data modification submodule, a password modification submodule, and a logout function submodule;

[0026] The homepage submodule is used to view the homepage interface of personal information;

[0027] The data modification submodule is used to modify personal data; the personal data includes email and contact information;

[0028] The password modification submodule is used to modify the login password;

[0029] The deregistration function submodule is used to deregister an account.

[0030] Furthermore, the hazardous chemicals database system also includes a universal data interface;

[0031] The universal data interface is used to provide an interface for importing and exporting data, and supports uploading data sources in EXCEL file format.

[0032] On the other hand, an embodiment of the present invention further provides a hazardous chemical database design method for designing and implementing a hazardous chemical database system as described in any of the above items, the method comprising the following steps:

[0033] A hazardous chemicals database system is designed by establishing system management module, database management module, hazardous chemical data module, scenario adaptation module, and dynamic analysis and evaluation module.

[0034] Furthermore, the hazardous chemicals database design method further includes the following steps:

[0035] Establish registration, login, and data retrieval functions based on the web page;

[0036] Provide log viewing and user management functions;

[0037] Set data access permissions for different roles, including common users and administrators.

[0038] Furthermore, the hazardous chemicals database design method further includes the following steps:

[0039] Determine the data items that need to be stored by analyzing the hazardous chemical report data and the data of the hazardous chemicals themselves;

[0040] According to the data items, database table information is designed; the database table information includes basic information of chemicals, hazard information, health hazards, environmental hazards, and safe storage and transportation information.

[0041] Furthermore, the hazardous chemicals database design method further includes the following steps:

[0042] Develop data interfaces and set up the data interfaces to support importing data from external systems;

[0043] Design data redundancy and backup mechanisms.

[0044] The embodiments of the present application include at least the following beneficial effects: The present application provides a hazardous chemical database design method and system. The system of the present invention includes a system management module, a database management module, a hazardous chemical data module, a scenario adaptation module, and a dynamic analysis and evaluation module; the system management module includes a user management submodule and a role management submodule; the user management submodule is used to manage user registration information; the role management submodule is used to set user roles and permissions; the database management module includes a hazardous chemical data management submodule and a report data management submodule; the hazardous chemical data management submodule is used to add, edit, and delete hazardous chemical data; the report data management submodule is used to add, edit, and delete report data; the hazardous chemical data module is used to store chemical data information; the scenario adaptation module is used to adapt to different management scenarios; and the dynamic analysis and evaluation module is used to generate management plans. The present invention can analyze customer groups based on basic data, develop customer resources in a targeted manner, and summarize and process statistical data for chemical risk assessment. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 is a schematic diagram of a hazardous chemicals database system provided by an embodiment of the present invention;

[0046] Figure 2 This is a diagram of the overall framework of the database provided by an embodiment of the present invention;

[0047] Figure 3 It is a schematic diagram of the database backend architecture provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0048] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are only used to explain the present application and are not intended to limit the present application. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the embodiments of the present application. They are merely examples of devices and methods consistent with some aspects of the embodiments of the present application as detailed in the appended claims.

[0049] It will be understood that the terms "first", "second", etc. used in this application may be used herein to describe various concepts, but unless otherwise specified, these concepts are not limited by these terms. These terms are only used to distinguish one concept from another. For example, without departing from the scope of the embodiments of the present application, the first information may also be referred to as the second information, and similarly, the second information may also be referred to as the first information. Depending on the context, the words "if" and "if" as used herein may be interpreted as "at the time of" or "when" or "in response to determining".

[0050] The terms "at least one", "plurality", "each", "any", etc. used in this application include "at least one", "two" or more, "plurality" or "each", "any" or "any one", "each" or "any one" in the context of the present invention, and "at least one" or "at least one" includes one, two or more, "plurality" or "any one" includes two or more, "each" or "each one" in the context of the present invention, and "any" or "any one

[0051] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the art to which this application pertains. The terms used herein are for the purpose of describing the embodiments of this application only and are not intended to limit this application.

[0052] The present invention takes into account the fact that with the development of the chemical industry and related industries, the types and quantities of chemicals have also increased dramatically. These substances have entered people's lives and work through production, transportation, storage, use and other channels. The existence of chemicals has brought great benefits to the development of modern society. At the same time, due to their inherent dangers, they also pose a serious threat to human health and the environment. Humans need to master information on all aspects of chemicals and continuously understand, control, develop and transform them to reduce the pollution of chemicals to the environment and the harm to human health. Therefore, databases related to chemical properties are also increasing, providing useful information and data for people to study chemicals. However, since chemical properties and related information cover a very wide range of content, including physicochemical properties, health hazards, environmental hazards, safe storage and transportation, safe production and use, first aid measures, chemical classification, detection and analysis, etc., it is difficult for a single database to collect all the information on chemicals. Most databases focus more on one or more aspects of the characteristics of chemicals.

[0053] Before explaining the embodiments of the present application in detail, some of the nouns and terms involved in the embodiments of the present application are first explained. The nouns and terms involved in the embodiments of the present application are subject to the following explanations.

[0054] 1) CAS number (Chemical Abstracts Service Number) is a unique identification code assigned to chemical substances by the Chemical Abstracts Service (CAS).

[0055] 2) UN number (United Nations Number) is a unique number assigned by the United Nations for the global transportation of dangerous goods.

[0056] The embodiments of the present invention are further described below with reference to the accompanying drawings.

[0057] On the one hand, an embodiment of the present invention provides a hazardous chemicals database system, referring to Figure 1,The system includes system management module, database management module, hazardous chemical data module, scenario adaptation module, and dynamic analysis and evaluation module;

[0058] The system management module includes the user management submodule and the role management submodule;

[0059] The user management submodule is used to manage user registration information; the role management submodule is used to set user roles and permissions;

[0060] The database management module includes the hazardous chemicals data management submodule and the report data management submodule;

[0061] The hazardous chemicals data management submodule is used to add, edit, and delete hazardous chemicals data; the report data management submodule is used to add, edit, and delete report data;

[0062] The hazardous chemical data module is used to store data information of chemicals;

[0063] The scenario adaptation module is used to adapt to different management scenarios; management scenarios include hazardous chemical chemical parks and cross-border transportation;

[0064] The dynamic analysis and evaluation module is used to generate management plans; management plans include emergency response plans and environmental protection plans; emergency response plans include leakage disposal and evacuation simulation; environmental protection plans include waste disposal recommendations and hazardous chemical safe storage recommendations.

[0065] As an optional implementation, the system management module of the present invention is mainly used by system administrators and involves the management of user permissions and roles:

[0066] User management function: Administrators can view, modify, delete user information, and manage user registration information.

[0067] Role management function: Administrators can set roles and permissions for different users and control access to data.

[0068] The modules in the present invention cooperate with each other to form a hazardous chemical database system. The system management module provides system security and authority control through user management and role management submodules; the database management module is responsible for the management of hazardous chemical data and report data, providing data support for the system; the hazardous chemical data module stores basic data of chemicals, providing a core data source for dynamic analysis and evaluation; the scenario adaptation module adjusts system functions according to different scenarios (such as chemical parks, cross-border transportation), increasing the applicability and flexibility of the system. The dynamic analysis and evaluation module is the core innovation of the system. It performs real-time data analysis and risk assessment based on the chemical property data (such as toxicity, reactivity, etc.) provided by the hazardous chemical data module and the scenario information (such as geographical location, environmental conditions, etc.) provided by the scenario adaptation module, and generates emergency response plans (such as leak disposal, evacuation simulation) and environmental protection plans (such as waste treatment recommendations, safe storage recommendations). By integrating the data of the hazardous chemical data module and the scenario adaptation module, the dynamic analysis and evaluation module can realize accurate dynamic analysis and evaluation technology, provide scientific and efficient decision support for hazardous chemical management, and achieve environmental compliance and sustainable development.

[0069] The database management module disclosed in the embodiment of the present invention further includes a hazardous chemicals data index submodule and a report data index submodule;

[0070] The hazardous chemicals data index submodule is used to provide retrieval of hazardous chemicals data;

[0071] The report data index submodule is used to query historical chemical report data.

[0072] As an optional implementation, the database management module of the present invention is mainly responsible for operations such as data uploading, classification, and retrieval, specifically including:

[0073] Report data index function: open to the public, supports querying historical chemical report data.

[0074] Report data management function: open to administrators, with the functions of adding, editing, and deleting report data, and supports fuzzy query.

[0075] Hazardous chemicals data index function: open to the public, providing retrieval of commonly used hazardous chemicals data.

[0076] Hazardous chemicals data management function: open to administrators, supports adding, editing, and deleting hazardous chemicals data, and supports fuzzy queries.

[0077] Data upload function: supports administrators to import data into the system, usually in the form of Excel files.

[0078] The hazardous chemical data module disclosed in the embodiment of the present invention includes hazardous chemical report data and basic data of hazardous chemicals;

[0079] Hazardous chemical report data includes contract number information, sample name, production unit information, and hazard information of hazardous chemicals;

[0080] Basic data on hazardous chemicals include the chemical name, CAS number, hazard category, health hazards, environmental hazards, transportation requirements, storage and usage precautions.

[0081] As an optional embodiment, the hazardous chemical data module of the present invention is the core module of the database, which contains data information related to all chemicals, mainly including:

[0082] Hazardous chemical report data: includes detailed report data of hazardous chemicals, such as contract number, sample name, production unit, hazard information, etc., which is mainly managed by the system administrator.

[0083] Basic data on hazardous chemicals: including chemical name, CAS number, hazard category, health hazards, environmental hazards, transportation requirements, storage and use precautions, etc. The data source comes from authoritative databases such as the "Catalogue of Hazardous Chemicals" and the "CAMEO Chemical Database".

[0084] The hazardous chemicals database system disclosed in the embodiment of the present invention further includes a login management module;

[0085] The login management module includes the user login submodule, the self-registration submodule, and the password retrieval submodule;

[0086] The user login submodule is used to provide registered users with the function of entering their account and password to log into the system;

[0087] The self-service registration submodule is used to provide users with a registration channel;

[0088] The password retrieval submodule provides a retrieval function when you forget your password.

[0089] As an optional implementation manner, the login management module of the embodiment of the present invention includes:

[0090] User login function: Provides registered users with the function of entering their account number and password to log into the system.

[0091] Self-service registration function: users can register a new account via email.

[0092] Password recovery function: Provides a recovery function when you forget your password, usually through email verification to recover the password.

[0093] Administrator function: System administrators can add, delete, and query users, and manage user login information, roles, and permissions.

[0094] View modification log function: Administrators can view users' operation logs and modification records to ensure system security.

[0095] The hazardous chemicals database system disclosed in the embodiment of the present invention further includes a personal management module;

[0096] The personal management module includes the homepage submodule, information modification submodule, password modification submodule, and logout function submodule;

[0097] The homepage submodule is used to view the homepage interface of personal information;

[0098] The data modification submodule is used to modify personal information; personal information includes email and contact information;

[0099] The password modification submodule is used to modify the login password;

[0100] The logout function submodule is used to log out the account.

[0101] The personal management module in this embodiment of the present invention mainly handles the management of user personal information, specifically including:

[0102] Home page: The home page interface where users view their personal information after logging in.

[0103] Information modification: Users can modify their personal information (such as email address, contact information, etc.).

[0104] Password modification: Users can modify their login password.

[0105] Logout function: Users can log out of their accounts and stop using the database system.

[0106] The hazardous chemicals database system disclosed in the embodiment of the present invention further includes a universal data interface;

[0107] The general data interface is used to provide data import and export interfaces, and supports uploading data sources in EXCEL file format.

[0108] On the other hand, an embodiment of the present invention further provides a hazardous chemical database design method for designing and implementing the aforementioned hazardous chemical database system, the method comprising the following steps:

[0109] S100. Design a hazardous chemicals database system by establishing a system management module, a database management module, a hazardous chemical data module, a scenario adaptation module, and a dynamic analysis and evaluation module.

[0110] The hazardous chemicals database design method disclosed in the embodiment of the present invention further includes the following steps:

[0111] S200, establishing registration, login, and data retrieval functions based on the web page;

[0112] S300, provides log viewing and user management functions;

[0113] S400. Set access rights for different roles to data; the roles include common users and administrators.

[0114] As an optional implementation method, the architecture design and technology selection of the embodiment of the present invention are as follows:

[0115] The MVC architecture is a commonly used software design pattern that can effectively separate data (Model), user interface (View), and control logic (Controller), thereby achieving high cohesion and low coupling of the system, and improving the maintainability and scalability of the system. The specific architecture includes:

[0116] Front-end technology: Use JavaScript and other front-end technologies to develop UI interfaces to ensure platform independence and adaptability to different terminal devices.

[0117] Back-end technology: ASP.NET Core 3.0 is used as the development platform, combined with SQL Server as the database. ASP.NET Core has strong cross-platform capabilities, scalability, and efficient security performance, making it suitable for building an efficient and secure back-end management system.

[0118] Database management: Utilizes the SQL Server data engine to provide efficient storage and retrieval functions.

[0119] The hazardous chemicals database design method disclosed in the embodiment of the present invention further includes the following steps:

[0120] S500: Analyze the hazardous chemical report data and the hazardous chemical data to determine the data items that need to be stored;

[0121] S600. Design database table information based on data items; the database table information includes basic information of chemicals, hazard information, health hazards, environmental hazards, and safe storage and transportation information.

[0122] The hazardous chemicals database design method disclosed in the embodiment of the present invention further includes the following steps:

[0123] S700, develop data interface and set up data interface to support importing data from external systems;

[0124] S800, design data redundancy and backup mechanisms.

[0125] As an optional embodiment, refer to Figure 2 and Figure 3The hazardous chemicals database design of the present invention is mainly divided into overall design and detailed design. In the database design, according to the needs of demand analysis and functional and performance requirements, appropriate design methods are used to carry out database design, system structure design and process design.

[0126] Login management: provides users with user login, self-registration, and password retrieval functions; system administrators can add and delete users and view modification logs;

[0127] Database management: Upload, classify and retrieve hazardous chemical report data and hazardous chemical data.

[0128] Database management has five functions: report data indexing (open to the public), report data management (for administrators, with add, edit, and delete functions, and support for fuzzy queries), hazardous chemicals data indexing (open to the public, and support for fuzzy queries), hazardous chemicals data management (for administrators, with add, edit, and delete functions, and support for fuzzy queries), and data upload (data import and data upload).

[0129] The design objectives of the database are as follows: (1) Establish a friendly interactive interface based on the web page to facilitate user registration, login, and data retrieval. (2) Establish a friendly back-end database management interface to facilitate administrators to upload, edit, delete, and other operations. (3) Establish a back-end database management system to receive interactive data submitted by the front end and send responses to the front end. Implement data storage, backup, retrieval, deletion, and other operations. (4) Establish a universal data interface to accept data sources in the form of EXCEL files.

[0130] Overall Database Framework: The data framework adopts an MVC architecture. By building data models, creating front-end views, and designing controllers, we will organically integrate data from various sources to form an efficient data retrieval platform. The database backend architecture will utilize ASP.NET Core and SQL Server databases. The SQL Server data service provides the data engine, accepting data interaction requests from IIS and ASP.NET Core and transmitting the results to the front-end UI.

[0131] Database Programming: The front-end UI utilizes JavaScript technology, fully considering the user experience across various terminals and achieving true platform independence. Back-end Design: ASP.NET Core 3.0 is used as the technical support. ASP.NET Core is currently the most advanced development platform, and programs developed using it offer strong scalability and platform independence. It offers inherent advantages in database security and efficiency.

[0132] Database Operational Status: The hazardous chemicals database platform has been compiled and published on the IIS server. After extensive debugging, the system is now operating reliably and stably. Over 4,000 records have been uploaded, essentially meeting design requirements.

[0133] By compiling statistics on the hazardous characteristics of chemicals in each region based on the database, it is convenient for testing agencies to develop the testing business market based on these regional hazardous characteristics of chemicals; for regulatory authorities, they can conduct risk assessment and rating based on the hazardous characteristics of chemicals in each region and implement targeted management measures.

[0134] The hazardous chemical report data of the present invention includes data information of more than 4,000 kinds of chemicals, including: contract number, sample name, entrusting unit, production unit, contact number, address, sample appearance and properties, ingredients, percentage content, CAS No., hazard identification, UN number, packaging requirements, packaging category, warning words, image pictures, explosives, flammable gases, aerosols, oxidizing gases, flammable liquids, flammable solids, self-reactive substances and mixtures, pyrophoric liquids, pyrophoric solids, self-heating substances and mixtures, substances and mixtures that release flammable gases when in contact with water, oxidizing liquids, oxidizing solids, organic peroxides, metal corrosives, explosion hazard, acute toxicity (oral), acute toxicity (dermal), acute toxicity (inhalation), skin corrosion / irritation, serious eye damage / irritation, respiratory / skin sensitization, germ cell mutagenicity, carcinogenicity, reproductive toxicity, specific target organ toxicity - single exposure 60 items of data including contact, specific target organ toxicity-repeated exposure, inhalation hazard, route of entry, inhalation contact, skin contact, eye contact, aquatic environmental hazards, atmospheric hazards, toxicity to aquatic life, recommended categories, fire-fighting measures, handling and storage, stability and reactivity, contact control / personal protection, first aid measures, emergency treatment of leaks, environmental hazards, persistence and degradability, potential bioaccumulation, mobility in soil, waste properties, waste precautions, etc., involving health hazards, environmental hazards, safe storage and transportation, safe production and use, first aid measures, product information, etc. The specific data information shall be entered according to the actual data volume of the report.

[0135] Hazardous chemicals data is based on the "Hazardous Chemicals Catalogue" (2015 edition) and combined with authoritative data sources such as the "Hazardous Chemicals Information Quick Reference Handbook" to collect data information on a variety of chemicals, including: product name, alias, English name, CAS number, hazard category, signal word, hazard statement, physical and chemical hazards, health hazards, environmental hazards, inhalation, skin contact, eye contact, fire extinguishing agents, special hazards, fire extinguishing precautions and protective measures, operator protection measures, protective equipment and emergency procedures, environmental protection measures, containment and cleanup methods of leaked chemicals and the disposal materials used, operating precautions, storage and transportation precautions, occupational exposure limits, biological exposure limits, detection methods, engineering controls, personal protective equipment, stability, hazardous reactions The data of 54 items including conditions to avoid contact, incompatible materials, hazardous decomposition products, acute toxicity, skin irritation or corrosion, eye irritation or corrosion, respiratory or skin sensitization, germ cell mutagenicity, carcinogenicity, reproductive toxicity, specific target organ toxicity - single exposure, specific target organ toxicity - repeated exposure, aspiration hazard, persistence and degradability, bioaccumulative potential, soil mobility, waste chemicals, pollutant packaging, waste precautions, UN number, UN shipping name, UN hazard class, packaging category, marine pollutant, transportation precautions, etc. involve accurate data on health hazards, environmental hazards, safe storage and transportation, safe production and use, first aid measures. The specific data shall be entered according to the actual amount of data queried.

[0136] Database operation of the present invention:

[0137] 1. Log in to the database website and click the "Register" button.

[0138] 2. Register the system login information by entering "Email" and "Password".

[0139] 3. Return to the login interface and enter your "account" and "password" to log in to the database system.

[0140] 4. The database system is primarily divided into three sections: personal management, system management, and hazardous chemical data. Personal management allows registered users to modify and log out of their login information and includes four main sections: homepage, profile modification, password modification, and logout. System management allows system administrators to manage registered user information and user levels, including user management and role management. Hazardous chemical data is the core component of the database. This module allows access to all data collected, including historical hazardous chemical reports and authoritative data sources for commonly used hazardous chemicals.

[0141] The beneficial effects of the present invention are as follows: the database will be used to: (1) provide more convenient, rapid and accurate data query and utilization during the detection process; (2) analyze customer groups based on basic data, develop customer resources in a targeted manner, and summarize and process statistical data for chemical risk assessment; (3) provide enterprises with information on the hazardous characteristics and classification of chemical substances; and (4) provide information for emergency response to chemical accidents.

[0142] On the other hand, an embodiment of the present invention also provides a hazardous chemical database design device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the method for designing a hazardous chemical database as described above is implemented.

[0143] The processor may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc.

[0144] The memory may include various types of storage units, such as system memory, read-only memory (ROM), and permanent storage devices. ROM may store static data or instructions required by the processor or other modules of the computer. The permanent storage device may be a readable and writable storage device. The permanent storage device may be a non-volatile storage device that does not lose stored instructions and data even if the computer is powered off. In some embodiments, the permanent storage device uses a large-capacity storage device (such as a magnetic or optical disk, flash memory) as the permanent storage device. In other embodiments, the permanent storage device may be a removable storage device (such as a floppy disk, optical drive). The system memory may be a readable and writable storage device or a volatile readable and writable storage device, such as dynamic random access memory. The system memory may store some or all instructions and data required by the processor during operation. In addition, the memory may include any combination of computer-readable storage media, including various types of semiconductor memory chips (DRAM, SRAM, SDRAM, flash memory, programmable read-only memory), and magnetic disks and / or optical disks may also be used. In some embodiments, the memory may include a readable and / or writable removable storage device, such as a compact disc (CD), a read-only digital versatile disc (e.g., DVD-ROM, dual-layer DVD-ROM), a read-only Blu-ray disc, an ultra-density optical disc, a flash memory card (e.g., SD card, mini SD card, Micro-SD card, etc.), a magnetic floppy disk, etc. Computer-readable storage media do not include carrier waves and transient electronic signals transmitted wirelessly or wired.

[0145] The memory stores executable codes, which, when processed by the processor, can enable the processor to execute part or all of the above-mentioned methods.

[0146] On the other hand, an embodiment of the present invention further provides a computer-readable storage medium storing computer-executable instructions for causing a computer to execute the aforementioned method for designing a hazardous chemical database.

[0147] Those skilled in the art will appreciate that all or some of the steps and systems in the method disclosed above can be implemented as software, firmware, hardware, and appropriate combinations thereof. Some physical components or all physical components can be implemented as software executed by a processor, such as a central processing unit, a digital signal processor, or a microprocessor, or implemented as hardware, or implemented as an integrated circuit, such as an application-specific integrated circuit. Such software can be distributed on a computer-readable medium, and the computer-readable medium can include computer storage media (or non-transitory media) and communication media (or temporary media). As known to those skilled in the art, the term computer storage media is included in any method or technology for storing information (such as computer-readable instructions, data structures, program modules, or other data) and is volatile and non-volatile, removable, and non-removable. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory, or other memory technology, CD-ROM, digital versatile disks (DVD), or other optical disk storage, magnetic cassettes, magnetic tapes, disk storage, or other magnetic storage devices, or any other medium that can be used to store desired information and can be accessed by a computer. Furthermore, as is well known to those skilled in the art, communication media typically embodies computer-readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media.

[0148] In the above description of this specification, reference to the terms "one embodiment / example," "another embodiment / example," or "certain embodiments / examples" 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 may be combined in any suitable manner in any one or more embodiments or examples.

[0149] While embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions, and variations may be made to the embodiments without departing from the principles and spirit of the invention, and that the scope of the invention is defined by the claims and their equivalents.

[0150] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but are not intended to limit the scope of the present invention. Any modifications, equivalent substitutions, and improvements made by those skilled in the art without departing from the scope and essence of the present invention should be within the scope of the present invention.

Claims

1. A hazardous chemicals database system, characterized in that: The system includes a system management module, a database management module, a hazardous chemical data module, a scenario adaptation module, and a dynamic analysis and evaluation module; The system management module includes a user management submodule and a role management submodule; The user management submodule is used to manage user registration information; The role management submodule is used to set the user's role and permissions; The database management module includes a hazardous chemicals data management submodule and a report data management submodule; The hazardous chemicals data management submodule is used to add, edit, and delete hazardous chemicals data; the report data management submodule is used to add, edit, and delete report data; The hazardous chemical data module is used to store data information of chemicals; The scenario adaptation module is used to adapt to different management scenarios; the management scenarios include hazardous chemical chemical parks and cross-border transportation; The dynamic analysis and evaluation module is used to generate a management plan; the management plan includes an emergency response plan and an environmental protection plan; the emergency response plan includes leakage disposal and evacuation simulation; the environmental protection plan includes waste disposal recommendations and hazardous chemical safe storage recommendations.

2. The system according to claim 1, wherein: The database management module also includes a hazardous chemicals data index submodule and a report data index submodule; The hazardous chemicals data index submodule is used to provide retrieval of hazardous chemicals data; The report data index submodule is used to query historical chemical report data.

3. The system according to claim 1, wherein: The hazardous chemical data module includes hazardous chemical report data and basic data of hazardous chemicals; The hazardous chemical report data includes the contract number information, sample name, production unit information, and hazard information of the hazardous chemicals; The basic data of hazardous chemicals include the name of the chemical, CAS number, hazard category, health hazards, environmental hazards, transportation requirements, storage and usage precautions.

4. The system according to claim 1, wherein: The system also includes a login management module; The login management module includes a user login submodule, a self-service registration submodule, and a password retrieval submodule; The user login submodule is used to provide a function for registered users to enter their account number and password to log in to the system; The self-service registration submodule is used to provide a registration channel for users; The password retrieval submodule provides a retrieval function when the password is forgotten.

5. The system according to claim 1, wherein: The system also includes a personal management module; The personal management module includes a homepage submodule, a data modification submodule, a password modification submodule, and a logout function submodule; The homepage submodule is used to view the homepage interface of personal information; The data modification submodule is used to modify personal data; the personal data includes email and contact information; The password modification submodule is used to modify the login password; The deregistration function submodule is used to deregister an account.

6. The system according to claim 1, wherein: The system also includes a universal data interface; The universal data interface is used to provide an interface for importing and exporting data, and supports uploading data sources in EXCEL file format.

7. A hazardous chemicals database design method, used to design and implement the hazardous chemicals database system according to any one of claims 1 to 6, characterized in that: The method comprises the following steps: A hazardous chemicals database system is designed by establishing system management module, database management module, hazardous chemical data module, scenario adaptation module, and dynamic analysis and evaluation module.

8. The method according to claim 7, characterized in that The method further comprises the following steps: Establish registration, login, and data retrieval functions based on the web page; Provide log viewing and user management functions; Set data access permissions for different roles, including common users and administrators.

9. The method according to claim 7, characterized in that The method further comprises the following steps: Determine the data items that need to be stored by analyzing the hazardous chemical report data and the data of the hazardous chemicals themselves; According to the data items, database table information is designed; the database table information includes basic information of chemicals, hazard information, health hazards, environmental hazards, and safe storage and transportation information.

10. The method according to claim 7, characterized in that The method further comprises the following steps: Develop data interfaces and set up the data interfaces to support importing data from external systems; Design data redundancy and backup mechanisms.

Images