CN113270170A - Data migration method and device, computer equipment and readable storage medium - Google Patents
Data migration method and device, computer equipment and readable storage medium Download PDFInfo
- Publication number
- CN113270170A CN113270170A CN202110595138.0A CN202110595138A CN113270170A CN 113270170 A CN113270170 A CN 113270170A CN 202110595138 A CN202110595138 A CN 202110595138A CN 113270170 A CN113270170 A CN 113270170A
- Authority
- CN
- China
- Prior art keywords
- data
- inspection
- migrated
- migration
- record data
- 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
Images
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H30/00—ICT specially adapted for the handling or processing of medical images
- G16H30/20—ICT specially adapted for the handling or processing of medical images for handling medical images, e.g. DICOM, HL7 or PACS
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/53—Querying
- G06F16/532—Query formulation, e.g. graphical querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/5866—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using information manually generated, e.g. tags, keywords, comments, manually generated location and time information
Abstract
The present application relates to the field of computer technologies, and in particular, to a data migration method and apparatus, a computer device, and a readable storage medium. The method comprises the following steps: acquiring inspection record data to be migrated; acquiring an inspection data set corresponding to inspection record data to be migrated; and matching the corresponding image data based on the inspection data set, and uploading the matched image data to a target database. By adopting the method, the migration speed and the migration accuracy for migrating the non-DICOM data and the DICOM data in the old PACS system to the new PACS system can be improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a data migration method and apparatus, a computer device, and a readable storage medium.
Background
With the rapid development of the digital information age, medical image Archiving and Communication Systems (PACS) are widely applied to hospital image departments, and the main task of the PACS is to store various medical images generated by hospitals in daily life, such as image data generated by Magnetic Resonance (MR), Computed Tomography (CT), Ultrasound (US), various X-ray machines, infrared instruments and other devices, in a digital manner, and when needed, the PACS can be quickly searched and retrieved under corresponding rights.
In a PACS system, examination related information of a patient is generally stored in a hierarchical structure, and for non-DICOM (Digital Imaging and Communications in Medicine) data, corresponding information is also recorded in a database.
When a PACS system is upgraded or needs to be replaced by a new PACS system, how to rapidly and accurately migrate non-DICOM data and DICOM data to the new PACS system is a problem to be solved urgently.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a data migration method, apparatus, computer device and readable storage medium capable of improving migration speed and migration accuracy.
A method of data migration, the method comprising:
acquiring inspection record data to be migrated;
acquiring an inspection data set corresponding to inspection record data to be migrated;
and matching the corresponding image data based on the inspection data set, and uploading the matched image data to a target database.
In one embodiment, acquiring the inspection record data to be migrated includes:
inserting the checking record data inquired from the database to be migrated into the migration database in a transaction mode;
and acquiring the inspection record data to be migrated from the migration database.
In one embodiment, before obtaining the check record data to be migrated from the migration database, the method further includes:
updating the data state of the check record data marked as migration failure in the migration database into a state to be migrated;
and acquiring the inspection record data of the state to be migrated to obtain the inspection record data to be migrated.
In one embodiment, examining the set of data comprises: and checking the recorded data and the corresponding image hierarchical structure relation.
In one embodiment, the queried check record data is inserted into the migration database and the check record data to be migrated is obtained from the migration database and processed by a multi-threaded or distributed system.
In one embodiment, matching the corresponding image data based on the inspection data set and uploading the matched image data to the target database is performed through the interface model.
In one embodiment, the method further includes:
and when the uploading of the image data is determined to be failed, uploading the matched image data to the target database again in a rollback transaction mode.
A data migration apparatus, the apparatus comprising:
the inspection record data acquisition module is used for acquiring the inspection record data to be migrated;
the inspection data set acquisition module is used for acquiring an inspection data set corresponding to the inspection record data to be migrated;
and the uploading module is used for matching the corresponding image data based on the inspection data set and uploading the matched image data to the target database.
A computer device comprising a memory storing a computer program and a processor implementing the steps of the method of any of the above embodiments when the processor executes the computer program.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method of any of the above embodiments.
According to the data migration method, the data migration device, the computer equipment and the readable storage medium, the inspection record data to be migrated are acquired, the inspection data set corresponding to the inspection record data to be migrated is acquired, the corresponding image data is further matched based on the inspection data set, and the matched image data is uploaded to the target database. Therefore, the corresponding inspection data set can be determined based on the acquired data of the inspection record to be migrated, the image data in the non-DICOM data format can be accurately matched based on the inspection data set, and the image data is uploaded to the target database after being matched, so that the non-DICOM data and the DICOM data can be uploaded to the target database together, and the accuracy of data migration and the migration speed can be improved.
Drawings
FIG. 1 is a diagram illustrating an example of an application scenario for a data migration method;
FIG. 2 is a flow diagram that illustrates a method for data migration in one embodiment;
FIG. 3 is a flow chart illustrating a data migration method according to another embodiment;
FIG. 4 is an overall architecture diagram of data migration in one embodiment;
FIG. 5 is a block diagram of a data migration apparatus in one embodiment;
FIG. 6 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The data migration method provided by the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. Specifically, the terminal 102 generates a migration instruction based on a trigger of the user, and sends the migration instruction to the server 104, so that the server 104 performs data migration based on the migration instruction. Specifically, the server 104 acquires the inspection record data to be migrated, and acquires an inspection data set corresponding to the inspection record data to be migrated. Further, the server 104 may match the corresponding image data based on the inspection data set, and upload the matched image data to the target database. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In one embodiment, as shown in fig. 2, a data migration method is provided, which is described by taking the application of the method to the server in fig. 1 as an example, and includes the following steps:
step S202, the inspection record data to be migrated is acquired.
The examination record data is data used for recording that the examination object has performed a relevant examination when the examination object performs an examination of a body part, and may include, for example, an object identifier, an examination log, an examination item, and the like of the examination object.
In this embodiment, the object identifier may refer to an identification number of the inspection object, or a registration number or the like that can indicate uniqueness of the inspection object.
In this embodiment, when the system needs to perform data migration, for example, when data in an old PACS system needs to be migrated to a new PACS system, all kinds of non-DICOM data stored hierarchically in the database need to be stored in the new PACS system according to the relationship between storage hierarchies in the old system, so that corresponding historical data can be retrieved in the new PACS system after the data migration is completed, and the consistency of information is ensured.
Specifically, the user can generate a migration instruction based on the terminal and send the migration instruction to the server, so that the server executes the scheme of the application to perform data migration when receiving the migration instruction.
In this embodiment, after receiving the migration instruction, the server may query the database to be migrated, and obtain the check record data to be migrated. The database to be migrated refers to the database of the old PACS system.
Step S204, acquiring an inspection data set corresponding to the inspection record data to be migrated.
In this embodiment, the server may obtain, based on the obtained inspection record data to be migrated, an inspection data set corresponding to the inspection record data to be migrated.
The inspection data set may be represented as study Collection, and the inspection data set may include, but is not limited to, inspection record data and corresponding image hierarchy relationship.
In this embodiment, the video hierarchy relationship refers to a hierarchy relationship between the inspection record data and the corresponding video data, and may specifically refer to a relationship between the video data and the inspection record data, the inspection information, the video sequence information, or the video information.
In this embodiment, the server may package the inspection record data and the acquired corresponding data based on the inspection record data to obtain the corresponding inspection record data.
And step S206, matching the corresponding image data based on the inspection data set, and uploading the matched image data to a target database.
In this embodiment, the server may match the corresponding image data based on the acquired inspection data set, and acquire the matched image data.
Specifically, the server may determine a data identifier or a data storage address of the corresponding image data based on the image information in the inspection data set, and acquire the corresponding image data based on the data identifier or the data storage address.
In this embodiment, after matching the corresponding image data, the server may upload the matched image data and the corresponding inspection data set to the target database, that is, migrate from the old PACS system to the new PACS system. For example, with continued reference to FIG. 3, the server may batch insert new PACS systems.
In the data migration method, the inspection record data to be migrated is acquired, the inspection data set corresponding to the inspection record data to be migrated is acquired, the corresponding image data is further matched based on the inspection data set, and the matched image data is uploaded to the target database. Therefore, the corresponding inspection data set can be determined based on the acquired data of the inspection record to be migrated, the image data in the non-DICOM data format can be accurately matched based on the inspection data set, and the image data is uploaded to the target database after being matched, so that the non-DICOM data and the DICOM data can be uploaded to the target database together, and the accuracy of data migration and the migration speed can be improved.
In one embodiment, the obtaining of the inspection record data to be migrated may include: inserting the checking record data inquired from the database to be migrated into the migration database in a transaction mode; and acquiring the inspection record data to be migrated from the migration database.
The migration database refers to a database for caching the queried inspection record data.
In this embodiment, the server may query the database to be migrated, determine whether the check record data is queried, and insert the queried check record data into the migration database.
Specifically, the server may set a migration time period in advance, and set data in a certain time range from start Date to end Date, for example, 2018.01.01 to 2018.12.30.
Further, the server may split the time range start Date to end Date into preset time intervals, for example, start Date to temp Date (start Date +1) with day as the time interval, 2018.01.01 to 2018.01.02, and query the database to be migrated to query the check record data of each preset time interval.
In this embodiment, referring to fig. 3, the server may perform data query in a polling manner, for example, set that a preset number of check record data are queried each time, and when the preset number of check record data are queried, insert the queried check record data into the migration database, and continue to query the database to be migrated.
In this embodiment, when the server queries the database to be migrated, a query time period may be set, and when the set query time period is reached, the server may determine the query result, and determine whether the check record data is queried, that is, determine whether the queried check record data to be migrated is empty. It is understood by those skilled in the art that "empty" refers to that none of the query log data is queried, and in other embodiments, it may also be understood that no query log data is queried for a predetermined number of check log data, for example, the predetermined number is 50, and when the number of the query log data is less than 50, it may also be determined that the query log data is empty.
In this embodiment, when the server determines that the query result is empty, the server may postpone the time interval by one day temp Date to temp Date +1, i.e., 2018.01.02 to 2018.01.03, and continue the query operation. The above steps are repeated until the query of all the inspection record data corresponding to the time ranges from start Date to end Date is completed.
In this embodiment, referring to fig. 4, when the server determines that the query result is not empty, the server may insert the queried inspection record data into the migration database, or the server may also insert the queried inspection record data into the migration database in batch, for example, insert the aforementioned 50 pieces of inspection record data queried each time into the migration database in batch.
In this embodiment, after the forward delay time interval is temp Date-temp Date +1, the server may determine the start time temp Date after forward delay, and determine whether the temp Date is greater than the total end time end Date. Specifically, when temp Date > end Date, it indicates that the query of the database to be migrated has been completed completely, and the server may stop continuing to query the database to be migrated.
In this embodiment, when the server queries the migration database, the query may be performed according to the check information hierarchy, and the queried check record data is inserted into the migration database.
In this embodiment, when the server inserts the migration database, the queried check record data may be inserted into the migration database in a transaction manner, that is, all the queried check record data are inserted into the migration database.
Further, the server may obtain each inserted check record data from the migration database to obtain the check record data to be migrated.
In this embodiment, the server may obtain each inserted check record data from the migration database, and add the check record data to the migration task queue, that is, with continued reference to fig. 4, produce the migration task, and perform subsequent processing.
Specifically, the server adds the check record data in the migration database to the migration task queue, which may be added to the migration task queue in chronological order, or may also add the check record data according to the hierarchical relationship between the data.
Further, the server may obtain the inspection record data from the migration task queue according to a preset adding condition, and add the inspection record data to the current task list.
Specifically, the preset adding condition may refer to a time condition, a business condition, or the like, for example, according to a time sequence, the inspection record data is obtained from the migration task queue and added to the current task queue, or the server may be correspondingly provided with a plurality of current task queues, each task queue corresponds to the inspection record data stored in different departments, and the server may store the inspection record data in the current task queues corresponding to the different departments according to the departments.
Further, the server may obtain the inspection record data from the current task queue and perform subsequent processing, i.e., the consumption migration task in fig. 4.
In this embodiment, after the server obtains the check record data from the migration database and adds the check record data to the migration task queue, it may further determine whether the migration task queue has a margin, and when it is determined that the migration task queue has a margin, continue to obtain the check record data from the migration database and add the check record data to the migration task queue.
In this embodiment, when the server determines that the migration task queue has no margin, the server may suspend obtaining the check record data from the migration database, and perform the determination of the margin again at preset time intervals.
In one embodiment, after the server obtains the inspection record data from the migration task queue and adds the inspection record data to the current task list, the server may also delete the overdue inspection record data in the current task list based on a preset deletion condition.
The deletion condition may be a time condition or the like.
Specifically, the server may determine a storage duration for each check record data stored in the current task list to be stored in the current task list, for example, determine whether the storage duration is greater than or equal to a preset storage duration threshold.
In this embodiment, with continuing reference to fig. 3, when the server determines that the storage duration is greater than or equal to the preset storage duration threshold, the server may determine that the check record data is overtime, and the server may delete the check record data from the current task list, that is, the overtime clearing task.
In one embodiment, the server may also delete data in the current task list based on other deletion conditions, for example, when the server determines that the inspection record data in the current task queue is not inspection record data of the current task queue, if the inspection record data is not inspection record data of a department corresponding to the current task queue, the server may delete the inspection record data. By deleting overtime check record data in the current task list, occupation of the overtime check record data on the current task queue can be avoided, and the capacity of the current task queue can be released in real time.
In the embodiment, the check record data is inserted in a transaction mode, so that the inquired check record data can be ensured to be completely inserted into the migration database, data insertion loss can be avoided, and the accuracy of inserting the check record data into the migration database can be improved.
In one embodiment, before obtaining the check record data to be migrated from the migration database, the method may further include: updating the data state of the check record data marked as migration failure in the migration database into a state to be migrated; and acquiring the inspection record data of the state to be migrated to obtain the inspection record data to be migrated.
In this embodiment, after the server inserts the queried check record data into the migration database, the data state of each inserted check record data may be set as a to-be-migrated state.
Meanwhile, the server can also judge the data state of each check record data in the migration database, and judge that each check record data is stateless data or check record data which fails to migrate.
In this embodiment, for stateless check record data, the server may first determine whether the check record data is uploaded or not and whether the upload is successful or not, and update the data state of the check record data to a to-be-migrated state when the upload is not successful or the upload is failed, and for check record data marked as migration failure, the server may change the data state of the check record data to the to-be-migrated state.
Further, the server may query the migration database, and obtain the inspection record data whose data state is the state to be migrated, so as to obtain the inspection record data to be migrated.
In one embodiment, the insertion of the queried check record data into the migration database and the retrieval of the check record data to be migrated from the migration database may be handled by a multi-threaded or distributed system.
Specifically, the server inserts the queried check record data into the migration database, and the obtaining of the check record data to be migrated from the migration database may be two threads processed in parallel, that is, the server is executed by two different threads, which do not interfere with each other.
In this embodiment, the server may perform processing on the insertion of the migration database and the acquisition of the check record data in parallel by branching threads in a multithreading or distributed system processing manner, so that concurrency of system operation may be improved, and data processing efficiency may be improved.
In one embodiment, the server matches the corresponding image data based on the inspection data set, and uploads the matched image data to the target database may also be performed in parallel.
In this embodiment, for the same inspection data set, the number of the corresponding image data may be greater than 1, that is, at least 2, and the server may perform matching of the image data in a multi-thread parallel manner, and upload the matched image data to the target database.
In one embodiment, matching the corresponding image data based on the inspection data set and uploading the matched image data to the target database may be performed through an interface model.
The interface model refers to a model for executing data migration, and the interface model can provide an interface to acquire data from a specified location and store the data to a target location through a migration interface.
In this embodiment, the interface model may provide a data acquisition interface, and match the image information of each image data to the corresponding image data. For example, the image data may be matched to a Storage location based on the image information, for example, the image data may be obtained from the Storage location after being stored in a local database, stored in a File Transfer Protocol (FTP) server, stored in an Object Storage Service (OBS), or the like, or the image data may be matched to the corresponding image data based on the image identifier or the data identifier directly.
In this embodiment, after the data acquisition interface of the interface model is matched and corresponding image data is acquired, the server may store the image data to a target location, that is, a target database, through the migration interface of the interface model.
Specifically, the interface model may store the acquired image data in a corresponding storage location of the target database according to an image hierarchical structure relationship of the image data.
In one embodiment, before the server uploads the matched image data to the target database, the method may further include: and compressing the matched image data to generate corresponding compressed data.
In this embodiment, after the server matches the corresponding image data, the image data may be written into the memory stream, and then the memory stream is compressed by using a compression algorithm, so as to obtain compressed data after compression processing, for example, Run Length Encoding (RLE), huffman, Rice, Lempel-Ziv, and the like.
In one embodiment, the compression processing performed by the server on the image Data may be Encryption compression processing, that is, while the image Data is compressed, the image Data may also be encrypted, for example, by using MD5, Secure Hash Algorithm 1 (SHA 1), RSA, Advanced Encryption Standard (AES) Algorithm, Data Encryption Standard (DES) Algorithm, and the like, so as to improve the security during the Data migration process.
In one embodiment, the method may further include: and when the uploading of the image data is determined to be failed, uploading the matched image data to the target database again in a rollback transaction mode.
In this embodiment, after the server uploads the matched image data to the target database, the server may receive feedback data fed back by the target database, and determine the image data based on the feedback data.
In this embodiment, the feedback data may include result data of successful upload or unsuccessful upload, and may also include specific upload time data, reason data of unsuccessful upload, and the like, such as upload timeout, an excessively large amount of upload data, and the like.
In this embodiment, the server may determine whether the uploading of the image data is successful based on the feedback data, and when the uploading fails, upload the matched image data to the target database again in a rollback transaction manner.
Specifically, the server may set the rollback number, for example, set the rollback number to three, and generate the prompt information and feed the prompt information back to the terminal when the set rollback number fails to be uploaded.
In this embodiment, the server may also actively record the migrated data amount, and determine whether the uploading of the image data fails based on the migrated data amount.
In this embodiment, after each migration of one image data, the server may calculate the data amount of the image data that has been successfully migrated or has been migrated, so as to record the migrated data amount of the migrated image data.
Further, the server may determine whether the migration of the image data is completed according to the migrated data amount, for example, determine whether the migrated data amount is equal to the data amount of the image data corresponding to the check data set.
In this embodiment, when the server determines that the migrated data amount is equal to the data amount of the image data corresponding to the inspection data set, it determines that the image data corresponding to the inspection data set has been migrated, and then performs migration processing on the image data corresponding to the next inspection data set.
In this embodiment, when the server determines that the migrated data amount is smaller than the data amount of the image data corresponding to the inspection data set, it determines that the migration of the image data corresponding to the inspection data set is not completed, and the server may continue to perform the migration of the image data through the interface model.
It should be understood that although the various steps in the flow charts of fig. 2-4 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-4 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least some of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 5, there is provided a data migration apparatus including: an inspection record data acquisition module 100, an inspection data set acquisition module 200, and an upload module 300, wherein:
an inspection record data obtaining module 100, configured to obtain inspection record data to be migrated.
An inspection data set obtaining module 200, configured to obtain an inspection data set corresponding to inspection record data to be migrated.
And an uploading module 300, configured to match corresponding image data based on the inspection data set, and upload the matched image data to the target database.
In one embodiment, the inspection record data obtaining module 100 may include:
the insertion sub-module is used for inserting the checking record data inquired from the database to be migrated into the migration database in a transaction mode;
and the acquisition submodule is used for acquiring the data of the check record to be migrated from the migration database.
In one embodiment, the apparatus may further include:
and the state updating module is used for updating the data state of the check record data marked as migration failure in the migration database into the state to be migrated before acquiring the check record data to be migrated from the migration database.
And the acquisition module is used for acquiring the inspection record data of the state to be migrated to obtain the inspection record data to be migrated.
In one embodiment, examining the data set may include: and checking the recorded data and the corresponding image hierarchical structure relation.
In one embodiment, the insertion of the queried check record data into the migration database and the retrieval of the check record data to be migrated from the migration database may be handled by a multi-threaded or distributed system.
In one embodiment, matching the corresponding image data based on the inspection data set and uploading the matched image data to the target database may be performed through an interface model.
In one embodiment, the apparatus may further include:
and the rollback module is used for uploading the matched image data to the target database again in a rollback transaction mode when the uploading failure of the image data is determined.
For specific limitations of the data migration apparatus, reference may be made to the above limitations of the data migration method, which will not be described herein again. The modules in the data migration apparatus may be implemented in whole or in part by software, hardware, and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 6. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing data such as examination record data, image sequence information, image data and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data migration method.
Those skilled in the art will appreciate that the architecture shown in fig. 6 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, there is provided a computer device comprising a memory storing a computer program and a processor implementing the following steps when the processor executes the computer program: acquiring inspection record data to be migrated; acquiring an inspection data set corresponding to inspection record data to be migrated; and matching the corresponding image data based on the inspection data set, and uploading the matched image data to a target database.
In one embodiment, the obtaining of the inspection record data to be migrated is realized when the processor executes the computer program, and may include: inserting the checking record data inquired from the database to be migrated into the migration database in a transaction mode; and acquiring the inspection record data to be migrated from the migration database.
In one embodiment, before the processor executes the computer program to obtain the check record data to be migrated from the migration database, the following steps may be further implemented: updating the data state of the check record data marked as migration failure in the migration database into a state to be migrated; and acquiring the inspection record data of the state to be migrated to obtain the inspection record data to be migrated.
In one embodiment, examining the data set may include: and checking the recorded data and the corresponding image hierarchical structure relation.
In one embodiment, the processor, when executing the computer program, implements the insertion of the queried check record data into the migration database and the retrieval of the check record data to be migrated from the migration database to be processed by a multi-threaded or distributed system.
In one embodiment, the processor executes the computer program to match the corresponding image data based on the inspection data set, and upload the matched image data to the target database is performed through the interface model.
In one embodiment, the processor, when executing the computer program, may further implement the following steps: and when the uploading of the image data is determined to be failed, uploading the matched image data to the target database again in a rollback transaction mode.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring inspection record data to be migrated; acquiring an inspection data set corresponding to inspection record data to be migrated; and matching the corresponding image data based on the inspection data set, and uploading the matched image data to a target database.
In one embodiment, the computer program, when executed by the processor, for obtaining the inspection record data to be migrated, may include: inserting the checking record data inquired from the database to be migrated into the migration database in a transaction mode; and acquiring the inspection record data to be migrated from the migration database.
In one embodiment, before the computer program is executed by the processor to obtain the check record data to be migrated from the migration database, the following steps may be further implemented: updating the data state of the check record data marked as migration failure in the migration database into a state to be migrated; and acquiring the inspection record data of the state to be migrated to obtain the inspection record data to be migrated.
In one embodiment, examining the data set may include: and checking the recorded data and the corresponding image hierarchical structure relation.
In one embodiment, the computer program when executed by the processor implements the insertion of queried inspection record data into the migration database and retrieval of inspection record data to be migrated from the migration database for processing by a multi-threaded or distributed system.
In one embodiment, the computer program when executed by the processor implements matching corresponding image data based on the inspection data set and uploading the matched image data to the target database is performed through the interface model.
In one embodiment, the computer program when executed by the processor may further implement the steps of: and when the uploading of the image data is determined to be failed, uploading the matched image data to the target database again in a rollback transaction mode.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method of data migration, the method comprising:
acquiring inspection record data to be migrated;
acquiring an inspection data set corresponding to the inspection record data to be migrated;
and matching corresponding image data based on the inspection data set, and uploading the matched image data to a target database.
2. The method of claim 1, wherein the obtaining inspection record data to be migrated comprises:
inserting the checking record data inquired from the database to be migrated into the migration database in a transaction mode;
and acquiring the inspection record data to be migrated from the migration database.
3. The method of claim 2, wherein prior to obtaining the check record data to be migrated from the migration database, further comprising:
updating the data state of the check record data marked as migration failure in the migration database into a state to be migrated;
and acquiring the inspection record data of the state to be migrated to obtain the inspection record data to be migrated.
4. The method of claim 2, wherein the inserting of the queried inspection record data into the migration database and the retrieving of the inspection record data to be migrated from the migration database are processed by a multi-threaded or distributed system.
5. The method of any of claims 1 to 4, wherein inspecting the set of data comprises: the inspection record data and the corresponding image hierarchical structure relationship.
6. The method according to any one of claims 1 to 4, wherein the matching of the corresponding image data based on the inspection data set and the uploading of the matched image data to the target database are performed through an interface model.
7. The method according to any one of claims 1 to 4, further comprising:
and when the uploading of the image data is determined to be failed, uploading the matched image data to the target database again in a rollback transaction mode.
8. An apparatus for data migration, the apparatus comprising:
the inspection record data acquisition module is used for acquiring the inspection record data to be migrated;
an inspection data set acquisition module, configured to acquire an inspection data set corresponding to the inspection record data to be migrated;
and the uploading module is used for matching the corresponding image data based on the inspection data set and uploading the matched image data to a target database.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110595138.0A CN113270170A (en) | 2021-05-28 | 2021-05-28 | Data migration method and device, computer equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110595138.0A CN113270170A (en) | 2021-05-28 | 2021-05-28 | Data migration method and device, computer equipment and readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113270170A true CN113270170A (en) | 2021-08-17 |
Family
ID=77233582
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110595138.0A Pending CN113270170A (en) | 2021-05-28 | 2021-05-28 | Data migration method and device, computer equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113270170A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106919608A (en) * | 2015-12-25 | 2017-07-04 | 中国移动通信集团公司 | Medical data processing method, device and platform |
| CN110019133A (en) * | 2017-12-21 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Online data moving method and device |
| CN110825693A (en) * | 2019-10-25 | 2020-02-21 | 武汉联影医疗科技有限公司 | Medical data storage method, device and readable storage medium |
| CN111078910A (en) * | 2019-12-06 | 2020-04-28 | 武汉联影医疗科技有限公司 | Medical image storage method, device, system, equipment and storage medium |
| CN112527923A (en) * | 2020-12-17 | 2021-03-19 | 武汉联影医疗科技有限公司 | Unstructured data storage method and device, computer equipment and storage medium |
| CN112687375A (en) * | 2021-01-06 | 2021-04-20 | 武汉联影医疗科技有限公司 | DICOM file transmission method, system, device, server and storage medium |
| CN112699098A (en) * | 2020-12-31 | 2021-04-23 | 中国农业银行股份有限公司 | Index data migration method, device and equipment |
-
2021
- 2021-05-28 CN CN202110595138.0A patent/CN113270170A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106919608A (en) * | 2015-12-25 | 2017-07-04 | 中国移动通信集团公司 | Medical data processing method, device and platform |
| CN110019133A (en) * | 2017-12-21 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Online data moving method and device |
| CN110825693A (en) * | 2019-10-25 | 2020-02-21 | 武汉联影医疗科技有限公司 | Medical data storage method, device and readable storage medium |
| CN111078910A (en) * | 2019-12-06 | 2020-04-28 | 武汉联影医疗科技有限公司 | Medical image storage method, device, system, equipment and storage medium |
| CN112527923A (en) * | 2020-12-17 | 2021-03-19 | 武汉联影医疗科技有限公司 | Unstructured data storage method and device, computer equipment and storage medium |
| CN112699098A (en) * | 2020-12-31 | 2021-04-23 | 中国农业银行股份有限公司 | Index data migration method, device and equipment |
| CN112687375A (en) * | 2021-01-06 | 2021-04-20 | 武汉联影医疗科技有限公司 | DICOM file transmission method, system, device, server and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6573443B2 (en) | Digital medical image data storage system | |
| WO2020233352A1 (en) | Block chain data chaining method, device, computer apparatus and storage medium | |
| CN111078910A (en) | Medical image storage method, device, system, equipment and storage medium | |
| CN110767291A (en) | Medical image processing method, apparatus and storage medium | |
| US8638997B2 (en) | Methods and systems for medical image processing, retrieval, and reviewing | |
| JP6268624B1 (en) | Data management system | |
| CN112017745B (en) | Decision information recommendation and drug information recommendation methods, devices, equipment and media | |
| US20140379635A1 (en) | System and Methods of Data Migration Between Storage Devices | |
| CN105765591A (en) | A system and method to pre-fetch comparison medical studies | |
| CN112527923A (en) | Unstructured data storage method and device, computer equipment and storage medium | |
| CN111131410A (en) | Image downloading method, computer device and storage medium | |
| CN110265104B (en) | Diagnostic report conformity detection method, device, computer equipment and storage medium | |
| US9405786B2 (en) | System and method for database flow management | |
| CN112256649A (en) | Medical file storage method and device | |
| CN113270170A (en) | Data migration method and device, computer equipment and readable storage medium | |
| CN110827959B (en) | Medical image processing method, device and storage medium | |
| US11915726B2 (en) | Recording device, readout device, recording method, recording program, readout method, readout program, and magnetic tape capable of shortening the reading of data recorded on a recording medium | |
| CN112182261A (en) | Image storage method and device, computer equipment and storage medium | |
| CN114822782A (en) | Medical image analysis method, system, apparatus, medium, and program product | |
| CN113096776A (en) | DICOM image file storage method, DICOM image file storage device, electronic equipment and DICOM image file storage medium | |
| CN111403005B (en) | Medical image data acquisition method and device, computer equipment and storage medium | |
| CN112416877A (en) | Medical data storage method and device, computer equipment and storage medium | |
| CN110718285B (en) | Data archiving method, system, device and storage medium | |
| JP6005951B2 (en) | Backup data storage and data backup system | |
| CN111724884A (en) | Generation of a resulting image |
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 |