A method and system for directly processing data flowing from pharmaceutical companies

Abstract

The present invention relates to the field of information technology, and specifically discloses a method and system for processing direct connection of data for pharmaceutical enterprises, wherein the method comprises: S10, receiving an instruction, and obtaining an execution list, direct connection rules, and data retrieval rules for data direct connection according to the instruction; S20, connecting to a corresponding system according to the direct connection rules, and obtaining implementation data from the system according to the execution list and data retrieval rules; S30, performing warehousing processing on the implementation data according to a Rolling function to obtain warehousing data; S40, performing version division on the warehousing data according to delivery requirements to obtain multiple version data; S50, delivering the specified version data according to the received delivery version instruction; S60, receiving an appeal request, and sending the appeal request to an administrator for the administrator to review the appeal request; S70, when the appeal request is reviewed and approved, extracting the appeal list, appeal direct connection rules, and appeal data retrieval rules in the appeal request; S80, reacquiring the implementation data, and executing S30-S50 again.

Description

Technical Field

[0001] The present invention relates to the field of information technology, and in particular to a method and system for directly processing data flowing to a pharmaceutical company. Background Art

[0002] DDI is the abbreviation of Distributors Data Integration, which means automatic collection of channel data. By installing data capture and transmission software on the dealer's PC, the scheduled automatic transmission of data can be achieved.

[0003] Currently, there are two popular methods of direct data connection in the market. One is to process data manually, but the manual data processing speed is slow and the processing cost is high. The other is to process data in a fully automated way, but the fully automated way is difficult to maintain data quality when collecting data. Summary of the Invention

[0004] In response to the above problems, the purpose of the present invention is to provide a method and system for directly processing data flowing from pharmaceutical companies, so as to improve data processing speed, reduce data processing costs and ensure data quality.

[0005] An embodiment of the present invention provides a method for directly processing data flowing to a pharmaceutical company, including:

[0006] Step S10: receiving a user input instruction and obtaining an execution list, direct connection rules, and data retrieval rules for direct data connection according to the instruction; the direct connection rules are used to specify the method for each pharmaceutical company to establish a connection with the current server, and the execution list includes the names of each pharmaceutical company used for direct data connection and the system corresponding to each pharmaceutical company, wherein the system is a database management system;

[0007] Step S20, connecting to the corresponding system according to the direct connection rule, and obtaining implementation data from the system according to the execution list and data retrieval rules;

[0008] Step S30, performing storage processing on the implementation data according to the Rolling function to obtain storage data;

[0009] Step S40: dividing the stored data into versions according to the delivery requirements to obtain multiple versions of data;

[0010] Step S50: delivering the specified version data according to the received delivery version instruction;

[0011] Step S60: receiving the appeal request submitted by the user and sending the appeal request to the administrator for the administrator to review the appeal request;

[0012] Step S70: When the appeal request is approved, extract the appeal list, appeal direct connection rules, and appeal data retrieval rules in the appeal request;

[0013] Step S80: reacquire the implementation data according to the complaint list, the complaint direct connection rule and the complaint data acquisition rule, and execute S30-S50 again.

[0014] In a possible implementation, the method further includes step S90:

[0015] Receive query conditions provided by a user, wherein the query conditions include information about a target system to be queried and target implementation data;

[0016] Obtain the number of databases and data tables of the target system;

[0017] When the number of databases and the number of data tables are both 1, search the data table of the target system according to the information of the target implementation data, and output and display the found query data;

[0018] When the number of databases is 1 and the number of data tables is greater than 1, determining a first target data table storing the target implementation data among the multiple data tables to be queried according to the query condition; searching the first target data table according to the information of the target implementation data, and outputting and displaying the found query data;

[0019] When the number of databases and the number of data tables are both greater than 1, the target database and the second target data table storing the target implementation data are determined according to the query conditions, the second target data table in the target database is searched according to the information of the target implementation data, and the found query data is output and displayed.

[0020] In a possible implementation, the S20 includes:

[0021] Determining the amount of implementation data to be transmitted based on the execution list and the data retrieval rules;

[0022] When the amount of the implementation data is less than or equal to the preset amount, obtaining the implementation data from the system according to the execution list and the data retrieval rule;

[0023] When the data volume of the implementation data is greater than the preset data volume, the implementation data is divided according to the preset data volume to obtain multiple batches of implementation data.

[0024] In a possible implementation, the user instruction includes a screening condition, an import instruction, and a selection instruction; and S10 includes:

[0025] Obtaining screening results from a preset project process list according to the screening conditions;

[0026] Determining the execution list from the screening results according to the import instruction;

[0027] The direct connection rule and the data retrieval rule are determined according to the selection instruction and the execution list.

[0028] In a possible implementation, the S20 further includes:

[0029] Encrypting the execution list and the data retrieval rule to obtain encrypted information, and sending the encrypted information to the system;

[0030] Acquire implementation data from the system according to the execution list and data retrieval rules;

[0031] The implementation data is encrypted to obtain encrypted implementation data.

[0032] In a possible implementation, the S30 further includes:

[0033] determining whether the implementation data is within a preset period, and when the implementation data is within the preset period, storing the implementation data in a database according to the Rolling function to obtain stored data;

[0034] When the implementation data is not within a preset period, a deposition process is performed on the implementation data to obtain deposition data.

[0035] In a possible implementation, the S30 further includes:

[0036] Determine a storage database and a storage data table for the implementation data according to the execution list and / or the implementation data;

[0037] The implementation data is stored in the storage data table in the storage database according to the Rolling function to obtain storage data.

[0038] In a possible implementation, the S20 further includes:

[0039] When the implementation data is not received within a preset time period, the system is reconnected according to the direct connection rule, or the implementation data is reacquired from the system according to the execution list and data retrieval rule.

[0040] In a possible implementation, the S20 further includes:

[0041] The channel connecting the systems through the direct connection rule is encrypted.

[0042] An embodiment of the present invention further provides a pharmaceutical enterprise data direct connection processing system for executing any of the above-mentioned data direct connection processing methods, including:

[0043] an acquisition module for receiving a user input instruction and acquiring an execution list, direct connection rules, and data retrieval rules for direct data connection according to the instruction; the direct connection rules are used to specify the method for each pharmaceutical company to establish a connection with the current server; the execution list includes the names of each pharmaceutical company used for direct data connection and the system corresponding to each pharmaceutical company, wherein the system is a database management system;

[0044] A direct connection module, configured to connect to a corresponding system according to the direct connection rule, and obtain implementation data from the system according to the execution list and data retrieval rules;

[0045] The storage module is used to perform storage processing on the implementation data according to the Rolling function to obtain storage data;

[0046] A version module is used to divide the stored data into versions according to the delivery requirements to obtain multiple versions of data;

[0047] The delivery module is used to deliver the specified version data according to the received delivery version instruction;

[0048] A receiving module is used to receive a complaint request submitted by a user and send the complaint request to an administrator for the administrator to review the complaint request;

[0049] An extraction module, configured to extract the appeal list, appeal direct connection rules, and appeal data retrieval rules from the appeal request when the appeal request is approved;

[0050] The re-acquisition module is used to re-acquire the implementation data according to the complaint list, the complaint direct connection rule and the complaint data acquisition rule.

[0051] The method and system for directly processing pharmaceutical enterprise data provided by the present invention can improve data processing speed, reduce data processing costs, and ensure data quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0052] Figure 1 A schematic diagram of a flow chart of a data direct connection method provided in an embodiment of the present invention;

[0053] Figure 2 A schematic diagram of the structure of a data direct connection system provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0054] The following detailed description of the embodiments of the present invention is provided in conjunction with the accompanying drawings and examples. The following detailed description of the embodiments and the accompanying drawings are intended to illustrate the principles of the present invention, but are not intended to limit the scope of the present invention. That is, the present invention is not limited to the preferred embodiments described, and the scope of the present invention is defined by the claims.

[0055] In the description of the present invention, it should be noted that, unless otherwise specified, “plurality” means two or more; the terms “first”, “second”, etc. are used for descriptive purposes only and cannot be understood as indicating or implying relative importance; for ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to the specific circumstances.

[0056] Figure 1 A flow chart of a data direct connection method provided by an embodiment of the present invention is shown in FIG. Figure 1 As shown, an embodiment of the present invention provides a data direct connection processing method, including:

[0057] Step S10: receiving a user input instruction, and obtaining an execution list, direct connection rules, and data retrieval rules for data direct connection according to the instruction;

[0058] The direct connection rule is used to specify how each pharmaceutical company establishes a connection with the current server. The execution list includes the names of each pharmaceutical company used for direct data connection and the system corresponding to each pharmaceutical company, which is a database management system.

[0059] In a possible implementation, the user instruction includes a screening condition, an import instruction, and a selection instruction. The screening condition includes at least one of the following: project English abbreviation, project English abbreviation, project status, remarks, time, etc.

[0060] Get the screening results from the preset project process list based on the screening conditions. The project process list stores multiple different projects, each of which has at least one corresponding enterprise, and each enterprise has a corresponding system.

[0061] Based on the import instructions, the execution list is determined from the screening results. The screening results are the query results that meet the screening conditions, not necessarily the actual information needed. Therefore, a secondary screening of the screening results based on the import instructions is required to determine the execution list. The execution list should at least include the companies and projects that need to be connected.

[0062] Determine direct connection rules and data retrieval rules based on selection instructions and execution lists.

[0063] The selection command allows the user to select the system corresponding to multiple enterprises or projects in the execution list. The execution subject of this invention is the server. The direct connection rule is the current connection method between the server and the system. The data retrieval rule refers to the method by which the server obtains implementation data from the system.

[0064] In one example, the current server is connected to the system via a wired connection, and the system can transmit data to the server via a signal transmission cable.

[0065] In another example, the current server is wirelessly connected to the system, and the system can transmit data to the server wirelessly, such as via Bluetooth, wireless network, etc.

[0066] In an example, the data retrieval rule may be a data retrieval function, such as a left() function, a right() function, a mid() function, or a user-defined rule, such as selecting only the first ten data items or selecting only data in a numeric format.

[0067] To improve data security, before S10, users using the server can also be verified.

[0068] In one example, the user can log in to the server only if the account and password entered by the user match.

[0069] In a further preferred solution, users can be divided into different levels, with different permissions corresponding to different users. For example, users with level one permissions can only view data stored in the server and cannot edit the data. Users with level two permissions can not only view data stored in the server but also edit the data. Users with level three permissions can view and edit data stored in the server and can also modify the permissions and / or levels of users with level one and level two permissions.

[0070] In a further preferred solution, user levels and / or permission time limits can be set, enabling better user management and improved data security. For example, if user A with level 1 permission is granted 24 hours of level 2 permission, then during the validity period of the level 2 permission, user A can not only view data stored on the server but also edit it. At the end of the level 2 permission period, user A reverts to level 1 permission, only being able to view data stored on the server but not edit it.

[0071] Step S20: Connect to the corresponding system according to the direct connection rule, and obtain implementation data from the system according to the execution list and data retrieval rules;

[0072] In one possible implementation, the systems are connected according to a direct connection rule.

[0073] The execution list and data retrieval rules are encrypted to obtain encrypted information, and the encrypted information is sent to the system.

[0074] In one example, a stream encryption algorithm may be used to encrypt the execution list and the data retrieval rules to obtain encrypted information, which is then sent to the system.

[0075] In one example, a block encryption algorithm may be used to encrypt the execution list and the data retrieval rules to obtain encrypted information, which is then sent to the system.

[0076] After receiving the encrypted information, the system needs to decrypt it before it can obtain the execution list and data retrieval rules.

[0077] To avoid transmission failures, you can first obtain implementation data from the system based on the execution list and data retrieval rules.

[0078] Determine the amount of implementation data that needs to be transmitted based on the execution list and data retrieval rules;

[0079] When the amount of implementation data is less than or equal to the preset amount, the implementation data is obtained from the system according to the execution list and data retrieval rules;

[0080] When the amount of implementation data is greater than the preset data amount, the implementation data is divided according to the preset data amount to obtain multiple batches of implementation data, thereby alleviating the transmission pressure by dividing the data into batches.

[0081] In one example, the present invention can also alleviate transmission pressure by using a transmission queue. The implementation data is sequentially placed into the queue in batches. Each time the server obtains a batch of implementation data, it deletes the batch and places the remaining implementation data from the end of the queue.

[0082] The system encrypts the implementation data to obtain encrypted implementation data.

[0083] In one example, the implementation data may be encrypted using a national encryption algorithm to obtain encrypted implementation data.

[0084] After receiving the encrypted implementation data, the server also needs to decrypt the encrypted implementation data before it can obtain the implementation data.

[0085] In order to prevent the implementation data from being tampered with, the system can add a digital signature when sending the implementation data, and the server can verify the identity of the sender through the digital signature.

[0086] To improve data security, a shared key can be used for encryption between the server and the system.

[0087] In one example, the server encrypts the execution list and data retrieval rules using a shared key, obtaining encrypted information, and sends the encrypted information to the system. After receiving the encrypted information, the system decrypts it using the shared key to obtain the execution list and data retrieval rules. The system encrypts implementation data using the shared key to obtain encrypted implementation data, and then feeds back the encrypted implementation data. After receiving the encrypted implementation data, the server decrypts it using the shared key to obtain the implementation data.

[0088] In order to improve data security, the server and the system each use their own public key for encryption and the other party's private key for decryption.

[0089] In one example, the server pre-acquires the system private key, and the system pre-acquires the server private key. The server encrypts the execution list and data retrieval rules using the server public key, obtaining encrypted information, and sends the encrypted information to the system. After receiving the encrypted information, the system decrypts the encrypted information using the server private key to obtain the execution list and data retrieval rules. The system encrypts implementation data using the system public key to obtain encrypted implementation data, and then feeds back the encrypted implementation data. After receiving the encrypted implementation data, the server decrypts the encrypted implementation data using the system private key to obtain the implementation data.

[0090] In a possible implementation, in order to prevent the data acquisition state from being in place for a long time, the following steps are further included after S20:

[0091] When the implementation data is not received within the preset time, the system is reconnected according to the direct connection rules, or the implementation data is re-obtained from the system according to the execution list and data retrieval rules.

[0092] The preset duration may be a fixed value set by the user, or a dynamic value determined based on the time for obtaining historical implementation data.

[0093] In one example, at fixed intervals, the time of each acquisition of implementation data before the current time is obtained, and the average of all times is taken as the new preset duration.

[0094] In a possible implementation, S20 further includes: encrypting a channel connecting the systems through the direct connection rule.

[0095] Step S30, performing storage processing on the implementation data according to the Rolling function to obtain storage data;

[0096] The Rolling function is provided in Pandas, a Python data analysis toolkit that incorporates numerous libraries and standard data models, providing the tools needed to efficiently manipulate large datasets. The Rolling function can be used as a stacked data storage method. When executed, the data for the corresponding N preset periods is deleted and replaced with the new data for the N preset periods.

[0097] In a possible implementation, it is determined whether the implementation data is within a preset period, and when the implementation data is within the preset period, the implementation data is stored in a database according to a Rolling function to obtain stored data.

[0098] Before filling the specified location with implementation data, the data at that location needs to be deleted.

[0099] In one example, the preset period may be any length of time, such as a year, a month, or a day.

[0100] When the implementation data is not within the preset period, a deposition process is performed on the implementation data to obtain deposition data.

[0101] In a possible implementation, S30 further includes:

[0102] Determine the storage database and storage data table of the implementation data according to the execution list and / or implementation data; store the implementation data into the storage data table in the storage database according to the Rolling function to obtain the storage data.

[0103] Step S40: version the incoming data according to the delivery requirements to obtain multiple versions of data;

[0104] In the embodiments of the present invention, versions generally refer to different stored versions of the stored information. That is, each modification to the stored information creates a new version. After the modification is completed, a version number is automatically generated to facilitate user differentiation. After the modification is completed, the modification time is also added to the corresponding version to facilitate user differentiation.

[0105] Step S50: delivering the specified version data according to the received delivery version instruction;

[0106] The delivery in the embodiment of the present invention mainly refers to uploading the specified version data to the cloud server.

[0107] In one example, the user directly inputs a delivery version instruction through the server, and the delivery at this time may also be the output of the specified version data.

[0108] In another example, the user inputs a delivery instruction through a remote computer. In this case, the delivery can be performed by the server uploading the specified version of the data to a cloud server, which then sends the data to the remote computer.

[0109] Step S60: receiving the appeal request submitted by the user and sending the appeal request to the administrator for the administrator to review the appeal request;

[0110] The appeal request may include at least one of the following: appellant, attachments, appeal content, project name, contact information, appeal status, appeal type, etc.

[0111] The review of appeal requests can be manual or automatic.

[0112] If the data is indeed incorrect, the status of the appeal request will be set to approved, otherwise the status of the appeal request will be set to rejected.

[0113] Step S70: When the appeal request is approved, the appeal list, appeal direct connection rules, and appeal data retrieval rules in the appeal request are extracted;

[0114] If the appeal request is rejected, the appeal result will be fed back to the appellant to remind the appellant that the appeal is incorrect or the appeal operation is incorrect.

[0115] Step S80: reacquire implementation data according to the appeal list, appeal direct connection rules and appeal data acquisition rules, and execute S30-S50 again.

[0116] In a possible implementation, the method further includes step S90:

[0117] Receive query conditions provided by the user, the query conditions including information about the target system to be queried and target implementation data;

[0118] Get the number of databases and data tables in the target system;

[0119] When the number of databases and data tables are both 1, search in the data table of the target system according to the information of the target implementation data, and output and display the found query data;

[0120] When the number of databases is 1 and the number of data tables is greater than 1, a first target data table storing target implementation data among the multiple data tables to be queried is determined according to the query conditions; the first target data table is searched according to the information of the target implementation data, and the found query data is output and displayed;

[0121] When the number of databases and the number of data tables are both greater than 1, the target database and the second target data table storing the target implementation data are determined according to the query conditions, the second target data table in the target database is searched according to the information of the target implementation data, and the found query data is output and displayed.

[0122] Figure 2 A schematic diagram of the structure of a data direct connection system provided by an embodiment of the present invention is shown in FIG. Figure 2 As shown, an embodiment of the present invention further provides a data direct connection processing system for executing any of the above-mentioned data direct connection processing methods, including:

[0123] The acquisition module 201 is used to receive instructions input by the user and obtain the execution list, direct connection rules and data retrieval rules for data direct connection according to the instructions;

[0124] The direct connection rule is used to specify how each pharmaceutical company establishes a connection with the current server. The execution list includes the names of each pharmaceutical company used for direct data connection and the system corresponding to each pharmaceutical company. The system is a database management system; the data retrieval rule refers to the way the server re-obtains implementation data from the system.

[0125] Direct connection module 202, used to connect to the corresponding system according to the direct connection rules, and obtain implementation data from the system according to the execution list and data retrieval rules;

[0126] The direct connection rule is how pharmaceutical companies establish connections with the system; the system is the storage area corresponding to the companies on the execution list;

[0127] The execution list and data retrieval rules are encrypted to obtain encrypted information, and the encrypted information is sent to the system.

[0128] After receiving the encrypted information, the system needs to decrypt it before it can obtain the execution list and data retrieval rules.

[0129] Obtain implementation data from the system according to the execution list and data retrieval rules.

[0130] To avoid transmission failures, you can first determine the amount of implementation data that needs to be transmitted based on the execution list and data retrieval rules.

[0131] When the amount of implementation data is less than the preset amount, the implementation data can be directly obtained from the system based on the execution list and data retrieval rules.

[0132] When the amount of implementation data is less than the preset data amount, the implementation data can be divided according to the preset data amount to alleviate the transmission pressure in batches.

[0133] The system encrypts the implementation data, obtains the encrypted implementation data, and feeds back the encrypted implementation data.

[0134] After receiving the encrypted implementation data, the server also needs to decrypt the encrypted implementation data before it can obtain the implementation data.

[0135] The storage module 203 is used to perform storage processing on the implementation data according to the Rolling function to obtain storage data;

[0136] When the implementation data is within the preset period, the implementation data is stored in the database according to the Rolling function to obtain the stored data.

[0137] Before filling the specified location with implementation data, the data at that location needs to be deleted.

[0138] The version module 204 is used to divide the incoming data into versions according to the delivery requirements to obtain multiple versions of data;

[0139] The delivery in the embodiment of the present invention mainly refers to uploading the specified version data to the cloud server.

[0140] In the embodiments of the present invention, versions generally refer to different stored versions of the stored information. That is, each modification to the stored information creates a new version, and after the modification is completed, a version number is automatically assigned to facilitate user differentiation. After the modification is completed, the modification time is also added to the corresponding version for easier differentiation.

[0141] The delivery module 205 is used to deliver the specified version data according to the received delivery version instruction;

[0142] Receiving module 206, for receiving the appeal request submitted by the user and sending the appeal request to the administrator for the administrator to review the appeal request;

[0143] Extraction module 207, used to extract the appeal list, appeal direct connection rules and appeal data retrieval rules in the appeal request when the appeal request is approved;

[0144] The re-acquisition module 208 is used to re-acquire the implementation data according to the appeal list, the appeal direct connection rule and the appeal data acquisition rule.

[0145] In a possible implementation, the data direct connection processing system further includes a query module for receiving query conditions provided by a user, wherein the query conditions include information about the target system to be queried and the target implementation data;

[0146] Get the number of databases and data tables in the target system;

[0147] When the number of databases and data tables are both 1, search in the data table of the target system according to the information of the target implementation data, and output and display the found query data;

[0148] When the number of databases is 1 and the number of data tables is greater than 1, a first target data table storing target implementation data among the multiple data tables to be queried is determined according to the query conditions; the first target data table is searched according to the information of the target implementation data, and the found query data is output and displayed;

[0149] When the number of databases and the number of data tables are both greater than 1, the target database and the second target data table storing the target implementation data are determined according to the query conditions, the second target data table in the target database is searched according to the information of the target implementation data, and the found query data is output and displayed.

[0150] In a possible implementation, the direct connection module 202 may also be used to determine the amount of implementation data to be transmitted based on the execution list and the data retrieval rule;

[0151] When the amount of implementation data is less than or equal to the preset amount, the implementation data is obtained from the system according to the execution list and data retrieval rules;

[0152] When the amount of the implementation data is greater than the preset amount, the implementation data is divided according to the preset amount to obtain multiple batches of implementation data.

[0153] In a possible implementation, the user instruction includes a screening condition, an import instruction, and a selection instruction;

[0154] The acquisition module 201 may also be used to:

[0155] Obtain screening results from the preset project process list based on screening conditions;

[0156] According to the import instructions, determine the execution list from the screening results;

[0157] Determine direct connection rules and data retrieval rules based on selection instructions and execution lists.

[0158] In a possible implementation, the direct connection module 202 may also be used to:

[0159] Encrypt the execution list and data retrieval rules to obtain encrypted information, and send the encrypted information to the system;

[0160] Obtain implementation data from the system according to the execution list and data retrieval rules;

[0161] The implementation data is encrypted to obtain encrypted implementation data.

[0162] In a possible implementation, the warehousing module 203 may also be used to:

[0163] Determine whether the implementation data is within the preset period, and when the implementation data is within the preset period, store the implementation data in the database according to the Rolling function to obtain the stored data;

[0164] When the implementation data is not within the preset period, a deposition process is performed on the implementation data to obtain deposition data.

[0165] In a possible implementation, the warehousing module 203 may also be used to:

[0166] Determine the storage database and storage data table for implementation data based on the execution list and / or implementation data;

[0167] According to the Rolling function, the implementation data is stored in the storage data table in the storage database to obtain the storage data.

[0168] In a possible implementation, the direct connection module 202 may also be used to:

[0169] When the implementation data is not received within the preset time, the system is reconnected according to the direct connection rules, or the implementation data is re-obtained from the system according to the execution list and data retrieval rules.

[0170] In a possible implementation, the direct connection module 202 may also be used to:

[0171] Encrypt the channel connecting the system through the direct connection rule.

[0172] The method and system for directly processing pharmaceutical enterprise data provided by the present invention can improve data processing speed, reduce data processing costs, and ensure data quality.

[0173] The above are merely specific embodiments of the present invention, but the scope of protection of the present invention is not limited thereto. Any modifications or substitutions that can be easily conceived by a person skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be based on the scope of protection of the claims.

Claims

1. A method for directly processing data flowing from pharmaceutical companies, characterized in that: include: Step S10: receiving a user input instruction and obtaining an execution list, direct connection rules, and data retrieval rules for direct data connection according to the instruction; the direct connection rules are used to specify the method for each pharmaceutical company to establish a connection with the current server, and the execution list includes the names of each pharmaceutical company used for direct data connection and the system corresponding to each pharmaceutical company, wherein the system is a database management system; Step S20, connecting to the corresponding system according to the direct connection rule, and obtaining implementation data from the system according to the execution list and data retrieval rules; Step S30, performing storage processing on the implementation data according to the Rolling function to obtain storage data; Step S40: dividing the stored data into versions according to the delivery requirements to obtain multiple versions of data; Step S50: delivering the specified version data according to the received delivery version instruction; Step S60: receiving the appeal request submitted by the user and sending the appeal request to the administrator for the administrator to review the appeal request; Step S70: When the appeal request is approved, extract the appeal list, appeal direct connection rules, and appeal data retrieval rules in the appeal request; Step S80: reacquire the implementation data according to the complaint list, the complaint direct connection rule and the complaint data acquisition rule, and execute S30-S50 again.

2. The data direct connection processing method according to claim 1, characterized in that: The step S90 is also included: Receive query conditions provided by a user, wherein the query conditions include information about a target system to be queried and target implementation data; Obtain the number of databases and data tables of the target system; When the number of databases and the number of data tables are both 1, search the data table of the target system according to the information of the target implementation data, and output and display the found query data; When the number of databases is 1 and the number of data tables is greater than 1, determining a first target data table storing the target implementation data among the multiple data tables to be queried according to the query condition; Searching the first target data table according to the information of the target implementation data, and outputting and displaying the found query data; When the number of databases and the number of data tables are both greater than 1, the target database and the second target data table storing the target implementation data are determined according to the query conditions, the second target data table in the target database is searched according to the information of the target implementation data, and the found query data is output and displayed.

3. The data direct connection processing method according to claim 1, characterized in that: The S20 includes: Determining the amount of implementation data to be transmitted based on the execution list and the data retrieval rules; When the amount of the implementation data is less than or equal to the preset amount, obtaining the implementation data from the system according to the execution list and the data retrieval rule; When the data volume of the implementation data is greater than the preset data volume, the implementation data is divided according to the preset data volume to obtain multiple batches of implementation data.

4. The data direct connection processing method according to claim 1, characterized in that: The user instructions include screening conditions, import instructions and selection instructions; S10 includes: Obtaining screening results from a preset project process list according to the screening conditions; Determining the execution list from the screening results according to the import instruction; The direct connection rule and the data retrieval rule are determined according to the selection instruction and the execution list.

5. The data direct connection processing method according to claim 1, characterized in that: The S20 further includes: Encrypting the execution list and the data retrieval rule to obtain encrypted information, and sending the encrypted information to the system; Acquire implementation data from the system according to the execution list and data retrieval rules; The implementation data is encrypted to obtain encrypted implementation data.

6. The data direct connection processing method according to claim 1, characterized in that: The S30 further includes: determining whether the implementation data is within a preset period, and when the implementation data is within the preset period, storing the implementation data in a database according to the Rolling function to obtain stored data; When the implementation data is not within a preset period, a deposition process is performed on the implementation data to obtain deposition data.

7. The data direct connection processing method according to claim 1, characterized in that: The S30 further includes: Determine a storage database and a storage data table for the implementation data according to the execution list and / or the implementation data; The implementation data is stored in the storage data table in the storage database according to the Rolling function to obtain storage data.

8. The data direct connection processing method according to claim 1, characterized in that: The S20 further includes: When the implementation data is not received within a preset time period, the system is reconnected according to the direct connection rule, or the implementation data is reacquired from the system according to the execution list and data retrieval rule.

9. The data direct connection processing method according to claim 1, characterized in that: The S20 further includes: The channel connecting the systems through the direct connection rule is encrypted.

10. A pharmaceutical enterprise data direct connection processing system for executing the data direct connection processing method according to any one of claims 1 to 9, characterized in that: include: an acquisition module for receiving a user input instruction and acquiring an execution list, direct connection rules, and data retrieval rules for direct data connection according to the instruction; the direct connection rules are used to specify the method for each pharmaceutical company to establish a connection with the current server; the execution list includes the names of each pharmaceutical company used for direct data connection and the system corresponding to each pharmaceutical company, wherein the system is a database management system; A direct connection module, configured to connect to a corresponding system according to the direct connection rule, and obtain implementation data from the system according to the execution list and data retrieval rules; The storage module is used to perform storage processing on the implementation data according to the Rolling function to obtain storage data; A version module is used to divide the stored data into versions according to the delivery requirements to obtain multiple versions of data; The delivery module is used to deliver the specified version data according to the received delivery version instruction; A receiving module is used to receive a complaint request submitted by a user and send the complaint request to an administrator for the administrator to review the complaint request; An extraction module, configured to extract the appeal list, appeal direct connection rules, and appeal data retrieval rules from the appeal request when the appeal request is approved; The re-acquisition module is used to re-acquire the implementation data according to the complaint list, the complaint direct connection rule and the complaint data acquisition rule.

Images