CN113407646A - Knowledge graph-based distributed hospital information comprehensive query system - Google Patents
Knowledge graph-based distributed hospital information comprehensive query system Download PDFInfo
- Publication number
- CN113407646A CN113407646A CN202110676528.0A CN202110676528A CN113407646A CN 113407646 A CN113407646 A CN 113407646A CN 202110676528 A CN202110676528 A CN 202110676528A CN 113407646 A CN113407646 A CN 113407646A
- Authority
- CN
- China
- Prior art keywords
- query
- information
- data
- information module
- medical
- 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
- 239000003814 drug Substances 0.000 claims abstract description 74
- 229940079593 drug Drugs 0.000 claims abstract description 39
- 238000000034 method Methods 0.000 claims description 50
- 238000003860 storage Methods 0.000 claims description 14
- 238000012986 modification Methods 0.000 claims description 12
- 230000004048 modification Effects 0.000 claims description 12
- 238000004422 calculation algorithm Methods 0.000 claims description 11
- 238000013507 mapping Methods 0.000 claims description 8
- 230000000977 initiatory effect Effects 0.000 claims description 6
- 230000007246 mechanism Effects 0.000 claims description 6
- 238000012545 processing Methods 0.000 claims description 6
- 238000004806 packaging method and process Methods 0.000 claims description 4
- 230000002085 persistent effect Effects 0.000 claims description 4
- 230000000845 anti-microbial effect Effects 0.000 claims description 3
- 230000006870 function Effects 0.000 abstract description 29
- 238000004458 analytical method Methods 0.000 abstract description 4
- 238000007619 statistical method Methods 0.000 abstract description 4
- 230000008569 process Effects 0.000 description 11
- 239000000463 material Substances 0.000 description 10
- 238000010586 diagram Methods 0.000 description 6
- 238000007405 data analysis Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 3
- 238000007792 addition Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000003759 clinical diagnosis Methods 0.000 description 2
- 238000013481 data capture Methods 0.000 description 2
- 230000004927 fusion Effects 0.000 description 2
- 230000002688 persistence Effects 0.000 description 2
- 238000009877 rendering Methods 0.000 description 2
- 230000011218 segmentation Effects 0.000 description 2
- 238000012549 training Methods 0.000 description 2
- ZIXXRXGPBFMPFD-UHFFFAOYSA-N 1-chloro-4-[(4-chlorophenyl)disulfanyl]benzene Chemical compound C1=CC(Cl)=CC=C1SSC1=CC=C(Cl)C=C1 ZIXXRXGPBFMPFD-UHFFFAOYSA-N 0.000 description 1
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000000844 anti-bacterial effect Effects 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005538 encapsulation Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000035945 sensitivity Effects 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/289—Object oriented databases
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/24—Classification techniques
- G06F18/241—Classification techniques relating to the classification model, e.g. parametric or non-parametric approaches
- G06F18/2413—Classification techniques relating to the classification model, e.g. parametric or non-parametric approaches based on distances to training or reference patterns
- G06F18/24147—Distances to closest patterns, e.g. nearest neighbour classification
-
- 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
- G16H40/00—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices
- G16H40/20—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- Business, Economics & Management (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Life Sciences & Earth Sciences (AREA)
- Epidemiology (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Artificial Intelligence (AREA)
- Evolutionary Biology (AREA)
- Evolutionary Computation (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Biomedical Technology (AREA)
- Bioinformatics & Computational Biology (AREA)
- General Health & Medical Sciences (AREA)
- Medical Informatics (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- Computing Systems (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention discloses a knowledge graph-based distributed hospital information comprehensive query system, which comprises a medical information module, a user information module, a consumable information module, an equipment information module and a medicine information module. The distributed hospital information comprehensive query system can query medical information and the like in real time, plays a data supporting role in operation and management of hospitals and departments through data statistics and analysis, and divides the query and statistics functions into the following four categories: the medical treatment information statistical analysis function, the drug information query and statistical function, the medical treatment consumable information query and statistical function and the medical equipment query and statistical function.
Description
Technical Field
The invention belongs to the technical field of medical systems, and particularly relates to a knowledge graph-based distributed hospital information comprehensive query system.
Background
At present, the information of hospitals is developed at a high speed, business software is increased continuously, a large amount of data information is generated and accumulated, the data information is distributed in different databases, the data volume is large and relatively independent, and the medical information data is utilized to improve the modernized management level of the hospitals and provide more scientific decision support. However, the information query function of each service software can only provide the information query of its own database, and cannot effectively integrate and analyze and utilize the original data, and cannot deeply exploit the value contained in the data. The cross-platform and cross-database integrated information query is also low in query efficiency, too low in information matching speed, incapable of realizing data fusion and the like through the interconnection of the interface platforms.
The knowledge graph is an accurate query for knowledge in a specific field, can be used for better querying complex associated information, understanding user intentions from a semantic layer, improving search quality and quickly matching and querying results, so the text mainly focuses on a knowledge graph-based quick search query function, extracts data among different service systems by using an encapsulation analysis function of the knowledge graph-based quick search query function, and classifies medical texts of the whole data by using a K nearest neighbor algorithm (KNN), thereby solving the problems.
Disclosure of Invention
The invention aims to solve the problems that the existing hospital query system is low in efficiency and cannot realize data fusion and the like, and provides a knowledge graph-based distributed hospital information comprehensive query system.
The technical scheme of the invention is as follows: a knowledge graph-based distributed hospital information comprehensive query system comprises a medical information module, a user information module, a consumable information module, an equipment information module and a medicine information module;
the medical information module is used for counting daily medical reports, real-time hospital data, department bed occupation income, medical income, medication condition and medical quality;
the user information module is used for modifying user information and distributing user role authority;
the consumable information module is used for counting consumable inventory details, counting department request details, checking accounts when entering and leaving the warehouse, counting department consumption and inquiring supply conditions;
the equipment information module is used for inquiring the information of the hospital information comprehensive inquiry system on line;
the drug information module is used for counting daily drugs, clinical pharmacy inventory, outpatient pharmacy inventory, warehouse-in and warehouse-out inquiry and drug information inquiry.
Further, the query method of the knowledge-graph-based distributed hospital information comprehensive query system comprises the following steps: classifying the medical data by using a KNN algorithm, and constructing a knowledge graph based on the classified medical data; and information inquiry is carried out in the medical information module, the user information module, the consumable information module, the equipment information module and the medicine information module by using the knowledge map.
Further, the distributed hospital information comprehensive query system adopts a SpringMVC framework.
Furthermore, in the medical information module, daily medical daily reports are obtained by regularly summarizing daily data through a timer;
the hospital real-time data is obtained by sequentially inquiring the Cache data and the Cache database in the distributed hospital information comprehensive inquiry system;
the department bed occupation income comprises the hospital bed occupation rate and income data of each department in each period of time, and is obtained by sequentially inquiring Cache data and a Cache database in a distributed hospital information comprehensive inquiry system;
the medication conditions include antimicrobial usage, prescription rates, and drug types.
Further, in the user information module, a specific method for modifying the user information is as follows: logging in a distributed hospital information comprehensive query system by a user, initiating an information modification request, calling a data access layer to query a database of the distributed hospital information comprehensive query system, and returning a query result to a Service layer in a SpringMVC framework to modify user information;
the specific method for distributing the user role authority comprises the following steps: logging in a distributed hospital information comprehensive QUERY system through an administrator, initiating an authority allocation request, calling a QUERY interface of a DAO layer in a SpringMVC framework by using a QUERY method to perform QUERY, returning a QUERY result to the administrator, and performing weight configuration.
Furthermore, in the consumable material information module, a user with consumable material detail query authority logs in a distributed hospital information comprehensive query system, a network interface layer is used for converting a consumable material inventory detail query request into a JSON format, the JSON format is sent to a Controller layer in a spring MVC framework for processing, a query condition obtained through processing is sent to a DAO layer in the spring MVC framework, the DAO layer is used for performing query operation, a query result is returned to a Service layer in the spring MVC framework for packaging, and consumable material inventory detail statistics is completed.
Further, the device information module adopts a MyISAM storage engine and an InNODB storage engine to perform online query.
Further, the inquiry mode of inquiring the warehouse-in and warehouse-out in the medicine information module comprises inquiring the warehouse-in medicine in each time period, inquiring the warehouse-out medicine in each time period and inquiring the warehouse-in medicine in each time period according to manufacturers;
the specific query method comprises the following steps: logging in a distributed hospital information comprehensive query system and setting a query time period through a user with an in-out query right, sending a warehousing query request packaged into a JSON format to a Controller layer in an MVC (virtual private network Controller) framework through an HTTP (hyper text transport protocol), mapping the warehousing query request to a Service layer in the SpringMVC framework by utilizing a Java reflection mechanism to analyze a query condition, and calling a persistent layer mapping framework of a DAO (data object oriented) layer in the SpringMVC framework to query warehousing information according to the analyzed query condition.
The invention has the beneficial effects that:
(1) the distributed hospital information comprehensive query system can query medical information and the like in real time, plays a data supporting role in operation and management of hospitals and departments through data statistics and analysis, and divides the query and statistics functions into the following four categories: the medical treatment information statistical analysis function, the drug information query and statistical function, the medical treatment consumable information query and statistical function and the medical equipment query and statistical function.
(2) The distributed hospital information comprehensive query system improves the efficiency of clinical diagnosis and treatment services, reduces medical errors, improves medical experience, controls medical cost, provides a stronger data analysis tool for hospital management and operation, and improves the refined management level of medical data.
Drawings
FIG. 1 is a block diagram of a distributed hospital information integrated query system;
FIG. 2 is a timing diagram of user information modification;
FIG. 3 is a timing diagram of role privilege assignment;
FIG. 4 is a flowchart of a role assignment routine;
FIG. 5 is a timing diagram illustrating consumable inventory details;
FIG. 6 is a timing chart of drug warehousing;
fig. 7 is a flowchart of a data acquisition procedure.
Detailed Description
The embodiments of the present invention will be further described with reference to the accompanying drawings.
Before describing specific embodiments of the present invention, in order to make the solution of the present invention more clear and complete, the definitions of the abbreviations and key terms appearing in the present invention will be explained first:
KNN algorithm: a machine algorithm based on supervised learning is fully called as a K-nearest neighbor algorithm.
In the SpringMVC architecture, the dao layer: the data persistence layer is mainly used, and tasks in charge of communicating with the database are all packaged;
service layer: the method mainly takes charge of application logic application design of a business module;
controller layer: the system is responsible for controlling the specific business module process;
view layer: the view layer and the control layer are combined closely and need to be combined for collaborative development, and the view layer is mainly responsible for displaying a front desk jsp page.
A Cache database: product of the United states Intersystems corporation, post-relational database.
QUERY method: the method is mainly used for executing the sql statement and realizing the addition, deletion, modification and check of the database.
The Java reflection mechanism: in the running state of the program, an object of any one class can be constructed, the class to which any one object belongs can be known, member variables and methods of any one class can be known, and the attribute and the method of any one object can be called.
MyISAM storage engine: a default storage engine of the MySQL relational database system.
InoDB storage Engine: a default table storage engine featuring line lock design, MVCC support, foreign key support, consistent non-locked reads, simultaneous design for most efficient utilization and use of memory and CPU.
As shown in fig. 1, the invention provides a knowledge-graph-based distributed hospital information comprehensive query system, which comprises a medical information module, a user information module, a consumable information module, an equipment information module and a medicine information module;
the medical information module is used for counting daily medical reports, real-time hospital data, department bed occupation income, medical income, medication condition and medical quality;
the user information module is used for modifying user information and distributing user role authority;
the consumable information module is used for counting consumable inventory details, counting department request details, checking accounts when entering and leaving the warehouse, counting department consumption and inquiring supply conditions;
the equipment information module is used for inquiring the information of the hospital information comprehensive inquiry system on line;
the drug information module is used for counting daily drugs, clinical pharmacy inventory, outpatient pharmacy inventory, warehouse-in and warehouse-out inquiry and drug information inquiry.
In the embodiment of the invention, the query method of the knowledge-graph-based distributed hospital information comprehensive query system comprises the following steps: classifying the medical data by using a KNN algorithm, and constructing a knowledge graph based on the classified medical data; and information inquiry is carried out in the medical information module, the user information module, the consumable information module, the equipment information module and the medicine information module by using the knowledge map.
The KNN algorithm is a method which is convenient to understand and simple to realize, and has the advantages that the generated training result is high in precision, no assumption needs to be made on no data input, the sensitivity degree of the KNN algorithm to abnormal values in samples is low, and the classification effect of the KNN algorithm in data with irregular boundaries is better than that of linear classification. However, it also has a certain disadvantage that, when training data, it requires a large amount of space to store all data to be tested, and both the computational complexity and the spatial complexity are high, so that it is not suitable for data with high feature space dimension.
The medical data according to the present invention is roughly divided into numerical data and text data, unlike general text data, and for example, the medicine information includes more data, such as numerical data, and the consumable information includes more text data. For text type data, punctuation marks, stop words and the like are not involved, but in order to extract features, some words are required to be subjected to segmentation operation.
In the embodiment of the invention, the distributed hospital information comprehensive query system adopts a SpringMVC framework.
In the embodiment of the invention, in the medical information module, daily medical daily reports are obtained by regularly summarizing daily data through a timer;
the hospital real-time data is obtained by sequentially inquiring the Cache data and the Cache database in the distributed hospital information comprehensive inquiry system;
the department bed occupation income comprises the hospital bed occupation rate and income data of each department in each period of time, and is obtained by sequentially inquiring Cache data and a Cache database in a distributed hospital information comprehensive inquiry system;
the hospital income is composed of total hospital income, total outpatient service income, total hospitalization income, total hospital medicine income, total outpatient service medicine income, total hospitalization medicine income, total hospital medical income, total outpatient service medical income and hospitalization medical income;
the medication conditions include antimicrobial usage, prescription rates, and drug types.
Daily medical daily report: one summary statistic was performed for daily data. In order to avoid that the statistical process influences the normal business of the hospital in the daytime, the statistical function is arranged to be carried out in the early morning of the day. The timer function provided by Spring is used to implement timing statistics.
Hospital real-time data: in order to accelerate the query efficiency of the real-time data of the hospital, the query process is divided into two parts, firstly, data query is carried out in Cache data, and if the data query does not exist in the Cache, the second step is carried out, and the data query is carried out in a Cache database;
the income of the department in bed: statistics is given on the occupancy of beds and the income of each department over a period of time, and data decision support is provided for the arrangement and decision of patients of the hospital population.
The medication condition is as follows: the medicine taking condition of each department of the whole hospital is supervised and controlled by the rationalization medicine taking module, and the medicine using condition of a department doctor, such as a large prescription, the using condition (DDDS) of antibacterial medicines, the medicine ratio and the like, can be checked in real time through the rationalization medicine taking module, so that self-monitoring of relevant departments of a hospital and clinical departments on medicine use is realized.
In the embodiment of the present invention, in the user information module, a specific method for modifying user information is as follows: logging in a distributed hospital information comprehensive query system by a user, initiating an information modification request, calling a data access layer to query a database of the distributed hospital information comprehensive query system, and returning a query result to a Service layer in a SpringMVC framework to modify user information;
the specific method for distributing the user role authority comprises the following steps: logging in a distributed hospital information comprehensive QUERY system through an administrator, initiating an authority allocation request, calling a QUERY interface of a DAO layer in a SpringMVC framework by using a QUERY method to perform QUERY, returning a QUERY result to the administrator, and performing weight configuration.
As shown in FIG. 2, the user information modification user first logs into the system and clicks on the user information button to enter a view of the personal information interface. The personal information interface view will initiate an event request to the personal information ViewModel. The personal information ViewModel will make a request to the back-end server via HTTP protocol. After receiving the event request from the ViewModel, the control layer of the back-end server uses a reflection mode to find the designated Service layer method. The Service level method then makes a request to the DAO layer operating the database. After receiving the query request of the personal information, the DAO layer queries the database by using Mybatis and returns the query result to the Service layer. And the Service layer encapsulates the inquired result into a JSON data format, returns the JSON data format to the personal information view interface through the Controller layer, and displays the inquired personal information after the user logs in through the rendering of the personal view interface. The steps are as follows: and 1-15 steps in the sequence diagram, wherein the display process of the personal information is carried out after the user logs in the system. The 17 th-31 th steps in the information modification sequence diagram are the flow of modifying information. The flow description of the modification information is basically consistent with the description of the display information, and the difference is mainly two different aspects. The first aspect is different in trigger mechanisms, and the information display requires a user to click an individual information button to trigger a query request for querying personal related information; and modifying the information requires the user to provide the information to be modified, and if the modification information is not provided, the inquiry information request is called. The second aspect is on the server side. If the information is modified, an UPDATE method is called at the server side, and then an UPDATE method operation database of the DAO layer is called. And the QUERY method used by the server end during QUERY is to call a SELECT method in the DAO layer to QUERY the data of the database.
The distribution sequence of the authority of the roles is shown in fig. 3. The administrator of the system allocates the authority for each role, and different users have different inquiry authorities in the hospital information comprehensive inquiry system. For example: the users who have the role of the master and the subordinate have all data query permissions of the system, can clearly query the finance, the medicine and the service quality of the whole hospital, and can only check some data of the department. Unlike the information modification function, the role authority assignment function is a function that only an administrator has. When an administrator logs in the system, the user list view shows all users in the system on a browser page in a list mode. The administrator selects a user who wants to modify the permissions and clicks the view button. The user list ModelView initiates an event request to the permission ModelView. The permission ModelView initiates a request to the server Controller through the HTTP protocol. After the Controller of the server receives the request, a QUERY method in the Service layer is defined by using a Java reflection mode. And calling a Mybatis QUERY interface in the DAO layer by the QUERY method, returning a QUERY result set of the database, and rendering and displaying the QUERY result set to an administrator through the permission view interface. And the administrator completes the configuration of the authority, then clicks a submit button and sends a mouse click event to the authority ModelView. And the permission ModelView encapsulates the permission data configured by the administrator into data in a JSON format and sends the data to a control layer of the server through an HTTP protocol. And the control layer of the server calls an UPDATE method in the Service layer, and modifies data in the database by operating a Mybatis interface in the DAO layer.
Here, a case where one doctor is set to a department level will be described, and a program flow of a specific flow is shown in fig. 4. First, the personal information of the doctor is inquired according to the name of the doctor, and whether the doctor exists in the system is verified. Here, in order to improve the overall efficiency of the system, the names of doctors are cached and stored in the memory relational database.
In the embodiment of the invention, in a consumable material information module, a user with consumable material detail inquiry authority logs in a distributed hospital information comprehensive inquiry system, a network interface layer is utilized to convert a consumable material inventory detail inquiry request into a JSON format, the JSON format is sent to a Controller layer in a spring MVC framework for processing, an inquiry condition obtained by processing is sent to a DAO layer in the spring MVC framework, the DAO layer is utilized to carry out inquiry operation, an inquiry result is returned to a Service layer in the spring MVC framework for packaging, and consumable material inventory detail statistics is completed.
As shown in fig. 5, first, the user having the authority to inquire the consumable material inventory details can execute the consumable material inventory details inquiry, otherwise, the inquiry cannot be performed. Interception aiming at the authority is embodied in two points, namely interception on a front-end access interface and interception of rear-end interface access. The interception of the front-end interface is operated by adopting a Shiro framework binding tag, and if the authority of inquiring the consumable stock is not available, the user can not display an inquiry button after logging in the system. In addition, the back end can carry out authority verification on the current user before executing the access interface, and if the authority of consumable inventory is not inquired, a status code with wrong authority is returned. After a doctor who has the authority of inquiring the consumable information logs in the system, clicking a button to jump to the consumable information View. The name or the key word of the consumable to be inquired is input in a search bar on the consumable information interface, and an inquiry button is clicked. Then the information to be inquired is encapsulated by the network interface layer into JSON format data to be transmitted in the network and sent to the Controller layer of the server. And the Controller layer of the service end receives the query request transmitted in the network, processes the query request, and uses the reflection call of the Java language to map the query request to the interface of the corresponding service layer. After receiving the relevant query conditions, the Service layer needs to process the query conditions, for example: removal of spaces, segmentation of multiple keywords, and the like. And then sending the processed query conditions to a DAO layer, wherein the DAO layer uses a database persistent layer mapping frame Mybatis to perform final query operation. The result of the DAO layer query is returned to the Service layer for specific packaging and processing. For example: ranking of query results, and the like. The Service layer sends the processed data to the Controller layer, and then sends the processed data to consumable information View after JSON serialization operation. And after receiving the JSON character string, the consumable information View performs deserialization operation to take out data, renders a page and displays the page to a doctor.
In the embodiment of the invention, the equipment information module adopts a MyISAM storage engine and an InNODB storage engine to carry out online inquiry.
The device information module has the functions of: the module can realize the on-line inquiry of the hospital-wide medical equipment information and realize the on-line inquiry of the equipment information. Because the equipment of the hospital is relatively fixed, the data of the equipment information module is relatively stable, frequent modification, addition and deletion operations cannot exist, and the operation aiming at the equipment information module is mainly an inquiry operation. Thus, the primary optimization herein is directed to improving query efficiency for the device information module. In order to improve efficiency, the following methods are used herein. And aiming at the equipment information table, selecting a MyISAM storage engine with more efficient query performance. As above, because the device information is relatively fixed, the frequency of operations of insertion, deletion, and modification is low, and there is no complex business logic. Two storage engines MyISAM and InnodB carried by the Cache are higher than InnodB in query performance, although the speed of the InnodB engine is slower than that of the MyISAM engine, the InnodB engine supports complex transaction operation and has various locks to solve the problem of concurrent dirty data. It is clear that the MyISAM engine needs to be selected for frequent queries. In addition, a globally unique device ID, called UEID, is generated for each device and set to the index, speeding up query efficiency. There are many inquiry methods supported by the information of the device, and there are other inquiry conditions according to the number of the device, the name of the device, the type of the device, the supplier, the manufacturer of the production, the contract number, and the like. After the information to be inquired is input, the data result of the equipment information meeting the relevant conditions can be inquired by clicking the search button.
In the embodiment of the invention, the inquiry mode of inquiring the warehouse-in and warehouse-out in the medicine information module comprises inquiring the warehouse-in medicine in each time period, inquiring the warehouse-out medicine in each time period and inquiring the warehouse-in medicine in each time period according to manufacturers;
the specific query method comprises the following steps: logging in a distributed hospital information comprehensive query system and setting a query time period through a user with an in-out query right, sending a warehousing query request packaged into a JSON format to a Controller layer in an MVC (virtual private network Controller) framework through an HTTP (hyper text transport protocol), mapping the warehousing query request to a Service layer in the SpringMVC framework by utilizing a Java reflection mechanism to analyze a query condition, and calling a persistent layer mapping framework of a DAO (data object oriented) layer in the SpringMVC framework to query warehousing information according to the analyzed query condition.
As shown in FIG. 6, inquiring the warehousing-in/out information requires that the user has an inquiry authority, and if the inquiry authority does not exist, the doctor can not see the medicine information View after logging in the system. If the doctor logs in the system and has the information View of the medicine, the doctor can inquire the information of the medicine in and out of the warehouse. The system supports three inquiry modes in total, inquires warehouse-in medicines for a period of time, inquires warehouse-out medicines for a period of time and inquires warehouse-in medicines for a period of time according to manufacturers. The whole drug warehousing query process can be described as follows: and (4) logging in the system by a doctor with the inquiry authority to enter the medicine information View. The doctor sets the inquiry mode, as above, there are three inquiry modes in total, and sets the inquiry time period. After the setting is finished, the medicine information View encapsulates the query information into JSON format data and sends the JSON format data to a Controller layer of the server through an HTTP protocol, and after the Controller layer receives the JSON data, the JSON data is mapped to a medicine in-out warehouse query Service interface by using a Java reflection mechanism. And the drug in-out warehouse query Service interface analyzes the JSON format query condition, calls the persistence layer mapping frame Mybatis of the DAO layer to operate the Cache database, and queries the result. And the Service layer receives the returned information of the medicine in and out of the warehouse, processes the data and delivers the data to the Controller layer, and the Controller layer encapsulates the data into a JSON format and returns the information View of the medicine through an HTTP protocol. And the medicine information View receives the data in the JSON format, analyzes and renders the data, and displays the data to a doctor.
Specifically, there are 4 methods in the MedicineService class that are relevant to drug warehousing. The findMediceineReportByFactorName () method queries the drug warehousing information correspondingly according to the name of the manufacturer, and the method calls the same-name method in the MedicineApper example to query the database. The findMediceineReporIn () method realizes the inquiry of the information of the warehoused drugs in a certain time period. findMedicineOut () corresponds to the information of drugs that are queried for ex-warehouse within a certain time period. In the last method, countmedicinerereport () is used as data statistics to count the number of entries in and out of a drug library for a certain period of time.
In an embodiment of the present invention, a data capture graph is shown in FIG. 7. The data source of the hospital information comprehensive query system is a hospital business system, and how to quickly acquire business data is a problem to be considered without influencing the normal medical flow of the hospital, although a large number of hospital patients are available, the number of patients who see a doctor at night is less than that of the patients in the daytime, and the number of the patients on weekends is more than that of the patients on weekdays, so that the timing task of the system captures data within one hour every 1 hour in the daytime, the data capture adopts a storage process, the storage process has a Cache at a Cache server end, the code execution efficiency can be improved, and the number of the patients can be increased in the daytime. Patients are relatively few in the morning at night, so that the whole data is captured in the morning of each tuesday; the flow of grabbing can be described as: firstly, installing sqoop and hadoop script files; secondly, judging whether the system has incremental data, if so, adding an incremental index without calling hadoop, and otherwise, carrying out the next operation; and thirdly, executing a hadoop batch index adding command and adding incremental data into the system index.
The working principle and the process of the invention are as follows: firstly, data extraction and integration technologies of different service systems are researched, the concept of a knowledge graph is introduced, a quick and accurate searching function of the knowledge graph is provided, and a KNN algorithm is combined to realize the accurate and quick query and statistics function of the system across platforms and databases. Secondly, the system of the invention takes the data requirement of a hospital manager on management decision as a main line, and realizes the data analysis of hospital operation and clinic by integrating the service data in the hospital, building a hospital data warehouse, and building a statistical analysis and data mining model and a knowledge base, thereby providing the support of the data in the decision aspect for the managers in the relevant aspects of the hospital. Then, according to the requirements of hospital managers on data information and the functions required to be met by the system, the system is designed in the aspect of architecture, each sub-module related in the query system is designed in detail, and main system functions such as medical information query and drug information query are realized by the operation and statistics among all resources in the system and the combination of a medical management system. Finally, the modules involved in implementing the system of the present invention, in addition to performing interface display and description on the key modules, also perform validation on the system in terms of validity and rationality.
The invention has the beneficial effects that:
(1) the distributed hospital information comprehensive query system can query medical information and the like in real time, plays a data supporting role in operation and management of hospitals and departments through data statistics and analysis, and divides the query and statistics functions into the following four categories: the medical treatment information statistical analysis function, the drug information query and statistical function, the medical treatment consumable information query and statistical function and the medical equipment query and statistical function.
(2) The distributed hospital information comprehensive query system improves the efficiency of clinical diagnosis and treatment services, reduces medical errors, improves medical experience, controls medical cost, provides a stronger data analysis tool for hospital management and operation, and improves the refined management level of medical data.
It will be appreciated by those of ordinary skill in the art that the embodiments described herein are intended to assist the reader in understanding the principles of the invention and are to be construed as being without limitation to such specifically recited embodiments and examples. Those skilled in the art can make various other specific changes and combinations based on the teachings of the present invention without departing from the spirit of the invention, and these changes and combinations are within the scope of the invention.
Claims (8)
1. A knowledge graph-based distributed hospital information comprehensive query system is characterized by comprising a medical information module, a user information module, a consumable information module, an equipment information module and a medicine information module;
the medical information module is used for counting daily medical reports, real-time hospital data, department bed occupation income, medical income, medication condition and medical quality;
the user information module is used for modifying user information and distributing user role authority;
the consumable information module is used for counting consumable inventory details, counting department request details, warehouse entry and exit reconciliation, counting department consumption and inquiring supply conditions;
the equipment information module is used for inquiring the information of the hospital information comprehensive inquiry system on line;
the drug information module is used for counting daily drugs, clinical pharmacy inventory, outpatient pharmacy inventory, warehouse-in and warehouse-out inquiry and drug information inquiry.
2. The knowledge-graph-based distributed hospital information comprehensive query system according to claim 1, wherein the query method of the knowledge-graph-based distributed hospital information comprehensive query system is as follows: classifying the medical data by using a KNN algorithm, and constructing a knowledge graph based on the classified medical data; and information inquiry is carried out in the medical information module, the user information module, the consumable information module, the equipment information module and the medicine information module by using the knowledge map.
3. The knowledge-graph-based distributed hospital information integrated query system according to claim 1, wherein said distributed hospital information integrated query system employs a SpringMVC framework.
4. The knowledge-graph-based distributed hospital information integrated query system according to claim 1, wherein in said medical information module, said daily medical daily reports are obtained by regularly summarizing daily data by a timer;
the hospital real-time data is obtained by sequentially inquiring Cache data and a Cache database in a distributed hospital information comprehensive inquiry system;
the department bed occupation income comprises the hospital bed occupation rate of each department in each period of time, and is obtained by sequentially inquiring Cache data and a Cache database in a distributed hospital information comprehensive inquiry system;
the medication conditions include antimicrobial usage rate, prescription scale and drug type.
5. The knowledge-graph-based distributed hospital information comprehensive query system according to claim 3, wherein in the user information module, a specific method for modifying user information is as follows: logging in a distributed hospital information comprehensive query system by a user, initiating an information modification request, calling a data access layer to query a database of the distributed hospital information comprehensive query system, and returning a query result to a Service layer in a SpringMVC framework to modify user information;
the specific method for distributing the user role authority comprises the following steps: logging in a distributed hospital information comprehensive QUERY system through an administrator, initiating an authority allocation request, calling a QUERY interface of a DAO layer in a SpringMVC framework by using a QUERY method to perform QUERY, returning a QUERY result to the administrator, and performing weight configuration.
6. The knowledge-graph-based distributed hospital information comprehensive query system of claim 3, wherein in the consumable information module, a user with consumable detail query authority logs in the distributed hospital information comprehensive query system, the network interface layer is used for converting the consumable inventory detail query request into a JSON format, the JSON format is sent to a Controller layer in a spring MVC framework for processing, the processed query condition is sent to a DAO layer in the spring MVC framework, the DAO layer is used for query operation, and the query result is returned to a Service layer in the spring MVC framework for packaging to complete the consumable inventory detail statistics.
7. The knowledge-graph-based distributed hospital information integrated query system according to claim 1, wherein said equipment information module employs a MyISAM storage engine and an InnoDB storage engine for online query.
8. The knowledge-graph-based distributed hospital information comprehensive query system according to claim 3, wherein the query modes for querying warehousing-in and warehousing-out in the drug information module comprise querying warehousing drugs at each time, querying ex-warehouse drugs at each time and querying warehousing drugs at each time according to manufacturers;
the specific query method comprises the following steps: logging in a distributed hospital information comprehensive query system and setting a query time period through a user with an in-out query right, sending a warehousing query request packaged into a JSON format to a Controller layer in an MVC (virtual private network Controller) framework through an HTTP (hyper text transport protocol), mapping the warehousing query request to a Service layer in the SpringMVC framework by utilizing a Java reflection mechanism to analyze a query condition, and calling a persistent layer mapping framework of a DAO (data object oriented) layer in the SpringMVC framework to query warehousing information according to the analyzed query condition.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110676528.0A CN113407646A (en) | 2021-06-18 | 2021-06-18 | Knowledge graph-based distributed hospital information comprehensive query system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110676528.0A CN113407646A (en) | 2021-06-18 | 2021-06-18 | Knowledge graph-based distributed hospital information comprehensive query system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113407646A true CN113407646A (en) | 2021-09-17 |
Family
ID=77685024
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110676528.0A Pending CN113407646A (en) | 2021-06-18 | 2021-06-18 | Knowledge graph-based distributed hospital information comprehensive query system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113407646A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115985478A (en) * | 2023-03-20 | 2023-04-18 | 成都信通网易医疗科技发展有限公司 | Drug permission query method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106021281A (en) * | 2016-04-29 | 2016-10-12 | 京东方科技集团股份有限公司 | Method for establishing medical knowledge graph, device for same and query method for same |
| CN109189940A (en) * | 2018-09-05 | 2019-01-11 | 南京大学 | A kind of knowledge sharing method of servicing based on crowdsourcing and graphical spectrum technology |
| CN109766446A (en) * | 2018-12-13 | 2019-05-17 | 平安科技（深圳）有限公司 | A kind of data survey method, data survey device and computer readable storage medium |
| CN109918475A (en) * | 2019-01-24 | 2019-06-21 | 西安交通大学 | A kind of Visual Inquiry method and inquiry system based on medical knowledge map |
| CN109992988A (en) * | 2018-01-02 | 2019-07-09 | ***通信有限公司研究院 | A kind of data permission management method and device |
| CN112836058A (en) * | 2019-11-25 | 2021-05-25 | 北京搜狗科技发展有限公司 | Medical knowledge map establishing method and device and medical knowledge map inquiring method and device |
-
2021
- 2021-06-18 CN CN202110676528.0A patent/CN113407646A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106021281A (en) * | 2016-04-29 | 2016-10-12 | 京东方科技集团股份有限公司 | Method for establishing medical knowledge graph, device for same and query method for same |
| CN109992988A (en) * | 2018-01-02 | 2019-07-09 | ***通信有限公司研究院 | A kind of data permission management method and device |
| CN109189940A (en) * | 2018-09-05 | 2019-01-11 | 南京大学 | A kind of knowledge sharing method of servicing based on crowdsourcing and graphical spectrum technology |
| CN109766446A (en) * | 2018-12-13 | 2019-05-17 | 平安科技（深圳）有限公司 | A kind of data survey method, data survey device and computer readable storage medium |
| CN109918475A (en) * | 2019-01-24 | 2019-06-21 | 西安交通大学 | A kind of Visual Inquiry method and inquiry system based on medical knowledge map |
| CN112836058A (en) * | 2019-11-25 | 2021-05-25 | 北京搜狗科技发展有限公司 | Medical knowledge map establishing method and device and medical knowledge map inquiring method and device |
Non-Patent Citations (3)
| Title |
|---|
| 余文杰: "面向基层医疗HIS***的设计与实现", 《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》 * |
| 徐安琪 等: "智慧建设与规划研究", 《医学信息学杂志》 * |
| 杨红玲: "医院信息***综述", 《信息***工程》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115985478A (en) * | 2023-03-20 | 2023-04-18 | 成都信通网易医疗科技发展有限公司 | Drug permission query method |
| CN115985478B (en) * | 2023-03-20 | 2023-07-18 | 成都信通网易医疗科技发展有限公司 | Query method for medicine authority |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109716320A (en) | Figure for distributed event processing system generates | |
| EP2608074B1 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| CN107451219B (en) | Method for analyzing second index and distributed New SQL database | |
| US8190555B2 (en) | Method and system for collecting and distributing user-created content within a data-warehouse-based computational system | |
| US8977600B2 (en) | System and method for continuous analytics run against a combination of static and real-time data | |
| US9047349B2 (en) | Methods for effective processing of time series | |
| CN101067823B (en) | System and method for optimizing federated databases management | |
| CN111971666A (en) | Dimension context propagation technology for optimizing SQL query plan | |
| US7984043B1 (en) | System and method for distributed query processing using configuration-independent query plans | |
| US20070174290A1 (en) | System and architecture for enterprise-scale, parallel data mining | |
| CN107077476A (en) | Event is enriched for event handling using the big data of regime type | |
| US7454423B2 (en) | Enterprise link for a software database | |
| US20120215751A1 (en) | Transaction prediction modeling method | |
| US7917501B2 (en) | Optimization of abstract rule processing | |
| US20160140205A1 (en) | Queries involving multiple databases and execution engines | |
| CN104767813A (en) | Public bank big data service platform based on openstack | |
| EP2869220B1 (en) | Networked database system | |
| US20140122099A1 (en) | Cohort identification system | |
| US10877984B1 (en) | Systems and methods for filtering and visualizing large scale datasets | |
| US10459987B2 (en) | Data virtualization for workflows | |
| CN113407646A (en) | Knowledge graph-based distributed hospital information comprehensive query system | |
| CN102902614A (en) | Dynamic monitoring and intelligent guide method | |
| von Bültzingsloewen et al. | ECA functionality in a distributed environment | |
| US8032475B2 (en) | Ruleset optimization through blocked and concurrent rule dispatch | |
| Castellano et al. | A flexible mining architecture for providing new e-knowledge services |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210917 |
|
| RJ01 | Rejection of invention patent application after publication |