CN101576882A - Traceable data collecting and analyzing system - Google Patents

Traceable data collecting and analyzing system Download PDF

Info

Publication number
CN101576882A
CN101576882A CNA2008100371379A CN200810037137A CN101576882A CN 101576882 A CN101576882 A CN 101576882A CN A2008100371379 A CNA2008100371379 A CN A2008100371379A CN 200810037137 A CN200810037137 A CN 200810037137A CN 101576882 A CN101576882 A CN 101576882A
Authority
CN
China
Prior art keywords
data
business diagnosis
course
operating point
key
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.)
Granted
Application number
CNA2008100371379A
Other languages
Chinese (zh)
Other versions
CN101576882B (en
Inventor
徐祖铭
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
No455 Hospital Pla
Original Assignee
No455 Hospital Pla
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by No455 Hospital Pla filed Critical No455 Hospital Pla
Priority to CN200810037137.9A priority Critical patent/CN101576882B/en
Publication of CN101576882A publication Critical patent/CN101576882A/en
Application granted granted Critical
Publication of CN101576882B publication Critical patent/CN101576882B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention discloses a traceable data collecting and analyzing system comprising a control layer, an operation layer and a data transmission layer. The control layer issues a data collection rule, maintains the received data, provides a data inquiry function, analyzes the received data, graphically exhibits an analysis result and has a capability of tracing historical attributes of the collected data. The operation layer comprises a plurality of operation points; each operation point extracts the data from a database associated with the operation point according to the data collection rule issued by the control layer, analyzes the extracted data, graphically exhibits an analysis result, has a capability of tracing historical attributes and additive attributes of the extracted data and transmits the extracted data to the control layer according to the data collection rule. The data transmission layer is arranged between the control layer and the operation layer so as to realize the communication between the control layer and the operation layer.

Description

Data acquisition and analytic system with the ability of can reviewing
Technical field
The present invention relates to data acquisition and monitoring technique, especially design a kind of data acquisition and analytic system with the ability of can reviewing.
Background technology
The reform of China's medical treatment system is moved towards the social security system from the socialized medicine system.Foundation by medical insurance system, progressively pushed medical expense to society, no longer by national load, add the reform of medical procurement is progressively prepared to the direction of separating drug dispensing from medical practice etc., all, also created good condition for the new application of infotech for China's medical industry is moved towards standardization, good basis has been established in the marketization.Along with the construction and the operation of hospital information system, data accumulation is more and more abundanter, becomes huge information wealth, for the career development progress of hospital provides strong support.Hospital will keep one's feet and try to achieve continuous development in the keen competition environment, must constantly form new decision-making to adapt to fast changing competitive landscape on the basis of analyzing data.In hospital, Army Hospital as medical institutions, faces the influence of above-mentioned overall situation as enterprise equally.In addition, the special nature of Army Hospital has also proposed special requirement to its informatization.
According to above demand background, Army Hospital according to army defend diligent system reach at ordinary times wartime health support organize and coordinate, requirement such as scheduling controlling, with the rapid reaction is core, solve that human resources, medical material, fund allocation and transfer etc. are defended directly the reporting automatically of diligent resource, compiled automatically, decision support demands such as intellectual analysis, intelligent planning and intelligent allocation, lifting army defends diligent system and defends diligent resource management and control level, realizes that army defends diligent commander by empirical to intelligent qualitative change.
Because the special management requirement of army, the informational needs of Army Hospital is reported to higher level administrative authority in time, and simultaneously, the information that requires to report has retrospective ability, can at any time recognize the historical process of this information.
Therefore, just need a kind of data acquisition with the ability of can reviewing, gather, analysis and supervisory system.
Summary of the invention
At above-mentioned demand, the invention provides and a kind ofly have having of the ability of to review and gather and analytic system.
The solution of the present invention is achieved as follows:
A kind of data acquisition and analytic system with the ability of can reviewing, comprise: key-course, issue data collecting rule and safeguard received data, the function of data query is provided, the data that receive are analyzed and showed the result of analysis in patterned mode, and key-course has the ability of can reviewing to the historical attribute of collected data; Operation layer, described operation layer comprises several operating points, each operating point extracts data according to the data collecting rule that described key-course issues from the database of operating point association, the result of analysis is analyzed and showed in patterned mode to data after extracting, each operating point has the ability of can reviewing to the historical attribute and the adeditive attribute of the data that it extracted, and each operating point arrives described key-course according to described data collecting rule with the data transmission of being extracted; Data transfer layer is erected between described key-course and the operation layer, realizes the data communication between key-course and the operation layer.
Wherein, described key-course comprises: the management platform server that is used to safeguard received data; Be erected at the business diagnosis server on the existing network framework, this business diagnosis server comprises business diagnosis server component, business diagnosis enterprise version assembly and internet information service; The client of business diagnosis client component has been installed; The key-course data communication server receives data from operation layer by described data transfer layer, and issues data collecting rule by described data transfer layer.Each operating point in the described operation layer comprises: related database provides source data; Be erected at the business diagnosis server on the existing network framework, this business diagnosis server comprises business diagnosis server component, business diagnosis enterprise version assembly and internet information service; The client of business diagnosis client component has been installed; The operating point data communication server receives data collecting rule from key-course by described data transfer layer, and sends the data of being gathered by described data transfer layer.Described data transfer layer is by E-mail transmission full dose or increment business diagnosis transmission data.
Each operating point in described key-course and the operation layer comprises: data Layer, unidirectional traffic is provided, and the reading capability of business datum only is provided to the developer; Application service layer provides bidirectional traffic, reads business datum from data Layer, is organized into the associated data Study document that breaks away from data Layer; Study document offered via the Web application layer represent layer; The operation requests that the receiving terminal user returns feeds back to after recomputating and represents layer; The Web application layer provides bidirectional traffic, links up the data stream between application service and the terminal user, and network access service is provided; Represent layer, bidirectional traffic be provided, obtain the demonstrating data of associated data Study document, and via the Web application layer to the request of application service submit operation.Data transfer layer provides the data transport service based on the E-mail transmission.
Each operating point in the described operation layer use business diagnosis application service by extract, conversion, the mode that loads obtain the source data in the related database, generate business diagnosis transmission data, by the business diagnosis enterprise version assembly in the operating point data conversion being transmitted in business diagnosis is the data analysis of business diagnosis associated data with the realization operating point, and the business diagnosis server in the operating point is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request; The full dose of operating point or increment business diagnosis transmission data send to key-course through the mode of data transfer layer by E-mail.Data transfer layer does not change the form of data, and business diagnosis is transferred to general headquarters with transmitting data transparency.Described key-course obtains the business diagnosis transmission data of the operating point transmission in the operation layer by the key-course data communication server, business diagnosis enterprise version assembly for business diagnosis transmission full dose Data Control layer loads data and be converted into the business diagnosis associated data, so that key-course analysis to be provided, business diagnosis enterprise version assembly for business diagnosis transmission incremental data key-course merges incremental data and full dose data, load then and be converted into the business diagnosis associated data so that concrete application service to be provided, the business diagnosis server of key-course is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request.
According to an embodiment, described key-course is served HMOs; Described operation layer is served medical institutions, and each operating point is wherein served a hospital.
Described key-course of serving HMOs comprises the analysis of data: provide ordering, on year-on-year basis, chain rate and mathematical model; Provide the chart of histogram, pie chart to represent; Review concrete patient's prescription on individual diagnosis detail.The operating point of serving hospital comprises the analysis of data: provide the chart of histogram, pie chart to represent; Review concrete patient's prescription on individual diagnosis, medical treatment, expense detail.
The operating point of serving hospital is according to data collecting rule, and regularly move the data in the database of gathering the court every day, saves as read-only business diagnosis transformat file.The operating point of serving hospital uploads to the data of up-to-date collection the key-course management platform server of key-course at the fixed time by data transfer layer; The management platform server of key-course gathers the data file of uploading by data transfer layer and gathers at preset time.
The operating point system that serves hospital utilizes the business diagnosis associated data to provide chart to represent and utilizes the business diagnosis associated data to review concrete patient's prescription on individual diagnosis, medical treatment, expense detail.The key-course of serving HMOs will merge from the business diagnosis associated data of operating point, form the business diagnosis transmission data after merging, extract business diagnosis transmission data, be loaded on business diagnosis associated data server by utilizing business diagnosis associated data provide ordering, on year-on-year basis, various analysis means such as chain rate and mathematical model, the prescription on individual diagnosis detail that provides chart to represent and review concrete patient.
The present invention also provides a kind of data acquisition and analytical approach with the ability of can reviewing, and comprising: issue data collecting rule by key-course; From the database of operating point association, extract data according to the data collecting rule that described key-course issues by several operating points in the operation layer; Each operating point is analyzed the data after extracting and is showed the result of analysis in patterned mode, and each operating point has the ability of can reviewing to the historical attribute and the adeditive attribute of the data that it extracted; Each operating point arrives described key-course according to described data collecting rule with the data transmission of being extracted; Key-course is also safeguarded received data, and the function of data query is provided, and the data that receive are analyzed and showed the result of analysis in patterned mode, and key-course has the ability of can reviewing to the historical attribute of collected data.
Wherein, each operating point in the described operation layer use business diagnosis application service by extract, conversion, the mode that loads obtain the source data in the related database, generates business diagnosis transmission data; By the business diagnosis enterprise version assembly in the operating point data conversion being transmitted in business diagnosis is the data analysis of business diagnosis associated data with the realization operating point, and the business diagnosis server in the operating point is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request; The full dose of operating point or increment business diagnosis transmission data send to key-course through the mode of data transfer layer by E-mail; Described key-course obtains the business diagnosis transmission data of the operating point transmission in the operation layer by the key-course data communication server, business diagnosis enterprise version assembly for business diagnosis transmission full dose Data Control layer loads data and be converted into the business diagnosis associated data, so that key-course analysis to be provided; Business diagnosis enterprise version assembly for business diagnosis transmission incremental data key-course merges incremental data and full dose data, loads then and is converted into the business diagnosis associated data so that concrete application service to be provided; The business diagnosis server of key-course is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request.
Adopt technical scheme of the present invention, realized that the trackability of network information system data, enhancing realize the intellectual analysis ability of network information system business, and improved the property monitored of the network information.
Description of drawings
Fig. 1 is the have data acquisition of the ability of can reviewing and the physical layer architecture figure of analytic system of the present invention;
Fig. 2 is the have data acquisition of the ability of can reviewing and the logical layer structure figure of analytic system of the present invention;
Fig. 3 is the have data acquisition of the ability of can reviewing and the data transmission flow diagram of analytic system of the present invention;
Fig. 4 is the have data acquisition of the ability of can reviewing and the process flow diagram of analytical approach of the present invention;
Fig. 5 A and Fig. 5 B show the example of traditional OLAP data cube and data organizational structure of the present invention respectively.
Embodiment
The invention provides a kind of data acquisition and analytic system, comprising with the ability of can reviewing:
Key-course, issue data collecting rule and safeguard received data, the function of data query is provided, the data that receive are analyzed and showed the result of analysis in patterned mode, key-course has the ability of can reviewing to the historical attribute of collected data;
Operation layer, operation layer comprises several operating points, each operating point extracts data according to the data collecting rule that key-course issues from the database of operating point association, the result of analysis is analyzed and showed in patterned mode to data after extracting, each operating point has the ability of can reviewing to the historical attribute and the adeditive attribute of the data that it extracted, and each operating point arrives key-course according to data collecting rule with the data transmission of being extracted;
Data transfer layer is erected between key-course and the operation layer, realizes the data communication between key-course and the operation layer.
With reference to shown in Figure 1, this physical layer architecture configuration with the data acquisition of the ability of can reviewing and analytic system is as follows,
Key-course 10 wherein comprises:
Be used to safeguard the management platform server 11 of received data;
Be erected at the business diagnosis server 12 on the existing network framework, this business diagnosis server comprises business diagnosis server component, business diagnosis enterprise version assembly and internet information service;
The client 13 of business diagnosis client component has been installed;
Key-course data communication server 14 receives data from operation layer by data transfer layer 30, and issues data collecting rule by data transfer layer 30.According to an embodiment, this key-course data communication server 14 is realized by mail server.
Each operating point 20 in the operation layer comprises:
Related database 21 provides source data;
Be erected at the business diagnosis server 22 on the existing network framework, this business diagnosis server comprises business diagnosis server component, business diagnosis enterprise version assembly and internet information service;
The client 23 of business diagnosis client component has been installed;
Operating point data communication server 24 receives data collecting rule from key-course by data transfer layer 30, and sends the data of being gathered by data transfer layer 30.According to an embodiment, this key-course data communication server 24 is realized by mail server.
Data transfer layer 30 transmits data by data communication network by E-mail transmission full dose or increment business diagnosis.According to an embodiment, between each operating point 20 of data transfer layer 30 and key-course 10 and operation layer, provide fire wall.
With reference to figure 2, shown in, on the basis of physical layer architecture shown in Figure 1, this logical organization configuration with the data acquisition of the ability of can reviewing and analytic system is as follows,
Each operating point 20 in key-course 10 and the operation layer all has similar logical organization, comprising:
Data Layer 40 provides unidirectional traffic, and the reading capability of business datum only is provided to the developer;
Application service layer 41 provides bidirectional traffic, reads business datum from data Layer, is organized into the associated data Study document that breaks away from data Layer; Study document offered via the Web application layer represent layer; The operation requests that the receiving terminal user returns feeds back to after recomputating and represents layer;
Web application layer 42 provides bidirectional traffic, links up the data stream between application service and the terminal user, and network access service is provided;
Represent the layer 43, bidirectional traffic is provided, obtain the demonstrating data of associated data Study document, and via the Web application layer to the request of application service submit operation;
Data transfer layer 30 provides the data transport service based on the E-mail transmission.
With reference to figure 3, show based on the data acquisition with the ability of can reviewing of physics illustrated in figures 1 and 2 and logical organization and the data transmission flow diagram in the analytic system,
Each operating point 10 in the operation layer use business diagnosis application services by extract, source data in the database that conversion, the mode that loads (ETL) obtain association, generate business diagnosis transmission data, by the business diagnosis enterprise version assembly in the operating point data conversion being transmitted in business diagnosis is the data analysis of business diagnosis associated data with the realization operating point, and the business diagnosis server in the operating point is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request; The full dose of operating point 20 or increment business diagnosis transmission data send to key-course 10 through the mode of data transfer layer 30 by E-mail;
Data transfer layer 30 does not change the form of data, and business diagnosis is transferred to general headquarters with transmitting data transparency;
Key-course 10 obtains the business diagnosis transmission data of the operating point transmission in the operation layer by the key-course data communication server, business diagnosis enterprise version assembly for business diagnosis transmission full dose Data Control layer loads data and be converted into the business diagnosis associated data, so that key-course analysis to be provided, business diagnosis enterprise version assembly for business diagnosis transmission incremental data key-course merges incremental data and full dose data, load then and be converted into the business diagnosis associated data so that concrete application service to be provided, the business diagnosis server of key-course is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request.
An application example of the present invention is to be applied to medical institutions, and key-course is wherein served HMOs, and operation layer is served medical institutions, and each operating point is wherein served a hospital.Further, this system applies is in the Army Hospital system, and key-course is wherein served general headquarters, and operation layer is served Army Hospital, and each operating point is wherein served an Army Hospital.Be applied in the system of Army Hospital system, data transfer layer will be based on the dedicated data transmission network struction of army.
The key-course of serving HMOs comprises the analysis of data: provide ordering, on year-on-year basis, chain rate and mathematical model; Provide the chart of histogram, pie chart to represent; Review concrete patient's prescription on individual diagnosis detail.And the operating point of serving hospital comprises the analysis of data: provide the chart of histogram, pie chart to represent; Review concrete patient's prescription on individual diagnosis, medical treatment, expense detail.
For the application of Army Hospital, the key-course of serving general headquarters comprises the analysis of data: classification gathers data such as the above rank of military counsellor, priority support, serious disease medical treatment, special medical personnel's outpatient service medicine, ambulatory care, the medicine of being in hospital, medical treatment in hospital.Carry out data mining from a plurality of angles such as time, region of war, hospital, personnel's classifications, trace back to the above rank of concrete military counsellor, priority support, serious disease medical treatment, special medical patient's details.The rank and the contrast of the above rank of the military counsellor of each region of war, hospital, priority support, serious disease medical treatment, special medical expense.Situation of change from the above rank of various chart reflection military counsellors, priority support, serious disease medical treatment, special medical expense.And the operating point of serving each Army Hospital comprises the analysis of data: based on the data query of certain querying condition, and provide on year-on-year basis, relevance ratio such as chain rate is to data.Gather based on the expense in hospital's scope, and provide on year-on-year basis, relevance ratio such as chain rate is to data.Hospital outpatient medicine, ambulatory care are provided, expense precedence datas such as the medicine of being in hospital, the medical treatment of being in hospital.Hospital outpatient medicine, ambulatory care are provided, expense distribution situations such as the medicine of being in hospital, the medical treatment of being in hospital.Information inquiries such as outpatient service medicine detail, medical detail are provided.Information inquiries such as hospital's medicine detail, medical detail are provided.
The operating point of serving hospital is according to data collecting rule, and regularly move the data in the database of gathering the court every day, saves as read-only business diagnosis transformat file; The operating point of serving hospital uploads to the data of up-to-date collection the key-course management platform server of key-course at the fixed time by data transfer layer; The management platform server of key-course gathers the data file of uploading by data transfer layer and gathers at preset time.
For the application of Army Hospital, the key-course of serving general headquarters issues data collecting rule by the management platform server.The operating point of serving each hospital is according to data collecting rule, and 24 o'clock to 1 o'clock morning of every day is gathered the court's data automatically, saves as read-only business diagnosis transformat file.Each operating point with the data of up-to-date collection every day 1:00 AM to 3 upload to the management platform server.Management platform server 3:00 AM to 6 every day gathers the data file of uploading.Wherein, each operating point can be according to the self-defined application data collection rule of user's request, but reported data must be followed the rule that key-course issues.
On the basis of Physical layer of introducing in conjunction with Fig. 1 and Fig. 2 and logical layer framework, the data analysis function of key-course and operation layer can be achieved as follows in the above:
The operating point system that serves hospital utilizes the business diagnosis associated data to provide chart to represent and utilizes the business diagnosis associated data to review concrete patient's prescription on individual diagnosis, medical treatment, expense detail;
The key-course of serving HMOs will merge from the business diagnosis associated data of operating point, form the business diagnosis transmission data after merging, extract business diagnosis transmission data, be loaded on business diagnosis associated data server by utilizing business diagnosis associated data provide ordering, on year-on-year basis, various analysis means such as chain rate and mathematical model, the prescription on individual diagnosis detail that provides chart to represent and review concrete patient.
With reference to shown in Figure 4, the present invention also provides a kind of data acquisition and analytical approach with the ability of can reviewing, and comprising:
51. issue data collecting rule by key-course;
52. from the database of operating point association, extract data according to the data collecting rule that key-course issues by several operating points in the operation layer;
53. each operating point is analyzed the data after extracting and showed the result of analysis in patterned mode, each operating point has the ability of can reviewing to the historical attribute and the adeditive attribute of the data that it extracted;
54. each operating point arrives key-course according to data collecting rule with the data transmission of being extracted;
55. key-course is also safeguarded received data, and the function of data query is provided, and the data that receive are analyzed and showed the result of analysis in patterned mode, key-course has the ability of can reviewing to the historical attribute of collected data.
Equally, on the basis of Physical layer of introducing in conjunction with Fig. 1 and Fig. 2 and logical layer framework, above-mentioned method can be achieved as follows in the above:
Each operating point in the operation layer use business diagnosis application service by extract, conversion, the mode that loads obtain the source data in the related database, generates business diagnosis transmission data;
By the business diagnosis enterprise version assembly in the operating point data conversion being transmitted in business diagnosis is the data analysis of business diagnosis associated data with the realization operating point, and the business diagnosis server in the operating point is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request;
The full dose of operating point or increment business diagnosis transmission data send to key-course through the mode of data transfer layer by E-mail;
Key-course obtains the business diagnosis transmission data of the operating point transmission in the operation layer by the key-course data communication server, business diagnosis enterprise version assembly for business diagnosis transmission full dose Data Control layer loads data and be converted into the business diagnosis associated data, so that key-course analysis to be provided;
Business diagnosis enterprise version assembly for business diagnosis transmission incremental data key-course merges incremental data and full dose data, loads then and is converted into the business diagnosis associated data so that concrete application service to be provided;
The business diagnosis server of key-course is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request.
According to one embodiment of the invention, in the data acquisition and analytic system that are applied to Army Hospital, adopted the memory database technology, to increase the speed of handling mass data with the ability of can reviewing.The business diagnosis associated data that the object that memory database data is handled is promptly come by business diagnosis transmission data-switching, these data are loaded in the internal memory directly to be handled.
Be different from traditional relational database system based on disk, the master data base memory-resident of memory database, simultaneously, memory database has been abandoned the traditional approach of data in magnetic disk management, all redesigned architecture based on total data in internal memory, its optimization aim is to improve internal memory and CPU service efficiency.Simultaneously, memory database has also carried out corresponding improvement aspect metadata cache, fast algorithm, parallel work-flow.The maximum characteristics of memory database are its " primary copy " or " working version " memory-resident, and promptly active transaction is only come into contacts with the memory copying of real-time internal memory database.Because issued transaction need not to carry out disk access, so data processing speed is higher more than 10 times than the data processing speed of traditional database, has greatly improved the application performance of Database Systems.
With compare based on disk database, the main advantage of memory database is:
1) removed frequent magnetic disc i/o operation from, finished same function, required machine instruction significantly reduces;
2) no longer need Buffer Manager, eliminated copying data expense extra between disk and the internal memory;
3) in the organization and administration of data and index, be extensive use of pointer, simplified memory management, reduced memory cost.
Traditional disk database is based upon on the relational model mostly.In order to reduce redundancy, separated record, when needing, use critical field that these records are connected together.The data base programmer need accept or reject with more spaces raising speed with between with more time interpolation reference record, and these select often to make the runnability of Database Systems to reduce.
The shared drive mechanism that memory database system has used operating system to provide, a slice shared drive district of during system initialization entire database being packed into, during operation, application process is directly visited entire database or a part of virtual address space that is mapped to oneself.At relation and index data these characteristics in internal memory entirely, pointer is used in data structure and data access widely.Application process can be passed through pointer, also can pass through position independent database side-play amount visit data, need not as disk database mutual with Buffer Manager.In addition, owing to pointer length is fixed, so the variable-length field problem can finely solve.Secondly, if a big data object repeatedly occurs, then only need storage once in the internal memory in database, other local pointer that uses is quoted.
Memory database system has been saved the space greatly than the Relational database of same level, because it has optimized data when data transmission---and remove unnecessary field data, automatically table is linked together.Do not need index, each available fields is become inquire about field and do not reduce performance.Because this design, memory database only need 1/10 space of same data in correlation model usually, i.e. the internal memory of 10GB is advanced in 100GB data compression.In application to the line number in form quantity, field quantity, the table and cell without limits.Internal memory is the factor of unique restriction application size.
In internal memory, all calculate after by inquiry and just begin the native system memory database, do not carry out in advance with all data storages.The design of system can be carried out whole application (comprising data model) in internal memory---and this is to use with traditional OLAP cube to compare high efficiency reason.It has created a data storage model based on internal memory, when it during data download, can obtain millions upon millions of data cells, and return Query Result in the time of level second in a data source.
The example of the data organizational structure that tradition OLAP data cube and native system are adopted is respectively shown in Fig. 5 A and Fig. 5 B.
In the data acquisition and analytic system that are applied to Army Hospital with the ability of can reviewing, data organization is on the data model basis that is based upon based on internal memory, form the interior tissue logical organization, at organization internal, multilist carries out association, formation has the data structure of the low coupling of high cohesion, and data are handled the consumption of minimizing internal memory through overcompression.
Query optimization depends on the storage means of data, the structure of index etc.The target of traditional query optimization is to reduce the access amount of disk, and with this end in view enquiring and optimizing method is not suitable for memory database.In memory database system, because the data set of affairs access is in internal memory, the target of memory database system query optimization is to save internal memory and CPU time.In order to reach this target, to select the suitable data storage organization for use for memory database earlier, design relational algebra operative algorithm efficiently on this basis, utilize equivalence theorem to carry out logic optimization again.
In the memory database of native system, the intermediate result of computing all is to preserve with the form of pointer, and as the source data of next computing, does not need to do earlier project, is taken up space to reduce intermediate result.And all project are risen to root, and a plurality of project are combined into project one time, disposable attribute with the pointer indication takes out finishes projection, to reduce the cost of RAT.
The memory database logic optimization rule that system adopts is as follows:
Rule 1: elect down and select computing, will select computing to be attached in the concatenation operation;
Rule 2: project is risen to tree root, merge project at last.
Simultaneously, the method that has adopted data to divide improves the order rate of high-speed cache.Jolt for fear of high-speed cache, adopt the cache database method of operating, increase a caching between operation, the result of buffer memory child-operation when this buffer memory is filled or child-operation when finishing, returns to parent-operation with the result again.
By above-mentioned query optimization operation, further improved the search efficiency of memory database.
On the architecture, system allows the user to select for use the deployment way of any user side to be connected to application system: zero spacial DHTML end, ActiveX plug-in unit, window client or Java client.System can increase and decrease client quickly and easily, and guarantees that each user can both have access to up-to-date query analysis result.
The transmission of data can adopt multiple mode to carry out asynchronous communication according to actual needs.System can be simply and promptly from discrete bottom data source loading data, to divide but not hour speed carry out the increment heavy duty.By such architecture, system has reduced the pressure to bottom operation system and data warehouse significantly.Commander's node can be disposed whenever and wherever possible, client node can Fast Installation with move, make system have the availability and the dirigibility of height.
The hospital information network of handling based on internal memory of the present invention directly reports the data handling procedure of traceability system to realize according to the following steps:
Step 1: loading data.
Step 2: data are extracted and are compressed into a data file with height logical relation.
Step 3: the user is clicking operation when using.
Step 4: according to institute's selection operation, related related data in internal memory, and the result returned the interface.
Adopt technical scheme of the present invention, realized that the trackability of network information system data, enhancing realize the intellectual analysis ability of network information system business, and improved the property monitored of the network information.

Claims (10)

1. a data acquisition and analytic system with the ability of can reviewing comprises:
Key-course, issue data collecting rule and safeguard received data, the function of data query is provided, the data that receive are analyzed and showed the result of analysis in patterned mode, key-course has the ability of can reviewing to the historical attribute of collected data;
Operation layer, described operation layer comprises several operating points, each operating point extracts data according to the data collecting rule that described key-course issues from the database of operating point association, the result of analysis is analyzed and showed in patterned mode to data after extracting, each operating point has the ability of can reviewing to the historical attribute and the adeditive attribute of the data that it extracted, and each operating point arrives described key-course according to described data collecting rule with the data transmission of being extracted;
Data transfer layer is erected between described key-course and the operation layer, realizes the data communication between key-course and the operation layer.
2. data acquisition and the analytic system with the ability of can reviewing as claimed in claim 1 is characterized in that,
Described key-course comprises:
Be used to safeguard the management platform server of received data;
Be erected at the business diagnosis server on the existing network framework, this business diagnosis server comprises business diagnosis server component, business diagnosis enterprise version assembly and internet information service;
The client of business diagnosis client component has been installed;
The key-course data communication server receives data from operation layer by described data transfer layer, and issues data collecting rule by described data transfer layer;
Each operating point in the described operation layer comprises:
Related database provides source data;
Be erected at the business diagnosis server on the existing network framework, this business diagnosis server comprises business diagnosis server component, business diagnosis enterprise version assembly and internet information service;
The client of business diagnosis client component has been installed;
The operating point data communication server receives data collecting rule from key-course by described data transfer layer, and sends the data of being gathered by described data transfer layer;
Described data transfer layer is by E-mail transmission full dose or increment business diagnosis transmission data.
3. data acquisition and the analytic system with the ability of can reviewing as claimed in claim 2 is characterized in that,
Each operating point in described key-course and the operation layer comprises:
Data Layer provides unidirectional traffic, and the reading capability of business datum only is provided to the developer;
Application service layer provides bidirectional traffic, reads business datum from data Layer, is organized into the associated data Study document that breaks away from data Layer; Study document offered via the Web application layer represent layer; The operation requests that the receiving terminal user returns feeds back to after recomputating and represents layer;
The Web application layer provides bidirectional traffic, links up the data stream between application service and the terminal user, and network access service is provided;
Represent layer, bidirectional traffic be provided, obtain the demonstrating data of associated data Study document, and via the Web application layer to the request of application service submit operation;
Data transfer layer provides the data transport service based on the E-mail transmission.
4. data acquisition and the analytic system with the ability of can reviewing as claimed in claim 3 is characterized in that,
Each operating point in the described operation layer use business diagnosis application service by extract, conversion, the mode that loads obtain the source data in the related database, generate business diagnosis transmission data, by the business diagnosis enterprise version assembly in the operating point data conversion being transmitted in business diagnosis is the data analysis of business diagnosis associated data with the realization operating point, and the business diagnosis server in the operating point is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request; The full dose of operating point or increment business diagnosis transmission data send to key-course through the mode of data transfer layer by E-mail;
Data transfer layer does not change the form of data, and business diagnosis is transferred to general headquarters with transmitting data transparency;
Described key-course obtains the business diagnosis transmission data of the operating point transmission in the operation layer by the key-course data communication server, business diagnosis enterprise version assembly for business diagnosis transmission full dose Data Control layer loads data and be converted into the business diagnosis associated data, so that key-course analysis to be provided, business diagnosis enterprise version assembly for business diagnosis transmission incremental data key-course merges incremental data and full dose data, load then and be converted into the business diagnosis associated data so that concrete application service to be provided, the business diagnosis server of key-course is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request.
5. as each described data acquisition and analytic system in the claim 1 to 4, it is characterized in that with the ability of can reviewing,
Described key-course is served HMOs; Described operation layer is served medical institutions, and each operating point is wherein served a hospital.
6. data acquisition and the analytic system with the ability of can reviewing as claimed in claim 5 is characterized in that,
Described key-course of serving HMOs comprises the analysis of data:
Provide ordering, on year-on-year basis, chain rate and mathematical model;
Provide the chart of histogram, pie chart to represent;
Review concrete patient's prescription on individual diagnosis detail;
The operating point of serving hospital comprises the analysis of data:
Provide the chart of histogram, pie chart to represent;
Review concrete patient's prescription on individual diagnosis, medical treatment, expense detail.
7. data acquisition and the analytic system with the ability of can reviewing as claimed in claim 6 is characterized in that,
The operating point of serving hospital is according to data collecting rule, and regularly move the data in the database of gathering the court every day, saves as read-only business diagnosis transformat file;
The operating point of serving hospital uploads to the data of up-to-date collection the key-course management platform server of key-course at the fixed time by data transfer layer;
The management platform server of key-course gathers the data file of uploading by data transfer layer and gathers at preset time.
8. data acquisition and the analytic system with the ability of can reviewing as claimed in claim 6 is characterized in that,
The operating point system that serves hospital utilizes the business diagnosis associated data to provide chart to represent and utilizes the business diagnosis associated data to review concrete patient's prescription on individual diagnosis, medical treatment, expense detail;
The key-course of serving HMOs will merge from the business diagnosis associated data of operating point, form the business diagnosis transmission data after merging, extract business diagnosis transmission data, be loaded on business diagnosis associated data server by utilizing business diagnosis associated data provide ordering, on year-on-year basis, various analysis means such as chain rate and mathematical model, the prescription on individual diagnosis detail that provides chart to represent and review concrete patient.
9. a data acquisition and analytical approach with the ability of can reviewing comprises:
Issue data collecting rule by key-course;
From the database of operating point association, extract data according to the data collecting rule that described key-course issues by several operating points in the operation layer;
Each operating point is analyzed the data after extracting and is showed the result of analysis in patterned mode, and each operating point has the ability of can reviewing to the historical attribute and the adeditive attribute of the data that it extracted;
Each operating point arrives described key-course according to described data collecting rule with the data transmission of being extracted;
Key-course is also safeguarded received data, and the function of data query is provided, and the data that receive are analyzed and showed the result of analysis in patterned mode, and key-course has the ability of can reviewing to the historical attribute of collected data.
10. data acquisition and the analytical approach with the ability of can reviewing as claimed in claim 9 is characterized in that,
Each operating point in the described operation layer use business diagnosis application service by extract, conversion, the mode that loads obtain the source data in the related database, generates business diagnosis transmission data;
By the business diagnosis enterprise version assembly in the operating point data conversion being transmitted in business diagnosis is the data analysis of business diagnosis associated data with the realization operating point, and the business diagnosis server in the operating point is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request;
The full dose of operating point or increment business diagnosis transmission data send to key-course through the mode of data transfer layer by E-mail;
Described key-course obtains the business diagnosis transmission data of the operating point transmission in the operation layer by the key-course data communication server, business diagnosis enterprise version assembly for business diagnosis transmission full dose Data Control layer loads data and be converted into the business diagnosis associated data, so that key-course analysis to be provided;
Business diagnosis enterprise version assembly for business diagnosis transmission incremental data key-course merges incremental data and full dose data, loads then and is converted into the business diagnosis associated data so that concrete application service to be provided;
The business diagnosis server of key-course is converted into the client analysis and consult of html format for operating point after the internet information service receives the query analysis request.
CN200810037137.9A 2008-05-08 2008-05-08 Traceable data collecting and analyzing system Expired - Fee Related CN101576882B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN200810037137.9A CN101576882B (en) 2008-05-08 2008-05-08 Traceable data collecting and analyzing system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN200810037137.9A CN101576882B (en) 2008-05-08 2008-05-08 Traceable data collecting and analyzing system

Publications (2)

Publication Number Publication Date
CN101576882A true CN101576882A (en) 2009-11-11
CN101576882B CN101576882B (en) 2011-01-12

Family

ID=41271816

Family Applications (1)

Application Number Title Priority Date Filing Date
CN200810037137.9A Expired - Fee Related CN101576882B (en) 2008-05-08 2008-05-08 Traceable data collecting and analyzing system

Country Status (1)

Country Link
CN (1) CN101576882B (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101895426A (en) * 2010-07-20 2010-11-24 中兴通讯股份有限公司 Data acquisition method and system in network resource evaluation
CN104765771A (en) * 2015-03-11 2015-07-08 杭州安恒信息技术有限公司 System and method for analyzing database behaviors
CN104866567A (en) * 2015-05-22 2015-08-26 国家计算机网络与信息安全管理中心 Method and apparatus for presenting business data
CN105931114A (en) * 2016-04-18 2016-09-07 中国建设银行股份有限公司 Centralized monitoring and analysis method and system for multi-application transaction information logic paths of bank
CN107644673A (en) * 2017-09-18 2018-01-30 苏州市卫生计生统计信息中心 Hospital business data distribution formula real-time acquisition system and method
CN107846442A (en) * 2017-08-02 2018-03-27 上海数烨数据科技有限公司 It is a kind of to increase the method for customizing passage gathered data based on Zabbix aggressive modes
CN108769197A (en) * 2018-05-29 2018-11-06 桂林优利特医疗电子有限公司 Automatic clinical chemistry analyzer information collecting method and system
CN108986873A (en) * 2018-06-27 2018-12-11 申艳莉 A kind of retrospective diagnosis and treatment data processing method and system
CN109471918A (en) * 2018-11-09 2019-03-15 医渡云(北京)技术有限公司 A kind of middle field retroactive method, equipment and medium
CN110019182A (en) * 2017-08-15 2019-07-16 华为技术有限公司 A kind of data traceability method and device

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1773453A (en) * 2004-11-10 2006-05-17 东软集团有限公司 System constituting method based on data definition
CN101075304A (en) * 2006-05-18 2007-11-21 河北全通通信有限公司 Method for constructing decision supporting system of telecommunication industry based on database
CN101141370A (en) * 2007-10-09 2008-03-12 南京财经大学 Gridding service based electric power enterprise real-time data processing method

Cited By (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101895426A (en) * 2010-07-20 2010-11-24 中兴通讯股份有限公司 Data acquisition method and system in network resource evaluation
WO2012009901A1 (en) * 2010-07-20 2012-01-26 中兴通讯股份有限公司 Data acquisition method in network resource estimation and system thereof
RU2532714C2 (en) * 2010-07-20 2014-11-10 Зте Корпорэйшен Method of acquiring data when evaluating network resources and apparatus therefor
CN104765771B (en) * 2015-03-11 2018-12-04 杭州安恒信息技术有限公司 A kind of behavior database analysis system and analysis method
CN104765771A (en) * 2015-03-11 2015-07-08 杭州安恒信息技术有限公司 System and method for analyzing database behaviors
CN104866567A (en) * 2015-05-22 2015-08-26 国家计算机网络与信息安全管理中心 Method and apparatus for presenting business data
CN105931114A (en) * 2016-04-18 2016-09-07 中国建设银行股份有限公司 Centralized monitoring and analysis method and system for multi-application transaction information logic paths of bank
CN107846442A (en) * 2017-08-02 2018-03-27 上海数烨数据科技有限公司 It is a kind of to increase the method for customizing passage gathered data based on Zabbix aggressive modes
CN110019182A (en) * 2017-08-15 2019-07-16 华为技术有限公司 A kind of data traceability method and device
CN110019182B (en) * 2017-08-15 2023-11-17 华为技术有限公司 Data tracing method and device
CN107644673A (en) * 2017-09-18 2018-01-30 苏州市卫生计生统计信息中心 Hospital business data distribution formula real-time acquisition system and method
CN108769197A (en) * 2018-05-29 2018-11-06 桂林优利特医疗电子有限公司 Automatic clinical chemistry analyzer information collecting method and system
CN108986873A (en) * 2018-06-27 2018-12-11 申艳莉 A kind of retrospective diagnosis and treatment data processing method and system
CN109471918A (en) * 2018-11-09 2019-03-15 医渡云(北京)技术有限公司 A kind of middle field retroactive method, equipment and medium
CN109471918B (en) * 2018-11-09 2020-11-10 医渡云(北京)技术有限公司 Intermediate field tracing method, device and medium

Also Published As

Publication number Publication date
CN101576882B (en) 2011-01-12

Similar Documents

Publication Publication Date Title
CN101576882B (en) Traceable data collecting and analyzing system
Angrish et al. A flexible data schema and system architecture for the virtualization of manufacturing machines (VMM)
CN103930875B (en) Software virtual machine for acceleration of transactional data processing
US8832020B2 (en) Method and system for safely transporting legacy data to an object semantic form data grid
US9183153B2 (en) Method and system for managing power grid data
CN107766402A (en) A kind of building dictionary cloud source of houses big data platform
JP5584780B2 (en) Data collection method, data collection apparatus, and network management device
CN100518131C (en) Grid data duplicate management system
CN102096684A (en) Grid real-time data integrating and sharing platform
Lai et al. Towards a framework for large-scale multimedia data storage and processing on Hadoop platform
KR20150112357A (en) Sensor data processing system and method thereof
CN105190623A (en) Log record management
CN104573068A (en) Information processing method based on megadata
CN106919608A (en) Medical data processing method, device and platform
CN103365971A (en) Mass data access processing system based on cloud computing
CN103207920A (en) Parallel metadata acquisition system
CN110196885A (en) A kind of cloud distributed real-time database system
CN103235817A (en) Large-scale infection control data storage processing method
CN112632025A (en) Power grid enterprise management decision support application system based on PAAS platform
CN114647716B (en) System suitable for generalized data warehouse
CN104035807A (en) Metadata cache replacement method of cloud storage system
US20090150351A1 (en) Method and system for querying a database
CN104573074A (en) High-speed calculating and analyzing method based on hospital data
CN109411094A (en) Health life expectancy in life expectancy application support information system and method based on hygiene medical treatment big data
CN105279375A (en) Regional medical image storage system based on Hadoop

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
C17 Cessation of patent right
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20110112

Termination date: 20110508