CN110197708A - A kind of migration of block chain and storage method towards electron medical treatment case history - Google Patents
A kind of migration of block chain and storage method towards electron medical treatment case history Download PDFInfo
- Publication number
- CN110197708A CN110197708A CN201910486535.7A CN201910486535A CN110197708A CN 110197708 A CN110197708 A CN 110197708A CN 201910486535 A CN201910486535 A CN 201910486535A CN 110197708 A CN110197708 A CN 110197708A
- Authority
- CN
- China
- Prior art keywords
- data
- block chain
- information
- transaction
- model
- 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
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/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/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/81—Indexing, e.g. XML tags; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H10/00—ICT specially adapted for the handling or processing of patient-related medical or healthcare data
- G16H10/60—ICT specially adapted for the handling or processing of patient-related medical or healthcare data for patient-specific data, e.g. for electronic patient records
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Health & Medical Sciences (AREA)
- Epidemiology (AREA)
- General Health & Medical Sciences (AREA)
- Medical Informatics (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- Computing Systems (AREA)
- Medical Treatment And Welfare Office Work (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of migration of block chain and storage method towards electron medical treatment case history, belong to block chain technical field, this method provides a kind of solution of old Data Migration to new block chain network, it can be achieved that from traditional database to the migration and mapping of block chain data in traditional medical electronic health record database (relevant database) and the medical electronics case history block catenary system (non-relational database) that newly constructs.It is the distributed data base system centered on sufferer by the centralized data base system transform centered on hospital-department by carrying out the construction of multiway tree data model to traditional medical database.One aspect of the present invention ensure that integrality and robustness of the data in new and old database migration.On the other hand, it ensure that by the construction to model tree and efficient duration data migration may be implemented.
Description
Technical field
The invention belongs to block chain technical field, it is related to a kind of block chain migration towards electron medical treatment case history and storage side
Method.
Background technique
Block chain was can be traced earliest in 1991, was proposed in distributed system by Haber and Bayeret using encryption
Hash function and Merkel tree, with timestamp efficiently, safety record data, and by the data block of encryption connect chaining.
Until 2008, middle acute hearing has delivered one " a kind of bit coin: point-to-point electronic cash system ", announces first generation block
The birth and large-scale application of chain technology.Hereafter block chain technology is then by Distributed Storage, point-to-point transmission, common recognition
The technologies such as mechanism and Encryption Algorithm are extract from bit coin, cooperate automatized script code composed by intelligence contract come into
A kind of distributed storage account book system of row programming and business processing.
With block chain technology recently this constantly carry out landing applicating adn implementing within several years, block chain and traditional medical row
Industry is combined into a kind of main trend.Hospital information system HIS (the Hospital used already due to traditional medical mechanism
Information System) this centralized system R stores sufferer information, causes constructing medical block
When this non-relational storage system of chain, be stored in worth of data in relevant database can not seamless migration to non-pass
It is in the block chain storage system of type.
It is existing about in medical block chain technology, most technology or patent are all from the overall flow for constructing medical block chain
Set about, memory node, the allomeric function of medical block chain and the privacy of electronic health record information including design distribution medical information
Access control policy etc. carries out technology and illustrates and apply.And the Data Transference Technology of block chain is mostly by old block chain
Data Migration is into the block chain of new version, or proposes that a kind of general relevant database moves to non-relational database
The technology of system.Thus cause in terms of block chain medical treatment, have method for the old electricity of hospital's traditional database using current
Sub- medical record information moves to be difficult in block chain database.Therefore, the present invention provides a kind of towards electron medical treatment case history
The migration of block chain and storage method.
Summary of the invention
In view of this, the purpose of the present invention is to provide a kind of, the block chain towards electron medical treatment case history is migrated and storage side
Electronic health record information existing in hospital database can be built into automatically multi-fork tree-model by method, and more by building
Fork tree-model is converted into semi-structured data to relational data and stores, and matches the user information on existing block chain, from
It is dynamic to issue intelligent contract, and conversion transition is into existing block chain storage system.
In order to achieve the above objectives, the invention provides the following technical scheme:
A kind of migration of block chain and storage method towards electron medical treatment case history, extracts electricity in traditional medical data system
Sub- case history relation table constructs multiway tree information model, and the multiway tree information model generated by building is to conditional electronic case history
Relationship phenotypic data carries out data conversion, by existing subscriber's information in the non-relational medical record data of generation and migration block chain
Carry out information matches.When being matched to relevant user information, sent according to multiway tree information model and non-relational medical record data
Information parameter establish intelligent contract, to converting successful non-relational medical record data according to first transaction data knot of new block chain
Structure and New Transaction data structure carry out the transaction broadcast of block chain, complete from traditional medical data system to block chain data system
Transition process.
Wherein, according to first transaction data content of the new block chain, by the corresponding non-relational case history number of member transaction
It is believed that breath is successively integrated into the New Transaction data structure with chain type sequence, it is solidificated in entire block, becomes block chain data.
Further, the building multiway tree information model, comprising the following steps:
S11: for the electronic health record data mutually nested there are multiple relation tables, knot is mapped step by step using multi-fork tree-model
Structure data relationship table, the root node of multiway tree or major key and external key in child node mapping table, and multi-fork leaf nodes
Field (attribute) in mapping table.
S12: obtain electronic health record relation table in Patient (patient information) table, and using the major key of Patient table as
The root node of entire multi-fork tree-model.
S13: the field in relation table is mapped as to the child node of multiway tree.
S14: judging whether child node is external key attribute, if present node is external key attribute, opens new thread, jumps to
External key institute owner's table executes program, step S12-S14 is repeated, until the external key attribute for not having that multi-fork tree node is not added in table.
S15: traversing all relationship nodes, if all fields in the relation table of place are all added to the multiway tree of phase mapping
In, terminate program.Otherwise, the field value for being not added to multi-fork tree node is read, step S13 is repeated.
Further, the multiway tree information model generated by building to the relationship phenotypic data of conditional electronic case history into
Existing subscriber's information in the non-relational medical record data of generation and migration block chain is carried out information matches by row data conversion,
Specifically includes the following steps:
S21: multi-fork tree-model root node mapped Patient relation table field data is obtained.
S22: multiway tree data instance is generated according to the structural model of multi-fork tree-model, from the Patient relation table
Start each tuple data being successively read in the table, until the last item tuple to be migrated in the relation table.
S23: for each tuple data read, data corresponding to the first character section from each tuple
Content starts, and gradually migrates in the leaf node and child node instantiated to multi-fork tree-model, until reading this number of tuples
According to the last one field corresponding to data content be migrated completion.
S24: for each corresponding foreign key field (attribute) of each tuple data in the relation table that is read,
According to the multiway tree model node relationship being previously generated, jumps to foreign key field and correspond to data relationship table belonging to major key field
In, it is successively read the tuple data that multiway tree model is be mapped in the corresponding relation table of foreign key field, until migrating to most bottom
The leaf node at end.
S25: for, without the independent data relation table directly or indirectly contacted, being built according to multiway tree with Patient relation table
Mould method obtains the major key in its relation table and does root node as entire multi-fork tree-model, successively migrating data.
S26: by relevant user information progress already present in the non-relational user medical record data of generation and block chain
Match.
Further, the relevant user information includes the patient's name in the Patient relation table, identity card
Number, gender, the personal patient informations such as date of birth；Patient's unique identification data in the conditional electronic medical record data system,
Major key information i.e. in Patient relation table；And guardian or other kinsfolks are formed in the Patient relation table
Network of personal connections information.
Further, the successful non-relational medical record data of conversion was migrated to the step of block chain and includes:
S31: it obtains non-relational data root node and is matched with existing subscriber's information on block chain.
S32: if user information successful match, intelligent contract, node are passed to using the return value of successful match as parameter
Between endorse and start issue transaction content.
S33: it if it fails to match for user information, is passed the validity period limit value of the return value and setting that it fails to match as parameter
Intelligent contract is passed, node is endorsed but do not issued, and whether detect in the contract time limit there are user's information matches.
S34: if being matched to relevant user information within the contract time limit, S32 is thened follow the steps.
S35: if not being matched to relevant user information within the contract time limit, transaction rollback operation is carried out, is stored back into non-pass
It is to wait pending step S31 in type database.
S36: first transaction data structure according to new block chain according to new block chain of the medical record data of transaction and new is issued
Transaction data structure carries out data storage.
Further, block chain storing data format includes following information:
Block chain overall data structure is divided into block head and block body two parts.Block head include block hash with it is previous
Block hash.Block body includes two different Transaction Informations, i.e., first transaction data and New Transaction data.
Wherein, first transaction data is used to describe the information of data attribute, including block chain version information, and multi-fork tree-model is negative
It carries and payload length and importing log information.Wherein, version information identifies the version imported in block chain at that time.Load length
Scale knows the size of the data volume of the multi-fork tree-model generated.The multiway tree mould for the semi-structured data that model load mark generates
Type.And it imports log and then records the information such as the storage location for importing the relevant database side of data and data payload.It is new to hand over
Easy data are used to store the medical record data converted, first number including electronic health record relation table corresponding to block chain transaction data
According to, logical time, Session loads and log is imported.Wherein, metadata represents the metadata information of relevant database side, packet
Include storage location, the functions such as historical data, file record.And logical time represents the data and generates in relevant database side
The time of data, rather than the importing time of block chain, logical time is by the case history result of patient with normal consultation time in block
It shows in chain.It imports log and then records the letter such as the storage location for importing the relevant database side of data and data payload
Breath.
Further, the node, which is given out a contract for a project, includes block chain index module, chained list module and state-storage module；
After the completion of intelligent contract publication, block chain frame module calls chained list module to receive the transaction content reached common understanding,
It is indexed by calling index module to establish transaction content, and logical time state is added, call state-storage module that will trade
Content is stored.When state-storage module is completed to store, generation transaction receipt, notification data conversion module carries out data mark
Note.Data conversion module is fed back to completion status is stored in electronic health record relation table, and completes the transition process of entire block chain.
The beneficial effects of the present invention are: one aspect of the present invention ensure that integrality of the data in new and old database migration
And robustness.On the other hand, it ensure that by the construction to model tree and efficient duration data migration may be implemented.
Other advantages, target and feature of the invention will be illustrated in the following description to a certain extent, and
And to a certain extent, based on will be apparent to those skilled in the art to investigating hereafter, Huo Zheke
To be instructed from the practice of the present invention.Target of the invention and other advantages can be realized by following specification and
It obtains.
Detailed description of the invention
To make the objectives, technical solutions, and advantages of the present invention clearer, the present invention is made below in conjunction with attached drawing excellent
The detailed description of choosing, in which:
Fig. 1 is the global procedures process of the present invention migrated towards electron medical treatment case history block chain with the method stored
Figure；
Fig. 2 is of the present invention towards multiway tree modeling procedure in the method that electron medical treatment case history block chain migrates and stores
Figure；
Fig. 3 is the number of the present invention migrated towards electron medical treatment case history block chain with block chain storage in the method for storage
According to structure chart；
Fig. 4 is of the present invention towards block chain storing data in the method that electron medical treatment case history block chain migrates and stores
First structure of deal figure in structure chart；
Fig. 5 is of the present invention towards block chain storing data in the method that electron medical treatment case history block chain migrates and stores
New Transaction structure chart in structure chart；
Fig. 6 is the overall structure figure of the present invention migrated towards electron medical treatment case history block chain with the method stored.
Specific embodiment
Illustrate embodiments of the present invention below by way of specific specific example, those skilled in the art can be by this specification
Other advantages and efficacy of the present invention can be easily understood for disclosed content.The present invention can also pass through in addition different specific realities
The mode of applying is embodied or practiced, the various details in this specification can also based on different viewpoints and application, without departing from
Various modifications or alterations are carried out under spirit of the invention.It should be noted that diagram provided in following embodiment is only to show
Meaning mode illustrates basic conception of the invention, and in the absence of conflict, the feature in following embodiment and embodiment can phase
Mutually combination.
Wherein, the drawings are for illustrative purposes only and are merely schematic diagrams, rather than pictorial diagram, should not be understood as to this
The limitation of invention；Embodiment in order to better illustrate the present invention, the certain components of attached drawing have omission, zoom in or out, not
Represent the size of actual product；It will be understood by those skilled in the art that certain known features and its explanation may be omitted and be in attached drawing
It is understood that.
The same or similar label correspond to the same or similar components in the attached drawing of the embodiment of the present invention；It is retouched in of the invention
In stating, it is to be understood that if there is the orientation or positional relationship of the instructions such as term " on ", "lower", "left", "right", "front", "rear"
To be based on the orientation or positional relationship shown in the drawings, be merely for convenience of description of the present invention and simplification of the description, rather than indicate or
It implies that signified device or element must have a particular orientation, be constructed and operated in a specific orientation, therefore is described in attached drawing
The term of positional relationship only for illustration, is not considered as limiting the invention, for the ordinary skill of this field
For personnel, the concrete meaning of above-mentioned term can be understood as the case may be.
Block catenary system is a kind of anti-tamper, shared digitlization distribution accounting system, according to the scale of block chain
Publicly-owned chain, privately owned chain and alliance's chain can be divided into operational mode.It include several nodes in each block catenary system, several
Different transaction can occur between node, and therefore generate transaction data.Block catenary system passes through endorsement mechanism and common recognition algorithm
Consistency is carried out to each transaction data to determine, to handle transaction data, forms account book data, also referred to as block counts
According to.It is non-relational number as used by block chain technology when block chain technology is combined with electronic medical record system
According to library NoSQL, and traditional medical electronic medical record system is often using relevant database.Relevant database refers to use
Relational model carrys out the database of group organization data.And relational model refers to two-dimensional table model, a relevant database is just
Be as bivariate table and its between connection composed by a data organization.Relevant database follows Standardized Design, guarantees
The minimum data redundancy of design, relational structure are close.And non-relational database refer to do not follow normal form structure design, point
Cloth, and do not guarantee the data-storage system of ACID principle generally.NoSQL is to be stored with key-value pair, and structure is unfixed
Storage mode.Original electronic medical record system can not be directly accessed in medical tile system to obtain medical record information, be needed
Medical record information is completed by Data Migration middleware from medical system to the transition process of block chain.Various embodiments of the present invention
Technical solution is related to relevant database and non-relational database and block chain memory technology.
Fig. 1 is that the embodiment of the present invention provides a kind of process of block chain migration and storage method towards electron medical treatment case history
Electronic health record information existing in hospital database can be built into automatically multi-fork tree-model by figure, and more by building
Fork tree-model is converted into semi-structured data to relational data and stores, and matches the user information on existing block chain, from
It is dynamic to issue intelligent contract, and conversion transition is into existing block chain storage system.
To achieve the above object, the present invention provides a kind of data migration method, and content is included in traditional medical data system
Electronic health record relation table is extracted in system to construct multiway tree information model, the multiway tree information model generated by building is to tradition
The relationship phenotypic data of electronic health record carries out data conversion, by the semi-structured data of generation with migrate it is useful on block chain
Family information carries out information matches.
When being matched to relevant user information, according to the information of multiway tree information model and the transmission of non-relational medical record data
Parameter establishes intelligent contract, to converting successful non-relational medical record data according to first transaction data structure of new block chain and new
Transaction data structure carries out the transaction broadcast of block chain, completes from traditional medical data system to the migration of block chain data system
Process.
Wherein, according to first transaction data content of the new block chain, by the corresponding non-relational case history number of member transaction
It is believed that breath is successively integrated into the New Transaction data structure with chain type sequence, it is solidificated in entire block, becomes block chain data.
System R described in the embodiment of the present invention, which refers to, meets pass applied to Hospital Electronic Medical Record system
It is the database software entity of model, including but not limited to common relevant database, such as: Oracle, DB2,
The Database Systems such as Microsoft SQL Server and MySQL.
Non-relational database system described in the embodiment of the present invention refers to the non-relational database suitable for alliance's chain
Software entity, including but not limited to common non-relational database, such as: MongoDB, redis, HBase and CouchDB etc.
Database Systems.
Optionally, Fig. 2 is a kind of multiway tree model foundation flow chart provided in an embodiment of the present invention.Its operating procedure is such as
Under:
Patient (patient information) table (S201) in electronic health record relation table is obtained, and the major key of Patient table is made
For the root node of entire multi-fork tree-model.(S202)
Field in relation table is mapped as to the child node of multiway tree, obtains the node in relation table.(S203)
Judge whether child node is external key attribute (S204), if present node is external key attribute, opens new thread, jump
Program (S207) is executed to external key institute owner's table, S202-S204 is repeated, until not having that the external key of multi-fork tree node is not added in table
Attribute.
Judge next node (S205), traverse all relationship nodes (S206), if all fields in the relation table of place
It is all added in the multiway tree of phase mapping, terminates program.Otherwise, the field value for being not added to multi-fork tree node is read, is repeated
S203。
Optionally, for the data migration method, wherein data conversion includes: with user's matching step
Obtain multi-fork tree-model root node mapped Patient relation table field data.
Multiway tree data instance is generated according to the structural model of multi-fork tree-model, since the Patient relation table
The each tuple data being successively read in the table, until the last item tuple to be migrated in the relation table.Wherein,
The tree ergodic algorithm for reading multiway tree data includes but is not limited to common algorithms, such as: preamble ergodic algorithm, inorder traversal are calculated
Method and subsequent ergodic algorithm etc..
For each tuple data read, data content corresponding to the first character section from each tuple
Start, gradually migrate in the leaf node and child node instantiated to multi-fork tree-model, until reading this tuple data
Data content corresponding to the last one field is migrated completion.
For each corresponding foreign key field (attribute) of each tuple data in the relation table that is read, according to
The multiway tree model node relationship being previously generated, jumps to foreign key field and corresponds in data relationship table belonging to major key field,
It is successively read the tuple data that multiway tree model is be mapped in the corresponding relation table of foreign key field, until migrating to lowermost end
Leaf node.
For with Patient relation table without the independent data relation table directly or indirectly contacted, according to the more of claim 2
Tree modeling method is pitched, the major key in its relation table is obtained and does root node as entire multi-fork tree-model, successively migrating data.
The non-relational user medical record data of generation is matched with already present relevant user information in block chain.
Optionally, relevant user information matched for institute includes at least following information:
Patient's name in the Patient relation table, identification card number, gender, the personal patient informations such as date of birth.Institute
State patient's unique identification data in conditional electronic medical record data system, i.e. major key information in Patient relation table.And institute
State in Patient relation table network of personal connections information composed by guardian or other kinsfolks.Wherein with name, gender and identity
Personal patient information based on card number is as stringent matching condition, and there are any one with personal information not the condition being consistent not
It can be carried out matching.And can then it be led to network of personal connections information composed by guardian in Patient relation table or other kinsfolks
Crossing given threshold matching degree can carry out as weak condition matching, such as threshold value matching degree in 80% or more user information
Match.Matched by being matched to the strong condition for meeting personal information with the weak condition of network of personal connections information, to the user on block chain into
Row matching push carries out the formal migration of data after agreeing to matching by web terminal or the end app via patient user.
Optionally, as shown in Figure 1, the step of migrating the non-relational medical record data converted to block chain packet
It includes:
It obtains non-relational data root node and is matched (S103) with existing subscriber's information on block chain.
If user information successful match, intelligent contract, intelligent contract are passed to using the return value of successful match as parameter
Start to generate and execute (S104), endorse between node and starts to issue transaction content (S109).
If it fails to match for user information, the validity period limit value of the return value and setting that it fails to match is passed to as parameter
Intelligent contract (S105), whether node endorsement but not publication (S106), detecting in the contract time limit has user's information matches
(S108)。
If being matched to relevant user information within the contract time limit, transaction endorsement is executed, and broadcast each node and disappear
The publication (S109) of breath.
If not being matched to relevant user information within the contract time limit, transaction rollback operation (S107) is carried out, is stored back into non-
Pending S103 is waited in relevant database buffer area.
The medical record data of transaction is issued according to the first transaction data structure and New Transaction according to new block chain of new block chain
Data structure carries out data storage.
Optionally, it is illustrated in figure 3 block chain data structure diagram.For the block chain storing data format include with
Lower information:
Block chain overall data structure is divided into block head and block body two parts.Block head include block hash (S301) with
Previous block hashes (S302).Block body includes two different Transaction Informations, i.e., first transaction data (S303) and New Transaction
Data (S304).
Optionally, it is illustrated in figure 4 first transaction data structure chart.First transaction data is used to describe the information of data attribute,
Including block chain version information (S401), multiway tree model load (S403) and payload length (S402) and importing log information
(S404).Wherein, version information identifies the version imported in block chain at that time.The multi-fork tree-model that payload length mark generates
Data volume size.The multi-fork tree-model for the semi-structured data that model load mark generates.And it imports log and then records and lead
Enter the information such as storage location and the data payload of the relevant database side of data.
Optionally, it is illustrated in figure 5 New Transaction data structure diagram.New Transaction data are used to store the case history number converted
According to the metadata (S501) including electronic health record relation table corresponding to block chain transaction data, logical time (S502) is traded negative
It carries (S503) and imports log (S504).Wherein, metadata represents the metadata information of relevant database side, including storage
Position, the functions such as historical data, file record.And logical time represents the data and generates data in relevant database side
Time, rather than the importing time of block chain, logical time by the case history result of patient with normal consultation time the table in block chain
It shows and.It imports log and then records the information such as the storage location for importing the relevant database side of data and data payload.
Optionally, it is illustrated in figure 6 the overall structure figure of data mover system.For applied by migration and storage method
Block chain framework, including but not limited to common alliance's chain block platform chain.Such as: Hyperledger Fabric, Ripple
And the alliances such as OpenChain platform chain.Its memory node module should include block chain index module, chained list module and state
Three kinds of memory module.
After the completion of intelligent contract publication, block chain frame module calls chained list module to receive the transaction content reached common understanding,
It is indexed by calling index module to establish transaction content, and logical time state is added, call state-storage module that will trade
Content is stored.
When state-storage module is completed to store, generation transaction receipt, notification data conversion module carries out data markers.Data
Conversion module is fed back to completion status is stored in electronic health record relation table, and completes the transition process of entire block chain.
Finally, it is stated that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although referring to compared with
Good embodiment describes the invention in detail, those skilled in the art should understand that, it can be to skill of the invention
Art scheme is modified or replaced equivalently, and without departing from the objective and range of the technical program, should all be covered in the present invention
Scope of the claims in.
Claims (7)
1. a kind of migration of block chain and storage method towards electron medical treatment case history, it is characterised in that: in traditional medical data system
Electronic health record relation table is extracted in system to construct multiway tree information model, the multiway tree information model generated by building is to tradition
The relationship phenotypic data of electronic health record carries out data conversion, by the non-relational medical record data of generation and migrates on block chain
There is user information to carry out information matches；When being matched to relevant user information, according to multiway tree information model and non-relational disease
It counts one by one and establishes intelligent contract according to the information parameter of transmission, to the successful non-relational medical record data of conversion according to the member of new block chain
Transaction data structure and New Transaction data structure carry out the transaction broadcast of block chain, complete from traditional medical data system to block
The transition process of chain data system；
Wherein, according to first transaction data content of new block chain, by member trade corresponding non-relational medical record data information according to
It is secondary to be integrated into the New Transaction data structure with chain type sequence, it is solidificated in entire block, becomes block chain data.
2. the migration of block chain and storage method according to claim 1 towards electron medical treatment case history, it is characterised in that: institute
State building multiway tree information model, comprising the following steps:
S11: for the electronic health record data mutually nested there are multiple relation tables, multi-fork tree-model mapping structure step by step is used
Data relationship table, the root node of multiway tree or major key and external key in child node mapping table, multi-fork leaf nodes are corresponding to close
It is the field in table, i.e. attribute；
S12: the patient information table Patient in electronic health record relation table is obtained, and using the major key of Patient table as entire more
Pitch the root node of tree-model；
S13: the field in relation table is mapped as to the child node of multiway tree；
S14: judging whether child node is external key attribute, if present node is external key attribute, opens new thread, jumps to external key
Institute's owner's table executes program, step S12-S14 is repeated, until the external key attribute for not having that multi-fork tree node is not added in table；
S15: traversing all relationship nodes, if all fields in the relation table of place are all added in the multiway tree of phase mapping, knot
Shu Chengxu；Otherwise, the field value for being not added to multi-fork tree node is read, step S13 is repeated.
3. the migration of block chain and storage method according to claim 2 towards electron medical treatment case history, it is characterised in that: institute
It states the multiway tree information model generated by building and data conversion is carried out to the relationship phenotypic data of conditional electronic case history, will generate
Non-relational medical record data and migration block chain on existing subscriber's information carry out information matches, specifically includes the following steps:
S21: multi-fork tree-model root node mapped Patient relation table field data is obtained；
S22: multiway tree data instance is generated according to the structural model of multi-fork tree-model, is successively read since Patient relation table
Each tuple data in table is taken, until the last item tuple to be migrated in the Patient relation table；
S23: for each tuple data read, data content corresponding to the first character section from each tuple
Start, gradually migrate in the leaf node and child node instantiated to multi-fork tree-model, until reading this tuple data
Data content corresponding to the last one field is migrated completion；
S24: it for each corresponding foreign key field of each tuple data, i.e. attribute in the relation table that is read, presses
According to the multiway tree model node relationship being previously generated, jumps to foreign key field and correspond to data relationship table belonging to major key field
In, it is successively read the tuple data that multiway tree model is be mapped in the corresponding relation table of foreign key field, until migrating to most bottom
The leaf node at end；
S25: for Patient relation table without the independent data relation table directly or indirectly contacted, according to multiway tree modeling side
Method obtains the major key in its relation table and does root node as entire multi-fork tree-model, successively migrating data；
S26: the non-relational user medical record data of generation is matched with already present relevant user information in block chain.
4. the migration of block chain and storage method according to claim 3 towards electron medical treatment case history, it is characterised in that: institute
Stating relevant user information includes the personal patient information in Patient relation table, i.e. patient's name, identification card number, gender, birth
Date；It further include patient's unique identification data in the conditional electronic medical record data system, i.e. master in Patient relation table
Key information；And network of personal connections information composed by guardian or other kinsfolks in the Patient relation table.
5. the migration of block chain and storage method according to claim 1 towards electron medical treatment case history, it is characterised in that: right
It converts successful non-relational medical record data and migrates to the step of block chain and include:
S31: it obtains non-relational data root node and is matched with existing subscriber's information on block chain；
S32: if user information successful match, intelligent contract is passed to using the return value of successful match as parameter, is carried on the back between node
Book simultaneously starts to issue transaction content；
S33: if it fails to match for user information, the validity period limit value of the return value and setting that it fails to match is passed to as parameter
Intelligent contract, node are endorsed but are not issued, and whether detect in the contract time limit has user's information matches；
S34: if being matched to relevant user information within the contract time limit, S32 is thened follow the steps；
S35: if not being matched to relevant user information within the contract time limit, transaction rollback operation is carried out, non-relational is stored back into
In database, pending step S31 is waited；
S36: the medical record data of transaction is issued according to the first transaction data structure and New Transaction according to new block chain of new block chain
Data structure carries out data storage.
6. the migration of block chain and storage method according to claim 5 towards electron medical treatment case history, it is characterised in that: area
Block chain storing data format includes following information:
Block chain overall data structure includes block head and block body, and the block head includes that block hash is dissipated with previous block
Column, block body include two different Transaction Informations, i.e., first transaction data and New Transaction data；
Wherein, first transaction data is used to describe the information of data attribute, including block chain version information, multiway tree model load with
Payload length and importing log information；Wherein, version information identifies the version imported in block chain at that time；Payload length mark
Know the size of the data volume of the multi-fork tree-model generated；The multi-fork tree-model for the semi-structured data that model load mark generates；
Import storage location and data payload that log recording imports the relevant database side of data；New Transaction data are used to store
The medical record data converted, the metadata including electronic health record relation table corresponding to block chain transaction data, logical time are handed over
Easily load and importing log；Wherein, the metadata information of metadata representation relation type database side, including storage location, history
Data, file record；Logical time represents corresponding data and generates the time of data in relevant database side, and non-block chain is led
The angle of incidence, logical time show the case history result of patient with normal consultation time in block chain；Import log recording
Import the storage location and data payload of the relevant database side of data.
7. the migration of block chain and storage method according to claim 5 towards electron medical treatment case history, it is characterised in that: institute
It states node and includes block chain index module, chained list module and state-storage module；
After the completion of intelligent contract publication, block chain frame module calls chained list module to receive the transaction content reached common understanding, and passes through
It calls index module to establish transaction content to index, and logical time state is added, call state-storage module by transaction content
It is stored；When state-storage module is completed to store, generation transaction receipt, notification data conversion module carries out data markers；Number
It is fed back in electronic health record relation table according to conversion module by completion status is stored, completes the transition process of entire block chain.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910486535.7A CN110197708B (en) | 2019-06-05 | 2019-06-05 | Block chain migration and storage method for electronic medical record |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910486535.7A CN110197708B (en) | 2019-06-05 | 2019-06-05 | Block chain migration and storage method for electronic medical record |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110197708A true CN110197708A (en) | 2019-09-03 |
| CN110197708B CN110197708B (en) | 2023-01-24 |
Family
ID=67754006
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910486535.7A Active CN110197708B (en) | 2019-06-05 | 2019-06-05 | Block chain migration and storage method for electronic medical record |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110197708B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111311283A (en) * | 2020-02-20 | 2020-06-19 | 宁波甜宝生物信息技术有限公司 | Cosmetic source tracing production process method based on block chain and cloud computing |
| CN112632080A (en) * | 2020-12-29 | 2021-04-09 | 杭州趣链科技有限公司 | Data storage method, device and equipment based on block chain |
| CN113157723A (en) * | 2021-04-06 | 2021-07-23 | 福州大学 | SQL access method for Hyperridge Fabric |
| CN116483808A (en) * | 2023-06-16 | 2023-07-25 | 北京国电通网络技术有限公司 | Data migration method, device, electronic equipment and computer readable medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106529194A (en) * | 2016-12-02 | 2017-03-22 | 深圳市前海安测信息技术有限公司 | Medical informatization electronic medical record data migration system and method |
| CN107040510A (en) * | 2016-11-30 | 2017-08-11 | 华侨大学 | A kind of medical big data processing method based on body area network and cloud computing |
| CN107820690A (en) * | 2017-08-21 | 2018-03-20 | 达闼科技成都有限公司 | Information choosing method, device, electronic equipment and computer-readable recording medium |
| WO2018126077A1 (en) * | 2016-12-30 | 2018-07-05 | Intel Corporation | Service provision to iot devices |
| CN108648784A (en) * | 2018-03-15 | 2018-10-12 | 西安电子科技大学 | Medical data storage method, information data processing terminal based on block chain technology |
| CN109191003A (en) * | 2018-09-25 | 2019-01-11 | 仲恺农业工程学院 | Fruits and vegetables agricultural product quality safety traceability system based on block chain |
| WO2019018776A1 (en) * | 2017-07-21 | 2019-01-24 | Patientory, Inc. | Blockchain network for secure exchange of healthcare information |
| CN109670334A (en) * | 2018-12-19 | 2019-04-23 | 平安科技（深圳）有限公司 | Electronic health record sharing method, device, computer equipment and storage medium |
| CN109830285A (en) * | 2019-01-07 | 2019-05-31 | 东软医疗系统股份有限公司 | A kind of medical image document handling method and device |
-
2019
- 2019-06-05 CN CN201910486535.7A patent/CN110197708B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107040510A (en) * | 2016-11-30 | 2017-08-11 | 华侨大学 | A kind of medical big data processing method based on body area network and cloud computing |
| CN106529194A (en) * | 2016-12-02 | 2017-03-22 | 深圳市前海安测信息技术有限公司 | Medical informatization electronic medical record data migration system and method |
| WO2018126077A1 (en) * | 2016-12-30 | 2018-07-05 | Intel Corporation | Service provision to iot devices |
| WO2019018776A1 (en) * | 2017-07-21 | 2019-01-24 | Patientory, Inc. | Blockchain network for secure exchange of healthcare information |
| CN107820690A (en) * | 2017-08-21 | 2018-03-20 | 达闼科技成都有限公司 | Information choosing method, device, electronic equipment and computer-readable recording medium |
| CN108648784A (en) * | 2018-03-15 | 2018-10-12 | 西安电子科技大学 | Medical data storage method, information data processing terminal based on block chain technology |
| CN109191003A (en) * | 2018-09-25 | 2019-01-11 | 仲恺农业工程学院 | Fruits and vegetables agricultural product quality safety traceability system based on block chain |
| CN109670334A (en) * | 2018-12-19 | 2019-04-23 | 平安科技（深圳）有限公司 | Electronic health record sharing method, device, computer equipment and storage medium |
| CN109830285A (en) * | 2019-01-07 | 2019-05-31 | 东软医疗系统股份有限公司 | A kind of medical image document handling method and device |
Non-Patent Citations (2)
| Title |
|---|
| XIAOSHUAI ZHANG: "Block-Based Access Control for Blockchain-Based Electronic Medical Records (EMRs) Query in eHealth", 《IEEE》 * |
| 苏雄业: "基于区块链的大数据共享模型与关键机制研究与实现", 《中国优秀硕士论文电子期刊网》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111311283A (en) * | 2020-02-20 | 2020-06-19 | 宁波甜宝生物信息技术有限公司 | Cosmetic source tracing production process method based on block chain and cloud computing |
| CN111311283B (en) * | 2020-02-20 | 2021-02-05 | 宁波甜宝生物信息技术有限公司 | Cosmetic source tracing production process method based on block chain and cloud computing |
| CN112632080A (en) * | 2020-12-29 | 2021-04-09 | 杭州趣链科技有限公司 | Data storage method, device and equipment based on block chain |
| CN113157723A (en) * | 2021-04-06 | 2021-07-23 | 福州大学 | SQL access method for Hyperridge Fabric |
| CN113157723B (en) * | 2021-04-06 | 2022-06-03 | 福州大学 | SQL access method for Hyperridge Fabric |
| CN116483808A (en) * | 2023-06-16 | 2023-07-25 | 北京国电通网络技术有限公司 | Data migration method, device, electronic equipment and computer readable medium |
| CN116483808B (en) * | 2023-06-16 | 2023-09-12 | 北京国电通网络技术有限公司 | Data migration method, device, electronic equipment and computer readable medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110197708B (en) | 2023-01-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110197708A (en) | A kind of migration of block chain and storage method towards electron medical treatment case history | |
| CN107451220B (en) | Distributed NewSQL database system | |
| US11144710B2 (en) | Device with communication interface and method for controlling database access | |
| CN109144966A (en) | A kind of high-efficiency tissue and management method of massive spatio-temporal data | |
| CN110390596A (en) | A kind of financial futures trading system | |
| CN109684330A (en) | User's portrait base construction method, device, computer equipment and storage medium | |
| CN110019176A (en) | Improve the data improvement control system that data administer service success rate | |
| CN106777227A (en) | Multidimensional data convergence analysis system and method based on cloud platform | |
| CN104778258B (en) | A kind of data pick-up method of Protocol-oriented data flow | |
| CN109902130A (en) | A kind of date storage method, data query method and apparatus, storage medium | |
| CN101799749A (en) | Concurrent collaborative processes for data management and retrieval | |
| US10924551B2 (en) | IRC-Infoid data standardization for use in a plurality of mobile applications | |
| CN103761140B (en) | A kind of method that issued transaction is realized in isomeric relationship type database | |
| CN110544528B (en) | Advanced learning-based upper and lower ophthalmic remote diagnosis platform and construction method thereof | |
| CN103473256A (en) | Defining content retention rules using a domain-specific language | |
| CN109857803A (en) | Method of data synchronization, device, equipment, system and computer readable storage medium | |
| CN109582831A (en) | A kind of chart database management system for supporting unstructured data storage and inquiry | |
| CN106202848A (en) | The acquisition methods of medical image file, user terminal and master server | |
| CN102880897A (en) | Application data sharing method of smart card and smart card | |
| CN105530316A (en) | Collaborative plotting spatial system of heterogeneous spatial information based on cloud computing technology | |
| CN109460393A (en) | Visualization system is repaired in a kind of preliminary examination based on big data in advance | |
| CN103488697A (en) | System and mobile terminal capable of automatically collecting and exchanging fragmented commercial information | |
| CN110007905A (en) | A kind of generation method and system of the software development scheme based on big data | |
| CN109886678A (en) | A kind of art work traceability system based on block chain | |
| CN106845795B (en) | Business transfer system based on multi-Agent technology and business transfer method thereof |
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 |