CN104391998A - SSAS (SQL server analysis services) based customized index processing method and device - Google Patents
SSAS (SQL server analysis services) based customized index processing method and device Download PDFInfo
- Publication number
- CN104391998A CN104391998A CN201410779032.6A CN201410779032A CN104391998A CN 104391998 A CN104391998 A CN 104391998A CN 201410779032 A CN201410779032 A CN 201410779032A CN 104391998 A CN104391998 A CN 104391998A
- Authority
- CN
- China
- Prior art keywords
- index
- customize
- customization
- instruction
- wait
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000004458 analytical method Methods 0.000 title abstract description 13
- 238000003672 processing method Methods 0.000 title abstract 3
- 238000000034 method Methods 0.000 claims abstract description 22
- 238000012423 maintenance Methods 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000008531 maintenance mechanism Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an SSAS (SQL server analysis services) based customized index processing method and device. The method comprises steps as follows: a to-be-customized index and affiliated information of the to-be-customized index are determined, wherein the to-be-customized index adopts a user-defined index required to be established, and the affiliated information comprises a definition expression of the to-be-customized index; an establishing instruction corresponding to the to-be-customized index is generated according to the to-be-customized index and the affiliated information of the to-be-customized index; and the to-be-customized index is established in an SSAS according to the establishing instruction. By means of the SSAS based customized index processing method and device, the problem of difficulty in uniform maintenance on the customized index in the prior art is solved.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of customization index disposal route based on analytical database and device.
Background technology
In existing data analysis system, analytical database (SSAS) stores fixing index, but each client exists different demands, and therefore some clients need to customize some user-defined counters.Such as, by order status for cancel an order, be defined as useless odd number etc.Specific implementation can pass through the generations such as the addition subtraction multiplication and division of existing each index, or weighted mean class, or the user-defined counter of alternate manner.In prior art, be by developing separately corresponding Cube data warehouse for each client, and create relevant user-defined counter for it.But based on the general maintenance mechanism that the user-defined counter neither one created under the program is unified, the change of each customization index, all needs independent develop and field corresponding Cube data warehouse, complex operation, cost higher.
For in prior art, problem difficult in maintenance is unified to customization index, not yet propose effective solution at present.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of customization index disposal route based on analytical database and device, unifies problem difficult in maintenance to solve in prior art to customization index.
To achieve these goals, according to an aspect of the present invention, a kind of customization index disposal route based on analytical database is provided.
Customization index disposal route based on analytical database according to the present invention comprises: determine the satellite information waiting to customize index and wait to customize index, wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index; Customize index according to waiting and wait to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index; And according to establishment instruction create in analytical database wait customize index.
Further, after determining the satellite information waiting to customize index and treat customization index, to generate according to the satellite information waiting to customize index and wait to customize index and before waiting to customize the corresponding establishment instruction of index, the method also comprises: create allocation list, wherein, allocation list is for storing the satellite information waiting to customize index and wait to customize index; Customize index by waiting and wait that the satellite information customizing index is stored to allocation list, customize index according to waiting and treat that the satellite information generation of customization index creates instruction accordingly and comprises: receive query statement, wherein, query statement is be used to indicate the instruction inquired about in allocation list and wait to customize index and wait the satellite information customizing index; In allocation list, the satellite information waiting to customize index and wait to customize index is inquired about according to query statement; And treat customization index according to what inquire and wait that the satellite information customizing index generates and waits to customize the corresponding establishment instruction of index.
Further, in analytical database, create customization index according to establishment instruction to comprise: customize index according to waiting and treat that the satellite information of customization index creates instruction accordingly and determines to create the respective rule treating customization index, wherein, respective rule comprises the index group of specifying customization index to store in analytical database; And wait to customize the respective rule of index and create according to creating in analytical database and wait to customize index.
Further, after creating in analytical database according to establishment instruction and treating customization index, the method also comprises: receive and add instruction, and wherein, adding instruction is be used to indicate the instruction of customization index added and need to add; The customization index that needs add is determined according to adding instruction; Receive update instruction, wherein, update instruction is the instruction of the customization index be used to indicate in the customization index replacement analysis database that adds as required; And according to the customization index in update instruction replacement analysis database.
Further, comprise according to the customization index in update instruction replacement analysis database: the customization index judging whether to have stored needs interpolation in analytical database; If stored the customization index needing to add in analytical database, upgrade needing the customization index of adding; And if do not store in analytical database need add customization index, by need add customization index be stored in analytical database.
To achieve these goals, according to a further aspect in the invention, a kind of customization index treating apparatus based on analytical database is provided.
Customization index treating apparatus based on analytical database according to the present invention comprises: the first determining unit, for determining the satellite information waiting to customize index and wait to customize index, wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index; Generation unit, for customizing index according to waiting and wait to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index; And first creating unit, wait to customize index for creating in analytical database according to establishment instruction.
Further, this device also comprises: the second creating unit, and for creating allocation list, wherein, allocation list is for storing the satellite information waiting to customize index and wait to customize index; Storage unit, for customizing index by waiting and waiting that the satellite information customizing index is stored to allocation list, generation unit also comprises: receiver module, for receiving query statement, wherein, query statement is be used to indicate the instruction inquired about in allocation list and wait to customize index and wait the satellite information customizing index; Enquiry module, for inquiring about the satellite information waiting to customize index and wait to customize index in allocation list according to query statement; And generation module, for treating customization index according to what inquire and wait that the satellite information customizing index generates and waits to customize the corresponding establishment instruction of index.
Further, first creating unit comprises: determination module, for customizing index according to waiting and treat that the satellite information of customization index creates instruction accordingly and determines to create the respective rule waiting to customize index, wherein, respective rule comprises the index group of specifying customization index to store in analytical database; And creation module, for waiting to customize the respective rule of index and create according to creating in analytical database and wait to customize index.
Further, this device also comprises: the first receiving element, and for receiving interpolation instruction, wherein, adding instruction is be used to indicate the instruction added and need the customization index of adding; Second determining unit, for determining according to adding instruction the customization index that needs add; Second receiving element, for receiving update instruction, wherein, update instruction is the instruction of the customization index be used to indicate in the customization index replacement analysis database that adds as required; And updating block, for according to the customization index in update instruction replacement analysis database.
Further, updating block comprises: judge module, for judging whether to have stored in analytical database the customization index needing to add; Update module, for having stored the customization index needing to add in analytical database, upgrades needing the customization index of adding; And memory module, for not storing the customization index needing to add in analytical database, be stored to needing the customization index of adding in analytical database.
By the present invention, adopt following steps: determine the satellite information waiting to customize index and wait to customize index, wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index; Customize index according to waiting and wait to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index; And according to establishment instruction create in analytical database wait customize index.By the present invention, create in analytical database and wait to customize index, thus can unify to safeguard to customization index, solve in prior art and problem difficult in maintenance is unified to customization index.
Accompanying drawing explanation
The accompanying drawing forming a application's part is used to provide a further understanding of the present invention, and schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram of the customization index disposal route based on analytical database according to a first embodiment of the present invention;
Fig. 2 is the process flow diagram of the customization index disposal route based on analytical database according to a second embodiment of the present invention; And
Fig. 3 is the schematic diagram of the customization index treating apparatus based on analytical database according to the embodiment of the present invention.
Embodiment
It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
The application's scheme is understood better in order to make those skilled in the art person, below in conjunction with the accompanying drawing in the embodiment of the present application, technical scheme in the embodiment of the present application is clearly and completely described, obviously, described embodiment is only the embodiment of the application's part, instead of whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not making the every other embodiment obtained under creative work prerequisite, all should belong to the scope of the application's protection.
It should be noted that, term " first ", " second " etc. in the instructions of the application and claims and above-mentioned accompanying drawing are for distinguishing similar object, and need not be used for describing specific order or precedence.Should be appreciated that the data used like this can be exchanged, in the appropriate case so that the embodiment of the application described herein.In addition, term " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, such as, contain those steps or unit that the process of series of steps or unit, method, system, product or equipment is not necessarily limited to clearly list, but can comprise clearly do not list or for intrinsic other step of these processes, method, product or equipment or unit.
Fig. 1 is the process flow diagram of the customization index disposal route based on analytical database according to a first embodiment of the present invention.As shown in Figure 1, the method comprises following step S101 to step S103:
Step S101, determines the satellite information waiting to customize index and wait to customize index.
Determine the satellite information waiting to customize index and wait to customize index, wherein, wait that customizing index is the user-defined counter needing to create, wait to customize the satellite information of index comprise wait to customize index definition expression formula, this treats information such as the customization Customs Assigned Number of index, the title of this customization index etc.
Step S102, customizes index according to waiting and waits to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index.
Customize index according to waiting and wait to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index.Particularly, according to SQL query statement, inquire the above-mentioned satellite information waiting to customize index and wait to customize index determined.The MDX being spliced into user-defined counter according to the information inquired creates statement, namely creates instruction.
Such as, determine and treat that customization index is valid order validorders, this wait customize index specific definition for ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]), the MDX generating user-defined counter according to information such as the specific definitions of validorders and validorders creates statement and is:
CREATE MEMBER CURRENTCUBE. [Measures]. and [ValidOrders] AS ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]), VISIBLE=1, DISPLAY_FOLDER='Customization';
It should be noted that, [Measures] above. what [ValidOrders] represented is the title waiting to customize index, AS ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]) what represent is the specific definition waiting to customize index, can be the correlation calculation result of the arbitrary function supported in MDX language, last Customization represent this wait to customize index leave the position of index group in.
Step S103, creates according to establishment instruction and waits to customize index in analytical database.
Create in analytical database according to establishment instruction and wait to customize index.Create automatically in analytical database according to the establishment statement (establishment instruction) of above-mentioned generation and wait to customize index.
Particularly, in analytical database, create customization index according to establishment instruction to comprise: customize index according to waiting and treat that the satellite information of customization index creates instruction accordingly and determines to create the respective rule treating customization index, wherein, respective rule comprises the index group of specifying customization index to store in analytical database; And wait to customize the respective rule of index and create according to creating in analytical database and wait to customize index.
Such as, determine and treat that customization index is valid order validorders, this wait customize index specific definition for ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]), the MDX generating user-defined counter according to information such as the specific definitions of validorders and validorders creates statement and is:
CREATE MEMBER CURRENTCUBE. [Measures]. and [ValidOrders] AS ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]), VISIBLE=1, DISPLAY_FOLDER='Customization';
The respective rule that customization index determined to treat in statement is created according to above-mentioned MDX.Such as, [Measures] above. what [ValidOrders] represented is the title waiting to customize index, AS ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]) what represent is the specific definition waiting to customize index, can be the correlation calculation result of the arbitrary function supported in MDX language, last Customization represent this treat customization index leave the respective rule such as the position of index group in.Respective rule according to creating validorders creates validorders in analytical database.
Preferably, in order to realize adding customization index of intelligence, the embodiment of the present invention provide based in the customization index disposal route of analytical database, according to establishment instruction create in analytical database treat customization index after, the method also comprises: receive and add instruction, wherein, adding instruction is be used to indicate the instruction added and need the customization index of adding; The customization index that needs add is determined according to adding instruction; Receive update instruction, wherein, update instruction is the instruction of the customization index be used to indicate in the customization index replacement analysis database that adds as required; And according to the customization index in update instruction replacement analysis database.
If user needs newly to add customization index, adding instruction by receiving, determining the customization index needing to add; According to the customization index that these needs add, the customization index in analytical database is upgraded.Thus achieve intelligence customization index is added.
Preferably, comprise according to the customization index in update instruction replacement analysis database: the customization index judging whether to have stored needs interpolation in analytical database; If stored the customization index needing to add in analytical database, upgrade needing the customization index of adding; And if do not store in analytical database need add customization index, by need add customization index be stored in analytical database.
By whether having stored the customization index needing to add in discriminatory analysis database, different schemes has been selected to upgrade the customization index in analytical database.If stored the customization index needing to add in analytical database, upgrade needing the customization index of adding; If do not store the customization index needing to add in analytical database, will the customization index of adding be needed to be stored in analytical database, the customization index being about to need to add be inserted in analytical database.Ensure that adding the customization index needing to add in analytical database.
The customization index disposal route based on analytical database that the embodiment of the present invention provides, by determining the satellite information waiting to customize index and wait to customize index, wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index; Customize index according to waiting and wait to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index; And according to establishment instruction create in analytical database wait customize index, create in analytical database wait customize index, thus can to customization index unify safeguard, solve in prior art to customization index unify problem difficult in maintenance.
Fig. 2 is the process flow diagram of the customization index disposal route based on analytical database according to a second embodiment of the present invention.Fig. 2 can as a kind of preferred implementation embodiment illustrated in fig. 1.As shown in Figure 2, the method comprises following step S201 to step S208:
Step S201, determines the satellite information waiting to customize index and wait to customize index, and wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index.
This step, with step S101, repeats no more here.
Step S202, creates allocation list.
Create allocation list, wherein, allocation list is for storing the satellite information waiting to customize index and wait to customize index.At least store in this allocation list and wait to customize index name, Customs Assigned Number, treat the information such as customization index definition expression formula.
Step S203, customizes index by waiting and waits that the satellite information customizing index is stored to allocation list.
By creating allocation list, customizing index by waiting and waiting to customize in the satellite information stored configuration table of index.
Step S204, customizes index according to waiting and waits to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index.
This step, with step S102, repeats no more here.
Step S205, receives query statement.
Receive query statement, wherein, query statement is be used to indicate the instruction inquired about in allocation list and wait to customize index and wait the satellite information customizing index.
Step S206, inquires about the satellite information waiting to customize index and wait to customize index in allocation list according to query statement.
Step S207, treats customization index according to what inquire and waits that the satellite information customizing index generates and waits to customize the corresponding establishment instruction of index.
Treat customization index according to what inquire in allocation list and wait that the satellite information customizing index generates and waits to customize the corresponding establishment instruction of index.
Such as, what inquire in allocation list treats that customization index is valid order validorders, this wait customize index specific definition for ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]), the MDX generating user-defined counter according to information such as the specific definitions of validorders and validorders creates statement and is:
CREATE MEMBER CURRENTCUBE. [Measures]. and [ValidOrders] AS ([ECommerce]. [OrderStatus]. [paying], [Measures]. [TotalOrders]), VISIBLE=1, DISPLAY_FOLDER='Customization'
Step S208, creates according to establishment instruction and waits to customize index in analytical database.
This step, with step S103, repeats no more here.
The customization index disposal route based on analytical database that the embodiment of the present invention provides, by determining the satellite information waiting to customize index and wait to customize index, wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index; Create allocation list, wherein, allocation list is for storing the satellite information waiting to customize index and wait to customize index; Customize index by waiting and wait that the satellite information customizing index is stored to allocation list, customize index according to waiting and wait that the satellite information customizing index generates and waits to customize the corresponding establishment instruction of index; Receive query statement, wherein, query statement is be used to indicate the instruction inquired about in allocation list and wait to customize index and wait the satellite information customizing index; In allocation list, the satellite information waiting to customize index and wait to customize index is inquired about according to query statement; Treat customization index according to what inquire and wait that the satellite information customizing index generates and waits to customize the corresponding establishment instruction of index; Create in analytical database according to establishment instruction and wait to customize index, create in analytical database and wait to customize index, thus can unify to safeguard to customization index, solve in prior art and problem difficult in maintenance is unified to customization index.
It should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, but in some cases, can be different from the step shown or described by order execution herein.
The embodiment of the present invention additionally provides a kind of customization index treating apparatus based on analytical database, it should be noted that, the customization index treating apparatus based on analytical database of the embodiment of the present invention may be used for performing that the embodiment of the present invention provides for the customization index disposal route based on analytical database.Below the customization index treating apparatus based on analytical database that the embodiment of the present invention provides is introduced.
Fig. 3 is the schematic diagram of the customization index treating apparatus based on analytical database according to the embodiment of the present invention.As shown in Figure 3, this device comprises: the first determining unit 10, generation unit 20 and the first creating unit 30.
First determining unit 10, for determining the satellite information waiting to customize index and wait to customize index, wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index.
Preferably, this first creating unit comprises: determination module, for customizing index according to waiting and treat that the satellite information of customization index creates instruction accordingly and determines to create the respective rule waiting to customize index, wherein, respective rule comprises the index group of specifying customization index to store in analytical database; And creation module, for waiting to customize the respective rule of index and create according to creating in analytical database and wait to customize index.
Generation unit 20, for customizing index according to waiting and wait to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index.
First creating unit 30, waits to customize index for creating in analytical database according to establishment instruction.
The customization index disposal route based on analytical database that the embodiment of the present invention provides, the satellite information waiting to customize index and wait to customize index is determined by the first determining unit 10, wherein, wait that customizing index is the user-defined counter needing to create, satellite information comprises the definition expression formula waiting to customize index; Generation unit 20 customizes index according to waiting and waits to customize the satellite information generation of index and wait to customize the corresponding establishment instruction of index; And first creating unit 30 according to establishment instruction create in analytical database wait customize index, create in analytical database and wait to customize index, thus can unify to safeguard to customization index, solve in prior art and problem difficult in maintenance is unified to customization index.
Preferably, the embodiment of the present invention provide based in the customization index treating apparatus of analytical database, this device also comprises: the second creating unit, and for creating allocation list, wherein, allocation list is waited to customize index and wait to customize the satellite information of index for storing; Storage unit, for customizing index by waiting and waiting that the satellite information customizing index is stored to allocation list, generation unit also comprises: receiver module, for receiving query statement, wherein, query statement is be used to indicate the instruction inquired about in allocation list and wait to customize index and wait the satellite information customizing index; Enquiry module, for inquiring about the satellite information waiting to customize index and wait to customize index in allocation list according to query statement; And generation module, for treating customization index according to what inquire and wait that the satellite information customizing index generates and waits to customize the corresponding establishment instruction of index.
Preferably, the embodiment of the present invention provide based in the customization index treating apparatus of analytical database, this device also comprises: the first receiving element, and for receiving interpolation instruction, wherein, adding instruction is be used to indicate the instruction of customization index added and need to add; Second determining unit, for determining according to adding instruction the customization index that needs add; Second receiving element, for receiving update instruction, wherein, update instruction is the instruction of the customization index be used to indicate in the customization index replacement analysis database that adds as required; And updating block, for according to the customization index in update instruction replacement analysis database.Preferably, this updating block also comprises: judge module, for judging whether to have stored in analytical database the customization index needing to add; Update module, for having stored the customization index needing to add in analytical database, upgrades needing the customization index of adding; And memory module, for not storing the customization index needing to add in analytical database, be stored to needing the customization index of adding in analytical database.
The invention described above embodiment sequence number, just to describing, does not represent the quality of embodiment.
In the above embodiment of the present invention, the description of each embodiment is all emphasized particularly on different fields, in certain embodiment, there is no the part described in detail, can see the associated description of other embodiments.
In several embodiments that the application provides, should be understood that, disclosed client, the mode by other realizes.Wherein, device embodiment described above is only schematic, the such as division of described unit, be only a kind of logic function to divide, actual can have other dividing mode when realizing, such as multiple unit or assembly can in conjunction with or another system can be integrated into, or some features can be ignored, or do not perform.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, and the indirect coupling of unit or module or communication connection can be electrical or other form.
The described unit illustrated as separating component or can may not be and physically separates, and the parts as unit display can be or may not be physical location, namely can be positioned at a place, or also can be distributed in multiple network element.Some or all of unit wherein can be selected according to the actual needs to realize the object of the present embodiment scheme.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, also can be that the independent physics of unit exists, also can two or more unit in a unit integrated.Above-mentioned integrated unit both can adopt the form of hardware to realize, and the form of SFU software functional unit also can be adopted to realize.
If described integrated unit using the form of SFU software functional unit realize and as independently production marketing or use time, can be stored in a computer read/write memory medium.Based on such understanding, the part that technical scheme of the present invention contributes to prior art in essence in other words or all or part of of this technical scheme can embody with the form of software product, this computer software product is stored in a storage medium, comprises all or part of step of some instructions in order to make a computer equipment (can be personal computer, server or the network equipment etc.) perform method described in each embodiment of the present invention.And aforesaid storage medium comprises: USB flash disk, ROM (read-only memory) (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), portable hard drive, magnetic disc or CD etc. various can be program code stored medium.
The above is only the preferred embodiment of the present invention; it should be pointed out that for those skilled in the art, under the premise without departing from the principles of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (10)
1., based on a customization index disposal route for analytical database, it is characterized in that, comprising:
Determine to wait to customize index and the described satellite information waiting to customize index, wherein, described in wait that customizing index is the user-defined counter needing to create, and waits the definition expression formula customizing index described in described satellite information comprises;
According to described wait customize index and described wait customize index satellite information generate customize the corresponding establishment instruction of index to described waiting; And
Create in analytical database according to described establishment instruction and wait to customize index.
2. method according to claim 1, is characterized in that,
Determine to wait to customize index and described wait to customize the satellite information of index after, wait described in basis customize index and described wait customize index satellite information generate to described wait to customize the corresponding establishment instruction of index before, described method also comprises: create allocation list, wherein, described allocation list is waited to customize index and the described satellite information waiting to customize index described in storing; Wait to customize index by described and describedly wait that customizing the satellite information of index is stored to described allocation list,
Treat that customization index and the described satellite information waiting to customize index generate corresponding establishment instruction and comprise according to described: reception query statement, wherein, described query statement is waited described in inquiry to customize index and the described instruction waiting the satellite information customizing index in described allocation list for being used to indicate; Wait described in inquiring about in described allocation list according to described query statement to customize index and the described satellite information waiting to customize index; And generate and customize the corresponding establishment instruction of index according to waiting to customize index and the described satellite information waiting to customize index described in inquiring to described waiting.
3. method according to claim 1, is characterized in that, creates customization index comprise according to described establishment instruction in analytical database:
Treat that customization index and the described satellite information waiting to customize index create the respective rule that instruction determines to wait described in establishment to customize index accordingly according to described, wherein, described respective rule comprises the index group of specifying described customization index to store in described analytical database; And
According to creating, treat that the respective rule of customization index is waited to customize index described in creating in described analytical database.
4. method according to claim 1, is characterized in that, create in analytical database according to described establishment instruction treat customization index after, described method also comprises:
Receive and add instruction, wherein, described interpolation instruction is be used to indicate the instruction added and need the customization index of adding;
The customization index needing to add is determined according to described interpolation instruction;
Receive update instruction, wherein, described update instruction is be used to indicate the instruction that the customization index of adding as required upgrades the customization index in described analytical database; And
The customization index in described analytical database is upgraded according to described update instruction.
5. method according to claim 4, is characterized in that, comprises according to the customization index that described update instruction upgrades in described analytical database:
Judge whether to have stored in described analytical database the customization index needing to add;
If stored the customization index needing to add in described analytical database, upgrade needing the customization index of adding; And
If do not store the customization index needing to add in described analytical database, be stored to needing the customization index of adding in described analytical database.
6., based on a customization index treating apparatus for analytical database, it is characterized in that, comprising:
First determining unit, customizes index and the described satellite information waiting to customize index for determining to wait, wherein, described in wait that customizing index is the user-defined counter needing to create, and waits the definition expression formula customizing index described in described satellite information comprises;
Generation unit, customizes the corresponding establishment instruction of index for treating described in basis that customization index and the described satellite information waiting to customize index generate to described waiting; And
First creating unit, waits to customize index for creating in analytical database according to described establishment instruction.
7. device according to claim 6, is characterized in that, described device also comprises:
Second creating unit, for creating allocation list, wherein, described allocation list is waited to customize index and the described satellite information waiting to customize index described in storing;
Storage unit, for waiting to customize index by described and describedly wait that customizing the satellite information of index is stored to described allocation list,
Described generation unit also comprises:
Receiver module, for receiving query statement, wherein, described query statement is waited described in inquiry to customize index and the described instruction waiting the satellite information customizing index in described allocation list for being used to indicate;
Enquiry module, waits to customize index and the described satellite information waiting to customize index described in inquiring about in described allocation list according to described query statement; And
Generation module, treats described in inquiring that customization index and the described satellite information waiting to customize index generate customize the corresponding establishment instruction of index to described waiting for basis.
8. device according to claim 6, is characterized in that, described first creating unit comprises:
Determination module, for treating described in basis that customization index and the described satellite information waiting to customize index create the respective rule that instruction determines to wait described in establishment to customize index accordingly, wherein, described respective rule comprises the index group of specifying described customization index to store in described analytical database; And
Creation module, for treating that the respective rule of customization index is waited to customize index described in creating in described analytical database according to creating.
9. device according to claim 6, is characterized in that, described device also comprises:
First receiving element, for receiving interpolation instruction, wherein, described interpolation instruction is be used to indicate the instruction added and need the customization index of adding;
Second determining unit, for determining the customization index needing to add according to described interpolation instruction;
Second receiving element, for receiving update instruction, wherein, described update instruction is be used to indicate the instruction that the customization index of adding as required upgrades the customization index in described analytical database; And
Updating block, for upgrading the customization index in described analytical database according to described update instruction.
10. device according to claim 9, is characterized in that, described updating block comprises:
Judge module, for judging whether to have stored in described analytical database the customization index needing to add;
Update module, for having stored the customization index needing to add in described analytical database, upgrades needing the customization index of adding; And
Memory module, for not storing the customization index needing to add in described analytical database, is stored to needing the customization index of adding in described analytical database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410779032.6A CN104391998B (en) | 2014-12-15 | 2014-12-15 | Customization index processing method and processing device based on analytical database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410779032.6A CN104391998B (en) | 2014-12-15 | 2014-12-15 | Customization index processing method and processing device based on analytical database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104391998A true CN104391998A (en) | 2015-03-04 |
| CN104391998B CN104391998B (en) | 2018-09-18 |
Family
ID=52609902
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410779032.6A Active CN104391998B (en) | 2014-12-15 | 2014-12-15 | Customization index processing method and processing device based on analytical database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104391998B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108647340A (en) * | 2018-05-14 | 2018-10-12 | 浪潮通用软件有限公司 | A kind of multidimensional data real-time analysis method based on dynamic crosstab |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060010164A1 (en) * | 2004-07-09 | 2006-01-12 | Microsoft Corporation | Centralized KPI framework systems and methods |
| CN101345654A (en) * | 2008-08-30 | 2009-01-14 | 华为技术有限公司 | Index computing method and apparatus |
| CN102013049A (en) * | 2010-10-20 | 2011-04-13 | 浪潮集团山东通用软件有限公司 | Virtual organization-based KPI analysis method and statistical analysis system |
| CN102289373A (en) * | 2011-07-28 | 2011-12-21 | 福建富士通信息软件有限公司 | Method for dynamically configuring index evaluation system |
| CN103455489A (en) * | 2012-05-28 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method and system for rapidly constructing key performance indicators (KPIs) of enterprises |
-
2014
- 2014-12-15 CN CN201410779032.6A patent/CN104391998B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060010164A1 (en) * | 2004-07-09 | 2006-01-12 | Microsoft Corporation | Centralized KPI framework systems and methods |
| CN101345654A (en) * | 2008-08-30 | 2009-01-14 | 华为技术有限公司 | Index computing method and apparatus |
| CN102013049A (en) * | 2010-10-20 | 2011-04-13 | 浪潮集团山东通用软件有限公司 | Virtual organization-based KPI analysis method and statistical analysis system |
| CN102289373A (en) * | 2011-07-28 | 2011-12-21 | 福建富士通信息软件有限公司 | Method for dynamically configuring index evaluation system |
| CN103455489A (en) * | 2012-05-28 | 2013-12-18 | 阿里巴巴集团控股有限公司 | Method and system for rapidly constructing key performance indicators (KPIs) of enterprises |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108647340A (en) * | 2018-05-14 | 2018-10-12 | 浪潮通用软件有限公司 | A kind of multidimensional data real-time analysis method based on dynamic crosstab |
| CN108647340B (en) * | 2018-05-14 | 2021-06-08 | 浪潮通用软件有限公司 | Multi-dimensional data real-time analysis method based on dynamic cross table |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104391998B (en) | 2018-09-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107391114B (en) | Page visual rendering method and device | |
| CN106796522B (en) | System and method for updating source code file | |
| CN109542445A (en) | A kind of method and apparatus that Android plug-in unit melts hair | |
| US9280339B1 (en) | Class replacer during application installation | |
| CN108846753B (en) | Method and apparatus for processing data | |
| US10282186B2 (en) | Managing software suite component versions | |
| CN102243582B (en) | For generating the method and apparatus of user aid information for self-defined user interface | |
| CN110321544B (en) | Method and device for generating information | |
| CN110597888B (en) | Virtual resource acquisition method and device based on block chain, medium and equipment | |
| CN109144619A (en) | Icon font information processing method, apparatus and system | |
| US11762636B2 (en) | Method and system for implementing application lineage metadata and registration | |
| CN111181770A (en) | Resource allocation method, system, electronic equipment and storage medium | |
| JP7549431B2 (en) | Automating the Adoption of Cloud Services | |
| CN110457289A (en) | Advertisement promotion channel interconnection method, system, electronic equipment and readable storage medium storing program for executing | |
| CN113157271A (en) | Service processing method and device | |
| CN102385617A (en) | Dynamic domain query and query translation | |
| CN108733399A (en) | The method and apparatus that dynamic updates configuration data | |
| Mohamed et al. | SaaS dynamic evolution based on model-driven software product lines | |
| US20220035782A1 (en) | Datacenter inventory management | |
| CN101145164A (en) | Chronological book inquiry method and device | |
| US20220245581A1 (en) | Method and apparatus for sharing delivery box | |
| CN104391998A (en) | SSAS (SQL server analysis services) based customized index processing method and device | |
| US11301223B2 (en) | Artificial intelligence enabled function logic infusion | |
| CN107810474A (en) | Being automatically imported in extensive source code thesaurus and dependence | |
| CN103514412A (en) | Method and cloud server for establishing role-based access control 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: SSAS (SQL server analysis services) based customized index processing method and device Effective date of registration: 20190531 Granted publication date: 20180918 Pledgee: Shenzhen Black Horse World Investment Consulting Co.,Ltd. Pledgor: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Registration number: 2019990000503 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
| CP02 | Change in the address of a patent holder | ||
| PP01 | Preservation of patent right |
Effective date of registration: 20240604 Granted publication date: 20180918 |
|
| PP01 | Preservation of patent right |