CN109739940A - On-line analytical processing method, apparatus, storage medium and electronic equipment - Google Patents
On-line analytical processing method, apparatus, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN109739940A CN109739940A CN201811638962.4A CN201811638962A CN109739940A CN 109739940 A CN109739940 A CN 109739940A CN 201811638962 A CN201811638962 A CN 201811638962A CN 109739940 A CN109739940 A CN 109739940A
- Authority
- CN
- China
- Prior art keywords
- dimension
- data
- analysis chart
- instruction
- data table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
This disclosure relates to a kind of on-line analytical processing method, apparatus, storage medium and electronic equipment, which comprises according to the first dimension and metrics query raw data table, obtain the first data corresponding with the first dimension and the measurement;According to the first data, analysis chart is generated;Drill through instruction for the target dimension attribute in present analysis chart in response to receiving, in the corresponding dimension hierarchy relationship of the raw data table, according to it is described drill through instruction level locating for the current dimension drilled through, the second dimension of acquisition;According to raw data table described in the second dimension and the metrics query, the second data corresponding with the second dimension and the measurement are obtained;According to the second data, new analysis chart is generated.Therefore, the analyzable dimension of on-line analytical processing method and measurement can be effectively widened, when carrying out on-line analysis, without pre-establishing cube, so as to improve the efficiency of on-line analysis, reduces complexity, and update easy to maintain.
Description
Technical field
This disclosure relates to data processing field, and in particular, to a kind of on-line analytical processing method, apparatus, storage medium
And electronic equipment.
Background technique
On-line analytical processing (OLAP) is a kind of Data Analysis Services technology, it enables analysis personnel unanimously, alternatively
Observed information in all its bearings, to achieve the purpose that deep to understand data.
OLAP is more common in traditional commerce intelligence (BI) analysis tool, traditional BI analysis tool, mostly uses that establish data vertical
The mode of cube (cube) carries out data modeling, however needs to analyze entire business scenario when creation cube, and setting is solid
Hierarchical relationship between fixed dimension and measurement and dimension later deposits data corresponding with the dimension and measurement in database
It stores up to cube.It is then based on dimension fixed in cube, metric carries out olap analysis.It will cause analyzable dimension in this way
And the hierarchical relationship between dimension is fixed, when business demand change needs to analyze new dimension, which is not applied for newly
The analysis of business demand is unable to satisfy the flexible drilling analysis demand of business;In addition, the period for establishing cube is long, change is difficult,
The low efficiency of analysis.
Summary of the invention
To solve the above-mentioned problems, neatly on-line analytical processing method, dress are analyzed purpose of this disclosure is to provide a kind of
It sets, storage medium and electronic equipment.
To achieve the goals above, according to the disclosure in a first aspect, providing a kind of on-line analytical processing method, the side
Method includes:
According to the first dimension and metrics query raw data table, corresponding with first dimension and the measurement the is obtained
One data;
According to first data, analysis chart is generated;
Instruction is drilled through for the target dimension attribute in present analysis chart in response to what is received, in the original number
According in the corresponding dimension hierarchy relationship of table, according to it is described drill through instruction level locating for the current dimension drilled through, obtain
Second dimension, the current dimension are dimension belonging to the target dimension attribute;
According to raw data table described in second dimension and the metrics query, obtain and second dimension and described
Measure corresponding second data;
According to second data, new analysis chart is generated.
Optionally, this method further include: when it is described to drill through instruction be that lower brills instructs when, according to the target dimension attribute,
Generate data filtering condition;And
The raw data table according to second dimension and the metrics query, obtain with second dimension and
The step of measurement corresponding second data are as follows:
The raw data table is inquired according to second dimension, the measurement and the data filtering condition, is obtained
Under second dimension, the second data corresponding with the target dimension attribute and the measurement.
Optionally, described according to first data, after generating the step of analyzing chart, this method further include:
It is described in the analysis chart of generation if first dimension is present in the dimension hierarchy relationship
Each dimensional attribute association of first dimension drills through control, described to drill through control and described drill through instruction for receiving.
Optionally, this method further include:
If first dimension is not present in the dimension hierarchy relationship, according to first dimension, described in update
Dimension hierarchy relationship.
Optionally, described according to second data, after the step of generating new analysis chart, this method is also wrapped
It includes:
It is that each dimensional attribute of second dimension is associated with and drills through control in the new analysis chart of generation, it is described
It drills through control and described drills through instruction for receiving.
Optionally, the dimension hierarchy relationship is stored using the storage form of non-data cube.
Optionally, described the step of generating new analysis chart are as follows:
Generate new analysis chart with instead previous existence at analysis chart.
According to the second aspect of the disclosure, a kind of on-line analytical processing device is provided, described device includes:
First enquiry module, for obtaining and first dimension according to the first dimension and metrics query raw data table
Corresponding first data with the measurement;
First generation module, for generating analysis chart according to first data;
Module is drilled through, for drilling through finger for the target dimension attribute in present analysis chart in response to what is received
Enable, in the corresponding dimension hierarchy relationship of the raw data table, according to it is described drill through instruction from current dimension locating for level open
Beginning is drilled through, and the second dimension is obtained, and the current dimension is dimension belonging to the target dimension attribute;
Second enquiry module, be used for the raw data table according to second dimension and the metrics query, obtain with
Second dimension and corresponding second data of the measurement;
Second generation module, for generating new analysis chart according to second data.
Optionally, the device further include:
Third generation module, for when it is described to drill through instruction be the instruction of lower brills when, according to the target dimension attribute, generation
Data filtering condition;And
Second enquiry module is used for:
The raw data table is inquired according to second dimension, the measurement and the data filtering condition, is obtained
Under second dimension, the second data corresponding with the target dimension attribute and the measurement.
Optionally, the device further include:
First relating module, for, according to first data, being generated after analyzing chart in first generation module,
It is first dimension in the analysis chart of generation if first dimension is present in the dimension hierarchy relationship
The association of each dimensional attribute drill through control, it is described to drill through control and described drill through instruction for receiving.
Optionally, the device further include:
Update module, for when first dimension is not present in the dimension hierarchy relationship, then according to described
Dimension updates the dimension hierarchy relationship.
Optionally, the device further include:
Second relating module, for, according to first data, being generated after analyzing chart in first generation module,
It is that each dimensional attribute of second dimension is associated with and drills through control in the new analysis chart of generation, it is described to drill through control
Described instruction is drilled through for receiving.
Optionally, the dimension hierarchy relationship is stored using the storage form of non-data cube.
Optionally, second generation module generates new analysis chart are as follows:
Generate new analysis chart with instead previous existence at analysis chart.
According to the third aspect of the disclosure, a kind of computer readable storage medium is provided, computer program is stored thereon with,
The program realizes the step of above-mentioned first aspect any the method when being executed by processor.
According to the fourth aspect of the disclosure, a kind of electronic equipment is provided, comprising:
Memory is stored thereon with computer program;
Processor, for executing the computer program in the memory, to realize any institute of above-mentioned first aspect
The step of stating method.
In the above-mentioned technical solutions, number corresponding with the first dimension and measurement can be obtained directly from raw data table
According to generate analysis chart.Therefore, even if business scenario changes, raw data table is caused to change, it can also be real
Now to the on-line analysis of any dimension of the raw data table after variation, avoid occurring in the prior art, being analyzed due to this
The case where can not carrying out on-line analysis to it in the cube that first dimension is established before not existing in.In this way, can effectively open up
The analyzable dimension of wide on-line analytical processing method and measurement, are bonded user's use demands, improve on-line analytical processing method
It is applicable in scene domain.By technical solution provided by the present disclosure, when carrying out on-line analysis, without pre-establishing cube, thus
The efficiency of on-line analysis can be improved, reduce complexity, and update easy to maintain.
Other feature and advantage of the disclosure will the following detailed description will be given in the detailed implementation section.
Detailed description of the invention
Attached drawing is and to constitute part of specification for providing further understanding of the disclosure, with following tool
Body embodiment is used to explain the disclosure together, but does not constitute the limitation to the disclosure.In the accompanying drawings:
Fig. 1 is the flow chart of the on-line analytical processing method provided according to an embodiment of the present disclosure;
Fig. 2 is the schematic diagram of display interface;
Fig. 3 is the block diagram of the on-line analytical processing device provided according to an embodiment of the present disclosure;
Fig. 4 is the block diagram of a kind of electronic equipment shown according to an exemplary embodiment;
Fig. 5 is the block diagram of a kind of electronic equipment shown according to an exemplary embodiment.
Specific embodiment
It is described in detail below in conjunction with specific embodiment of the attached drawing to the disclosure.It should be understood that this place is retouched
The specific embodiment stated is only used for describing and explaining the disclosure, is not limited to the disclosure.
On-line analytical processing method according to the exemplary embodiment of the disclosure can be applied to the intellectual analysis of various data,
After intellectual analysis, it can be shown by way of chart (such as histogram, cake chart etc.) to user according to the demand of user
User it is expected the data understood.
In on-line analytical processing method according to the exemplary embodiment of the disclosure, dimension refers to the angle of display data
It spends, value is nonnumeric field in corresponding data table;Measurement refers to the quantitative value of displaying, i.e., value is number in corresponding data table
The field of value.As an example, dimension may include area, province, city, pin when the data of analysis are the sales data of product
Sell time, sale month etc..
Shown in Fig. 1, for the flow chart of the on-line analytical processing method provided according to an embodiment of the present disclosure, such as scheme
Shown in 1, which comprises
In S11, according to the first dimension and metrics query raw data table, corresponding with the first dimension and measurement the is obtained
One data.
Wherein, which may include one or more tables of data.First dimension can be in raw data table
Any dimension, measurement can be any measurement in raw data table.Whole needed for being stored with analysis in raw data table
Data can then obtain corresponding with the first dimension and measurement when determining the first dimension and measurement from raw data table
Data.
In S12, according to the first data, analysis chart is generated.
In S13, instruction is drilled through for the target dimension attribute in present analysis chart in response to what is received, in original
In the corresponding dimension hierarchy relationship of beginning tables of data, is drilled through, obtained according to drilling through instruction level locating for the current dimension
Second dimension, the current dimension are dimension belonging to the target dimension attribute.
Wherein, dimensional attribute indicates that the value of dimension, analysis chart as shown in Figure 2, corresponding dimension are province, then
Shandong, Jiangsu etc. are the dimensional attribute of the dimension.The corresponding dimension hierarchy relationship of raw data table is used to indicate raw data table
In multiple dimensions between hierarchical relationship, the dimension hierarchy relationship can be used for characterize data analysis granularity.Illustratively, original
When the corresponding dimension hierarchy relationship of tables of data is area-province-city, next level in area is indicated for province, under province
One level is city.Wherein, the analysis granularity of next level is thinner compared to the analysis granularity of current level.
In S14, according to the second dimension and metrics query raw data table, corresponding with the second dimension and measurement the is obtained
Two data.
In S15, according to the second data, new analysis chart is generated.
Wherein, which can be histogram, pie chart etc., and the side of analysis chart is generated according to the data that inquiry obtains
Formula is the prior art, and details are not described herein.
In the above-mentioned technical solutions, number corresponding with the first dimension and measurement can be obtained directly from raw data table
According to generate analysis chart.Therefore, even if business scenario changes, raw data table is caused to change, it can also be real
Now to the on-line analysis of any dimension of the raw data table after variation, avoid occurring in the prior art, being analyzed due to this
The case where can not carrying out on-line analysis to it in the cube that first dimension is established before not existing in.In this way, can effectively open up
The analyzable dimension of wide on-line analytical processing method and measurement, are bonded user's use demands, improve on-line analytical processing method
It is applicable in scene domain.By technical solution provided by the present disclosure, when carrying out on-line analysis, without pre-establishing cube, thus
The efficiency of on-line analysis can be improved, reduce complexity, and update easy to maintain.
In order to make those skilled in the art be easier to understand technical solution provided in an embodiment of the present invention, first below to upper
The each step stated in method is described in detail.
It is alternatively possible to determine the first dimension and measurement according to the user's choice.Illustratively, user can be according to its business
Demand, which determines, needs the dimension and measurement analyzed, as shown in Fig. 2, can in region 201 in raw data table dimension and
Measurement is shown, so as to which the dimension selected is determined as the first dimension, selected measurement is determined as the measurement, is such as schemed
Described in 2, the first dimension is province, is measured as quantity on order.
Optionally, the corresponding dimension hierarchy relationship of raw data table can be constructed in advance.Illustratively, as 203 in Fig. 2
Shown in region can be the region for constructing dimension hierarchy relationship, can be preset in level and region in this region
Position between corresponding relationship.For example, the regional dimension in region 201 is being dragged to the corresponding position of the first estate by user
When setting 2031, regional dimension can be determined in dimension hierarchy relationship according to position of the regional dimension in hierarchical relationship building region
Middle corresponding the first estate.It similarly, can also be according to the position when province dimension being dragged to the corresponding position 2032 of the second grade
Set determining province dimension corresponding second grade in dimension hierarchy relationship;City dimension is dragged to the corresponding position of the tertiary gradient
When 2033, it can also determine that city dimension corresponds to the tertiary gradient in dimension hierarchy relationship according to the position, wherein setting dimension
The position number of hierarchical relationship can be configured according to actual use.
Optionally, in another embodiment, dimension can be carried out using generated dimension hierarchy relationship as an option
The building of hierarchical relationship.Such as, when establishing the dimension hierarchy relationship of the first level and the second level, the dimension layer can be shown
Secondary relationship, as shown in 205 in Fig. 2, the dimension hierarchy relationship that has as constructed.In subsequent needs, further building dimension hierarchy is closed
When being, when such as further increasing cities and towns dimension, the dimension hierarchy relationship directly can be dragged to the corresponding position of the first level,
Cities and towns dimension is dragged to the position of the second level, at this point, can then construct the dimension between " area-province-city-cities and towns "
Spend hierarchical relationship.Through the above technical solutions, can based on the dimension hierarchy relationship constructed to dimension hierarchy relationship carry out into
The setting of one step improves the efficiency of dimension hierarchy relationship building, user-friendly.Above-described embodiment is only to construct dimension hierarchy to close
A kind of example implementations of system, are not defined the disclosure.For example, it is also possible to directly input each level pair by user
The dimension answered is configured dimension hierarchy relationship.
Optionally, described according to the first data, after the step 12 for generating analysis chart, this method further include:
It is described in the analysis chart of generation if first dimension is present in the dimension hierarchy relationship
Each dimensional attribute association of first dimension drills through control, described to drill through control and described drill through instruction for receiving.
Illustratively, the first dimension is province, then the analysis chart generated according to the first data is as shown in Figure 2.Initial data
The corresponding dimension hierarchy relationship of table is area-province-city, then the first dimension is present in the dimension hierarchy relationship.At this point, can
, to drilling analysis is carried out, to be analyzed according to dimension hierarchy relationship with being based on other dimensions.Therefore, in this embodiment, may be used
Think that each dimensional attribute association of the first dimension (that is, province) drills through control, in order to realize drilling analysis.Wherein, first
When dimension has its higher level's dimension, then control is drilled through for be rolled onto higher level's dimension in its association, there is junior in the first dimension
When dimension, then control is drilled through for be drilled into junior's dimension under its association.Wherein, the first dimension is province, in area-province-
In the dimension hierarchy relationship in city, province has higher level's dimension (that is, regional dimension) and junior's dimension (that is, city dimension), then
Volume to regional drilling through control and be used to indicate down can be used to indicate for each dimensional attribute association in province be drilled into city
Drill through control.When user chooses and drills through control accordingly, then it can receive and drill through instruction accordingly.
Optionally, the associated control that drills through of dimensional attribute can be triggered display when user needs to carry out drilling operation.
Illustratively, it drills through control and right mouse button can be clicked by user and carry out triggering and show.The display mode for drilling through control can be
Menu is shown.As shown in Fig. 2, current dimension is province, when user (is shown as histogram in the corresponding region in dimensional attribute Shandong
When, which is then the region of the corresponding display column in Shandong) right-click when, then Shandong is determined as target dimension attribute, and
It can show that the control that drills through of the target dimension Attribute Association is e.g. shown on this in the corresponding region in target dimension attribute Shandong
Roll up to area drill through control and under be drilled into city drill through control.
Through the above technical solutions, each dimensional attribute association for the first dimension being present in dimension hierarchy relationship drills through
Control drills through instruction convenient for receive user, while may be whether user is able to carry out drilling analysis and prompts, fitting
The use demand of user.
Optionally, this method further include:
If first dimension is not present in the dimension hierarchy relationship, according to first dimension, described in update
Dimension hierarchy relationship.
It wherein, then cannot be based on the corresponding of first dimension when the first dimension is not present in dimension hierarchy relationship
It analyzes chart and carries out drilling analysis.At this point it is possible to be updated to dimension hierarchy relationship, which is added to dimension
In hierarchical relationship, to carry out drilling analysis based on the corresponding analysis chart of the first dimension.
Illustratively, the mode for updating dimension hierarchy relationship is similar with the building mode of dimension hierarchy relationship.In an embodiment
In, which can be associated with the dimension hierarchy relationship constructed, with to the dimension hierarchy relationship constructed into
Row updates, and the first dimension and other dimensions in raw data table can also be associated, and is closed with creating new dimension hierarchy
System.Its specific embodiment is described in detail above, and details are not described herein.
Through the above technical solutions, can with real-time update dimension hierarchy relationship, so as to based on present analysis chart into
Row drilling analysis improves the spirit of drilling analysis so that the on-line analytical processing method can be adapted for multiple business scene
Activity.
Optionally, drilling through may include upper volume and lower brill, in response to receiving for the target in present analysis chart
Dimensional attribute drills through instruction, in the corresponding dimension hierarchy relationship of raw data table, instructs according to drilling through from current dimension institute
Place's level starts to be drilled through, and obtains the second dimension, may include:
If drilling through instruction indicates dimension corresponding in the corresponding dimension hierarchy relationship of raw data table, can be by the dimension
Degree is determined as the second dimension, e.g., drills through and is drilled into city under instruction instruction, then the second dimension is city;
If drilling through the type for indicating and drilling through, according to the type and the corresponding dimension hierarchy relationship of raw data table
Determine the second dimension, it e.g.,, then can will be original when current dimension is province when to drill through type that instruction instruction drills through be lower brill
In the corresponding dimension hierarchy relationship of tables of data, the corresponding next level in province be determined as the second dimension, i.e. city dimension.
Optionally, described according to second data, after the step of generating new analysis chart, this method is also wrapped
It includes:
It is that each dimensional attribute of second dimension is associated with and drills through control in the new analysis chart of generation, it is described
It drills through control and described drills through instruction for receiving.
In this embodiment, the second dimension is determined by drilling through instruction and dimension hierarchy relationship, then the second dimension
It is present in the dimension hierarchy relationship.Therefore, it can directly be closed in new analysis chart for each dimensional attribute of the second dimension
Connection drills through control, drills through instruction for the analysis chart new with this to receive.Wherein, in the new analysis chart of generation
Each dimensional attribute association for the second dimension drills through the embodiment of control and is the first dimension in the analysis chart of generation
The embodiment that each dimensional attribute association drills through control is identical, and details are not described herein.
Through the above technical solutions, control is drilled through for each dimensional attribute association of the second dimension in new analysis chart,
Allow user to carry out drilling analysis based on new analysis chart, realizes the drilling analysis of more analysis granularities, further promoted
User experience.
Optionally, this method further include: when it is described to drill through instruction be that lower brills instructs when, according to the target dimension attribute,
Generate data filtering condition;And
It is described according to the second dimension and metrics query raw data table, it is several to obtain corresponding with the second dimension and measurement second
According to the step of are as follows:
The raw data table is inquired according to second dimension, the measurement and the data filtering condition, is obtained
Under second dimension, the second data corresponding with the target dimension attribute and the measurement.
In one embodiment, user is by the way that shown in Fig. 2, current dimension is province, measures as quantity on order, then user chooses
When drilling through control of " under be drilled into city ", the instruction that drills through received is the instruction of lower brills.Illustratively, according to the target dimension category
Property, when generating data filtering condition, target dimension attribute is Shandong, is drilled into city, the data mistake of generation under lower brill instruction instruction
Filter condition is to belong to the city in Shandong.Therefore, when inquiring raw data table, it can be got from raw data table and belong to Shandong
Each city the corresponding data of quantity on order, to generate new analysis chart according to the data.
Through the above technical solutions, for each dimensional attribute shown in analysis chart, it can be based on part of dimension
Degree attribute carries out lower brill analysis and meets the use demand of user, and easy to operate consequently facilitating carrying out multi-angular analysis, reduces
The use difficulty of user.
Optionally, it is described drill through instruction be upper volume instruction when, can be directly according to volume instruction and dimension hierarchy relationship on this
The second dimension and metrics query raw data table determined obtain the second data corresponding with the second dimension and measurement, thus
New analysis chart is generated according to the second data.Its specific embodiment is described above, and details are not described herein.
Optionally, in another embodiment, when generating analysis chart, user can also input filter condition.It is receiving
To the input of user filter condition when, when according to dimension and metrics query raw data table, the data of acquisition are original number
According to data corresponding and meeting the filter condition with the dimension and measurement in table.Such as, the filter condition of user's input is " order
Quantity is greater than 1000 ", then when being inquired in raw data table, and when quantity on order is less than or equal to 1000, the data are not
It can be acquired, i.e., not shown in analysis chart.
Optionally, the dimension hierarchy relationship is stored using the storage form of non-data cube.
It wherein, can be by initial data using the storage form of data cube when being stored to dimension hierarchy relationship
In table, the data of dimension corresponding to the dimension hierarchy relationship and the dimension hierarchy relationship stored.At this point, if desired to this
Dimension hierarchy relationship is updated, then the data stored to it and dimension hierarchy relationship is needed to be updated.
In the embodiment that the disclosure provides, it can be stored using the storage form of non-data cube, such as only to the dimension
Degree hierarchical relationship is stored, and is not stored to its data.Therefore, when being updated to dimension hierarchy relationship, it is only necessary to
Dimension hierarchy relationship is updated, does not need to carry out the operation that inquiry raw data table again obtains simultaneously storing data.Therefore,
On the one hand the treating capacity that data can be reduced, on the other hand can be improved the update efficiency of dimension hierarchy relationship, so that dimension layer
The update mode of secondary relationship is simple, is easy to implement, so that the applicability of analysis method be effectively ensured.
In one embodiment, a kind of example implementations for generating new analysis chart are as follows:
Generate new analysis chart with instead previous existence at analysis chart e.g. can be in the chart display area in Fig. 2
New analysis chart is shown, so as to check convenient for user.
In another embodiment, the analysis chart that can also be shown the new analysis chart simultaneously and generate before, so as to
It is compared and analyzed according to the chart of different dimensions level.
The disclosure also provides a kind of on-line analytical processing device, as shown in figure 3, described device 10 includes:
First enquiry module 100, for according to the first dimension and metrics query raw data table, obtaining and first dimension
Degree and corresponding first data of the measurement;
First generation module 200, for generating analysis chart according to first data;
Module 300 is drilled through, for the drilling through for the target dimension attribute in present analysis chart in response to receiving
Instruction, in the corresponding dimension hierarchy relationship of the raw data table, according to it is described drill through instruction from current dimension locating for level
Start to be drilled through, obtain the second dimension, the current dimension is dimension belonging to the target dimension attribute;
Second enquiry module 400 is used for the raw data table according to second dimension and the metrics query, obtains
The second data corresponding with second dimension and the measurement;
Second generation module 500, for generating new analysis chart according to second data.
Optionally, the device 10 further include:
Third generation module, for when it is described to drill through instruction be the instruction of lower brills when, according to the target dimension attribute, generation
Data filtering condition;And
Second enquiry module 400 is used for:
The raw data table is inquired according to second dimension, the measurement and the data filtering condition, is obtained
Under second dimension, the second data corresponding with the target dimension attribute and the measurement.
Optionally, the device 10 further include:
First relating module, for according to first data, generated in first generation module 200 analysis chart it
It afterwards, is described first in the analysis chart of generation if first dimension is present in the dimension hierarchy relationship
Each dimensional attribute association of dimension drills through control, described to drill through control and described drill through instruction for receiving.
Optionally, the device 10 further include:
Update module, for when first dimension is not present in the dimension hierarchy relationship, then according to described
Dimension updates the dimension hierarchy relationship.
Optionally, the device 10 further include:
Second relating module, for according to first data, generated in first generation module 200 analysis chart it
It afterwards, is that each dimensional attribute of second dimension is associated with and drills through control in the new analysis chart of generation, it is described to drill through
Control drills through instruction described in being used to receive.
Optionally, the dimension hierarchy relationship is stored using the storage form of non-data cube.
Optionally, second generation module 500 generates new analysis chart are as follows:
Generate new analysis chart with instead previous existence at analysis chart.
About the device in above-described embodiment, wherein modules execute the concrete mode of operation in related this method
Embodiment in be described in detail, no detailed explanation will be given here.
Fig. 4 is the block diagram of a kind of electronic equipment 700 shown according to an exemplary embodiment.As shown in figure 4, the electronics is set
Standby 700 may include: processor 701, memory 702.The electronic equipment 700 can also include multimedia component 703, input/
Export one or more of (I/O) interface 704 and communication component 705.
Wherein, processor 701 is used to control the integrated operation of the electronic equipment 700, to complete at above-mentioned on-line analysis
All or part of the steps in reason method.Memory 702 is for storing various types of data to support in the electronic equipment 700
Operation, these data for example may include the finger of any application or method for operating on the electronic equipment 700
Order and the relevant data of application program, such as contact data, the message of transmitting-receiving, picture, audio, video etc..The storage
Device 702 can be realized by any kind of volatibility or non-volatile memory device or their combination, such as static random
It accesses memory (Static Random Access Memory, abbreviation SRAM), electrically erasable programmable read-only memory
(Electrically Erasable Programmable Read-Only Memory, abbreviation EEPROM), erasable programmable
Read-only memory (Erasable Programmable Read-Only Memory, abbreviation EPROM), programmable read only memory
(Programmable Read-Only Memory, abbreviation PROM), and read-only memory (Read-Only Memory, referred to as
ROM), magnetic memory, flash memory, disk or CD.Multimedia component 703 may include screen and audio component.Wherein
Screen for example can be touch screen, and audio component is used for output and/or input audio signal.For example, audio component may include
One microphone, microphone is for receiving external audio signal.The received audio signal can be further stored in storage
Device 702 is sent by communication component 705.Audio component further includes at least one loudspeaker, is used for output audio signal.I/O
Interface 704 provides interface between processor 701 and other interface modules, other above-mentioned interface modules can be keyboard, mouse,
Button etc..These buttons can be virtual push button or entity button.Communication component 705 is for the electronic equipment 700 and other
Wired or wireless communication is carried out between equipment.Wireless communication, such as Wi-Fi, bluetooth, near-field communication (Near Field
Communication, abbreviation NFC), 2G, 3G, 4G, NB-IOT, eMTC or other 5G etc. or they one or more of
Combination, it is not limited here.Therefore the corresponding communication component 707 may include: Wi-Fi module, bluetooth module, NFC mould
Block etc..
In one exemplary embodiment, electronic equipment 700 can be by one or more application specific integrated circuit
(Application Specific Integrated Circuit, abbreviation ASIC), digital signal processor (Digital
Signal Processor, abbreviation DSP), digital signal processing appts (Digital Signal Processing Device,
Abbreviation DSPD), programmable logic device (Programmable Logic Device, abbreviation PLD), field programmable gate array
(Field Programmable Gate Array, abbreviation FPGA), controller, microcontroller, microprocessor or other electronics member
Part is realized, for executing above-mentioned on-line analytical processing method.
In a further exemplary embodiment, a kind of computer readable storage medium including program instruction is additionally provided, it should
The step of above-mentioned on-line analytical processing method is realized when program instruction is executed by processor.For example, the computer-readable storage
Medium can be the above-mentioned memory 702 including program instruction, and above procedure instruction can be by the processor 701 of electronic equipment 700
It executes to complete above-mentioned on-line analytical processing method.
Fig. 5 is the block diagram of a kind of electronic equipment 1900 shown according to an exemplary embodiment.For example, electronic equipment 1900
It may be provided as a server.Referring to Fig. 5, electronic equipment 1900 includes processor 1922, and quantity can be one or more
A and memory 1932, for storing the computer program that can be executed by processor 1922.The meter stored in memory 1932
Calculation machine program may include it is one or more each correspond to one group of instruction module.In addition, processor 1922 can
To be configured as executing the computer program, to execute above-mentioned on-line analytical processing method.
In addition, electronic equipment 1900 can also include power supply module 1926 and communication component 1950, the power supply module 1926
It can be configured as the power management for executing electronic equipment 1900, which can be configured as realization electronic equipment
1900 communication, for example, wired or wireless communication.In addition, the electronic equipment 1900 can also include that input/output (I/O) connects
Mouth 1958.Electronic equipment 1900 can be operated based on the operating system for being stored in memory 1932, such as Windows
ServerTM, Mac OS XTM, UnixTM, LinuxTM etc..
In a further exemplary embodiment, a kind of computer readable storage medium including program instruction is additionally provided, it should
The step of above-mentioned on-line analytical processing method is realized when program instruction is executed by processor.For example, the computer-readable storage
Medium can be the above-mentioned memory 1932 including program instruction, and above procedure instruction can be by the processor of electronic equipment 1900
1922 execute to complete above-mentioned on-line analytical processing method.
The preferred embodiment of the disclosure is described in detail in conjunction with attached drawing above, still, the disclosure is not limited to above-mentioned reality
The detail in mode is applied, in the range of the technology design of the disclosure, a variety of letters can be carried out to the technical solution of the disclosure
Monotropic type, these simple variants belong to the protection scope of the disclosure.
It is further to note that specific technical features described in the above specific embodiments, in not lance
In the case where shield, it can be combined in any appropriate way.In order to avoid unnecessary repetition, the disclosure to it is various can
No further explanation will be given for the combination of energy.
In addition, any combination can also be carried out between a variety of different embodiments of the disclosure, as long as it is without prejudice to originally
Disclosed thought equally should be considered as disclosure disclosure of that.
Claims (10)
1. a kind of on-line analytical processing method, which is characterized in that the described method includes:
According to the first dimension and metrics query raw data table, the first number corresponding with first dimension and the measurement is obtained
According to;
According to first data, analysis chart is generated;
Instruction is drilled through for the target dimension attribute in present analysis chart in response to what is received, in the raw data table
In corresponding dimension hierarchy relationship, according to it is described drill through instruction level locating for the current dimension drilled through, obtain second
Dimension, the current dimension are dimension belonging to the target dimension attribute;
According to raw data table described in second dimension and the metrics query, obtain and second dimension and the measurement
Corresponding second data;
According to second data, new analysis chart is generated.
2. the method according to claim 1, wherein this method further include: when it is described drill through instruction be it is lower brill refer to
When enabling, according to the target dimension attribute, data filtering condition is generated;And
The raw data table according to second dimension and the metrics query obtains and second dimension and described
The step of measuring corresponding second data are as follows:
The raw data table is inquired according to second dimension, the measurement and the data filtering condition, is obtained described
Under second dimension, the second data corresponding with the target dimension attribute and the measurement.
3. the method according to claim 1, wherein generating analysis chart according to first data described
The step of after, this method further include:
It is described first in the analysis chart of generation if first dimension is present in the dimension hierarchy relationship
Each dimensional attribute association of dimension drills through control, described to drill through control and described drill through instruction for receiving.
4. according to the method described in claim 3, it is characterized in that, this method further include:
If first dimension is not present in the dimension hierarchy relationship, according to first dimension, the dimension is updated
Hierarchical relationship.
5. the method according to claim 1, wherein generating new analysis according to second data described
After the step of chart, this method further include:
It is that each dimensional attribute of second dimension is associated with and drills through control in the new analysis chart of generation, it is described to drill through
Control drills through instruction described in being used to receive.
6. method according to any one of claims 1-5, which is characterized in that the dimension hierarchy relationship uses non-data
The storage form of cube stores.
7. method according to any one of claims 1-5, which is characterized in that described the step of generating new analysis chart
Are as follows:
Generate new analysis chart with instead previous existence at analysis chart.
8. a kind of on-line analytical processing device, which is characterized in that described device includes:
First enquiry module, for obtaining and first dimension and institute according to the first dimension and metrics query raw data table
State corresponding first data of measurement;
First generation module, for generating analysis chart according to first data;
Module is drilled through, for drilling through instruction for the target dimension attribute in present analysis chart in response to what is received,
In the corresponding dimension hierarchy relationship of the raw data table, according to it is described drill through instruction level locating for the current dimension carry out
It drills through, obtains the second dimension, the current dimension is dimension belonging to the target dimension attribute;
Second enquiry module, be used for the raw data table according to second dimension and the metrics query, obtain with it is described
Second dimension and corresponding second data of the measurement;
Second generation module, for generating new analysis chart according to second data.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
The step of any one of claim 1-7 the method is realized when row.
10. a kind of electronic equipment characterized by comprising
Memory is stored thereon with computer program;
Processor, for executing the computer program in the memory, to realize described in any one of claim 1-7
The step of method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811638962.4A CN109739940A (en) | 2018-12-29 | 2018-12-29 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811638962.4A CN109739940A (en) | 2018-12-29 | 2018-12-29 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109739940A true CN109739940A (en) | 2019-05-10 |
Family
ID=66362458
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811638962.4A Pending CN109739940A (en) | 2018-12-29 | 2018-12-29 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109739940A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112286409A (en) * | 2020-08-21 | 2021-01-29 | 上海柯林布瑞信息技术有限公司 | Data visualization analysis method and device, storage medium and terminal |
CN112989019A (en) * | 2019-12-12 | 2021-06-18 | 阿里巴巴集团控股有限公司 | Data processing method, device, computer system and readable storage medium |
CN113837622A (en) * | 2021-09-27 | 2021-12-24 | 北京博望华科科技有限公司 | Coal consumption data multidimensional drilling analysis method and device, storage medium and computing equipment |
Citations (9)
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 |
CN102135994A (en) * | 2011-03-17 | 2011-07-27 | 新太科技股份有限公司 | Online analytical processing (OLAP)-based intelligent analysis method |
CN102867066A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data summarization device and data summarization method |
CN104424231A (en) * | 2013-08-26 | 2015-03-18 | 腾讯科技(深圳)有限公司 | Multi-dimensional data processing method and device |
CN105022813A (en) * | 2015-07-07 | 2015-11-04 | 中电海康集团有限公司 | Configurable multidimensional dynamic data graph group association method |
CN106021486A (en) * | 2016-05-18 | 2016-10-12 | 广东源恒软件科技有限公司 | Big data-based data multidimensional analyzing and processing method |
CN107357923A (en) * | 2017-07-21 | 2017-11-17 | 山东浪潮商用系统有限公司 | The cubical method of the tax is generated based on FreeMarker |
CN107408134A (en) * | 2015-03-19 | 2017-11-28 | 华为技术有限公司 | Rebuild the method for the data storage of multi-dimensional database and rebuild server |
CN108255479A (en) * | 2017-12-08 | 2018-07-06 | 平安科技(深圳)有限公司 | Creation method, device, storage medium and the terminal of cube files |
-
2018
- 2018-12-29 CN CN201811638962.4A patent/CN109739940A/en active Pending
Patent Citations (9)
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 |
CN102135994A (en) * | 2011-03-17 | 2011-07-27 | 新太科技股份有限公司 | Online analytical processing (OLAP)-based intelligent analysis method |
CN102867066A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data summarization device and data summarization method |
CN104424231A (en) * | 2013-08-26 | 2015-03-18 | 腾讯科技(深圳)有限公司 | Multi-dimensional data processing method and device |
CN107408134A (en) * | 2015-03-19 | 2017-11-28 | 华为技术有限公司 | Rebuild the method for the data storage of multi-dimensional database and rebuild server |
CN105022813A (en) * | 2015-07-07 | 2015-11-04 | 中电海康集团有限公司 | Configurable multidimensional dynamic data graph group association method |
CN106021486A (en) * | 2016-05-18 | 2016-10-12 | 广东源恒软件科技有限公司 | Big data-based data multidimensional analyzing and processing method |
CN107357923A (en) * | 2017-07-21 | 2017-11-17 | 山东浪潮商用系统有限公司 | The cubical method of the tax is generated based on FreeMarker |
CN108255479A (en) * | 2017-12-08 | 2018-07-06 | 平安科技(深圳)有限公司 | Creation method, device, storage medium and the terminal of cube files |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112989019A (en) * | 2019-12-12 | 2021-06-18 | 阿里巴巴集团控股有限公司 | Data processing method, device, computer system and readable storage medium |
CN112286409A (en) * | 2020-08-21 | 2021-01-29 | 上海柯林布瑞信息技术有限公司 | Data visualization analysis method and device, storage medium and terminal |
CN112286409B (en) * | 2020-08-21 | 2021-09-24 | 上海柯林布瑞信息技术有限公司 | Data visualization analysis method and device, storage medium and terminal |
CN113589989A (en) * | 2020-08-21 | 2021-11-02 | 上海柯林布瑞信息技术有限公司 | Data multidimensional drilling method and device, storage medium and terminal |
CN113837622A (en) * | 2021-09-27 | 2021-12-24 | 北京博望华科科技有限公司 | Coal consumption data multidimensional drilling analysis method and device, storage medium and computing equipment |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105222782B (en) | A kind of route recommendation method and mobile terminal | |
CN107924679A (en) | Delayed binding during inputting understanding processing in response selects | |
CN109739940A (en) | On-line analytical processing method, apparatus, storage medium and electronic equipment | |
TW201633241A (en) | Target address determining method and device | |
CN109062779A (en) | Test control method, main control device, controlled device and test macro | |
CN106164945A (en) | Sight modeling and visualization | |
JP6091981B2 (en) | Menstruation scheduled date calculation device and program | |
US7797356B2 (en) | Dynamically detecting exceptions based on data changes | |
US20210342867A1 (en) | Methods for predicting economic state and establishing economic state prediction model and corresponding apparatuses | |
CN110018920A (en) | A kind of detection method, device and the equipment of page presentation exception | |
TW201917571A (en) | Information processing method, apparatus, and device | |
WO2020181854A1 (en) | Payment anomaly detection | |
CN109753372A (en) | Multidimensional data method for detecting abnormality, device, readable storage medium storing program for executing and electronic equipment | |
JP2018101201A (en) | Policy introduction effect prediction device, policy introduction effect prediction program and policy introduction effect prediction method | |
CN105550316B (en) | The method for pushing and device of audio list | |
CN109784657A (en) | Operation flow method for building up, device, storage medium and electronic equipment | |
CN109800858A (en) | Data exception detection method, device, readable storage medium storing program for executing and electronic equipment | |
CN109766913A (en) | Tenant group method, apparatus, computer readable storage medium and electronic equipment | |
US20170255343A1 (en) | Data interaction cards for capturing and replaying logic in visual analyses | |
CN108093057A (en) | Method and device for guiding permission to be opened | |
EP2977937A1 (en) | Event processing systems and methods | |
CN108241404A (en) | A kind of method, apparatus and electronic equipment for obtaining the off-line operation time | |
CN109062791A (en) | A kind of signal message recording method, system, equipment and computer storage medium | |
CN109815278A (en) | A kind of method for exhibiting data and its equipment, storage medium, electronic equipment | |
CN108683547A (en) | A kind of wireless sensor network configuration method of software definition |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190510 |
|
RJ01 | Rejection of invention patent application after publication |