Data storage query method and device, equipment and storage medium

Abstract

The invention relates to the technical field of data storage, and discloses a data storage query method and device, equipment and a storage medium. Firstly, to-be-stored medical data is acquired; and then, data separation is performed on the to-be-stored medical data as required to obtain recorded information and content data for respective storage, so that the flexibility of the system is improved, the storage pressure of the system is reduced, and long-term availability of the data is ensured. And finally, in order to ensure the traceability of the data, obtaining a storage position identifier of the content data, and carrying out associative storage on the storage position identifier and the recording information in a to-be-queried manner, so as to ensure the integrity of the data. As the recorded information and the content data are stored for a long time, the user can query the required data without tedious steps, the operation process is simplified, and the user experience is improved.

Description

Technical Field

[0001] The present invention relates to the field of data storage technology, and in particular to a data storage query method, device, equipment and storage medium. Background Art

[0002] Hospitals generate a large amount of various data in their daily operations, including imaging data and processing data, and as the scale of hospitals expands, the amount of data will increase significantly.

[0003] In the related art, PACS systems digitally store medical images and related information. However, due to the large amount of data and the long storage time required, PACS systems face storage overload issues. Therefore, a new data storage and query method is needed. Summary of the Invention

[0004] The embodiments of this specification are intended to at least to some extent solve one of the technical problems in the related art. To this end, the embodiments of this specification propose a data storage query method, apparatus, device and storage medium.

[0005] This specification provides a data storage query method, the method comprising:

[0006] Acquiring medical data to be stored;

[0007] Separating the medical data to be stored to obtain record information and content data for separate storage;

[0008] The storage location identifier of the content data is obtained, and the storage location identifier and the record information are associated and stored in a manner to be queried.

[0009] In one embodiment, the method further comprises:

[0010] Based on the storage space size of the database, the number of examination records per unit time, the storage space requirement of the preset attribute information, and the preset overall storage time information, the index attribute information of the storage table in the database is determined so as to extract the record information from the medical data to be stored based on the index attribute information, wherein the preset attribute information includes at least one attribute item, the index attribute information includes at least one index item, and the at least one index item corresponds to the at least one attribute item.

[0011] In one embodiment, the method further includes: storing the content data in an external expansion storage device; and associating and storing the storage location identifier and the record information in a manner to be queried, including:

[0012] Permanently storing the recorded information in a database of a primary storage and query device;

[0013] The record information and the storage location identifier are associated and stored in a database of the primary storage query device, wherein the primary storage query device can perform data transmission with the external expansion storage device.

[0014] In one embodiment, storing the content data in an external expansion storage device includes:

[0015] Performing data conversion on the content data to obtain sequence information and document information;

[0016] The sequence information and the document information are associated and stored in the external expansion storage device.

[0017] In one embodiment, the method further comprises:

[0018] The content data and / or the record information are backed up and stored, and the backup location identifier is stored in the database, wherein the backup location identifier and the record information are associated and stored in the database.

[0019] In one embodiment, the method further comprises:

[0020] In the case where a query instruction is received through the primary storage query device, determining query index data based on the query instruction;

[0021] Performing a query operation in the database based on the query index data to determine a target storage location identifier of the required target content data;

[0022] Locating a target external expansion storage device storing the target content data according to the target storage location identifier;

[0023] A query operation is performed in the target external expansion storage device based on the query index data to obtain the target content data and output the target content data.

[0024] In one embodiment, the method further comprises:

[0025] When the external expansion storage device storing the target content data is not located according to the target storage location identifier, prompt information including the target storage location identifier is output, so as to access the target external expansion storage device corresponding to the target storage location identifier based on the prompt information.

[0026] In one embodiment, the method further comprises:

[0027] In the case where it is determined that the target external expansion storage device does not have the target content data, performing a query operation in the database based on the query index data to determine a target backup location identifier of the required target content data;

[0028] Locating the target external expansion storage device storing the target content data according to the target backup location identifier;

[0029] A query operation is performed in the target external expansion storage device corresponding to the target backup location identifier based on the query index data to obtain the target content data.

[0030] The present disclosure provides a data storage query device, comprising:

[0031] A medical data acquisition module, used to acquire medical data to be stored;

[0032] A data separation module is used to separate the medical data to be stored to obtain record information and content data for separate storage;

[0033] The associated storage module is used to obtain the storage location identifier of the content data, and associate and store the storage location identifier and the record information in a manner to be queried.

[0034] An embodiment of the present specification provides a medical imaging device, comprising: a memory, and one or more processors communicatively connected to the memory; the memory stores instructions executable by the one or more processors, and the instructions are executed by the one or more processors to enable the one or more processors to implement the steps of the method described in any of the above embodiments.

[0035] An embodiment of this specification provides a computer device, which includes: a memory, and one or more processors communicatively connected to the memory; the memory stores instructions that can be executed by the one or more processors, and the instructions are executed by the one or more processors to enable the one or more processors to implement the steps of the method described in any of the above embodiments.

[0036] The embodiments of this specification provide a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the method described in any one of the above embodiments are implemented.

[0037] An embodiment of this specification provides a computer program product, which includes instructions. When the instructions are executed by a processor of a computer device, the computer device can perform the steps of the method described in any of the above embodiments.

[0038] In the aforementioned implementation method, the medical data to be stored is first acquired. Then, as needed, the medical data to be stored is separated to obtain record-keeping information and content data for separate storage. This improves system flexibility, reduces system storage pressure, and ensures long-term data availability. Finally, to ensure data traceability, the storage location identifier of the content data is obtained, and the storage location identifier and the record-keeping information are associated and stored in a queryable manner to ensure data integrity. Because the record-keeping information and content data are stored long-term, users can retrieve the required data without going through tedious steps, simplifying the operational process and improving the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] Figure 1 A flowchart of a data storage query method provided in an embodiment of this specification;

[0040] Figure 2 A schematic diagram of a process for associating and storing a storage location identifier and record information in a manner to be queried provided in an embodiment of this specification;

[0041] Figure 3 A schematic diagram of the process of storing content data provided in the embodiment of this specification;

[0042] Figure 4 A flowchart of a data query method provided in an embodiment of this specification;

[0043] Figure 5 A schematic diagram of a process for obtaining target content data provided in an embodiment of this specification;

[0044] Figure 6 A schematic diagram of a data storage query device provided in an embodiment of this specification;

[0045] Figure 7 This is a diagram of the internal structure of a computer device provided in accordance with an embodiment of this specification. DETAILED DESCRIPTION

[0046] The following describes embodiments of the present invention in detail, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present invention, and are not to be construed as limiting the present invention.

[0047] Hospital radiology departments generate a massive amount of medical data annually, primarily consisting of imaging data and related processing data. The larger the hospital, the greater the data volume, especially in imaging departments. To efficiently store this data, a Picture Archiving and Communication System (PACS) system is often used. The primary task of a PACS system is to digitally store patient medical images, along with related patient and imaging examination information. This information can be accessed and browsed at any time through the PACS system, supporting image post-processing, physician diagnosis, and comparative analysis of historical imaging data.

[0048] In large hospitals, PACS systems serve not only the radiology department but also other imaging departments, such as ultrasound, nuclear medicine, endoscopy, and pathology, to meet the imaging data needs of each department. A complete PACS system typically includes the following core modules: medical image acquisition, large-capacity data storage, image display and processing, database management, and transmission network. Furthermore, PACS systems support extended functions such as quality control and data analysis. This imaging data is typically stored as DICOM images, while other information is stored in a database.

[0049] However, PACS systems face the following challenges: image storage inconsistency, limited dynamic storage capacity expansion, and system expansion complexity. Therefore, in large-scale hospitals, the maintenance and standardized implementation of PACS systems need to be carried out by professional manufacturers.

[0050] With the increasing demand for medical diagnosis and treatment, hospitals at all levels need to store patients' medical data for a long time. However, due to the large scale of PACS systems, many small hospitals and grassroots health centers are unable to deploy dedicated PACS systems.

[0051] Workstations cannot directly implement a one-time permanent query of all stored data. In workstations, files are usually exported during data backup, and patient information can be attached during the export, or all patient data indexes can be saved as DICOMDIR files. When data needs to be accessed, simply connect the backup removable disk or CD to the workstation and then import the data back. However, when the amount of data is large, the search process may become slow and inconvenient because the speed is limited when searching for specific data on a large-capacity removable disk. To solve this problem, by utilizing the index file method, relying on the query capability of the operating system to simplify the data search process, thereby improving query efficiency and enhancing the convenience of operation.

[0052] However, the index file method has weak scalability and requires storage expansion through external mobile hard drives or networked clusters. However, this method relies on traversing all storage devices, resulting in low query efficiency and requiring additional query interfaces to manage data access.

[0053] For small hospitals, data management relies on manual operations, which makes data loss more likely and difficult to find. The lack of a unified and automated data management method makes the management of long-term stored data more complicated.

[0054] Based on this, the embodiments of this specification provide a data storage query method. First, the medical data to be stored is obtained. Then, as needed, the medical data to be stored is separated to obtain record information and content data for separate storage, thereby improving the flexibility of the system, reducing the system storage pressure, and ensuring the long-term availability of data. Finally, in order to ensure the traceability of the data, the storage location identifier of the content data is obtained, and the storage location identifier and the record information are associated and stored in a query-to-be-queried manner to ensure the integrity of the data. Since the record information and content data are stored for a long time, users can query the required data without going through cumbersome steps, which simplifies the operation process and improves the user experience.

[0055] This specification provides a data storage query method. Figure 1 , the data storage query method may include the following steps:

[0056] S110: Obtain medical data to be stored.

[0057] S120 , separating the medical data to be stored to obtain record information and content data for separate storage.

[0058] The medical data to be stored may include structured data and unstructured data. Structured data may include patient personal information, examination and test results, etc., and unstructured data may include medical images, case texts, etc.

[0059] Specifically, when a patient visits a doctor, they first register their information and enter basic personal information (such as name, age, and medical history). Simultaneously, the patient's medical information generated during examinations and visits (such as medical images and imaging reports) also needs to be stored. The medical storage and query system acquires and stores this data in real time, generating the medical data to be stored. The system then uses a classification algorithm to separate the stored medical data, parsing it into two categories: record-keeping information and content data. Because record-keeping information often has high query requirements, it requires permanent storage to ensure fast query performance. Content data, on the other hand, often contains large amounts of unstructured data and is therefore bulky. Therefore, separate storage of content data and record-keeping information can help reduce the burden on the storage and query equipment. Record-keeping information occupies less storage space and can include structured data at the examination level, such as patient ID, name, and doctor information, facilitating rapid retrieval. Content data is larger in volume and can include patient ID, medical images, and imaging reports. It's important to note that some overlap exists between record-keeping information and content data, such as patient IDs. This overlap allows for establishing associations and facilitating subsequent queries. Furthermore, because record-keeping information occupies a relatively small amount of storage space, the storage system can achieve near-permanent storage, even for large amounts of record-keeping information, ensuring long-term preservation and data integrity. This permanent storage capability is crucial for the long-term management of medical data and the tracking of patient historical data.

[0060] In some embodiments, the medical storage query system acquires and saves data in real time. Before obtaining the medical data to be stored, the system pre-sets the storage mode, storage device parameters, data upload method, data storage area, etc. for storing the data. The storage mode can be referred to as a storage technology. For example, the storage mode can be divided into a centralized storage mode and a distributed storage mode based on the storage method. Of course, it can also be divided into multiple storage technology modes based on the development of storage technology. For example, these multiple storage technology modes may include DAS (Direct-Attached Storage, open system direct-attached storage) storage mode, NAS (Network Attached Storage, network attached storage) storage mode, cloud object-based object storage technology OBS (Object Storage Service) mode, third-party call storage technology mode, etc. This allows subsequent computer devices to read the data and obtain the medical data to be stored.

[0061] S130: Obtain the storage location identifier of the content data, and associate the storage location identifier with the record information in a manner to be queried.

[0062] Specifically, to ensure the efficiency and reliability of the storage system, each storage device used to store content data is assigned a unique identifier, ensuring that each storage device storing content data can be accurately identified and tracked throughout the data storage system. To ensure the traceability of content data and the integrity of the medical data to be stored, the identifier of the storage device storing the content data is used as the storage location identifier each time content data is stored. This identifier and the corresponding record information of the content data are stored in the database in a queryable manner, so that the corresponding external expansion storage device can be located based on the storage location identifier.

[0063] In the above implementation, the medical data to be stored is first acquired. Then, as needed, the data is separated to obtain record-keeping information and content data for separate storage. This improves system flexibility, reduces system storage pressure, and ensures long-term data availability. Finally, to ensure data traceability, the storage location identifier of the content data is obtained, and the storage location identifier and record-keeping information are associated and stored in a queryable manner to ensure data integrity. Because the record-keeping information and content data are stored long-term, users can retrieve the required data without tedious steps, simplifying the operational process and improving the user experience.

[0064] In some embodiments, the method may further include: determining the index attribute information of the storage table in the database based on the storage space size of the database, the number of examination records per unit time, the storage space requirement of the preset attribute information, and the preset overall storage time information, so as to extract record information from the medical data to be stored based on the index attribute information.

[0065] The preset attribute information includes at least one attribute item, the index attribute information includes at least one index item, and there is a one-to-one correspondence between the at least one index item and the at least one attribute item.

[0066] In some cases, due to the limited storage space of the primary storage query device's database and the need for permanent storage of recorded information for immediate query and audit, it is particularly important to properly limit the content stored in the database. To properly allocate recorded information within the limited storage space, dynamic adjustments are required based on priority and storage space availability.

[0067] Specifically, the number of inspection records within the preset total storage time is calculated by multiplying the number of inspection records per unit time by the preset total storage time. While ensuring permanent storage, the database's storage space is divided by the number of inspection records within the preset total storage time to determine the storage space required to store the record-keeping information corresponding to a single inspection record.

[0068] The storage space requirements of the preset attribute information include the storage space requirements of multiple attribute items. Next, based on the storage space size limit required for the record information corresponding to a single inspection record, and on the premise of prioritizing the attribute items according to their importance, start selecting one by one from the most important attribute items, and calculate the total storage space requirements of the selected attribute items until the total storage space requirements of the selected attribute items are close to or reach the storage space size limit required for the record information corresponding to a single inspection record, and then continue to select the next attribute item. The selected attribute items are used as index items of the storage table in the database to constitute index attribute information. Then, the index items included in the index attribute information are used to separate the medical data to be stored, and the actual data values corresponding to each index item are extracted from the overall data. The actual data values corresponding to all index items constitute the record information.

[0069] Exemplarily, the preset attribute information may include multiple attribute items such as patient identification, patient name, examination time, gender, birthday, examination identification, examination description, patient weight, patient height, examination registration number, submitting department, referring physician, operator, and examination site.

[0070] It should be noted that the number of inspection records per unit time, the storage space requirement of the preset attribute information, and the preset overall storage time information can be set according to different requirements.

[0071] In some embodiments, as shown in Table 1, the index attribute information of the storage table in the database may include five index items: database incremental index field, patient name, patient ID, examination number, and examination date.

[0072] name type length Database incremental index field Int 32 bytes Patient's name Varchar(64) 10 bytes (average) Patient ID Varchar(64) 10 bytes (average) Check number Varchar(64) 10 bytes (average) Check date and time Varchar(64) 10 bytes

[0073] Table 1

[0074] Based on the index attribute information stored in the database above, we can determine that the storage space required for the record information corresponding to a single examination record is 80 bytes. Therefore, with a database storage space of 1GB, approximately 13 million examination records can be stored. Assuming a large hospital generates 5,000 examination records per day, the total number of examination records over 10 years is approximately 1.8 million, which is approximately equivalent to permanent storage.

[0075] In the above embodiment, based on the storage space size of the database, the number of examination records per unit time, the storage space requirement of the preset attribute information, and the preset overall storage time information, the index attribute information of the storage table in the database is determined, so as to extract the record information from the medical data to be stored based on the index attribute information, optimize the resource consumption of the database, and realize refined access control.

[0076] In some embodiments, the method may further include: storing the content data in an external expansion storage device. Storing the storage location identifier and the record information in a manner to be queried may include the following steps:

[0077] S210: Permanently store the record information in the database of the main storage query device.

[0078] S220: Associate the record information and the storage location identifier and store them in a database of the primary storage query device.

[0079] The main storage query device can perform data transmission with an external expansion storage device, which can be a storage medium such as a mobile disk or an optical disk.

[0080] Specifically, the medical storage query system consists of two parts: a main storage query device and an external extended storage device. The external extended storage device can perform efficient data transmission with the main storage query device through an interface. Since record information usually has a strong query demand, it needs to be permanently stored in the database of the main storage query device to ensure that it can meet the requirements of fast query. Content data usually contains a large amount of unstructured data and has a large data volume. Therefore, content data can be stored in an external extended storage device, which helps to reduce the burden on the main storage query device and ensure that sufficient storage space can be provided to meet the storage needs of content data. In order to ensure the traceability of content data and the integrity of the medical data to be stored, the record information and the storage location identifier are associated and stored in the database of the main storage query device, so that the corresponding external extended storage device can be located later according to the storage location identifier.

[0081] It should be noted that the amount of stored record information and storage location identification data is usually extremely small and the demand is low, and the hospital storage system can almost achieve permanent storage.

[0082] In some embodiments, breakpoint marks can be added to the record information or content data. The breakpoint marks can be divided into segments and each segment can be marked with a breakpoint. The number of segments and the number of breakpoints added to each segment can be set according to actual conditions. In addition, the breakpoint marks can be in the form of graphics, text, numbers, highlights, etc. After the breakpoint marks are added to the record information or content data, the breakpoint marks and the record information can be stored together in the database of the main storage query device, and the breakpoint marks and the content data can be stored together in the external expansion storage device.

[0083] In actual application scenarios, when the system is powered off or disconnected from the network, the data upload process will be interrupted. In this case, the breakpoint mark can be used to know where the data is uploaded at this time, and after the system is powered on again or reconnected to the network, the data can be continued to be uploaded according to the breakpoint mark.

[0084] In the above implementation, the record information is permanently stored in the database of the main storage query device, and the record information and the storage location identifier are associated and stored in the database of the main storage query device.

[0085] In some embodiments, see Figure 3 Storing content data in an external expansion storage device may include the following steps:

[0086] S310: Convert the content data to obtain sequence information and document information.

[0087] S320: Associate the sequence information and the document information and store them in an external expansion storage device.

[0088] Specifically, by converting the content data, extracting structured information (such as patient ID, examination type, serial number, etc.) and its corresponding specific data information, sequence information and document information are obtained. Sequence information can be detailed information of medical imaging examinations, usually including parameters such as examination type (such as head CT scan, chest CT scan), scan time, equipment number, serial number, etc. The document information corresponding to each sequence information can include specific imaging data (such as CT images), diagnostic reports, etc. In order to achieve effective management and rapid retrieval, the sequence information and document information are stored in a one-to-one association in an external expansion storage device. Among them, the document information can be stored in the form of files to meet various types of document information storage needs.

[0089] It should be noted that there are overlapping parts between the record information and the sequence information, such as the patient ID, so that an association can be established through the overlapping parts to facilitate subsequent query operations.

[0090] In the above implementation, the content data is converted to obtain sequence information and document information, which are then associated and stored in an external expansion storage device to facilitate subsequent query operations.

[0091] In some embodiments, the method may further include: backing up the content data and / or the record information, and storing the backup location identifier in a database.

[0092] The backup location identifier and the record information are stored in association in the database.

[0093] Specifically, each external expansion storage device is assigned a unique identifier to ensure that each external expansion storage device can be accurately identified and tracked in the entire data storage system. In order to ensure the security of the data, the data needs to be backed up. In some embodiments, the content data can be fully backed up and stored in another external expansion storage device, and the identifier of the external expansion storage device is used as the backup location identifier. In other embodiments, the content data and record information can be fully backed up in another external expansion storage device, and the identifier of the external expansion storage device is used as the backup location identifier. The backup location identifier is associated with the record information corresponding to the content data and stored in the database. Exemplarily, the backup location identifier can be represented by a four-byte integer field to save storage space.

[0094] It should be noted that backup operations can be automatically executed through system configuration or manually triggered by the administrator. For automatic backups, you can set a scheduled time period (such as daily, weekly, or monthly) to perform backup tasks regularly to ensure timely data preservation and updating.

[0095] In the above implementation, the content data and / or record information are backed up and stored, and the backup location identifier is stored in the database, thereby improving the security of storage.

[0096] In some embodiments, see Figure 4 , the method may further comprise the following steps:

[0097] S410: When a query instruction is received through the primary storage query device, query index data is determined based on the query instruction.

[0098] S420: Execute a query operation in the database based on the query index data to determine a target storage location identifier for the required target content data.

[0099] Specifically, in response to the operation of inputting the required data into the main storage query device, a query instruction is generated. After receiving the query instruction, the main storage query device analyzes the query instruction received by the main storage query device to determine the query index data to be used. The query index data is generally an identifier related to the record information and content data, and is used to locate the required data. The query operation is performed in the database using the query index data, and the storage location identifier corresponding to the query index data is determined and used as the target storage location identifier. The external expansion storage device corresponding to the target storage location identifier stores the content data corresponding to the query index data, that is, the required target content data.

[0100] S430: Locate the target external expansion storage device storing the target content data according to the target storage location identifier.

[0101] S440: Execute a query operation in the target external expansion storage device based on the query index data, obtain target content data, and output the target content data.

[0102] Specifically, the storage location identifier is a unique identifier pointing to a specific external expansion storage device. The primary storage query device includes at least one external expansion storage device. Then, through the target storage location identifier, traverse the primary storage query device to locate the external expansion storage device corresponding to the target storage location identifier, that is, the target external expansion storage device. Then, the query index data is used to perform a query operation in the target external expansion storage device corresponding to the target storage location identifier to confirm whether the target external expansion storage device corresponding to the target storage location identifier contains the content data corresponding to the query index data. If the query operation is successful, the content data corresponding to the query index data is used as the target content data and the target content data is output.

[0103] In the above embodiment, when a query instruction is received through the main storage query device, query index data is determined based on the query instruction, a query operation is performed in the database based on the query index data, a target storage location identifier of the required target content data is determined, and according to the target storage location identifier, the target external expansion storage device storing the target content data is located, and a query operation is performed in the target external expansion storage device based on the query index data to obtain the target content data and output the target content data, thereby improving the query speed.

[0104] In some embodiments, the method may further include: when the external expansion storage device storing the target content data is not located according to the target storage location identifier, outputting prompt information including the target storage location identifier, so as to access the target external expansion storage device corresponding to the target storage location identifier based on the prompt information.

[0105] Specifically, the storage location identifier is a unique identifier pointing to a specific external expansion storage device. The main storage query device includes at least one external expansion storage device. The main storage query device is traversed through the target storage location identifier. If the external expansion storage device storing the target content data is not located in the main storage query device, a prompt message containing the target storage location identifier will be automatically generated and output. The storage location identifier is a unique identifier pointing to a specific external expansion storage device. Therefore, the target storage location identifier in the prompt message reminds the user to connect the external expansion storage device corresponding to the target storage location identifier, that is, the target external expansion storage device, to the main storage query device.

[0106] In the above embodiment, when the external expansion storage device storing the target content data is not located according to the target storage location identifier, prompt information including the target storage location identifier is output so that the target external expansion storage device corresponding to the target storage location identifier is accessed based on the prompt information, thereby ensuring that the target content data can be queried.

[0107] In some embodiments, see Figure 5 , the method may further comprise the following steps:

[0108] S510: When it is determined that the target external expansion storage device does not contain the target content data, a query operation is performed in the database based on the query index data to determine a target backup location identifier of the required target content data.

[0109] S520: Locate the target external expansion storage device storing the target content data according to the target backup location identifier.

[0110] S530: Execute a query operation in the target external expansion storage device corresponding to the target backup location identifier based on the query index data to obtain target content data.

[0111] Specifically, a query is performed in the target external extended storage device corresponding to the target storage location identifier based on the query index data to determine whether the target external extended storage device has content data corresponding to the query index data. If the target external extended storage device corresponding to the target storage location identifier does not have content data corresponding to the query index data, it means that the data has been removed. At this time, it is necessary to re-execute the query operation in the database based on the query index data to determine the backup location identifier corresponding to the query index data and use it as the target backup location identifier. The backup location identifier is a unique identifier pointing to a specific external extended storage device. The target backup location identifier is used to locate the external extended storage device corresponding to the target backup location identifier in the main storage query device and use it as the target external extended storage device. The query index data is used to perform a query operation in the target external extended storage device corresponding to the target backup location identifier to confirm whether the target external extended storage device corresponding to the target backup location identifier contains content data corresponding to the query index data. If the query operation is successful, the content data corresponding to the query index data is used as the target content data.

[0112] In the above embodiment, when it is determined that the target external expansion storage device does not contain the target content data, a query operation is performed in the database based on the query index data to determine the target backup location identifier of the required target content data, and according to the target backup location identifier, the target external expansion storage device storing the target content data is located, and a query operation is performed in the target external expansion storage device corresponding to the target backup location identifier based on the query index data to obtain the target content data, thereby improving fault tolerance and ensuring that data will not be lost.

[0113] The embodiments of this specification also provide an application scenario for a data storage query method. Specifically, a medical storage query system provides a user interface for doctors to manage and configure storage devices. Doctors use the user interface to set the number of examination records per unit time and a preset overall storage time. The medical storage query system then calculates index attribute information for a storage table in the database based on the database's storage space, the number of examination records per unit time, the storage space required for preset attribute information, and the preset overall storage time.

[0114] The doctor uses the equipment to examine the patient normally and obtains medical imaging data. The doctor then reviews and analyzes the medical imaging data and writes a report or processes the medical imaging data based on the analysis results to obtain medical data to be stored.

[0115] The medical data to be stored is separated to obtain record information and content data. The record information is stored in the database of the main storage query device. The content data is stored in an external expansion storage device, and the identifier of the external expansion storage device is used as the storage location identifier associated with the record information in the database.

[0116] When executing a query operation, query index data is determined based on the query instruction. A query operation is executed in a database based on the query index data to determine a target storage location identifier for the desired target content data. Based on the target storage location identifier, a target external expansion storage device storing the target content data is located. Based on the query index data, a query operation is executed in the target external expansion storage device to obtain the target content data and output the target content data for display.

[0117] This specification provides a data storage query device 600. Figure 6 The data storage query device 600 includes: a medical data acquisition module 610, a data separation module 620, and an associated storage module 630.

[0118] A medical data acquisition module 610 is used to acquire medical data to be stored;

[0119] A data separation module 620 is used to separate the medical data to be stored to obtain record information and content data for separate storage;

[0120] The associated storage module 630 is used to obtain the storage location identifier of the content data, and associate and store the storage location identifier and the record information in a manner to be queried.

[0121] For a detailed description of the data storage query device, please refer to the description of the data storage query method above, which will not be repeated here.

[0122] An embodiment of the present specification provides a medical imaging device, including a memory and a processor. The memory stores a computer program, and the processor implements the method steps in the above embodiment when executing the computer program.

[0123] In some embodiments, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. Figure 7 As shown. The computer device includes a processor, a memory, a communication interface, a display screen and an input device connected via a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be achieved through WIFI, an operator network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a data storage query method is implemented. The display screen of the computer device can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad provided on the computer device housing, or an external keyboard, touchpad or mouse.

[0124] Those skilled in the art will understand that Figure 7 The structure shown in the figure is merely a block diagram of a portion of the structure related to the solution disclosed in this specification, and does not constitute a limitation on the computer device to which the solution disclosed in this specification is applied. Specifically, the computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

[0125] In some embodiments, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the method steps in the above embodiments when executing the computer program.

[0126] An embodiment of this specification provides a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the method in any of the above embodiments are implemented.

[0127] One embodiment of the present specification provides a computer program product, which includes instructions. When the instructions are executed by a processor of a computer device, the computer device is enabled to perform the steps of the method of any of the above embodiments.

[0128] It should be noted that the logic and / or steps represented in the flowcharts or otherwise described herein, for example, can be considered as a sequenced list of executable instructions for implementing the logical functions, and can be embodied in any computer-readable medium for use by, or in conjunction with, an instruction execution system, apparatus, or device (e.g., a computer-based system, a system including a processor, or other system that can fetch and execute instructions from an instruction execution system, apparatus, or device). For purposes of this specification, a "computer-readable medium" can be any device that can contain, store, communicate, propagate, or transport a program for use by, or in conjunction with, an instruction execution system, apparatus, or device. More specific examples (non-exhaustive list) of computer-readable media include the following: an electrical connection with one or more wires (electronic device), a portable computer disk cartridge (magnetic device), random access memory (RAM), read-only memory (ROM), erasable and programmable read-only memory (EPROM or flash memory), fiber optic devices, and portable compact disc read-only memory (CDROM). Furthermore, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or otherwise processing it in a suitable manner if necessary, and then storing it in a computer memory.

Claims

1. A data storage query method, characterized in that: The method comprises: Acquiring medical data to be stored; Separating the medical data to be stored to obtain record information and content data for separate storage; The storage location identifier of the content data is obtained, and the storage location identifier and the record information are associated and stored in a manner to be queried.

2. The method according to claim 1, characterized in that The method further comprises: Based on the storage space size of the database, the number of examination records per unit time, the storage space requirement of the preset attribute information, and the preset overall storage time information, the index attribute information of the storage table in the database is determined so as to extract the record information from the medical data to be stored based on the index attribute information, wherein the preset attribute information includes at least one attribute item, the index attribute information includes at least one index item, and the at least one index item corresponds to the at least one attribute item.

3. The method according to claim 2, characterized in that The method further includes: storing the content data in an external expansion storage device; and associating and storing the storage location identifier and the record information in a manner to be queried, including: Permanently storing the recorded information in a database of a primary storage and query device; The record information and the storage location identifier are associated and stored in a database of the primary storage query device, wherein the primary storage query device can perform data transmission with the external expansion storage device.

4. The method according to claim 3, characterized in that The storing of the content data in the external expansion storage device includes: Performing data conversion on the content data to obtain sequence information and document information; The sequence information and the document information are associated and stored in the external expansion storage device.

5. The method according to claim 3, characterized in that The method further comprises: The content data and / or the record information are backed up and stored, and the backup location identifier is stored in the database, wherein the backup location identifier and the record information are associated and stored in the database.

6. The method according to claim 3, characterized in that The method further comprises: In the case where a query instruction is received through the primary storage query device, determining query index data based on the query instruction; Performing a query operation in the database based on the query index data to determine a target storage location identifier of the required target content data; Locating a target external expansion storage device storing the target content data according to the target storage location identifier; A query operation is performed in the target external expansion storage device based on the query index data to obtain the target content data and output the target content data.

7. The method according to claim 6, characterized in that The method further comprises: When the external expansion storage device storing the target content data is not located according to the target storage location identifier, prompt information including the target storage location identifier is output, so as to access the target external expansion storage device corresponding to the target storage location identifier based on the prompt information.

8. The method according to claim 6, characterized in that The method further comprises: In the case where it is determined that the target external expansion storage device does not have the target content data, performing a query operation in the database based on the query index data to determine a target backup location identifier of the required target content data; Locating the target external expansion storage device storing the target content data according to the target backup location identifier; A query operation is performed in the target external expansion storage device corresponding to the target backup location identifier based on the query index data to obtain the target content data.

9. A data storage query device, characterized in that: The device comprises: A medical data acquisition module, used to acquire medical data to be stored; A data separation module is used to separate the medical data to be stored to obtain record information and content data for separate storage; The associated storage module is used to obtain the storage location identifier of the content data, and associate and store the storage location identifier and the record information in a manner to be queried.

10. A medical imaging device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 8 are implemented.

11. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 8 are implemented.

12. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 8 are implemented.

Images