[go: up one dir, main page]

CN107273682A - File organization module applied to electronic health record archive arrangement system - Google Patents

File organization module applied to electronic health record archive arrangement system Download PDF

Info

Publication number
CN107273682A
CN107273682A CN201710436537.6A CN201710436537A CN107273682A CN 107273682 A CN107273682 A CN 107273682A CN 201710436537 A CN201710436537 A CN 201710436537A CN 107273682 A CN107273682 A CN 107273682A
Authority
CN
China
Prior art keywords
file
organizational form
user
priority
record
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.)
Pending
Application number
CN201710436537.6A
Other languages
Chinese (zh)
Inventor
彭逢安
陈卫单
李卓研
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Huiyang Health Science And Technology Co Ltd
Original Assignee
Guangzhou Huiyang Health Science And Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangzhou Huiyang Health Science And Technology Co Ltd filed Critical Guangzhou Huiyang Health Science And Technology Co Ltd
Priority to CN201710436537.6A priority Critical patent/CN107273682A/en
Publication of CN107273682A publication Critical patent/CN107273682A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention discloses a kind of file organization module applied to electronic health record archive arrangement system, including organizational form creating unit, organizational form query unit and organizational form output unit, wherein, organizational form has three kinds, is respectively without the basic document tissue created, the priority file tissue and advanced file tissue that are created by organizational form creating unit;Organizational form query unit builds satisfactory SELECT statement and database file is inquired about according to the search request of user;Organizational form output unit is used for output organization mode, sorting field and classificating requirement that system is specified according to user, perform corresponding inquiry, so that when carrying out taxonomic revision according to various criterion to a large amount of electronic health records, only copy need to be stored in database, electronic health record files bulk redundancy is avoided, while providing the organizational form of a variety of electronic medical record documents, the Data storage operating efficiency of clinical research personnel is greatly improved.

Description

File organization module applied to electronic health record archive arrangement system
Technical field
The present invention relates to field of medical technology, a kind of file group applied to electronic health record archive arrangement system is particularly related to Knit module.
Background technology
In clinical research, the medical records of patient is the mostly important firsthand information, and clinical research staff is led to The medical records of collection patient is crossed, the medical history information and data for obtaining serving goal in research is therefrom excavated.However, to case history , it is necessary to different standards to carrying out different classification with a collection of case history when analysis, such as according to sex, the age or Progression of disease is classified.If for different sorting techniques, different files, each file are directly set up in a hard disk Classification in folder all to carrying out various criterion with a collection of case history, then can cause can be due to different criteria for classifications with a case history There are multiple copies, the actually bulk redundancy of data.
Therefore, in the urgent need to developing a kind of file organization module applied to electronic health record archive arrangement system, Neng Gouyou Effect ground is arranged and filed to electronic health record with the small storage control of most probable.
The content of the invention
For problem present in background technology, electronic health record archive arrangement is applied to it is an object of the invention to provide one kind The file organization module of system so that when carrying out taxonomic revision according to various criterion to a large amount of electronic health records, in database Only need to store copy, it is to avoid the bulk redundancy of electronic health record files, while also providing a variety of electronic medical record documents Organizational form, greatly improve the Data storage operating efficiency of clinical research personnel.
The technical proposal of the invention is realized in this way:A kind of file organization applied to electronic health record archive arrangement system Module, including organizational form creating unit, organizational form query unit and organizational form output unit, wherein, organizational form wound Build unit:Organizational form is divided into basic document organizational form, priority file organizational form and advanced file organizational form, group Knitting mode creating unit is used for the establishment of priority file organizational form and advanced file organizational form, priority organizational form Establishment is divided into priority organizational form and created and the establishment of asterisk organizational form, in the database of electronic health record archive arrangement system Can be priority tissue table and asterisk organizational form table respectively, both major keys are all while create two empty tables when building storehouse Admission number, the former variable is priority, and the latter does not have other data variables in addition to admission number;In user's read electronic disease Go through heating temperature after file, or decide whether as asterisk in files-designated, when user be certain part of file heating temperature it Afterwards, admission number and priority level on a record, record can be increased in priority tissue table;User is certain part of files-designated After upper asterisk, it can equally increase admission number on a record, record in asterisk organizational form table;When user cancels preferential Level, or when removing asterisk, the corresponding record of this bar file can be deleted from respective tissue table;Advanced file organizational form is created Build, firstly the need of defining classification variable, regulation specific name and attribute, then to need to define optional types of variables;By definition Self-defined taxonomic organization's table can be set up afterwards, and major key is admission number, and variable is exactly specific name;User is to every part of electricity After sub- patient file is read, variables choice can be carried out to this part of file, user is completed after variables choice, system can be Increase a record in self-defined taxonomic organization's table, major key is corresponding admission number, and variable is then carried out according to the selection of user The record of numerical value;Organizational form query unit:The organizational form inquiry is divided into Three models, and respectively basic document tissue is looked into Ask, priority file hoc queries and advanced file hoc queries, wherein, can be with during user's selection basic document hoc queries Directly inquired about;When user selects priority file hoc queries, priority is chosen whether only to show that some is preferential The case history archive of level, after the completion of selection, system builds SELECT statement and database file is carried out according to the search request of user Inquiry;During user's selection advanced file organizational form inquiry, the field to be inquired about is selected first, then the bar of selected inquiry Part, structure SELECT statement is inquired about database file after system receives instruction;Organizational form output unit:For group The output of mode is knitted, when user's selection is exported with certain organizational form, sorting field and divide that system is specified according to user Class requirement, performs organizational form inquiry, keeps in the data base view of Query Result generation, the path selected according to user and word Duan Yaoqiu sets up file in destination path, then according under the result of each packet and each packet in data base view Store path in each part electronic health record file record finds original storage path, and finds the original document according to the path, And the original document is sent to destination folder.
In the above-mentioned technical solutions, the specific name can be but be not limited to " disease stage ", " whether take certain with attribute Plant medicine ".
In the above-mentioned technical solutions, the optional types of variables of correspondence " disease stage " is " 1 phase ", " 2 phase " and " 3 phase ".
In the above-mentioned technical solutions, the optional types of variables corresponding to " whether taking certain medicine " is "Yes" and "No".
File organization module of the present invention applied to electronic health record archive arrangement system, including organizational form creating unit, Organizational form query unit and organizational form output unit, wherein, the organizational form of file has three kinds, is respectively without creating Basic document tissue, the priority file tissue and advanced file tissue created by organizational form creating unit;Tissue Mode query unit is used for the search request according to user, builds satisfactory SELECT statement and database file is looked into Ask;Organizational form output unit is used for output organization mode, and sorting field and classificating requirement that system is specified according to user are held The corresponding inquiry of row, so that when carrying out taxonomic revision according to various criterion to a large amount of electronic health records, in database only Copy need to be stored, it is to avoid electronic health record files bulk redundancy, while providing the organizer of a variety of electronic medical record documents Formula, greatly improves the Data storage operating efficiency of clinical research personnel.
Brief description of the drawings
Fig. 1 is priority organizational form visioning procedure schematic diagram in the present invention;
Fig. 2 is middle-and-high-ranking file organization mode visioning procedure schematic diagram of the invention;
Fig. 3 is organizational form output schematic flow sheet in the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiments.Based on this Embodiment in invention, the every other reality that those of ordinary skill in the art are obtained under the premise of creative work is not made Example is applied, the scope of protection of the invention is belonged to.
A kind of file organization module applied to electronic health record archive arrangement system of the present invention, including organizational form Creating unit, organizational form query unit and organizational form output unit, are the group by electronic health record files and file The mode of knitting is separated, and electronic health record files are stored in into Database Folder, and the organizational form of file is stored in data In library file, build Virtual table to show the different organizational form of file using data base view.The following is to above-mentioned each list The detailed description of member:
(1) organizational form creating unit:
For the establishment of organizational form, in electronic health record archive arrangement system, the organizational form of file has three kinds:Basis File organization mode, priority file organizational form and advanced file organizational form.Wherein, basic document organizational form is not required to Organizational form is created, organizational form inquiry is directly can be carried out;And priority organizational form and advanced file organizational form It is required for being created, the following is the explanation for creating both organizational forms with reference to Fig. 1 and Fig. 2:
A. priority organizational form is created:
Priority organizational form is divided into two kinds:Priority organizational form and asterisk organizational form.In electronic health record archives Data library text in clearing system can be priority tissue table and asterisk organizer respectively while create two empty tables when building storehouse Formula table.Both major keys are all admission numbers, and the former variable is priority, and the latter does not have the change of other data in addition to admission number Amount.
It after user's read electronic patient file, can specifically be considered according to it, be file heating temperature (1-4), Or decide whether as asterisk in files-designated., can be in priority tissue table after user is certain part of file heating temperature Admission number and priority level on one record of increase, record, do not record other in addition to admission number and priority appoint What data.And after user is asterisk in certain part of files-designated, can equally increase a record in asterisk organizational form table, record Upper admission number.When user's cancellation priority, or when removing asterisk, this bar file can be deleted from respective tissue table corresponding Record.
B. advanced file organizational form is created:
Advanced file organization service is in superior classification demand of the user to electronic health record files, also referred to as self-defined text Part tissue.When user uses advanced file tissue, it is necessary first to defining classification variable, regulation specific name and attribute, such as " disease stage ", " whether taking Omeprazole ".Then need to define optional types of variables, such as corresponding to " disease stage " Optional types of variables is " 1 phase ", " 2 phase " and " 3 phase ", and the optional types of variables for corresponding to " whether taking Omeprazole " is "Yes" and "No".
After definition, system can set up self-defined taxonomic organization's table.Major key is admission number, and variable is exactly point Class name.User can carry out variables choice after being read to every part of electronic health record file to this part of file.User completes After variables choice, system can increase a record in self-defined taxonomic organization's table, and major key is corresponding admission number, and variable The record of numerical value is then carried out according to the selection of user.
(2) organizational form query unit:
To the inquiry of electronic health record archives regarded by database according to certain organizational form for the inquiry of organizational form What figure was realized, system builds satisfactory SELECT statement and database file is inquired about according to the search request of user. It is divided into main table and affiliated group's table in the database file, by using view, hides the table structure of bottom, so as to builds virtual Table is realized.
Organizational form inquiry is divided into Three models:Basic document hoc queries, priority file hoc queries and senior File organization is inquired about.
A. basic document hoc queries:
The field that basic document hoc queries are inquired about all is basic field, it is only necessary to which being inquired about in main table just can obtain To Query Result, without simultaneous affiliated group table.The field that basic document hoc queries are inquired about includes but is not limited to lower word Section:
Age Sex Main suit Section office Admission date ...
User inputs sorting field and class condition in the case history sorting module of electronic health record archive arrangement system, is System builds SELECT statement after receiving instruction, and form is as follows:
CREATE VIEW<Sorting field>The main table WHERE of _ view AS SELECT*FROM<Class condition>
ORDER BY<Sorting field>;
Build after completion SELECT statement, perform the sentence, return to classification results.
B. priority file hoc queries:
When user selects priority file hoc queries, priority can be chosen whether only to show some priority Case history archive.After the completion of selection, system builds SELECT statement and database file is looked into according to the search request of user Ask.
CREATE VIEW<Priority>The main table admission numbers=priority groups of the main table WHERE of _ view AS SELECT*FROM Knit table admission numbers AND<Priority level condition>.ORDER BY<Priority level>
Build after completion SELECT statement, perform the sentence, return to classification results.
Asterisk document classification equally follows the above method.
C. advanced file tissue:
During user's selection advanced file organizational form inquiry, the field to be inquired about is selected first, inquiry is then selected Condition.System builds SELECT statement after receiving instruction, and form is as follows:
CREATE VIEW<Sorting field>The main table admission numbers of the main table WHERE of _ view AS SELECT*FROM=self-defined Taxonomic organization table admission numbers AND<Class condition>.ORDER BY<Sorting field>
Build after completion SELECT statement, perform the sentence, return to classification results.
(3) organizational form output unit:
For the output of organizational form, when user's selection is exported with certain organizational form, system is specified according to user Sorting field and classificating requirement, organizational form inquiry is performed on backstage, the data base view that Query Result is generated is temporarily stored into Backstage, the path selected according to user and field requirement set up file in destination path, then the root in data base view According to the result of each packet, the store path in each part electronic health record file record under each packet finds original storage road Footpath, and the original document is found according to the path, and the original document is sent to destination folder.When All Files is output to After destination folder, output is completed.Wherein, the flow of organizational form output is as shown in Figure 3.
The following is further illustrating that one instantiation of combination is carried out:
Certain user needs to carry out the clinical research on chronic renal failure, now have collected 30 parts of clinical case histories, is stored in electricity In sub- case history archive clearing system.User needs classifying by stages to these case histories according to chronic renal failure, as defined in it Name variable, attribute and optional type are:
User has been defined after variable, and system sets up taxonomic organization's table.
User is completed to read after case history, and case history delimited by stages, delimited result and is stored in taxonomic organization's table, respectively For:
Call SELECT statement as follows:
CREATE VIEW CKD by stages _ the main table admission numbers=CKD of the main table WHERE of view AS SELECT*FROM by stages Taxonomic organization's table admission number .ORDER BY types
Using data base view, show as follows:
Admission number Type Name Sex Admission date ...
160511 The III phases Zhang San Man
160812 The III phases Li Si Man
150314 The III phases Zhao six Female
...
161231 The V phases
170112 The V phases
150312 The V phases
To sum up, the present invention is applied to the file organization module of electronic health record archive arrangement system, has the advantages that:
1. when carrying out clinical research, it is often necessary to will be classified according to different standards with a collection of case history archive, than Such as according to disease stage, whether take medicine.If setting up file respectively for each criteria for classification, then to a electricity It is accomplished by copying many parts for sub- patient file and is put into different files, the great redundancy of the data actually caused.Using The mode that file organization method is separated with original document, can by a variety of different file organization modes with a kind of relation Form is stored in database file, is taken out when calling using data base view, is so avoided that same text document is carried out Repeatedly copy, largely saves memory space.
2. in this kind of electronic health record files organizational form, file organization mode be divide into three classifications, respectively Based on file organization, priority file tissue and advanced file tissue, user can be met in terms of different to file Classification demand.For the classification of patient medical records essential information, it can just be completed with basic document tissue, and for more The sorting technique of specific aim research oriented target, user being capable of self-defined sorting technique and type, then voluntarily to text in systems Part is classified, the free degree it is higher there is provided selection it is also more.
If 3. store electronic medical record document in the way of setting up file respectively, then when needing to have access to document, use Family, which needs to click to enter specific file, is read, and be presented to user is specific document examples, it is difficult to contrasted Read, show also not succinct enough.Employ after data base view shows to different file organization modes, with form Form shows that the table structure and file to bottom are hidden to file content, only shows and closes the most for a user The content of the heart so that read interface is more succinct.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all essences in the present invention God is with principle, and any modification, equivalent substitution and improvements made etc. should be included in the scope of the protection.

Claims (4)

1. a kind of file organization module applied to electronic health record archive arrangement system, it is characterised in that:Including organizational form wound Unit, organizational form query unit and organizational form output unit are built, wherein,
Organizational form creating unit:Organizational form is divided into basic document organizational form, priority file organizational form and senior File organization mode, organizational form creating unit is used for the wound of priority file organizational form and advanced file organizational form Build, priority organizational form, which is created, is divided into the establishment of priority organizational form and the establishment of asterisk organizational form, in electronic health record shelves Two empty tables can be created during the Database of case clearing system simultaneously, are priority tissue table and asterisk organizational form respectively Table, both major keys are all admission numbers, and the former variable is priority, and the latter does not have the change of other data in addition to admission number Amount;The heating temperature after user's read electronic patient file, or decide whether as asterisk in files-designated, when user is certain After part file heating temperature, admission number and priority etc. on a record, record can be increased in priority tissue table Level;After user is asterisk in certain part of files-designated, it can equally increase in asterisk organizational form table and be in hospital on a record, record Number;When user's cancellation priority, or when removing asterisk, the corresponding record of this bar file can be deleted from respective tissue table; Advanced file organizational form is created as, firstly the need of defining classification variable, regulation specific name and attribute, then needing definition can Select types of variables;Self-defined taxonomic organization's table can be set up after definition, major key is admission number, and variable is exactly to classify Title;User can carry out variables choice after being read to every part of electronic health record file to this part of file, and user completes to become After amount selection, system can increase a record in self-defined taxonomic organization's table, and major key is corresponding admission number, and variable is then The record of numerical value is carried out according to the selection of user;
Organizational form query unit:Organizational form inquiry is divided into Three models, respectively basic document hoc queries, preferential The inquiry of level file organization and advanced file hoc queries, wherein, it can be carried out during user's selection basic document hoc queries straight Connect inquiry;When user selects priority file hoc queries, priority is chosen whether only to show the disease of some priority Archives are gone through, after the completion of selection, system builds SELECT statement and database file is inquired about according to the search request of user; During user's selection advanced file organizational form inquiry, the field to be inquired about is selected first, then the condition of selected inquiry, system Structure SELECT statement is inquired about database file after receiving instruction;
Organizational form output unit:For the output of organizational form, when user's selection is exported with certain organizational form, system root The sorting field and classificating requirement specified according to user, perform organizational form inquiry, and the database of temporary Query Result generation is regarded Figure, the path selected according to user and field requirement set up file in destination path, then the basis in data base view Store path under the result of each packet and each packet in each part electronic health record file record finds original storage path, And the original document is found according to the path, and the original document is sent to destination folder.
2. the file organization module according to claim 1 applied to electronic health record archive arrangement system, it is characterised in that: The specific name and attribute can be but be not limited to " disease stage ", " whether taking certain medicine ".
3. the file organization module according to claim 2 applied to electronic health record archive arrangement system, it is characterised in that: The optional types of variables of correspondence " disease stage " is " 1 phase ", " 2 phase " and " 3 phase ".
4. the file organization module according to claim 1 applied to electronic health record archive arrangement system, it is characterised in that: Optional types of variables corresponding to " whether taking certain medicine " is "Yes" and "No".
CN201710436537.6A 2017-06-09 2017-06-09 File organization module applied to electronic health record archive arrangement system Pending CN107273682A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710436537.6A CN107273682A (en) 2017-06-09 2017-06-09 File organization module applied to electronic health record archive arrangement system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710436537.6A CN107273682A (en) 2017-06-09 2017-06-09 File organization module applied to electronic health record archive arrangement system

Publications (1)

Publication Number Publication Date
CN107273682A true CN107273682A (en) 2017-10-20

Family

ID=60066100

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710436537.6A Pending CN107273682A (en) 2017-06-09 2017-06-09 File organization module applied to electronic health record archive arrangement system

Country Status (1)

Country Link
CN (1) CN107273682A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108563736A (en) * 2018-04-10 2018-09-21 口碑(上海)信息技术有限公司 The method and device of data is inquired based on data characteristics
CN109360651A (en) * 2018-12-12 2019-02-19 天津迈沃医药技术股份有限公司 Treatment history statistics generation method and system based on disease circle
CN110941650A (en) * 2019-11-22 2020-03-31 北京雅丁信息技术有限公司 Medical data statistical query system and method

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1300028A (en) * 2001-01-31 2001-06-20 宇汇资讯股份有限公司 Dynamic attribute database management retrieval method and system
CN101236555A (en) * 2007-01-31 2008-08-06 国际商业机器公司 Method and system for file management
US20090192979A1 (en) * 2008-01-30 2009-07-30 Commvault Systems, Inc. Systems and methods for probabilistic data classification
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association
WO2017042396A1 (en) * 2015-09-10 2017-03-16 F. Hoffmann-La Roche Ag Informatics platform for integrated clinical care

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1300028A (en) * 2001-01-31 2001-06-20 宇汇资讯股份有限公司 Dynamic attribute database management retrieval method and system
CN101236555A (en) * 2007-01-31 2008-08-06 国际商业机器公司 Method and system for file management
US20090192979A1 (en) * 2008-01-30 2009-07-30 Commvault Systems, Inc. Systems and methods for probabilistic data classification
WO2017042396A1 (en) * 2015-09-10 2017-03-16 F. Hoffmann-La Roche Ag Informatics platform for integrated clinical care
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108563736A (en) * 2018-04-10 2018-09-21 口碑(上海)信息技术有限公司 The method and device of data is inquired based on data characteristics
CN108563736B (en) * 2018-04-10 2021-04-27 口碑(上海)信息技术有限公司 Method and device for querying data based on data characteristics
CN109360651A (en) * 2018-12-12 2019-02-19 天津迈沃医药技术股份有限公司 Treatment history statistics generation method and system based on disease circle
CN110941650A (en) * 2019-11-22 2020-03-31 北京雅丁信息技术有限公司 Medical data statistical query system and method

Similar Documents

Publication Publication Date Title
Oesper et al. WordCloud: a Cytoscape plugin to create a visual semantic summary of networks
US9262584B2 (en) Systems and methods for managing a master patient index including duplicate record detection
CN103676645B (en) A kind of method for digging of the correlation rule in time series data stream
Rosenfeld et al. ImmuneDB, a novel tool for the analysis, storage, and dissemination of immune repertoire sequencing data
Li et al. Efficient discovery of risk patterns in medical data
US10572461B2 (en) Systems and methods for managing a master patient index including duplicate record detection
US8589424B1 (en) Method and system for accurate medical-code translation
CN109558494A (en) A kind of scholar&#39;s name disambiguation method based on heterogeneous network insertion
CN101438285A (en) Method for domain identification of documents in a document database
CN108874956A (en) Mass file search method, device, computer equipment and storage medium
CN107273682A (en) File organization module applied to electronic health record archive arrangement system
Ytow et al. Nomencurator: a nomenclatural history model to handle multiple taxonomic views
EP3039576A1 (en) Methods for semantic text analysis
JP2005250820A (en) XML document classification method in storage system
JP2013242675A (en) Dispersion information control device, dispersion information search method, data dispersion arrangement method and program
WO2011070979A1 (en) Dictionary creation device
Zhu et al. Developing a dynamic materialized view index for efficiently discovering usable views for progressive queries
Parvanova et al. A Web-based Platform to Share Harmonized Results from COVID-19 Clinical Studies
CN101609462A (en) Task recognition system and method under a kind of personal data space environment
JP6810780B2 (en) CNN infrastructure image search method and equipment
CN102119386A (en) Information retrieval device and corresponding method based on folded loose-leaf collection
Bodra Processing queries over partitioned graph databases: an approach and it's evaluation
Jia et al. Target-oriented keyword search over temporal databases
Kent He shoots, he scores: Navigating the complex world of transcriptomic scores in the age of artificial intelligence
Shamim et al. Intelligent data mining in autonomous heterogeneous distributed and dynamic data sources

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20171020

RJ01 Rejection of invention patent application after publication