CN114201615B - Scientific research data change review method and server based on data snapshot - Google Patents
Scientific research data change review method and server based on data snapshot Download PDFInfo
- Publication number
- CN114201615B CN114201615B CN202111627078.2A CN202111627078A CN114201615B CN 114201615 B CN114201615 B CN 114201615B CN 202111627078 A CN202111627078 A CN 202111627078A CN 114201615 B CN114201615 B CN 114201615B
- Authority
- CN
- China
- Prior art keywords
- data
- field
- scientific
- scientific research
- modification
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/36—Creation of semantic tools, e.g. ontology or thesauri
- G06F16/374—Thesaurus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/128—Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02A—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
- Y02A90/00—Technologies having an indirect contribution to adaptation to climate change
- Y02A90/10—Information and communication technologies [ICT] supporting adaptation to climate change, e.g. for weather forecasting or climate simulation
Abstract
The invention discloses a scientific research data change review method and a server based on a data snapshot. When a command for storing the scientific form is received, unstructured storage is carried out on all data of the scientific form in a key value pair mode, when a command for reviewing historical data is received, data of a target patient are traversed to obtain all field IDs and field names, then a table structure of a data trace table is built according to all field IDs and field names, unstructured data of the target patient are analyzed, corresponding historical data are filled into the table structure of the data trace table according to a key value corresponding relation to obtain the data trace table, the technical effect that data in an intermediate stage can be checked at any time is achieved, the problem that one step is needed to deduce the historical data of a certain stage is queried in the prior art is solved, and the efficiency of data review is improved.
Description
Technical Field
The embodiment of the invention relates to an electronic data processing technology, in particular to a scientific research data change review method and a server based on data snapshot.
Background
In the process of conducting scientific research projects and researching patient data, medical researchers sometimes modify the patient data according to the actual condition of the patient so as to correct data entry errors; or modifying the descriptive field names of the patient data to make the field names of the derived data more reasonable; or adding and deleting partial fields according to the research requirement of the scientific research project so as to obtain the patient data required by the research more accurately.
Because sample data of scientific and strict scientific and research projects must be changed and modified at will, data mark needs to be carried out on all data changes, the conventional scientific and research system generally records each changed field and field data before and field data after each change in a patient data change record table one by constructing a patient data change record table, and when a scientific and research person needs to review historical data, only the data change condition of the historical changed field can be displayed.
When data of a certain stage is required to be acquired, the patient data before the last modification is calculated and generated according to the current patient data and the last modification record in the patient data change record table, then the patient data before the last modification and the last modification record in the patient data change record table are calculated and generated, so that the patient data of the required stage is obtained, when the number of times of modification of the patient data is large, the data change review calculation logic becomes very complex, and because each field change of each modification is required to be recorded in the record table one by one, a large amount of data lines exist for the patient data with the large number of modification times, a large amount of storage space is occupied, and a large amount of time is required to be consumed for each review of early-stage data.
Disclosure of Invention
The invention provides a scientific research data change review method based on a data snapshot, which reduces the occupation of storage space by unstructured storage of all data of a scientific research form in a key value pair mode, and solves the technical problem that historical data review is too complex in the prior art by establishing a data trace table.
The embodiment of the invention provides a scientific research data change review method based on a data snapshot, which comprises the following steps:
when a command for storing the scientific form is received, unstructured storage is carried out on all data of the scientific form in a key value pair mode;
when a command for reviewing historical data is received, traversing the data of the target patient to obtain all field IDs and field names;
and establishing a table structure of a data mark-keeping table according to all the field IDs and field names, analyzing unstructured data of a target patient, and filling corresponding historical data into the table structure of the data mark-keeping table according to the corresponding relation of key values to obtain the data mark-keeping table.
Preferably, the method for reviewing scientific research data change based on data snapshot further comprises:
when receiving a command for storing the scientific form, storing modification execution information of the scientific form; the modification execution information includes at least: one of modification time, modifier and modification reason;
when a command for reviewing historical data is received, acquiring the modification execution information;
establishing a table structure of a data mark table containing the modification execution information according to the modification execution information, all field IDs and field names;
and filling the data corresponding to the modification execution information, the field ID and the data corresponding to the field name into a table structure of a data mark table containing the modification execution information to obtain the data mark table containing the modification execution information.
Preferably, the method for reviewing scientific research data change based on data snapshot further comprises:
and when a command for storing the scientific form is received, storing the modification execution information in the form of structured data, and associating the modification execution information with all data of the scientific form which is stored unstructured in the form of key value pairs.
Preferably, in the method for reviewing the variation of scientific research data based on data snapshot, when a command for reviewing historical data is received, unstructured data of a target patient is traversed, and all field IDs and field names are obtained.
Preferably, the method for reviewing the variation of scientific research data based on the data snapshot further comprises a field dictionary, wherein the field dictionary stores a field ID and a field name of the scientific research form, and the method further comprises:
when a command for storing a scientific research form is received, searching whether the field dictionary contains all field IDs and field names of the scientific research form, and if not, updating the field dictionary according to the field IDs and field names which are not contained;
and when a command for inquiring historical data is received, traversing the field dictionary data of the target patient to obtain all field IDs and field names.
Preferably, the method for reviewing scientific research data change based on data snapshot, the field dictionary further includes a field identification code, the field identification code is used for identifying the field ID and the field name, and the method further includes:
when a command for storing a scientific form is received, unstructured storage is carried out on the field identification code and all data of the scientific form in a key value pair mode;
when a command for inquiring historical data is received, traversing field dictionary data of a target patient to obtain all field IDs, field names and field identification codes;
establishing a table structure of a data mark table according to all the field IDs and field names;
and analyzing unstructured data of the target patient, and filling corresponding historical data into a table structure of the data mark table according to the corresponding relation between the field identification code, the field ID and the field name to obtain the data mark table.
Preferably, in the method for reviewing scientific research data change based on data snapshot, all data of the scientific research form are stored in an unstructured mode in the form of key value pairs, and the unstructured storage mode generates corresponding Json program sentences.
Preferably, the method for reviewing scientific research data change based on data snapshot further comprises:
and comparing two adjacent pieces of historical data in the data mark table in pairs, and identifying later modified data.
Preferably, in the method for reviewing the variation of the scientific research data based on the data snapshot, the data mark table is displayed in a manner of retaining the scientific research form, and the display manner comprises a floating window and/or a newly built page.
In a second aspect, an embodiment of the present invention further provides a server, where the server includes: the system comprises a memory, a processor and a scientific research data change review program which is stored in the memory and can run on the processor, wherein the scientific research data change review program based on the data snapshot realizes the steps of the scientific research data change review method based on the data snapshot when being executed by the processor.
The invention stores all data of the scientific research form in an unstructured way through the key value pair, reduces the space occupation to a certain extent, solves the problem that the historical data of a certain stage needs to be deduced step by establishing the data trace table in the prior art, improves the comprehensiveness and accuracy of data review and greatly improves the data review efficiency on the premise of not improving the storage space occupation.
Drawings
FIG. 1 is a flowchart of an embodiment of a method for reviewing changes in scientific research data based on a data snapshot according to the present invention;
FIG. 2 is a flowchart of another embodiment of a review method for data changes in a scientific research based on a data snapshot according to the present invention;
FIG. 3 is a flowchart of another embodiment of a review method for data changes in a scientific research based on a data snapshot according to the present invention;
fig. 4 is a schematic diagram of a server structure according to another embodiment of the data snapshot-based research data change review method of the present invention.
Detailed Description
The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.
Fig. 1 is a flowchart of a method for reviewing changes in scientific research data based on data snapshot, which is provided in an embodiment of the present invention, and the embodiment is applicable to a data recording scenario of inputting, modifying and deleting patient data by medical researchers in the process of performing scientific research projects and researching patient data, and the method can be executed by a computing device with a storage function, and specifically includes the following steps:
s100, when a command for storing the scientific research form is received, unstructured storage is carried out on all data of the scientific research form in a key value pair mode;
it is easy to understand that when new patient data needs to be recorded, an operator opens a new blank scientific form to fill in, a command for saving the scientific form is sent by the operator, when the rear end receives the new blank scientific form, the patient data is stored in a corresponding database table in a structured manner according to the content filled in by the operator, and meanwhile, the field ID and the corresponding data are saved in a key value pair manner in an unstructured manner, for example, the field corresponding to the field ID is "sex", the corresponding data are saved in a key value pair manner in an unstructured manner, and when the patient data need to be modified, the operator calls the scientific form of the patient, after modification, clicking the save button again, and when the rear end receives a command for saving the scientific research form, saving all field IDs and corresponding data again, and comparing the data of the past times for the modified part, for example, when the data of which the field is 'sex' is modified from 'female' to 'male', unstructured saving is carried out on the 'sex' and the 'female' in the form of key value pairs, and when the data of which the data is saved last time can be marked with different colors or the 'male-female' is displayed, wherein the modification process is not necessarily embodied in the form of '-', the right arrow, the number larger than the number, the blank space and the like.
It is worth emphasizing that, due to the association between field ID and field name, all data of the scientific form is included in the form of key value pairs: when the field ID is too complex, a field identification code may be used instead of the field ID, and thus, there may be a case where the field identification code is used as a key-to-data key-to-key.
S200, when a command for reviewing historical data is received, traversing the data of the target patient to obtain all field IDs and field names;
it should be noted that, when the history data of the patient is queried, the history data is usually displayed in order to check the modification condition of the data of the patient, so that the data of the target patient needs to be traversed to obtain all the data of the patient, wherein the field ID and the field name are the category to which the patient data belongs, and because the association between the data and the field ID is already established during the storage, the obtained data has a corresponding relationship with the field ID, and because the field and the field ID have a one-to-one correspondence, the corresponding relationship between the field and the field ID is stored in the unstructured data and can also be stored in the field dictionary, and the traversing process comprises at least one condition of traversing the unstructured data, traversing the field dictionary data and traversing the structured data.
S300, establishing a table structure of a data mark-keeping table according to all field IDs and field names, analyzing unstructured data of a target patient, and filling corresponding historical data into the table structure of the data mark-keeping table according to a key value corresponding relation to obtain the data mark-keeping table.
It is emphasized that the record table needs to be built to contain field names to represent the value of the data, while the data trace table needs to contain all field names for the integrity of the data. Therefore, in this embodiment, a table structure of the data trace table is established according to the traversed field names, and then data obtained by analyzing unstructured data of the target patient is filled into the data trace table, so that the established data trace table contains all data and variation conditions of the target patient, data in any intermediate process can be intuitively displayed, the data of the data trace table can be ordered according to modification time, modification data can be marked in different colors, the variation conditions of data in the past can be comprehensively and intuitively reflected, and the reading efficiency of the data trace table is improved.
According to the technical scheme, through the unstructured storage mode of all data of the scientific research form in the form of key value pairs, the technical problems that in the prior art, data deducing logic is complex, time consumption is long, server resource consumption is large and data review efficiency is low are solved, meanwhile, the stored data are displayed through the establishment of the data trace table, the situation of historical data change can be comprehensively and intuitively reflected, the effect of displaying all historical data is achieved, the review efficiency of the historical data is improved, the accuracy of acquired data is improved, and user experience is improved.
Referring to fig. 2, the method further comprises:
s400, when a command for storing the scientific research form is received, storing modification execution information of the scientific research form; the modification execution information includes at least: one of modification time, modifier and modification reason;
it should be noted that, since the scientific research form only includes patient data, and in order to reflect the details of each modification, information such as a modifier, modification time and modification reason need to be reflected, so that the three information need to be saved, the modifier can obtain according to the logged account, the modification time can be directly obtained from the network, and the modification reason needs to be filled in by the modifier in the modification process.
It is easy to understand that for the latest data, the latest data is required to be frequently referred to, so that the latest unstructured file is saved in the database table, the latest unstructured file is prevented from being searched for each reference, the latest unstructured file is converted into a scientific research form, the additional calculation amount is consumed, the reading speed of the scientific research form is reduced, the latest scientific research form data of all patients are stored in the database table, and each row of patient data in the patient data table corresponds to the patient data in one patient scientific research form; when the scientific research form of the target patient needs to be read, all data of the row of the patient in the database form is only needed to be selected and loaded to the scientific research form through the script, so that the time consumption of the data retrieval and loading of the patient is greatly reduced, and the data loading speed of the scientific research form is improved, wherein the script loading process specifically comprises the following steps: the form page is bound with a corresponding data source, the format of the form page is generated in the form page generating process, and corresponding data in the data source is loaded into the corresponding position of the form page according to the patient ID and the bound data source.
S500, acquiring the modification execution information when receiving a command for reviewing historical data;
it should be noted that the modification execution information may be stored in a structured or unstructured manner in a corresponding unstructured file, where the modifier, the modification time, the modification reason, and the detailed data have a correspondence relationship after being stored.
S600, establishing a table structure of a data mark table containing the modification execution information according to the modification execution information, all field IDs and field names;
it is worth emphasizing that in the above example, the header of the data trace table containing the modification execution information includes all field names, modifier, modification time and modification reason.
And S700, filling the data corresponding to the modification execution information, the field ID and the data corresponding to the field name into a table structure of a data mark table containing the modification execution information, and obtaining the data mark table containing the modification execution information.
It is easy to understand that after the table structure is built, the data of the target patient can be filled in according to the association relation stored in the structuring, in the above example, the data sorting mode of the data trace table containing the modification execution information can be sorted according to the modification time, and only the data meeting the screening condition can be displayed by setting the screening condition.
Referring to fig. 3, the method for reviewing scientific research data change based on data snapshot further includes:
and S410, when receiving a command for storing the scientific research form, storing the modification execution information in the form of structured data, and associating the modification execution information with all data of the scientific research form which is stored in an unstructured mode in the form of key value pairs.
It should be emphasized that the modification execution information may be stored in a structured manner with the corresponding unstructured file, for example, when stored in a record table manner, the header is a modifier, a modification time, a modification reason and detailed data, where the detailed data may be a text segment, a picture, a filename or a hyperlink of the unstructured file.
Specifically, according to the scientific research data change review method based on the data snapshot, when a command for reviewing historical data is received, unstructured data of a target patient is traversed, and all field IDs and field names are obtained.
Specifically, the method further comprises a field dictionary, wherein the field dictionary stores a field ID and a field name of the scientific research form, and the method further comprises:
when a command for storing a scientific research form is received, searching whether the field dictionary contains all field IDs and field names of the scientific research form, and if not, updating the field dictionary according to the field IDs and field names which are not contained;
and when a command for inquiring historical data is received, traversing the field dictionary data of the target patient to obtain all field IDs and field names.
It should be emphasized that, because the field names may be adjusted in some cases because the description is not accurate enough, when the data trace table is generated after adjustment, two columns of data may be generated, which is not beneficial to reading, so in this embodiment, whether the field names are the same column data or not is determined according to the field ID and the field names, the field names in the latest data are the field names of the modified data according to the modification time, and the field names displayed in the data trace table are used as the field names, in this embodiment, the modification process of the field names may also be displayed, for example, when the "modifier" is adjusted to "operator", the "modifier-operator" word may be added in the column of the "operator" in the first current in the data trace table, and the separator is added to separate from the original data.
Specifically, the field dictionary further includes a field identification code, where the field identification code is used to identify the field ID and the field name, and the method further includes:
when a command for storing a scientific form is received, unstructured storage is carried out on the field identification code and all data of the scientific form in a key value pair mode;
it is easy to understand that, because the field name may be more complex in reading, and the field ID also has a more complex problem due to its generation rule, and more space is occupied when unstructured storage is performed, so the manner of introducing the field identification code in this embodiment replaces the field name and the field ID, and the space occupation situation when unstructured data is stored is greatly reduced.
When a command for inquiring historical data is received, traversing field dictionary data of a target patient to obtain all field IDs, field names and field identification codes;
it should be noted that, the corresponding relationship among the field ID, the field name and the field identification code is stored in the field dictionary, the field name and the field ID may be recorded only once, a large amount of field identification codes are used in the unstructured data for recording, and then the corresponding field name and field ID are queried according to the field dictionary, so that the occupation of the space is further reduced.
Establishing a table structure of a data mark table according to all the field IDs and field names;
and analyzing unstructured data of the target patient, and filling corresponding historical data into a table structure of the data mark table according to the corresponding relation between the field identification code, the field ID and the field name to obtain the data mark table.
It should be emphasized that, after the field names are queried through the identification codes and the field dictionary, the table structure is built and the data is filled in the same manner as the above embodiments, which has all the technical effects of the above embodiments and is not described in detail herein.
Specifically, unstructured storage is carried out on all data of the scientific research form in the form of key value pairs, and the unstructured storage mode is used for generating corresponding Json program sentences.
It should be noted that, in this embodiment, json is used as an unstructured storage mode, and the data is stored and represented in a text format completely independent of the programming language. The method is easy to read by people, is easy to analyze and generate by machines, has higher effective data rate compared with Json and xml, and can further reduce the space occupation of storing the data snapshot, wherein the data snapshot is a data snapshot of a scientific research form and all data of the scientific research form.
It is easy to understand that when the Json program statement is introduced into the above example as an unstructured storage manner, a new Json program statement is generated each time the scientific form is saved, each Json program statement represents a modifier, and at a certain modification time, all patient data after the patient scientific form is modified and changed due to a certain modification reason, so each Json program statement represents a line of data in the data trace comparison table. The modification execution information of the modifier, the modification time, the modification reason and the like can be stored in one-to-one correspondence with the Json program statement independently of the Json program statement generated by each modification, and the modification execution information can be directly contained in the Json program statement when the Json program statement is generated, so that the storage space is saved.
When the modifier, the modification time, the modification reason and the corresponding Json program statement are stored in a structured manner, the Json program statement is stored in a record table manner, and the method has the advantages that the speed of acquiring the Json program statement according to the modifier, the modification time and the modification reason is faster and more accurate. Meanwhile, when in structured storage, the patient ID can be stored as structured data and corresponds to a corresponding Json program statement. The method has the advantages that the speed of acquiring all Json program sentences of the target patient according to the patient ID is faster and more accurate. And the Json program statement is used as a data snapshot to save all data of the patient scientific research form, so that the table structure of the record table is simplified, the data volume is greatly reduced, the complexity of the record table is greatly reduced, all historical patient data can be obtained by directly analyzing the Json program statement in the record table, the data review mode is simple and convenient, the occupied consumption of server resources is small, the review result presentation time is short, the response is quick, and the overall user experience is good.
Specifically, the method further comprises the following steps:
and comparing two adjacent pieces of historical data in the data mark table in pairs, and identifying later modified data.
It is easy to understand that when the data of the scientific research form is recorded by using the Json program statement, two adjacent pieces of history data are two Json files with adjacent modification time of the target patient, the later modified data are obtained by comparing the data stored in the Json file with the later modification time with the data stored in the Json file with the earlier modification time, and the reading efficiency of the data is greatly improved by identifying the data.
Specifically, the data mark-keeping table is displayed in a manner of keeping the scientific research form, wherein the display manner comprises a suspension window and/or a newly built page.
It is easy to understand that, after the data mark-keeping table is opened, the content in the data mark-keeping table can be better understood according to the data of the scientific research table, in this embodiment, in order to realize the function of mutual comparison, when the floating window is used for displaying, the position of the floating window can be draggable, and the background scientific research table can be scrolled up and down, an operator can drag the floating window to view the shielding content, and view the content in the scientific research table which is not displayed on the current page in a mode of scrolling up and down.
According to the embodiment, a technical scheme is perfected by disclosing a detailed specific mode of establishing the data trace table, the data review efficiency is further improved, meanwhile, a detailed process of saving and inquiring information by using Json program sentences is disclosed, space occupation is reduced, the technical scheme is further perfected by disclosing different forms of the data trace table, the integrity of recorded data is improved, the convenience of data review is improved, all modification and change of patient data in a patient scientific research form by medical research personnel can be comprehensively recorded and reviewed, the latest and more reasonable field names of the patient scientific research form can be automatically adopted for describing historical data, meanwhile, the change content of part of fields added and deleted in the history modification process of the patient scientific research form can be comprehensively recorded and reviewed, when the historical data is displayed, compared with the previous version of data, the changed data is marked with colors to prompt a user; the method has the advantages that the element increase and decrease conditions, the data change conditions, the multiple data change relations and the like on the form can be more intuitively and accurately checked, so that the data recording and review are more comprehensive and accurate, the requirement that the reality of the data change is questioned by referring to other data at the time when scientific researchers review historical data is fully met, the patient data after each modification change can be completely described and stored by adopting one Json file, the technical problem that a plurality of lines of data storage are required to be occupied and a large amount of storage space is occupied in the prior art is avoided, and the storage space for storing modification change records is greatly saved.
Fig. 4 is a schematic structural diagram of a server according to an embodiment of the present invention, where the server includes a processor 70, a memory 71, an input device 72, and an output device 73; the number of processors 70 in the server may be one or more, one processor 70 being taken as an example in fig. 4; the processor 70, memory 71, input devices 72 and output devices 73 in the server may be connected by a bus or other means, for example in fig. 4.
The memory 71 is used as a computer readable storage medium for storing a software program, a computer executable program and a module, such as program instructions corresponding to the data snapshot-based scientific research data change review method in the embodiment of the present invention. The processor 70 executes various functional applications of the server and data processing by running software programs, instructions and modules stored in the memory 71, i.e., implements the above-described data snapshot-based research data variation review method.
The memory 71 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, at least one application program required for functions; the storage data area may store data created according to the use of the terminal, etc. In addition, memory 71 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid-state storage device. In some examples, memory 71 may further include memory remotely located with respect to processor 70, which may be connected to a server via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 72 may be used to receive entered numeric or character information and to generate key signal inputs related to user settings and function control of the server. The output device 73 may include a display server such as a display screen.
The memory contains computer executable instructions which, when executed by a computer processor, are configured to perform a data snapshot-based scientific research data change review method, the method comprising:
when a command for storing the scientific form is received, unstructured storage is carried out on all data of the scientific form in a key value pair mode;
when a command for reviewing historical data is received, traversing the data of the target patient to obtain all field IDs and field names;
and establishing a table structure of a data mark-keeping table according to all the field IDs and field names, analyzing unstructured data of a target patient, and filling corresponding historical data into the table structure of the data mark-keeping table according to the corresponding relation of key values to obtain the data mark-keeping table.
Specifically, the method further comprises:
when receiving a command for storing the scientific form, storing modification execution information of the scientific form; the modification execution information includes at least: one of modification time, modifier and modification reason;
when a command for reviewing historical data is received, acquiring the modification execution information;
establishing a table structure of a data mark table containing the modification execution information according to the modification execution information, all field IDs and field names;
and filling the data corresponding to the modification execution information, the field ID and the data corresponding to the field name into a table structure of a data mark table containing the modification execution information to obtain the data mark table containing the modification execution information.
Specifically, the method further comprises:
and when a command for storing the scientific form is received, storing the modification execution information in the form of structured data, and associating the modification execution information with all data of the scientific form which is stored unstructured in the form of key value pairs.
Specifically, when a command to review the history data is received, unstructured data of the target patient is traversed to obtain all field IDs and field names.
Specifically, the method further comprises a field dictionary, wherein the field dictionary stores a field ID and a field name of the scientific research form, and the method further comprises:
when a command for storing a scientific research form is received, searching whether the field dictionary contains all field IDs and field names of the scientific research form, and if not, updating the field dictionary according to the field IDs and field names which are not contained;
and when a command for inquiring historical data is received, traversing the field dictionary data of the target patient to obtain all field IDs and field names.
Specifically, the field dictionary further includes a field identification code, where the field identification code is used to identify the field ID and the field name, and the method further includes:
when a command for storing a scientific form is received, unstructured storage is carried out on the field identification code and all data of the scientific form in a key value pair mode;
when a command for inquiring historical data is received, traversing field dictionary data of a target patient to obtain all field IDs, field names and field identification codes;
establishing a table structure of a data mark table according to all the field IDs and field names;
and analyzing unstructured data of the target patient, and filling corresponding historical data into a table structure of the data mark table according to the corresponding relation between the field identification code, the field ID and the field name to obtain the data mark table.
Specifically, unstructured storage is carried out on all data of the scientific research form in the form of key value pairs, and the unstructured storage mode is used for generating corresponding Json program sentences.
Specifically, the method further comprises:
and comparing two adjacent pieces of historical data in the data mark table in pairs, and identifying later modified data.
Specifically, the data mark-keeping table is displayed in a manner of keeping the scientific research form, wherein the display manner comprises a suspension window and/or a newly built page.
The server has the corresponding functional modules and beneficial effects of the execution method, and the detailed description is omitted here.
From the above description of embodiments, it will be clear to a person skilled in the art that the present invention may be implemented by means of software and necessary general purpose hardware, but of course also by means of hardware, although in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, etc., and include several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method according to the embodiments of the present invention.
It should be noted that, in the above-mentioned embodiments of the search apparatus, each unit and module included are only divided according to the functional logic, but not limited to the above-mentioned division, as long as the corresponding functions can be implemented; in addition, the specific names of the functional units are also only for distinguishing from each other, and are not used to limit the protection scope of the present invention.
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (6)
1. A scientific research data change review method based on data snapshot is characterized by comprising the following steps:
when a command for storing the scientific form is received, unstructured storage is carried out on all data of the scientific form in a key value pair mode; searching whether a field dictionary contains all field IDs and field names of the scientific research form, if not, updating the field dictionary according to the field IDs and field names which are not contained, wherein the field dictionary stores the field IDs and field names of the scientific research form;
when a command for reviewing historical data is received, traversing the field dictionary data of the target patient to obtain all field IDs and field names;
establishing a table structure of a data mark-keeping table according to all field IDs and field names, analyzing unstructured data of a target patient, and filling corresponding historical data into the table structure of the data mark-keeping table according to a key value corresponding relation to obtain the data mark-keeping table;
the method further comprises the steps of:
when receiving a command for storing the scientific form, storing modification execution information of the scientific form; the modification execution information includes at least: one of modification time, modifier and modification reason;
when a command for reviewing historical data is received, acquiring the modification execution information;
establishing a table structure of a data mark table containing the modification execution information according to the modification execution information, all field IDs and field names;
filling the data corresponding to the modification execution information, the field ID and the data corresponding to the field name into a table structure of a data mark table containing the modification execution information to obtain the data mark table containing the modification execution information;
the method further comprises the steps of:
when receiving a command for storing a scientific form, storing the modification execution information in a structured data mode, and correlating all data of the scientific form which is stored unstructured in a key value pair mode;
the field dictionary further includes a field identification code for identifying the field ID and the field name, the method further includes:
when a command for storing a scientific form is received, unstructured storage is carried out on the field identification code and all data of the scientific form in a key value pair mode;
when a command for inquiring historical data is received, traversing field dictionary data of a target patient to obtain all field IDs, field names and field identification codes;
establishing a table structure of a data mark table according to all the field IDs and field names;
and analyzing unstructured data of the target patient, and filling corresponding historical data into a table structure of the data mark table according to the corresponding relation between the field identification code, the field ID and the field name to obtain the data mark table.
2. The method for reviewing data snapshot based on claim 1, wherein upon receiving a command to review historical data, unstructured data of the target patient is traversed to obtain all field IDs and field names.
3. The method for reviewing scientific research data change based on data snapshot according to any one of claims 1-2, wherein all data of the scientific research form are stored unstructured in the form of key value pairs, and the unstructured storage mode is used for generating corresponding Json program sentences.
4. The data snapshot-based scientific research data change review method according to any one of claims 1 to 2, wherein the method further comprises:
and comparing two adjacent pieces of historical data in the data mark table in pairs, and identifying later modified data.
5. The method for reviewing scientific research data change based on data snapshot according to any one of claims 1-2, wherein the data trace table is displayed in a manner of retaining the scientific research form, and the display manner comprises a floating window and/or a newly built page.
6. A server, the server comprising: a memory, a processor and a data snapshot based scientific data change review program stored on the memory and executable on the processor, the data snapshot based scientific data change review program when executed by the processor implementing the data snapshot based scientific data change review method of any one of claims 1 to 5.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111627078.2A CN114201615B (en) | 2021-12-28 | 2021-12-28 | Scientific research data change review method and server based on data snapshot |
| PCT/CN2022/139214 WO2023125032A1 (en) | 2021-12-28 | 2022-12-15 | Scientific research data change review method based on data snapshot, and server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111627078.2A CN114201615B (en) | 2021-12-28 | 2021-12-28 | Scientific research data change review method and server based on data snapshot |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114201615A CN114201615A (en) | 2022-03-18 |
| CN114201615B true CN114201615B (en) | 2023-06-27 |
Family
ID=80657084
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111627078.2A Active CN114201615B (en) | 2021-12-28 | 2021-12-28 | Scientific research data change review method and server based on data snapshot |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN114201615B (en) |
| WO (1) | WO2023125032A1 (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114201615B (en) * | 2021-12-28 | 2023-06-27 | 上海市精神卫生中心（上海市心理咨询培训中心） | Scientific research data change review method and server based on data snapshot |
| CN116049196A (en) * | 2023-03-07 | 2023-05-02 | 杭州巨创网络科技有限公司 | System, method, electronic device and medium for updating database based on target form |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| CN104699811A (en) * | 2015-03-23 | 2015-06-10 | 重庆广播电视大学 | Method and device for recording and backtracking variation of form data in non-invasion manner |
| CN106021369A (en) * | 2016-05-11 | 2016-10-12 | 上海佳依佳信息科技有限公司 | Method and equipment for data change management |
| CN108133015A (en) * | 2017-12-22 | 2018-06-08 | 东软集团股份有限公司 | Form data trace method, apparatus, storage medium and electronic equipment |
| US10109027B1 (en) * | 2010-09-01 | 2018-10-23 | Brian T. Stack | Database access and community electronic medical records system |
| CN109033323A (en) * | 2018-07-18 | 2018-12-18 | 中国人民解放军91776部队 | A kind of tree structure basic data change record method based on operator |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9760571B1 (en) * | 2013-07-23 | 2017-09-12 | jSonar Inc. | Tabular DB interface for unstructured data |
| CN113835965B (en) * | 2021-09-27 | 2024-03-26 | 中电金信软件有限公司 | Parameter track mark-keeping method and device |
| CN114201615B (en) * | 2021-12-28 | 2023-06-27 | 上海市精神卫生中心（上海市心理咨询培训中心） | Scientific research data change review method and server based on data snapshot |
-
2021
- 2021-12-28 CN CN202111627078.2A patent/CN114201615B/en active Active
-
2022
- 2022-12-15 WO PCT/CN2022/139214 patent/WO2023125032A1/en unknown
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10109027B1 (en) * | 2010-09-01 | 2018-10-23 | Brian T. Stack | Database access and community electronic medical records system |
| CN102662946A (en) * | 2012-02-20 | 2012-09-12 | 北京地拓科技发展有限公司 | Method and system for automatically monitoring record changes in database |
| CN104699811A (en) * | 2015-03-23 | 2015-06-10 | 重庆广播电视大学 | Method and device for recording and backtracking variation of form data in non-invasion manner |
| CN106021369A (en) * | 2016-05-11 | 2016-10-12 | 上海佳依佳信息科技有限公司 | Method and equipment for data change management |
| CN108133015A (en) * | 2017-12-22 | 2018-06-08 | 东软集团股份有限公司 | Form data trace method, apparatus, storage medium and electronic equipment |
| CN109033323A (en) * | 2018-07-18 | 2018-12-18 | 中国人民解放军91776部队 | A kind of tree structure basic data change record method based on operator |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114201615A (en) | 2022-03-18 |
| WO2023125032A1 (en) | 2023-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109670054B (en) | Knowledge graph construction method and device, storage medium and electronic equipment | |
| CA2684822C (en) | Data transformation based on a technical design document | |
| US6467081B2 (en) | Automated help system for reference information | |
| CN114201615B (en) | Scientific research data change review method and server based on data snapshot | |
| CN108228861B (en) | Method and system for performing feature engineering for machine learning | |
| CN108762743B (en) | Data table operation code generation method and device | |
| CN101171571A (en) | Apparatus for analysing and organizing artifacts in a software application | |
| JP2005508552A (en) | Memory system for data objects | |
| CN109308254B (en) | Test method, test device and test equipment | |
| CN109471851B (en) | Data processing method, device, server and storage medium | |
| CN110580189A (en) | method and device for generating front-end page, computer equipment and storage medium | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN115576974B (en) | Data processing method, device, equipment and medium | |
| CN110334302B (en) | Complex Web application front-end runtime analysis method | |
| CN114330272A (en) | Medical record template generation method and device, electronic equipment and storage medium | |
| CN112558966B (en) | Depth model visualization data processing method and device and electronic equipment | |
| CN113760894A (en) | Data calling method and device, electronic equipment and storage medium | |
| CN113704288A (en) | Data display method and device, computer readable medium and electronic equipment | |
| CN112783482A (en) | Visual form generation method, device, equipment and storage medium | |
| CN111427577A (en) | Code processing method and device and server | |
| CN109358919B (en) | Dynamic configuration method and device for universal page, computer equipment and storage medium | |
| CN110889013A (en) | Data association method, device, server and storage medium based on XML | |
| CN115101157A (en) | Method, device, equipment and readable medium for automatically generating analysis report | |
| CN109948251B (en) | CAD-based data processing method, device, equipment and storage medium | |
| CN113760317A (en) | Page display method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |