CN103258054B - Method and device for processing data - Google Patents
Method and device for processing data Download PDFInfo
- Publication number
- CN103258054B CN103258054B CN201310213824.2A CN201310213824A CN103258054B CN 103258054 B CN103258054 B CN 103258054B CN 201310213824 A CN201310213824 A CN 201310213824A CN 103258054 B CN103258054 B CN 103258054B
- Authority
- CN
- China
- Prior art keywords
- data
- dimension
- metric
- acquisition system
- incidence relation
- 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.)
- Expired - Fee Related
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and device for processing data, wherein the method includes the following steps: dimension data are obtained; a first data set corresponding to the dimension data is extracted from a first data bank, wherein the first data set comprises first data; aggregation calculation is carried out on the first data and a metric value is obtained; a first incidence relation is established between the metric value and the dimension data and a second data bank is generated. According to the method and device for processing the data, the effect that a complete ancient Chinese medicine case data bank is established rapidly and accurately is achieved. When a user inquires ancient Chinese medicine case data, the user can directly obtain a complete inquiry result by directly inquiring from the second data bank. Inquiry is rapid, accurate and high in efficiency.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of data processing method and device.
Background technology
Ancient Chinese medicine case carries the theory of medicine of ancient Chinese medicine doctor and practical experience for thousands of years, be richly stored with,
Unknown information, is the precious resources of Basic Theories of Chinese Medicine and clinical research.How to realize the traditional Chinese medical science doctor in ancient literature resource
The digitized storage of case, obtains ancient Chinese medicine diagnosis and treatment rule, is very necessary and urgent task.
Increasingly extensive in the application of tcm field with computer information technology, set up in ancient times using computer technology
Doctor's case data-storage system, realizes the digitized storage of ancient Chinese medicine case, obtains containing, unknown in advance, valuable
Information, seek ancient Chinese medicine Therapy characteristics, become possibility, and attempted by some researcheres, in ancient times traditional Chinese medical science case data
Collection, storage, in the fundamentals of management it is achieved that ancient Chinese medicine case Study on Data Processing.But, existing research exists all
Many problems.First, existing research only achieves simple statistics, data analysiss are limited only to from single angle, statistics frequency
Secondary and frequency, such as: the use cave frequency based on specific passages through which vital energy circulates and frequency.Second, existing data storage simply realizes the letter of data
Single storage, when carrying out complex query to such data, existing storage system is difficult to multi-angle, multi-level, many sides
Inquire about and obtain accurate and visual and understandable Query Result.
For in prior art because existing ancient Chinese medicine medical case database is imperfect, thus leading to using existing case
The result of data base querying data is inaccurate, inefficiency, and cannot realize the problem of increasingly complex inquiry, not yet carries at present
Go out effective solution.
Content of the invention
For correlation technique because existing ancient Chinese medicine medical case database is imperfect, thus leading to using existing case number
According to the result of library inquiry data is inaccurate, inefficiency, and the problem of increasingly complex inquiry cannot be realized, not yet propose at present
Effectively solution, for this reason, present invention is primarily targeted at providing a kind of data processing method and device, above-mentioned to solve
Problem.
To achieve these goals, according to an aspect of the invention, it is provided a kind of data processing method, the method bag
Include: obtain dimension data；First data acquisition system corresponding with dimension data, wherein, the first data is extracted from the first data base
Set includes the first data；Aggregation computation is carried out to the first data and obtains metric；Set up between metric and dimension data
First incidence relation generates the second data base.
Further, the first data carried out with Aggregation computation obtain the step of metric including: read from standard vocabulary storehouse
Take standard vocabulary；According to standard vocabulary, the first data is standardized being converted to the second data；Second data is gathered
Collection is calculated metric.
Further, after extracting first data acquisition system corresponding with dimension data from the first data base, at data
Reason method includes: whether the integrity degree of detection the first data meets first threshold, does not meet first in the integrity degree of the first data
In the case of threshold value, the first data is deleted or supplement is processed the first data acquisition system after being cleared up；Or detection first
Whether there is threeth data consistent with the first data in data acquisition system, there is the situation of the 3rd data in the first data acquisition system
Under, delete the 3rd data, the first data acquisition system after being cleared up.
Further, the first data is deleted or supplement process cleared up after the first data acquisition system step bag
Include: extract description data from dimension data；Using description number pick, supplement process is carried out to the first data, so that the first number pick
Integrity degree meet first threshold, the first data acquisition system after being cleared up.
Further, dimension data includes: dimension element data, dimension element code data and dimension element data with
The second incidence relation between dimension element code data, wherein, that sets up between metric and dimension data first associates pass
The step that system generates the second data base includes: the 3rd incidence relation setting up between metric and dimension element code data；Logical
Excessively value and the second incidence relation set up the first incidence relation；Preserve dimension data, metric, the first incidence relation and the 3rd
Incidence relation, to generate the second data base.
Further, after setting up the first incidence relation between metric and dimension data and generating the second data base,
Data processing method also includes: the first multidimensional data analysis request of receive user；By the first multidimensional data analysis request conversion
Ask for the second multidimensional data analysis；Obtain from the second data base and ask corresponding result data with the second multidimensional data analysis
Collection；Output result data set.
To achieve these goals, according to an aspect of the invention, it is provided a kind of data processing equipment, this device bag
Include: acquisition module, for obtaining dimension data；First extraction module, for extracting and dimension data pair from the first data base
The first data acquisition system answered；Computing module, is measured for carrying out Aggregation computation to the first data in the first data acquisition system
Value；First processing module, generates the second data base for setting up the first incidence relation between metric and dimension data.
Further, computing module includes: the first read module, for reading standard vocabulary from standard vocabulary storehouse；The
Two processing modules, for being standardized being converted to the second data to the first data according to standard vocabulary；First son calculates mould
Block, obtains metric for carrying out Aggregation computation to the second data.
Further, data processing equipment also includes: first detection module, for detect the first data integrity degree whether
Meet first threshold；3rd processing module, in the case of not meeting first threshold for the integrity degree in the first data, to first
Data is deleted or supplement processes the first data acquisition system after being cleared up；Second detection module, for detecting the first data
Whether there is threeth data consistent with the first data in set；Fourth processing module, for existing in the first data acquisition system
In the case of 3rd data, delete the 3rd data, the first data acquisition system after being cleared up.
Further, the 3rd processing module includes: the second extraction module, for extracting description data from dimension data；
5th processing module, for supplement process being carried out to the first data using description data, so that the integrity degree symbol of the first data
Close first threshold, the first data acquisition system after being cleared up.
Further, dimension data includes: dimension element data, dimension element code data and dimension element data with
The second incidence relation between dimension element code data, wherein, first processing module includes: the first subprocessing module, is used for
Set up the 3rd incidence relation between metric and dimension element code data；Second subprocessing module, for by metric
Set up the first incidence relation with the second incidence relation；3rd subprocessing module, for preserving dimension data, metric, the first pass
Connection relation and the 3rd incidence relation, to generate the second data base.
Using the present invention, by obtaining dimension data, from the first data base, then extract corresponding with dimension data the
One data acquisition system, and after the first data in the first data acquisition system being carried out with Aggregation computation and obtains metric, set up tolerance
The first incidence relation between value and dimension data generates the second data base, can obtain the first data set by dimension data
Close, after obtaining metric according to the first data acquisition system, set up the first incidence relation between metric and dimension data, lead to
Cross the first incidence relation and generate the second data base, metric is imported by the first incidence relation and generates the second data base, and then
There is provided data source that is accurate, being suitable for for multidimensional data analysis, thus solving due to existing ancient Chinese medicine medical case database
Imperfect and data is unordered, thus leading to that the result inquiring about data using existing medical case database is inaccurate, inefficiency, and
The problem of increasingly complex inquiry cannot be realized it is achieved that rapidly and accurately setting up the effect of complete ancient Chinese medicine medical case database
Really, during user's inquiry ancient Chinese medicine case data, directly inquire about from the second data base, can be with the complete inquiry knot of direct access
Really, inquire about quick, accurate, efficiency high.
Brief description
Accompanying drawing described herein is used for providing a further understanding of the present invention, constitutes the part of the application, this
Bright schematic description and description is used for explaining the present invention, does not constitute inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the structural representation of data processing equipment according to embodiments of the present invention；
Fig. 2 is the structural representation of the data processing equipment according to embodiment illustrated in fig. 1；
Fig. 3 is the flow chart of data processing method according to embodiments of the present invention；
Fig. 4 is the schematic flow sheet inquiring about data according to embodiment illustrated in fig. 3 in the second data base；And
Fig. 5 is the schematic flow sheet of the creation method of the initial multi-dimensional database according to embodiment illustrated in fig. 3.
Specific embodiment
It should be noted that in the case of not conflicting, the embodiment in the application and the feature in embodiment can phases
Mutually combine.To describe the present invention below with reference to the accompanying drawings and in conjunction with the embodiments in detail.
Fig. 1 is the structural representation of data processing equipment according to embodiments of the present invention.Fig. 2 is to implement according to Fig. 1
The structural representation of the data processing equipment of example.
As depicted in figs. 1 and 2, this device may include that acquisition module 10, for obtaining dimension data；First extraction mould
Block 30, for extracting first data acquisition system corresponding with dimension data from the first data base；Computing module 50, for first
The first data in data acquisition system carries out Aggregation computation and obtains metric；First processing module 70, is used for setting up metric and dimension
The first incidence relation between degrees of data generates the second data base.
Using the present invention, dimension data is obtained by acquisition module, then pass through the first extraction module from the first data base
Middle extraction first data acquisition system corresponding with dimension data, and in computing module, the first data in the first data acquisition system is carried out
After Aggregation computation obtains metric, set up the first incidence relation between metric and dimension data by first processing module
Generate the second data base, the first data acquisition system can be obtained by dimension data, obtain tolerance according to the first data acquisition system
After value, set up the first incidence relation between metric and dimension data, the second data base generated by the first incidence relation,
Metric is imported by the first incidence relation and generates the second data base, and then provide for multidimensional data analysis accurate, applicable
Data source, thus solve due to existing ancient Chinese medicine medical case database imperfect, thus leading to using existing case number
According to the result of library inquiry data is inaccurate, inefficiency, and the problem of increasingly complex inquiry cannot be realized it is achieved that quickly accurate
Really set up the effect of complete ancient Chinese medicine medical case database, during user's inquiry ancient Chinese medicine case data, directly from second
Inquire about in data base, can be with the complete Query Result of direct access, it is quick, accurate to inquire about, efficiency high.
Specifically, the scheme in the above embodiment of the present invention is applied to different data base management systems and different behaviour
Make system.
According to the abovementioned embodiments of the present invention, computing module 50 may include that the first read module 5l, for from standard words
Remittance reads standard vocabulary in storehouse；Second processing module 53, for being standardized changing to the first data according to standard vocabulary
To the second data；First sub- computing module 55, obtains metric for carrying out Aggregation computation to the second data.
Specifically, the standard vocabulary that can be read according to the first read module 51 by Second processing module 53 is to first
Data is standardized being converted to the second data.For example, the title of dynasty dimension data there may be time, publication time etc.
Various ways, be probably such as: the different form such as clear, Qing Dynasty, Qing Dynasty, then need to be uniformly processed according to standard vocabulary
Value form for " Qing Dynasty ".
In the above embodiment of the present invention, device can also include: first detection module 90, for detecting the first data
Integrity degree whether meet first threshold；3rd processing module 110, does not meet first threshold for the integrity degree in the first data
In the case of, the first data is deleted or supplement is processed the first data acquisition system after being cleared up；Second detection module
130, whether there is second data consistent with the first data in the first data acquisition system for detecting；Fourth processing module 150, uses
In the case of there is second data consistent with the first data in the first data acquisition system, delete the second data, cleared up
The first data acquisition system afterwards.
According to the abovementioned embodiments of the present invention, the 3rd processing module 110 may include that the second extraction module, for from dimension
Description data is extracted in degrees of data；5th processing module, for supplement process being carried out to the first data using description data, so that
The integrity degree obtaining the first data meets first threshold, the first data acquisition system after being cleared up.
Specifically, in this data processing equipment, the 3rd processing module 110 can also include data deletion module, is used for
According to the data value mistake in described first data and loss situation, carry out data dump；As: the integrity degree of detection the first data
Do not meet first threshold then it is assumed that this first data lacks the main disease to be treated data of case, then deleted by data deletion module
This first data；Second detection module 130 and fourth processing module 150 can be arranged in data combiners block, specifically, the
Two detection modules 130 can also detect the situation that whether there is multiple row storage identical datas in the first data acquisition system, if deposited
Then multiple row are being merged, specifically, be modified to the data in string using the unnecessary row of deletion or by the number pick in different row
Integration is processed, and obtains the first data acquisition system after cleaning, such as: acupuncture points on the human body data is respectively stored in master point and adjunct acupuncture points two row, then
The data of two row can be merged.
In the above embodiment of the present invention, dimension data may include that dimension element data, dimension element code data
And the second incidence relation between dimension element data and dimension element code data, wherein, first processing module includes: the
One subprocessing module, for setting up the 3rd incidence relation between metric and dimension element code data；Second subprocessing mould
Block, for setting up the first incidence relation by metric and the second incidence relation；3rd subprocessing module, for preserving number of dimensions
According to, metric, the first incidence relation and the 3rd incidence relation, to generate the second data base.
In the above embodiment of the present invention, this device can also include: receiver module 170, for the of receive user
One multidimensional data analysis request；First modular converter 190, for being converted into dimension more than second by the first multidimensional data analysis request
According to analysis request；6th processing module 210, corresponding with the second multidimensional data analysis request for obtaining from the second data base
Result data collection；And, output module 230, for output result data set.
Specifically, after the first multidimensional data analysis request receiving user by receiver module 170, the of system
One modular converter 190 can make requests on according to the first multidimensional data analysis request and be converted to the second multidimensional data analysis request,
Wherein, according to first multidimensional data analysis request make requests on conversion include to first multidimensional data analysis request carry out data please
Ask and classify and generate query statement or directly generate query statement, then pass through the 6th processing module 210 from the second data base
Obtain and ask corresponding result data collection with the second multidimensional data analysis, then this result data is exported by output module 230
Collection.Wherein, output module 230 can be in the way of according to user's request display result data collection in the second multidimensional data analysis request
Show this result data collection, wherein it is possible to result data collection is converted to by visualization data by the second modular converter, and pass through
Result data collection is shown by display module.Wherein, receiver module 170 and output module 230 may be located on the front end of system
On server；The mode of display result data collection includes: tables of data display format and graphic display form.
Fig. 3 is the flow chart of data processing method according to embodiments of the present invention, and the method as shown in Figure 3 includes walking as follows
Rapid:
Step s102, obtains dimension data.
Step s104, extracts first data acquisition system corresponding with dimension data, wherein, the first data from the first data base
Set includes the first data.
Step s106, carries out Aggregation computation to the first data and obtains metric.
Step s108, the first incidence relation set up between metric and dimension data generates the second data base.
Obtain dimension data first, then from the first data base, extract first data acquisition system corresponding with dimension data,
And after the first data in the first data acquisition system being carried out with Aggregation computation and obtains metric, set up metric and dimension data
Between the first incidence relation generate the second data base, the first data acquisition system can be obtained by dimension data, according to the
After one data acquisition system obtains metric, set up the first incidence relation between metric and dimension data, associate by first
Relation generates the second data base, imports metric by the first incidence relation and generates the second data base, and then is multidimensional data
Analysis provide accurately, the data source that is suitable for, thus solve due to existing ancient Chinese medicine medical case database imperfect, thus
Lead to the result inquiring about data using existing medical case database inaccurate, and cannot quickly obtain from existing data base directly perceived
The problem of understandable analysis result is it is achieved that rapidly and accurately set up the effect of complete ancient Chinese medicine medical case database, user
During inquiry ancient Chinese medicine case data, directly inquire about from the second data base, can be inquired about with the complete Query Result of direct access
Quickly, accurately, efficiency high.
Wherein, the above embodiment of the present invention can apply to the process of ancient Chinese medicine case data.In first data base
The incidence relation being stored between field of medicaments target standard vocabulary and standard vocabulary；Aggregation computation is to first getting
The statistical calculation that data is carried out, wherein statistical calculation include the calculating the first data sued for peace, averages and seek counting；Metric
Including the observation index value according to multiple data analysiss angles.Above-mentioned counting just refers to the calculating of metering number, for example, occurs hundred
Crossing point once just meter one number, occurs being counted as 2 to Baihui acupoint twice, occurs three times and be 3.
Dimension data can be saved in the dimension table in multi-dimensional database, and multi-dimensional database can preserve one group of dimension table
With the second data base, dimension data in each dimension table, can be preserved.Wherein, dimension is the angle of data analysiss, dimension hierarchy
For the description of the logical structure relation in dimension, dimension element data is for storing the concrete data on dimension hierarchy, dimension
Element code data can be one group of character code of unique mark dimension element data, can also preserve in dimension in dimension table
Logical structure relation description data, and logical structure relation reflects the division of the different level of detail in dimension.
More specifically, can also include the first data base in multi-dimensional database, the first data can include data analysiss angle
The description data of degree, and the 5th also preserving in the first data base between the first data and dimension element data associate
System, can read first data acquisition system corresponding with dimension data by the 5th incidence relation from the first data base.
In the above embodiment of the present invention, it is primarily due to store the description data of data analysiss angle in dimension table,
The observation index value according to multiple data analysiss angles is store, the data of storage in the wherein second data base in second data base
Can also be stored in multi-dimensional database using the preservation form of center table, build according to the first incidence relation and the 3rd incidence relation
Contacting between vertical center table and dimension table, builds ancient Chinese medicine case multi-dimensional database, provides science for multidimensional data analysis
, data source that is reliable, being accurately suitable for.
In the above-described embodiments, by the first incidence relation and the 3rd incidence relation, the second data base and dimension table are set up
Between contact, center table and dimension table are chained up, are easy to inquiry and the display of multidimensional data analysis result.For example,
By the dimension element data in dimension table and dimension element code data, by the get first multidimensional data analysis request
Multiple dimensions the element code combination that data is converted to corresponding dimension element code data composition is described, and using this
The corresponding metric of element code combination is obtained in the table of Xi Cong center；Conversely, utilizing this contact, by the tolerance in the table of center
The corresponding element code Combination conversion of value is the description data of multiple dimensions accordingly, and then understands specifically containing of metric
Justice.
In the above-described embodiments, the method for execution step s106 may include that
(1) according to the element combinations on the minimum dimension hierarchy between all dimensions, using the dimension data in dimension table
Aggregation computation is carried out to the first data in the first data acquisition system and generates the second data acquisition system, such as according to passages through which vital energy circulates, division of human body,
The Qucha cave on minimum dimension hierarchy between disease, therapy, five dimensions of dynasty, front/side Head Section, hemiplegia, acupuncture manipulation, bright
The dimension data of the element combinations in generation, carries out the concrete statistics that acupuncture points on the human body uses frequency to the first data in the first data acquisition system,
And generate shape such as: (Qucha cave element code, front/side Head Section element code, hemiplegia element code, acupuncture manipulation element code, bright
Use frequency for element code, acupuncture points on the human body) the second data acquisition system；
Due to multiple elements of the same name be there may be on a certain dimension hierarchy of some specific dimension and these elements are upper
Different father's elements be correspond on one-level level；For example, according to the Professional knowledge of tcm field, different syndromes may comprise phase
Same symptom, there may be multiple elements of the same name on the symptom level of disease dimension and these elements are corresponding on syndrome level
Different father's elements, such as: according to embodiments of the invention, hemiplegia symptom can be under the jurisdiction of multiple syndromes；For above-mentioned
Situation, according to the first pre-conditioned Model Design dimension element code using " segmentation, succession type ", that is, by a level unit
Father's element code section of plain code, it is possible to achieve the differentiation of element of the same name, for example, using the father unit of the code of hemiplegia element
Plain (i.e. element on syndrome level) carries out the differentiation of the symptom of the same name of different syndromes, and then realizes Aggregation computation；Additionally, being directed to
The use frequency of specific acupoint and usage frequency statistics, can be with " affiliated between the acupuncture points on the human body in establishing criteria lexicon and specific acupoint
Specific acupoint " contact attribute, in the use frequency of acupuncture points on the human body and the statistic processess of usage frequency, synchronously completes the use of specific acupoint
Frequency and the statistics of usage frequency.
Wherein, first pre-conditioned can be according in the logical structure relation between dimension hierarchy and traditional Chinese medical science standard vocabulary storehouse
Tcm field standard vocabulary, set in conjunction with ordering relation between the different elements in same level.Using " segmentation, continuing
Hold formula " (even there is father's element in some element to pattern, then the coding of this element is compiled with itself by father's element encoding of this element
Code composition, otherwise, this element will be coded independently), the element on the dimension hierarchy contained by dimension is encoded, above-mentioned coding
Pattern is easy to identify contact between the element on hierarchical elements and upper level level, improves Data Analysis Services efficiency；As: it is directed to
Passages through which vital energy circulates dimension, the element (i.e. whole) in top time be encoded to jm；Two elements on one-level level are (i.e. decent and strange
Warp) be separately encoded for: jmo and jml, above-mentioned coding is formed by two sections, and that is, father's element encoding value jm of element and respective element exist
Serial number (0 and 1) on same level；On two grades of levels, taking decent as a example, its two daughter elements (i.e. yang channel and yin channel)
It is separately encoded as jm00 and jm01, above-mentioned coding is by decent father's element encoding value jmo of element and respective element in same level
On serial number (0 and 1) composition；In the same manner, on tertiary level, taking yang channel as a example, its two daughter elements (three Yang channels of hand and foots
Three YANG meridians) it is separately encoded as jm000 and jm001；On level Four level, taking the three Yang channels of hand as a example, its three daughter element (handss
The bright large intestine channel of sun, triple energizer meridian and small intestine meridian) it is separately encoded as jmoooli, jmooosj and jm000si, on
State coding to be made up of decent father's element encoding value jm000 of element and the standard code of respective element, wherein, standard code foundation
Science of acupuncture and moxibustion standard vocabulary is with reference to China's authority's standard (standard No. is " acupuncture points on the human body title and the positioning " of gb/t12346-2006) and pin
The classical works in moxibustion field are (such as: " science of acupuncture and moxibustion ", " science of channels and collaterals ", " science of acupuncture points ", " meridional point ", " the international mark of acupuncture cave name
Quasi- handbook " etc.)；On Pyatyi level, taking the large intesting channel of Hand-Yangming as a example, its daughter element is (such as: shangyang acupoint, two ask cave, three ask cave
Deng) be separately encoded for: jmooolil, jmoooll2, jmoooll3 etc., above-mentioned coding is by decent father's element encoding value of element
Jm000li and and respective element on same level serial number composition；Wherein, serial number is according to science of acupuncture and moxibustion standard vocabulary reference
China's authority's standard (standard No. is " acupuncture points on the human body title and the positioning " of gb/t12346-2006) and the classical works in science of acupuncture and moxibustion field
(such as: " science of acupuncture and moxibustion ", "=the science of channels and collaterals ", " science of acupuncture points ", " meridional point ", " acupuncture cave name international standard handbook " etc.)
(2) between according to the element in the element combinations and different dimensions level on the higher dimensional level between dimension
Filiation, carries out Aggregation computation to existing data in the table of center and generates the 3rd data acquisition system.As: according to passages through which vital energy circulates, human body
Branch, disease, therapy, the bladder meridian between five dimensions of dynasty, head, hemiplegia, acupuncture manipulation, the element group of the Ming Dynasty
Close, and the daughter element situation according to bladder meridian element and header elements, acupuncture points on the human body use is carried out to the data in the table of center
The statistics of frequency, and generate shape such as: (bladder meridian element code, header elements code, hemiplegia element code, thorn
Method element code, Ming Dynasty's element code, acupuncture points on the human body use frequency) cohersive and integrated data.
(3) data in the second data acquisition system and the 3rd data acquisition system is directed into the second data base.
In the above-described embodiments, it is one group of dimension being actually needed determination according to ancient Chinese medicine case data analysiss, from
And ensure that the multi-angle of data analysiss；And the Professional knowledge according to tcm field, determines dimension hierarchy and dimension layer
Element on secondary is it is ensured that the multi-stratification of data analysiss；According to multidimensional data analysis action type, carry out the number of various ways
According to analysis, realize many sides property of data analysiss.
After getting the second data base, multi-dimensional database creates and completes, and not only stores due in multi-dimensional database
The first data base collecting in advance, and store the second data base, therefore, inquiring about in multi-dimensional database during data only need to be
Disposably accessed or simple statistics in multi-dimensional database, just can be obtained multidimensional data analysis result, it is to avoid to multiple former
Complexity on a large amount of initial datas of beginning data base, repetition, substantial amounts of data query operation and statistical operation, the system that shortens is rung
Between seasonable, improve data analysiss work efficiency, possess quick Data Analysis Services ability.
Before reading dimension data from multi-dimensional database, read initial data, then basis from raw data base
Initial data determines dimension and tolerance, and the Professional knowledge according to tcm field, determines dimension element data and dimension hierarchy
Data, can obtain dimension element code according to the first pre-conditioned unique mark determining each dimension element data afterwards
Data.Wherein, raw data base can also be saved in multi-dimensional database.
Wherein, the data in dimension data and the first data base all can be saved in raw data base, raw data base
In initial data can include ancient Chinese medicine case first foundation data, the second basic data and each basic data it
Between the 4th incidence relation, e.g., the symptom data of ancient Chinese medicine case, acupuncture points on the human body data and thorn moxibustion in raw data base, can be included
The first foundation data such as method data, the second basic data can include case title, case type, disease, author, source,
The data such as dynasty.
According to the abovementioned embodiments of the present invention, the first data carried out with Aggregation computation obtain the step of metric wrapping
Include: read standard vocabulary from standard vocabulary storehouse；First data is standardized be converted to the second number according to standard vocabulary
According to；Aggregation computation is carried out to the second data and obtains metric.
Be stored with standard vocabulary storehouse in above-described embodiment the standard vocabulary of tcm field, specifically, standard vocabulary
Basic Theories of Chinese Medicine standard vocabulary, Chinese medical disease standard vocabulary, science of acupuncture and moxibustion standard vocabulary etc. can be included.Wherein, TCM basis
Theoretical standard vocabulary with reference to China authority standard (such as: standard No. be gb/t20348-2006 " Basic Theories of Chinese Medicine term ") and
Related classical works (such as: " Basic Theories of Chinese Medicine "), Chinese medical disease standard vocabulary is with reference to China's authority's standard (such as: standard No. is
" classification of diseases and the code " of gb/t14396-1993, standard No. are " Chinese medical disease classification and the generation of gb/t15657-1995
Code ", standard No. be " the tcm clinical practice diagnosis and treatment term diseased portion " of gb/t16751.1-1997, standard No. be gb/t16751.2-
1997 " tcm clinical practice diagnosis and treatment term syndrome part ", standard No. are " the tcm clinical practice diagnosis and treatment term of gb/t16751.3-1997
Method for the treatment of part " etc.) and China's tcm field classical works (such as: " traditional Chinese medical science voluminous dictionary ", " Diagnostics of Chinese Medicine ", " tcm internal medicine
Learn " etc.), science of acupuncture and moxibustion standard vocabulary is with reference to the authoritative standard of World Health Organization (WHO) and China (such as: " the pin that World Health Organization (WHO) issues
Moxibustion acupuncture point international standard book number ", standard No. be " the acupuncture points on the human body title with positioning " of gb/t12346-2006, standard No. be 6812346-90
" through cave position " etc.) and science of acupuncture and moxibustion field classical works (such as: " science of acupuncture and moxibustion ", " science of channels and collaterals ", " science of acupuncture points ", " meridional point
Learn ", " acupuncture cave name international standard handbook ", " Chinese acupuncture and moxibustion acupuncture point lead to mirror " etc.).Additionally, standard vocabulary storehouse is additionally operable to storage mark
Contact attribute between quasi- vocabulary.For example, contact that (i.e. an acupuncture points on the human body belongs to one due to existing between acupuncture points on the human body and passages through which vital energy circulates to be subordinate to
Passages through which vital energy circulates and a passages through which vital energy circulates comprises multiple acupuncture points on the human bodys), therefore in standard vocabulary storehouse preserve acupuncture points on the human body and passages through which vital energy circulates between " affiliated passages through which vital energy circulates "
For representing the contact attribute between acupuncture points on the human body standard vocabulary and passages through which vital energy circulates standard vocabulary.Standard vocabulary storehouse is not only obtaining of initial data
Take and provide foundation, when the first data is carried out with supplement process, the contact between the standard vocabulary of storage in standard vocabulary storehouse
Attribute is also used as augmenting foundation；When the first data is standardized with conversion, the standard words of storage in standard vocabulary storehouse
Contact attribute between remittance is also used as the conversion foundation of standardization conversion.
Specifically, the incidence relation between the standard vocabulary in establishing criteria lexicon and standard vocabulary is to the first data
In Non-Normalized Data carry out data conversion, obtain the second data.For example, in the first data, the data value of acupuncture points on the human body may be deposited
In the form of another name, this is accomplished by, according to the standard vocabulary of acupuncture points on the human body title, another name is converted to title.
In the above embodiment of the present invention, extracting first data set corresponding with dimension data from the first data base
After conjunction, method may include that detection the first data integrity degree whether meet first threshold, the first data integrity degree not
In the case of meeting first threshold, the first data is deleted or supplement is processed the first data acquisition system after being cleared up；Or
Detect in the first data acquisition system and whether there is second data consistent with the first data exist and first in the first data acquisition system
In the case of the second consistent data of data, delete the second data, the first data acquisition system after being cleared up.
According to the abovementioned embodiments of the present invention, the first data is deleted or supplement is processed the first number after being cleared up
May include that according to the step of set and extract description data from dimension data；Using description data, the first data is augmented
Process, the first data acquisition system so that the integrity degree of the first data meets first threshold, after being cleared up.
Specifically, the detection in the above embodiment of the present invention, to the first data in the first data acquisition system, i.e. foundation
Whether the data value mistake in the first data and loss situation, data value are by multiple row storage conditions, data row design data
The Data Detection that value setting situation is carried out.Specific to traditional Chinese medical science case field, do not meet first threshold in the integrity degree of the first data
In the case of, whether the integrity degree of detection the first data is less than Second Threshold, is not less than the second threshold in the integrity degree of the first data
In the case of value, according to the contact attribute between the dimension element data of disappearance and standard vocabulary in the first data to the first data
Carry out data supplement, the first data acquisition system after being cleared up；In the case that the integrity degree of the first number pick is less than Second Threshold,
Delete the first data, the first data acquisition system after being cleared up.
In the above-described embodiments, in view of there may be in raw data base that data value is lack of standardization, data value mistake and losing
Whether mistake, data value design many situations such as data value setting by multiple row storages, data row, and then affect data statisticss knot
The accuracy of fruit, there is likely to be the situation lacking dimension data, and then affects multidimensional data analysis in original data source
Feasibility, the above embodiment of the present invention carries out to the first data deleting, augments process to clear up to the first data acquisition system
The first data acquisition system after being cleared up, thus avoiding above-mentioned situation, thus ensure that the Feasible degree of multidimensional data analysis, carries
Rise the accuracy of data results.
In the above embodiment of the present invention, dimension data may include that dimension element data, dimension element code data
And the second incidence relation between dimension element data and dimension element code data, wherein, set up metric and number of dimensions
According between the first incidence relation generate the step of the second data base and may include that and set up metric and dimension element code data
Between the 3rd incidence relation；First incidence relation is set up by metric and the second incidence relation；Preserve dimension data, tolerance
Value, the first incidence relation and the 3rd incidence relation, to generate the second data base.
In the above embodiment of the present invention, generate the setting up the first incidence relation between metric and dimension data
After two data bases, said method can also include: the first multidimensional data analysis request of receive user；By the first multidimensional data
Analysis request is converted into the second multidimensional data analysis request；It is right with the second multidimensional data analysis request to obtain from the second data base
The result data collection answered；Output result data set.
Specifically, after the first multidimensional data analysis request receiving user by receiver module 170, the of system
One modular converter 190 can make requests on according to the first multidimensional data analysis request and be converted to the second multidimensional data analysis request,
Wherein, according to first multidimensional data analysis request make requests on conversion include to first multidimensional data analysis request carry out data please
Ask and classify and generate query statement or directly generate query statement, then pass through the 6th processing module 210 from the second data base
Obtain and ask corresponding result data collection with the second multidimensional data analysis, then the pick of this number of results is exported by output module 230
Collection.Wherein, output module 230 can be in the way of according to user's request display result data collection in the second multidimensional data analysis request
Show this result data collection, wherein it is possible to result data collection is converted to by visualization data by the second modular converter, and pass through
Result data collection is shown by display module.Wherein, receiver module 170 and output module 230 may be located on the front end of system
On server；The mode of display result data collection includes: tables of data display format and graphic display form.
As shown in figure 4, execution step s202: the first multidimensional data analysis request of receive user.Specifically, user is permissible
By input equipment input the first multidimensional data analysis request, wherein, the first multidimensional data analysis request can include dimension, dimension
Element on degree order, dimension hierarchy, dimension hierarchy and tolerance.For example, for " the Gu of the crooked mouth and tongue symptom for the treatment of apoplexy
Use frequency for acupuncture case in the acupuncture points on the human body in decent and eight extra-channel " analysis request, user can carry out in the input of system
Disease dimension and passages through which vital energy circulates dimension, " disease → passages through which vital energy circulates " dimension order, " apoplexy " element on the disease layer in disease dimension
" crooked mouth and tongue " element on all elements (i.e. all syndromes of apoplexy) → msq layer on → syndrome layer, in passages through which vital energy circulates dimension
In two grades of levels on " decent " and the selection operation measured of " eight extra-channel " element and " acupuncture points on the human body uses frequency ", and then generate machine
The first multidimensional data analysis request that device can identify, analysis result is with reference to shown in table 1.
Table 1
After receiving the first multidimensional data analysis request, can be with execution step s204: by the first modular converter 190
First multidimensional data analysis request is converted into the second multidimensional data analysis request.Specifically, if the first multidimensional data analysis
Request is the further analysis request being formed based on existing analysis result, then according to multidimensional data analysis action type to first
Multidimensional data analysis request is classified and is generated query statement, otherwise directly generates query statement；According to multidimensional data analysis
Action type is effectively classified and is generated query statement to the first multidimensional data analysis request, simplifies data analysis request
Complexity, shorten the execution time of data analysis request, and then improve the treatment effeciency of data analysiss.
The initial data in raw data base in the above-described embodiments so can be can ensure that based on former with real-time update
The analysis operation of the same data in beginning data base will not obtain successively different results, thus ensure that data results
Concordance.Additionally, the invention provides Analysis Service and foreground service technology scheme, can easily generate data analysis request
Require with presentation of information, after receiving the first multidimensional data analysis request, by the first modular converter 190 to multidimensional data
Analysis request and existing analysis result carry out flexibly intuitively data manipulation, and generate further data analysis request,
Reduce the complexity that the first multidimensional data analysis ask generating process, realize polytype data analysis operation, obtain more
For analysis result interested, and object information is shown with visual and understandable form, and then improve the interactivity of data analysiss.
In the above-described embodiments, according to multidimensional data analysis action type, the first multidimensional data analysis request is carried out effectively
During classifying and generate query statement in ground, multidimensional data analysis action type includes: lower brill, upper volume, section, stripping and slicing and rotation
Turn；Higher level is turned by lower boring for increasing the logical structure relation between the dimension hierarchy in number of dimensions or foundation specific dimension
It is changed into lower level, obtain detailed metric；Upper volume be reduce number of dimensions or according to the dimension hierarchy in specific dimension it
Between logical structure relation lower level is changed into higher level, obtain rough metric；Section is one or more
Under concrete element in dimension limits, obtain the metric in other dimensions；Stripping and slicing is the element in one or more dimensions
Under interval restriction, obtain the metric in other dimensions；Rotate to be the sequence changing between dimension, obtain new metric.
Specifically, the first modular converter 190 can carry out deep analysis to existing analysis result, generate further and divide
The second multidimensional data analysis request after analysis；For example, referring to shown in table 1, user can click " decent " aobvious in this tables of data
Show region, generate the second multidimensional data analysis request, for obtaining the next stage dimension layer in residing dimension hierarchy for the decent element
The metric corresponding to all elements (i.e. " yang channel " and " yin channel ") on secondary, analysis result is with reference to shown in table 2.
Table 2
In addition, there may be filiation, if the dimension belonging to an element between element on different dimensions level
Level comprises next stage level and this element exists and another element itself having logical relation on next stage level, front
Person is referred to as father's element of the latter, and the latter is referred to as the former daughter element, and father's element can comprise multiple daughter elements, a son
Element can only be under the jurisdiction of father's element；Shown in reference table 1, before " decent " "+" identify for representing according to this element institute
Logical structure relation between the dimension hierarchy in dimension belonging to, the dimension hierarchy belonging to this element comprises next stage level and is somebody's turn to do
Element comprises daughter element on next stage level and existing analysis result not yet shows that this element institute on next stage level is right
The concrete condition of the daughter element answered, user can carry out drill down operator on this element；Conversely, "-" identifies for representing user
Volume operation on can carrying out on this element；Additionally, there is no above-mentioned mark before element for representing the dimension belonging to this element
Level does not comprise next stage dimension hierarchy or this element and does not comprise daughter element on next stage dimension hierarchy.
After obtaining analysis result (namely obtaining result data collection), export analysis result (i.e. result data collection).Point
Analysis result the way of output can by according to user demand have different in the way of.For example, it may be tables of data, block diagram, cake
The much information way of output such as shape figure.
The step executing the second multidimensional data analysis request includes: obtains from the second data base and divides with the second multidimensional data
Corresponding multidimensional data is asked in analysis, and forms result data collection.Specific step is as follows:
Specifically, multidimensional data analysis action type includes volume, lower brill, section, stripping and slicing and five kinds of operations of rotation, example
As, with reference to shown in table 2, " decent " viewing area that user can click in this table is asked with inputting the first multidimensional data analysis,
Due to the dimension data being designated "-", then showing to have analyzed with respect to decent lower level before " decent ", then may be used
So that new metric (as shown in table 1) is obtained by the operation of upper volume, and then metric distribution situation is obtained from less level；
On this, the process that implements of volume operation is: the data on the gauge region row corresponding to this viewing area is collected, raw
After the metric of Cheng Xin, carry out the adjustment of tables of data, form and show new analysis result data table, as shown in table 1；Above-mentioned
Process, without the inquiry operation in multi-dimensional database, improves treatment effeciency；Additionally, drill down operator is the inverse mistake of upper volume operation
Journey.
Further, user can add dynasty dimension, obtains more detailed metric by drill down operator, if that is,
One-level level in dynasty dimension comprises " before bright " and " after bright " two elements, and (wherein, " after bright " element includes the Ming Dynasty, this division
Foundation is: the Ming Dynasty is the period of maturation of ancient times acupuncture case development), then can on the basis of existing data analysiss further
Obtain " before bright " and the metric distribution situation of " after bright ", and then obtain metric distribution situation from more angles, deeply
Solution " the ancient times acupuncture case for the treatment of crooked mouth and tongue symptom uses frequency in seriously and in eight extra-channel, the acupuncture points on the human body after bright front and bright "
Situation, obtains interested, more rich result.
More specifically, user can also adjust passages through which vital energy circulates dimension data and the sequencing of dynasty dimension data, by rotation
Operation obtains new metric, that is, understand in depth " the ancient times acupuncture case for the treatment of crooked mouth and tongue symptom after bright front and bright,
Acupuncture points on the human body seriously and in eight extra-channel uses frequency " situation, and then obtain metric distribution situation from new side.
Step s206: obtain from the second data base and ask corresponding result data collection with the second multidimensional data analysis.
Specifically, execution is above-mentioned is being converted into the second multidimensional data analysis request generation by the first multidimensional data analysis request
Query statement, and generate result data collection.Wherein, link with the second Database first, afterwards according to looking in sentence
Inquiry condition, is disposably inquired about or simple statistics in the second data base, generates result data collection.
Wherein, the query statement that the first multidimensional data analysis request changes into may need to carry out letter in the second data base
Single collect statistics；As a example analysis request involved by by table 1, the center table of the second data base stores the disease in disease dimension
" apoplexy " element, this element concrete syndrome daughter element, above-mentioned syndrome daughter element " mouth on msq layer on syndrome layer on sick layer
Wry tongue is oblique " " acupuncture points on the human body uses frequency " metric of daughter element, if executing the query statement of this request, need in the second data base
Middle " the acupoint inquiring about and collect " the syndrome daughter element that apoplexy element is comprised, and this daughter element comprises crooked mouth and tongue daughter element "
Cave uses frequency " metric, and then generate result data collection.
Step s208, output result data set.Specifically, can receive and show the result data in above-described embodiment
Collection, is converted into visual information, and shows user by display device.
Fig. 5 is the schematic flow sheet of the creation method of the initial multi-dimensional database according to embodiment illustrated in fig. 3.According to Fig. 5
Shown embodiment, specifically comprises the following steps that
Step s302, according to the second pre-conditioned explicit data analytic angle and observation index, to determine dimension and tolerance.
Specifically, for example, acupuncture points on the human body is the core data of acupuncture case, and case data analysiss often need observation acupuncture points on the human body to use feelings
Condition, acupuncture points on the human body service condition can include acupuncture points on the human body frequency of usage and frequency；Additionally, case data analysiss can be from symptom, passages through which vital energy circulates, people
Body branch, therapy, dynasty angularly to observe acupuncture points on the human body service condition, and then obtain the rule hidden in case；Therefore, dimension can
To be defined as: dynasty, passages through which vital energy circulates, division of human body, therapy and five dimensions of disease, tolerance can determine as: acupuncture points on the human body frequency of usage and
Acupuncture points on the human body usage frequency, such that it is able to obtain metric according to above-mentioned multiple dimensions, realizes the case data analysiss of multi-angle.Separately
Outward, because specific acupoint is that have special treatment effect the acupuncture points on the human body by the classification of specific title, have in the clinical practice of the science of acupuncture and moxibustion
Particularly important meaning；Therefore, specific acupoint has prominent value using frequency and usage frequency, also should be set as many dimensions
Tolerance according to storehouse.
Step s304, obtains the dimension element on dimension hierarchy and dimension hierarchy.Specifically, special according to tcm field
Industry knowledge, determines the element on dimension hierarchy and dimension hierarchy.For example, according to tcm field knowledge, passages through which vital energy circulates dimension can be wrapped
Include top time (i.e. passages through which vital energy circulates itself can be described as all), one-level level (including decent and two elements of eight extra-channel), two grades of levels
(such as: the decent element in upper level level includes yin channel and two daughter elements of yang channel on this level), tertiary level (such as: on
Yin channel element in one-level level includes the Three Yin channels of hand and two daughter elements of Three Yin Channels of Foot on this level), level Four level (such as:
Three Yin channels of hand element in upper level level includes meridian of Hand-TAI YIN, meridian of Hand-SHAO YIN and three son units of meridian of Hand-JUE YIN on this level
Element) and Pyatyi level is (such as: the meridian of Hand-TAI YIN in upper level level includes the acupoints such as zhongfu point, Yunmen cave, self-sufficient and strategically located region cave on this level
Cave daughter element).
According to above-described embodiment: by passages through which vital energy circulates dimension top time to lowest level, the description journey to passages through which vital energy circulates dimension
Degree becomes more and more thinner；Conversely, description degree becomes more and more thicker.User can be according to passages through which vital energy circulates dimension, with " whole one decent one
Yin channel one Three Yin channels of hand proficiency Taiyin channels one zhongfu point " is analysis path, progressively obtains more and more thinner or increasingly thicker tolerance
Value, and then realize multi-level data analysiss.In addition, there is notional logical structure relation between dimension hierarchy, that is, from
An element on the angle upper level dimension hierarchy of concept may comprise the one or more son units on next stage dimension hierarchy
Element, conversely, an element on next stage dimension hierarchy is under the jurisdiction of some the father's element on upper level dimension hierarchy, such as:
Conceptive, yang channel element comprises the three Yang channels of hand and two elements of the three yang channels of foots, conversely, three Yang channels of hand element is under the jurisdiction of yang channel unit
Element.
Step s306, using first pre-conditioned dimension element is entered line codeization process, obtain dimension element code number
According to.
Step s308, generates dimension table according to dimension element code data and dimension element.
Step s310, generates center table according to dimension element code data and metric data.Specifically, one can be formed
The empty table of center table is it is also possible to store complete dimension data known to some and metric in the table of center.
Step s312, dimension table and center table are saved as multi-dimensional database.
Specifically, after execution step s312, the data in raw data base can also be imported multi-dimensional database, with
And subsequently can execute the operation the second data base being saved in multi-dimensional database.
It should be noted that the step that illustrates of flow process in accompanying drawing can be in such as one group of computer executable instructions
Execute in computer system, and although showing logical order in flow charts, but in some cases, can be with not
It is same as the step shown or described by order execution herein.
As can be seen from the above description, present invention achieves following technique effect: obtain dimension data first, so
First data acquisition system corresponding with dimension data is extracted afterwards from the first data base, and to the first number in the first data acquisition system
According to carrying out after Aggregation computation obtains metric, setting up the first incidence relation between metric and dimension data and generating the second number
According to storehouse, the first data acquisition system can be obtained by dimension data, after obtaining metric according to the first data acquisition system, set up
The first incidence relation between metric and dimension data, generates the second data base by the first incidence relation, closes by first
Connection relation imports metric to generate the second data base, and then provides data source that is accurate, being suitable for for multidimensional data analysis, from
And solve because existing ancient Chinese medicine medical case database is imperfect and data is unordered, thus lead to using existing case data
The result of library inquiry data is inaccurate, inefficiency, and cannot realize the problem of increasingly complex inquiry it is achieved that quick and precisely
Set up the effect of complete ancient Chinese medicine medical case database, during user's inquiry ancient Chinese medicine case data, directly from the second number
Inquire about according in storehouse, can be with the complete Query Result of direct access, it is quick, accurate to inquire about, efficiency high.
Obviously, those skilled in the art should be understood that each module of the above-mentioned present invention or each step can be with general
Computing device realizing, they can concentrate on single computing device, or be distributed in multiple computing devices and formed
Network on, alternatively, they can be realized with the executable program code of computing device, it is thus possible to they are stored
To be executed by computing device in the storage device, or they be fabricated to each integrated circuit modules respectively, or by they
In multiple modules or step be fabricated to single integrated circuit module to realize.So, the present invention be not restricted to any specific
Hardware and software combines.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, made any repair
Change, equivalent, improvement etc., should be included within the scope of the present invention.
Claims (7)
1. a kind of data processing method is it is characterised in that be applied to the process of ancient Chinese medicine case data, comprising:
Obtain dimension data；
First data acquisition system corresponding with described dimension data, wherein, described first data acquisition system is extracted from the first data base
Including the first data；
Aggregation computation is carried out to described first data and obtains metric, wherein, metric is included according to multiple data analysiss angles
Observation index value；
The first incidence relation set up between described metric and described dimension data generates the second data base,
Wherein, after extracting first data acquisition system corresponding with described dimension data from the first data base, at described data
Reason method includes: detect described first data integrity degree whether meet first threshold, described first data integrity degree not
In the case of meeting described first threshold, described first data is deleted or supplement is processed the first data after being cleared up
Set；Or detect with the presence or absence of threeth data consistent with described first data in described first data acquisition system, described first
In the case of there is described 3rd data in data acquisition system, delete described 3rd data, obtain the first data after described cleaning
Set；
Wherein, described first data is deleted or the step of the first data acquisition system that supplement is processed after being cleared up is included:
Description data is extracted from described dimension data；Using described description data, supplement process is carried out to described first data, so that
The integrity degree obtaining described first data meets described first threshold, obtains the first data acquisition system after described cleaning；
Wherein, after getting described second data base, multi-dimensional database creates and completes, and described multi-dimensional database stores institute
State the first data base and described second data base.
2. data processing method according to claim 1 obtains it is characterised in that carrying out Aggregation computation to described first data
Step to metric includes:
Standard vocabulary is read from standard vocabulary storehouse；
According to described standard vocabulary, described first data is standardized being converted to the second data；
Aggregation computation is carried out to described second data and obtains metric.
3. data processing method according to claim 1 is it is characterised in that described dimension data includes: dimension element number
Associate according to second between, dimension element code data and described dimension element data and described dimension element code data
System, wherein, sets up the step bag that the first incidence relation between described metric and described dimension data generates the second data base
Include:
Set up the 3rd incidence relation between described metric and described dimension element code data；
Described first incidence relation is set up by described metric and described second incidence relation；
Preserve described dimension data, described metric, described first incidence relation and described 3rd incidence relation, described to generate
Second data base.
4. data processing method according to claim 1 is it is characterised in that setting up described metric and described number of dimensions
According between first incidence relation generate the second data base after, described data processing method also includes:
First multidimensional data analysis request of receive user；
Described first multidimensional data analysis request is converted into the second multidimensional data analysis request；
Obtain from described second data base and ask corresponding result data collection with described second multidimensional data analysis；
Export described result data collection.
5. a kind of data processing equipment is it is characterised in that include:
Acquisition module, for obtaining dimension data；
First extraction module, for extracting first data acquisition system corresponding with described dimension data from the first data base；
Computing module, obtains metric for carrying out Aggregation computation to the first data in described first data acquisition system；
First processing module, generates the second number for setting up the first incidence relation between described metric and described dimension data
According to storehouse,
Wherein, described data processing equipment also includes: first detection module, for detect described first data integrity degree whether
Meet first threshold；3rd processing module, does not meet the situation of described first threshold for the integrity degree in described first data
Under, described first data is deleted or supplement is processed the first data acquisition system after being cleared up；Second detection module, is used for
Detect and in described first data acquisition system, whether there is threeth data consistent with described first data；Fourth processing module, is used for
In the case of there is described 3rd data in described first data acquisition system, delete described 3rd data, after obtaining described cleaning
The first data acquisition system；
Wherein, described 3rd processing module includes: the second extraction module, for extracting description data from described dimension data；
5th processing module, for supplement process being carried out to described first data using described description data, so that described first number
According to integrity degree meet described first threshold, obtain described cleaning after the first data acquisition system；
Wherein, after getting described second data base, multi-dimensional database creates and completes, and described multi-dimensional database stores institute
State the first data base and described second data base.
6. data processing equipment according to claim 5 is it is characterised in that described computing module includes:
First read module, for reading standard vocabulary from standard vocabulary storehouse；
Second processing module, for being standardized to described first data being converted to the second number according to described standard vocabulary
According to；
First sub- computing module, obtains metric for carrying out Aggregation computation to described second data.
7. data processing equipment according to claim 5 is it is characterised in that described dimension data includes: dimension element number
Associate according to second between, dimension element code data and described dimension element data and described dimension element code data
System, wherein, described first processing module includes:
First subprocessing module, associates for setting up the between described metric and described dimension element code data the 3rd
System；
Second subprocessing module, for setting up described first incidence relation by described metric and described second incidence relation；
3rd subprocessing module, for preserving described dimension data, described metric, described first incidence relation and the described 3rd
Incidence relation, to generate described second data base.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310213824.2A CN103258054B (en) | 2013-05-31 | 2013-05-31 | Method and device for processing data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310213824.2A CN103258054B (en) | 2013-05-31 | 2013-05-31 | Method and device for processing data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103258054A CN103258054A (en) | 2013-08-21 |
| CN103258054B true CN103258054B (en) | 2017-01-25 |
Family
ID=48961971
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310213824.2A Expired - Fee Related CN103258054B (en) | 2013-05-31 | 2013-05-31 | Method and device for processing data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103258054B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103440333A (en) * | 2013-09-05 | 2013-12-11 | 深圳好视网络科技有限公司 | Data processing method and device |
| CN103870712A (en) * | 2014-03-31 | 2014-06-18 | 张东升 | Traditional Chinese medicine knowledge data intelligent response method and device |
| CN105224534A (en) * | 2014-05-29 | 2016-01-06 | 腾讯科技（深圳）有限公司 | A kind of method and device of asking response |
| CN104166738A (en) * | 2014-09-04 | 2014-11-26 | 北京国双科技有限公司 | Database query processing method and device |
| CN104182546B (en) * | 2014-09-09 | 2017-10-27 | 北京国双科技有限公司 | The data query method and device of database |
| CN107767155B (en) * | 2016-08-18 | 2021-06-18 | 腾讯科技（深圳）有限公司 | Method and system for evaluating user portrait data |
| CN107861996A (en) * | 2017-10-16 | 2018-03-30 | 中国医学科学院医学信息研究所 | A kind of medicine evidence-based database Diagrams automatic creation system |
| CN116991901A (en) * | 2023-09-25 | 2023-11-03 | 深圳市秦丝科技有限公司 | Data control system and method based on multidimensional database query |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599088A (en) * | 2008-11-18 | 2009-12-09 | 北京美智医疗科技有限公司 | The mining multi-dimensional data system and method for medical information system |
-
2013
- 2013-05-31 CN CN201310213824.2A patent/CN103258054B/en not_active Expired - Fee Related
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599088A (en) * | 2008-11-18 | 2009-12-09 | 北京美智医疗科技有限公司 | The mining multi-dimensional data system and method for medical information system |
Non-Patent Citations (2)
| Title |
|---|
| 基于数据库技术的古代中医治疗数据采集方法的研究;李丹等;《中医药学报》;20121220;第40卷(第6期);全文 * |
| 重复和不完整数据的清理方法研究及应用;鲁均云;《中国优秀硕士学位论文全文数据库 信息科技辑》;20100715;第2010年卷(第07期);第24-25页，第51页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103258054A (en) | 2013-08-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103258054B (en) | Method and device for processing data | |
| CN107145511A (en) | Structured medical data library generating method and system based on medical science text message | |
| CN106933994B (en) | Traditional Chinese medicine knowledge graph-based core disease and syndrome relation construction method | |
| CN107346369A (en) | A kind of medical information processing method and device | |
| CN104207931B (en) | Face facial point precise positioning and acupuncture and moxibustion prescription, acumoxibustion prescription learning method | |
| CN107833595A (en) | Medical big data multicenter integration platform and method | |
| CN107169078A (en) | Knowledge of TCM collection of illustrative plates and its method for building up and computer system | |
| CN107066814A (en) | A kind of traditional Chinese medical science intelligent auxiliary diagnosis system cooperateed with based on the four methods of diagnosis | |
| CN106803012B (en) | Prescription function prediction method based on probability topic model and Chinese medicine essential attribute | |
| CN106933985B (en) | Analysis and discovery method of core party | |
| Jiang et al. | Using link topic model to analyze traditional Chinese medicine clinical symptom-herb regularities | |
| CN106909572A (en) | A kind of construction method and device of question and answer knowledge base | |
| CN103366394A (en) | Direct volume rendering method for abstracting features of medical volume data | |
| CN111599433B (en) | Auxiliary prescription method and device for medicinal materials, storage medium and terminal | |
| CN109086397A (en) | Dynamic report generation method based on inquiry dimension | |
| CN117711611B (en) | MDT remote consultation system and method based on scene fusion and mr | |
| Li et al. | Wound segmentation network based on location information enhancement | |
| CN104933026A (en) | Method for automatically extracting knowledge in the field of traditional Chinese medicine acupuncture and moxibustion | |
| CN111312363B (en) | Double-hand coordination enhancement system based on virtual reality | |
| Wu et al. | Visualization of Traditional Chinese Medicine formulas: development and usability study | |
| CN112233804B (en) | Intelligent recommendation method for warp and equipment applying method | |
| CN107658024A (en) | Suggestion method for pushing based on theory of traditional Chinese medical science | |
| CN109086396A (en) | Endowment big data analysis platform | |
| CN115019388A (en) | Full-automatic gait analysis method for shooting gait video by using monocular camera | |
| CN114446488A (en) | Traditional Chinese medicine prescription identification method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C53 | Correction of patent for invention or patent application | ||
| CB03 | Change of inventor or designer information |
Inventor after: Yan Chaosheng Inventor after: Li Dan Inventor after: Zheng Nan Inventor after: Sun Zhongren Inventor after: Yan Chaoqi Inventor after: Jiang Deyou Inventor before: Yan Chaosheng Inventor before: Li Dan Inventor before: Sun Zhongren Inventor before: Yan Chaoqi Inventor before: Jiang Deyou |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: INVENTOR; FROM: YAN CHAOSHENG LI DAN SUN ZHONGREN YAN CHAOQI JIANG DEYOU TO: YAN CHAOSHENG LI DAN ZHENG NAN SUN ZHONGREN YAN CHAOQI JIANG DEYOU |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170125 Termination date: 20180531 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |