CN103092997A - Linkage query system and linkage query method used for statement analysis - Google Patents

Linkage query system and linkage query method used for statement analysis Download PDF

Info

Publication number
CN103092997A
CN103092997A CN2013100557932A CN201310055793A CN103092997A CN 103092997 A CN103092997 A CN 103092997A CN 2013100557932 A CN2013100557932 A CN 2013100557932A CN 201310055793 A CN201310055793 A CN 201310055793A CN 103092997 A CN103092997 A CN 103092997A
Authority
CN
China
Prior art keywords
area
see
interlock
information
target
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN2013100557932A
Other languages
Chinese (zh)
Other versions
CN103092997B (en
Inventor
陈飞
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yonyou Software Co Ltd
Original Assignee
Yonyou Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Yonyou Software Co Ltd filed Critical Yonyou Software Co Ltd
Priority to CN201310055793.2A priority Critical patent/CN103092997B/en
Publication of CN103092997A publication Critical patent/CN103092997A/en
Application granted granted Critical
Publication of CN103092997B publication Critical patent/CN103092997B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention provides a linkage query system used for statement analysis. The system comprises a relation building unit, a relation judging unit, an information adding unit and a query unit, wherein the relation building unit is used for building linkage relations among any of a plurality of pivot areas in a statement, the relation judging unit is used for judging whether a specified target pivot area is in linkage relation with a source pivot area selected by a user currently, the information adding unit is used for acquiring selected dimensionality information in the source pivot area selected by the user if the specified target pivot area is related to the source pivot area in a linkage mode and adding the dimensionality information to context models, and the query unit is used for processing context information through combination of the context models to generate a query statement for query operation. The invention further provides a linkage query method used for the statement analysis. According to the linkage query system and the linkage query method used for the statement analysis, the dimensionality information in the target source pivot area can be dynamically added to the target pivot area in a linage executing process, and then new dimensionality information is added to the target pivot area based on original dimensionality, and linkage data is enabled to have more business significance.

Description

The interlock inquiry system and the interlock querying method that are used for statement analysis
Technical field
The present invention relates to the data query technique field, in particular to the interlock inquiry system that is used for statement analysis and interlock querying method.
Background technology
Enterprise can produce various in business process, has the different business meaning, the form of different-format.May exist a plurality of see-through area in every form, these see-through area have embodied the business circumstance of enterprise from different angles.When the supvr of enterprise wants to check the data of the different see-through area under a certain specified conditions, need to these independently see-through area connect, and the incidence relation between these see-through area just be referred to as the interlock.
The conventional way that solves this class problem is to set up contact by the attribute that is associated that exists between different see-through area, and by triggering these relating attributes, makes target source represent data under the respective attributes value.But the too simplification of result that this mode represents after can causing linking is unfavorable for that the enterprise operator understands and analyze the data of enterprise comprehensively and accurately.
Therefore, need a kind of new interlock inquiring technology, can be in the process of carrying out interlock, the dimensional information of target source see-through area is added on the see-through area of target dynamically, make the target see-through area on original dimension basis, add new dimensional information, various dimensions, the omnibearing data that represent after interlock make the data after interlock have more the business meaning.
Summary of the invention
The present invention just is being based on the problems referred to above, a kind of new interlock inquiring technology has been proposed, can be in the process of carrying out interlock, the dimensional information of target source see-through area is added on the see-through area of target dynamically, make the target see-through area on original dimension basis, add new dimensional information, various dimensions, the omnibearing data that represent after interlock make the data after interlock have more the business meaning.
In view of this, the present invention proposes a kind of interlock inquiry system for statement analysis, comprising: relation is set up the unit, is used for setting up interaction relation between any a plurality of see-through area of described form; Concern judging unit, be used for when carrying out inquire about the time the target see-through area of appointment judge between the target see-through area of described appointment and the current source see-through area of choosing of user whether have interaction relation; The information adding device, be used in the situation that judgment result is that and be, obtain the dimensional information that described user selects in the described current source see-through area of choosing, and selected dimensional information is added in context model, make the dimensional information of the target see-through area that comprises simultaneously described appointment in described context model and the dimensional information of the described current source see-through area of choosing; Query unit is used for merging by described context model and processes contextual information, with the generated query statement, and utilizes described query statement to carry out query manipulation to the target see-through area of described appointment.
In this technical scheme, by simultaneously to the inquiry that links of the dimensional information of the dimensional information of source see-through area and target see-through area, thereby make the result of inquiry more be conducive to the analysis of business datum.
In technique scheme, preferably, described relation is set up the unit and comprised: regional chooser unit is used for selecting to set up with the source see-through area target see-through area of interaction relation; The information storing sub-units is used for creating the data model of described source see-through area, and the information that all and the existence of described source see-through area maybe need to set up the see-through area of interaction relation is stored in described data model.In this technical scheme, by the establishment data model, thereby realization is to effective storage of the interaction relation between see-through area.
In technique scheme, preferably, described information storing sub-units comprises: the Object Creation module is used for creating the interlock object; Wherein, described information storing sub-units is stored to the information of described target see-through area in described interlock object, and described interlock object is stored in the data model of described source see-through area.In this technical scheme, particularly, realize storage to the interaction relation between a plurality of see-through area by the link mode of object of storage, it is more accurate to make the storage of interaction relation.
In technique scheme, preferably, described information storing sub-units also comprises: the element creation module, be used for creating the interlock element, and described interlock element is kept a list that is used for preserving all interlock objects corresponding with described source see-through area; Wherein, described information storing sub-units is stored in described interlock element in the data model of described source see-through area.In this technical scheme, by store all the interlock objects lists, thereby other see-through area that are associated with the source see-through area are carried out record.
In technique scheme, preferably, also comprise: described query statement is MDX(multi-dimensional expressions, Multidimensional Expressions) statement.
According to another aspect of the invention, also proposed a kind of interlock querying method for statement analysis, having comprised: step 202, set up interaction relation between any a plurality of see-through area in described form; Step 204, in the time need to carrying out inquiry to the target see-through area of appointment, if there is interaction relation in the current source see-through area of choosing of the target see-through area of described appointment and user, obtain the dimensional information that described user selects in the described current source see-through area of choosing, and selected dimensional information is added in context model, make the dimensional information of the target see-through area that comprises simultaneously described appointment in described context model and the dimensional information of the described current source see-through area of choosing; Step 206 merges by described context model and processes contextual information, with the generated query statement, and utilizes described query statement to carry out query manipulation to the target see-through area of described appointment.
In this technical scheme, by simultaneously to the inquiry that links of the dimensional information of the dimensional information of source see-through area and target see-through area, thereby make the result of inquiry more be conducive to the analysis of business datum.
In technique scheme, preferably, described step 202 comprises: selection need to be set up with the source see-through area target see-through area of interaction relation; Create the data model of described source see-through area, and exist the information of the see-through area that maybe needs to set up interaction relation to be stored in described data model all and described source see-through area.In this technical scheme, by the establishment data model, thereby realization is to effective storage of the interaction relation between see-through area.
In technique scheme, preferably, create the interlock object, and the information of described target see-through area is stored in described interlock object; Described interlock object is stored in the data model of described source see-through area.In this technical scheme, particularly, realize storage to the interaction relation between a plurality of see-through area by the link mode of object of storage, it is more accurate to make the storage of interaction relation.
In technique scheme, preferably, also comprise: create the interlock element, described interlock element is kept a list that is used for preserving all interlock objects corresponding with described source see-through area; Described interlock element is stored in the data model of described source see-through area.In this technical scheme, by store all the interlock objects lists, thereby other see-through area that are associated with the source see-through area are carried out record.
In technique scheme, preferably, also comprise: described query statement is the MDX statement.
By above technical scheme, can be in the process of carrying out interlock, the dimensional information of target source see-through area is added on the see-through area of target dynamically, make the target see-through area on original dimension basis, add new dimensional information, various dimensions, the omnibearing data that represent after interlock make the data after interlock have more the business meaning.
Description of drawings
Fig. 1 shows the block diagram of the inquiry system that links according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of the querying method that links according to an embodiment of the invention;
Fig. 3 shows the particular flow sheet of carrying out according to an embodiment of the invention the interlock inquiry;
Fig. 4 shows the structural representation of the functional module that realizes according to an embodiment of the invention the interlock inquiry;
Fig. 5 shows the interface schematic diagram of selecting according to an embodiment of the invention the interlock object;
Before Fig. 6 shows execution interlock inquiry according to an embodiment of the invention, the interface schematic diagram of the MDX information of interlock object and correspondence;
Fig. 7 shows the interface schematic diagram in the source of linking according to an embodiment of the invention;
After Fig. 8 shows execution interlock inquiry according to an embodiment of the invention, the interface schematic diagram of the MDX information of interlock object and correspondence.
Embodiment
In order more clearly to understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.Need to prove, in the situation that do not conflict, the application's embodiment and the feature in embodiment can make up mutually.
A lot of details have been set forth in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not subjected to the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of the inquiry system that links according to an embodiment of the invention.
As shown in Figure 1, the inquiry system 100 that links according to an embodiment of the invention comprises: relation is set up unit 102, is used for setting up interaction relation between any a plurality of see-through area of described form; Concern judging unit 104, be used for when carrying out inquire about the time the target see-through area of appointment judge between the target see-through area of described appointment and the current source see-through area of choosing of user whether have interaction relation; Information adding device 106, be used in the situation that judgment result is that and be, obtain the dimensional information that described user selects in the described current source see-through area of choosing, and selected dimensional information is added in context model, make the dimensional information of the target see-through area that comprises simultaneously described appointment in described context model and the dimensional information of the described current source see-through area of choosing; Query unit 108 is used for merging by described context model and processes contextual information, with the generated query statement, and utilizes described query statement to carry out query manipulation to the target see-through area of described appointment.
In this technical scheme, by simultaneously to the inquiry that links of the dimensional information of the dimensional information of source see-through area and target see-through area, thereby make the result of inquiry more be conducive to the analysis of business datum.
In technique scheme, preferably, described relation is set up unit 102 and comprised: regional chooser unit 1022 is used for selecting to set up with the source see-through area target see-through area of interaction relation; Information storing sub-units 1024 is used for creating the data model of described source see-through area, and the information that all and the existence of described source see-through area maybe need to set up the see-through area of interaction relation is stored in described data model.In this technical scheme, by the establishment data model, thereby realization is to effective storage of the interaction relation between see-through area.
In technique scheme, preferably, described information storing sub-units 1024 comprises: Object Creation module 1024A is used for creating the interlock object; Wherein, described information storing sub-units 1024 is stored to the information of described target see-through area in described interlock object, and described interlock object is stored in the data model of described source see-through area.In this technical scheme, particularly, realize storage to the interaction relation between a plurality of see-through area by the link mode of object of storage, it is more accurate to make the storage of interaction relation.
In technique scheme, preferably, described information storing sub-units 1024 also comprises: element creation module 1024B, be used for creating the interlock element, and described interlock element is kept a list that is used for preserving all interlock objects corresponding with described source see-through area; Wherein, described information storing sub-units 1024 is stored in described interlock element in the data model of described source see-through area.In this technical scheme, by store all the interlock objects lists, thereby other see-through area that are associated with the source see-through area are carried out record.
In technique scheme, preferably, also comprise: described query statement is the MDX statement.
Fig. 2 shows the process flow diagram of the querying method that links according to an embodiment of the invention.
As shown in Figure 2, the querying method that links according to an embodiment of the invention comprises: step 202, set up interaction relation between any a plurality of see-through area in described form; Step 204, in the time need to carrying out inquiry to the target see-through area of appointment, if there is interaction relation in the current source see-through area of choosing of the target see-through area of described appointment and user, obtain the dimensional information that described user selects in the described current source see-through area of choosing, and selected dimensional information is added in context model, make the dimensional information of the target see-through area that comprises simultaneously described appointment in described context model and the dimensional information of the described current source see-through area of choosing; Step 206 merges by described context model and processes contextual information, with the generated query statement, and utilizes described query statement to carry out query manipulation to the target see-through area of described appointment.
In this technical scheme, by simultaneously to the inquiry that links of the dimensional information of the dimensional information of source see-through area and target see-through area, thereby make the result of inquiry more be conducive to the analysis of business datum.
In technique scheme, preferably, described step 202 comprises: selection need to be set up with the source see-through area target see-through area of interaction relation; Create the data model of described source see-through area, and exist the information of the see-through area that maybe needs to set up interaction relation to be stored in described data model all and described source see-through area.In this technical scheme, by the establishment data model, thereby realization is to effective storage of the interaction relation between see-through area.
In technique scheme, preferably, create the interlock object, and the information of described target see-through area is stored in described interlock object; Described interlock object is stored in the data model of described source see-through area.In this technical scheme, particularly, realize storage to the interaction relation between a plurality of see-through area by the link mode of object of storage, it is more accurate to make the storage of interaction relation.
In technique scheme, preferably, also comprise: create the interlock element, described interlock element is kept a list that is used for preserving all interlock objects corresponding with described source see-through area; Described interlock element is stored in the data model of described source see-through area.In this technical scheme, by store all the interlock objects lists, thereby other see-through area that are associated with the source see-through area are carried out record.
In technique scheme, preferably, also comprise: described query statement is the MDX statement.
Fig. 3 shows the particular flow sheet of carrying out according to an embodiment of the invention the interlock inquiry.
As shown in Figure 3, carrying out according to an embodiment of the invention the idiographic flow of inquiring about that links comprises:
Step 302 is selected the see-through area that need to link.
Step 304 builds table interlock element, is kept in the see-through area model.
Step 306, when trigger event occured, the interlock actuator was carried out in the process of interlock, obtains the dimension filtercondition of current click, is added in context.
Step 308, context model merges the dimensional information of source see-through area and target see-through area.
Step 310 is checked the result after interlock.
Some concept explanations related to the present invention in flow process are as follows for carrying out:
The interlock object: the interlock object is used for preserving the information of the see-through area of interlock, as ID(Identity, identification number), title etc.Can access the data of corresponding see-through area by these information.
Interlock element: kept the list of an interlock object, preserved corresponding with it interlock object.The interlock element all is kept in the data model of see-through area itself.A see-through area can have the object of a plurality of interlocks.
MDX: a kind Sql(Structure Query Language, Structured Query Language (SQL)) statement is for the data of inquiry see-through area.
The see-through area model: the data model of see-through area, the information of in store see-through area, as MDX, the information such as see-through area setting, pointer to member attribute.
The interlock actuator: be used for carrying out the implementation procedure of interlock, is mainly the filtering information that obtains the source see-through area, filtering information is put hereinafter supreme, again the target see-through area is inquired about.
Context filtering model: be used for the cube dimension filtering model of stored table condition of contact and perspective table.Which dimension the filtering model of cube dimension is used for explaining exists as contextual filtercondition.
In addition, the step for above-mentioned interlock is carried out also need to prove:
1, can be related arbitrarily with the relation of multi-to-multi between different see-through area, each regional information is kept in the interlock object.Selection need to the target see-through area of source see-through area interlock.
The information of the target see-through area that 2, the first step is obtained is kept in the interlock object, in store all interlock objects associated therewith in the model of source see-through area.
3, first obtain the dimensional information of the current click of source see-through area in interlock actuator implementation, and this information is deposited hereinafter supreme, combine the dimensional information of source see-through area and the dimensional information of target see-through area itself in context this moment.Unify to process context by context model, generate new MDX, this MDX combines dimension filtercondition and original dimensional information.By new MDX, the target see-through area is re-executed query manipulation.
Fig. 4 shows the structural representation of the functional module that realizes according to an embodiment of the invention the interlock inquiry.
As shown in Figure 4, realize that according to an embodiment of the invention the functional module of interlock inquiry comprises that target interlock object arranges module, linkage process execution module, object table enquiry module, wherein:
Target interlock object arranges module: this module is mainly to obtain to carry out with the source see-through area target see-through area of combined operation.The process that realizes is fairly simple, obtains the interlock element in the see-through area model.The information of in store all relevant see-through area in the interlock element.
The linkage process execution module: this module is mainly to obtain the dimensional information of source see-through area by the interlock actuator, and the information that dimension is filtered joins in context model.Merge contextual information by context model, and generate new MDX.New MDX is not only comprising the original Query Information of target see-through area, has also added dynamically the dimensional information of source see-through area.
The object table enquiry module: this module goes to the backstage to re-start the one query operation according to the MDX information that generates in the interlock implementation, and represents the result after inquiry.
When concrete the execution, can adopt as Fig. 5 to human-computer interaction interface shown in Figure 8, thereby be convenient to the user, see-through area and querying condition etc. is selected, thereby realized easily interlock inquiry to see-through area.
Wherein, Fig. 5 shows the interface schematic diagram of selecting according to an embodiment of the invention the interlock object, such as having selected " financial indicating gauge " as the source see-through area in figure.And Fig. 6 correspondingly showed before execution interlock inquiry, the interface schematic diagram of the MDX information of interlock object and correspondence, and wherein, Query Result is " asset-liability ratio=23.73% ".
Correspondingly, Fig. 7 shows the interface schematic diagram in the source of linking according to an embodiment of the invention, links with " date=2011 ".After Fig. 8 correspondingly shows execution interlock inquiry, the interface schematic diagram of the MDX information of interlock object and correspondence, Query Result is " asset-liability ratio=0.00% ".
More than be described with reference to the accompanying drawings technical scheme of the present invention, innovation of the present invention is based on multidimensional analysis, proposed the multidimensional filtering information of interlock source triggering is passed to object table, allow the target see-through area on original basis, combine the filtercondition of source see-through area, represent dynamically Query Result, allow the result of inquiry that the business meaning is more arranged, make the enterprise operator can be more accurate, the data of understanding enterprise more clearly, improved the efficient of enterprise.
The above is only the preferred embodiments of the present invention, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.

Claims (10)

1. an interlock inquiry system that is used for statement analysis, is characterized in that, comprising:
Relation is set up the unit, is used for setting up interaction relation between any a plurality of see-through area of described form;
Concern judging unit, be used for when carrying out inquire about the time the target see-through area of appointment judge between the target see-through area of described appointment and the current source see-through area of choosing of user whether have interaction relation;
The information adding device, be used in the situation that judgment result is that and be, obtain the dimensional information that described user selects in the described current source see-through area of choosing, and selected dimensional information is added in context model, make the dimensional information of the target see-through area that comprises simultaneously described appointment in described context model and the dimensional information of the described current source see-through area of choosing;
Query unit is used for merging by described context model and processes contextual information, with the generated query statement, and utilizes described query statement to carry out query manipulation to the target see-through area of described appointment.
2. interlock inquiry system according to claim 1, is characterized in that, described relation is set up the unit and comprised:
Chooser unit, zone is used for selecting to set up with the source see-through area target see-through area of interaction relation;
The information storing sub-units is used for creating the data model of described source see-through area, and the information that all and the existence of described source see-through area maybe need to set up the see-through area of interaction relation is stored in described data model.
3. interlock inquiry system according to claim 2, is characterized in that, described information storing sub-units comprises:
The Object Creation module is used for creating the interlock object;
Wherein, described information storing sub-units is stored to the information of described target see-through area in described interlock object, and described interlock object is stored in the data model of described source see-through area.
4. interlock inquiry system according to claim 3, is characterized in that, described information storing sub-units also comprises:
The element creation module is used for creating the interlock element, and described interlock element is kept a list that is used for preserving all interlock objects corresponding with described source see-through area;
Wherein, described information storing sub-units is stored in described interlock element in the data model of described source see-through area.
5. the described interlock inquiry system of any one according to claim 1 to 4, is characterized in that, also comprises:
Described query statement is the MDX statement.
6. an interlock querying method that is used for statement analysis, is characterized in that, comprising:
Step 202 is set up interaction relation between any a plurality of see-through area in described form;
Step 204, in the time need to carrying out inquiry to the target see-through area of appointment, if there is interaction relation in the current source see-through area of choosing of the target see-through area of described appointment and user, obtain the dimensional information that described user selects in the described current source see-through area of choosing, and selected dimensional information is added in context model, make the dimensional information of the target see-through area that comprises simultaneously described appointment in described context model and the dimensional information of the described current source see-through area of choosing;
Step 206 merges by described context model and processes contextual information, with the generated query statement, and utilizes described query statement to carry out query manipulation to the target see-through area of described appointment.
7. interlock querying method according to claim 6, is characterized in that, described step 202 comprises:
Selection need to be set up with the source see-through area target see-through area of interaction relation;
Create the data model of described source see-through area, and exist the information of the see-through area that maybe needs to set up interaction relation to be stored in described data model all and described source see-through area.
8. interlock querying method according to claim 7, is characterized in that, also comprises:
Create the interlock object, and the information of described target see-through area is stored in described interlock object;
Described interlock object is stored in the data model of described source see-through area.
9. interlock querying method according to claim 8, is characterized in that, also comprises:
Create the interlock element, described interlock element is kept a list that is used for preserving all interlock objects corresponding with described source see-through area;
Described interlock element is stored in the data model of described source see-through area.
10. the described interlock querying method of any one according to claim 6 to 9, is characterized in that, also comprises:
Described query statement is the MDX statement.
CN201310055793.2A 2013-02-21 2013-02-21 For interlock inquiry system and the interlock querying method of statement analysis Active CN103092997B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201310055793.2A CN103092997B (en) 2013-02-21 2013-02-21 For interlock inquiry system and the interlock querying method of statement analysis

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310055793.2A CN103092997B (en) 2013-02-21 2013-02-21 For interlock inquiry system and the interlock querying method of statement analysis

Publications (2)

Publication Number Publication Date
CN103092997A true CN103092997A (en) 2013-05-08
CN103092997B CN103092997B (en) 2016-03-30

Family

ID=48205562

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310055793.2A Active CN103092997B (en) 2013-02-21 2013-02-21 For interlock inquiry system and the interlock querying method of statement analysis

Country Status (1)

Country Link
CN (1) CN103092997B (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103488692A (en) * 2013-09-02 2014-01-01 用友软件股份有限公司 Data query system and data query method
CN104391928A (en) * 2014-11-21 2015-03-04 用友软件股份有限公司 Device and method for dynamically constructing multi-dimensional model definitions
CN106682064A (en) * 2016-11-03 2017-05-17 用友网络科技股份有限公司 Number picking device and method for enterprise report
CN108153885A (en) * 2017-12-27 2018-06-12 东软集团股份有限公司 Chart interlock method, device, storage medium and electronic equipment
CN109190862A (en) * 2018-06-04 2019-01-11 平安科技(深圳)有限公司 Operational risk interlock method, system, computer equipment and storage medium
CN109241049A (en) * 2018-07-04 2019-01-18 杭州数云信息技术有限公司 A kind of OLAP framework

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107562708B (en) * 2017-08-31 2020-08-11 顾杏春 Report linkage display method and system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120203852A1 (en) * 2006-10-13 2012-08-09 Yahoo! Inc. Systems and methods for establishing or maintaining a personalized trusted social network
US20120254718A1 (en) * 2011-03-30 2012-10-04 Narayan Madhavan Nayar View-independent annotation of commercial data
CN102867068A (en) * 2012-09-28 2013-01-09 用友软件股份有限公司 Report penetration device and report penetration method for online analytical processing system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120203852A1 (en) * 2006-10-13 2012-08-09 Yahoo! Inc. Systems and methods for establishing or maintaining a personalized trusted social network
US20120254718A1 (en) * 2011-03-30 2012-10-04 Narayan Madhavan Nayar View-independent annotation of commercial data
CN102867068A (en) * 2012-09-28 2013-01-09 用友软件股份有限公司 Report penetration device and report penetration method for online analytical processing system

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
刘涛: "计费统计查询子系统的设计与实现", 《万方学位论文全文数据库》 *
熊尧: "报表数据融合系统开发", 《万方学位论文全文数据库》 *

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103488692A (en) * 2013-09-02 2014-01-01 用友软件股份有限公司 Data query system and data query method
CN104391928A (en) * 2014-11-21 2015-03-04 用友软件股份有限公司 Device and method for dynamically constructing multi-dimensional model definitions
CN104391928B (en) * 2014-11-21 2018-08-28 用友网络科技股份有限公司 The device and method that dynamic construction multidimensional model defines
CN106682064A (en) * 2016-11-03 2017-05-17 用友网络科技股份有限公司 Number picking device and method for enterprise report
CN106682064B (en) * 2016-11-03 2020-02-11 用友网络科技股份有限公司 Data acquisition device and method for enterprise report
CN108153885A (en) * 2017-12-27 2018-06-12 东软集团股份有限公司 Chart interlock method, device, storage medium and electronic equipment
CN108153885B (en) * 2017-12-27 2020-09-04 东软集团股份有限公司 Chart linkage method and device, storage medium and electronic equipment
CN109190862A (en) * 2018-06-04 2019-01-11 平安科技(深圳)有限公司 Operational risk interlock method, system, computer equipment and storage medium
CN109241049A (en) * 2018-07-04 2019-01-18 杭州数云信息技术有限公司 A kind of OLAP framework

Also Published As

Publication number Publication date
CN103092997B (en) 2016-03-30

Similar Documents

Publication Publication Date Title
US11941017B2 (en) Event driven extract, transform, load (ETL) processing
CN103092997A (en) Linkage query system and linkage query method used for statement analysis
EP3435257B1 (en) Metadata-based general request translator for distributed computer systems
US20220261413A1 (en) Using specified performance attributes to configure machine learning pipepline stages for an etl job
US10061788B2 (en) Transformation of document flow to contributors network
JP6404820B2 (en) Mechanism for chaining continuous queries
CN102270225B (en) Data change daily record method for supervising and data change daily record supervising device
US10936589B1 (en) Capability-based query planning for heterogenous processing nodes
WO2019143705A1 (en) Dimension context propagation techniques for optimizing sql query plans
CN109690524A (en) Data Serialization in distributed event processing system
CN105138621B (en) A kind of Sybase ASE database configuration optimization system and method
US10909114B1 (en) Predicting partitions of a database table for processing a database query
EP2880556A1 (en) Supporting multi-tenancy in a federated data management system
US20160299827A1 (en) Generating a visualization of a metric at a level of execution
CN102968464A (en) Index-based local resource quick retrieval system and retrieval method thereof
CN106471501A (en) The method of data query, the storage method data system of data object
WO2015041731A1 (en) Interest-driven business intelligence systems including segment data
US10776368B1 (en) Deriving cardinality values from approximate quantile summaries
CN102932416B (en) A kind of intermediate data storage method of information flow task, processing method and device
CN114064707A (en) Data query method and device for data virtualization server and storage medium
CN110309122A (en) Obtain method, apparatus, server and the storage medium of incremental data
CN103365923A (en) Method and device for assessing partition schemes of database
US9727550B2 (en) Presenting a selected table of data as a spreadsheet and transforming the data using a data flow graph
US11755568B1 (en) Execution and consistency model for materialized tables
US8521699B2 (en) Tracking changes across collection of data tables

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 Haidian District North Road, Beijing, No. 68

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
C14 Grant of patent or utility model
GR01 Patent grant