CN104408107B - The device and method of Multidimensional Expressions record - Google Patents
The device and method of Multidimensional Expressions record Download PDFInfo
- Publication number
- CN104408107B CN104408107B CN201410671260.1A CN201410671260A CN104408107B CN 104408107 B CN104408107 B CN 104408107B CN 201410671260 A CN201410671260 A CN 201410671260A CN 104408107 B CN104408107 B CN 104408107B
- Authority
- CN
- China
- Prior art keywords
- expression formula
- information
- increment
- expression
- inquiry
- 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.)
- Active
Links
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/24—Querying
- G06F16/245—Query processing
- G06F16/2452—Query translation
- G06F16/24528—Standardisation; Simplification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of devices of Multidimensional Expressions record, comprising: client for original expression needed for sending the inquiry of this expression formula and the increment set based on the inquiry of last time expression formula, and receives return information;On-line analysing processing system is parsed, is obtained and merging treatment for the original expression based on transmission, and obtained result set is returned.The present invention also provides a kind of methods of Multidimensional Expressions record.According to the technical solution of the present invention, single object type can be made full use of to complete the expression formula record of more object types on the basis of existing expression formula recording mode, establishes general, the unified record thinking that more object type metadatas participate in expression formula record.
Description
Technical field
The present invention relates to field of computer technology, and in particular, to the device and one kind of a kind of Multidimensional Expressions record are more
The method for tieing up expression formula record.
Background technique
In on-line analysing processing system, core is exactly the analysis to multidimensional data, user and analysis process system
Operation can be interacted by way of Multidimensional Expressions, but this can generally have increment relation between last time operation,
And Multidimensional Expressions be it is stateless, store multiple whole expression formula contexts, operation compared, memory space have compared with
High requirement.
Therefore, it is necessary to a kind of new expression formula recording techniques, can be on the basis of existing expression formula recording mode, sufficiently
It is recorded using the expression formula that single object type completes more object types, establishes more object type metadatas and participate in expression formula record
General, unified record thinking.
Summary of the invention
The present invention is based on the above problems, proposes a kind of new expression formula recording technique, can be in existing expression
On the basis of formula recording mode, makes full use of single object type to complete the expression formula record of more object types, establish more object types
Metadata participates in general, the unified record thinking of expression formula record.
In view of this, the invention proposes a kind of devices of Multidimensional Expressions record, comprising: client, for sending this
Original expression and the increment set based on the inquiry of last time expression formula needed for secondary expression formula inquiry, and receive return information;Connection
Machine analysis process system is parsed, is obtained and merging treatment for the original expression based on transmission, the result that will be obtained
Collection returns.In the technical scheme, it can simplify user operation by the record of to multidimensional model inquiry and modification, mention
High model storage efficiency.
In the above-mentioned technical solutions, it is preferable that the client specifically includes: sending module, for sending this expression
Original expression needed for formula inquiry and the increment set based on the inquiry of last time expression formula;Receiving module returns to letter for receiving
Breath.In the technical scheme, it is possible to reduce the dependence to context expression formula, it can be true by original expression and increment set
Determine current expression, simplify user's operation, improve the composition efficiency of expression formula, improves storage efficiency.
In the above-mentioned technical solutions, it is preferable that the on-line analysing processing system, comprising: expression interpreter is used for base
It in the original expression and increment set of transmission, is parsed, obtains new expression formula;Autoincrementing operation module, for based on conjunction
At the new expression formula of generation, incremental data information is obtained;Merge and return module, incremental data information for will acquire with
The last time expression formula inquiry data information that increment set includes merges, and returns to the result set for merging and obtaining.In the technology
In scheme, the side of Multidimensional Expressions can be passed through by the analysis to multidimensional data, the operation of user and analysis process system
Formula interacts, but this can generally have increment relation between last time operation, pass through recording increment, it is possible to reduce multidimensional
The storage of model;Buffer efficiency is improved by increment query, and simplifies the operation of user.
In the above-mentioned technical solutions, it is preferable that the incremental data information and increment merged and return module will acquire
The last time expression formula that set includes inquires the operation that data information merges, and further comprises: according to the incremental data of acquisition
Acquisition of information increment cache information, the information cache of the last time operation that the increment cache information that will acquire and increment set include into
Row merges;And/or in the incremental data information of the autoincrementing operation module acquisition, record has the autoincrementing operation information of user.
In the above-mentioned technical solutions, it is preferable that the original expression, specially the expression formula letter of record user's most original
The expression formula of breath.
According to a further aspect of the invention, it is also proposed that a kind of method of Multidimensional Expressions record, comprising: step 202:
Original expression needed for sending the inquiry of this expression formula and the increment set based on the inquiry of last time expression formula, and receive return letter
Breath;Step 204: the original expression based on transmission is parsed, is obtained and merging treatment, and obtained result set is returned.?
In the technical solution, the operation of user can be simplified by the record of inquiry and modification to multidimensional model, improve model storage
Efficiency.
In the above-mentioned technical solutions, it is preferable that the step 202 specifically includes: step 302: sending this expression formula and look into
Original expression needed for asking and the increment set based on the inquiry of last time expression formula;Step 304: receiving return information.In the skill
In art scheme, it is possible to reduce the dependence to context expression formula can determine current table by original expression and increment set
Up to formula, simplify user's operation, improve the composition efficiency of expression formula, improves storage efficiency.
In the above-mentioned technical solutions, it is preferable that the step 204, comprising: step 402: the original expression based on transmission
And increment set, it is parsed, obtains new expression formula;Step 404: based on the new expression formula being synthetically generated, obtaining increment
Data information;Step 406: the last time expression formula that the incremental data information that will acquire and increment set include inquire data information into
Row merges, and returns to the result set for merging and obtaining.In the technical scheme, the analysis to multidimensional data, Yong Huyu can be passed through
The operation of analysis process system can be interacted by way of Multidimensional Expressions, but this generally can between last time operation
There are increment relations, pass through recording increment, it is possible to reduce the storage of multidimensional model;Buffer efficiency is improved by increment query, and
Simplify the operation of user.
In the above-mentioned technical solutions, it is preferable that the incremental data information that the step 406 will acquire includes with increment set
The operation that merges of last time expression formula inquiry data information, further comprise: being obtained according to the incremental data information of acquisition
The information cache of increment cache information, the last time operation that increment cache information and the increment set that will acquire include merges;
And/or in the incremental data information of step 404 acquisition, record has the autoincrementing operation information of user.
In the above-mentioned technical solutions, it is preferable that the original expression, specially the expression formula letter of record user's most original
The expression formula of breath.
By above technical scheme, single object type can be made full use of on the basis of existing expression formula recording mode
The expression formula record for completing more object types establishes general, the unified record that more object type metadatas participate in expression formula record
Thinking.
Detailed description of the invention
Fig. 1 shows the block diagram of the device of the Multidimensional Expressions record of embodiment according to the present invention;
Fig. 2 shows the flow charts of the method for the Multidimensional Expressions of embodiment according to the present invention record;
Fig. 3 shows the flow chart of the client of embodiment according to the present invention;
Fig. 4 shows the flow chart of the on-line analysing processing system of embodiment according to the present invention;
Fig. 5 shows the flow chart of traditional Multidimensional Expressions interaction;
Fig. 6 shows the interactive flow chart with data Stored Procedure of Multidimensional Expressions of embodiment according to the present invention.
Specific embodiment
To better understand the objects, features and advantages of the present invention, with reference to the accompanying drawing and specific real
Applying mode, the present invention is further described in detail.It should be noted that in the absence of conflict, the implementation of the application
Feature in example and embodiment can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, still, the present invention may be used also
To be implemented using other than the one described here other modes, therefore, protection scope of the present invention is not by described below
Specific embodiment limitation.
Fig. 1 shows the block diagram of the device of the Multidimensional Expressions record of embodiment according to the present invention.
As shown in Figure 1, the device 100 that the Multidimensional Expressions of embodiment according to the present invention record, comprising: client 102,
For original expression needed for sending the inquiry of this expression formula and the increment set based on the inquiry of last time expression formula, and receives and return
It writes in reply and ceases;On-line analysing processing system 104 is parsed, is obtained and merging treatment for the original expression based on transmission,
Obtained result set is returned.In the technical scheme, it can simplify and use by the record of inquiry and modification to multidimensional model
The operation at family improves model storage efficiency.
In the above-mentioned technical solutions, it is preferable that client 102 specifically includes: sending module 1022, for sending this
Original expression needed for expression formula inquiry and the increment set based on the inquiry of last time expression formula;Receiving module 1024, for connecing
Receive return information.In the technical scheme, it is possible to reduce the dependence to context expression formula passes through original expression and increment collection
It closes and can determine current expression, simplify user's operation, improve the composition efficiency of expression formula, improve storage efficiency.
In the above-mentioned technical solutions, it is preferable that on-line analysing processing system 104, comprising: expression interpreter 1042 is used
It in original expression and increment set based on transmission, is parsed, obtains new expression formula;Autoincrementing operation module 1044 is used
In based on the new expression formula being synthetically generated, incremental data information is obtained;Merging and return module 1046, the increasing for will acquire
The last time expression formula inquiry data information that amount data information includes with increment set merges, and returns to the result for merging and obtaining
Collection.In the technical scheme, multidimensional can be passed through by the analysis to multidimensional data, the operation of user and analysis process system
The mode of expression formula interacts, but this can generally have increment relation between last time operation, can by recording increment
To reduce the storage of multidimensional model;Buffer efficiency is improved by increment query, and simplifies the operation of user.
In the above-mentioned technical solutions, it is preferable that merge and the incremental data information that will acquire of return module 1046 and increment
The last time expression formula that set includes inquires the operation that data information merges, and further comprises: according to the incremental data of acquisition
Acquisition of information increment cache information, the information cache of the last time operation that the increment cache information that will acquire and increment set include into
Row merges;And/or in the incremental data information of the acquisition of autoincrementing operation module 1044, record has the autoincrementing operation information of user.
In the above-mentioned technical solutions, it is preferable that original expression specially records the expression formula information of user's most original
Expression formula.
Fig. 2 shows the flow charts of the method for the Multidimensional Expressions of embodiment according to the present invention record.
As shown in Fig. 2, the method that the Multidimensional Expressions of embodiment according to the present invention record, comprising: step 202: sending
Original expression needed for the inquiry of this expression formula and the increment set based on the inquiry of last time expression formula, and receive return information;
Step 204: the original expression based on transmission is parsed, is obtained and merging treatment, and obtained result set is returned.At this
In technical solution, the operation of user can be simplified by the record of inquiry and modification to multidimensional model, improve model storage effect
Rate.
In the above-mentioned technical solutions, it is preferable that as shown in figure 3, step 202, specifically includes: step 302: sending this table
Up to original expression needed for formula inquiry and the increment set based on the inquiry of last time expression formula;Step 304: receiving return information.
In the technical scheme, it is possible to reduce the dependence to context expression formula can determine by original expression and increment set
Current expression simplifies user's operation, improves the composition efficiency of expression formula, improves storage efficiency.
In the above-mentioned technical solutions, it is preferable that as shown in figure 4, step 204, comprising: step 402: based on the original of transmission
Expression formula and increment set, are parsed, and new expression formula is obtained;Step 404: based on the new expression formula being synthetically generated, obtaining
Take incremental data information;Step 406: the last time expression formula inquiry data that the incremental data information and increment set that will acquire include
Information merges, and returns to the result set for merging and obtaining.In the technical scheme, can by the analysis to multidimensional data,
The operation of user and analysis process system can be interacted by way of Multidimensional Expressions, but between this operates last time
Can generally there be increment relation, pass through recording increment, it is possible to reduce the storage of multidimensional model;Caching effect is improved by increment query
Rate, and simplify the operation of user.
In the above-mentioned technical solutions, it is preferable that the incremental data information that step 406 will acquire and increment set include upper
The operation that secondary expression formula inquiry data information merges further comprises: obtaining increment according to the incremental data information of acquisition
The information cache of cache information, the last time operation that increment cache information and the increment set that will acquire include merges;With/
Or, record has the autoincrementing operation information of user in the incremental data information that step 404 obtains.
In the above-mentioned technical solutions, it is preferable that original expression specially records the expression formula information of user's most original
Expression formula.
Technical solution of the present invention, the method and apparatus of specially a kind of Multidimensional Expressions record based on state, is applicable in
In in multi-dimensional query is analyzed, record of the user to inquiry and the modification of multidimensional model.Technical solution of the present invention can simplify
The operation of user improves model storage efficiency.
In on-line analysing processing system, core is exactly the analysis to multidimensional data, user and analysis process system
Operation can be interacted by way of Multidimensional Expressions, but this can generally have increment relation between last time operation,
Pass through recording increment, it is possible to reduce the storage of multidimensional model;Buffer efficiency is improved by increment query, and simplifies the behaviour of user
Make.
For traditional Multidimensional Expressions interaction, its process is as shown in Figure 5.Technical solution of the present invention expresses multidimensional
The interactive improvement with data Stored Procedure of formula, referring to Fig. 6.
In Fig. 5, the expression formula of request is sent in on-line analysing processing system by client, is carried out by expression interpreter
Parsing, the main grammer for verifying expression formula, guarantees the correctness of wherein member (including dimension member and index) object, and table
Identifiable interrogation model in background analysis system is parsed into up to formula.Expression formula is mutually indepedent every time, and basic for user returns
It moves back and is completed with autoincrementing operation all in accordance with independent event, without state, the data inquired cannot sufficiently be shared.
In Fig. 6 it will be seen that in the interaction of improved Multidimensional Expressions and increment Stored Procedure, at on-line analysis
In reason system, former expression formula and autoincrementing operation information stacks are used.By expression interpreter, merges and generate new expression formula, root
According to autoincrementing operation acquisition of information incremental data information, incremental data information is merged with last time expression formula inquiry data information, and
Return the result collection.
Technical solution of the present invention obtains realization in analysis platform at present.Applying the technical scheme of the present invention can subtract
Few dependence to context expression formula can determine current expression by original expression and increment set, simplify user behaviour
Make, improve the composition efficiency of expression formula, improves storage efficiency.
The realization of technical solution of the present invention, mainly comprises the following steps:
(1) original expression records the expression formula information of user's most original.
(2) active stack records the autoincrementing operation of user.
(3) expression interpreter generates new-standard cement according to original expression and increment information.
(4) increment caches, and obtains increment caching according to increment information, and merge with the information cache of last time operation.
For golden dish " method and apparatus of Multidimensional Expressions data buffer storage in on-line analysing processing system ", number of patent application
CN200710003018.7, difference is the method and apparatus that former patent emphasizes expression formula data buffer storage, only for expression formula number
According to the method and apparatus that technical solution of the present invention emphasizes the caching of expression formula.
The technical scheme of the present invention has been explained in detail above with reference to the attached drawings, it is contemplated that not easy, system in the related technology
One solution for complicated type expression formula record.Existing expression formula record is unable to complete complicated type participation
Expression formula recording process.Therefore, the invention proposes a kind of devices of Multidimensional Expressions record and a kind of Multidimensional Expressions record
Method, single object type can be made full use of to complete the table of more object types on the basis of existing expression formula recording mode
It is recorded up to formula, establishes general, the unified record thinking that more object type metadatas participate in expression formula record.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.All within the spirits and principles of the present invention, made any to repair
Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.
Claims (2)
1. a kind of device of Multidimensional Expressions record characterized by comprising
Client, for original expression needed for sending the inquiry of this expression formula and the increment collection based on the inquiry of last time expression formula
It closes, and receives return information, the original expression, the specially expression formula of the expression formula information of record user's most original;
The client, specifically includes:
Sending module, for original expression needed for sending the inquiry of this expression formula and the increment based on the inquiry of last time expression formula
Set;Receiving module, for receiving return information;
On-line analysing processing system is parsed, is obtained and merging treatment, will be obtained for the original expression based on transmission
Result set return;
The on-line analysing processing system, comprising:
Expression interpreter is parsed for original expression and increment set based on transmission, obtains new expression formula;
Autoincrementing operation module, the new expression formula for being generated based on the expression interpreter obtain incremental data information;
Merge and return module, the last time expression formula that incremental data information and increment set for will acquire include inquire data
Information merges, and returns to the result set for merging and obtaining;
The last time expression formula inquiry data that the incremental data information and increment set that the merging and return module will acquire include
The operation that information merges further comprises:
Increment cache information is obtained according to the incremental data information of acquisition, increment cache information and the increment set that will acquire include
Last time operation information cache merge;
And/or
In the incremental data information that the autoincrementing operation module obtains, record has the autoincrementing operation information of user.
2. a kind of method of Multidimensional Expressions record characterized by comprising
Step 202: original expression needed for sending the inquiry of this expression formula and the increment set based on the inquiry of last time expression formula,
And return information is received, the original expression, the specially expression formula of the expression formula information of record user's most original;
Step 204: the original expression based on transmission is parsed, is obtained and merging treatment, and obtained result set is returned;
The step 202, specifically includes:
Step 302: original expression needed for sending the inquiry of this expression formula and the increment set based on the inquiry of last time expression formula;
Step 304: receiving return information;
The step 204, specifically includes:
Step 402: original expression and increment set based on transmission are parsed, obtain new expression formula;
Step 404: based on the new expression formula being synthetically generated, obtaining incremental data information;
Step 406: the last time expression formula inquiry data information that the incremental data information that will acquire includes with increment set is closed
And and return and merge obtained result set,
The last time expression formula inquiry data information that the incremental data information and increment set that the step 406 will acquire include carries out
Combined operation further comprises:
Increment cache information is obtained according to the incremental data information of acquisition, increment cache information and the increment set that will acquire include
Last time operation information cache merge;
And/or
In the incremental data information that the step 404 obtains, record has the autoincrementing operation information of user.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410671260.1A CN104408107B (en) | 2014-11-21 | 2014-11-21 | The device and method of Multidimensional Expressions record |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410671260.1A CN104408107B (en) | 2014-11-21 | 2014-11-21 | The device and method of Multidimensional Expressions record |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104408107A CN104408107A (en) | 2015-03-11 |
CN104408107B true CN104408107B (en) | 2018-12-14 |
Family
ID=52645738
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410671260.1A Active CN104408107B (en) | 2014-11-21 | 2014-11-21 | The device and method of Multidimensional Expressions record |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104408107B (en) |
Family Cites Families (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6684207B1 (en) * | 2000-08-01 | 2004-01-27 | Oracle International Corp. | System and method for online analytical processing |
CN102789488B (en) * | 2012-06-29 | 2016-05-04 | 用友网络科技股份有限公司 | Data query treatment system and data query processing method |
US9122755B2 (en) * | 2013-02-26 | 2015-09-01 | Sap Se | Instantaneous incremental search user interface |
CN103455560A (en) * | 2013-08-12 | 2013-12-18 | 曙光信息产业股份有限公司 | Data query method and system |
CN103488688A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Cell data cache system and cell data cache method |
CN104102727B (en) * | 2014-07-23 | 2017-07-04 | 百度在线网络技术(北京)有限公司 | The recommendation method and device of query word |
-
2014
- 2014-11-21 CN CN201410671260.1A patent/CN104408107B/en active Active
Also Published As
Publication number | Publication date |
---|---|
CN104408107A (en) | 2015-03-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Inel et al. | Crowdtruth: Machine-human computation framework for harnessing disagreement in gathering annotated data | |
CN104636257B (en) | The DBAS automated testing method covered based on SQL | |
CN105468929B (en) | Clinical case data collecting system and acquisition method | |
CN103678590B (en) | Report collecting device and report collecting method based on OLAP | |
CN107341098A (en) | Software performance testing method, platform, equipment and storage medium | |
CN108959337A (en) | Big data acquisition methods, device, equipment and storage medium | |
CN107544984A (en) | A kind of method and apparatus of data processing | |
RU2014124207A (en) | METHOD AND METHODS FOR COLLECTING, PROVIDING AND MANAGING INFORMATION ABOUT MEDICAL DIAGNOSTIC PROCEDURES | |
CN108806773A (en) | Medical image cloud storage platform designing method | |
EP2590117A1 (en) | Knowledge based parsing | |
Gupta et al. | Faster as well as early measurements from big data predictive analytics model | |
CN103559300B (en) | The querying method and inquiry unit of data | |
WO2015172478A1 (en) | Method and apparatus for heterogeneous replica management in distributed storage system | |
CN102270232A (en) | Semantic data query system with optimized storage | |
US10515102B2 (en) | Pre-processing of geo-spatial sensor data | |
CN106126629A (en) | A kind of master data management method and system based on live industry | |
CN109815230A (en) | A kind of full-service data center Data Audit method of knowledge based map | |
CN107895013A (en) | Quality of data rule control method and device, storage medium, electronic equipment | |
CN110825641B (en) | Micro-service application test system based on simulation data generator | |
CN108268468A (en) | The analysis method and system of a kind of big data | |
CN104408107B (en) | The device and method of Multidimensional Expressions record | |
CN107066532A (en) | A kind of method and system for generating enterprise's transverse and longitudinal graph of a relation | |
CN109598553A (en) | Questionnaire intelligently tears conjunction method and system open | |
Fagerholm | Radical right and radical left party ideologies: a pan-European mapping of necessary attributes, differences and similarities | |
Pospiech et al. | Big Data--A theory model |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information |
Address after: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
COR | Change of bibliographic data | ||
GR01 | Patent grant | ||
GR01 | Patent grant |