Embodiment
Below by drawings and Examples, technical scheme of the present invention is described in further detail.
Fig. 1 is the process flow diagram of data archiving method first embodiment of the present invention, and as shown in Figure 1, present embodiment may further comprise the steps:
The client data ofstep 101, reception client upload, described client data is stored in the client data table.
It is example that present embodiment uploads to data center that data file with each medical institutions, client in this step is hospital's end for each medical institutions, each hospital's end all has infosystem separately, this infosystem is gathered the related data of each hospital's end self, such as patient information, diagnosis records etc., form the form of the tables of data of each hospital's end infosystem definition separately, also comprise client coding in this client data in order to the sign client, represent A hospital such as 01,02 represents B hospital, and this tables of data is uploaded to the front end processor of data center's front end.
Step 102, described client data table is converted to the filing data table, described filing data table internal memory contains the consolidation form data.
Front end processor has been set up data base management system (DBMS) when disposing, and the tables of data that has been pre-created consolidation form is the filing data table, and every tables of data contains a class content and a uniform format, but different types of tables of data form may be not quite similar.Front end processor is after receiving the client data of client upload, data interchange platform by front end processor is translated and is resolved this client data, be converted into the consolidation form data of front end processor definition, the client data table converted to the filing data table that stores the consolidation form data.
Step 103, the filing data table is uploaded to data center, deposits described consolidation form data in central database by described data center.
Front end processor is uploaded to data center with the filing data table that converts, and deposits the consolidation form data in the filing data table in central database by described data center and files.
Present embodiment makes that by at front end processor the client data table being converted to the filing data table of consolidation form this method can be general between heterogeneous system, has realized the unified filing of heterogeneous system data.
Fig. 2 is the signaling process figure of data archiving method second embodiment of the present invention, and as shown in Figure 2, present embodiment may further comprise the steps:
Step 201, client are uploaded to archiving server with client data.
Each medical institutions is that hospital's end is gathered each hospital's end related data separately by its inner infosystem, such as patient information, diagnosis records etc., form the form of the tables of data of each hospital's client information system definition, and this client data table is uploaded to archiving server.
Client information system of hospital should submit the information data of medical information data such as the outpatient service type and the type of being in hospital every day to, and the full dose data of dictionary table: medical personnel's dictionary table.Concrete submission time can be according to the reasonable arrangement of the different situations of various places and each medical institutions to reach the purpose of alleviating central server pressure, avoiding network congestion.Wherein, the infosystem of hospital internal is being worked out when archiving server is submitted the programmed logic of image data to, be as the regularly running separately of an independent handling procedure logic with this step, and not related with daily medical profession flow process in the hospital, promptly will not be somebody's turn to do the necessary condition of submitting to the image data success or not whether can continue to circulate to archiving server as the daily medical profession flow process of hospital.
Step 202, archiving server regularly are submitted to front end processor in batches with the client data table that receives, and this client data table is sent to the transmission file cache district of front end processor.
Step 203, front end processor are converted to the consolidation form data with client data, the client data table are converted to the filing data table of consolidation form.
The tables of data that front end processor has been pre-created consolidation form is the filing data table, and every tables of data contains a class content and a uniform format, but different types of filing data sheet format may be not quite similar.The Various types of data table can constantly be improved upgrading to satisfy the demand of different medical mechanism.Following table 1 is a tabular example of data, and this tables of data is used for describing every information of doctor's advice aspect.
Table 1 doctor's advice detail list
| Data item | Field name | Data type | Byte | Could be sky | Explanation |
| Doctor's advice ID | YZID | Character string | 32 | Not | The associating major key is seen explanation (1) |
| Cancel sign | CXBZ | Character | 1 | Not | The associating major key, coding.1: normal; 2: cancel this doctor's advice |
| The prescription on individual diagnosis serial number | JZLSH | Character string | 32 | Not | See explanation (2) |
| The doctor's advice explanation | YZSM | Character string | 256 | Be | See explanation (3) |
| Card number | KH | Character string | 25 | Not | See explanation (4) |
| Medical institutions' code | YLJGDM | Character string | 11 | Not | |
| Assign section office's coding | XDKSBM | Character string | 15 | Not | Coding.See section office's dictionary table |
| The lesion | BQ | Character string | 32 | Be | The lesion at patient place |
| Carry out section office's coding | ZXKSBM | Character string | 15 | Not | The concrete section office that carry out doctor's advice.Coding.See section office's dictionary table |
| Doctor's advice is assigned people's job number | XDRGH | Character string | 16 | Not | Job number by the corresponding doctor of hospital internal is filled in.See medical personnel's dictionary table |
| Intelligent's name under the doctor's advice | XDRXM | Character string | 32 | Not | |
| Doctor's advice executor's job number | ZXRGH | Character string | 16 | Be | Confirm that by hospital internal the nurse's of doctor's advice job number fills in.See medical personnel's dictionary table |
| Doctor's advice executor's name | ZXRXM | Character string | 32 | Be | |
| The doctor's advice group number | YZZH | Character string | 32 | Be | |
| The detailed coding of doctor's advice | YZMXBM | Character string | 15 | Not | See explanation (5) |
| The detailed title of doctor's advice | YZMXMC | Character string | 256 | Not | See explanation (5) |
| The doctor's advice classification | YZLB | Character string | 1 | Not | Coding.1: long-term; 2: interim; 3: leave hospital; 9: other |
| Doctor's advice is assigned the time | YZXDSJ | Time | | Not | |
| The doctor's advice execution time | YZZXSJ | Time | | Be | |
| The doctor's advice termination time | YZZZSJ | Time | | Be | |
| Drug specifications | YPGG | Character string | | | |
| The medicine usage | YPYF | Character string | | | |
| Dosage | YYJL | Character string | 32 | Be | See explanation (6) |
| The medication frequency | YYPD | Character string | 32 | Be | See explanation (7) |
| Send out pharmaceutical quantities | FYJL | Character string | 32 | Be | See explanation (8) |
| Inspection area | JCBW | Character string | 32 | Be | See explanation (9) |
| Remarks | BZ | Character string | 1024 | Be | Special explanation |
| Level of confidentiality | MJ | Character string | 16 | Be | See explanation (10) |
About being described as follows of above-mentioned table 1:
(1) doctor's advice ID is the numbering of a doctor's advice of hospital internal unique identification, must guarantee not repeat in this hospital.Recycle as the sequence number in the hospital, can adopt the mode that adds the date in front to avoid repetition (form: YYYYMMDD).All doctor's advices of being abrogated should not made a report on.To the doctor's advice of having made a report on do not think have need to revise may, for this detail, will disregard as repeating to make a report on identical doctor's advice ID to making a report on.For the hospital that possesses complete doctor workstation function, the doctor's advice of zero cost also can be made a report on and upload; For the hospital that does not temporarily possess complete function, can only make a report on the doctor's advice of uploading non-zero cost earlier and get final product.
(2) the prescription on individual diagnosis serial number is the external key of this table, is used for related with the diagnosis records epiphase.
(3) the doctor's advice explanation is the character property explanation to this doctor's advice.
(4) " card number " is in order to associated patient individual's index.
(5) the detailed coding/title of doctor's advice:, then upload coding and title in the order of magnitude dictionary table if this doctor's advice detail is a charging item; If this doctor's advice detail is non-charging item, then upload the coding and the title of hospital oneself definition.
(6) dosage is meant that the patient once uses the amount of medicine.As: " once two ".
(7) the medication frequency is meant the number of times that uses medicine in the time period.As: " three times on the one ".
(8) sending out pharmaceutical quantities is meant corresponding to a doctor's advice and indicates the dose of issuing the patient.As: " two boxes ".Send out pharmaceutical quantities and needn't form the logical consistency relation that number calculates with dosage and frequency.
(9) inspection area illustrates checked position specially at the doctor's advice of medical inspection.
(10) regulation of making a report on of level of confidentiality is as follows: first control of filling in for special disease.Wherein 0: common disorder; 1: malignant tumour; 2: venereal disease; 3: other incurable disease; 9: other.All the other everybody reservations are standby, can all fill out 0.
The doctor's advice detail list of example is suitable in most hospitals shown in the above-mentioned table 1, and except that this doctor's advice tables of data, can also define patient information table, diagnosis records table, test rating table, bacterium table, drug sensitivity tests table, inspection report table and discharge abstract etc. as a result.
Data in the above-mentioned Various types of data table comprise the medical information data of hospital's end, assign the time etc. such as doctor's advice, also comprise dictionary data, this dictionary data is a coded format, assign section office's coding etc. such as medical institutions' code and doctor's advice, these coded datas all need the dictionary table support of being correlated with, and promptly dictionary table is used for explaining the implication of each coded representation, represent A hospital such as 01,02 represents B hospital.This dictionary table is stored in data center, and its definition is finished by country or local hygiene department.Hospital end can safeguard the partial content in this dictionary table and upgrade by the WEB mode, hospital's end maintenance update and obtain the examining of relevant departments after should can come into force from ammeter.
Front end processor after receiving the client data that archiving server uploads, by the data interchange platform of front end processor, to its translate, processing such as parsing, convert the client data sheet format to the front end processor definition and the filing data table of the consolidation form created.
Wherein, front end processor is after receiving the client data that archiving server uploads, must be after the filing data that receives client upload be made a report on information slip, its data interchange platform just begins this client data is handled, and the situation that the data interchange platform of front end processor just begins to handle that finishes takes place not make a report on occurs owing to a variety of causes causes the data of hospital end to make a report on delays in work avoiding.It is to be used to write down the situation that hospital's data are made a report on data and data interchange platform deal with data that this filing data is made a report on information slip, hospital's end is after data upload finishes, create and fill in this table, be revised as 0 such as the processing identification field in will showing, then identify hospital's end and upload ED, hospital's end is made a report on the transmission file cache district that information slip is uploaded to front end processor with this filing data then, transmission file cache district has uploaded data according to this table judgement hospital end and has finished, then the tables of data of just hospital's end of storage being uploaded sends data interchange platform to, data interchange platform begins the client data of uploading is handled, and after disposing, the processing identification field that filing data is made a report in the information slip is revised as 1, and the identification data switching plane is finished dealing with.Be filing data shown in the following table 2 and make a report on an example structure of information slip.
Table 2 filing data is made a report on information slip
Step 204, front end processor are uploaded to data center with the filing data table.
Front end processor is finished dealing with to client data at data interchange platform, the client data table is converted to the filing data table of consolidation form after, this filing data table is uploaded to data center.In addition, the storage space in the transmission file cache district of front end processor after the data interchange platform of front end processor is finished data upload, carries out the release work of storage space automatically.
Step 205, data center handle the data in the described filing data table, and deposit it in central database.
After the data of data center in receiving the filing data table that front end processor uploads, at first check this legitimacy of uploading data, judge promptly whether this uploads data is the constraint condition that meets data center's database.For the data of eligible, be inserted into data center and hold in the corresponding tables of data; For the data of eligible not, data center's end will provide the client that feeds back to of misdata.
Data center check is uploaded the data legitimacy and makes the concrete steps of relevant treatment as follows: data center can be at first with the dictionary data in the tables of data of uploading promptly " coding " field contrast with the dictionary table that is stored in data center, whether the encoded radio that check is somebody's turn to do in " coding " field occurs in dictionary table.If occur, then carry out next step processing; Otherwise carry out error handling processing, promptly execution in step 206, and the result feeds back to client with misdata.
After having inspected dictionary data, data center's end is handled the patient information table earlier, and whether " card number " field in the patient information table that check hospital end is uploaded appears in the patient information table of data center's end.If have, then merge patient information, can carry out the comparison of patient information similarity, the patient information that the mark height is similar simultaneously; If do not have, illustrate that then this patient information increases newly, then be inserted in the patient information table of data center, be equivalent to the patient who increases newly is registered.
Data center continues the information of other filing data tables of check then.The diagnosis records table that the hospital of check earlier of data center end is uploaded, whether " card number " of the mark patient information in the check diagnosis records table appears in the patient information table of data center, the patient information table because data center has disposed in previous step, all patients' " card number " all has been recorded in the patient information table of data center, if then hospital holds the card number in the diagnosis records table of uploading not appear in the patient information table of data center, then carry out error handling processing; If the card number in the diagnosis records table that hospital end uploads is arranged in the patient information table of data center, then will be somebody's turn to do in the diagnosis records table of " card number " corresponding relevant diagnosis records insertion data center.
Then, whether data center's check hospital holds other " prescription on individual diagnosis serial numbers " that comprise in respectively the showing of " prescription on individual diagnosis serial number " field of uploading to appear in the diagnosis records table of data center.If have, the record of each table is inserted in each table of center-side correspondence; If do not have, then carry out error handling processing.Whether the test rating table that data center check hospital end is uploaded, bacterium appear in the inspection report table of data center as a result " medical institutions' code ", " survey report odd numbers ", " reporting date " three in table and the drug sensitivity tests table.If have, the record of each table is inserted in each table of center-side correspondence, if promptly the test rating table of uploading is held by hospital, bacterium is " the medical institutions' code " in table and the drug sensitivity tests table as a result, " survey report odd numbers ", appear at " reporting date " in the inspection report table of data center, then the content in the test rating table that hospital's end is uploaded is inserted in the inspection report table of data center, the bacterium that hospital end is uploaded is the bacterium as a result in the table that inserts data center of the content in the table as a result, and the content in the drug sensitivity tests table that hospital's end is uploaded is inserted in the drug sensitivity tests table of data center; If do not have, then carry out error handling processing.Whether data center also checks the pairing file of filename that occurs in " file chaining " field in inspection report table that hospital end uploads, the discharge abstract to exist.If have, then each file is deposited in center-side and store accordingly in the catalogue of this document; If do not have, then carry out error handling processing.
When inserting new data, data center also needs to know and modified logo is judged the correctness of the data of newly uploading according to the principal mark of each tables of data.Operating process to the inhomogeneity data can be as follows: normal data: assert after the data center systems retrieval, the major key of the data item of newly uploading not with the existing data item of center-side in any repetition, and the modified logo of new data is " normally ", then this is uploaded data item and be considered as normal data, and be inserted in the tables of data.Revise data: after the data center systems retrieval, assert, the existing data of the major key of certain bar data of newly uploading and center-side repeat, and the modified logo of new data is " revising data in the past ", then this is uploaded data and be considered as revising data, the center will cover the identical data of original major key with the full content of the data newly uploaded.Cancel data: after the data center systems retrieval, assert, the existing data of the major key of the data item of newly uploading and center-side repeat, and the modified logo of new data is " cancelling data in the past ", then this is uploaded data and is considered as cancelling data, and the data that original major key is identical will be done and cancel processing.Invalid data: after the data center systems retrieval, assert, the major key of the data item of newly uploading not with the existing data item of center-side in any repetition, but the modified logo of new data is " revising data in the past " or " cancelling data in the past ", then this is uploaded data item and be considered as invalid data, it is carried out discard processing.If the existing data of the major key of the data item of newly uploading and center-side repeat, and the modified logo of new data is " normally ", illustrate that hospital repeats to have uploaded (or more than) twice with these data, then this is uploaded data item and be considered as repeating data, it is carried out discard processing.Wherein, " diagnosis of being in hospital is detailed ", " DD detail " and " operation is detailed " three class data: consider the not recording operation daily record when handling this three classes business datum of hospital internal infosystem, therefore can't submit the modification of data to and cancel request.So this three classes processing method of data is, as long as there is this three classes data upload in hospital, then data center with the data whole of the same type of corresponding " prescription on individual diagnosis serial number " do cancel handle after, with the data newly uploaded as normal data.Therefore require hospital when submitting to, must guarantee the integrality of data for these three classes data.
Step 206, data center feed back to described client with data processed result.
Data center systems will be issued by the website, inside of district system the result of image data to hospital.Hospital can arrive in the corresponding page of website result is inquired about.The processing feedback result of issue comprises tables of data, submission data strip number, the successful data strip number of submission processing, the not successful deal with data bar number of date, time, processing.The not content of successful deal with data and not the cause for the success.Reason need be searched according to handling feedback result by hospital, after having solved the fault that exists, not successful data is carried out submit operation once more.
Present embodiment makes that by at front end processor the client data table being converted to the filing data table of consolidation form this method can be general between heterogeneous system, has realized the unified filing of data between heterogeneous system.
Fig. 3 is the structural representation of front end processor embodiment of the present invention, and as shown in Figure 3, the present embodiment front end processor comprises receiver module 301, processing module 302 and sending module 303.Wherein, receiver module 301 is used to receive the client data of client upload, and described client data is stored in the client data table; Processing module 302 is used for described client data table is converted to the filing data table, and described filing data table internal memory contains the consolidation form data; Sending module 303 is used for described filing data table is uploaded to data center, deposits described consolidation form data in central database by described data center.Further, the receiver module 301 of present embodiment front end processor can comprise first receiving element 3011 and second receiving element 3012, and wherein, first receiving element 3011 is used to receive the client formatted data of client upload; Second receiving element 3012 is used to receive the filing data of described client upload and makes a report on information slip, and described filing data is made a report on information slip and comprised the processing sign that identifies described client upload ED.Further, processing module 302 can also comprise first processing unit 3021 and second processing unit 3022, wherein, first processing unit 3021 is used for described client data is converted to the consolidation form data, and described client data table is converted to the filing data table, described consolidation form data storage is in the filing data table; Second processing unit 3022 is used for after described client formatted data is converted to the consolidation form ED, and the processing sign that described filing data is made a report in the information slip is revised as the processing sign that sign is converted to described client formatted data the consolidation form ED.
Particularly, receiver module 301 can be the transmission file cache district in the front end processor, it is the client data that hospital's end is uploaded that first receiving element 3011 in the receiver module 301 receives client, and this client data is stored in the client data table of each hospital's client information system definition; After this client data of client upload finishes, can create and fill in filing data and make a report on information slip, processing identification field in this table is revised as the sign of sign client upload ED, upload such as 0 representative data and to finish, fill in finish after, client is made a report on information slip with this filing data can be uploaded to front end processor by the WEB mode.Second receiving element 3012 of front end processor receives after filing data that these sign client upload data finish makes a report on information slip, and notification handler module 302 begins these data are handled.Processing module 302 can be the data interchange platform in the front end processor, processing such as the client data in the 3021 pairs of client data tables of first processing unit in the processing module 302 is translated, parsing, the consolidation form tables of data that the client data table is converted to front end processor definition and establishment is the filing data table; After data processing was finished, second processing unit 3022 was made a report on processing sign in the information slip with filing data and is revised as sign the client data table is converted to the processing sign of filing data end of list (EOL), finishes dealing with such as 1 representative data.Sending module 303 is after data processing is finished, and the filing data table that the client data table is converted to consolidation form is uploaded to data center and deposits central database in.
The present embodiment front end processor makes that by the client data table being converted to the filing data table of consolidation form this method can be general between heterogeneous system, has realized the unified filing of data between heterogeneous system.
Fig. 4 is the structural representation of data filing system embodiment of the present invention, and as shown in Figure 4, present embodiment data filing system comprises client 401, front end processor 402 and data center 403.Wherein, client 401 be used for number clients according to this client data table reach described front end processor 402 in form; The described client table that front end processor 402 is used for receiving from client 401 is converted to the filing data table, storage consolidation form data in the described filing data table, and described filing data table is uploaded to data center 403, front end processor 402 can adopt the structure shown in Fig. 3 embodiment; Data center 403 is used for depositing the consolidation form data of described filing data table in central database.Further, this data filing system also comprises archiving server 404, is used for the described client data table that stores described client data and is uploaded to described front end processor 402.Data center 403 can also comprise second processing module 4031, feedback module 4032, second receiver module 4033 and update module 4034, wherein, second processing module 4031 is used for whether the consolidation form data of described filing data table are met the correctness judgement and the processing of the central database constraint condition of data center 403; Feedback module 4032 is used for to client 401 feedback filing data results; Second receiver module 4033 is used to receive the dictionary table data that client 401 is uploaded; Update module 4034 is used for the described dictionary table of dictionary table Data Update according to described client upload.
Particularly, client 401 with the number clients of its insider information system collection according to this client data table reach archiving server 404 in form, regularly in bulk this client data table is uploaded to front end processor 402 by archiving server 404.Front end processor 402 is converted to the filing data table of consolidation form with the client data table of uploading, and it is uploaded to data center 403.Whether the consolidation form data in 4031 pairs of filing data tables of second processing module of data center 403 meet the legitimacy of central database condition of data center 403 and correctness judge and handle after, it is stored into central database.After the data processing of feedback module 4032 in 4031 pairs of filing data tables of second processing module finishes, data processed result is fed back to client 401.In addition, data center 403 stores in order to support the dictionary table of filing data table, this dictionary table can make an explanation to the dictionary encoding data in the filing data table and define, and this dictionary table can carry out real-time maintenance and renewal, client 401 can be safeguarded the dictionary table at data center 403 by the WEB mode, receive the dictionary table data that client 401 is uploaded by second receiver module 4033 in the data center 403, the dictionary table data of being uploaded according to this client 401 by update module 4034 are upgraded dictionary table again.
Present embodiment data filing system makes that by the client data table being converted to the filing data table of consolidation form this method can be general between heterogeneous system, has realized the unified filing of data between heterogeneous system.
It should be noted that at last: above embodiment is only in order to technical scheme of the present invention to be described but not limit it, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that: it still can make amendment or be equal to replacement technical scheme of the present invention, and these modifications or be equal to replacement and also can not make amended technical scheme break away from the spirit and scope of technical solution of the present invention.