CN109935285A - A kind of the structuring processing method and processing system of ICU nursing forms data - Google Patents
A kind of the structuring processing method and processing system of ICU nursing forms data Download PDFInfo
- Publication number
- CN109935285A CN109935285A CN201910090925.2A CN201910090925A CN109935285A CN 109935285 A CN109935285 A CN 109935285A CN 201910090925 A CN201910090925 A CN 201910090925A CN 109935285 A CN109935285 A CN 109935285A
- Authority
- CN
- China
- Prior art keywords
- nursing
- patient
- model
- table model
- icu
- 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
Links
Abstract
The invention discloses structuring processing methods and processing system that a kind of ICU nurses single semi-structured data, model is extracted by building dictionary table and structured message, and structuring screening storage is carried out to nursing forms data, it includes vital sign table model that the structured message, which extracts model, it checks and examines table model, patient enters liquid table model, patient goes out liquid table model and operation nursing table model, its drip irrigation device is, the keynote message that can be nursed in forms data to ICU carries out structuring processing, eliminate data structure difference, optimize the quality of data, realize the structured asso- ciation storage of data, just with subsequent query data, save the human cost and time cost of follow-up work, also the efficiency for improving scientific research is further helped in.
Description
Technical field
The present invention relates to medical data structuring process field is related to, in particular to a kind of ICU nurses the structure of forms data
Change processing method and processing system.
Background technique
Intensive care unit (ICU) is the place that medical information is intensive, mistake is high-incidence, shows the critical collection of conditions of patients
In, treatment time it is urgent continue, human resources relative deficiency, instrument type is more, store period is more, conduit quantity is more, work
The features such as intensity is big.The data information amount of patient with severe symptoms is huge: the various custodial care facilities of patient's bedside, vim and vigour, ventilator, infusion
The various Medical Instruments such as pumping plant, Continuous Renal Replace Threapy (CRRT) and extracorporeal membrane oxygenation (ECMO) need real-time management；Separately
According to statistics, the medical monitoring record of ICU may relate to up to 236 different data variables, the monitoring item of patient clinical information
Mesh and sample frequency are also significantly larger than general patient, and a huge ICU clinical medical data information bank is consequently formed.
From the point of view of the status of the current country, the clinical data of ICU is substantially recorded in nursing list, HIS (information for hospital system
System) or LIS (Laboratory Information Management System) it is inner, wherein ICU nursing be singly that nurse is critical to the state of an illness according to doctor's advice and the state of an illness,
The objective record of nursing process during the patient for needing to guard is hospitalized, data have recorded the current every life of patient in detail
The current state of patient has been reacted in the treatment that sign and patient are received, and data volume is big and covering scope is wide.But at present
ICU, which nurses forms data, to be stored in semi-structured form, and such nursing unirecord only being capable of team vital sign patient
Acquisition, browsing and assist diagnosis illness.And be difficult to for nursing forms data in keynote message realization automatically extract, conclude with
And further analysis and utilization.In semi-structured nursing list, the data format multiplicity of record, quality difference is very big, and data can weigh
Multiple availability is often also not especially high.A large amount of clinical data information cannot effectively integrate, and on the one hand lead to data information not
It can be used effectively, another aspect mass efficient information is ignored or loses.This, which results in a large amount of clinical datas, to be divided
Analysis and excavation.
It is not high and be difficult to the characteristics of obtaining cleaning that ICU nursing forms data is integrally presented various structures, publicity, with doctor
Also seem many information islands between each medical system of institute, there is no information interchange between each other and share, it is difficult to really play
Its clinical and scientific research value.Structuring processing is carried out to ICU nursing forms data, to later period medical data scientific research and artificial intelligence
Application of the medical treatment in ICU has significant role.
Therefore, it is necessary to which providing a kind of structuring processing scheme of ICU nursing forms data improves described in above-mentioned condition
Problem achievees the purpose that ICU clinical data conducive to clinical data analysis and excavation.
Summary of the invention
In view of the deficiencies of the prior art, the present invention intends to provide a kind of single semi-structured data of ICU nursing
Structuring processing method and processing system, to ICU nursing forms data in keynote message carry out structuring processing, eliminate data
Architectural difference optimizes the quality of data, realizes that the structured asso- ciation storage of data saves follow-up work just with subsequent query data
Human cost and time cost, also further help in improve scientific research efficiency.
Above-mentioned technical purpose of the invention has the technical scheme that
In a first aspect, the present patent application provides a kind of structuring processing method of single semi-structured data of ICU nursing, it is described
Method extracts model by building dictionary table and structured message and carries out structuring screening storage, the structure to nursing forms data
Change information extraction model includes vital sign table model, inspection inspection table model, patient enters liquid table model, patient goes out liquid table model
Table model is nursed with operation, the described method comprises the following steps:
Step 1: to project inducing classification all in nursing forms data, dictionary table is established, and provides default to dictionary table
The integrality of unit guarantee data；
Step 2: obtaining the nursing forms data of patient, judges that each intermediate item in nursing forms data is returned according to dictionary table
The structured message belonged to extracts model, extracts model according to different structured messages and carries out structuring processing；
If belonging to vital sign table model, according to vital sign table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, is stored in vital sign table；
If belong to inspection examine table model, according to check examine table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit check check table；
If belonging to patient enters liquid table model, according to patient enter liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient enter liquid table；
If belonging to patient goes out liquid table model, according to patient go out liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient go out liquid table；
If belong to operation nursing table model, according to operation nursing table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit operation nursing table.
Further preferably, for checking check table, addition patient ICU serial number and differentiation fluid acquisition in step 2
The quiet arterial blood label in source, and the related culture fluid information of addition test atmosphere, addition patient ICU serial number are convenient to disease
Understanding of people's single in section's checking information.
Further preferably, for vital sign table in step 2, addition indicate this record whether Yi Chang ERROR_
FLAG；For checking check table in step 2, addition indicate this record whether Yi Chang ERROR_FLAG item；For step
Patient goes out liquid table in two, addition indicate this record whether effective ERROR_FLAG.
Further preferably, liquid table entered for patient in step 2, the attached managing detailed catalogue item of the amount of being added into (such as unit,
Rate, concentration etc.), be conducive to handle the skimble-scamble data of unit, the conversion of simplicity amount.
Further preferably, for operation nursing table in step 2, when being related to drug and giving data, the chains such as addition doctor's advice ID
It is connected to doctor's advice information, conveniently seeks the doctor's advice source of patient's medication.
Second aspect, the present patent application provides a kind of structuring processing storage system of ICU nursing forms data, with above-mentioned knot
Structure processing method is corresponding, the dictionary table including being established according to project inducing classification all in nursing forms data and structuring
Information extraction model, the structured message extract model and include vital sign table model, check and table model, patient is examined to enter liquid
Table model, patient go out liquid table model and operation nursing table model；
When the nursing forms data for obtaining patient, judge what each intermediate item in nursing forms data was belonged to according to dictionary table
Structured message extracts model, extracts model according to different structured messages and carries out structuring processing:
If belonging to vital sign table model, according to vital sign table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, is stored in vital sign table；
If belonging to inspection examines table model, according to inspection check table table model to the content of the intermediate item in nursing list
Structured asso- ciation storage is carried out, deposit checks check table；
If belonging to patient enters liquid table model, according to patient enter liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient enter liquid table；
If belonging to patient goes out liquid table model, according to patient go out liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient go out liquid table；
If belong to operation nursing table model, according to operation nursing table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit operation nursing table.
Further preferably, for checking that check table, addition patient ICU serial number and the quiet of differentiation fluid acquisition source move
Arteries and veins blood label, and the related culture fluid information of addition test atmosphere, addition patient ICU serial number is convenient to exist to patient's single
The understanding of section's checking information.
Further preferably, for vital sign table, addition indicate this record whether Yi Chang ERROR_FLAG item；It is right
In check check table, addition indicate this record whether Yi Chang ERROR_FLAG item；Liquid table is gone out for patient, addition instruction should
Record whether effective ERROR_FLAG.
Further preferably, liquid table, attached managing detailed catalogue item (such as unit, rate, the concentration of the amount of being added into are entered for patient
Deng), be conducive to handle the skimble-scamble data of unit, the conversion of simplicity amount.
Further preferably, table is nursed for operation, when being related to drug and giving data, addition doctor's advice ID etc. is linked to doctor's advice
Information conveniently seeks the doctor's advice source of patient's medication.
In conclusion the present invention having the beneficial effect that on the one hand in contrast to the prior art, can nurse forms data to ICU
In keynote message carry out structuring processing, eliminate data structure difference, optimize the quality of data, realize the structured asso- ciation of data
Storage, just with subsequent query data, saves the human cost and time cost of follow-up work, also further helps in raising science
The efficiency of research；On the other hand, can based on structuring, treated that nursing forms data carries out data analysis and excavation, allow ICU
Nursing forms data can be fully used, its clinical and scientific research value be played, to later period medical data scientific research and artificial intelligence
Application of the energy medical treatment in ICU has significant role.
Detailed description of the invention
Fig. 1 is total frame of structuring process flow in embodiment；
Fig. 2 is the detail flowchart that forms data processing is nursed in structuring in embodiment；
Fig. 3 is provides the detail view of default units to dictionary table in embodiment；
Fig. 4 is in embodiment to the detail view for checking check table addition arteriovenous blood label and specimen information；
Fig. 5 is the detail view for adding doctor's advice ID link information in embodiment to operation nursing table.
Specific embodiment
Invention is described in further detail below in conjunction with attached drawing.
In a first aspect, the present patent application provides a kind of structuring processing method of single semi-structured data of ICU nursing, reference
Shown in Fig. 1 and Fig. 2, the method extracts model by building dictionary table and structured message and carries out structuring to nursing forms data
Screening storage, the structured message extract model and include vital sign table model, check and table model, patient is examined to enter liquid table mould
Type, patient go out liquid table model and operation nursing table model, the described method comprises the following steps:
Step 1: to project inducing classification all in nursing forms data, dictionary table is established, and provides default to dictionary table
The integrality of unit guarantee data (see Fig. 3)；
Step 2: obtaining the nursing forms data of patient, judges that each intermediate item in nursing forms data is returned according to dictionary table
The structured message belonged to extracts model, extracts model according to different structured messages and carries out structuring processing；
If belonging to vital sign table model, according to vital sign table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, is stored in vital sign table；
If belong to inspection examine table model, according to check examine table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit check check table；
If belonging to patient enters liquid table model, according to patient enter liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient enter liquid table；
If belonging to patient goes out liquid table model, according to patient go out liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient go out liquid table；
If belong to operation nursing table model, according to operation nursing table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit operation nursing table.
Further preferably, for checking check table, addition patient ICU serial number and differentiation fluid acquisition in step 2
The quiet arterial blood label in source, and the related culture fluid information of addition test atmosphere, addition patient ICU serial number are convenient to disease
Understanding of people's single in section's checking information (see Fig. 4).
Further preferably, for vital sign table in step 2, addition indicate this record whether Yi Chang ERROR_
FLAG；For checking check table in step 2, addition indicate this record whether Yi Chang ERROR_FLAG item；For step
Patient goes out liquid table in two, addition indicate this record whether effective ERROR_FLAG.
Further preferably, liquid table entered for patient in step 2, the attached managing detailed catalogue item of the amount of being added into (such as unit,
Rate, concentration etc.), be conducive to handle the skimble-scamble data of unit, the conversion of simplicity amount.
Further preferably, for operation nursing table in step 2, when being related to drug and giving data, the chains such as addition doctor's advice ID
It is connected to doctor's advice information, conveniently seeks the doctor's advice source of patient's medication (see Fig. 5).
Second aspect, the present patent application provides a kind of structuring processing storage system of ICU nursing forms data, with above-mentioned knot
Structure processing method is corresponding, the dictionary table including being established according to project inducing classification all in nursing forms data and structuring
Information extraction model, the structured message extract model and include vital sign table model, check and table model, patient is examined to enter liquid
Table model, patient go out liquid table model and operation nursing table model；
When the nursing forms data for obtaining patient, judge what each intermediate item in nursing forms data was belonged to according to dictionary table
Structured message extracts model, extracts model according to different structured messages and carries out structuring processing:
If belonging to vital sign table model, according to vital sign table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, is stored in vital sign table；
If belong to inspection examine table model, according to check examine table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit check check table；
If belonging to patient enters liquid table model, according to patient enter liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient enter liquid table；
If belonging to patient goes out liquid table model, according to patient go out liquid table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit patient go out liquid table；
If belong to operation nursing table model, according to operation nursing table model to nursing list in the intermediate item content into
The storage of row structured asso- ciation, deposit operation nursing table.
Further preferably, for checking that check table, addition patient ICU serial number and the quiet of differentiation fluid acquisition source move
Arteries and veins blood label, and the related culture fluid information of addition test atmosphere, addition patient ICU serial number is convenient to exist to patient's single
The understanding of section's checking information.
Further preferably, for vital sign table, addition indicate this record whether Yi Chang ERROR_FLAG item；It is right
In check check table, addition indicate this record whether Yi Chang ERROR_FLAG item；Liquid table is gone out for patient, addition instruction should
Record whether effective ERROR_FLAG.
Further preferably, liquid table, attached managing detailed catalogue item (such as unit, rate, the concentration of the amount of being added into are entered for patient
Deng), be conducive to handle the skimble-scamble data of unit, the conversion of simplicity amount.
Further preferably, table is nursed for operation, when being related to drug and giving data, addition doctor's advice ID etc. is linked to doctor's advice
Information conveniently seeks the doctor's advice source of patient's medication.
Specifically, the table structure of above-mentioned dictionary table successively includes ROW_ID (line number), ITEMID (item id), LABEL
(project name), ABBREVIATION (project is write a Chinese character in simplified form), DBSOURCE (data source), LINKSTO (chained list), CATEGORY
(project generic), UNITNAME (conventional unit), PARAM_TYPE (parameter type, as character string/numerical value/single choice is more
Choosing).For example, the item id of heart rate is 5330, it is abbreviated as ' HR ', this generic is ' life entity in nursing record form
Sign ', the LINKSTO item in dictionary table can be directed toward vital sign table, that is, representing this, specific value can be stored in life entity now
It levies in table, unit ' secondary/min ', value type is ' numerical value '.
As shown in figure 3, wherein UNITNAME by the logical text retrieval of dictionary table, utilized from nursing forms data project name
Function, which is torn open, selects unit, for example, taking ' secondary/min ', end-expiratory positive pressure (setting) when respiratory rate (setting) (secondary/min)
(cmH2O) ' cmH2O ' etc. is taken when, and the ITEMID for not matching and being added to, associative function are then filtered out by MySQL logic again
Added unit.
Next model is extracted to above-mentioned structured message to be described in detail, i.e., vital sign table model, inspection are examined
Table model, patient enter liquid table model, patient goes out liquid table model and the operation nursing corresponding table structure of table model is described in detail,
It is described below as occurred DRUG_DESCRIBE, refers to the specific note nursed in single (former data) to a certain contents of a project/result
Record.
One, vital sign table model
Its relevant vital sign table includes the ordinary life sign of patient and nurses any other relevant information to it,
Such as ventilator setting, the state of mind.Therefore, vital sign table is included in relation to the patient ICU most information being hospitalized
In.
The vital sign table table structure of existing building successively includes ROW_ID (line number), PATIENT_ID (patient's ID/ medical record
Number, people's only one), VISIT_ID (patient's admission number), ICU_ID (patient ICU serial number), an ITEMID (detection project
ID), OBSERVE_TIME (time of measuring), STORETIME (record time), VALUE (measured value), VALUENUM (measurement
As a result digital information), VALUEUOM (unit), ERROR_FLAG (instruction measured value whether abnormal), RESULTSTATUS (refer to
Determine measurement type, be " manual " or " automatic "), STOPPED (measure whether stop).Wherein, if VALUE measured value is numerical value
Type, then VALUENUM is corresponding number, if VALUE is not numeric type, VALUENUM is sky.
Data are directed toward vital sign by LINKSTO in the single former data of nursing and the dictionary table sorted out in vital sign table
The ITEMID of table is associated to be obtained.
For the patient code of PATIENT_ID, VISIT_ID, ICU_ID, PATIENT_ID and ICU_ID are obtained from former data
It takes, wherein admission time is carried out type conversion with patient's identification number (PATIENT_ID) using function by VISIT_ID and splicing obtains；
OBSERVE_TIME uses letter by the corresponding date of inspection item and time value recorded in nursing unit data
Number carries out splicing and type converts to obtain；
VALUE is defined using function, retains former data when nursing this in list and being recorded as numeric type；When in nursing list
When this is recorded as character string type, numerical information in character string is extracted；When this is recorded as the descriptive letter of plain text in nursing list
When breath, text information keyword is extracted.Such as: it is extracted in former data when eye opening reaction, limb motion, language response using function
This records numerical information in (DRUG_DESCRIBE)；DRUG_ is directly used when RASS scoring, TMP (mmHg), angiosthenia
DESCRIBE；GCS Coma Score Shi Ruoyuan data have record total score, then function extracts total score, will be in former data if without total score
The each event score for belonging to this is added to obtain total score etc..
ITEMID as major event event, OBSERVE_TIME, VALUE, VALUENUM, VALUEUOM, ERROR_FLAG,
RESULTSTATUS, STOPPED etc. are the attached description informations recorded under this ITEMID in nursing list, are repaired as attribute
Item is adornd to exist.Structured asso- ciation storage is so carried out just according to content of the vital sign table model to the intermediate item in nursing list
It is, after this nursing record and its attached description information are handled according to rule structuralisation, according in the vital sign table
All kinds of numbers of patient, carry out corresponding association with attribute modification item and store to database ITEMID major event event, form life entity
Levy table.
Two, it checks and examines table model
Check that check table table includes all laboratory measurements, such as blood gas analysis data.Its table structure successively includes
ROW_ID (line number), PATIENT_ID (patient's ID/ patient's identification number, people's only one), VISIT_ID (patient's admission number), ICU_ID
(patient ICU serial number), ITEMID (ID of a detection project), OBSERVE_TIME (time of measuring), VALUE (measurement
Value), VALUENUM (digital information of measurement result), VALUEUOM (unit), ERROR_FLAG (instruction measured value it is whether different
Often), BLOOD_FLAG (quiet artery mark), SPEC_ITEMID (sample code), SPEC_TYPE_DESC (sample title),
SPEC_NUM (sample number is used for external relations).
It note that the time relevant to this result is the time of fluid acquisition, rather than clinical staff can obtain these
The time of value.If VALUE measured value is numeric type, VALUENUM is corresponding number, if VALUE is not numeric type,
Then VALUENUM is sky.
Check in check table that data are directed toward inspection inspection by LINKSTO in the single former data of nursing and the dictionary table sorted out
The ITEMID of table is associated to be obtained.
PATIENT_ID, VISIT_ID, ICU_ID patient code obtain principle with vital sign table；OBSERVE_TIME,
By the corresponding date of inspection item and time value recorded in the single former data of nursing, splicing is carried out using function and type converts
It arrives；
VALUE is defined using function, retains former data when nursing this in list and being recorded as numeric type；When in nursing list
When this is recorded as character string type, wherein numerical information is extracted；When this is recorded as plain text descriptive information in nursing list,
Extract text information keyword；
As shown in figure 4, defined using function, when in the attached description information of this record, occur in nursing list keyword '
Venous' setting BLOOD_FLAG be 1, occur keyword ' Arterial ' be arranged BLOOD_FLAG be 2, others 3；It mentions again
The specimen information examined in the attached description information of this record in relation to this in nursing list is taken, SPEC_ITEMID is generated,
SPEC_TYPE_DESC, SPEC_NUM modify item, can more intuitive understanding test atmosphere, exclude the influence of test atmosphere.
Information above and patient code's information, ITEMID major event event etc. are associated storage.
Three, patient enters liquid table model
Patient enter liquid table table include patient ICU be hospitalized during it is all enter amount, specifically enter amount mode include vein input, it is micro-
Pump, continuous infusion pump, oral, nasal feeding, injection etc..
It successively includes that (patient's ID/ patient's identification number, a people is only by ROW_ID (line number), PATIENT_ID that patient, which enters liquid table table structure,
One), VISIT_ID (patient's admission number), ICU_ID (patient ICU serial number), ITEMID (treatment type ID), STARTTIME
(time started), ENDTIME (end time), LABEL (project name), AMOUNT (medication amount), RATEUOM (rate list
Position), RATE (rate), AMOUNTHOURLYUOM (medication amount unit per hour), AMOUNTHOURLY (medication amount per hour),
CONCENTRATIONUOM (concentration unit), CONCENTRATION (concentration), ON_OFF_FLAG (whether start and stop),
PASSAGE (access, such as: peripheral vein: left forearm), ORDERID (doctor's advice ID).When being related to drug and giving data, addition doctor
ID is advised, the doctor's advice source of patient's medication is conveniently sought.
Patient enters data in liquid table and enters liquid by LINKSTO direction patient in the single former data of nursing and the dictionary table sorted out
The ITEMID of table is associated to be obtained.
Wherein PATIENT_ID, VISIT_ID, ICU_ID patient code obtain principle with vital sign table.
By dictionary table extract it is all enter the relevant data of amount, identify under this ITEMID, retouch in conjunction with dictionary table
State the ancillary data of modification this ITEMID.Distinguishing major event event, (vein input Micropump, nasal feeding, takes orally, injects, is lasting defeated
Liquid pump etc.) and the description supplemental information as described under the event, be divided into: time, rate enter amount, concentration etc., will be same group above
Description modification item is generated after data combination, is put into patient with patient code, major event event correlation storage and is entered in liquid table.
Four, patient goes out liquid table model
It includes all outputs during patient ICU is hospitalized that patient, which goes out liquid table table, specifically goes out quantifier and includes urine, phlegm, various draws
Flow liquid etc..
It successively includes that (patient's ID/ patient's identification number, a people is only by ROW_ID (line number), PATIENT_ID that patient, which goes out liquid table table structure,
One), VISIT_ID (patient's admission number), ICU_ID (patient ICU serial number), ITEMID (measured value ID), OBSERVE_
TIME (time of measuring), VALUE (amount of output substance), VALUEUOM (unit of output substance), OUT_COLOUR (output
The color of matter), the OUT_STATUS character of substance (output), OUT_VOLUM (volume of output substance), OUT_WAVE (whether
Have liquid fluctuating), NEWBOTTLE (whether have new go out liquid), ERROR_FLAG (whether record effective).
Patient goes out data in liquid table and goes out liquid by LINKSTO direction patient in the single former data of nursing and the dictionary table sorted out
The ITEMID of table is associated to be obtained.
Wherein PATIENT_ID, VISIT_ID, ICU_ID patient code principle are the same as vital sign table；
The relevant data of all outputs are extracted by dictionary table, in conjunction with dictionary table, identifies under this ITEMID, retouches
The satellite information for stating this ITEMID, the modification attribute word as major event event exist.Such as ' urine: catheter, urine color, urine
Amount ' it is to extract urine volume occurrence with group data and be stored in VALUE, extract unit information therein ' ml ' deposit VALUEUOM, urine
Color corresponding informance ' Huang ' is stored in OUT_COLOUR etc..In another example other go out liquid item, ' sputum ' corresponding informance be ' sputum amount: in；Phlegm
Liquid color: yellow；In sputum characteristic: thick ', then extract wherein ' ' deposit VALUE, extracts colouring information therein ' Huang ' and is stored in OUT_
COLOUR extracts wherein ' thick ' deposit OUT_STATUS of trait information etc..
Go out in liquid table in patient, using ITEMID as major event event, OBSERVE_TIME, VALUE, VALUEUOM, OUT_
COLOUR, OUT_STATUS, OUT_VOLUM, OUT_WAVE are the attached descriptions recorded under this ITEMID in nursing list
It extracts in information, exists as modification item.So go out liquid table model according to patient to carry out the content of the intermediate item in nursing list
Structured asso- ciation storage is exactly, after this nursing record and its attached description information are handled according to rule structuralisation, according to
All kinds of numbers of patient, ITEMID major event event, attribute modification item, medical care information, the monitoring with this in the vital sign table
Item (NEWBOTTLE, ERROR_FLAG), which is associated, to be stored to database, is formed patient and is gone out liquid table.
Five, operation nursing table model
Operation nursing table includes the treatment operation received between patient ICU hospital stay and Related Nursing project etc., such as move/
Vein Tube, bedsore evaluation, anticoagulant flushing etc..
Operating nursing table table structure successively includes that (patient's ID/ patient's identification number, a people is only by ROW_ID (line number), PATIENT_ID
One), VISIT_ID (patient's admission number), ICU_ID (patient ICU serial number), ITEMID (item id), STARTTIME (open
Begin the time), ENDTIME (end time), VALUE (result), VALUEUOM (measurement unit), LOCATION (operating position, such as
Without being then shown as NULL), LOCATIONCATEGORY (the affiliated catalogue of LOCATION), ORDERID (doctor's advice ID), ORDERNAME
(doctor's advice title), LINKORDERID (connection doctor's advice ID), ORDERCATEGORYNAME (given drug first-level class directory name),
SECONDARYORDERCATEGORYNAME (given drug subclassificatio directory name)
Data go out liquid by LINKSTO direction patient in the single former data of nursing and the dictionary table sorted out in operation nursing table
The ITEMID of table is associated to be obtained.
Wherein PATIENT_ID, VISIT_ID, ICU_ID patient code principle are the same as vital sign table；
When extracting all relevant data of operations nursing by dictionary table, specifically to operate or nurse item as master
Body event (is stored, concrete meaning can be inquired in dictionary table) with its corresponding ITEMID, is operated the corresponding time and is stored in
STARTTIME and ENDTIME extracts corresponding satellite information under its operation, such as operating result, corresponding position are repaired as major event
Adorn item storage.
As shown in figure 5, all operations and nursing items can also be linked to doctor's advice information in storage in operation nursing table, remember
Doctor's advice state, medical staff's operation information etc. are recorded, the doctor's advice source of patient's operations is conveniently sought.It is being related to drug and is giving to grasp
When making, the relevant satellite information of drug, such as given drug classified catalogue etc., further associated storage can be extracted.
The above is only exemplary embodiment of the invention, protection scope and is not intended to limit the present invention, this hair
Bright protection scope is determined by the attached claims.
Claims (10)
1. a kind of structuring processing method of ICU nursing forms data, which is characterized in that the method passes through building dictionary table and knot
Structure information extraction model carries out structuring screening storage to nursing forms data, and it includes life that the structured message, which extracts model,
Sign table model checks and examines table model, patient enters liquid table model, patient goes out liquid table model and operate nursing table model, described
Method the following steps are included:
Step 1: to project inducing classification all in nursing forms data, dictionary table is established, and it is single to provide default to dictionary table
Position；
Step 2: obtaining the nursing forms data of patient, judges that each intermediate item in nursing forms data is belonged to according to dictionary table
Structured message extract model, extract model according to different structured message and carry out structuring processing；
If belonging to vital sign table model, tied according to content of the vital sign table model to the intermediate item in nursing list
Structure associated storage is stored in vital sign table；
If belonging to inspection examines table model, table model is examined to tie the content of the intermediate item in nursing list according to checking
Structure associated storage, deposit check check table；
If belonging to patient enters liquid table model, liquid table model is entered according to patient, the content of the intermediate item in nursing list is tied
Structure associated storage, deposit patient enter liquid table；
If belonging to patient goes out liquid table model, liquid table model is gone out according to patient, the content of the intermediate item in nursing list is tied
Structure associated storage, deposit patient go out liquid table；
If belonging to operation nursing table model, tied according to content of the operation nursing table model to the intermediate item in nursing list
Structure associated storage, deposit operation nursing table.
2. a kind of structuring processing method of ICU nursing forms data according to claim 1, which is characterized in that for step
Check table, addition patient ICU serial number and the quiet arterial blood label for distinguishing fluid acquisition source, and addition inspection are checked in rapid two
Test the related culture fluid information of environment.
3. a kind of structuring processing method of ICU nursing forms data according to claim 1, which is characterized in that for step
Vital sign table in rapid two, addition indicate this record whether Yi Chang ERROR_FLAG item；It is examined for being checked in step 2
Table, addition indicate this record whether Yi Chang ERROR_FLAG item；Liquid table is gone out for patient in step 2, addition indicates this
Record whether effective ERROR_FLAG.
4. a kind of structuring processing method of ICU nursing forms data according to claim 1, which is characterized in that for step
Patient enters liquid table, the attached managing detailed catalogue item (such as unit, rate, concentration) for the amount of being added into rapid two.
5. a kind of structuring processing method of ICU nursing forms data according to claim 1, which is characterized in that for step
Operation nursing table in rapid two, when being related to drug and giving data, addition doctor's advice ID etc. is linked to doctor's advice information.
6. a kind of structuring processing system of ICU nursing forms data, which is characterized in that including according to all in nursing forms data
The dictionary table and structured message that project inducing classification is established extract model, and it includes life entity that the structured message, which extracts model,
Table model is levied, is checked and is examined table model, patient enters liquid table model, patient goes out liquid table model and operate nursing table model；
When the nursing forms data for obtaining patient, the structure that each intermediate item in nursing forms data is belonged to is judged according to dictionary table
Change information extraction model, extract model according to different structured messages and carry out structuring processing:
If belonging to vital sign table model, tied according to content of the vital sign table model to the intermediate item in nursing list
Structure associated storage is stored in vital sign table；
If belonging to inspection examines table model, table model is examined to tie the content of the intermediate item in nursing list according to checking
Structure associated storage, deposit check check table；
If belonging to patient enters liquid table model, liquid table model is entered according to patient, the content of the intermediate item in nursing list is tied
Structure associated storage, deposit patient enter liquid table；
If belonging to patient goes out liquid table model, liquid table model is gone out according to patient, the content of the intermediate item in nursing list is tied
Structure associated storage, deposit patient go out liquid table；
If belonging to operation nursing table model, tied according to content of the operation nursing table model to the intermediate item in nursing list
Structure associated storage, deposit operation nursing table.
7. a kind of structuring processing system of ICU nursing forms data according to claim 6, which is characterized in that for inspection
Check table, addition patient ICU serial number and the quiet arterial blood label for distinguishing fluid acquisition source are looked into, and adds test atmosphere
Correlation culture fluid information.
8. a kind of structuring processing system of ICU nursing forms data according to claim 6, which is characterized in that for life
Order sign table, addition indicate this record whether Yi Chang ERROR_FLAG item；For checking check table, addition indicates the Xiang Ji
Record whether Yi Chang ERROR_FLAG item；Liquid table gone out for patient, addition indicate this record whether effective ERROR_FLAG
?.
9. a kind of structuring processing system of ICU nursing forms data according to claim 6, which is characterized in that for suffering from
Person enters liquid table, the attached managing detailed catalogue item (such as unit, rate, concentration) for the amount of being added into.
10. a kind of structuring processing system of ICU nursing forms data according to claim 6, which is characterized in that for behaviour
Make nursing table, when being related to drug and giving data, addition doctor's advice ID etc. is linked to doctor's advice information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910090925.2A CN109935285A (en) | 2019-01-30 | 2019-01-30 | A kind of the structuring processing method and processing system of ICU nursing forms data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910090925.2A CN109935285A (en) | 2019-01-30 | 2019-01-30 | A kind of the structuring processing method and processing system of ICU nursing forms data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109935285A true CN109935285A (en) | 2019-06-25 |
Family
ID=66985318
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910090925.2A Pending CN109935285A (en) | 2019-01-30 | 2019-01-30 | A kind of the structuring processing method and processing system of ICU nursing forms data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109935285A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110322942A (en) * | 2019-07-02 | 2019-10-11 | 慕勇峰 | A kind of generation method of Nursing writs, system and computer readable storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1869989A (en) * | 2005-05-23 | 2006-11-29 | 国际商业机器公司 | System and method for generating structured representation from structured description |
| WO2010099422A1 (en) * | 2009-02-26 | 2010-09-02 | Imdsoft, Inc. | Decision support |
| CN102509012A (en) * | 2011-11-04 | 2012-06-20 | 厦门市智业软件工程有限公司 | Method for mapping contents of electronic medical record into electronic medical record standard database |
| WO2015136578A1 (en) * | 2014-03-12 | 2015-09-17 | パナソニックＩｐマネジメント株式会社 | Health management system |
| CN106815337A (en) * | 2016-12-31 | 2017-06-09 | 深圳市易特科信息技术有限公司 | Medical big data associated storage system and method |
| CN108319605A (en) * | 2017-01-16 | 2018-07-24 | 医渡云（北京）技术有限公司 | The structuring processing method and system of medical examination data |
| CN109063507A (en) * | 2018-07-13 | 2018-12-21 | 上海派兰数据科技有限公司 | A kind of general design model for hospital information system analysis |
-
2019
- 2019-01-30 CN CN201910090925.2A patent/CN109935285A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1869989A (en) * | 2005-05-23 | 2006-11-29 | 国际商业机器公司 | System and method for generating structured representation from structured description |
| WO2010099422A1 (en) * | 2009-02-26 | 2010-09-02 | Imdsoft, Inc. | Decision support |
| CN102509012A (en) * | 2011-11-04 | 2012-06-20 | 厦门市智业软件工程有限公司 | Method for mapping contents of electronic medical record into electronic medical record standard database |
| WO2015136578A1 (en) * | 2014-03-12 | 2015-09-17 | パナソニックＩｐマネジメント株式会社 | Health management system |
| CN106815337A (en) * | 2016-12-31 | 2017-06-09 | 深圳市易特科信息技术有限公司 | Medical big data associated storage system and method |
| CN108319605A (en) * | 2017-01-16 | 2018-07-24 | 医渡云（北京）技术有限公司 | The structuring processing method and system of medical examination data |
| CN109063507A (en) * | 2018-07-13 | 2018-12-21 | 上海派兰数据科技有限公司 | A kind of general design model for hospital information system analysis |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110322942A (en) * | 2019-07-02 | 2019-10-11 | 慕勇峰 | A kind of generation method of Nursing writs, system and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US5921920A (en) | Intensive care information graphical display | |
| US8949108B2 (en) | Document processing, template generation and concept library generation method and apparatus | |
| CN110109887A (en) | Data retrieval method, electronic equipment and computer storage medium | |
| CN110036383A (en) | Knowledge based engineering electronic health record Automatic signature extraction | |
| KR101926632B1 (en) | A method of case learning and comments generation for clinical pathology examination using rule optimization | |
| Bouam et al. | An intranet-based automated system for the surveillance of nosocomial infections: prospective validation compared with physicians' self-reports | |
| CN108288130A (en) | Clinical care Performance Evaluation System and method based on data mining analysis platform | |
| CN111899837A (en) | Operation report coordination method and system based on digital operating room | |
| CN107408154A (en) | Computer assisted nursing stage structure | |
| Al-Mualemi et al. | A deep learning-based sepsis estimation scheme | |
| CN103093112B (en) | Prior-warning device | |
| CN109935285A (en) | A kind of the structuring processing method and processing system of ICU nursing forms data | |
| US20080147444A1 (en) | Blood product utilization system and methods | |
| Aronsky et al. | An integrated decision support system for diagnosing and managing patients with community-acquired pneumonia. | |
| WO2022141929A1 (en) | Health self-test system, server, and health testing system | |
| CN101501695A (en) | Systems and methods for associating nucleic acid profiles and proteomic profiles with healthcare protocols and guidelines in a decision support system | |
| CN113257371B (en) | Clinical examination result analysis method and system based on medical knowledge map | |
| Liu et al. | Research on the key technology based-nlp of chinese medicine pulse's mathematical quantifying | |
| CN116864056A (en) | Hospital nursing data processing method and platform | |
| CN112885457B (en) | Post-structured processing method, system and storage medium of medical big data | |
| CN117038094A (en) | Method and system for mining and analyzing specific disease knowledge based on clinical data | |
| Wang et al. | A childhood disease database based on word segmentation technology: Research and practice | |
| Zheng et al. | Semantic extraction and processing of medical records for patient-oriented visual index | |
| Kondo et al. | A computer system applying the face method to represent multiphasic tests | |
| CN115691738A (en) | Method for automatically identifying treatment completion condition of septic shock patient |
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: 20190625 |
|
| RJ01 | Rejection of invention patent application after publication |