Database access system of compound database

Abstract

The embodiment of the invention relates to a database access system of a compound database. The system comprises a database service gateway, a request message queue, a feedback message queue, a message processing module, a cache message queue, a database management module, a user permission configuration table, an operation approval configuration table and the compound database, the database service gateway is respectively connected with the request message queue and the feedback message queue; the message processing module is respectively connected with the request message queue, the feedback message queue and the cache message queue; and the database management module is respectively connected with the cache message queue, the user permission configuration table, the operation approval configuration table and the compound database. Through the method, the waste rate of storage resources can be reduced, and the overall task processing performance of the database is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a database access system for a compound database. Background Art

[0002] In many scientific and technological fields (such as semiconductors, new energy, and nanotechnology), it is necessary to build a large-scale compound database for scientific and technological workers to improve research and development efficiency; the compounds mentioned here include compounds such as solvents, solutions, and electrolytes of battery electrolytes, positive / negative electrode material compounds of batteries, crystal material compounds, etc. This type of compound database usually uses a single compound as the basic data unit and stores all the compound properties related to it. The compound properties mentioned here should at least include the chemical formula of the compound molecule, the simplified molecular linear input specification (SMILES) sequence of the compound molecule, and all physical / chemical properties of the compound molecule (such as melting point, boiling point, mass, atomic number, effective charge, volume, density, oxidation-reduction energy, etc.).

[0003] At present, the conventional construction method of this type of compound database mostly adopts the full attribute recording method to construct data records, that is, to construct a corresponding data record for each compound, and to collect all the attributes of this compound in this corresponding data record. Through development practice, we found that this conventional construction method will cause problems such as high storage resource waste rate and low data processing performance when the data volume is large. The reason for the high storage resource waste rate is that although there are some common attributes (referred to as primary attributes) between compounds with different structures and application requirements, there are also some personalized attributes (referred to as secondary attributes). If the full attribute recording method is used to construct the data record of the compound on a relational database (such as SQL database, MySQL database), it is necessary to count all the attributes of all compounds and construct a maximum range of attribute field set based on the statistical results. This will undoubtedly cause a large amount of redundant field waste when the number of compounds is large, resulting in a high storage resource waste rate. The reason for the low data processing performance is that when using the full attribute recording method, all possible concurrent database processing tasks (such as export and query) must be based on the same large data record, which invisibly increases the resource consumption of each processing task (such as memory resources). When the total amount of resources is limited, it will naturally lead to a decline in the overall task processing performance of the database. Summary of the invention

[0004] The purpose of the present invention is to provide a database access system for a compound database in view of the defects of the prior art, the system comprising: a database service gateway, a request message queue, a feedback message queue, a message processing module, a cache message queue, a database management module, a user authority configuration table, an operation approval configuration table and a compound database; wherein the database service gateway is used to perform record addition processing on the request message queue according to the received first service request, and is also used to perform request feedback sending processing according to the feedback message queue; the message processing module is used to perform cache message addition processing on the cache message queue according to the request message queue, and is also used to perform feedback message addition processing on the feedback message queue according to the cache message queue; the user review unit of the database management module is used to perform user authority status update processing on each cache message record in the cache message queue according to the user authority configuration table, and the operation approval unit is used to perform data review status update processing on each cache message record in the cache message queue according to the operation approval configuration table The data import unit is used to add or update data to the compound database according to the cache message queue, the data deletion unit is used to delete data from the compound database according to the cache message queue, the data export unit is used to export data from the compound database according to the cache message queue, and the data query unit is used to query data from the compound database according to the cache message queue; the project index table of the compound database is used to store multiple project index records, each project index record corresponds to a database project and a compound primary attribute table, the compound primary attribute table of the compound database is used to store multiple compound primary attribute records, each compound primary attribute record corresponds to a common attribute set of a compound and a compound secondary attribute table, the compound secondary attribute table of the compound database is used to store multiple compound secondary attribute records, and the compound secondary attribute table of the compound database updates a group of secondary attributes of a compound by adding compound secondary attribute records. The present invention uses the compound primary / secondary attribute table to distinguish the storage space of the common attributes and individual attributes of the compound, and distinguishes the storage space of each compound individual attribute through the compound secondary attribute table, thereby avoiding the problem of redundant field waste caused by the conventional full attribute recording method, thereby achieving the purpose of reducing the storage resource waste rate and improving the overall task processing performance of the database.

[0005] To achieve the above-mentioned purpose, an embodiment of the present invention provides a database access system for a compound database, the system comprising: a database service gateway, a request message queue, a feedback message queue, a message processing module, a cache message queue, a database management module, a user authority configuration table, an operation approval configuration table and a compound database;

[0006] The database service gateway is connected to the request message queue and the feedback message queue respectively; the message processing module is connected to the request message queue, the feedback message queue and the cache message queue respectively; the database management module is connected to the cache message queue, the user authority configuration table, the operation approval configuration table and the compound database respectively;

[0007] The database service gateway is used to receive a first service request, and perform a record adding process on the request message queue according to the first service request; the database service gateway is also used to perform a request feedback sending process according to the feedback message queue;

[0008] The request message queue is used to store multiple request message records;

[0009] The feedback message queue is used to store multiple feedback message records;

[0010] The message processing module is used to perform a cache message adding process on the cache message queue according to the request message queue; the message processing module is also used to perform a feedback message adding process on the feedback message queue according to the cache message queue;

[0011] The cache message queue is used to store multiple cache message records;

[0012] The database management module includes a user review unit, an operation approval unit, a data import unit, a data deletion unit, a data export unit and a data query unit; the user review unit is used to update the user authority status of each cache message record in the cache message queue according to the user authority configuration table; the operation approval unit is used to update the data review status of each cache message record in the cache message queue according to the operation approval configuration table; the data import unit is used to add or update data to the compound database according to the cache message queue; the data deletion unit is used to delete data from the compound database according to the cache message queue; the data export unit is used to export data from the compound database according to the cache message queue; the data query unit is used to query data from the compound database according to the cache message queue;

[0013] The user authority configuration table is used to store multiple user authority configuration records;

[0014] The operation approval configuration table is used to store multiple operation approval configuration records;

[0015] The compound database includes a project index table, multiple compound primary attribute tables and multiple compound secondary attribute tables; the project index table is used to store multiple project index records; the compound primary attribute table is used to store multiple compound primary attribute records; the compound secondary attribute table is used to store multiple compound secondary attribute records; the project index records correspond one-to-one to the compound primary attribute table; the compound primary attribute records correspond one-to-one to the compound secondary attribute table.

[0016] Preferably, the first service request includes a first message identifier, a first message source address, a first message header and a first message body; the first message identifier is a unique message identifier of the current service request; the first message source address is the sender address of the current service request; the first message header includes a first user identifier, a first user token, a first project identifier and a first instruction type; the first user identifier is a unique identity identifier of the initiating user who initiates the current service request, the first user token is the identity token information for the current user, and the first project identifier is a database project identifier corresponding to the database data to be operated by the current service request; the first instruction type includes import, delete, export and query; the first message body includes a first instruction parameter; the first instruction parameter is a CSV file;

[0017] Each of the request message records corresponds to one of the first service requests; the request message record includes at least a request message identifier, a request message source address, a request message header, a request message body, and a request message status; the request message identifier, the request message source address, the request message header, and the request message body are the corresponding first message identifier, the first message source address, the first message header, and the first message body, respectively; the request message status includes unprocessed and processed;

[0018] Each feedback message record corresponds to one request message record; the feedback message record at least includes a feedback message identifier, a feedback message target address, a feedback message header, a feedback message body and a feedback message status: the feedback message identifier matches the corresponding request message identifier; the feedback message target address matches the corresponding request message source address; the feedback message header includes a second user identifier, a second project identifier, a second instruction type and a first instruction execution status; the second user identifier, the second project identifier and the second instruction type respectively match the corresponding first user identifier, the first project identifier and the first instruction type; the second instruction type includes import, delete, export and query; the first instruction execution status includes success and exception; the feedback message body includes first feedback data; the first feedback data is a compressed package file with one or more CSV files; the feedback message status includes unprocessed and processed;

[0019] Each of the cached message records corresponds to a request message record; the cached message record includes at least a request message identifier, a request source address, a request user identifier, a request user token, a request project identifier, a request instruction type, a request instruction parameter, a user authority status, a data review status, a request feedback data and a request message status: the request message identifier, the request source address, the request user identifier, the request user token, the request project identifier, the request instruction type and the request instruction parameter respectively match the corresponding first message identifier, the first message source address, the first user identifier, the first user token, the first project identifier, the first instruction type and the first instruction parameter; the request instruction type includes import, delete, export and query; the user authority status and the data review status both include unreviewed, unsatisfied and satisfied; the request message status includes unprocessed, under review, in process, feedback received and processed;

[0020] The user authority configuration record at least includes an authority configuration record identifier, a registered user identifier, a registered user type, a registered user token, a token validity period and a registration project identifier set; the authority configuration record identifier is a unique record identifier corresponding to the current user authority configuration record; each of the user authority configuration records corresponds to a registered user, and the registered user identifier is a unique identity identifier of the current registered user; the registered user type includes an administrator type and multiple non-administrator types; the registered user token is the identity token information pre-assigned to the current registered user, and the token validity period is the validity period information of the current token; the registration project identifier set is composed of one or more registration project identifiers when it is not empty; each registered user can be added to one or more database projects, and each of the registration project identifiers in the registration project identifier set is a project identifier of a database project where the current registered user is located;

[0021] The operation approval configuration record at least includes an approval configuration record identifier, an approval project identifier, an approval configuration set and an approval interface set; the approval configuration record identifier is a unique record identifier corresponding to the current operation approval configuration record; each of the operation approval configuration records corresponds to a database project that requires data approval, and the approval project identifier is a unique project identifier of the current database project; the approval configuration set consists of one or more approval configurations; each of the approval configurations is used to set whether three types of operations corresponding to a type of user need approval, and each of the approval configurations consists of an approval user type, an import configuration bit, a delete configuration bit and an export configuration bit; the approval user type includes an administrator type and all non-administrator types; the values ​​of the import, delete and export configuration bits include 0 and 1, and when the import, delete or export configuration bit is 0, it means that the current user type is in No approval is required when processing data import, deletion or export operations in the current database project. When the import, deletion or export configuration bit is 1, it indicates that the current user type needs approval when processing data import, deletion or export operations in the current database project; at least one of the import, deletion and export configuration bits of the approval configuration is 1; the approval interface set includes an import approval interface, a deletion approval interface and an export approval interface; the import, deletion and export approval interfaces are each a manual or other machine processing interface for data approval processing, and each approval interface is used to receive the approval application sent by the operation approval unit and send it to the corresponding manual processing end or other machine processing end for approval operation, and send the approval passed or approval failed conclusion returned by the manual processing end or other machine processing end based on each approval application as the corresponding approval result to the operation approval unit;

[0022] Each of the project index records in the project index table corresponds to a database item in the compound database; the project index records corresponding to each database item in the project index table can only be added once before being deleted, but can be modified multiple times; the project index record at least includes an index record identifier, a project index identifier, a project member identifier set, an index record status, and a primary attribute table identifier; the index record identifier is a unique record identifier for the current project index record; the project index identifier is a unique project identifier for the current database item; the project member identifier set includes one or more member user identifiers, each of which corresponds to a unique identity identifier of a registered user added to the current database item; the index record status includes undeleted and deleted; the primary attribute table identifier is a unique identifier for the corresponding primary attribute table of the compound;

[0023] Each of the compound primary attribute tables corresponds to a database item in the compound database; each of the compound primary attribute records in each of the compound primary attribute tables corresponds to a compound in the current database item; the compound primary attribute records corresponding to each compound in the compound primary attribute table can only be added once before being deleted, but can be modified multiple times; the compound primary attribute record includes at least a primary attribute record identifier, a SMI LES sequence, a molecular chemical formula, a chemical element sequence, a first-class molecular fingerprint, a second-class molecular fingerprint, a third-class molecular fingerprint, a primary attribute set, a primary attribute record status, and a secondary attribute table identifier; the primary attribute record identifier is a unique record identifier of the current compound primary attribute record; the SMI LES sequence is the SMI LES sequence of the current compound. LES sequence; the molecular chemical formula is the chemical expression of the current compound molecule; the chemical element sequence is the chemical element collection of the current compound molecule, which is composed of multiple chemical elements; the first, second and third types of molecular fingerprints are respectively the torsionbv algorithm molecular fingerprint, mfp2 algorithm molecular fingerprint and ffp2 algorithm molecular fingerprint of the current compound molecule; all attributes of each compound are divided into two attribute sets: general attributes and personalized attributes, wherein the general attribute set is composed of multiple general attributes, and the first-level attribute set in the compound first-level attribute record corresponding to each compound corresponds to the general attribute set of the current compound; the first-level attribute set includes multiple first-level attributes, each of which is composed of a pair of attribute name and attribute value, and each of which corresponds to a general attribute in the general attribute set of the current compound; the first-level attribute record status includes undeleted and deleted; the second-level attribute table identifier is the unique identifier of the corresponding compound second-level attribute table;

[0024] Each of the compound secondary attribute tables corresponds to a compound in a database item in the compound database; all attributes of each compound are divided into two attribute sets: general attributes and personalized attributes, wherein the personalized attribute set is further subdivided into multiple secondary attribute subsets and each secondary attribute subset has a unique classification name, and each of the compound secondary attribute records in the compound secondary attribute table corresponding to each compound corresponds to an attribute update operation of a class of secondary attribute subsets of the current compound; the compound secondary attribute record at least includes a secondary attribute record identifier, a secondary attribute classification name, a secondary attribute set, a secondary attribute version, a secondary attribute addition time and a secondary attribute record status; the secondary attribute record identifier is the unique record identifier of the current compound secondary attribute record; the secondary attribute classification name is the classification name of the secondary attribute subset updated at the time; the secondary attribute set is the secondary attribute subset updated at the time, consisting of multiple secondary attributes, each of which consists of a pair of attribute name and attribute value; the secondary attribute version is the version information corresponding to the secondary attribute set; the secondary attribute addition time is the addition time of the current compound secondary attribute record; the secondary attribute record status includes not deleted and deleted.

[0025] Preferably, the database business gateway is specifically used to parse the corresponding first message identifier, the first message source address, the first message header and the first message body from the first business request as the corresponding current message identifier, current message source address, current message header and current message body based on a preset request message parsing rule when adding a record to the request message queue according to the first business request; and add a new request message record in the request message queue as the corresponding current newly added record; and set the request message identifier, the request message source address, the request message header and the request message body of the currently newly added record to the corresponding current message identifier, the current message source address, the current message header and the current message body; and set the request message status of the currently newly added record to unprocessed.

[0026] Preferably, the database service gateway is specifically used to, when performing the request feedback sending processing according to the feedback message queue, record all the feedback message records in the feedback message queue whose feedback message status is unprocessed as unprocessed records, and use the unprocessed record with the earliest time as the corresponding current record; and when the current record is not empty, perform corresponding feedback message encapsulation processing according to the feedback message identifier, the feedback message target address, the feedback message header and the feedback message body of the current feedback message record according to the preset feedback message encapsulation rule to obtain the corresponding current feedback message; and send the current feedback message to the feedback message target address of the current feedback message record; and reset the feedback message status of the current record to processed after the message is successfully sent.

[0027] Preferably, the message processing module is specifically used for, when performing cache message adding processing on the cache message queue according to the request message queue,

[0028] Recording all the request message records whose request message status is unprocessed in the request message queue as unprocessed records, and taking the earliest unprocessed record as the corresponding current request message record;

[0029] and when the current request message record is not empty, extracting the request message identifier, the request message source address, the request message header and the request message body of the current request message record as the corresponding current message identifier, the current message source address, the current message header and the current message body;

[0030] and extracting the first user identifier, the first user token, the first project identifier and the first instruction type of the current message header and the first instruction parameter of the current message body as the corresponding current user identifier, current user token, current project identifier, current instruction type and current instruction parameter;

[0031] and adding a new cached message record in the cached message queue as the corresponding current cached message record;

[0032] and setting the request message identifier, the request source address, the request user identifier, the request user token, the request project identifier, the request instruction type and the request instruction parameter of the current cache message record to the corresponding current message identifier, the current message source address, the current user identifier, the current user token, the current project identifier, the current instruction type and the current instruction parameter;

[0033] The user authority status and the data review status of the current cache message record are both set to unreviewed; the request feedback data of the current cache message record is set to empty; and the request message status of the current cache message record is set to unprocessed;

[0034] And when the setting of the current cache message record is completed, the request message status of the current request message record is reset to processed.

[0035] Preferably, the message processing module is specifically used for, when performing feedback message adding processing on the feedback message queue according to the cache message queue,

[0036] Recording all cached message records in the cached message queue whose request message status is "fed back" as fed back records, and taking the earliest fed back record as the corresponding current cached message record;

[0037] and when the current cache message record is not empty, identifying whether the user authority status and the data audit status of the current cache message record are both satisfied, if so, setting the corresponding current instruction execution status to success, otherwise setting the corresponding current instruction execution status to abnormal;

[0038] and taking the request message identifier and the request source address of the current cache message record as the corresponding feedback message identifier and the feedback message target address; and taking the request user identifier, the request project identifier, the request instruction type and the current instruction execution status corresponding to the current cache message record as the corresponding second user identifier, the second project identifier, the second instruction type and the first instruction execution status to form the corresponding feedback message header; and taking the request feedback data of the current cache message record as the corresponding first instruction feedback data to form the corresponding feedback message body; and setting a corresponding feedback message status to unprocessed;

[0039] The obtained feedback message identifier, the feedback message target address, the feedback message header, the feedback message body and the feedback message status form a corresponding feedback message record and add it to the feedback message queue;

[0040] After the feedback message record is successfully added, the request message status of the current cache message record is set to processed.

[0041] Preferably, the user audit unit is specifically configured to, when performing user authority status update processing on each cache message record in the cache message queue according to the user authority configuration table,

[0042] All cached message records in the cached message queue whose request message status is unprocessed are recorded as unprocessed records, and the unprocessed record with the earliest time is used as the corresponding current unprocessed record; and the request user identifier, the request user token and the request project identifier of the current unprocessed record are used as the corresponding current user identifier, current user token and current project identifier; and the current time is used as the corresponding current token time;

[0043] and taking the user authority configuration record in the user authority configuration table in which the registered user identifier matches the current user identifier, the registered user token matches the current user token, and the token validity period meets the current token time as the corresponding current user authority configuration record;

[0044] and identifying whether the current user authority configuration record is empty;

[0045] If the current user authority configuration record is empty, the user authority status and the data review status of the current unprocessed record are both set to unsatisfied, and the request message status of the current unprocessed record is set to fed back;

[0046] If the current user authority configuration record is not empty, it is confirmed whether there is a registration project identifier matching the current project identifier in the registration project identifier set of the current user authority configuration record; if it is confirmed that it exists, the user authority status of the current unprocessed record is set to satisfied, and the request message status of the current unprocessed record is set to under review; if it is confirmed that it does not exist, the user authority status and the data review status of the current unprocessed record are both set to unsatisfied, and the request message status of the current unprocessed record is set to received feedback.

[0047] Preferably, the operation approval unit is specifically configured to, when performing data review status update processing on each cache message record in the cache message queue according to the operation approval configuration table,

[0048] All cached message records in the cached message queue whose request message status is under review are recorded as under review records, and the earliest under review record is used as the corresponding current under review record; the request user identifier, the request project identifier, the request instruction type and the request instruction parameters of the current under review record are used as the corresponding current user identifier, current project identifier, current instruction type and current instruction parameters; the registered user type of the user authority configuration record whose registered user identifier in the user authority configuration table matches the current user identifier is used as the corresponding current user type; and the operation approval configuration record whose approval project identifier in the operation approval configuration table matches the current project identifier is used as the corresponding current operation approval configuration record;

[0049] and identifying whether the current operation approval configuration record is empty;

[0050] If the current operation approval configuration record is empty, the data review status recorded in the current review is set to satisfied, and the request message status recorded in the current review is set to being processed;

[0051] If the current operation approval configuration record is not empty, taking the approval configuration whose approval user type matches the current user type in the approval configuration set of the current operation approval configuration record as the corresponding current approval configuration, and identifying whether the current approval configuration is empty;

[0052] If the current approval configuration is empty, the data review status recorded in the current review is set to satisfied, and the request message status recorded in the current review is set to being processed;

[0053] If the current approval configuration is not empty, confirm whether there is a configuration bit corresponding to the current instruction type in the import, delete and export configuration bits of the current approval configuration; if there is or not, set the data review status recorded in the current review to satisfied, and set the request message status recorded in the current review to processing; if it is confirmed to exist, set the configuration bit corresponding to the current instruction type in the import, delete and export configuration bits of the current approval configuration as the corresponding current configuration bit, and identify the current configuration bit;

[0054] If the current configuration bit is 0, the data audit status recorded in the current audit is set to satisfied, and the request message status recorded in the current audit is set to being processed;

[0055] If the current configuration bit is 1, the approval interface corresponding to the current instruction type in the import, delete and export approval interfaces of the approval interface set of the current operation approval configuration record is used as the corresponding current approval interface; and a unique timestamp is generated based on the current time as the corresponding first application identifier, and the first application identifier and the current user identifier, the current project identifier, the current instruction type, and the current instruction parameters form a corresponding first approval application and send it to the current approval interface; and after successful sending, the request message identifier recorded in the current review is used as the corresponding first message identifier, and the first application identifier and the first message identifier form a corresponding first approval record and save it; and after the approval record is successfully saved, the request message status recorded in the current review is set to being processed.

[0056] Preferably, the operation approval unit is further used to, when receiving a corresponding first approval result from any approval interface, use the first approval result currently received as the corresponding current approval result; and use the first approval record whose first application identifier matches the second application identifier of the current approval result among all the first approval records saved as the corresponding current approval record; and use the cached message record whose request message identifier in the cached message queue matches the first message identifier of the current approval record as the corresponding current message record; and use the first approval feedback of the current approval result as the corresponding current approval feedback; and identify the current approval feedback; if the current approval feedback is approval passed, set the data review status of the current message record to satisfied; if the current approval feedback is approval failed, set the data review status of the current message record to unsatisfied, and set the request message status of the current message record to fed back; wherein, the first approval result includes the second application identifier and the first approval feedback; and the first approval feedback includes approval passed and approval failed.

[0057] Preferably, when the first instruction type of the first service request is import, delete, export and query, the CSV file corresponding to the first instruction parameter is recorded as the corresponding import instruction file, delete instruction file, export instruction file and query instruction file;

[0058] The first line of the import, delete, export and query instruction file is a column field line, and the second to last lines are data lines; each data line corresponds to an import, delete, export and query operation; the field format of the column field line of the import, delete, export and query instruction file meets the corresponding import file field format requirements, delete file field format requirements, export file field format requirements and query file field format requirements;

[0059] The column fields required by the import file field format are composed of import classification fields, group member fields, SMI LES fields, chemical formula fields, element sequence fields, first-class fingerprint fields, second-class fingerprint fields, third-class fingerprint fields, first-class attribute fields, second-class attribute classification fields, second-class attribute fields and version fields; the import classification fields include project creation, first-class attribute import and second-class attribute import;

[0060] When the import classification field is a project creation, the member field is a project member identification set, which is composed of one or more user identifications of registered users; the SMILES field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field, the first level attribute field, the second level attribute classification field, the second level attribute field and the version field are all empty;

[0061] When the import classification field is a primary attribute import, the group member field, the secondary attribute classification field, the secondary attribute field and the version field are all empty; the SMILES field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field and the primary attribute field correspond to the SMILES sequence, molecular chemical formula, chemical element sequence, first type molecular fingerprint, second type molecular fingerprint, third type molecular fingerprint and primary attribute set respectively;

[0062] When the import classification field is a secondary attribute import, the member field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field and the first type attribute field are empty; the SMI LES field, the second type attribute classification field, the second type attribute field and the version field are the corresponding SMI LES sequence, second type attribute classification name, second type attribute set and second type attribute version respectively;

[0063] The column fields required by the deletion file field format are composed of a deletion classification field, a deletion SMI LES field, a deletion attribute field and a deletion version field; the deletion classification field includes project deletion, compound deletion and attribute deletion;

[0064] When the deletion category field is item deletion, the deletion SMILES field, the deletion attribute field and the deletion version field are all empty;

[0065] When the deletion classification field is compound deletion, the deletion SMI LES field is a corresponding SMI LES sequence; the deletion attribute field and the deletion version field are both empty;

[0066] When the deletion category field is attribute deletion, the deletion SMI LES field is a corresponding SMI LES sequence; the deletion attribute field is empty or a corresponding secondary attribute category name; the deletion version field is empty or a secondary attribute version; the deletion attribute field and the deletion version field cannot be empty at the same time;

[0067] The column fields required by the export file field format are composed of an export classification field and an export SMI LES field; the export classification field includes project export and compound export; when the export classification field is a project export, the export SMI LES field is empty; when the export classification field is a compound export, the export SMI LES field is a corresponding SMI LES sequence;

[0068] The column fields required by the query file field format are composed of a query classification field, an SMI LES configuration field, a chemical element configuration field and a similarity configuration field; the query classification field includes a query based on SMI LES and a query based on a chemical element; when the query classification field item is exported as a query based on SMI LES, the SMI LES configuration field is a corresponding SMI LES sequence, the chemical element configuration field is empty, and the similarity configuration field is empty or a similarity; when the query classification field item is exported as a query based on a chemical element, the SMI LES configuration field and the similarity configuration field are empty, and the chemical element configuration field is a chemical element sequence.

[0069] Preferably, the data import unit is specifically used for, when adding or updating data to the compound database according to the cache message queue,

[0070] Recording all cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in process, and whose request instruction type is import as import operation records, and taking the earliest import operation record as the corresponding current import operation record;

[0071] and taking the requested project identifier of the current import operation record as the corresponding current project identifier; and taking the CSV file of the requested instruction parameters of the current import operation record as the corresponding current import instruction file; and extracting the data rows formatted from the current import instruction file based on the import file field format requirements to obtain a corresponding first data row sequence; the first data row sequence is formed by sequentially sorting one or more first data rows;

[0072] and sequentially traverse all the first data rows of the first data row sequence; and in the traversal process, take the first data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the first data row sequence as the corresponding first processing index; and extract the import classification field of the current data row as the corresponding current import classification; and identify the current import classification; if the current import classification is project creation, then based on the current project identifier and the member field of the current data row, perform corresponding database project creation or update processing in the compound database to obtain the corresponding first processing result; if the current import classification is primary attribute import, then based on the current project identifier and the SMILES field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field and the primary attribute field of the current data row, perform corresponding compound primary attribute addition or update processing in the compound database to obtain the corresponding first processing result; if the current import classification is secondary attribute import, then based on the current project identifier and the SMILES field of the current data row, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field and the primary attribute field, perform corresponding compound primary attribute addition or update processing in the compound database to obtain the corresponding first processing result. The LES field, the secondary attribute classification field, the secondary attribute field and the version field are processed in the compound database to obtain the corresponding first processing result; and the first processing index and the first processing result are used to form a corresponding first processing feedback; and at the end of the traversal, all the first processing feedbacks are used to form a corresponding first processing feedback sequence; the first processing result includes success and failure;

[0073] And bring the first processing feedback sequence into a preset type of feedback CSV file template to perform corresponding CSV file assembly to obtain a corresponding first feedback CSV file; and based on a preset file compression package tool, compress the first feedback CSV file to obtain a corresponding first compressed package file; and based on the first compressed package file, set the request feedback data of the current import operation record; and set the request message status of the current import operation record to have been fed back.

[0074] Preferably, the data deleting unit is specifically used for, when performing data deletion processing on the compound database according to the cache message queue,

[0075] Recording all cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in process, and whose request instruction type is delete as deletion operation records, and taking the earliest deletion operation record as the corresponding current deletion operation record;

[0076] and taking the request item identifier of the current deletion operation record as the corresponding current item identifier; and taking the CSV file of the request instruction parameters of the current deletion operation record as the corresponding current deletion instruction file; and extracting the data rows formatted from the current deletion instruction file based on the deletion file field format requirements to obtain a corresponding second data row sequence; and the second data row sequence is formed by sequentially sorting one or more second data rows;

[0077] And all the second data rows of the second data row sequence are traversed sequentially; and in the traversal process, the second data row currently traversed is used as the corresponding current data row; and the sequence index of the current data row in the second data row sequence is extracted as the corresponding second processing index; and the deletion classification field of the current data row is extracted as the corresponding current deletion classification; and the current deletion classification is identified; if the current deletion classification is an item deletion, then based on the current item identifier, the corresponding database item deletion processing is performed in the compound database to obtain the corresponding second processing result; if the current deletion classification is a compound deletion, then based on the current item identifier and the deletion SMILES field of the current data row, the corresponding compound deletion processing is performed in the compound database to obtain the corresponding second processing result; if the current deletion classification is an attribute deletion, then based on the current item identifier and the deletion SMILES field of the current data row, the corresponding compound deletion processing is performed in the compound database to obtain the corresponding second processing result. The LES field, the deletion attribute field and the deletion version field perform corresponding compound attribute deletion processing in the compound database to obtain the corresponding second processing result; and the obtained second processing index and the second processing result form a corresponding second processing feedback; and at the end of the traversal, all the obtained second processing feedbacks form a corresponding second processing feedback sequence; the second processing result includes success and failure;

[0078] And bring the second processing feedback sequence into a preset type of feedback CSV file template to perform corresponding CSV file assembly to obtain a corresponding second feedback CSV file; and based on a preset file compression package tool, compress the second feedback CSV file to obtain a corresponding second compressed package file; and based on the second compressed package file, set the request feedback data of the current deletion operation record; and set the request message status of the current deletion operation record to have been fed back.

[0079] Preferably, the data export unit is specifically used for, when the data export processing is performed on the compound database according to the cache message queue,

[0080] Recording all cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in processing, and whose request instruction type is export as export operation records, and taking the earliest export operation record as the corresponding current export operation record;

[0081] and taking the request project identifier of the current export operation record as the corresponding current project identifier; and taking the CSV file of the request instruction parameters of the current export operation record as the corresponding current export instruction file; and extracting the data rows formatted from the current export instruction file based on the export file field format requirements to obtain a corresponding third data row sequence; and the third data row sequence is formed by sequentially sorting one or more third data rows;

[0082] and sequentially traverse all the third data rows of the third data row sequence; and in the traversal process, take the third data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the third data row sequence as the corresponding third processing index; and extract the export classification field of the current data row as the corresponding current export classification; and identify the current export classification; if the current export classification is project export, then based on the current project identifier, the corresponding database project export processing is performed in the compound database to obtain the corresponding third processing result, and the third processing result and the corresponding third processing index are brought into the preset second-category feedback CSV file template for corresponding CSV file assembly to obtain the corresponding third feedback CSV file; if the current export classification is compound export, then based on the current project identifier and the export SMILES field of the current data row, the corresponding compound export processing is performed in the compound database to obtain the corresponding third processing result, and the third processing result and the corresponding third processing index are brought into the preset third-category feedback CSV file template for corresponding CSV file assembly to obtain the corresponding third feedback CSV file;

[0083] At the end of the traversal, all the third feedback CSV files obtained are saved in the same file directory, and the current file directory is compressed based on the preset file compression package tool to obtain the corresponding third compressed package file; and based on the third compressed package file, the request feedback data of the current export operation record is set; and the request message status of the current export operation record is set to feedback received.

[0084] Preferably, the data query unit is specifically used for, when performing data query processing on the compound database according to the cache message queue,

[0085] Recording the cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in process, and whose request instruction type is query as query operation records, and taking the earliest query operation record as the corresponding current query operation record;

[0086] And the request project identifier of the current query operation record is used as the corresponding current project identifier; and the CSV file of the request instruction parameters of the current query operation record is used as the corresponding current query instruction file; and based on the query file field format requirements, the data rows formatted by the current query instruction file are extracted to obtain the corresponding fourth data row sequence; the fourth data row sequence is formed by sequentially sorting one or more fourth data rows;

[0087] and sequentially traverse all the fourth data rows of the fourth data row sequence; and in the traversal process, take the fourth data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the fourth data row sequence as the corresponding fourth processing index; and extract the query classification field of the current data row as the corresponding current query classification; and identify the current query classification; if the current query classification is based on SMI LES query, then based on the current project identifier and the SMI LES of the current data row The LES configuration field and the similarity configuration field perform corresponding compound query processing on the compound database to obtain a corresponding fourth processing result, and bring the fourth processing result and the corresponding fourth processing index into the preset four-category feedback CSV file template for corresponding CSV file assembly to obtain a corresponding fourth feedback CSV file; if the current export classification is based on chemical element query, then based on the current project identifier and the chemical element configuration field of the current data row, the compound database is subjected to corresponding compound query processing to obtain the corresponding fourth processing result, and the fourth processing result and the corresponding fourth processing index are brought into the preset five-category feedback CSV file template for corresponding CSV file assembly to obtain the corresponding fourth feedback CSV file;

[0088] At the end of the traversal, all the fourth feedback CSV files obtained are saved in the same file directory, and the current file directory is compressed based on the preset file compression package tool to obtain the corresponding fourth compressed package file; and based on the fourth compressed package file, the request feedback data of the current query operation record is set; and the request message status of the current query operation record is set to feedback received.

[0089] The embodiment of the present invention provides a database access system for a compound database, the system comprising: a database service gateway, a request message queue, a feedback message queue, a message processing module, a cache message queue, a database management module, a user authority configuration table, an operation approval configuration table and a compound database; wherein the database service gateway is used to perform record addition processing on the request message queue according to the received first service request, and is also used to perform request feedback sending processing according to the feedback message queue; the message processing module is used to perform cache message addition processing on the cache message queue according to the request message queue, and is also used to perform feedback message addition processing on the feedback message queue according to the cache message queue; the user review unit of the database management module is used to perform user authority status update processing on each cache message record in the cache message queue according to the user authority configuration table, the operation approval unit is used to perform data review status update processing on each cache message record in the cache message queue according to the operation approval configuration table, and the data import The unit is used to perform data addition or update processing on the compound database according to the cache message queue, the data deletion unit is used to perform data deletion processing on the compound database according to the cache message queue, the data export unit is used to perform data export processing on the compound database according to the cache message queue, and the data query unit is used to perform data query processing on the compound database according to the cache message queue; the project index table of the compound database is used to store multiple project index records, each project index record corresponds to a database project and a compound primary attribute table, the compound primary attribute table of the compound database is used to store multiple compound primary attribute records, each compound primary attribute record corresponds to a common attribute set of a compound and a compound secondary attribute table, the compound secondary attribute table of the compound database is used to store multiple compound secondary attribute records, and the compound secondary attribute table of the compound database is updated by adding a compound secondary attribute record. The embodiment of the present invention uses the compound primary / secondary attribute table to distinguish the storage space of the common attributes and individual attributes of the compound, and distinguishes the storage space of each compound individual attribute through the compound secondary attribute table, thereby avoiding the problem of redundant field waste caused by the conventional full attribute recording method, reducing the storage resource waste rate, and improving the overall task processing performance of the database. BRIEF DESCRIPTION OF THE DRAWINGS

[0090] Figure 1 A module structure diagram of a database access system for a compound database provided by an embodiment of the present invention;

[0091] Figure 2 A schematic diagram of the column field data structure of the import file field format requirements, the delete file field format requirements, the export file field format requirements and the query file field format requirements provided in an embodiment of the present invention;

[0092] Figure 3 A schematic diagram of the data structure of the request message record and the feedback message record provided in an embodiment of the present invention;

[0093] Figure 4 A schematic diagram of the data structure of a cached message record provided by an embodiment of the present invention;

[0094] Figure 5 A schematic diagram of the data structure of a user authority configuration record and an operation approval configuration record provided in an embodiment of the present invention;

[0095] Figure 6 A schematic diagram of the data structure of the project index record, compound primary attribute record and compound secondary attribute record provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0096] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all 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.

[0097] The embodiment of the present invention provides a database access system for a compound database, such as Figure 1 As shown in the module structure diagram of a database access system for a compound database provided in an embodiment of the present invention, the system mainly includes: a database business gateway 1, a request message queue 2, a feedback message queue 3, a message processing module 4, a cache message queue 5, a database management module 6, a user authority configuration table 7, an operation approval configuration table 8 and a compound database 9.

[0098] Among them, the connection relationship between the various system components of the embodiment of the present invention is: the database business gateway 1 is connected to the request message queue 2 and the feedback message queue 3 respectively; the message processing module 4 is connected to the request message queue 2, the feedback message queue 3 and the cache message queue 5 respectively; the database management module 6 is connected to the cache message queue 5, the user authority configuration table 7, the operation approval configuration table 8 and the compound database 9 respectively.

[0099] (I) Database business gateway 1:

[0100] The database service gateway 1 of the embodiment of the present invention is used to receive a first service request and perform a record adding process on the request message queue 2 according to the first service request. The database service gateway 1 is also used to perform a request feedback sending process according to the feedback message queue 3.

[0101] Here, the first business request of an embodiment of the present invention includes a first message identifier, a first message source address, a first message header and a first message body; wherein, the first message identifier is a unique message identifier of the current business request; the first message source address is the sender address of the current business request; the first message header includes a first user identifier, a first user token, a first project identifier and a first instruction type; the first user identifier is a unique identity identifier of the initiating user who initiates the current business request, the first user token is the identity token information for the current user, and the first project identifier is a database project identifier corresponding to the database data to be operated by the current business request; the first instruction type includes import, delete, export and query; the first message body includes a first instruction parameter; the first instruction parameter is a CSV file.

[0102] It should be noted that when the first instruction type of the first service request is import, delete, export and query, the CSV file corresponding to the first instruction parameter is recorded as the corresponding import instruction file, delete instruction file, export instruction file and query instruction file. The first row of the import, delete, export and query instruction file of the embodiment of the present invention is a column field row, and the second to last rows are data rows; each data row corresponds to an import, delete, export and query operation.

[0103] It should also be noted that the field formats of the column field rows of the import, deletion, export and query instruction files in the embodiments of the present invention meet the corresponding import file field format requirements, deletion file field format requirements, export file field format requirements and query file field format requirements and can be customized based on actual application requirements.

[0104] A customized solution provided by an embodiment of the present invention is given below:

[0105] 1) Import file field format requirements:

[0106] like Figure 2 As shown in the schematic diagram of the column field data structure of the import file field format requirements, the deletion file field format requirements, the export file field format requirements and the query file field format requirements provided in the embodiment of the present invention, the column field of the import file field format requirements consists of an import classification field, a group member field, an SMI LES field, a chemical formula field, an element sequence field, a first-class fingerprint field, a second-class fingerprint field, a third-class fingerprint field, a first-level attribute field, a second-level attribute classification field, a second-level attribute field and a version field; wherein the import classification field includes project creation, first-level attribute import and second-level attribute import;

[0107] a. When the imported classification field is created for a project, the member field is a project member ID set consisting of one or more registered user IDs; the SMILES field, chemical formula field, element sequence field, first-class fingerprint field, second-class fingerprint field, third-class fingerprint field, first-class attribute field, second-class attribute classification field, second-class attribute field and version field are all empty;

[0108] b. When the imported classification field is the first-level attribute, the member field, the second-level attribute classification field, the second-level attribute field and the version field are all empty; the SMILES field, the chemical formula field, the element sequence field, the first-class fingerprint field, the second-class fingerprint field, the third-class fingerprint field and the first-level attribute field are the corresponding SMILES sequence, the molecular chemical formula, the chemical element sequence, the first-class molecular fingerprint, the second-class molecular fingerprint, the third-class molecular fingerprint and the first-level attribute set respectively; the first-, second- and third-class molecular fingerprints mentioned here refer to the compound molecular fingerprints calculated based on the tors ionbv (Topo logica l-Tors ion Bit Fingerpr int) algorithm, the compound molecular fingerprints calculated based on the mfp2 (Morgan Bit Fingerpr int with Default Radius 2) algorithm, and the compound molecular fingerprints calculated based on the ffp2 (Morgan FCFP Bit Fingerpr int with Default Radius 2) algorithm; the first-level attribute set mentioned here is the common attribute set of compound molecules;

[0109] c. When the imported classification field is a secondary attribute, the member field, chemical formula field, element sequence field, first-class fingerprint field, second-class fingerprint field, third-class fingerprint field and first-class attribute field are empty; the SMI LES field, second-class attribute classification field, second-class attribute field and version field are the corresponding SMI LES sequence, second-class attribute classification name, second-class attribute set and second-class attribute version respectively;

[0110] 2) Delete the file field format requirements:

[0111] like Figure 2 As shown, the column fields required by the deletion file field format consist of deletion of classification fields, deletion of SMI LES fields, deletion of attribute fields, and deletion of version fields; wherein, deletion of classification fields includes project deletion, compound deletion, and attribute deletion;

[0112] a. When the deletion category field is item deletion, the deletion SMI LES field, deletion attribute field and deletion version field are all empty;

[0113] b. When the deletion classification field is compound deletion, the deletion SMI LES field is a corresponding SMI LES sequence; the deletion attribute field and the deletion version field are both empty;

[0114] c. When the deletion category field is attribute deletion, the deletion SMI LES field is a corresponding SMI LES sequence; the deletion attribute field is empty or a corresponding secondary attribute category name; the deletion version field is empty or a secondary attribute version; the deletion attribute field and the deletion version field cannot be empty at the same time;

[0115] 3) Export file field format requirements:

[0116] like Figure 2 As shown, the column fields required by the export file field format consist of export classification fields and export SMI LES fields; wherein the export classification fields include project export and compound export;

[0117] a. When the export classification field is project export, the exported SMI LES field is empty;

[0118] b. When the exported classification field is a compound, the exported SMI LES field is a corresponding SMI LES sequence;

[0119] 4) Query file field format requirements:

[0120] like Figure 2 As shown, the column fields required by the query file field format are composed of a query classification field, an SMI LES configuration field, a chemical element configuration field, and a similarity configuration field; wherein the query classification field includes a query based on SMI LES and a query based on chemical elements;

[0121] a. When the query classification field item is exported as a SMI LES-based query, the SMI LES configuration field is a corresponding SMI LES sequence, the chemical element configuration field is empty, and the similarity configuration field is empty or a similarity;

[0122] b. When the query classification field item is exported as a query based on chemical elements, the SMILES configuration field and the similarity configuration field are empty, and the chemical element configuration field is a chemical element sequence.

[0123] In a specific implementation of an embodiment of the present invention, the database service gateway 1 is specifically used to parse the corresponding first message identifier, first message source address, first message header and first message body from the first service request as the corresponding current message identifier, current message source address, current message header and current message body based on the preset request message parsing rule when performing record addition processing on the request message queue 2 according to the first service request; and add a request message record 21 in the request message queue 2 as the corresponding current newly added record; and set the request message identifier, request message source address, request message header and request message body of the current newly added record to the corresponding current message identifier, current message source address, current message header and current message body; and set the request message status of the current newly added record to unprocessed. Here, the request message parsing rule is a pre-set message parsing rule, such as a parsing rule for HTTPS messages based on TCP / IP.

[0124] In another specific implementation of the embodiment of the present invention, the database service gateway 1 is specifically used to record all feedback message records 31 with unprocessed feedback message status in the feedback message queue 3 as unprocessed records when performing request feedback sending processing according to the feedback message queue 3, and take the earliest unprocessed record as the corresponding current record; and when the current record is not empty, perform corresponding feedback message encapsulation processing according to the feedback message identifier, feedback message target address, feedback message header and feedback message body of the current feedback message record 31 according to the preset feedback message encapsulation rules to obtain the corresponding current feedback message; and send the current feedback message to the feedback message target address of the current feedback message record 31; and reset the feedback message status of the current record to processed after the message is successfully sent. Here, the feedback message encapsulation rules correspond to the request message parsing rules, such as the encapsulation rules of HTTPS messages based on TCP / IP.

[0125] (II) Request message queue 2:

[0126] The request message queue 2 of the embodiment of the present invention is used to store a plurality of request message records 21 .

[0127] Here, each request message record 21 in the embodiment of the present invention corresponds to a first service request. Figure 3 As shown in the data structure diagram of the request message record and feedback message record provided for the embodiment of the present invention, the request message record 21 of the embodiment of the present invention at least includes a request message identifier, a request message source address, a request message header, a request message body and a request message status; wherein the request message identifier, the request message source address, the request message header and the request message body are respectively the corresponding first message identifier, the first message source address, the first message header and the first message body; the request message status includes unprocessed and processed.

[0128] (III) Feedback message queue 3:

[0129] The feedback message queue 3 of the embodiment of the present invention is used to store multiple feedback message records 31.

[0130] Here, each feedback message record 31 in the embodiment of the present invention corresponds to one request message record 21. Figure 3 As shown, the feedback message record 31 of the embodiment of the present invention at least includes a feedback message identifier, a feedback message target address, a feedback message header, a feedback message body and a feedback message status: wherein the feedback message identifier matches the corresponding request message identifier; the feedback message target address matches the corresponding request message source address; the feedback message header includes a second user identifier, a second project identifier, a second instruction type and a first instruction execution status; the second user identifier, the second project identifier and the second instruction type respectively match the corresponding first user identifier, the first project identifier and the first instruction type; the second instruction type includes import, delete, export and query; the first instruction execution status includes success and exception; the feedback message body includes first feedback data; the first feedback data is a compressed package file with one or more CSV files; the feedback message status includes unprocessed and processed.

[0131] (IV) Message processing module 4:

[0132] The message processing module 4 of the embodiment of the present invention is used to perform a cache message adding process on the cache message queue 5 according to the request message queue 2. The message processing module 4 is also used to perform a feedback message adding process on the feedback message queue 3 according to the cache message queue 5.

[0133] In another specific implementation of the embodiment of the present invention, the message processing module 4 is specifically used for performing a cache message adding process on the cache message queue 5 according to the request message queue 2:

[0134] Step A1, record all request message records 21 in the request message queue 2 whose request message status is unprocessed as unprocessed records, and take the earliest unprocessed record as the corresponding current request message record;

[0135] Step A2, when the current request message record is not empty, extracting the request message identifier, request message source address, request message header and request message body of the current request message record as the corresponding current message identifier, current message source address, current message header and current message body;

[0136] Step A3, extracting the first user identifier, the first user token, the first project identifier and the first instruction type of the current message header and the first instruction parameter of the current message body as the corresponding current user identifier, the current user token, the current project identifier, the current instruction type and the current instruction parameter;

[0137] Step A4, and add a cached message record 51 in the cached message queue 5 as the corresponding current cached message record;

[0138] Step A5, and set the request message identifier, request source address, request user identifier, request user token, request project identifier, request instruction type and request instruction parameters of the current cache message record to the corresponding current message identifier, current message source address, current user identifier, current user token, current project identifier, current instruction type and current instruction parameters;

[0139] Step A6, and set the user authority status and data review status of the current cached message record to unreviewed; and set the request feedback data of the current cached message record to empty; and set the request message status of the current cached message record to unprocessed;

[0140] Step A7: When the setting of the current cache message record is completed, the request message status of the current request message record is reset to processed.

[0141] In another specific implementation of the embodiment of the present invention, the message processing module 4 is specifically configured to: when performing feedback message adding processing on the feedback message queue 3 according to the cache message queue 5:

[0142] Step B1, record all cached message records 51 in the cached message queue 5 whose request message status is fed back as fed back records, and take the earliest fed back record as the corresponding current cached message record;

[0143] Step B2: when the current cached message record is not empty, identify whether the user authority status and data audit status of the current cached message record are satisfied, if so, set the corresponding current instruction execution status to success, otherwise, set the corresponding current instruction execution status to abnormal;

[0144] Step B3, and use the request message identifier and request source address of the current cache message record as the corresponding feedback message identifier and feedback message target address; and use the request user identifier, request project identifier, request instruction type and current instruction execution status corresponding to the current cache message record as the corresponding second user identifier, second project identifier, second instruction type and first instruction execution status to form a corresponding feedback message header; and use the request feedback data of the current cache message record as the corresponding first instruction feedback data to form a corresponding feedback message body; and set a corresponding feedback message status to unprocessed;

[0145] Step B4, a corresponding feedback message record 31 is formed by the obtained feedback message identifier, feedback message target address, feedback message header, feedback message body and feedback message status and added to the feedback message queue 3;

[0146] Step B5: After the feedback message record 31 is successfully added, the request message status of the current cache message record is set to processed.

[0147] (V) Cache message queue 5:

[0148] The cache message queue 5 of the embodiment of the present invention is used to store a plurality of cache message records 51 .

[0149] Here, each cache message record 51 in the embodiment of the present invention corresponds to a request message record 21. Figure 4 As shown in the data structure diagram of the cache message record provided for the embodiment of the present invention, the cache message record 51 of the embodiment of the present invention at least includes a request message identifier, a request source address, a request user identifier, a request user token, a request project identifier, a request instruction type, a request instruction parameter, a user authority status, a data review status, a request feedback data and a request message status: wherein the request message identifier, the request source address, the request user identifier, the request user token, the request project identifier, the request instruction type and the request instruction parameter respectively match the corresponding first message identifier, the first message source address, the first user identifier, the first user token, the first project identifier, the first instruction type and the first instruction parameter; the request instruction type includes import, delete, export and query; the user authority status and the data review status both include unreviewed, unsatisfied and satisfied; the request message status includes unprocessed, under review, under processing, feedback received and processed.

[0150] (VI) Database management module 6:

[0151] The database management module 6 of the embodiment of the present invention includes a user audit unit 61 , an operation approval unit 62 , a data import unit 63 , a data deletion unit 64 , a data export unit 65 and a data query unit 66 .

[0152] The user review unit 61 is used to perform a user authority status update process on each cache message record 51 in the cache message queue 5 according to the user authority configuration table 7. The operation approval unit 62 is used to perform a data review status update process on each cache message record 51 in the cache message queue 5 according to the operation approval configuration table 8. The data import unit 63 is used to perform a data addition or update process on the compound database 9 according to the cache message queue 5. The data deletion unit 64 is used to perform a data deletion process on the compound database 9 according to the cache message queue 5. The data export unit 65 is used to perform a data export process on the compound database 9 according to the cache message queue 5. The data query unit 66 is used to perform a data query process on the compound database 9 according to the cache message queue 5.

[0153] In another specific implementation of the embodiment of the present invention, the user review unit 61 is specifically used to perform user authority status update processing on each cache message record 51 in the cache message queue 5 according to the user authority configuration table 7:

[0154] Step C1, record all cached message records 51 in the cached message queue 5 with the request message status as unprocessed as unprocessed records, and use the earliest unprocessed record as the corresponding current unprocessed record; use the requesting user identifier, requesting user token and requesting project identifier of the current unprocessed record as the corresponding current user identifier, current user token and current project identifier; and use the current time as the corresponding current token time;

[0155] Step C2, and taking the user authority configuration record 71 in the user authority configuration table 7 in which the registered user identifier matches the current user identifier, the registered user token matches the current user token, and the token validity period meets the current token time as the corresponding current user authority configuration record;

[0156] Step C3, identifying whether the current user authority configuration record is empty;

[0157] Step C4: if the current user authority configuration record is empty, the user authority status and data review status of the current unprocessed record are both set to unsatisfied, and the request message status of the current unprocessed record is set to fed back;

[0158] Step C5, if the current user authority configuration record is not empty, confirm whether there is a registration project identifier that matches the current project identifier in the registration project identifier set of the current user authority configuration record; if it is confirmed to exist, the user authority status of the current unprocessed record is set to satisfied, and the request message status of the current unprocessed record is set to under review; if it is confirmed that it does not exist, the user authority status and data review status of the current unprocessed record are both set to unsatisfied, and the request message status of the current unprocessed record is set to feedback received.

[0159] In another specific implementation of the embodiment of the present invention, the operation approval unit 62 is specifically configured to: when performing data review status update processing on each cache message record 51 in the cache message queue 5 according to the operation approval configuration table 8:

[0160] Step D1, record all cached message records 51 in the cached message queue 5 whose request message status is under review as under review records, and take the earliest under review record as the corresponding current under review record; take the request user ID, request project ID, request instruction type and request instruction parameters of the current under review record as the corresponding current user ID, current project ID, current instruction type and current instruction parameters; take the registered user type of the user authority configuration record 71 in the user authority configuration table 7 whose registered user ID matches the current user ID as the corresponding current user type; take the operation approval configuration record 81 in the operation approval configuration table 8 whose approval project ID matches the current project ID as the corresponding current operation approval configuration record;

[0161] Step D2, identifying whether the current operation approval configuration record is empty;

[0162] Step D3, if the current operation approval configuration record is empty, the data review status of the current review record is set to satisfied, and the request message status of the current review record is set to processing;

[0163] Step D4, if the current operation approval configuration record is not empty, the approval configuration whose approval user type in the approval configuration set of the current operation approval configuration record matches the current user type is used as the corresponding current approval configuration, and whether the current approval configuration is empty is identified;

[0164] Step D4-A, if the current approval configuration is empty, the data review status of the current review record is set to satisfied, and the request message status of the current review record is set to processing;

[0165] Step D4-B, if the current approval configuration is not empty, confirm whether there is a configuration bit corresponding to the current instruction type in the import, delete and export configuration bits of the current approval configuration; if it exists or not, set the data review status recorded in the current review to satisfied, and set the request message status recorded in the current review to processing; if it is confirmed to exist, set the configuration bit corresponding to the current instruction type in the import, delete and export configuration bits of the current approval configuration as the corresponding current configuration bit, and identify the current configuration bit;

[0166] Step D4-BA, if the current configuration bit is 0, the data audit status recorded in the current audit is set to satisfied, and the request message status recorded in the current audit is set to processing;

[0167] Step D4-BB, if the current configuration bit is 1, the approval interface corresponding to the current instruction type in the import, deletion and export approval interfaces of the approval interface set of the current operation approval configuration record is used as the corresponding current approval interface; and a unique timestamp is generated based on the current time as the corresponding first application identifier, and a corresponding first approval application is composed of the first application identifier and the current user identifier, the current project identifier, the current instruction type, and the current instruction parameters and sent to the current approval interface; and after the sending is successful, the request message identifier recorded in the current review is used as the corresponding first message identifier, and the first application identifier and the first message identifier form a corresponding first approval record and save it; and after the approval record is successfully saved, the request message status recorded in the current review is set to being processed.

[0168] The operation approval unit 62 is also used to, when a corresponding first approval result is received from any approval interface, use the currently received first approval result as the corresponding current approval result; and use the first approval record whose first application identifier matches the second application identifier of the current approval result among all the saved first approval records as the corresponding current approval record; and use the cached message record 51 whose request message identifier in the cached message queue 5 matches the first message identifier of the current approval record as the corresponding current message record; and use the first approval feedback of the current approval result as the corresponding current approval feedback; and identify the current approval feedback; if the current approval feedback is approval passed, set the data review status of the current message record to satisfied; if the current approval feedback is approval failed, set the data review status of the current message record to unsatisfied, and set the request message status of the current message record to fed back; wherein, the first approval result includes the second application identifier and the first approval feedback; and the first approval feedback includes approval passed and approval failed.

[0169] In another specific implementation of the embodiment of the present invention, the data import unit 63 is specifically used for adding or updating data to the compound database 9 according to the cache message queue 5:

[0170] Step E1, all cached message records 51 in the cached message queue 5 whose user authority status and data audit status are satisfied, whose request message status is processing, and whose request instruction type is import are recorded as import operation records, and the earliest import operation record is taken as the corresponding current import operation record;

[0171] Step E2, and use the request project identifier of the current import operation record as the corresponding current project identifier; and use the CSV file of the request instruction parameters of the current import operation record as the corresponding current import instruction file; and extract the data rows formatted from the current import instruction file based on the import file field format requirements to obtain the corresponding first data row sequence;

[0172] Wherein, the first data row sequence is formed by sequentially sorting one or more first data rows;

[0173] As mentioned above, the field format of the column field row of the CSV file of the request instruction parameter of the current import operation record should meet the corresponding import file field format requirements; a customized solution for the import file field format requirements provided by the embodiment of the present invention is as follows Figure 2 As shown, the next step E3 is actually to press Figure 2 The three types of subdivision import instructions (project creation, primary attribute import, secondary attribute import) and the corresponding subdivision instruction parameters, i.e. other fields corresponding to each subdivision import instruction, are used to perform the corresponding three types of import operations;

[0174] Step E3, and sequentially traverse all the first data rows of the first data row sequence; and in the traversal process, take the currently traversed first data row as the corresponding current data row; and extract the sequence index of the current data row in the first data row sequence as the corresponding first processing index; and extract the import classification field of the current data row as the corresponding current import classification; and identify the current import classification; if the current import classification is project creation, then based on the current project identifier and the member field of the current data row, the corresponding database project creation or update processing is performed in the compound database 9 to obtain the corresponding first processing result; if the current import classification is primary attribute import, then based on the current project identifier and the SMI LES field, chemical formula field, element sequence field, first class fingerprint field, second class fingerprint field, third class fingerprint field and primary attribute field of the current data row, the corresponding compound primary attribute addition or update processing is performed in the compound database 9 to obtain the corresponding first processing result; if the current import classification is secondary attribute import, then based on the current project identifier and the SMI LES field of the current data row, the chemical formula field, element sequence field, first class fingerprint field, second class fingerprint field, third class fingerprint field and primary attribute field, the corresponding compound primary attribute is added or updated in the compound database 9 to obtain the corresponding first processing result. The LES field, the secondary attribute classification field, the secondary attribute field and the version field are processed in the compound database 9 to obtain the corresponding first processing result; and the obtained first processing index and the first processing result form a corresponding first processing feedback; and at the end of the traversal, all the obtained first processing feedbacks form a corresponding first processing feedback sequence;

[0175] The first processing result includes success and failure;

[0176] Step E4, and bring the first processed feedback sequence into a preset type of feedback CSV file template to perform corresponding CSV file assembly to obtain the corresponding first feedback CSV file; and based on the preset file compression package tool, compress the first feedback CSV file to obtain the corresponding first compressed package file; and based on the first compressed package file, set the request feedback data of the current import operation record; and set the request message status of the current import operation record to have been fed back.

[0177] Here, a type of feedback CSV file template is a pre-set CSV file assembly template, which can be customized based on actual application requirements. The embodiment of the present invention does not impose specific restrictions on the type of feedback CSV file template.

[0178] In another specific implementation of the embodiment of the present invention, the data import unit 63 is specifically used to perform corresponding database project creation or update processing in the compound database 9 based on the current project identifier and the member field of the current data row to obtain the corresponding first processing result:

[0179] Step F1, extract the member field of the current data row as the corresponding current project member identification set; and use the project index record 911 in the project index table 91 whose project index identification matches the current project identification and whose index record status is not deleted as the corresponding current project index record; and identify whether the current project index record is empty;

[0180] Step F2, if the current project index record is not empty, then when the current project member identification set is empty, the project member identification set of the current project index record is reset to the corresponding current project member identification set; and after the reset is successful, the corresponding first processing result is set to success;

[0181] Step F3, if the current project index record is empty, then add a new project index record 911 in the project index table 91 as the corresponding new project index record 911; and assign a unique record identifier to the new project index record 911 as the corresponding current record identifier; and set the index record identifier, project index identifier and project member identifier set of the new project index record 911 to the corresponding current record identifier, current project identifier and current project member identifier set; and set the index record status of the new project index record 911 to not deleted; and create an empty compound primary attribute table 92 as the corresponding current primary attribute table; and assign a unique data table identifier to the current primary attribute table as the corresponding current primary attribute table identifier; and set the primary attribute table identifier of the new project index record 911 to the corresponding current primary attribute table identifier; and after all data items of the new project index record 911 are successfully set, set the corresponding first processing result to success.

[0182] In another specific implementation of the embodiment of the present invention, the data import unit 63 is specifically used to add or update the corresponding compound primary attribute in the compound database 9 based on the current project identifier and the SMILES field, chemical formula field, element sequence field, first-class fingerprint field, second-class fingerprint field, third-class fingerprint field and primary attribute field of the current data row to obtain the corresponding first processing result:

[0183] Step G1, taking the project index record 911 whose project index identifier in the project index table 91 matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and taking the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table; and extracting the SMI LES field, chemical formula field, element sequence field, first-class fingerprint field, second-class fingerprint field, third-class fingerprint field and primary attribute field of the current data row as the corresponding current SMI LES sequence, current molecular chemical formula, current chemical element sequence, current first-class molecular fingerprint, current second-class molecular fingerprint, current third-class molecular fingerprint and current primary attribute set;

[0184] Step G2, and taking the compound primary attribute record 921 whose SMILES sequence in the current primary attribute table matches the current SMILES sequence and whose primary attribute record status is not deleted as the corresponding current primary attribute record; and identifying whether the current primary attribute record is empty;

[0185] Step G3, if the current primary attribute record is empty, then add a compound primary attribute record 921 in the current primary attribute table as the corresponding newly added primary attribute record; and assign a unique record identifier to the newly added primary attribute record as the corresponding current record identifier; and set the primary attribute record identifier, SMI LES sequence, molecular chemical formula, chemical element sequence, first-class molecular fingerprint, second-class molecular fingerprint, third-class molecular fingerprint and primary attribute set of the newly added primary attribute record to the corresponding current record identifier, current SMI LES sequence, current molecular chemical formula, current chemical element sequence, current first-class molecular fingerprint, current second-class molecular fingerprint, current third-class molecular fingerprint and current primary attribute set; and set the primary attribute record status of the newly added primary attribute record to undeleted; and create an empty compound secondary attribute table 93 as the corresponding current secondary attribute table; and assign a unique data table identifier to the current secondary attribute table as the corresponding current secondary attribute table identifier; and set the secondary attribute table identifier of the newly added primary attribute record to the corresponding current secondary attribute table identifier; and after all data items of the newly added primary attribute record are successfully set, set the corresponding first processing result to success;

[0186] Step G4, if the current first-level attribute record is not empty, then based on the current SMI LES sequence, current molecular chemical formula, current chemical element sequence, current class I molecular fingerprint, current class II molecular fingerprint, current class III molecular fingerprint or current first-level attribute set that is not empty, reset the corresponding SMI LES sequence, molecular chemical formula, chemical element sequence, class I molecular fingerprint, class II molecular fingerprint, class III molecular fingerprint or first-level attribute set in the current first-level attribute record; and after all data items of the current first-level attribute record are successfully reset, set the corresponding first processing result to success.

[0187] In another specific implementation of the embodiment of the present invention, the data import unit 63 is specifically used to add the corresponding compound secondary attribute in the compound database 9 based on the current project identifier and the SMILES field, the secondary attribute classification field, the secondary attribute field and the version field of the current data row to obtain the corresponding first processing result:

[0188] Step H1, extract the SMILES field, secondary attribute classification field, secondary attribute field and version field of the current data row as the corresponding current SMILES sequence, current secondary attribute classification name, current secondary attribute set and current secondary attribute version; and use the current time as the corresponding current adding time;

[0189] Step H2, and use the project index record 911 in the project index table 91 that matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and use the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table; and use the compound primary attribute record 921 in the current primary attribute table that matches the SMI LES sequence and the current SMI LES sequence and whose primary attribute record status is not deleted as the corresponding current primary attribute record; and use the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of the current primary attribute record as the corresponding current secondary attribute table;

[0190] Step H3, and add a compound secondary attribute record 931 to the current secondary attribute table as the corresponding newly added secondary attribute record; and assign a unique record identifier to the newly added secondary attribute record as the corresponding current record identifier; and set the secondary attribute record identifier, secondary attribute category name, secondary attribute set, secondary attribute version and secondary attribute addition time of the newly added secondary attribute record to the corresponding current record identifier, current secondary attribute category name, current secondary attribute set, current secondary attribute version and current addition time; and set the secondary attribute record status of the newly added secondary attribute record to not deleted; and after all data items of the newly added secondary attribute record are successfully set, set the corresponding first processing result to success.

[0191] In another specific implementation of the embodiment of the present invention, the data deleting unit 64 is specifically configured to: when performing data deletion processing on the compound database 9 according to the cache message queue 5:

[0192] Step J1, all cached message records 51 in the cached message queue 5 whose user authority status and data audit status are satisfied, whose request message status is in process, and whose request instruction type is delete are recorded as delete operation records, and the earliest delete operation record is taken as the corresponding current delete operation record;

[0193] Step J2, and use the request item identifier of the current deletion operation record as the corresponding current item identifier; and use the CSV file of the request instruction parameters of the current deletion operation record as the corresponding current deletion instruction file; and extract the data row formatted from the current deletion instruction file based on the deletion file field format requirements to obtain the corresponding second data row sequence;

[0194] Wherein, the second data row sequence is formed by sequentially sorting one or more second data rows;

[0195] As mentioned above, the field format of the column field row of the CSV file of the request instruction parameter of the current deletion operation record should meet the corresponding deletion file field format requirements; a customized solution for the deletion file field format requirements provided by the embodiment of the present invention is as follows Figure 2 As shown, the next step J3 is actually to press Figure 2 The three types of subdivision deletion instructions (project deletion, compound deletion, attribute deletion) given in the and the corresponding subdivision instruction parameters, i.e., other fields corresponding to each subdivision deletion instruction, are used to perform the corresponding three types of deletion operations;

[0196] Step J3, and sequentially traverse all the second data rows of the second data row sequence; and in the traversal process, take the currently traversed second data row as the corresponding current data row; and extract the sequence index of the current data row in the second data row sequence as the corresponding second processing index; and extract the deletion classification field of the current data row as the corresponding current deletion classification; and identify the current deletion classification; if the current deletion classification is project deletion, then based on the current project identifier, the corresponding database project deletion processing is performed in the compound database 9 to obtain the corresponding second processing result; if the current deletion classification is compound deletion, then based on the current project identifier and the deletion SMILES field of the current data row, the corresponding compound deletion processing is performed in the compound database 9 to obtain the corresponding second processing result; if the current deletion classification is attribute deletion, then based on the current project identifier and the deletion SMILES field, deletion attribute field and deletion version field of the current data row, the corresponding compound attribute deletion processing is performed in the compound database 9 to obtain the corresponding second processing result; and the obtained second processing index and the second processing result constitute a corresponding second processing feedback; and at the end of the traversal, all the obtained second processing feedbacks constitute a corresponding second processing feedback sequence;

[0197] The second processing result includes success and failure;

[0198] Step J4, and bring the second processing feedback sequence into a type of feedback CSV file template to assemble the corresponding CSV file to obtain the corresponding second feedback CSV file; and based on the preset file compression package tool, compress the second feedback CSV file to obtain the corresponding second compressed package file; and based on the second compressed package file, set the request feedback data of the current deletion operation record; and set the request message status of the current deletion operation record to have been fed back.

[0199] In another specific implementation of the embodiment of the present invention, the data deleting unit 64 is specifically configured to, when a corresponding database item deletion process is performed in the compound database 9 based on the current item identifier to obtain a corresponding second processing result:

[0200] Step K1, taking the project index record 911 in the project index table 91 whose project index identifier matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; taking the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding first attribute table; taking the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of each compound primary attribute record 921 in the current primary attribute table as the corresponding second attribute table;

[0201] Step K2, and set the index record status of the current project index record to deleted; and set the primary attribute record status of all compound primary attribute records 921 in the first attribute table to deleted; and set the secondary attribute record status of all compound secondary attribute records 931 in the second attribute table to deleted; and after all record statuses corresponding to the current project index record are successfully set to deleted, set the corresponding second processing result to success.

[0202] In another specific implementation of the embodiment of the present invention, the data deletion unit 64 is specifically used to perform corresponding compound deletion processing in the compound database 9 based on the current project identifier and the deleted SMILES field of the current data row to obtain a corresponding second processing result:

[0203] Step L1, extract the deleted SMI LES field of the current data row as the corresponding current SMI LES sequence; and use the project index record 911 in the project index table 91 whose project index identifier matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and use the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table; and use the compound primary attribute record 921 whose SMI LES sequence in the current primary attribute table matches the current SMI LES sequence as the corresponding current primary attribute record; and use the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of the current primary attribute record as the corresponding current secondary attribute table;

[0204] Step L2, and set the primary attribute record status of the current primary attribute record to deleted; and set the secondary attribute record status of all compound secondary attribute records 931 in the current secondary attribute table to deleted; and after all record statuses corresponding to the current primary attribute record are successfully set to deleted, set the corresponding second processing result to success.

[0205] In another specific implementation of the embodiment of the present invention, the data deletion unit 64 is specifically used to perform corresponding compound attribute deletion processing in the compound database 9 based on the current project identifier and the deleted SMILES field, deleted attribute field and deleted version field of the current data row to obtain a corresponding second processing result:

[0206] Step M1, extract the deleted SMI LES field, deleted attribute field and deleted version field of the current data row as the corresponding current SMI LES sequence, current deleted attribute and current deleted version; and use the project index record 911 in the project index table 91 whose project index identifier matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and use the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table; and use the compound primary attribute record 921 in the current primary attribute table whose SMI LES sequence matches the current SMI LES sequence as the corresponding current primary attribute record; and use the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of the current primary attribute record as the corresponding current secondary attribute table;

[0207] Step M2, and identify the current deletion attribute and the current deletion version; if the current deletion attribute is not empty but the current deletion version is empty, then the secondary attribute record status of all compound secondary attribute records 931 whose secondary attribute classification names match the current deletion attribute in the current secondary attribute table are set to deleted; if the current deletion attribute is empty but the current deletion version is not empty, then the secondary attribute record status of all compound secondary attribute records 931 whose secondary attribute versions match the current deletion version in the current secondary attribute table are set to deleted; if both the current deletion attribute and the current deletion version are not empty, then the secondary attribute record status of all compound secondary attribute records 931 whose secondary attribute classification names match the current deletion attribute and whose secondary attribute versions match the current deletion version in the current secondary attribute table are set to deleted;

[0208] Step M3: after all record states corresponding to the current deletion attribute and the current deletion version in the current secondary attribute table are successfully set to deleted, the corresponding second processing result is set to success.

[0209] In another specific implementation of the embodiment of the present invention, the data export unit 65 is specifically used for, when performing data export processing on the compound database 9 according to the cache message queue 5:

[0210] Step N1, all cached message records 51 in the cached message queue 5 whose user authority status and data audit status are satisfied, whose request message status is in process, and whose request instruction type is export are recorded as export operation records, and the earliest export operation record is taken as the corresponding current export operation record;

[0211] Step N2, and use the request project identifier of the current export operation record as the corresponding current project identifier; and use the CSV file of the request instruction parameters of the current export operation record as the corresponding current export instruction file; and extract the data rows formatted from the current export instruction file based on the export file field format requirements to obtain the corresponding third data row sequence;

[0212] Wherein, the third data row sequence is formed by sequentially sorting one or more third data rows;

[0213] As mentioned above, the field format of the column field row of the CSV file of the request instruction parameter of the current export operation record should meet the corresponding export file field format requirements; a customized solution for the export file field format requirements provided by the embodiment of the present invention is as follows Figure 2 As shown, the next step N3 is actually to press Figure 2 The two types of subdivided export instructions (project export, compound export) given in and the corresponding subdivided instruction parameters, i.e., other fields corresponding to each subdivided export instruction, are used to perform the corresponding two types of export operations;

[0214] Step N3, and sequentially traverse all the third data rows of the third data row sequence; and in the traversal process, take the third data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the third data row sequence as the corresponding third processing index; and extract the export classification field of the current data row as the corresponding current export classification; and identify the current export classification; if the current export classification is project export, then based on the current project identifier, perform the corresponding database project export processing in the compound database 9 to obtain the corresponding third processing result, and bring the third processing result and the corresponding third processing index into the preset second-category feedback CSV file template for corresponding CSV file assembly to obtain the corresponding third feedback CSV file; if the current export classification is compound export, then based on the current project identifier and the export SMILES field of the current data row, perform the corresponding compound export processing in the compound database 9 to obtain the corresponding third processing result, and bring the third processing result and the corresponding third processing index into the preset third-category feedback CSV file template for corresponding CSV file assembly to obtain the corresponding third feedback CSV file;

[0215] Here, the second and third types of feedback CSV file templates are each a pre-set CSV file assembly template, which can be customized based on actual application requirements. The embodiment of the present invention does not impose specific restrictions on the second and third types of feedback CSV file templates;

[0216] Step N4, at the end of the traversal, all the third feedback CSV files obtained are saved in the same file directory, and the current file directory is compressed based on the preset file compression package tool to obtain the corresponding third compressed package file; and the request feedback data of the current export operation record is set based on the third compressed package file; and the request message status of the current export operation record is set to feedback received.

[0217] In another specific implementation of the embodiment of the present invention, the data export unit 65 is specifically configured to, when performing corresponding database item export processing in the compound database 9 based on the current item identifier to obtain a corresponding third processing result:

[0218] Step P1, taking the project index record 911 in the project index table 91 whose project index identifier matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and taking the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table;

[0219] Step P2, and use the compound primary attribute record 921 whose primary attribute record status is not deleted in the current primary attribute table as the corresponding current primary attribute record; and use the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of the current primary attribute record as the corresponding current secondary attribute table; and extract the SMILES sequence, molecular chemical formula, chemical element sequence, first-class molecular fingerprint, second-class molecular fingerprint, third-class molecular fingerprint and primary attribute set of the current primary attribute record as the corresponding first ... chemical element sequence, molecular chemical formula, molecular formula, third-class molecular fingerprint and primary attribute set of the current primary attribute record as the corresponding first SMILES sequence, molecular chemical formula, chemical element sequence, molecular chemical formula, molecular formula, third-class molecular fingerprint and primary attribute set of the current primary attribute record as the corresponding first SMILES sequence, molecular chemical formula, chemical element sequence, molecular chemical formula, molecular formula, third-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first-class molecular fingerprint and first- LES sequence, the first molecular chemical formula, the first chemical element sequence, the first molecular fingerprint A, the first molecular fingerprint B, the first molecular fingerprint C and the first attribute set; and all the secondary attribute classification names in the current secondary attribute table are counted to obtain the corresponding secondary attribute classification name set; and each secondary attribute classification name in the secondary attribute classification name set is used as the corresponding current classification name, and the secondary attribute set of the compound secondary attribute record 931 whose secondary attribute classification name in the current secondary attribute table is the same as the current classification name and the secondary attribute record status is not deleted and the secondary attribute version is the latest version is extracted as the corresponding current secondary attribute set, and when the current secondary attribute set is not empty, the current classification name and the current secondary attribute set form a corresponding second attribute set; and the first SMILES sequence, the first molecular chemical formula, the first chemical element sequence, the first molecular fingerprint A, the first molecular fingerprint B, the first molecular fingerprint C, the first attribute set and all the second attribute sets corresponding to the current first-level attribute record form a corresponding first compound export data set;

[0220] Step P3: all the first compound derived data sets are used to form a corresponding third processing result.

[0221] In another specific implementation of the embodiment of the present invention, the data export unit 65 is specifically used to perform corresponding compound export processing in the compound database 9 based on the current project identifier and the exported SIMILES field of the current data row to obtain a corresponding third processing result:

[0222] Step Q1, extract the exported SMI LES field of the current data row as the corresponding current SMI LES sequence; and use the project index record 911 in the project index table 91 whose project index identifier matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and use the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table; and use the compound primary attribute record 921 in the current primary attribute table whose SMI LES sequence matches the current SMI LES sequence and whose primary attribute record status is not deleted as the corresponding current primary attribute record;

[0223] Step Q2, and extract the SMILES sequence, molecular chemical formula, chemical element sequence, first-class molecular fingerprint, second-class molecular fingerprint, third-class molecular fingerprint and first-class attribute set of the current first-class attribute record as the corresponding second SMILES sequence, second molecular chemical formula, second chemical element sequence, second molecular fingerprint A, second molecular fingerprint B, second molecular fingerprint C and third attribute set;

[0224] Step Q3, and use the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of the current primary attribute record as the corresponding current secondary attribute table; and perform statistics on all secondary attribute classification names in the current secondary attribute table to obtain a corresponding secondary attribute classification name set; and use each secondary attribute classification name in the secondary attribute classification name set as the corresponding current classification name, and extract the secondary attribute set of the compound secondary attribute record 931 whose secondary attribute classification name in the current secondary attribute table is the same as the current classification name and the secondary attribute record status is not deleted and the secondary attribute version is the latest version as the corresponding current secondary attribute set, and when the current secondary attribute set is not empty, a corresponding fourth attribute set is formed by the current classification name and the current secondary attribute set;

[0225] Step Q4, the second SMILES sequence, the second molecular chemical formula, the second chemical element sequence, the second molecular fingerprint A, the second molecular fingerprint B, the second molecular fingerprint C, the third attribute set and all the fourth attribute sets corresponding to the current first-level attribute record form a corresponding third processing result.

[0226] In another specific implementation of the embodiment of the present invention, the data query unit 66 is specifically used to perform data query processing on the compound database 9 according to the cache message queue 5:

[0227] Step R1, record all cached message records 51 in the cached message queue 5 whose user authority status and data audit status are satisfied, whose request message status is processing, and whose request instruction type is query as query operation records, and take the earliest query operation record as the corresponding current query operation record;

[0228] Step R2, and use the request item identifier of the current query operation record as the corresponding current item identifier; and use the CSV file of the request instruction parameters of the current query operation record as the corresponding current query instruction file; and extract the data rows formatted from the current query instruction file based on the query file field format requirements to obtain the corresponding fourth data row sequence;

[0229] The fourth data row sequence is formed by sequentially sorting one or more fourth data rows;

[0230] As mentioned above, the field format of the column field row of the CSV file of the request instruction parameter of the current query operation record should meet the corresponding query file field format requirements; a customized solution for the query file field format requirements provided by the embodiment of the present invention is as follows Figure 2 As shown, the next step R3 is actually to press Figure 2 The two types of subdivision query instructions (query based on SMI LES and query based on chemical elements) given in the specification and the corresponding subdivision instruction parameters, i.e., other fields corresponding to each subdivision query instruction, are used to perform the corresponding two types of query operations;

[0231] Step R3, and sequentially traverse all fourth data rows of the fourth data row sequence; and in the traversal process, take the fourth data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the fourth data row sequence as the corresponding fourth processing index; and extract the query classification field of the current data row as the corresponding current query classification; and identify the current query classification; if the current query classification is based on SMI LES query, then based on the current project identifier and the SMI LES configuration field and similarity configuration field of the current data row, the compound database 9 is subjected to corresponding compound query processing to obtain the corresponding fourth processing result, and the fourth processing result and the corresponding fourth processing index are brought into the preset four-category feedback CSV file template for corresponding CSV file assembly to obtain the corresponding fourth feedback CSV file; if the current export classification is based on chemical element query, then based on the current project identifier and the chemical element configuration field of the current data row, the compound database 9 is subjected to corresponding compound query processing to obtain the corresponding fourth processing result, and the fourth processing result and the corresponding fourth processing index are brought into the preset five-category feedback CSV file template for corresponding CSV file assembly to obtain the corresponding fourth feedback CSV file;

[0232] Here, the fourth and fifth types of feedback CSV file templates are each a pre-set CSV file assembly template, which can be customized based on actual application requirements. The embodiment of the present invention does not impose specific restrictions on the fourth and fifth types of feedback CSV file templates;

[0233] Step R4, at the end of the traversal, all the fourth feedback CSV files obtained are saved in the same file directory, and the current file directory is compressed based on the preset file compression package tool to obtain the corresponding fourth compressed package file; and based on the fourth compressed package file, the request feedback data of the current query operation record is set; and the request message status of the current query operation record is set to feedback received.

[0234] In another specific implementation of the embodiment of the present invention, the data query unit 66 is specifically used to perform corresponding compound query processing on the compound database 9 based on the current project identifier and the SMILES configuration field and the similarity configuration field of the current data row to obtain a corresponding fourth processing result:

[0235] Step S1, extract the SMILES configuration field and the similarity configuration field of the current data row as the corresponding current SMILES sequence and current similarity; and use the project index record 911 in the project index table 91 whose project index identifier matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and use the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table;

[0236] Step S2, and identify whether the current similarity is empty; if the current similarity is not empty, set the corresponding current similarity threshold as the current similarity; if the current similarity is empty, set the corresponding current similarity threshold as the preset first similarity threshold;

[0237] Here, the first similarity threshold is a preset default threshold parameter;

[0238] Step S3, extract the compound primary attribute records 921 in the current primary attribute table whose primary attribute record status is not deleted and whose SMILES sequence has a similarity with the current SMILES sequence exceeding the corresponding current similarity threshold, and sort them in descending order of similarity to form a corresponding first record sequence;

[0239] Step S4, when the first record sequence is not empty, perform a round of traversal on all compound primary attribute records 921 of the first record sequence; and in this round of traversal, the currently traversed compound primary attribute record 921 is used as the corresponding current primary attribute record; and the SMILES sequence, molecular chemical formula, chemical element sequence, first class molecular fingerprint, second class molecular fingerprint, third class molecular fingerprint and primary attribute set of the current primary attribute record are extracted as the corresponding third ... chemical element sequence, first class molecular fingerprint, second class molecular fingerprint, third class molecular fingerprint and primary attribute set of the current primary attribute record LES sequence, the third molecular chemical formula, the third chemical element sequence, the third molecular fingerprint A, the third molecular fingerprint B, the third molecular fingerprint C and the fifth attribute set; and the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of the current primary attribute record is used as the corresponding current secondary attribute table; and all the secondary attribute classification names in the current secondary attribute table are counted to obtain the corresponding secondary attribute classification name set; and each secondary attribute classification name in the secondary attribute classification name set is used as the corresponding current classification name, and the secondary attribute set of the compound secondary attribute record 931 whose secondary attribute classification name in the current secondary attribute table is the same as the current classification name and the secondary attribute record status is not deleted and the secondary attribute version is the latest version is extracted as the corresponding current secondary attribute set, and when the current secondary attribute set is not empty, the current classification name and the current secondary attribute set form a corresponding sixth attribute set; and the third SMI LES sequence, the third molecular chemical formula, the third chemical element sequence, the third molecular fingerprint A, the third molecular fingerprint B, the third molecular fingerprint C, the fifth attribute set and all the sixth attribute sets corresponding to the current primary attribute record form a corresponding first query record; and at the end of this round of traversal, all the obtained first query records form the corresponding fourth processing result.

[0240] In another specific implementation of the embodiment of the present invention, the data query unit 66 is specifically used to perform corresponding compound query processing on the compound database 9 based on the current project identifier and the chemical element configuration field of the current data row to obtain a corresponding fourth processing result:

[0241] Step T1, extract the chemical element configuration field of the current data row as the corresponding current chemical element sequence; and use the project index record 911 whose project index identifier in the project index table 91 matches the current project identifier and whose index record status is not deleted as the corresponding current project index record; and use the compound primary attribute table 92 corresponding to the primary attribute table identifier of the current project index record as the corresponding current primary attribute table;

[0242] Step T2, extract the compound primary attribute records 921 whose primary attribute record status is not deleted and whose chemical element sequence includes the current chemical element sequence in the current primary attribute table, and sort them in the order of record identifiers to form a corresponding second record sequence;

[0243] Step T3, when the second record sequence is not empty, perform a round of traversal on all compound primary attribute records 921 of the second record sequence; and in this round of traversal, the currently traversed compound primary attribute record 921 is used as the corresponding current primary attribute record; and the SMILES sequence, molecular chemical formula, chemical element sequence, first-class molecular fingerprint, second-class molecular fingerprint, third-class molecular fingerprint and primary attribute set of the current primary attribute record are extracted as the corresponding fourth ... chemical element sequence, first-class molecular fingerprint, second-class molecular fingerprint, third-class molecular fingerprint and primary attribute set of the current primary attribute record are extracted as the corresponding fourth SMILES sequence, molecular chemical formula, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical element sequence, chemical LES sequence, fourth molecular chemical formula, fourth chemical element sequence, fourth molecular fingerprint A, fourth molecular fingerprint B, fourth molecular fingerprint C and seventh attribute set; and the compound secondary attribute table 93 corresponding to the secondary attribute table identifier of the current primary attribute record is used as the corresponding current secondary attribute table; and all secondary attribute classification names in the current secondary attribute table are counted to obtain the corresponding secondary attribute classification name set; and each secondary attribute classification name in the secondary attribute classification name set is used as the corresponding current classification name, and the secondary attribute set of the compound secondary attribute record 931 whose secondary attribute classification name in the current secondary attribute table is the same as the current classification name and the secondary attribute record status is not deleted and the secondary attribute version is the latest version is extracted as the corresponding current secondary attribute set, and when the current secondary attribute set is not empty, the current classification name and the current secondary attribute set form a corresponding eighth attribute set; and the fourth SMI LES sequence, fourth molecular chemical formula, fourth chemical element sequence, fourth molecular fingerprint A, fourth molecular fingerprint B, fourth molecular fingerprint C, seventh attribute set and all eighth attribute sets corresponding to the current primary attribute record form a corresponding fourth query record; and at the end of this round of traversal, all the obtained fourth query records form the corresponding fourth processing result.

[0244] From the above description of the processing units of the database management module 6, it can be seen that the data import unit 63, the data deletion unit 64, the data export unit 65 and the data query unit 66 of the embodiment of the present invention are actually four batch processors for batch reading and writing operations on the compound database 9. The working principle of these four batch processors (data import unit 63, data deletion unit 64, data export unit 65 and data query unit 66) is: according to four types of pre-customized batch file parsing rules (i.e. Figure 2The batch processors parse and execute a series of read and write operations of the input batch file (i.e., the CSV file in the request instruction parameter of the cache message record 51) one by one and return the corresponding batch feedback file (i.e., the CSV file compressed package stored in the request feedback data of the cache message record 51). It should be noted that the compound database 9 of the embodiment of the present invention is a logical database, and the various data table items therein can be stored in different types of physical databases (e.g., relational databases, distributed non-relational databases, etc.) based on application requirements. Then, when executing each parsed database read and write operation, the above four batch processors need to convert the corresponding physical database instruction based on the database instruction format of the target physical database corresponding to the read and write operation to obtain one or more physical database instructions and execute them.

[0245] It should also be noted that, based on the design principles of the above four batch processors (data import unit 63, data deletion unit 64, data export unit 65 and data query unit 66) in the embodiment of the present invention, the following adjustments can be made according to actual application requirements during the specific implementation process: 1) During the specific implementation process, the parsing process of the import / delete / export / query subdivision instructions can be modified by modifying the batch file parsing rules according to actual application requirements, or more import / delete / export / query subdivision instructions can be added, or other major categories of instructions other than import / delete / export / query can be added; 2) During the specific implementation process, the CSV file type of the batch file can be replaced with other text file types, such as txt file type, ini file type, xml file type, json file, etc., by modifying the batch file parsing rules according to actual application requirements; 3) During the specific implementation process, the CSV file type of the batch feedback file can be replaced with other text file types, such as txt file type, xml file type, json file, etc., according to actual application requirements.

[0246] (VII) User authority configuration table 7:

[0247] The user authority configuration table 7 of the embodiment of the present invention is used to store a plurality of user authority configuration records 71 ​​.

[0248] Here, if Figure 5As shown in the data structure diagram of the user authority configuration record and operation approval configuration record provided for the embodiment of the present invention, the user authority configuration record 71 of the embodiment of the present invention at least includes an authority configuration record identifier, a registered user identifier, a registered user type, a registered user token, a token validity period and a registration project identifier set; wherein the authority configuration record identifier is a unique record identifier corresponding to the current user authority configuration record; each user authority configuration record 71 corresponds to a registered user, and the registered user identifier is a unique identity identifier of the current registered user; the registered user type includes an administrator type and multiple non-administrator types; the registered user token is the identity token information pre-assigned to the current registered user, and the token validity period is the validity period information of the current token; the registration project identifier set is composed of one or more registration project identifiers when it is not empty; each registered user can join one or more database projects, and each registration project identifier in the registration project identifier set is a project identifier of a database project where the current registered user is located.

[0249] It should be noted that the user authority configuration table 7 of the embodiment of the present invention is a logical data table item. The embodiment of the present invention can select a corresponding physical database (such as a relational database, a distributed non-relational database, etc.) for the user authority configuration table 7 based on application requirements for physical data storage, thereby obtaining a variety of authority configuration table storage customization solutions. Commonly used relational databases mentioned in the embodiment of the present invention include SQL, MySQL, PostgreSQL and other databases, and commonly used distributed non-relational databases mentioned in the embodiment of the present invention include MongoDB, Red is, SequoiaDB and other databases. One of the multiple authority configuration table storage customization solutions that can be provided by the embodiment of the present invention is: using SQL or MySQL database to store the user authority configuration table 7.

[0250] (VIII) Operation Approval Configuration Table 8:

[0251] The operation approval configuration table 8 of the embodiment of the present invention is used to store a plurality of operation approval configuration records 81 .

[0252] Here, if Figure 5 As shown, the operation approval configuration record 81 of the embodiment of the present invention at least includes an approval configuration record identifier, an approval item identifier, an approval configuration set and an approval interface set; wherein:

[0253] 1) The approval configuration record identifier is the unique record identifier corresponding to the current operation approval configuration record;

[0254] 2) Each operation approval configuration record 81 corresponds to a database item that needs data approval, and the approval item identifier is the unique item identifier of the current database item;

[0255] 3) The approval configuration set is composed of one or more approval configurations; each approval configuration is used to set whether three types of operations corresponding to a type of user need approval, and each approval configuration is composed of an approval user type, an import configuration bit, a delete configuration bit, and an export configuration bit; among them, the approval user type includes an administrator type and all non-administrator types; the values ​​of the import, delete, and export configuration bits include 0 and 1, and when the import, delete, or export configuration bit is 0, it means that the current user type does not need to be approved when processing data import, delete, or export operations in the current database project, and when the import, delete, or export configuration bit is 1, it means that the current user type needs to be approved when processing data import, delete, or export operations in the current database project; the embodiment of the present invention stipulates that at least one of the import, delete, and export configuration bits is 1;

[0256] 4) The approval interface set includes an import approval interface, a delete approval interface and an export approval interface; wherein the import, delete and export approval interfaces are each a manual or other machine processing interface for performing data approval processing; each approval interface in the embodiment of the present invention is used to receive the approval application sent by the operation approval unit 62 and send it to the corresponding manual processing end or other machine processing end for approval operation, and send the approval passed or approval failed conclusion returned by the manual processing end or other machine processing end based on each approval application as the corresponding approval result to the operation approval unit 62.

[0257] It should be noted that the operation approval configuration table 8 of the embodiment of the present invention is a logical data table item. The embodiment of the present invention can select a corresponding physical database (such as a relational database, a distributed non-relational database, etc.) for the operation approval configuration table 8 based on application requirements for physical data storage, thereby obtaining a variety of approval configuration table storage customization solutions. One of the various approval configuration table storage customization solutions that can be provided by the embodiment of the present invention is: using SQL or MySQL database to store the operation approval configuration table 8.

[0258] (IX) Compound Database 9:

[0259] The compound database 9 of the embodiment of the present invention is a logical database, and the data table items therein at least include a project index table 91, multiple compound primary attribute tables 92, and multiple compound secondary attribute tables 93. Among them, the project index table 91 is used to store multiple project index records 911; the compound primary attribute table 92 is used to store multiple compound primary attribute records 921; and the compound secondary attribute table 93 is used to store multiple compound secondary attribute records 931. The project index records 911 of the embodiment of the present invention correspond one-to-one to the compound primary attribute table 92; and the compound primary attribute records 921 of the compound primary attribute table 92 correspond one-to-one to the compound secondary attribute table 93.

[0260] Each project index record 911 of the embodiment of the present invention corresponds to a database project in the compound database 9; it should be noted that the project index record 911 corresponding to each database project in the project index table 91 can only be added once before being deleted, but can be modified multiple times.

[0261] like Figure 6 As shown in the data structure diagram of the project index record, compound primary attribute record and compound secondary attribute record provided in the embodiment of the present invention, the project index record 911 of the embodiment of the present invention at least includes an index record identifier, a project index identifier, a project member identifier set, an index record status and a primary attribute table identifier; wherein, the index record identifier is a unique record identifier of the current project index record; the project index identifier is a unique project identifier of the current database project; the project member identifier set includes one or more member user identifiers, each member user identifier corresponds to a unique identity identifier of a registered user added to the current database project; the index record status includes undeleted and deleted; the primary attribute table identifier is the unique identifier of the corresponding compound primary attribute table 92.

[0262] Each compound primary attribute table 92 of the embodiment of the present invention corresponds to a database item in the compound database 9; each compound primary attribute record 921 in each compound primary attribute table 92 corresponds to a compound in the current database item; it should be noted that the compound primary attribute record 921 corresponding to each compound in the compound primary attribute table 92 can only be added once before being deleted, but can be modified multiple times.

[0263] like Figure 6As shown, the compound primary attribute record 921 of the embodiment of the present invention at least includes a primary attribute record identifier, a SMILES sequence, a molecular chemical formula, a chemical element sequence, a first-class molecular fingerprint, a second-class molecular fingerprint, a third-class molecular fingerprint, a primary attribute set, a primary attribute record state and a secondary attribute table identifier; wherein the primary attribute record identifier is a unique record identifier of the current compound primary attribute record 921; the SMILES sequence is the SMILES sequence of the current compound; the molecular chemical formula is the chemical expression of the current compound molecule; the chemical element sequence is a collection of chemical elements of the current compound molecule, which is composed of multiple chemical elements; the first, second and third class molecular fingerprints are tors of the current compound molecule respectively. IONBV algorithm molecular fingerprint, MFP2 algorithm molecular fingerprint and FFP2 algorithm molecular fingerprint; all attributes of each compound are divided into two attribute sets: general attributes and personalized attributes, wherein the general attribute set is composed of multiple general attributes, and the first-level attribute set in the compound first-level attribute record 921 corresponding to each compound corresponds to the general attribute set of the current compound; the first-level attribute set includes multiple first-level attributes, each first-level attribute is composed of a pair of attribute name and attribute value, and each first-level attribute corresponds to a general attribute in the general attribute set of the current compound; the first-level attribute record status includes undeleted and deleted; the second-level attribute table identifier is the unique identifier of the corresponding compound second-level attribute table 93.

[0264] Each compound secondary attribute table 93 of the embodiment of the present invention corresponds to a compound in a database item in the compound database 9; all attributes of each compound are divided into two attribute sets: general attributes and personalized attributes, wherein the personalized attribute set is further subdivided into multiple secondary attribute subsets and each secondary attribute subset has a unique classification name, and each compound secondary attribute record 931 in the compound secondary attribute table 93 corresponding to each compound corresponds to an attribute update operation of a class of secondary attribute subsets of the current compound.

[0265] like Figure 6 As shown, the compound secondary attribute record 931 of the embodiment of the present invention at least includes a secondary attribute record identifier, a secondary attribute classification name, a secondary attribute set, a secondary attribute version, a secondary attribute addition time and a secondary attribute record status; wherein the secondary attribute record identifier is a unique record identifier of the current compound secondary attribute record 931; the secondary attribute classification name is the classification name of the secondary attribute subset updated at the time; the secondary attribute set is the secondary attribute subset updated at the time, consisting of multiple secondary attributes, each secondary attribute consisting of a pair of attribute name and attribute value; the secondary attribute version is the version information corresponding to the secondary attribute set; the secondary attribute addition time is the addition time of the current compound secondary attribute record 931; the secondary attribute record status includes not deleted and deleted.

[0266] It should be noted that the project index table 91, the compound primary attribute table 92, and the compound secondary attribute table 93 of the embodiment of the present invention are each a type of logical data table item, and the project index record 911, the compound primary attribute record 921, and the compound secondary attribute record 931 in each table are also each a type of logical data record. The embodiment of the present invention can select a corresponding physical database (such as a relational database, a distributed non-relational database, etc.) for the project index table 91, the compound primary attribute table 92, and the compound secondary attribute table 93 based on application requirements for physical data storage, thereby obtaining a variety of compound database storage customization solutions. One of the various compound database storage customization solutions that can be provided by the embodiment of the present invention is: using SQL or MySQL database to store the project index table 91, using PostgreSQL database to store the compound primary attribute table 92, and using MongoDB or Redis database to store the compound secondary attribute table 93.

[0267] It should also be noted that it should be understood that the division of the various modules of the above system is only a division of logical functions. In actual implementation, they can be fully or partially integrated into one physical entity, or they can be physically separated. And these modules can all be implemented in the form of software called by processing elements; they can also be all implemented in the form of hardware; some modules can also be implemented in the form of software called by processing elements, and some modules can be implemented in the form of hardware. For example, the message processing module can be a separately established processing element, or it can be integrated in a chip of the above-mentioned device. In addition, it can also be stored in the memory of the above-mentioned device in the form of program code, and called and executed by a processing element of the above-mentioned system. The implementation of other modules is similar. In addition, these modules can be fully or partially integrated together, or they can be implemented independently. The processing element described here can be an integrated circuit with signal processing capabilities. In the implementation process, each method step of the aforementioned method or each module processing step of the aforementioned system can be completed by an integrated logic circuit of hardware in the processor element or instructions in the form of software.

[0268] For example, the modules of the above system may be one or more integrated circuits configured to implement the aforementioned method, such as one or more specific integrated circuits (ASIC), or one or more digital signal processors (DSP), or one or more field programmable gate arrays (FPGA), etc. For another example, when a module of the above system is implemented in the form of a processing element scheduling program code, the processing element may be a general-purpose processor, such as a central processing unit (CPU) or other processor that can call program code. For another example, these modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).

[0269] In the above embodiments, all or part of the embodiments may be implemented by software, hardware, firmware or any combination thereof. When implemented by software, all or part of the embodiments may be implemented in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, all or part of the processes or functions described in the above method embodiments are generated. The above computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The above-mentioned computer instructions can be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the above-mentioned computer instructions can be transmitted from one website, computer, server or data center to another website, computer, server or data center through wired (such as coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (such as infrared, wireless, Bluetooth, microwave, etc.) methods. The above-mentioned computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device such as a server or data center that includes one or more available media integrated. The above-mentioned available medium can be a magnetic medium (such as a floppy disk, a hard disk, a tape), an optical medium (such as a DVD), or a semiconductor medium (such as a solid state drive (SSD)), etc.

[0270] The embodiment of the present invention provides a database access system for a compound database, the system comprising: a database service gateway, a request message queue, a feedback message queue, a message processing module, a cache message queue, a database management module, a user authority configuration table, an operation approval configuration table and a compound database; wherein the database service gateway is used to perform record addition processing on the request message queue according to the received first service request, and is also used to perform request feedback sending processing according to the feedback message queue; the message processing module is used to perform cache message addition processing on the cache message queue according to the request message queue, and is also used to perform feedback message addition processing on the feedback message queue according to the cache message queue; the user review unit of the database management module is used to perform user authority status update processing on each cache message record in the cache message queue according to the user authority configuration table, the operation approval unit is used to perform data review status update processing on each cache message record in the cache message queue according to the operation approval configuration table, and the data import The unit is used to perform data addition or update processing on the compound database according to the cache message queue, the data deletion unit is used to perform data deletion processing on the compound database according to the cache message queue, the data export unit is used to perform data export processing on the compound database according to the cache message queue, and the data query unit is used to perform data query processing on the compound database according to the cache message queue; the project index table of the compound database is used to store multiple project index records, each project index record corresponds to a database project and a compound primary attribute table, the compound primary attribute table of the compound database is used to store multiple compound primary attribute records, each compound primary attribute record corresponds to a common attribute set of a compound and a compound secondary attribute table, the compound secondary attribute table of the compound database is used to store multiple compound secondary attribute records, and the compound secondary attribute table of the compound database is updated by adding a compound secondary attribute record. The embodiment of the present invention uses the compound primary / secondary attribute table to distinguish the storage space of the common attributes and individual attributes of the compound, and distinguishes the storage space of each compound individual attribute through the compound secondary attribute table, thereby avoiding the problem of redundant field waste caused by the conventional full attribute recording method, reducing the storage resource waste rate, and improving the overall task processing performance of the database.

[0271] The professionals should further realize that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented by electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0272] The steps of the method or algorithm described in conjunction with the embodiments disclosed herein may be implemented using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0273] The specific implementation methods described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific implementation method of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A database access system for a compound database, characterized in that: The system includes: a database service gateway, a request message queue, a feedback message queue, a message processing module, a cache message queue, a database management module, a user authority configuration table, an operation approval configuration table and a compound database; The database service gateway is connected to the request message queue and the feedback message queue respectively; the message processing module is connected to the request message queue, the feedback message queue and the cache message queue respectively; the database management module is connected to the cache message queue, the user authority configuration table, the operation approval configuration table and the compound database respectively; The database service gateway is used to receive a first service request, and perform a record adding process on the request message queue according to the first service request; the database service gateway is also used to perform a request feedback sending process according to the feedback message queue; The request message queue is used to store multiple request message records; The feedback message queue is used to store multiple feedback message records; The message processing module is used to perform a cache message adding process on the cache message queue according to the request message queue; the message processing module is also used to perform a feedback message adding process on the feedback message queue according to the cache message queue; The cache message queue is used to store multiple cache message records; The database management module includes a user review unit, an operation approval unit, a data import unit, a data deletion unit, a data export unit and a data query unit; the user review unit is used to update the user authority status of each cache message record in the cache message queue according to the user authority configuration table; the operation approval unit is used to update the data review status of each cache message record in the cache message queue according to the operation approval configuration table; the data import unit is used to add or update data to the compound database according to the cache message queue; the data deletion unit is used to delete data from the compound database according to the cache message queue; the data export unit is used to export data from the compound database according to the cache message queue; the data query unit is used to query data from the compound database according to the cache message queue; The user authority configuration table is used to store multiple user authority configuration records; The operation approval configuration table is used to store multiple operation approval configuration records; The compound database includes a project index table, multiple compound primary attribute tables and multiple compound secondary attribute tables; the project index table is used to store multiple project index records; the compound primary attribute table is used to store multiple compound primary attribute records; the compound secondary attribute table is used to store multiple compound secondary attribute records; the project index records correspond one-to-one to the compound primary attribute table; the compound primary attribute records correspond one-to-one to the compound secondary attribute table.

2. The database access system for a compound database according to claim 1, characterized in that: The first service request includes a first message identifier, a first message source address, a first message header and a first message body; the first message identifier is a unique message identifier of the current service request; the first message source address is an address of a sender of the current service request; the first message header includes a first user identifier, a first user token, a first project identifier and a first instruction type; The first user identifier is a unique identifier of the initiating user of the current service request, the first user token is the identity token information for the current user, and the first project identifier is a database project identifier corresponding to the database data to be operated by the current service request; the first instruction type includes import, delete, export and query; the first message body includes a first instruction parameter; the first instruction parameter is a CSV file; Each of the request message records corresponds to one of the first service requests; the request message record includes at least a request message identifier, a request message source address, a request message header, a request message body, and a request message status; The request message identifier, the request message source address, the request message header and the request message body are the corresponding first message identifier, the first message source address, the first message header and the first message body respectively; the request message status includes unprocessed and processed; Each feedback message record corresponds to one request message record; the feedback message record at least includes a feedback message identifier, a feedback message target address, a feedback message header, a feedback message body and a feedback message status: the feedback message identifier matches the corresponding request message identifier; the feedback message target address matches the corresponding request message source address; the feedback message header includes a second user identifier, a second project identifier, a second instruction type and a first instruction execution status; the second user identifier, the second project identifier and the second instruction type respectively match the corresponding first user identifier, the first project identifier and the first instruction type; the second instruction type includes import, delete, export and query; the first instruction execution status includes success and exception; the feedback message body includes first feedback data; the first feedback data is a compressed package file with one or more CSV files; the feedback message status includes unprocessed and processed; Each of the cached message records corresponds to one of the request message records; The cache message record at least includes a request message identifier, a request source address, a request user identifier, a request user token, a request project identifier, a request instruction type, a request instruction parameter, a user authority status, a data review status, a request feedback data and a request message status: the request message identifier, the request source address, the request user identifier, the request user token, the request project identifier, the request instruction type and the request instruction parameter respectively match the corresponding first message identifier, the first message source address, the first user identifier, the first user token, the first project identifier, the first instruction type and the first instruction parameter; the request instruction type includes import, delete, export and query; the user authority status and the data review status both include unreviewed, unsatisfied and satisfied; the request message status includes unprocessed, under review, in process, feedback received and processed; The user authority configuration record at least includes an authority configuration record identifier, a registered user identifier, a registered user type, a registered user token, a token validity period and a registration project identifier set; the authority configuration record identifier is a unique record identifier corresponding to the current user authority configuration record; each of the user authority configuration records corresponds to a registered user, and the registered user identifier is a unique identity identifier of the current registered user; the registered user type includes an administrator type and multiple non-administrator types; the registered user token is the identity token information pre-assigned to the current registered user, and the token validity period is the validity period information of the current token; the registration project identifier set is composed of one or more registration project identifiers when it is not empty; each registered user can be added to one or more database projects, and each of the registration project identifiers in the registration project identifier set is a project identifier of a database project where the current registered user is located; The operation approval configuration record at least includes an approval configuration record identifier, an approval project identifier, an approval configuration set and an approval interface set; the approval configuration record identifier is a unique record identifier corresponding to the current operation approval configuration record; each of the operation approval configuration records corresponds to a database project that requires data approval, and the approval project identifier is a unique project identifier of the current database project; the approval configuration set consists of one or more approval configurations; each of the approval configurations is used to set whether three types of operations corresponding to a type of user need approval, and each of the approval configurations consists of an approval user type, an import configuration bit, a delete configuration bit and an export configuration bit; the approval user type includes an administrator type and all non-administrator types; the values ​​of the import, delete and export configuration bits include 0 and 1, and when the import, delete or export configuration bit is 0, it means that the current user type is in No approval is required when processing data import, deletion or export operations in the current database project. When the import, deletion or export configuration bit is 1, it indicates that the current user type needs approval when processing data import, deletion or export operations in the current database project; at least one of the import, deletion and export configuration bits of the approval configuration is 1; the approval interface set includes an import approval interface, a deletion approval interface and an export approval interface; the import, deletion and export approval interfaces are each a manual or other machine processing interface for data approval processing, and each approval interface is used to receive the approval application sent by the operation approval unit and send it to the corresponding manual processing end or other machine processing end for approval operation, and send the approval passed or approval failed conclusion returned by the manual processing end or other machine processing end based on each approval application as the corresponding approval result to the operation approval unit; Each of the project index records in the project index table corresponds to a database item in the compound database; the project index records corresponding to each database item in the project index table can only be added once before being deleted, but can be modified multiple times; the project index record includes at least an index record identifier, a project index identifier, a project member identifier set, an index record status, and a primary attribute table identifier; the index record identifier is a unique record identifier for the current project index record; the project index identifier is a unique project identifier for the current database item; The project member identification set includes one or more member user identifications, each of which corresponds to a unique identification of a registered user added to the current database project; the index record status includes undeleted and deleted; the primary attribute table identification is the unique identification of the corresponding primary attribute table of the compound; Each of the compound primary attribute tables corresponds to a database item in the compound database; each of the compound primary attribute records in each of the compound primary attribute tables corresponds to a compound in the current database item; The compound primary attribute record corresponding to each compound in the compound primary attribute table can only be added once before being deleted, but can be modified multiple times; the compound primary attribute record at least includes a primary attribute record identifier, a SMILES sequence, a molecular chemical formula, a chemical element sequence, a first-class molecular fingerprint, a second-class molecular fingerprint, a third-class molecular fingerprint, a primary attribute set, a primary attribute record status, and a secondary attribute table identifier; The primary attribute record identifier is the unique record identifier of the primary attribute record of the current compound; the SMILES sequence is the SMILES sequence of the current compound; The molecular chemical formula is the chemical expression of the current compound molecule; the chemical element sequence is the chemical element collection of the current compound molecule, which is composed of multiple chemical elements; the first, second and third types of molecular fingerprints are respectively the TorsionBV algorithm molecular fingerprint, the MFP2 algorithm molecular fingerprint and the FFP2 algorithm molecular fingerprint of the current compound molecule; all the attributes of each compound are divided into two attribute sets: general attributes and personalized attributes, wherein the general attribute set is composed of multiple general attributes, and the first-level attribute set in the compound first-level attribute record corresponding to each compound corresponds to the general attribute set of the current compound; the first-level attribute set includes multiple first-level attributes, each of which is composed of a pair of attribute name and attribute value, and each of which corresponds to a general attribute in the general attribute set of the current compound; the first-level attribute record status includes undeleted and deleted; The secondary attribute table identifier is a unique identifier of the corresponding secondary attribute table of the compound; Each of the compound secondary attribute tables corresponds to a compound in a database item in the compound database; all attributes of each compound are divided into two attribute sets: general attributes and personalized attributes, wherein the personalized attribute set is further subdivided into multiple secondary attribute subsets and each secondary attribute subset has a unique classification name, and each of the compound secondary attribute records in the compound secondary attribute table corresponding to each compound corresponds to an attribute update operation of a class of secondary attribute subsets of the current compound; The compound secondary attribute record at least includes a secondary attribute record identifier, a secondary attribute classification name, a secondary attribute set, a secondary attribute version, a secondary attribute addition time, and a secondary attribute record status; The secondary attribute record identifier is a unique record identifier of the secondary attribute record of the current compound; The secondary attribute classification name is the classification name of the secondary attribute subset updated at that time; The secondary attribute set is a secondary attribute subset updated at the time, and is composed of multiple secondary attributes, each of which is composed of a pair of attribute name and attribute value; the secondary attribute version is the version information corresponding to the secondary attribute set; The secondary attribute adding time is the adding time of the secondary attribute record of the current compound; The secondary attribute record status includes undeleted and deleted.

3. The database access system for a compound database according to claim 2, characterized in that: The database business gateway is specifically used to parse the corresponding first message identifier, the first message source address, the first message header and the first message body from the first business request as the corresponding current message identifier, current message source address, current message header and current message body based on the preset request message parsing rules when performing record addition processing on the request message queue according to the first business request; and add a new request message record in the request message queue as the corresponding current newly added record; and set the request message identifier, the request message source address, the request message header and the request message body of the currently newly added record to the corresponding current message identifier, the current message source address, the current message header and the current message body; and set the request message status of the currently newly added record to unprocessed.

4. The database access system for a compound database according to claim 2, characterized in that: The database service gateway is specifically used for recording all the feedback message records whose feedback message status is unprocessed in the feedback message queue as unprocessed records when performing the request feedback sending processing according to the feedback message queue, and taking the unprocessed record with the earliest time as the corresponding current record; and when the current record is not empty, performing corresponding feedback message encapsulation processing according to the feedback message identifier, the feedback message target address, the feedback message header and the feedback message body of the current feedback message record according to the preset feedback message encapsulation rule to obtain the corresponding current feedback message; and sending the current feedback message to the feedback message target address of the current feedback message record; and resetting the feedback message status of the current record to processed after the message is successfully sent.

5. The database access system for a compound database according to claim 2, characterized in that: The message processing module is specifically used for performing a cache message adding process on the cache message queue according to the request message queue. Recording all the request message records whose request message status is unprocessed in the request message queue as unprocessed records, and taking the earliest unprocessed record as the corresponding current request message record; and when the current request message record is not empty, extracting the request message identifier, the request message source address, the request message header and the request message body of the current request message record as the corresponding current message identifier, the current message source address, the current message header and the current message body; and extracting the first user identifier, the first user token, the first project identifier and the first instruction type of the current message header and the first instruction parameter of the current message body as the corresponding current user identifier, current user token, current project identifier, current instruction type and current instruction parameter; and adding a new cached message record in the cached message queue as the corresponding current cached message record; and setting the request message identifier, the request source address, the request user identifier, the request user token, the request project identifier, the request instruction type and the request instruction parameter of the current cache message record to the corresponding current message identifier, the current message source address, the current user identifier, the current user token, the current project identifier, the current instruction type and the current instruction parameter; The user authority status and the data review status of the current cache message record are both set to unreviewed; the request feedback data of the current cache message record is set to empty; and the request message status of the current cache message record is set to unprocessed; And when the setting of the current cache message record is completed, the request message status of the current request message record is reset to processed.

6. The database access system for a compound database according to claim 2, characterized in that: The message processing module is specifically used for performing feedback message adding processing on the feedback message queue according to the cache message queue. Recording all cached message records in the cached message queue whose request message status is "fed back" as fed back records, and taking the earliest fed back record as the corresponding current cached message record; and when the current cache message record is not empty, identifying whether the user authority status and the data audit status of the current cache message record are both satisfied, if so, setting the corresponding current instruction execution status to success, otherwise setting the corresponding current instruction execution status to abnormal; and taking the request message identifier and the request source address of the current cache message record as the corresponding feedback message identifier and the feedback message target address; and taking the request user identifier, the request project identifier, the request instruction type and the current instruction execution status corresponding to the current cache message record as the corresponding second user identifier, the second project identifier, the second instruction type and the first instruction execution status to form the corresponding feedback message header; and taking the request feedback data of the current cache message record as the corresponding first instruction feedback data to form the corresponding feedback message body; and setting a corresponding feedback message status to unprocessed; The obtained feedback message identifier, the feedback message target address, the feedback message header, the feedback message body and the feedback message status form a corresponding feedback message record and add it to the feedback message queue; After the feedback message record is successfully added, the request message status of the current cache message record is set to processed.

7. The database access system for a compound database according to claim 2, characterized in that: The user audit unit is specifically configured to, when performing user authority status update processing on each cache message record in the cache message queue according to the user authority configuration table, Recording all cached message records in the cached message queue whose request message status is unprocessed as unprocessed records, and taking the earliest unprocessed record as the corresponding current unprocessed record; and taking the requesting user identifier, the requesting user token and the requesting project identifier of the currently unprocessed record as the corresponding current user identifier, current user token and current project identifier; And use the current time as the corresponding current token time; and taking the user authority configuration record in the user authority configuration table in which the registered user identifier matches the current user identifier, the registered user token matches the current user token, and the token validity period meets the current token time as the corresponding current user authority configuration record; and identifying whether the current user authority configuration record is empty; If the current user authority configuration record is empty, the user authority status and the data review status of the current unprocessed record are both set to unsatisfied, and the request message status of the current unprocessed record is set to fed back; If the current user authority configuration record is not empty, it is confirmed whether there is a registration project identifier matching the current project identifier in the registration project identifier set of the current user authority configuration record; if it is confirmed that it exists, the user authority status of the current unprocessed record is set to satisfied, and the request message status of the current unprocessed record is set to under review; if it is confirmed that it does not exist, the user authority status and the data review status of the current unprocessed record are both set to unsatisfied, and the request message status of the current unprocessed record is set to received feedback.

8. The database access system for a compound database according to claim 2, characterized in that: The operation approval unit is specifically configured to, when performing data review status update processing on each cache message record in the cache message queue according to the operation approval configuration table, All cached message records in the cached message queue whose request message status is under review are recorded as under review records, and the earliest under review record is used as the corresponding current under review record; and the request user identifier, the request project identifier, the request instruction type and the request instruction parameters of the current under review record are used as the corresponding current user identifier, current project identifier, current instruction type and current instruction parameters; and taking the registered user type of the user authority configuration record in which the registered user identifier in the user authority configuration table matches the current user identifier as the corresponding current user type; and taking the operation approval configuration record in the operation approval configuration table whose approval project identifier matches the current project identifier as the corresponding current operation approval configuration record; and identifying whether the current operation approval configuration record is empty; If the current operation approval configuration record is empty, the data review status recorded in the current review is set to satisfied, and the request message status recorded in the current review is set to being processed; If the current operation approval configuration record is not empty, taking the approval configuration whose approval user type matches the current user type in the approval configuration set of the current operation approval configuration record as the corresponding current approval configuration, and identifying whether the current approval configuration is empty; If the current approval configuration is empty, the data review status recorded in the current review is set to satisfied, and the request message status recorded in the current review is set to being processed; If the current approval configuration is not empty, confirm whether there is a configuration bit corresponding to the current instruction type in the import, delete and export configuration bits of the current approval configuration; if there is or not, set the data review status recorded in the current review to satisfied, and set the request message status recorded in the current review to processing; if it is confirmed to exist, set the configuration bit corresponding to the current instruction type in the import, delete and export configuration bits of the current approval configuration as the corresponding current configuration bit, and identify the current configuration bit; If the current configuration bit is 0, the data audit status recorded in the current audit is set to satisfied, and the request message status recorded in the current audit is set to processing; If the current configuration bit is 1, the approval interface corresponding to the current instruction type in the import, delete and export approval interfaces of the approval interface set of the current operation approval configuration record is used as the corresponding current approval interface; A unique timestamp is generated based on the current time as the corresponding first application identifier, and the first application identifier and the current user identifier, the current project identifier, the current instruction type, and the current instruction parameters form a corresponding first approval application and send it to the current approval interface; and after successful sending, the request message identifier recorded in the current review is used as the corresponding first message identifier, and the first application identifier and the first message identifier form a corresponding first approval record and save it; and after the approval record is successfully saved, the request message status recorded in the current review is set to being processed.

9. The database access system for a compound database according to claim 8, characterized in that: The operation approval unit is further configured to, when receiving a corresponding first approval result from any approval interface, use the first approval result currently received as the corresponding current approval result; And among all the first approval records saved, the first approval record whose first application identifier matches the second application identifier of the current approval result is used as the corresponding current approval record; and the cached message record whose request message identifier in the cached message queue matches the first message identifier of the current approval record is used as the corresponding current message record; and the first approval feedback of the current approval result is used as the corresponding current approval feedback; and the current approval feedback is identified; if the current approval feedback is approval passed, the data review status of the current message record is set to satisfied; if the current approval feedback is approval failed, the data review status of the current message record is set to unsatisfied, and the request message status of the current message record is set to feedback received; wherein, the first approval result includes the second application identifier and the first approval feedback; and the first approval feedback includes approval passed and approval failed.

10. The database access system for a compound database according to claim 2, characterized in that: When the first instruction type of the first service request is import, delete, export and query, the CSV file corresponding to the first instruction parameter is recorded as the corresponding import instruction file, delete instruction file, export instruction file and query instruction file; The first line of the import, delete, export and query instruction files are all column field lines, and the second to last lines are data lines; Each data row corresponds to one import, delete, export and query operation; The field formats of the column field rows of the import, delete, export and query instruction files meet the corresponding import file field format requirements, delete file field format requirements, export file field format requirements and query file field format requirements; The column fields required by the import file field format are composed of import classification fields, group member fields, SMILES fields, chemical formula fields, element sequence fields, first-class fingerprint fields, second-class fingerprint fields, third-class fingerprint fields, first-class attribute fields, second-class attribute classification fields, second-class attribute fields and version fields; the import classification fields include project creation, first-class attribute import and second-class attribute import; When the import classification field is a project creation, the member field is a project member identification set, which is composed of one or more user identifications of registered users; the SMILES field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field, the first level attribute field, the second level attribute classification field, the second level attribute field and the version field are all empty; When the imported classification field is a primary attribute import, the group member field, the secondary attribute classification field, the secondary attribute field and the version field are all empty; the SMILES field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field and the primary attribute field correspond to the SMILES sequence, molecular chemical formula, chemical element sequence, first type molecular fingerprint, second type molecular fingerprint, third type molecular fingerprint and primary attribute set respectively; When the import classification field is a secondary attribute import, the member field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field and the first type attribute field are empty; the SMILES field, the second type attribute classification field, the second type attribute field and the version field are the corresponding SMILES sequence, the second type attribute classification name, the second type attribute set and the second type attribute version respectively; The column fields required by the deletion file field format are composed of a deletion classification field, a deletion SMILES field, a deletion attribute field, and a deletion version field; the deletion classification field includes project deletion, compound deletion, and attribute deletion; When the deletion classification field is item deletion, the deletion SMILES field, the deletion attribute field and the deletion version field are all empty; When the deletion classification field is compound deletion, the deletion SMILES field is a corresponding SMILES sequence; the deletion attribute field and the deletion version field are both empty; When the deletion classification field is attribute deletion, the deletion SMILES field is a corresponding SMILES sequence; the deletion attribute field is empty or a corresponding secondary attribute classification name; the deletion version field is empty or a secondary attribute version; the deletion attribute field and the deletion version field cannot be empty at the same time; The column fields required by the export file field format are composed of export classification fields and export SMILES fields; the export classification fields include project export and compound export; When the export classification field is project export, the export SMILES field is empty; When the exported classification field is a compound export, the exported SMILES field is a corresponding SMILES sequence; The column fields required by the query file field format are composed of a query classification field, a SMILES configuration field, a chemical element configuration field and a similarity configuration field; the query classification field includes a SMILES-based query and a chemical element-based query; When the query classification field item is exported as a SMILES-based query, the SMILES configuration field is a corresponding SMILES sequence, the chemical element configuration field is empty, and the similarity configuration field is empty or a similarity; when the query classification field item is exported as a chemical element-based query, the SMILES configuration field and the similarity configuration field are empty, and the chemical element configuration field is a chemical element sequence.

11. The database access system for a compound database according to claim 10, characterized in that: The data import unit is specifically used for adding or updating data to the compound database according to the cache message queue. Recording all cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in process, and whose request instruction type is import as import operation records, and taking the earliest import operation record as the corresponding current import operation record; and taking the requested project identifier of the current import operation record as the corresponding current project identifier; and taking the CSV file of the request instruction parameters of the current import operation record as the corresponding current import instruction file; and extracting the data rows formatted from the current import instruction file based on the import file field format requirements to obtain a corresponding first data row sequence; the first data row sequence is formed by sequentially sorting one or more first data rows; And all the first data rows of the first data row sequence are traversed in sequence; and in the traversal process, the first data row currently traversed is used as the corresponding current data row; and the sequence index of the current data row in the first data row sequence is extracted as the corresponding first processing index; and the import classification field of the current data row is extracted as the corresponding current import classification; and the current import classification is identified; if the current import classification is project creation, then based on the current project identifier and the member field of the current data row, a corresponding database project creation or update process is performed in the compound database to obtain a corresponding first processing result; If the current import classification is a primary attribute import, then based on the current project identifier and the SMILES field, the chemical formula field, the element sequence field, the first type fingerprint field, the second type fingerprint field, the third type fingerprint field and the primary attribute field of the current data row, a corresponding compound primary attribute addition or update process is performed in the compound database to obtain the corresponding first processing result; If the current import classification is secondary attribute import, then based on the current project identifier and the SMILES field, the secondary attribute classification field, the secondary attribute field and the version field of the current data row, the corresponding compound secondary attribute is added in the compound database to obtain the corresponding first processing result; The obtained first processing index and the first processing result form a corresponding first processing feedback; At the end of the traversal, all the first processing feedbacks obtained form a corresponding first processing feedback sequence; the first processing results include success and failure; and bringing the first processing feedback sequence into a preset type of feedback CSV file template to perform corresponding CSV file assembly to obtain a corresponding first feedback CSV file; and compressing the first feedback CSV file based on a preset file compression package tool to obtain a corresponding first compressed package file; And based on the first compressed package file, the request feedback data of the current import operation record is set; and the request message status of the current import operation record is set to have been fed back.

12. The database access system for a compound database according to claim 10, characterized in that: The data deletion unit is specifically used for, when performing data deletion processing on the compound database according to the cache message queue, Recording all cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in process, and whose request instruction type is delete as deletion operation records, and taking the earliest deletion operation record as the corresponding current deletion operation record; and taking the request item identifier of the current deletion operation record as the corresponding current item identifier; and taking the CSV file of the request instruction parameters of the current deletion operation record as the corresponding current deletion instruction file; and extracting the data rows formatted from the current deletion instruction file based on the deletion file field format requirement to obtain a corresponding second data row sequence; the second data row sequence is formed by sequentially sorting one or more second data rows; and sequentially traverse all the second data rows of the second data row sequence; and in the traversal process, use the second data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the second data row sequence as the corresponding second processing index; and extract the deletion classification field of the current data row as the corresponding current deletion classification; and identify the current deletion classification; If the current deletion classification is item deletion, performing a corresponding database item deletion process in the compound database based on the current item identifier to obtain a corresponding second processing result; If the current deletion classification is compound deletion, then performing corresponding compound deletion processing in the compound database based on the current project identifier and the deleted SMILES field of the current data row to obtain the corresponding second processing result; If the current deletion is classified as attribute deletion, then performing corresponding compound attribute deletion processing in the compound database based on the current project identifier and the deleted SMILES field, the deleted attribute field and the deleted version field of the current data row to obtain the corresponding second processing result; and forming a corresponding second processing feedback by using the obtained second processing index and the second processing result; At the end of the traversal, all the obtained second processing feedbacks form a corresponding second processing feedback sequence; the second processing results include success and failure; and bringing the second processing feedback sequence into a preset type of feedback CSV file template to perform corresponding CSV file assembly to obtain a corresponding second feedback CSV file; and compressing the second feedback CSV file based on a preset file compression package tool to obtain a corresponding second compressed package file; And based on the second compressed package file, the request feedback data of the current deletion operation record is set; and the request message status of the current deletion operation record is set to have been fed back.

13. The database access system for a compound database according to claim 10, characterized in that: The data export unit is specifically used for, when the data export processing is performed on the compound database according to the cache message queue, Recording all cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in processing, and whose request instruction type is export as export operation records, and taking the earliest export operation record as the corresponding current export operation record; and taking the requested project identifier of the current export operation record as the corresponding current project identifier; and taking the CSV file of the request instruction parameters of the current export operation record as the corresponding current export instruction file; and extracting the data rows formatted from the current export instruction file based on the export file field format requirement to obtain a corresponding third data row sequence; the third data row sequence is formed by sequentially sorting one or more third data rows; and sequentially traverse all the third data rows of the third data row sequence; and in the traversal process, take the third data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the third data row sequence as the corresponding third processing index; and extract the export classification field of the current data row as the corresponding current export classification; and identify the current export classification; If the current export classification is project export, then based on the current project identifier, a corresponding database project export process is performed in the compound database to obtain a corresponding third processing result, and the third processing result and the corresponding third processing index are brought into a preset second-category feedback CSV file template to perform a corresponding CSV file assembly to obtain a corresponding third feedback CSV file; If the current export classification is compound export, then based on the current project identifier and the export SMILES field of the current data row, the corresponding compound export processing is performed in the compound database to obtain the corresponding third processing result, and the third processing result and the corresponding third processing index are brought into the preset three-category feedback CSV file template to perform corresponding CSV file assembly to obtain the corresponding third feedback CSV file; At the end of the traversal, all the obtained third feedback CSV files are saved in the same file directory, and the current file directory is compressed based on a preset file compression package tool to obtain a corresponding third compressed package file; And based on the third compressed package file, the request feedback data of the current export operation record is set; and the request message status of the current export operation record is set to have been fed back.

14. The database access system for a compound database according to claim 10, characterized in that: The data query unit is specifically used for performing data query processing on the compound database according to the cache message queue. Recording all cached message records in the cached message queue whose user authority status and data audit status are both satisfied, whose request message status is in process, and whose request instruction type is query as query operation records, and taking the earliest query operation record as the corresponding current query operation record; and taking the request item identifier of the current query operation record as the corresponding current item identifier; and taking the CSV file of the request instruction parameters of the current query operation record as the corresponding current query instruction file; and extracting the data rows formatted from the current query instruction file based on the query file field format requirement to obtain a corresponding fourth data row sequence; the fourth data row sequence is formed by sequentially sorting one or more fourth data rows; and sequentially traverse all the fourth data rows of the fourth data row sequence; and in the traversal process, take the fourth data row currently traversed as the corresponding current data row; and extract the sequence index of the current data row in the fourth data row sequence as the corresponding fourth processing index; and extract the query classification field of the current data row as the corresponding current query classification; and identify the current query classification; If the current query classification is based on SMILES query, then based on the current project identifier and the SMILES configuration field and the similarity configuration field of the current data row, the corresponding compound query processing is performed on the compound database to obtain a corresponding fourth processing result, and the fourth processing result and the corresponding fourth processing index are brought into the preset four-category feedback CSV file template for corresponding CSV file assembly to obtain a corresponding fourth feedback CSV file; If the current export classification is based on chemical element query, then based on the current project identifier and the chemical element configuration field of the current data row, the corresponding compound query processing is performed on the compound database to obtain the corresponding fourth processing result, and the fourth processing result and the corresponding fourth processing index are brought into the preset five-category feedback CSV file template to perform corresponding CSV file assembly to obtain the corresponding fourth feedback CSV file; At the end of the traversal, all the fourth feedback CSV files are saved in the same file directory, and the current file directory is compressed based on a preset file compression package tool to obtain a corresponding fourth compressed package file; and The request feedback data of the current query operation record is set based on the fourth compressed package file; and the request message status of the current query operation record is set to have been fed back.

Images