CN114201615A - Scientific research data change review method based on data snapshot and server - Google Patents
Scientific research data change review method based on data snapshot and server Download PDFInfo
- Publication number
- CN114201615A CN114201615A CN202111627078.2A CN202111627078A CN114201615A CN 114201615 A CN114201615 A CN 114201615A CN 202111627078 A CN202111627078 A CN 202111627078A CN 114201615 A CN114201615 A CN 114201615A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- scientific research
- command
- 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.)
- Granted
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Medical Treatment And Welfare Office Work (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a scientific research data change review method based on data snapshots and a server. The method comprises the steps of performing unstructured storage on all data of a scientific research form in a key value pair mode when a command of storing the scientific research form is received, traversing data of a target patient to obtain all field IDs and field names when a command of reviewing historical data is received, establishing a table structure of a data trace-keeping table according to the all field IDs and the field names, analyzing the unstructured data of the target patient, filling corresponding historical data into the table structure of the data trace-keeping table according to a key value corresponding relation to obtain the data trace-keeping table, achieving the technical effect of viewing data in an intermediate stage at any time, solving the problem that one-step derivation is needed when historical data in a certain stage is queried in the prior art, and improving data reviewing efficiency.
Description
Technical Field
The embodiment of the invention provides an electronic data processing technology, and particularly relates to a scientific research data change review method and a server based on data snapshots.
Background
During the processes of carrying out scientific research projects and researching patient data, medical scientific researchers sometimes modify the patient data according to the actual conditions of the patient so as to correct data entry errors; or modifying the field names of the patient data to make the field names of the derived data more reasonable; or according to the research needs of the scientific research projects, partial fields are added and deleted, so that the patient data required by the research can be acquired more accurately.
The sample data of scientific research projects must be scientific and rigorous, and must not be changed and modified at will, so data is required to be left for all data changes, the existing scientific research systems generally record each modified change field, field data before change and field data after change in a patient data change record table in a form of constructing the patient data change record table one by one, and when scientific research personnel need to review historical data, only the data change condition of the historical modified field can be displayed.
When data of a certain stage needs to be acquired, patient data before the last modification needs to be calculated and generated according to the current patient data and the last modification record in the patient data change record table, then patient data before the last modification needs to be calculated and generated according to the patient data before the last modification and the penultimate modification record in the patient data change record table, and so on, so as to acquire the patient data of the required stage.
Disclosure of Invention
The invention provides a scientific research data change reviewing method based on data snapshots, which reduces the occupation of storage space by storing all data of a scientific research form in a key value pair mode in an unstructured mode, and solves the technical problem that historical data reviewing in the prior art is too complicated by establishing a data trace table.
The embodiment of the invention provides a scientific research data change review method based on data snapshots, which comprises the following steps:
when receiving a command of storing the scientific research form, performing unstructured storage on all data of the scientific research form in a key value pair mode;
when a command of 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 the data trace table according to all the field IDs and the field names, analyzing unstructured data of the target patient, and filling corresponding historical data into the table structure of the data trace table according to the key value corresponding relation to obtain the data trace table.
Preferably, the scientific research data change review method based on the data snapshot further includes:
when receiving a command of saving the scientific research form, saving modification execution information of the scientific research form; the modification execution information includes at least: one of a modification time, a modification person, and a modification reason;
when a command for reviewing the historical data is received, acquiring the modification execution information;
establishing a table structure of a data trace 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 and the data corresponding to the field ID and the field name into a table structure of a data trace table containing the modification execution information to obtain the data trace table containing the modification execution information.
Preferably, the scientific research data change review method based on the data snapshot further includes:
and when a command for storing the scientific research 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 research form which is stored in the form of key value pairs in an unstructured mode.
Preferably, the scientific research data change review method based on the data snapshot traverses the unstructured data of the target patient to obtain all the field IDs and field names when receiving the command of reviewing the historical data.
Preferably, the scientific research data change review method based on the data snapshot further includes a field dictionary, and the field dictionary stores the field ID and the field name of the scientific research form, and the method further includes:
when a command of saving the scientific research form is received, whether the field dictionary contains all field IDs and field names of the scientific research form is searched, if not, the field dictionary is updated according to the field IDs and the field names which are not contained;
and when a command for inquiring the historical data is received, traversing the field dictionary data of the target patient to obtain all the field IDs and the field names.
Preferably, in the scientific research data change review method based on the data snapshot, the field dictionary further includes a field identification code, and 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 research form is received, the field identification code and all data of the scientific research form are stored in an unstructured mode 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 trace table according to all 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 trace table according to the corresponding relation between the field identification code and the field ID and the field name to obtain the data trace table.
Preferably, in the scientific research data change review method based on the data snapshot, all data of the scientific research form is stored in an unstructured manner in a key-value pair manner, and the unstructured storage manner is to generate corresponding Json program statements.
Preferably, the scientific research data change review method based on the data snapshot further includes:
and comparing every two adjacent historical data in the data trace table, and identifying the data modified later.
Preferably, in the scientific research data change review method based on the data snapshot, the data trace table is displayed in a manner of reserving the scientific research form, and the display manner includes 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 scientific research data change review program based on the data snapshot is executed by the processor to realize the steps of the scientific research data change review method based on the data snapshot.
According to the invention, all data of the scientific research form are stored in an unstructured manner in a key value pair mode, the space occupation is reduced to a certain extent, the problem that one-step deduction is needed for reviewing historical data at a certain stage in the prior art is solved by establishing the data trace table, the comprehensiveness and the accuracy of data review are improved on the premise of not improving the storage space occupation, and the data review efficiency is greatly improved.
Drawings
FIG. 1 is a flow chart illustrating an embodiment of a method for reviewing scientific research data changes based on data snapshots;
FIG. 2 is a flow chart illustrating a method for reviewing scientific research data changes based on data snapshots according to another embodiment of the present invention;
FIG. 3 is a flow chart illustrating a method for reviewing scientific research data changes based on data snapshots according to another embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a server according to another embodiment of the method for reviewing changes in scientific research data based on data snapshots.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Fig. 1 is a flowchart of a scientific research data change review method based on a data snapshot according to an embodiment of the present invention, which is applicable to a data recording scenario in which a medical scientific research worker enters, modifies, and deletes patient data in a process of performing a scientific research project and researching patient data, and the method can be executed by a computing device having a storage function, and specifically includes the following steps:
s100, when receiving a command of storing a scientific research form, performing unstructured storage 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 research form to be filled, a command for storing the scientific research form is sent by the operator, when the data is received at the rear end, the patient data is structurally stored in a corresponding database table according to the content filled by the operator, meanwhile, the field ID and the corresponding data are stored in a key-value pair mode in an unstructured mode, for example, the field corresponding to the field ID is 'sex', the corresponding data is 'male', the 'sex' and the 'male' are stored in a key-value pair mode, when the patient data needs to be modified, the operator calls the scientific research form of the patient, clicks the storage button again after the modification, and when the rear end receives the command for storing the scientific research form, all the field IDs and the corresponding data are stored again, for example, when the data corresponding to the field of "sex" is changed from "male" to "female", the "sex" and "female" are stored in a key value pair manner, and when the data is displayed, the data different from the data stored last time can be marked with different colors or displayed as "male-female", wherein the modification process is not necessarily embodied as "-", and can also be in the forms of right arrow, larger than number, space and the like.
It is worth emphasizing that, due to the association between the field ID and the field name, all data of the scientific form are included in the form of key-value pairs: when the field ID is too complicated, it is possible to replace the field ID with a field identification code, and thus there is also a case where the field identification code is used as a key value pair keyed with the field identification code and data.
S200, traversing the data of the target patient to obtain all field IDs and field names when receiving a command of reviewing historical data;
it should be noted that, when querying patient history data, usually in order to view the modification condition of patient data, the history data needs to be displayed completely and comprehensively, and therefore, data of a target patient needs to be traversed to obtain all data of the patient, where a field ID and a field name are categories to which the patient data belongs, since association between data and the field ID is already established during storage, there is a corresponding relationship between the obtained data and the field ID, and since fields and field IDs are in one-to-one correspondence, there is a corresponding relationship between data and fields, where the corresponding relationship between fields and field IDs is stored in unstructured data and may also be stored in a field dictionary, the traversal process includes traversing at least one of unstructured data, traversing field dictionary data, and traversing structure data.
S300, establishing a table structure of the data trace table according to all the field IDs and the field names, analyzing unstructured data of the target patient, and filling corresponding historical data into the table structure of the data trace table according to the key value corresponding relation to obtain the data trace table.
It is worth emphasizing that the record table needs to contain field names to represent the value of the data, and the data trace table needs to contain all field names for the integrity of the data. Therefore, in the embodiment, the table structure of the data trace table is established according to the traversed field names, and then the data obtained by analyzing the unstructured data of the target patient is filled into the data trace table, so that the established data trace table contains all data and change conditions of the target patient, data in any intermediate process can be visually displayed, the row data of the data trace table can be sequenced according to modification time, the modified data is marked in different colors, the change conditions of the data in the past can be comprehensively and visually reflected, and the reading efficiency of the data trace table is improved.
According to the technical scheme, through the mode of carrying out unstructured preservation on all data of the scientific research form in a key value pair mode, the technical problems that the prior art is complex in data derivation logic, long in time consumption, high in server resource consumption and low in data review efficiency are solved, meanwhile, the preserved data are displayed through establishing the data trace table, the change condition of historical data can be comprehensively and visually reflected, the effect of displaying all historical data is achieved, the review efficiency of the historical data is improved, the accuracy of data acquisition is improved, and the user experience is improved.
Referring to fig. 2, the method further includes:
s400, when receiving a command of saving the scientific research form, saving modification execution information of the scientific research form; the modification execution information includes at least: one of a modification time, a modification person, and a modification reason;
it should be noted that, since the scientific research form only includes the patient data, and in order to reflect the detailed situation of each modification, it is also necessary to reflect the information of the reviewer, the revision time, the revision reason, and the like of each modification, it is also necessary to store these three pieces of information, the reviewer can obtain the revision time according to the logged account, and the revision reason needs to be filled in during the revision process by the reviewer.
It is easy to understand that, for the latest data, because the latest data needs to be frequently consulted, the latest data is stored in a database table, the situation that the latest stored unstructured file needs to be searched for in each consultation and converted into a scientific research form is avoided, extra calculation amount is consumed, the reading speed of the scientific research form is reduced, the latest scientific research form data of all patients is stored in the database table, and each line 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 target patient need be read, only need select in the database table that the patient is on all data to through script loading to scientific research form can, greatly reduced patient data retrieval and loaded consuming time, improved the data loading speed of scientific research form, wherein the loaded process of script specifically includes: and binding a corresponding data source to the form page, generating the format of the form page in the process of generating the form page, and loading corresponding data in the data source to a corresponding position of the form page according to the patient ID and the bound data source.
S500, acquiring the modification execution information when a command of reviewing the historical data is received;
it should be noted that the modification execution information may be stored in a structured or unstructured manner in the corresponding unstructured file, where there is a corresponding relationship among a modifier, a modification time, a modification reason, and detailed data after storage.
S600, establishing a table structure of a data trace table containing the modification execution information according to the modification execution information, all field IDs and field names;
it is to be emphasized that, in the above example, the header of the data trace table containing the modification execution information includes all of the field names, the modification person, the modification time, and the modification reason.
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 trace table containing the modification execution information to obtain the data trace table containing the modification execution information.
It is easy to understand that after the table structure is established, the data of the target patient may be filled in according to the association relationship stored in the structure, in the above example, the data trace table data sorting mode including the modification execution information may be sorted according to the modification time, and only the data meeting the screening condition may be displayed by setting the screening condition.
Referring to fig. 3, the scientific research data change review method based on the data snapshot further includes:
and S410, storing the modification execution information in the form of structured data when receiving a command of storing the scientific research form, and associating the modification execution information with all data of the scientific research form which is stored in the form of key value pairs in an unstructured mode.
It is worth emphasizing that the modification execution information may be stored in a structured manner with the corresponding unstructured file, for example, when the modification execution information is stored in a form of a record table, the header is the modifier, the modification time, the modification reason, and the detailed data, where the detailed data may be a text segment, a picture, a file name, or a hyperlink of the unstructured file.
Specifically, the scientific research data change review method based on the data snapshot traverses unstructured data of a target patient to obtain all field IDs and field names when a command of reviewing historical data is received.
Specifically, the method further includes a field dictionary, where the field dictionary holds field IDs and field names of the scientific research forms, and the method further includes:
when a command of saving the scientific research form is received, whether the field dictionary contains all field IDs and field names of the scientific research form is searched, if not, the field dictionary is updated according to the field IDs and the field names which are not contained;
and when a command for inquiring the historical data is received, traversing the field dictionary data of the target patient to obtain all the field IDs and the field names.
It should be emphasized that, because the field names may be adjusted inaccurately due to the description, and when the data trace table is generated after the adjustment, two columns of data are generated, which is not easy to read, this embodiment will determine whether the field names are the same column of data according to the field ID and the field name, and determine the field name in the latest data as the modified data field name according to the modification time, and use this as the field name displayed by the data trace table.
Specifically, the field dictionary further includes a field identification code for identifying the field ID and the field name, and the method further includes:
when a command for storing a scientific research form is received, the field identification code and all data of the scientific research form are stored in an unstructured mode in a key value pair mode;
it is easy to understand that, because the field name may be more complex for reading, and the field ID also has a more complex problem due to its generation rule, and will occupy more space when performing unstructured storage, therefore, the embodiment introduces the field identification code to replace the field name and the field ID, thereby greatly reducing the space occupation when storing unstructured data.
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 field dictionary stores the corresponding relationship among the field ID, the field name, and the field identification code, so that the field name and the field ID can be recorded only once, a large number of field identification codes are used in the unstructured data for recording, and then the corresponding field name and the corresponding field ID are queried according to the field dictionary, thereby further reducing the space occupation.
Establishing a table structure of a data trace table according to all 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 trace table according to the corresponding relation between the field identification code and the field ID and the field name to obtain the data trace table.
It should be emphasized that, after the field names are searched by the identification codes and the field dictionary, the table structure establishment and the data filling process are consistent in the above embodiment, and all technical effects of the above embodiment are achieved, and are not described in detail herein.
Specifically, all data of the scientific research form are stored in an unstructured mode in a key value pair mode, and the unstructured mode is to generate corresponding Json program statements.
It should be noted that, in the present embodiment, Json is used as an unstructured storage method, and data is stored and represented in a text format completely independent of a programming language. The method is easy for people to read and machine to analyze and generate, Json has a higher effective data rate than xml, and the occupied space for storing the data snapshot is further reduced, wherein the data snapshot is a scientific research form and the data snapshots of all data of the scientific research form.
It is easy to understand that, by introducing the Json program statements 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 row of data in the data trace comparison table. The modification executing information such as the modifier, the modification time, the modification reason and the like can be independent of the Json program statement generated by modification each time and is stored in one-to-one correspondence with the Json program statement, and the modification executing information can also be directly contained in the Json program statement when the Json program statement is generated, so that the storage space is saved.
And when the modifier, the modification time, the modification reason and the corresponding Json program statement are stored in a structured mode, the Json program statement is stored in a record table mode. Meanwhile, when structured storage is carried out, the patient ID can be stored as structured data and corresponds to the corresponding Json program statement. The method has the advantages that the speed for acquiring all Json program statements of the target patient according to the patient ID is higher and the method is more accurate. And Json program sentences are used as data snapshots to store all data of the patient scientific research forms, so that the table structure of the record table can be simplified, the data volume is greatly reduced, the complexity of the record table is greatly reduced, all historical patient data can be acquired by directly analyzing the Json program sentences in the record table, the data review mode is simple and convenient, the server resource occupation consumption is low, the review result presentation time is short, the response is fast, and the user overall experience is good.
Specifically, the method further comprises the following steps:
and comparing every two adjacent historical data in the data trace table, and identifying the data modified later.
It is easy to understand that when the data of the scientific research form is recorded by using the Json program statements, two adjacent pieces of historical data are two Json files with adjacent modification time of the target patient, and the later modified data is 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.
Specifically, the data trace list is displayed in a manner of reserving the scientific research form, and the display manner comprises a floating window and/or a newly-built page.
It is easy to understand that after the data trace table is opened, the scientific research form is retained, and then the content in the data trace table can be better understood according to the data of the scientific research form, in order to realize the function of mutual comparison in this embodiment, when the floating window is used for displaying, the position of the floating window can be draggable, and the background scientific research form can be scrolled up and down, and an operator can drag the floating window to view the sheltered content, and view the content in the scientific research form which is not displayed on the current page in the up and down scrolling mode.
The embodiment perfects the technical scheme by disclosing a detailed concrete mode for establishing the data trace table, realizes further improvement of the data reviewing efficiency, simultaneously discloses a detailed process for storing and inquiring information by using Json program statements, reduces the space occupation, further perfects the technical scheme by disclosing different forms of the data trace table, improves the integrity of recorded data and the convenience of data reviewing, can not only comprehensively record and review all modifications and changes of medical scientific research personnel to the patient data in the patient scientific research form, but also automatically adopt the latest and more reasonable field names of the patient scientific research form for describing historical data, can comprehensively record and review the changed contents of adding and deleting partial fields in the previous modification process of the patient scientific research form, and when displaying the historical data, compared with the previous version data, the changed data is marked with colors to prompt the user; the method can be more intuitive, accurately check the increase and decrease conditions of elements on the form, the data change conditions, the multi-data change relation and the like, so that the data recording and reviewing are more comprehensive and accurate, the requirement that scientific research personnel consult the authenticity of the data change with other data at that time when reviewing historical data is fully met, the patient data after being modified and changed at each time can be completely stored by adopting a Json file description, the technical problem that in the prior art, multiple rows of data storage need to be occupied, a large amount of storage space is occupied is avoided, and the storage space for storing the 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 the processors 70 in the server may be one or more, and one processor 70 is taken as an example in fig. 4; the processor 70, the memory 71, the input device 72 and the output device 73 in the server may be connected by a bus or other means, and the bus connection is exemplified in fig. 4.
The memory 71 is a computer-readable storage medium, and can be used for storing software programs, computer-executable programs, and modules, such as program instructions corresponding to the method for reviewing scientific research data change based on data snapshots in the embodiment of the present invention. The processor 70 executes various functional applications and data processing of the server by running software programs, instructions and modules stored in the memory 71, that is, the above-mentioned scientific research data change review method based on the data snapshot is realized.
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, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the 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 located remotely from processor 70, which may be connected to a server over 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 input numeric or character information and 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 that when executed by a computer processor perform a method for review of a data snapshot-based change in scientific research data, the method comprising:
when receiving a command of storing the scientific research form, performing unstructured storage on all data of the scientific research form in a key value pair mode;
when a command of 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 the data trace table according to all the field IDs and the field names, analyzing unstructured data of the target patient, and filling corresponding historical data into the table structure of the data trace table according to the key value corresponding relation to obtain the data trace table.
Specifically, the method further comprises:
when receiving a command of saving the scientific research form, saving modification execution information of the scientific research form; the modification execution information includes at least: one of a modification time, a modification person, and a modification reason;
when a command for reviewing the historical data is received, acquiring the modification execution information;
establishing a table structure of a data trace 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 and the data corresponding to the field ID and the field name into a table structure of a data trace table containing the modification execution information to obtain the data trace table containing the modification execution information.
Specifically, the method further comprises:
and when a command for storing the scientific research 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 research form which is stored in the form of key value pairs in an unstructured mode.
Specifically, upon receiving a command to review historical data, the unstructured data of the target patient is traversed to obtain all field IDs and field names.
Specifically, the method further includes a field dictionary, where the field dictionary holds field IDs and field names of the scientific research forms, and the method further includes:
when a command of saving the scientific research form is received, whether the field dictionary contains all field IDs and field names of the scientific research form is searched, if not, the field dictionary is updated according to the field IDs and the field names which are not contained;
and when a command for inquiring the historical data is received, traversing the field dictionary data of the target patient to obtain all the field IDs and the field names.
Specifically, the field dictionary further includes a field identification code for identifying the field ID and the field name, and the method further includes:
when a command for storing a scientific research form is received, the field identification code and all data of the scientific research form are stored in an unstructured mode 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 trace table according to all 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 trace table according to the corresponding relation between the field identification code and the field ID and the field name to obtain the data trace table.
Specifically, all data of the scientific research form are stored in an unstructured mode in a key value pair mode, and the unstructured mode is to generate corresponding Json program statements.
Specifically, the method further comprises:
and comparing every two adjacent historical data in the data trace table, and identifying the data modified later.
Specifically, the data trace list is displayed in a manner of reserving the scientific research form, and the display manner comprises a floating window and/or a newly-built page.
The server has the corresponding functional modules and beneficial effects of the execution method, and the description is omitted.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It should be noted that, in the embodiment of the above search apparatus, each included unit and module are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. 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, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A scientific research data change review method based on data snapshot is characterized by comprising the following steps:
when receiving a command of storing the scientific research form, performing unstructured storage on all data of the scientific research form in a key value pair mode;
when a command of 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 the data trace table according to all the field IDs and the field names, analyzing unstructured data of the target patient, and filling corresponding historical data into the table structure of the data trace table according to the key value corresponding relation to obtain the data trace table.
2. The method for reviewing changes in scientific research data based on data snapshots as claimed in claim 1, further comprising:
when receiving a command of saving the scientific research form, saving modification execution information of the scientific research form; the modification execution information includes at least: one of a modification time, a modification person, and a modification reason;
when a command for reviewing the historical data is received, acquiring the modification execution information;
establishing a table structure of a data trace 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 and the data corresponding to the field ID and the field name into a table structure of a data trace table containing the modification execution information to obtain the data trace table containing the modification execution information.
3. The method for reviewing changes in scientific research data based on data snapshots as claimed in claim 2, further comprising:
and when a command for storing the scientific research 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 research form which is stored in the form of key value pairs in an unstructured mode.
4. The method for reviewing scientific data changes based on data snapshots as claimed in claim 1, wherein when a command to review historical data is received, unstructured data of a target patient is traversed to obtain all field IDs and field names.
5. The scientific research data change review method based on the data snapshot as claimed in claim 1, further comprising a field dictionary, wherein the field dictionary holds field IDs and field names of the scientific research forms, and the method further comprises:
when a command of saving the scientific research form is received, whether the field dictionary contains all field IDs and field names of the scientific research form is searched, if not, the field dictionary is updated according to the field IDs and the field names which are not contained;
and when a command for inquiring the historical data is received, traversing the field dictionary data of the target patient to obtain all the field IDs and the field names.
6. The method for reviewing scientific data changes based on data snapshots as claimed in claim 5, wherein the field dictionary further comprises field identification codes for identifying the field IDs and field names, the method further comprising:
when a command for storing a scientific research form is received, the field identification code and all data of the scientific research form are stored in an unstructured mode 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 trace table according to all 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 trace table according to the corresponding relation between the field identification code and the field ID and the field name to obtain the data trace table.
7. The method for reviewing changes of scientific research data based on data snapshots as claimed in claims 1 to 6, wherein all data of a scientific research form are stored in an unstructured manner in the form of key-value pairs, and the unstructured storage is to generate corresponding Json program statements.
8. The method for reviewing scientific research data change based on data snapshot as claimed in claims 1 to 6, wherein the method further comprises:
and comparing every two adjacent historical data in the data trace table, and identifying the data modified later.
9. The scientific research data change review method based on the data snapshot as claimed in claims 1 to 6, wherein the data trace list is displayed in a manner of reserving the scientific research form, and the display manner includes a floating window and/or a newly-built page.
10. A server, characterized in that the server comprises: a memory, a processor, and a data snapshot based research data change review program stored on the memory and executable on the processor, the data snapshot based research data change review program when executed by the processor implementing the data snapshot based research data change review method as recited in any one of claims 1 to 9.
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 true CN114201615A (en) | 2022-03-18 |
| CN114201615B 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) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116049196A (en) * | 2023-03-07 | 2023-05-02 | 杭州巨创网络科技有限公司 | System, method, electronic device and medium for updating database based on target form |
| WO2023125032A1 (en) * | 2021-12-28 | 2023-07-06 | 上海市精神卫生中心（上海市心理咨询培训中心） | Scientific research data change review method based on data snapshot, and server |
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 |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023125032A1 (en) * | 2021-12-28 | 2023-07-06 | 上海市精神卫生中心（上海市心理咨询培训中心） | Scientific research data change review method based on data snapshot, and server |
| CN116049196A (en) * | 2023-03-07 | 2023-05-02 | 杭州巨创网络科技有限公司 | System, method, electronic device and medium for updating database based on target form |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114201615B (en) | 2023-06-27 |
| WO2023125032A1 (en) | 2023-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9811577B2 (en) | Asynchronous data replication using an external buffer table | |
| CN114416667B (en) | Method and device for rapidly sharing network disk file, network disk and storage medium | |
| CN114201615B (en) | Scientific research data change review method and server based on data snapshot | |
| CN109471851B (en) | Data processing method, device, server and storage medium | |
| CN111125598A (en) | Intelligent data query method, device, equipment and storage medium | |
| EP3144810B1 (en) | System for data aggregation and analysis of data from a plurality of data sources | |
| CN110580189A (en) | method and device for generating front-end page, computer equipment and storage medium | |
| US20160188584A1 (en) | System for tracking and displaying changes in a set of related electronic documents. | |
| CN110990445A (en) | Data processing method, device, equipment and medium | |
| US20240037084A1 (en) | Method and apparatus for storing data | |
| US9880991B2 (en) | Transposing table portions based on user selections | |
| CN112558966B (en) | Depth model visualization data processing method and device and electronic equipment | |
| CN111143434A (en) | Intelligent data checking method, device, equipment and storage medium | |
| CN113760894A (en) | Data calling method and device, electronic equipment and storage medium | |
| WO2022150110A1 (en) | Document content extraction and regression testing | |
| CN113010208A (en) | Version information generation method, version information generation device, version information generation equipment and storage medium | |
| CN113704288A (en) | Data display method and device, computer readable medium and electronic equipment | |
| CN112800371A (en) | Method and device for processing spreadsheet data in web page | |
| CN109542890B (en) | Data modification method, device, computer equipment and storage medium | |
| CN109358919B (en) | Dynamic configuration method and device for universal page, computer equipment and storage medium | |
| CN114968725A (en) | Task dependency relationship correction method and device, computer equipment and storage medium | |
| CN115329150A (en) | Method and device for generating search condition tree, electronic equipment and storage medium | |
| CN113760317A (en) | Page display method, device, equipment and storage medium | |
| CN108334621B (en) | Database operation method, device, equipment and computer readable storage medium | |
| CN113176878B (en) | Automatic query method, device and equipment |
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 |