Data processing method, device, equipment and storage medium

By comparing and mapping the attribute items of data templates, the problem of inefficient compilation of traditional pharmacovigilance master files is solved, and more efficient data processing and file writing is achieved.

CN114021540BActive Publication Date: 2025-03-14浙江太美医疗科技股份有限公司
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202111333643.4
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-11-11
Publication Date
2025-03-14
Estimated Expiration
2041-11-11

AI Technical Summary

Technical Problem

The compilation of traditional pharmacovigilance master documents requires a lot of manpower, and a lot of repetitive labor is required when information updates or changes in laws and regulations are made.

Method used

By comparing the first data template with the second data template, the same target attribute item is obtained, and a mapping label is added to the target attribute item in the second data template that is the same as the target attribute item in the first data template, so that it can parse the data based on the first parsing rule.

Benefits of technology

It effectively improves the efficiency of writing pharmacovigilance master files, reduces repetitive labor, and improves the configuration efficiency of data templates.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114021540B_ABST
    Figure CN114021540B_ABST
Patent Text Reader

Abstract

The embodiments of the present specification provide a data processing method, apparatus, device and storage medium. Compare a first data template with a second data template to obtain the same target attribute item; wherein the first data template and the second data template respectively include multiple attribute items; the attribute item of the first data template has a mapping tag that matches the first parsing rule; add the same mapping tag as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item in the second data template can map the data parsed based on the first parsing rule based on the mapping tag. By adding the same mapping tag as the target attribute item in the first data template to the target attribute item in the second data template, the target attribute item of the second data template reuses the parsing rule of the target attribute item of the first data template, which effectively improves the efficiency of data template compilation.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a data processing method, device, equipment and storage medium. Background Art

[0002] In order to standardize and guide the pharmacovigilance activities of drug marketing authorization holders and drug registration applicants, the State Drug Administration has organized the formulation of the "Pharmacovigilance Quality Management Standards" to standardize the pharmacovigilance activities of the entire life cycle of drugs. It stipulates the establishment, update, content and submission of the pharmacovigilance master file. The holder shall create and maintain the pharmacovigilance master file to describe the pharmacovigilance system and activities. The holder shall update the pharmacovigilance master file in a timely manner to ensure that it is consistent with the current pharmacovigilance system and activities, and continue to meet relevant laws and regulations and actual work needs. The pharmacovigilance master file shall include: organizational structure, full-time staffing, sources of drug adverse reaction information, etc. For the requirements of the drug supervision and administration department, the holder shall submit the pharmacovigilance master file as required. It can be seen that the pharmacovigilance master file contains a large amount of data and information, and needs to be established and updated in accordance with legal requirements.

[0003] The pharmacovigilance master file includes a large amount of information. The compilation of traditional pharmacovigilance master files often involves manual data collection and writing, which requires a lot of manpower. In addition, when information is updated or legal and regulatory requirements change, the pharmacovigilance master file needs to be modified, which often requires a lot of repetitive work. Summary of the invention

[0004] In view of this, multiple embodiments of this specification are dedicated to providing a data processing method, device, equipment and storage medium, which effectively improve the efficiency of writing drug vigilance master files.

[0005] An embodiment of the present specification provides a data processing method, including: comparing a first data template with a second data template to obtain the same target attribute item; wherein the first data template and the second data template respectively include multiple attribute items; the attribute item of the first data template has a mapping label that matches a first parsing rule; and adding a mapping label that is the same as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item in the second data template can map the data parsed based on the first parsing rule based on the mapping label.

[0006] An embodiment of the present specification provides a data processing method, including: receiving a second data file generation request for a second data template sent by a terminal, wherein the second data template includes multiple attribute items; acquiring second source data based on the second data file generation request; setting a designated tag for the second source data that matches a first parsing rule; wherein the attribute items in the first data template have a mapping tag that matches the first parsing rule, the attribute items in the second data template at least partially include a mapping tag that matches the first parsing rule, and the designated tag corresponds to the mapping tag.

[0007] An embodiment of the present specification provides a data processing device, including: a target attribute acquisition module, used to compare a first data template with a second data template to obtain the same target attribute item; wherein the first data template and the second data template respectively include multiple attribute items; the attribute item of the first data template has a mapping label that matches a first parsing rule; a mapping label adding module, used to add a mapping label that is the same as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item in the second data template can map the data parsed based on the first parsing rule based on the mapping label.

[0008] An embodiment of the present specification provides a data processing device, including: a request receiving module, used to receive a second data file generation request for a second data template sent by a terminal, wherein the second data template includes multiple attribute items; a source data acquisition module, used to acquire second source data based on the second data file generation request; a source data parsing module, used to set a specified label for the second source data matching the first parsing rule; wherein the attribute items in the first data template have a mapping label matching the first parsing rule, the attribute items in the second data template at least partially include a mapping label matching the first parsing rule, and the specified label corresponds to the mapping label.

[0009] An embodiment of the present specification provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the method described in the above embodiment when executing the computer program.

[0010] An embodiment of the present specification provides a computer-readable storage medium having computer program instructions stored thereon, wherein the computer program instructions implement the method described in the above embodiment when executed by a processor.

[0011] The implementation mode of this specification adds the same mapping label as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item of the second data template can reuse the parsing rule of the target attribute item of the first data template, thereby effectively improving the efficiency of data template writing and the efficiency of writing drug vigilance master files. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] Figure 1 Shown is an interactive schematic diagram of a data processing method in a scenario example provided by an implementation method.

[0013] Figure 2 Shown is an interactive schematic diagram of a data processing system in a scenario example provided by an embodiment.

[0014] Figure 3 Shown is a flow chart of a data processing method provided by one embodiment.

[0015] Figure 4 Shown is a flow chart of a data processing method provided by one embodiment.

[0016] Figure 5 Shown is a structural block diagram of a data processing device provided by one embodiment.

[0017] Figure 6 Shown is a structural block diagram of a data processing device provided by one embodiment.

[0018] Figure 7 Shown is a diagram of the internal structure of a computer device provided by one embodiment. DETAILED DESCRIPTION

[0019] The following will be combined with the drawings in some of the embodiments of the specification to clearly and completely describe the technical solutions in some of the embodiments of the specification. Obviously, the described embodiments are only some of the embodiments of the specification, not all of the embodiments. Based on the embodiments in this specification, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of this specification.

[0020] The pharmacovigilance quality management specification stipulates that the holder shall create and maintain the pharmacovigilance master file, and stipulates the content that the pharmacovigilance master file should include. The pharmacovigilance master file needs to include: organizational information, basic information of the person in charge of pharmacovigilance, full-time staffing, sources of adverse drug reaction information, information tools or systems, etc. The organizational information specifically includes information describing the organizational structure, responsibilities and relationships related to pharmacovigilance activities. The basic information of the person in charge of pharmacovigilance includes residence, contact information, resume, responsibilities, etc. It can be seen that the pharmacovigilance master file needs to record a lot of information in accordance with the specification. In addition, the holder should update the pharmacovigilance master file in a timely manner to ensure that it is consistent with the current pharmacovigilance system and activities, and continue to meet relevant laws and regulations and actual work needs. Therefore, there is a need to modify and update the pharmacovigilance master file. The current pharmacovigilance master file is often compiled by manual data collection and writing, and needs to be recompiled when updated, resulting in a lot of duplication of work.

[0021] See also Figure 1 . In a specific scenario example, in order to improve the efficiency of writing the pharmacovigilance master file and better ensure that the pharmacovigilance master file meets legal requirements, the administrator can pre-create the data template of the pharmacovigilance master file according to legal requirements and actual work conditions. In addition, computer technology is used to store pharmacovigilance related data. In order to map data to the data template and form a data file, it is necessary to establish data parsing rules, parse the data first, and then map the parsed data to the data template to form the pharmacovigilance master file. The administrator can configure the data template and the parsing rules through a terminal, such as operating a computer. At this time, the administrator end can be understood as the user end. The pharmacovigilance master file needs to include the basic information of the person in charge of pharmacovigilance, including residence, contact information, resume, responsibilities, etc.; accordingly, the data template needs to include attribute items such as residence and contact information. Each attribute item can include an attribute identifier and an attribute value. For example, the attribute identifier of the contact information attribute item is "telephone" and the attribute value is "***". At this time, the attribute value is the initial value. The attribute item has a mapping label. For example, the mapping label of the contact information attribute item is "telephone", and the mapping label can be used as the attribute identifier. The mapping tag matches the first parsing rule. For example, if the source data is the person in charge's phone number 123, the first parsing rule can be used to set the specified tag "extension number" for the phone number "123". The specified tag corresponds to the mapping tag. For example, the rules are set in advance, and the mapping tag is the only association between "phone number" and the specified tag "extension number", so as to realize mapping the data with the specified tag to the attribute item of the data template.

[0022] Taking the first data template that has been established as an example, the first data template includes multiple attribute items, and the attribute items of the first data template have mapping tags that match the first parsing rule. Specifically, for example, the first data template includes attribute items that reflect the basic information of the person in charge of drug vigilance, specifically including residence, contact information, and responsibility attribute items. However, the attribute items of the first data template do not include a resume for the basic information of the person in charge of drug vigilance, which does not meet legal requirements. At this time, a second data template needs to be created. The second data template also needs to include residence, contact information, and responsibility attribute items. For the same target attribute items as the first data template, the residence, contact information, and responsibility attribute items in the second data template can be added with the same mapping tags as the residence, contact information, and responsibility attribute items in the first data template. At this time, the residence, contact information, and responsibility attribute items can be mapped based on the mapping tags to the data parsed based on the first parsing rule.

[0023] In addition, for distinguishing attribute items related to resume information that are not included in the first data template, additional mapping labels and parsing rules need to be set. For example, resume information needs to include majors, degrees, etc., and the second data template is configured with major and degree attribute items, and the second mapping label is configured for the attribute item, such as the second mapping label of the major attribute item is "A1" and the second mapping label of the degree attribute item is "B1". The first parsing rule includes setting a specified label "A" for the source data of the major "Pharmacy" and setting a specified label "B" for the source data of the academic degree "Doctor". A1 is set to have a unique association with A, and B1 is set to have a unique association with B. Then, the distinguishing attribute item can be mapped based on the second mapping label to the data parsed based on the second parsing rule.

[0024] See also Figure 2. The embodiment of this specification provides a data processing system. The data processing system may include a user terminal and a server. The user terminal may be an electronic device with network access capability. Specifically, for example, the user terminal may be a desktop computer, a tablet computer, a laptop computer, a smart phone, a digital assistant, a smart wearable device, a shopping guide terminal, a television, a smart speaker, a microphone, etc. Among them, smart wearable devices include but are not limited to smart bracelets, smart watches, smart glasses, smart helmets, smart necklaces, etc. Alternatively, the user terminal may also be software that can be run in the above-mentioned electronic devices. The server may be an electronic device with certain computing and processing capabilities. It may have a network communication module, a processor, and a memory, etc. Of course, the above-mentioned server may also refer to software running in the electronic device. The above-mentioned server may also be a distributed server, which may be a system with multiple processors, memories, network communication modules, etc. operating in collaboration. Alternatively, the server may also be a server cluster formed by several servers. Alternatively, with the development of science and technology, the server may also be a new technical means that can realize the corresponding functions of the embodiment of the specification. For example, it may be a new form of "server" based on quantum computing.

[0025] See also Figure 3 The embodiments of this specification provide a data processing method. In some embodiments, the data processing method may be executed by a server. The data processing method may include the following steps.

[0026] Step S110: Compare the first data template with the second data template to obtain the same target attribute items; wherein the first data template and the second data template respectively include multiple attribute items; the attribute items of the first data template have mapping tags that match the first parsing rules.

[0027] In order to facilitate the management and unification of documents, cases, clinical trial data, pharmacovigilance master files, etc. need to have standard templates to standardize the form and content of various documents. Taking the pharmacovigilance master file as an example, the pharmacovigilance master file is a legal requirement document, so it needs to be written in accordance with legal provisions. In order to ensure that the final document meets legal requirements, the template of the pharmacovigilance master file is often first formulated according to legal guidance. The pharmacovigilance master file involves multiple contents and requires the collection of a large amount of information, which may come from different data sources. Therefore, in order to make the collected pharmacovigilance data match the requirements of the template, it is necessary to formulate initial data processing rules, association rules between processed data and templates, etc., which generates a lot of workload.

[0028] In some cases, a new pharmacovigilance master file template needs to be created to adapt to changes in the company, such as changes in company employees, changes in the company's organizational structure, or to meet the requirements of different countries, or when laws and regulations change, or to meet the requirements of different companies. However, different templates often have the same content. If you create them from scratch, a lot of duplication of work will be generated in the process of establishing templates multiple times, which is not conducive to improving efficiency.

[0029] In some embodiments, the first data template and the second data template may both be templates of a pharmacovigilance master file, a clinical trial data template, an electronic medical record template, etc. For example, the first data template is a data template of a pharmacovigilance master file set on the original organizational structure of the company, and the second data template is a data template of a pharmacovigilance master file established after the organizational structure of the company changes.

[0030] In some embodiments, the first data template and the second data template include multiple attribute items respectively. The "Pharmacovigilance Quality Management Standards" stipulates that the content of the pharmacovigilance master file includes the staffing of full-time personnel, such as the number of full-time personnel, relevant professional background, etc. Therefore, both the first data template and the second data template can include full-time personnel name attribute items, full-time personnel education attribute items, etc., to meet the requirements. In some embodiments, the first data template is compared with the second data template, which can be to compare each attribute item in the first data template with the attribute item in the second data template one by one, or to compare each attribute item in the second data template with the attribute item in the first data template one by one, so as to obtain the same target attribute item.

[0031] In some embodiments, the attribute item may include an attribute item identifier, and the first data template and the second data template are compared to obtain the same target attribute item, which may be determined by comparing the attribute item identifiers to determine whether the attribute items in the first data template and the second data template are target attribute items. When the attribute item identifier of the attribute item in the second data template is the same as the attribute item identifier of the attribute item in the first data template, the attribute item represented by the attribute identifier is the target attribute item.

[0032] When generating a pharmacovigilance master file, it is necessary to collect information from various systems and files, and then fill it into the configured pharmacovigilance master file data template to form a standard data file.

[0033] In some embodiments, the attribute item of the first data template has a mapping tag that matches the first parsing rule. The first parsing rule can be used to set a specified tag for the first source data when the first source data required by the first data template is obtained, wherein the specified tag has a corresponding relationship with the mapping tag, so that the attribute item of the first data template can map the first source data parsed based on the first parsing rule based on the mapping tag.

[0034] In some embodiments, the attribute item may have an attribute identifier, and the mapping tag may have a corresponding relationship with the attribute identifier, so that the attribute item can match the first parsing rule. The mapping tag may have a corresponding relationship with the attribute identifier, and the mapping tag and the attribute identifier may be the same, or the two may be different but have a one-to-one association relationship based on a preset rule. The attribute item may also have an attribute value, and the attribute value in the first data template may take a null value or any original value. The first source data may have a source data value. After the first source data is parsed based on the first parsing rule, or in other words, after the first source data is set with a specified tag based on the first parsing rule, the specified tag and the mapping tag have a corresponding relationship, and at this time, the attribute item of the first data template can map the first source data parsed based on the first parsing rule based on the mapping tag. Specifically, the attribute value can be replaced with the source data value, so as to achieve data mapping, and finally form a first data file that conforms to the format of the first data template. The specified tag and the mapping tag have a corresponding relationship, and the two may be the same or the two may have a one-to-one association relationship based on a preset rule. For example, the first data template needs to include attribute items related to the basic information of the person in charge of drug vigilance. Specific attribute items may include residence, contact information, etc. At this time, the attribute identifier may include "residence" and "telephone". The mapping label corresponding to the "residence" attribute identifier is "residence", and the mapping label corresponding to the "telephone" attribute identifier is "mobile phone number". Correspondingly, the designated label may be "residence" and "telephone". Among them, "mobile phone number" and "telephone" are pre-set as a one-to-one association, so that there is a corresponding relationship between the attribute identifier and the mapping label, and between the designated label and the mapping label.

[0035] In some embodiments, the attribute item may have an attribute identifier and an attribute value, and the attribute value of the attribute item of the first data template may be a mapping label, so that the attribute item can match the first parsing rule. The first source data may have a source data value. After the first source data is parsed based on the first parsing rule, the attribute item of the first data template can map the first source data parsed based on the first parsing rule based on the mapping label. Specifically, the attribute value can be replaced with the source data value, that is, the mapping label can be replaced, thereby realizing data mapping, and finally forming a first data file that conforms to the format of the first data template.

[0036] By comparing the first data template with the second data template, the same target attribute item is obtained, thereby identifying the attribute item shared by the two data templates.

[0037] Step S120: adding the same mapping tag as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item in the second data template can map the data parsed based on the first parsing rule based on the mapping tag.

[0038] Since the attribute item of the first data template has a mapping tag that matches the first parsing rule, and the target attribute item is the same attribute item in the second data template as in the first data template, the same data processing rule can be set. For the target attribute item in the second data template, add the same mapping tag as the target attribute item in the first data template, then the target attribute item in the second data template has a mapping tag that matches the first parsing rule. In this case, the first parsing rule can be reused, and the data parsed based on the first parsing rule can establish a connection with the target attribute item because of the mapping tag, thereby realizing data mapping and forming a data file in a standard format that conforms to the definition of the second data template.

[0039] The data processing method provided in the implementation mode of this specification realizes the reuse of rules by adding the same mapping label as the target attribute item in the first data template to the target attribute item in the second data template, realizes the export of multiple data files, and improves the configuration efficiency of the data template.

[0040] It can be understood that different data templates are configured because there are differences between the data templates. Therefore, simply reusing the first parsing rule of the first data template does not form a complete second data template.

[0041] In some embodiments, the data processing method may further include: comparing the first data template with the second data template to obtain distinguishing attribute items in the second data template that are different from the first data template; configuring a second mapping label for the distinguishing attribute items that matches a second parsing rule; wherein the second parsing rule is different from the first parsing rule.

[0042] It can be understood that the target attribute item can be all the attribute items of the first data template, or it can be some of the attribute items of the first data template. Of course, the target attribute item can also be all the attribute items of the second data template, or it can be some of the attribute items of the second data template. The first data template is compared with the second data template to obtain the distinguishing attribute items in the second data template that are different from the first data template. The set of distinguishing attribute items and target attribute items can be all the attribute items of the second data template. It can be understood that at this time, the target attribute item is a part of the attribute items of the second data template, and the distinguishing attribute items cannot reuse the first parsing rule. By configuring a second mapping tag that matches the second parsing rule for the distinguishing attribute item, the second parsing rule is different from the first parsing rule, so that the data mapping of the attribute items in the second data template that are different from the first data template can be implemented based on the second parsing rule, forming a file in a standard format that conforms to the definition of the second data template.

[0043] When there are multiple data templates, when forming a new data template, it can be compared with multiple already configured data templates, so as to further improve the efficiency of forming data templates and data files.

[0044] In some embodiments, the data processing method may further include: comparing the first data template with the second data template to obtain a distinguishing attribute item in the second data template that is different from the first data template; comparing the distinguishing attribute item with a third data template to obtain the same second target attribute item, the attribute item of the third data template having a third mapping tag that matches a third parsing rule; adding a third mapping tag that is the same as the second target attribute item in the third data template to the second target attribute item in the second data template, so that the second target attribute item in the second data template can map the data parsed based on the third parsing rule based on the third mapping tag. By comparing the distinguishing attribute item with the third data template, when the distinguishing attribute item and the attribute item in the third data template are the same, the attribute item that cannot reuse the first data template can reuse the parsing rule of the third data template, thereby improving the efficiency of forming data templates and data files.

[0045] In some embodiments, when the second data template also includes a second distinguishing attribute item that is different from both the first data template and the third data template, a separate parsing rule may be configured for it. It is understood that the parsing rule may be different from both the first parsing rule and the second parsing rule. The comparison may also be continued in the presence of other data templates. The specific method may be determined based on the number of second distinguishing attribute items and the similarity between multiple data templates.

[0046] When there are multiple data templates, there may be differences in the similarity between each data template and the data template that needs to be newly configured, or it can be understood that when different data templates are used as the first data template, the number of the same target attribute items between the first data template and the second data template may also be different.

[0047] In some embodiments, the data processing method may further include: comparing at least two data templates with the second data template to obtain the same number of target attribute items; setting the data template with the maximum number of target attribute items as the first data template. The data template with high similarity to the second data template has a larger number of target attribute items. By comparing different data templates with the second data template in advance, the data template that can realize more parsing rule reuse can be quickly identified to improve efficiency. The maximum number of can be obtained by comparing the number of target attribute items after obtaining the number of target attribute items, or by the ratio of the number of target attribute items to the total number of attribute items of the second data template. The ratio can more intuitively represent the degree of similarity between each data template and the second data template. When the similarity between the data template with the maximum number of target attribute items and the second data template reaches the first threshold, the parsing rules of the third data template can be further reused. Parsing rules can also be set separately for it.

[0048] In some implementations, all data templates may be compared with the second data template, or part of the data template may be compared with the second data template, or the comparison may be performed in a predetermined order, and when the number of identical target attribute items obtained by comparison is greater than a threshold, the data template is used as the first data template without further comparison.

[0049] In some implementations, the distinguishing attribute items may be compared with each data template, and the data template having the largest number of distinguishing attribute items may be set as the third data template. The attribute items of the third data template may each have a third mapping tag that matches the third parsing rule, and a third mapping tag may be added to the distinguishing data item in the second data template that is the same as the third data template, and the distinguishing data item may match the data parsed based on the third parsing rule based on the third mapping tag.

[0050] In some implementations, in the second data template, attribute items that are different from those in the first data template may be configured with separate parsing rules.

[0051] In some embodiments, the attribute item of the first data template includes a first attribute identifier, and the attribute item of the second data template includes a second attribute identifier. In the step of comparing the first data template with the second data template to obtain the same target attribute item, the step includes: comparing the first attribute identifier with the second attribute identifier; when the first attribute identifier corresponds to the second attribute identifier, taking the attribute item as the target attribute item. The first attribute identifier corresponds to the second attribute identifier, and the first attribute identifier and the second attribute identifier may be the same. Alternatively, the first attribute identifier and the second attribute identifier may have a unique association relationship based on a preset condition. For example, the first attribute identifier and the second attribute identifier are both "full-time staff name", or the first attribute identifier is "full-time staff name" and the second attribute identifier is "full-time staff name", and the preset condition is that "full-time staff name" and "full-time staff name" have a unique association relationship.

[0052] In some embodiments, the first parsing rule can configure a specified label for the source data when the acquired source data meets a preset condition; wherein the specified label corresponds to the mapping label. The source data can be stored raw data, or it can be data processed based on a preset raw data processing rule. The raw data processing rule can be determined based on a data template. If the raw data is the name of a full-time staff member, and the data template attribute item includes the name of the full-time staff member, the raw data can be used as the source data. For example, when the raw data is the full-time staff member's surname and first name, it is first necessary to derive the full-time staff member's name and use the full-time staff member's name as the source data.

[0053] In some embodiments, the designated tag corresponds to the mapping tag, and the designated tag and the mapping tag may be the same. In some embodiments, the designated tag corresponds to the mapping tag, and the designated tag and the mapping tag may be a preset tag pair and have a unique association. For example, the designated tag and the mapping tag are both "full-time staff name", or the designated tag is "full-time staff name" and the mapping tag is "full-time staff name", and the preset condition is that "full-time staff name" and "full-time staff name" have a unique association.

[0054] In some embodiments, the first parsing rule can add a specified label to the source data when the acquired source data meets the preset conditions. Since the specified label corresponds to the mapping label, the source data with the specified label added can be mapped to the attribute item of the data template. For example, the source data includes a "full-time staff name" column, and the first row of data in the column is "Zhang San". The first data template includes the "full-time staff name" attribute item, and the mapping label of the attribute item is "full-time name". The preset condition is the judgment condition for adding labels to the source data, such as adding the "full-time name" specified label to the full-time staff name. The source data "Zhang San" adds the specified label "full-time name" based on the first parsing rule. "Zhang San" can map "Zhang San" to the "full-time staff name" attribute item based on the correspondence between the specified label "full-time name" and the "full-time name" mapping label of the data template.

[0055] In some embodiments, the first parsing rule includes an original data processing rule, so as to realize the processing of the original data to obtain the source data, and can configure a specified label for the source data when the source data meets the preset conditions. Similarly, the source data parsed based on the first parsing rule can be mapped to the target attribute item in the second data template.

[0056] See also Figure 4 The present specification provides a data processing method in some embodiments. In some embodiments, the data processing method may be executed by a terminal. The data processing method may include the following steps.

[0057] Step S210: receiving a second data file generation request for a second data template sent by a terminal, wherein the second data template includes a plurality of attribute items.

[0058] In some embodiments, the terminal may be a terminal device that can provide an operation interface for the user and implement input and output based on the user's operation. Sending the second data file generation request may be executed by a specific application, and the application may run on the terminal device. The terminal may be a computer or a notebook. The user accesses a specific application, such as opening the drug vigilance system, selecting a pre-set data template, such as selecting the second data template, and clicking the button to generate the drug vigilance system master file. Based on the user's operation, the terminal sends the second data file generation request to the server.

[0059] Step S220: Generate a request to obtain second source data based on the second data file.

[0060] In some implementations, the original data may be stored with a data identifier associated with the data template, so that the original data is obtained when a request to generate a second data file is received.

[0061] In some embodiments, the second source data may be original data, or data processed based on the original data by data processing rules. The data processing rules have been determined when the data template is set, and have a corresponding relationship with the data template, so that when a request to generate a second data file is received, the second source data can be obtained according to the pre-set data processing rules.

[0062] Step S230: Setting a designated tag for the second source data in the second source data that matches the first parsing rule; wherein the attribute items in the first data template respectively have mapping tags that match the first parsing rule, the attribute items in the second data template at least include some mapping tags that match the first parsing rule, and the designated tag corresponds to the mapping tag.

[0063] In some embodiments, the data template has a corresponding parsing rule, and the second source data is the source data that matches the second data template. Furthermore, the attribute item is configured with a parsing rule, and the second source data is parsed based on the parsing rule when generating the second data file. The parsed source data can be mapped to the attribute item of the data template.

[0064] In some embodiments, the attribute item in the first data template has a mapping label that matches the first parsing rule, or in other words, the first parsing rule is a parsing rule set according to the first data template, and the source data required by the first data template can be parsed using the first parsing rule, so that the parsed source data can be mapped to the first data template to form a first data file.

[0065] In some embodiments, when configuring the second data file, the attribute items of the second data template are compared with the first data template to obtain the same target attribute items, and the same mapping tags as the target attribute items in the first data template are added to the target attribute items in the second data template, so that the target attribute items in the second data template can map the data parsed based on the first parsing rules based on the mapping tags.

[0066] In some embodiments, the target attribute item in the second data template includes a mapping tag that matches the first parsing rule, and a specified tag is set for the second source data that matches the first parsing rule, and the specified tag corresponds to the mapping tag, so that the target attribute item in the second data template can match the second source data with the specified tag based on the mapping tag.

[0067] In some implementations, the designated tag corresponds to the mapped tag, and the designated tag and the mapped tag may be the same, or the designated tag and the preset tag may be a tag pair having a unique association relationship based on a preset rule.

[0068] In some embodiments, the attribute items in the second data template at least include some mapping tags that match the first parsing rule. It can be understood that the second data template and the first data template have the same attribute items, so the first parsing rule can be reused for the same attribute items. A specified tag is set for the second source data that matches the first parsing rule in the second source data, and the specified tag corresponds to the mapping tag, thereby realizing the reuse of parsing rules for the same attribute items between multiple data templates and improving the efficiency of template configuration.

[0069] In some embodiments, the data processing method may further include: setting a second designated tag for the second source data matching the second parsing rule; wherein the distinguishing attribute items in the second data template respectively have second mapping tags matching the second parsing rule, the distinguishing attribute items are different from the attribute items of the first data template, and the second designated tag corresponds to the second mapping tag. It can be understood that the second data template and the first data template have different attribute items, or distinguishing attribute items, and the distinguishing attribute items cannot directly reuse the first parsing rule when matching the source data. The distinguishing attribute items respectively have second mapping tags matching the second parsing rule. Therefore, when the source data of the distinguishing attribute items are parsed, the second parsing rule is matched, and the second parsing rule implements the second source data to set the second designated tag, and the second designated tag corresponds to the second mapping tag, thereby realizing data mapping of the distinguishing attribute items.

[0070] In some embodiments, the data processing method may further include: the second source data has a source data identifier and a source data value; the attribute item of the second data template has a second attribute identifier and a second attribute value; the method further includes: when the specified label corresponds to the mapping label, the source data value replaces the second attribute value. For example, the second source data is the patient's personal basic information, such as age 20 years old, the source data identifier is age and the source data value is 20, the second source data matches the first parsing rule, and is parsed by the first parsing rule and is set with a specified label "age". The second attribute identifier of the attribute item of the second data template is age, and the second attribute value is a null value. The attribute item has a mapping label "age", and the preset rule sets the specified label "age" and the mapping label "age" to have a unique association relationship, so that the specified label corresponds to the mapping label, and the source data value 20 replaces the null value of the second attribute.

[0071] In some cases, the original data may be missing or incomplete. For example, in the early stage of establishing a pharmacovigilance system, less data was collected, so some attribute items were missing data when exporting data files.

[0072] In some embodiments, the data processing method may further include: when the value of the attribute item with a mapping tag in the second data file is the second attribute value, setting the attribute item value to a null value; and feeding back the second data file to the terminal. The value of the attribute item with a mapping tag in the second data file is the second attribute value, which means that the attribute item has not completed data mapping, so the second attribute value is set to a null value to avoid the default value in the second data file being mistaken for the actual value. The second attribute value can be a null value or a non-null value. When the second attribute value is a null value, setting the attribute item value to a null value can be understood as maintaining the attribute item value unchanged.

[0073] In some embodiments, the data processing method may further include: setting a second designated tag for the second source data matching the second parsing rule; wherein the distinguishing attribute items in the second data template respectively have second mapping tags matching the second parsing rule, the distinguishing attribute items are different from the attribute items of the first data template, and the second designated tag corresponds to the second mapping tag. When the second data template includes attribute items different from the first data template, or the second data template has distinguishing attribute items, the first parsing rule cannot be reused. The second parsing rule is configured for the second source data by configuring the second mapping tag matching the second parsing rule through the distinguishing attribute item, and when the second source data is parsed according to the second parsing rule, the second designated tag is added to the second source data. Then, the distinguishing attribute items in the second data template can map the data parsed based on the second parsing rule based on the second mapping tag, thereby realizing the formation of the second data file.

[0074] In some embodiments, the data processing method may further include: the second source data has a source data identifier and a source data value; the attribute item of the second data template has a second attribute identifier and a second attribute value; the method further includes: when the second designated tag corresponds to the second mapping tag, the source data value replaces the second attribute value. The correspondence between the second designated tag and the second mapping tag replaces the second attribute value of the attribute item in the second data template with the second mapping tag with the source data value of the second source data set with the second designated tag, realizes data mapping of attribute items different from the first data template, and forms a second data file.

[0075] See also Figure 5. The embodiment of this specification also provides a data processing device. The data processing device 300 includes: a target attribute acquisition module 310 and a mapping label adding module 320. The target attribute acquisition module is used to compare the first data template with the second data template to obtain the same target attribute item; wherein the first data template and the second data template respectively include multiple attribute items; the attribute item of the first data template has a mapping label that matches the first parsing rule; the mapping label adding module is used to add the same mapping label as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item in the second data template can map the data parsed based on the first parsing rule based on the mapping label.

[0076] For the specific definition of the data processing device, please refer to the definition of the data processing method above, which will not be repeated here. Each module in the above data processing device can be implemented in whole or in part by software, hardware and a combination thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0077] See also Figure 6 . The embodiment of this specification also provides a data processing device. The data processing device 400 includes: a request receiving module 410, a source data acquisition module 420, and a source data parsing module 430. The request receiving module is used to receive a second data file generation request for a second data template sent by a terminal, wherein the second data template includes multiple attribute items; the source data acquisition module is used to obtain the second source data based on the second data file generation request; the source data parsing module is used to set a specified label for the second source data matching the first parsing rule; wherein the attribute item in the first data template has a mapping label that matches the first parsing rule, the attribute item in the second data template at least partially includes a mapping label that matches the first parsing rule, and the specified label corresponds to the mapping label.

[0078] For the specific definition of the data processing device, please refer to the definition of the data processing method above, which will not be repeated here. Each module in the above data processing device can be implemented in whole or in part by software, hardware and a combination thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0079] See also Figure 7. In some embodiments, a computer device is provided, which may be a terminal. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected via a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be achieved through WIFI, an operator network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a clinical trial data conversion method is implemented. The display screen of the computer device may be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device may be a touch layer covering the display screen, or a button, a trackball or a touchpad provided on the housing of the computer device, or an external keyboard, touchpad or mouse, etc.

[0080] Those skilled in the art will understand that Figure 7 The structure shown in the figure is only a block diagram of a part of the structure related to the implementation mode of this specification, and does not constitute a limitation on the computer device to which the implementation mode of this specification is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

[0081] In some embodiments, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the method in the above embodiment is implemented when the processor executes the computer program.

[0082] In some embodiments, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the method in the above embodiment is implemented.

[0083] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned implementation methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the implementation methods of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the implementation methods of this specification may include at least one of non-volatile and volatile memory. Non-volatile memory may include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0084] The technical features of the above embodiments may be arbitrarily combined. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0085] The above descriptions are only some of the implementation methods in this specification and are not intended to limit this specification. Any modifications, equivalent substitutions, etc. made within the spirit and principles of this specification should be included in the scope of disclosure of this specification.

Claims

1. A data processing method, characterized in that: include: Comparing the first data template with the second data template to obtain the same target attribute item; wherein the first data template and the second data template respectively include multiple attribute items; the attribute item of the first data template has a mapping tag matching the first parsing rule; Adding the same mapping tag as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item in the second data template can map the data parsed based on the first parsing rule based on the mapping tag; Among them, it also includes: Comparing the first data template with the second data template to obtain distinguishing attribute items in the second data template that are different from those in the first data template; A second mapping tag matching a second parsing rule is configured for the distinguishing attribute item; wherein the second parsing rule is different from the first parsing rule.

2. The method according to claim 1, characterized in that Also includes: Comparing the first data template with the second data template to obtain distinguishing attribute items in the second data template that are different from those in the first data template; Comparing the distinguishing attribute item with a third data template to obtain the same second target attribute item, wherein the attribute item of the third data template has a third mapping tag matching a third parsing rule; For the second target attribute item in the second data template, add a third mapping tag that is the same as the second target attribute item in the third data template, so that the second target attribute item in the second data template can map the data parsed based on the third parsing rule based on the third mapping tag.

3. The method according to claim 1, characterized in that: Also includes: Compare at least two data templates with the second data template respectively to obtain the number of identical target attribute items; The data template having the largest number of target attribute items is set as the first data template.

4. The method according to claim 1, characterized in that The attribute item of the first data template includes a first attribute identifier, and the attribute item of the second data template includes a second attribute identifier. The step of comparing the first data template with the second data template to obtain the same target attribute item includes: comparing the first attribute identifier with the second attribute identifier; In the case where the first attribute identifier corresponds to the second attribute identifier, the attribute item is used as the target attribute item.

5. The method according to claim 1, characterized in that The first parsing rule can add a specified tag to the source data when the acquired source data meets a preset condition; wherein the specified tag corresponds to the mapping tag.

6. A data processing method, characterized in that: include: Receiving a second data file generation request for a second data template sent by a terminal, wherein the second data template includes a plurality of attribute items; Generate a request to obtain second source data based on the second data file; Setting a designated tag for the second source data matching the first parsing rule; wherein the attribute item in the first data template has a mapping tag matching the first parsing rule, the attribute item in the second data template at least partially includes the mapping tag matching the first parsing rule, and the designated tag corresponds to the mapping tag; Among them, it also includes: A second designated label is set for the second source data matching the second parsing rule; wherein the distinguishing attribute items in the second data template respectively have second mapping labels matching the second parsing rule, the distinguishing attribute items are different from the attribute items of the first data template, and the second designated label corresponds to the second mapping label.

7. The method according to claim 6, characterized in that The second source data has a source data identifier and a source data value; the attribute item of the second data template has a second attribute identifier and a second attribute value; the method further includes: In the case where the designated label corresponds to the mapping label, the second attribute value is replaced by the source data value.

8. The method according to claim 7, characterized in that The method further comprises: In the case where the value of the attribute item having the mapping tag in the second data file is the second attribute value, setting the value of the attribute item to a null value; The second data file is fed back to the terminal.

9. The method according to claim 6, characterized in that The second source data has a source data identifier and a source data value; the attribute item of the second data template has a second attribute identifier and a second attribute value; the method further includes: When the second designated tag corresponds to the second mapping tag, the second attribute value is replaced by the source data value.

10. A data processing device, characterized in that: include: A target attribute acquisition module, used to compare the first data template with the second data template to obtain the same target attribute item; wherein the first data template and the second data template respectively include multiple attribute items; the attribute item of the first data template has a mapping tag matching the first parsing rule; a mapping label adding module, configured to add the same mapping label as the target attribute item in the first data template to the target attribute item in the second data template, so that the target attribute item in the second data template can map the data parsed based on the first parsing rule based on the mapping label; Wherein, the device is also used for: Comparing the first data template with the second data template to obtain distinguishing attribute items in the second data template that are different from those in the first data template; A second mapping tag matching a second parsing rule is configured for the distinguishing attribute item; wherein the second parsing rule is different from the first parsing rule.

11. A data processing device, characterized in that: include: A request receiving module, configured to receive a second data file generation request for a second data template sent by a terminal, wherein the second data template includes a plurality of attribute items; A source data acquisition module, configured to generate a request to acquire second source data based on the second data file; a source data parsing module, configured to set a designated tag for second source data matching a first parsing rule; wherein an attribute item in a first data template has a mapping tag matching the first parsing rule, an attribute item in the second data template at least partially includes a mapping tag matching the first parsing rule, and the designated tag corresponds to the mapping tag; Wherein, the device is also used for: A second designated label is set for the second source data matching the second parsing rule; wherein the distinguishing attribute items in the second data template respectively have second mapping labels matching the second parsing rule, the distinguishing attribute items are different from the attribute items of the first data template, and the second designated label corresponds to the second mapping label.

12. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that: When the processor executes the computer program, the method according to any one of claims 1 to 9 is implemented.

13. A computer-readable storage medium having computer program instructions stored thereon, characterized in that: When the computer program instructions are executed by a processor, the method according to any one of claims 1 to 9 is implemented.

Citation Information

Patent Citations

  • Data file conversion method and apparatus

    CN101216835A

  • Method and device for generating mobile report form

    CN105808538A