[go: up one dir, main page]

CN102007476A - Query processing visualization system and method for visual query processing - Google Patents

Query processing visualization system and method for visual query processing Download PDF

Info

Publication number
CN102007476A
CN102007476A CN2009801133489A CN200980113348A CN102007476A CN 102007476 A CN102007476 A CN 102007476A CN 2009801133489 A CN2009801133489 A CN 2009801133489A CN 200980113348 A CN200980113348 A CN 200980113348A CN 102007476 A CN102007476 A CN 102007476A
Authority
CN
China
Prior art keywords
query
query processing
information
processing
manager
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN2009801133489A
Other languages
Chinese (zh)
Inventor
S·阿孜孜
V·莫德维诺夫
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.)
International Business Machines Corp
Original Assignee
International Business Machines Corp
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
Priority claimed from CA002629922A external-priority patent/CA2629922A1/en
Priority claimed from US12/104,108 external-priority patent/US8122050B2/en
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Publication of CN102007476A publication Critical patent/CN102007476A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Prevention of errors by analysis, debugging or testing of software
    • G06F11/3604—Analysis of software for verifying properties of programs
    • G06F11/3612—Analysis of software for verifying properties of programs by runtime analysis
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/30—Monitoring
    • G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466—Performance evaluation by tracing or monitoring
    • G06F11/3476—Data logging

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Debugging And Monitoring (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A query processing visualization system includes a visualization module. The visualization module visualizes log information of query processing events that occur during processing of a client query requesting data from one or more data sources by: analyzing the log information to identify dependencies of the query processing events; formatting a visual presentation component representing the recorded information in a hierarchy reflecting the dependencies of the query processing events; and presenting the visual presentation component in the context of the hierarchy of formatted visual presentation components.

Description

The method of query processing visualization system and visual query processing
Technical field
The present invention relates to the method for query processing visualization system and visual query processing.
Background technology
Many mechanisms use data-carrier store to store business data, for example financial data and operation data.In order to help the commercial user to check their data, various data analysis application have been proposed.Those data analysis application provide the various views or the report of data to the user.Data analysis application has query engine, and this query engine accesses data memory is to obtain desired data.Some data analysis application has on-line analysis and handles (OLAP) engine, in order to the multidimensional view of data to be provided.
Those existing query engines and OLAP engine use the parts of engine to obtain desired data, and do not allow external component to participate in the internal logic of query processing.Therefore, these engines can not reuse or with other parts shared functionality.
The reusing of plan logic of device action is provided for the ease of all query manipulations of compiling in single executive plan, laid-open U.S. Patents application publication on the 28th No.US2006/0294076 A1 proposed use query frame frame system Dec in 2006, this query frame frame system is handled has the inquiry that a liaison plan device and a plurality of inquiry service provide device, and above-mentioned U.S. Patent application is incorporated into this by reference.The query frame frame system is handled inquiry and is produced query execution plan, according to this query execution plan, utilizes relevant inquiry service to provide device to carry out inquiry.When going wrong in the inquiry implementation, for debugging problem, the user need understand the details of query processing.
Therefore, expectation provides a kind of instrument, and this instrument provides the visable representation to query processing, notes the query processing problem to help the user.
Summary of the invention
The present invention uses the query processing visualization interface of the specific format view that query processing can be provided.
One object of the present invention is to provide the method for improved query processing visualization system and visual query processing.
According to an aspect of the present invention, a kind of query processing visualization system that comprises visualization model is provided, and this visualization model is used for visual record (logging) information in the query processing incident that process took place that request is handled from the client query of the data of one or more data sources.This visualization model comprises that recorded information analyzer, event sequence formatter and method call present manager.The recorded information analyzer is provided for analytic record information, with the dependence of identification query processing incident.The event sequence formatter is provided for the visual parts that present that format the expression recorded information by the dependent level of reflection query processing incident.Method call presents manager and is provided under the environment by the level of the formative visual part of event sequence formatter and presents the visual parts that present.
A kind of method of visual query processing is provided according to a further aspect in the invention.This method comprises the steps: to analyze the recorded information of the query processing incident that is taken place in the process that request is handled from the client query of the data of one or more data sources, thus the dependence of identification query processing incident; Format the visual parts that present of expression recorded information by the dependent level of reflection query processing incident; And under environment, present the visual parts that present by the level of the formative visual part of formatting step.
According to a further aspect in the invention, provide a kind of computer-readable medium that comprises computer executable instructions, wherein computer executable instructions can be read and executed by a computer, and is used to carry out the method for visual query processing.This method comprises the steps: to analyze the recorded information of the query processing incident that is taken place in the process that request is handled from the client query of the data of one or more data sources, thus the dependence of identification query processing incident; Format the visual parts that present of expression recorded information by the dependent level of reflection query processing incident; And under environment, present the visual parts that present by the level of the formative visual part of formatting step.
From first aspect, the invention provides a kind of query processing visualization system that comprises visualization model, this visualization model is used for visual recorded information in the query processing incident that process took place that request is handled from the client query of the data of one or more data sources, this visualization model comprises: the recorded information analyzer is used for the dependence of analytic record information with identification query processing incident; The event sequence formatter is used for formaing the visual parts that present of representing recorded information by the dependent level of reflection query processing incident; And method call presents manager, is used for presenting the visual parts that present under the environment by the level of the formative visual part of event sequence formatter.
Preferably, the invention provides a kind of query processing visualization system, wherein the recorded information analyzer also comprises the recorded information of analyzing with the main corresponding method call of query processing incident, and the dependence called of recognition methods; The event sequence formatter also comprises the visual parts that present of dependent level format by the reflection method call; And present the visual parts that present under the environment of method call presents that manager is included in also that method for expressing calls the visual level that presents parts.
Preferably, the invention provides a kind of query processing visualization system, wherein the recorded information analyzer also comprises the recurrence dependence that analytic record information is called with recognition methods; The event sequence formatter also comprises recurrence dependence manager, be used for will the method call that recursively calls of expression the visual parts that present be formatted as collapsible (collapsible) parts; Also comprise and present foldable part and method call presents manager so that visually present to the method for setting the tone with degree of depth place.
Preferably, the invention provides a kind of query processing visualization system, wherein the event sequence formatter comprises that also transform method calls manager, is used to open the macro operation tree of method of structure of macro operation tree of having represented conversion.
Preferably, the invention provides a kind of query processing visualization system, wherein: the recorded information analyzer also comprises the recorded information of extracting the event handling information that comprises method call; And method call presents manager and also comprises the process information adder, is used for process information is added to the visual part of this method call of expression.
Preferably, the invention provides a kind of query processing visualization system, wherein process information comprises the consumption time and/or the memory consumption of method call.
Preferably, the invention provides a kind of query processing visualization system, wherein the process information adder highlights process information in presenting.
Preferably, the invention provides a kind of query processing visualization system, wherein method call presents manager and also comprises the parts marker manager, be used to utilize method title, container object title and provide the title of service provider of the processing service of this method to come mark to represent the parts that present of method call.
Preferably, the invention provides a kind of query processing visualization system, wherein the recorded information analyzer also comprises the recorded information of extracting the parameter information that comprises method call; And method call presents manager and also comprises the parameter information adder, is used for the visit of the parameter information of method call being added to the visual part of this method call of expression.
Preferably, the invention provides a kind of query processing visualization system, wherein the parameter information adder comprises that also adding input parameter visit, output parameter visit and/or return parameters visits.
Preferably, the invention provides a kind of query processing visualization system, wherein the parameter information manager also comprises macro operation tree manager, be used to present the macro operation tree that expression comprises the parameter of inquiry framework inquiry, wherein inquire about the framework inquiry and can carry out by one or more query processing service providers of the inquiry framework of handling client query.
Preferably, the invention provides a kind of query processing visualization system, wherein macro operation comprises the Query Result definition, inquires about and/or provides the device inquiry.
Preferably, the invention provides a kind of query processing visualization system, wherein method call presents manager and comprises the execution Options Manager, is used for allowing to carry out the inquiry of inquiry framework, and is used to present the view of the Query Result that comprises execution.
Preferably, the invention provides a kind of query processing visualization system, wherein macro operation tree manager comprises macro operation management in details device, is used for exposing with predetermined format the structure of the macro operation of finishing the macro operation definition.
Preferably, the invention provides a kind of query processing visualization system, wherein the recorded information analyzer comprises the recorded information of extraction as the resultant query execution plan of inquiry plan processing, and this query execution plan comprises can be by the macro operation of query processing service provider execution; The event sequence formatter also comprises the visual parts that present of the executable macro operation of format expression, so that the expression query execution plan; Also comprise and present the visual parts that present that are used to confirm executive plan and method call presents manager.
Preferably, the invention provides a kind of query processing visualization system that also comprises logging modle, this logging modle comprises: the incident catcher is used for catching the query processing incident that process took place handling client query; The method call recognizer, the main query processing event recognition that is used for the query processing incident that will be captured is a method call; And record element manager, be used for each method call is recorded as by the record element representation.
From another aspect of the present invention, the invention provides a kind of method of visual query processing, this method comprises the steps: to analyze the recorded information of the query processing incident that is taken place in the process that request is handled from the client query of the data of one or more data sources, thus the dependence of identification query processing incident; Format the visual parts that present of expression recorded information by the dependent level of reflection query processing incident; And under environment, present the visual parts that present by the level of the formative visual part of formatting step.
Preferably, the invention provides a kind of method, wherein analytical procedure also comprises the recorded information of analyzing with the main corresponding method call of query processing incident, and the dependence called of recognition methods; Formatting step comprises that also the dependent level by the reflection method call formats the visual parts that present; And rendering step also is included under the environment of level of the visual part that method for expressing calls and presents the visual parts that present.
Preferably, the invention provides a kind of method, wherein analytical procedure also comprises the recurrence dependence that recognition methods is called; Formatting step comprises that also the visual parts that present of the method call that expression is recursively called are formatted as foldable part; And rendering step also comprises and presents foldable part, so that visually present to the method for setting the tone with degree of depth place.
Preferably, the invention provides a kind of method, wherein rendering step also comprises and opens the macro operation tree of method of structure of macro operation tree of having represented conversion.
Preferably, the invention provides a kind of method, wherein analytical procedure also comprises the recorded information of extracting the event handling information that comprises method call; And rendering step also comprises the visual part that process information is added to this method call of expression.
Preferably, the invention provides a kind of method, wherein rendering step also comprises consumption time and/or the memory consumption that adding method calls.
Preferably, the invention provides a kind of method, wherein formatting step also comprises the title of the title of utilizing method, container object and provides the title of service provider of the processing service of this method to come mark to represent the parts that present of method call.
Preferably, the invention provides a kind of method, wherein: analytical procedure also comprises the recorded information of extracting the parameter information that comprises method call; And rendering step also comprises and will the visit of the parameter information of method call be added to the visual part of this method call of expression.
Preferably, the invention provides a kind of method, wherein parameter information adds step and comprises also and present the macro operation tree that expression comprises the parameter of inquiry framework inquiry that this inquiry framework inquiry can be carried out by one or more query processing service providers of the inquiry framework of handling client query.
Preferably, the invention provides a kind of method, wherein macro operation tree rendering step also comprises provides the execution option, is used to allow to inquire about the execution of framework inquiry, and is used to present the view of the Query Result that comprises execution.
Preferably, the invention provides a kind of method, wherein analytical procedure also comprises the recorded information of acquisition as the resultant query execution plan of inquiry plan processing, and this query execution plan comprises can be by the macro operation of query processing service provider execution; Formatting step also comprises the visual parts that present of the executable macro operation of format expression, with the expression query execution plan; And rendering step also comprises and presents the visual parts that present that are used to confirm executive plan.
Preferably, the invention provides a kind of method, this method also comprises the step by following acquisition recorded information: catch the query processing incident that is taken place in the process of handling client query; With the main query processing event recognition in the query processing incident that is captured is method call; Reach each method call is recorded as by the record element representation.
On the other hand, the invention provides the computer program in a kind of internal storage that is loaded into digital machine, this computer program comprises the software code part, and this software code part is carried out in order to realize aforesaid invention when described product moves on computers.
Description of drawings
Specifically describe embodiments of the present invention below with reference to accompanying drawing as just example, in the accompanying drawing:
Fig. 1 illustrates the block diagram of query processing visualization system according to the preferred embodiment of the present invention;
Fig. 2 is the block diagram that the example of query frame frame system is shown;
Fig. 3 is the figure that the example of query tree is shown;
Fig. 4 is the figure that the example of query frame frame system is shown;
Fig. 5 is the figure that the embodiment of query processing visualization system is shown;
Fig. 6 is the figure of embodiment that the logging modle of query processing visualization system is shown;
Fig. 7 is the example of query processing daily record (log);
Fig. 8 is the figure of embodiment that the visualization model of query processing visualization system is shown;
Fig. 9 is the example through the senior expression of formative query processing daily record;
Figure 10 illustrates the figure that method call presents the embodiment of manager;
Figure 11 is the example that visualization method calls;
Figure 12 is the example that the XML of parameter represents;
Figure 13 is the example of macro operation tree;
Figure 14 is the example of the Query Result view of inquiry framework inquiry;
Figure 15 is the example of opening that the macro operation tree is shown;
Figure 16 is the example of the tree schema of macro operation;
Figure 17 is another example of the tree schema of macro operation;
Figure 18 is another example of the tree schema of macro operation;
Figure 19 is the example of macro operation details;
Figure 20 is another example of macro operation details;
Figure 21 is another example of macro operation details;
Figure 22 is the example of the view of query execution plan;
Figure 23 is the figure that the example of inquiring about the flow process of carrying out is shown;
Figure 24 is an example of confirming request;
Figure 25 is the example of the affirmation request after the conversion;
Figure 26 is an example of confirming the request command report;
Figure 27 is an example of confirming the request response; And
Figure 28 is the example of Query Information string.
Embodiment
With reference to figure 1, the query processing visualization system 100 according to the embodiment of the present application has been described.Query processing visualization system 100 is suitable for being used in the open system of loosely-coupled query processing parts.In the embodiment shown in fig. 1, the query frame frame system 10 of query processing visualization system 100 in being used in report server 20 worked.Query frame frame system 10 is provided for from data analysis system 30 and receives user inquiring, and handles received user's request, so that the data of utilizing metadata schema 22 to be asked from one or more data source 40 retrievals.These systems may be suitable for being used in the client-server environment.
Query analysis system 30 provides the various views of data in the data source 40 so that allow the application system of customer analysis data.When user's request msg view, query analysis system 20 produces user's request.In order to produce user's request, query analysis system 20 can use the metadata schema 22 of the metadata that comprises data source 40.The user asks to adopt query analysis system 20 to be used for sending the form of the query language of user's request.
User's request that 10 interceptions of query frame frame system are produced by data analysis system 30.It handles and carries out this user's request, so that from data source 40 retrieval desired data.
As shown in Figure 2, query frame frame system 10 has a plurality of query processing parts 12.Query processing parts 12 comprise that group polling operation provides device 15 and a liaison plan device 16.Query processing parts 12 are shared the common interface 14 and the common query language of query frame frame system 10.Query processing parts 12 are insertable.
Each query manipulation provides device 15 to carry out specific operation to inquiry, as following further example.In Fig. 2,, show three query manipulations device 15 is provided for illustration.In query frame frame system 10, can there be more or less query manipulation that device is provided.
Routine as shown in FIG. 3, query frame frame system 10 uses inquiry frameworks (QF) inquiry 50.The role of query specification is played the part of in QF inquiry 50, and wherein query manipulation provides device 15 to use this standard to communicate with one another, and provides device (OQP) 74 and the inquiry of seller's inquiry (VQ) planner to provide device 76 to communicate by letter with (RQP) 72, the inquiry of OLAP planner.Service provider 80 provides local search operation, and with query block that other parts are associated on produce the device inquiry be provided.In this example, query frame frame system 10 has local tabulation operation provides device 82, the local execution to provide device 84 and many cubes (multicube) to unite device 86 is provided.In order to allow other query manipulation that inquiry after device uses conversion is provided, query transformation provides device 90 to be responsible for pre-service QF inquiry.In this example, query frame frame system 10 has the definition of standard Query Result provides device 92, inquiry refining to provide device 94, query decomposition to provide device 96 and query optimization that device 98 is provided.
Query processing visualization system 100 provides visual to query processing.Query processing comprises inquiry plan and inquiry execution.
As shown in Figure 5, query processing visualization system 100 comprises visualization model 140.In this embodiment, query processing visualization system 100 is worked with the logging modle 120 that provides in these query processing visualization system 100 outsides.In other embodiments, logging modle 120 can be the part of query processing visualization system 100.
The recorded information of the query processing incident that logging modle 120 acquisitions are taken place in the process of the client query of handling request msg.At the embodiment that query frame frame system 10 has writing function and is used for stored record recording of information information storage unit, logging modle 120 can obtain recorded information from the recorded information reservoir of query frame frame system 10.
Fig. 6 shows the embodiment that logging modle 120 wherein provides writing function.In this embodiment, logging modle 120 has incident catcher 122, method call recognizer 124 and record element manager 126.Incident catcher 122 is caught the query processing incident that takes place in query frame frame system 10.Incident catcher 122 has the parameter catcher 132 of the recorded information that is used for the parameter that method for catching calls.The main event recognition that method call recognizer 124 will capture is calling of docking port method.The recursion method that method call recognizer 124 has the method call that is used to discern recurrence calls recognizer 134.Record element manager 126 is log in inquiry framework journal file, to reflect the incident that is captured.Record element manager 126 has the daughter element manager 136 of the record that is used for managing daughter element.
The structure of daily record is to be driven by the sequential affair that takes place in query frame frame system 10.Some information that record element manager 126 should write down are write in the daily record at once, make record not need any information and remain in the storer and wait at record in addition of suitable time.On the other hand, although the execution of method call may cause taking place other incident that should write down in query frame frame system 10, record element manager 126 is write some information after method is finished, for example the content of the method output parameter of method.
In one embodiment, record element manager 126 is with XML format record information.Record element manager 126 recorded informations make each inquiry framework interface method call all by the XML element representation.The input and output parameter of parameter catcher 132 method for catching, and the parameter in the daughter element of daughter element manager 136 recording methods.The dependence of the structure presentation of events of XML form.It is recurrence that other great majority of inquiring about the framework interface method are called, that is, they call other method as the part of its realization.Recursion method calls the method call of recognizer 134 identification recurrence, and daughter element manager 136 is recorded as the submethod element with the method call of recurrence.
Fig. 7 shows the example by the part of the query processing event log of the method call of logging modle 120 or query frame frame system 10 records.Even call for single, in fact the amount of the daily record data that is captured also is huge and inundatory for the user is used for analyzing, and this is very typical.
Information in the visualization model 140 visual query processing event logs.It serves as a kind of instrument, make and to carry out top-down analysis to recorded information, help identification to be responsible for the journal file part of given conversion, corresponding record data (for example, input and output parameter) to be gathered together, reflects order that device calls and/or the value that maximizes recorded information are provided in inquiry plan and the execute phase process.
Fig. 8 shows the embodiment of visualization model 140, and this visualization model comprises that recorded information analyzer 150, event sequence formatter 160 and method call present manager 180.
The recorded information of recorded information analyzer 150 analysis and consult processing events.The dependence of its identification query processing incident or method call.The parameter information of the dependent information of recurrence, event handling information and/or method call that recorded information analyzer 150 can extracting method calls.
Event sequence formatter 160 formats the visual parts that present of expression recorded information by the dependent level of reflection method call.It will represent that the visual part of the method recursively called is rendered as foldable part, make visually to present to set the tone with the method at degree of depth place or belong to the method for given method call subtree.Event sequence formatter 160 has recurrence dependence manager 164, is used for formaing the visual parts that present that method for expressing calls by the dependent level of reflection recurrence.The event sequence formatter can also have the manager 166 that transform method calls, and the ability of these macro operations trees of the method for the structure of having opened at conversion the macro operation tree is provided.Generally speaking, transform method calls manager 166 and the content and the output parameter of the input parameter preparing to call can be compared.If these parameter differences, then transform method calls manager 166 and can use it as the indication that conversion has taken place.Except in order to optimize, also being desirably in provides device can return null response under the situation that does not apply conversion.Transform method calls manager 166 and can use those null responses to detect the indication that conversion does not take place at visual logic.In case applied, then the order of utilizing the QueryPrepare method call of opening of macro operation tree clearly illustrates that inquiry plan logic in proper order, selects the method call that in fact those changed query structure and returned for wherein visual in response parameter.
Method call presents the parts that manager 180 rendering method under by the environment of the level of event sequence formatter 160 formative visual parts calls recorded information.
Fig. 9 shows the example to the senior expression of recorded information by the dependent level of reflection method call.This form is suitable for solving the demand that record data are analyzed.Senior expression only shows method call.The recurrence dependence of method call is to reflect in the level corresponding to the visual part of method.The method recursively called of expression visual present parts can be fold or open, make the method for calling degree of depth place that only shows expectation.Each visual parts that present of representing each method are to utilize the title of its title, container object and provide the title of device visually to discern.
Figure 10 shows the embodiment that method call presents manager 180, and wherein method call presents manager 180 and has process information adder 182, is used for the process information of method call is added to the visual part of this method call of expression.Process information can be the statistical information of the processing of method call, for example the consumption time and/or the memory consumption of method call.Process information adder 182 can highlight process information in presenting, make the performance of no matter when investigating query frame frame system 10 all to be easy to be concerned about this information.
As shown in figure 10, method call presents manager 180 can also have parts marker manager 184, be used to utilize method title, container object title and/or provide the title that device is provided of the processing service of method to come mark to represent that the method call of method call presents parts.
As shown in figure 10, method call presents manager 180 and has parameter information adder 190.Parameter information adder 190 will add the visual part of this method call of expression to the visit of the parameter information of method call.Parameter information can comprise the information of input parameter, output parameter and/or return parameters.Therefore, the visual start-up point of also serving as its input and output parameter of further analysis of call method.Parameter information adder 182 can add input parameter visit, output parameter visit and/or return parameters visit.Parameter information adder 182 only can show the visit to the non-NULL parameter value.In the time of one in these visits of selection, present associated parameter value.
Figure 11 shows the example that presents with method call that parameter information is conducted interviews.This visual start-up point of serving as its input and output parameter of further analysis of method call.As shown in figure 12, click parameter type and open the value that is delivered to given method call.Parameter can have XML and represent.
As shown in figure 10, method call presents manager 180 and also can have macro operation tree manager 192.Macro operation tree manager 192 presents the macro operation tree that expression comprises the parameter of QF inquiry.
Parameter value can be the QF inquiry.As described above in reference to Figure 3, query frame frame system 10 is regarded inquiry as the combination of macro operation.Have only the macro operation of several types, comprising: with the operation that SQL query is represented, this is the responsibility that relational query provides device (RQP); Express the operation that (MDX) inquiry is represented with multidimensional, this is the responsibility that the OLAP inquiry provides device (OQP); The operation of dynamic cube of structure, it can be characterized and be the responsibility that cube makes up provides device by cube structure; And a plurality of local operations of handling, for example report the operation of device pattern seam, null suppression operation and/or the operation of master-details.The parameter of method call can comprise the inquiry of inquiry framework, and this is the combination of macro operation.
Utilize macro operation tree manager 192, method call presents the tree that manager 180 can also be shown as the parameter that comprises the QF inquiry macro operation.The macro operation tree can comprise expression Query Result definition (QRD), inquires about and/or provide the node of device inquiry.Figure 13 shows the example that presents of this macro operation tree.In this example, the node of macro operation tree comprises QRD and inquiry.Node in the macro operation tree can differently present according to action type, and is for example, differently painted.Can to be chosen to the parameter value to comprising QF inquiry be default in the expression of the macro operation of example among Figure 13, because it provides the effective senior description of request content.This view can show that the logical micro-operations that comprises QRD and inquiry sets the conversion of physical operations tree (that is, providing the device inquiry).
As further illustrating among Figure 10, method call presents manager 180 can have the Options Manager 194 of execution, the view that allows to carry out the inquiry of inquiry framework and be used to present the Query Result that comprises execution.Figure 13 also shows the example of " execution " option, should start the given QF inquiry of execution by " execution " option, in case and the ready view that comprises Query Result that just switches to of Query Result, as example among Figure 14.Browse queries result allows further to understand the semanteme that is delivered to the inquiry of limiting-members.This functional another important application is the ability of the intermediate result of physical operations in the checking executive plan.
As example among Figure 15, have the macro operation of opening and set the main query transformation pattern that the visual inspection of the journal file of transform block also allows the given request of User Recognition be comprised.For example, the macro operation tree schema shown in Figure 16 indicates dynamic cube to be occupied by a plurality of data stream.Pattern shown in Figure 17 is the example of indicator that occupies the optimization of dynamic cubical tabulation inquiry.Another example is the pattern shown in Figure 18, and its indication inquiry has the operation of report device pattern.
In case planned inquiry, query execution plan is exactly the net result that inquiry plan is handled.During this time, the QF inquiry of expression query execution plan includes only the physics macro operation that the device execution can be provided by query manipulation.The order of these operations has determined that they are in the order of calling of execute phase with from a data stream of operating another operation in the macro operation tree.The physics macro operation is expressed with providing device to inquire about.Each provides device inquiry and responsible certain of operating execution to provide device related.
Therefore, in case planned inquiry, the macro operation tree just only comprises the providerQuery node.Strategy at inquiry plan is that operation as much as possible is shifted onto among the embodiment of underlying database, and the OLAP inquiry that the relational query that the main operation in this tree is based on SQL provides device (RQP) operation and mainly expresses (MDX) based on multidimensional provides device (OQP) operation.These operations oneself can be complicated and combination that comprise the better operation of understanding of needs.By these operations being rendered as the macro operation tree, visualization system 100 helps the user to understand and analyzes macro operation, and does not need to understand query frame frame system 10.
Generally speaking, most of macro operations all have certain inner structure of in fact finishing its definition.Macro operation tree manager 192 can also have macro operation management in details device 198, is used for being exposed this structure by the form that the potential user of wide scope understands.For example, Figure 19 to 21 shows the example of form that macro operation management in details device 198 is used for representing the details of RQP, OQP and CubeBuildProvider node.Visualization system 100 is by the SQL view, and for example Cognos SQL, local SQL and inquiry framework inquiry view present the details that RQP operates, routine as shown in Figure 19.Visualization system 100 utilizes the dynamic cubical structure at given inquiring structuring to present the CubeBuildProvider operation, routine as shown in Figure 20.The local MDX that visualization system 100 passes through to be produced presents the OQP details of operation, routine as shown in Figure 21.Macro operation management in details device 198 can provide other view, and for example expression can be checked from the result's of the given operation of a data stream of operating another operation view.
Visualization system 100 provides and also has been suitable for the query execution plan view of being reported that the author uses.Executive plan is exposed significantly the seeing clearly of data volume that any set point place consumption of operation essence, their performance and inquiry execution related during inquiry/report handled can be provided to the report author.In general, the report author understands the inside of query frame frame system 10 to needs or the inquiry framework of query engine architecture provides the notion of device to be unfamiliar with.Visualization system 100 provides the view of the query execution plan of representing by more extensively known notions (for example SQL query standard, MDX query specification and cube creation operation).Therefore, not in executive plan visual, to use the notion that the device inquiry is provided, visualization system 100 utilizes their prime responsibility mark macro operation, perhaps in other words, for being that each macro operation provides senior title or mark intuitively to the report author.Figure 22 shows the example of the view with this senior title.
Figure 23 is the figure that illustrates by the example of the flow process of reporting the view that the author asks executive plan.The report author asks to browse executive plan in data analysis system 30.Data analysis system 30 will confirm that request 200 sends to report server 20.XMLAPI after report server 20 will be changed confirms that request 202 sends to query frame frame system 10.Query frame frame system 10 is handled request and is produced executive plan, and will comprise that the XML API response 204 of this executive plan returns to report server 20.Report server 20 converts thereof into to be confirmed response 206 and returns to data analysis system 30, and data analysis system 30 sends to executive plan 208 visualization model 140 of query processing visualization system 100 again, in order to present to the report author.
For example, data analysis system 30 uses the affirmation request of expressing with SOAP request form.In order correctly to indicate the request to executive plan, the SOAP that data analysis system 30 sends requestProperty=ExecutionPlan confirms request or orders 200.Report server 20 will confirm that request 200 converts QF XML API request to or orders 202, and as shown in Figure 25, the request severity level is the message of " information " and the number that also has request attribute.QF XML API request 202 comprises＜property name=" QFExecutionPlan " 〉.The request attribute collection does not comprise the execution attribute of the request of being supported by the QF XMLAPI shown in Figure 26.
Query frame frame system 10 is handled and is confirmed request and produce to comprise＜property name=" QFExecutionPlan "〉QF XML API response 204.Report server 20 receives these responses, and convert thereof into request is comprised＜queryInfo the SOAP of the affirmation request of the Query Information of details under the element confirms response 206, as shown in figure 27, wherein QUERY INFO is the XML string of coding.Executive plan is the part of this Query Information XML, as shown in figure 28.
So that the unprocessed form of device query tree to be provided, the SOAP that data analysis system 30 receives the executive plan that comprises the XML form confirms response 206.This executive plan XML 208 is sent to the visualization model 140 of query processing visualization system 100, and this visualization model 140 formats executive plan XML as described above and presents through formative executive plan.By supporting the visual dynamic attribute of executive plan, visualization model 140 also provides the inquiry plan analytic function: folding and expansion is operated tree, opened nodes properties view and is started the execution of plan subtree.
Query processing visualization system of the present invention can be realized by the combination of any hardware, software or hardware and software with above-mentioned functions.Software code can be stored in the computer-readable memory in whole or in part.Computer data signal that can realize in carrier wave in addition,, the expression software code can transmit by communication network.This computer-readable memory and computer data signal and hardware, software and its combination are also within the scope of the invention.
The present invention is described about one or more embodiment.But, to one skilled in the art, in not deviating from, can make various changes and modifications under the situation of the defined scope of the invention obviously as claim.

Claims (29)

1.一种查询处理可视化系统，包括：1. A query processing visualization system comprising: 可视化模块，用于可视化在对请求来自一个或多个数据源的数据的客户端查询进行处理的过程中所发生的查询处理事件的记录信息，该可视化模块包括：A visualization module for visualizing recorded information of query processing events that occur during processing of client queries requesting data from one or more data sources, the visualization module comprising: 记录信息分析器，用于分析记录信息，以便识别查询处理事件的依赖性；a record information analyzer for analyzing record information in order to identify dependencies of query processing events; 事件顺序格式化器，用于按反映查询处理事件的依赖性的层次来格式化表示记录信息的可视呈现部件；及an event sequence formatter for formatting visual presentation components representing record information in a hierarchy reflecting dependencies of query processing events; and 方法调用呈现管理器，用于在由事件顺序格式化器格式化的可视呈现部件的层次的环境下呈现可视呈现部件。Method invokes the rendering manager for rendering the visual rendering component within the context of the hierarchy of visual rendering components formatted by the event sequence formatter. 2.如权利要求1所述的查询处理可视化系统，其中：2. The query processing visualization system of claim 1, wherein: 记录信息分析器还包括分析与主要查询处理事件相对应的方法调用的记录信息，以及识别方法调用的依赖性；The record information analyzer also includes analyzing record information of method calls corresponding to main query processing events, and identifying dependencies of method calls; 事件顺序格式化器还包括按反映方法调用的依赖性的层次来格式化可视呈现部件；及The sequence of events formatter also includes formatting the visual presentation components in a hierarchy reflecting the dependencies of the method calls; and 方法调用呈现管理器还包括在表示方法调用的可视呈现部件的层次的环境下呈现可视呈现部件。The method call rendering manager also includes rendering the visual rendering component within the context of the hierarchy of visual rendering components representing the method call. 3.如权利要求2所述的查询处理可视化系统，其中：3. The query processing visualization system of claim 2, wherein: 记录信息分析器还包括分析记录信息以识别方法调用的递归依赖性；The record information analyzer also includes analyzing record information to identify recursive dependencies of method calls; 事件顺序格式化器还包括递归依赖性管理器，用于将表示递归地调用的方法调用的可视呈现部件格式化成可折叠部件；及The sequence of events formatter also includes a recursive dependency manager for formatting visual presentation components representing recursively invoked method calls into collapsible components; and 方法调用呈现管理器还包括呈现可折叠部件以使得可视地呈现给定调用深度处的方法。The method call rendering manager also includes rendering an accordion to visually render a method at a given call depth. 4.如权利要求2所述的查询处理可视化系统，其中事件顺序格式化器还包括变换方法调用管理器，用于打开表示变换了宏操作树的结构的方法的宏操作树。4. The query processing visualization system of claim 2, wherein the event sequence formatter further comprises a transform method call manager for opening a macro operation tree representing a method that transforms the structure of the macro operation tree. 5.如权利要求2所述的查询处理可视化系统，其中：5. The query processing visualization system of claim 2, wherein: 记录信息分析器还包括提取包括方法调用的事件处理信息的记录信息；及The log information analyzer also includes extracting log information including event handling information for method calls; and 方法调用呈现管理器还包括处理信息添加器，用于将处理信息添加到表示方法调用的可视部件。The method call rendering manager also includes a handle information adder for adding handle information to the visual component representing the method call. 6.如权利要求5所述的查询处理可视化系统，其中处理信息包括方法调用的耗用时间和/或存储器消耗。6. The query processing visualization system of claim 5, wherein processing information includes elapsed time and/or memory consumption of method calls. 7.如权利要求5所述的查询处理可视化系统，其中处理信息添加器在呈现中突出显示处理信息。7. The query processing visualization system of claim 5, wherein the processing information adder highlights the processing information in the presentation. 8.如权利要求2所述的查询处理可视化系统，其中方法调用呈现管理器还包括部件标记管理器，用于利用方法的名称、容器对象的名称和提供方法的处理服务的服务提供器的名称来标记表示方法调用的呈现部件。8. The query processing visualization system of claim 2, wherein the method call presentation manager further comprises a component tag manager for utilizing the name of the method, the name of the container object, and the name of the service provider that provides the processing service for the method to mark the rendered widget that represents a method call. 9.如权利要求2所述的查询处理可视化系统，其中：9. The query processing visualization system of claim 2, wherein: 记录信息分析器还包括提取包括方法调用的参数信息在内的记录信息；及The record information analyzer also includes extracting record information including parameter information of method calls; and 方法调用呈现管理器还包括参数信息添加器，用于将对方法调用的参数信息的访问添加到表示方法调用的可视部件。The method call presentation manager also includes a parameter information adder for adding access to parameter information for the method call to the visual component representing the method call. 10.如权利要求9所述的查询处理可视化系统，其中参数信息添加器还包括添加输入参数访问、输出参数访问和/或返回参数访问。10. The query processing visualization system of claim 9, wherein the parameter information adder further comprises adding input parameter accesses, output parameter accesses and/or return parameter accesses. 11.如权利要求9所述的查询处理可视化系统，其中参数信息管理器还包括宏操作树管理器，用于呈现表示包含查询框架查询的参数的宏操作树，该查询框架查询可由处理客户端查询的查询框架的一个或多个查询处理服务提供器执行。11. The query processing visualization system of claim 9, wherein the parameter information manager further comprises a macro operation tree manager for presenting a macro operation tree representing parameters containing a query frame query that can be processed by a processing client The query frame is executed by one or more query processing service providers. 12.如权利要求11所述的查询处理可视化系统，其中宏操作包括查询结果定义、查询和/或提供器查询。12. The query processing visualization system of claim 11, wherein macro operations include query result definitions, queries, and/or provider queries. 13.如权利要求11所述的查询处理可视化系统，其中方法调用呈现管理器包括执行选项管理器，用于允许执行查询框架查询，以及用于呈现包含执行的查询结果的视图。13. The query processing visualization system of claim 11, wherein the method call presentation manager includes an execution options manager for enabling execution of query frame queries and for presenting views containing executed query results. 14.如权利要求11所述的查询处理可视化系统，其中宏操作树管理器包括宏操作细节管理器，用于以预定格式露出完成宏操作定义的宏操作的结构。14. The query processing visualization system of claim 11, wherein the macro operation tree manager includes a macro operation detail manager for exposing the structure of the macro operation that completes the macro operation definition in a predetermined format. 15.如权利要求1所述的查询处理可视化系统，其中记录信息分析器包括提取作为查询计划处理的结果所产生的查询执行计划的记录信息，该查询执行计划包括可由查询处理服务提供器执行的宏操作；15. The query processing visualization system of claim 1 , wherein the log information analyzer includes extracting log information of a query execution plan generated as a result of query plan processing, the query execution plan including executable by the query processing service provider Macro operation; 事件顺序格式化器还包括格式化表示可执行的宏操作的可视呈现部件以表示查询执行计划；及The sequence of events formatter also includes formatting visual presentation components representing executable macro operations to represent query execution plans; and 方法调用呈现管理器还包括呈现用于确认执行计划的可视呈现部件。The method call presentation manager also includes presenting a visual presentation component for validating the execution plan. 16.如权利要求1所述的查询处理可视化系统，还包括记录模块，该记录模块包括：16. The query processing visualization system as claimed in claim 1, further comprising a recording module, the recording module comprising: 事件捕捉器，用于捕捉在处理客户端查询的过程中所发生的查询处理事件；An event catcher for capturing query processing events that occur during the processing of client queries; 方法调用识别器，用于将所捕捉到的查询处理事件中的主要查询处理事件识别为方法调用；及a method call recognizer for identifying a primary query processing event among the captured query processing events as a method call; and 记录元素管理器，用于将每个方法调用记录为由记录元素表示。A logging element manager for logging each method call as represented by a logging element. 17.一种可视化查询处理的方法，该方法包括如下步骤：17. A method for visual query processing, the method comprising the steps of: 分析在对请求来自一个或多个数据源的数据的客户端查询进行处理的过程中所发生的查询处理事件的记录信息，从而识别查询处理事件的依赖性；Analyzing recorded information of query processing events that occur during processing of client queries requesting data from one or more data sources to identify dependencies of query processing events; 按反映查询处理事件的依赖性的层次来格式化表示记录信息的可视呈现部件；及formatting visual presentation components representing record information in a hierarchy reflecting dependencies of query processing events; and 在由格式化步骤格式化的可视呈现部件的层次的环境下呈现可视呈现部件。The visual presentation component is rendered within the context of the hierarchy of visual presentation components formatted by the formatting step. 18.如权利要求17所述的方法，其中：18. The method of claim 17, wherein: 分析步骤还包括分析与主要查询处理事件相对应的方法调用的记录信息，以及识别方法调用的依赖性；The analyzing step also includes analyzing recorded information of method calls corresponding to the main query processing events, and identifying dependencies of the method calls; 格式化步骤还包括按反映方法调用的依赖性的层次来格式化可视呈现部件；及The formatting step also includes formatting the visual presentation component in a hierarchy that reflects the method call's dependencies; and 呈现步骤还包括在表示方法调用的可视呈现部件的层次的环境下呈现可视呈现部件。The step of rendering also includes rendering the visual presentation component within the context of the hierarchy of visual presentation components representing the method call. 19.如权利要求18所述的方法，其中：19. The method of claim 18, wherein: 分析步骤还包括识别方法调用的递归依赖性；The analysis step also includes identifying recursive dependencies of method calls; 格式化步骤还包括将表示递归地调用的方法调用的可视呈现部件格式化成可折叠部件；及The formatting step also includes formatting the visual presentation component representing the recursively invoked method call into a collapsible component; and 呈现步骤还包括呈现可折叠部件使得可视地呈现给定调用深度处的方法。The step of presenting also includes presenting the accordion such that the method at a given call depth is visually presented. 20.如权利要求18所述的方法，其中呈现步骤还包括打开表示变换了宏操作树的结构的方法的宏操作树。20. The method of claim 18, wherein the presenting step further comprises opening the macro operation tree representing the method that transformed the structure of the macro operation tree. 21.如权利要求18所述的方法，其中：21. The method of claim 18, wherein: 分析步骤还包括提取包括方法调用的事件处理信息在内的记录信息；及The analyzing step also includes extracting logging information including event handling information for method calls; and 呈现步骤还包括将处理信息添加到表示方法调用的可视部件。The rendering step also includes adding processing information to the visual component representing the method call. 22.如权利要求21所述的方法，其中呈现步骤还包括添加方法调用的耗用时间和/或存储器消耗。22. The method of claim 21, wherein the step of presenting further comprises adding elapsed time and/or memory consumption of method calls. 23.如权利要求18所述的方法，其中格式化步骤还包括利用方法的名称、容器对象的名称和提供方法的处理服务的服务提供器的名称来标记表示方法调用的呈现部件。23. The method of claim 18, wherein the formatting step further comprises tagging the presentation component representing the method call with a name of the method, a name of the container object, and a name of a service provider providing processing services for the method. 24.如权利要求18所述的方法，其中：24. The method of claim 18, wherein: 分析步骤还包括提取包括方法调用的参数信息在内的记录信息；及The analyzing step also includes extracting record information including parameter information of the method call; and 呈现步骤还包括将对方法调用的参数信息的访问添加到表示方法调用的可视部件。The rendering step also includes adding access to parameter information for the method call to the visual component representing the method call. 25.如权利要求24所述的方法，其中参数信息添加步骤还包括呈现表示包含查询框架查询的参数的宏操作树，该查询框架查询可由处理客户端查询的查询框架的一个或多个查询处理服务提供器执行。25. The method of claim 24, wherein the parameter information adding step further comprises presenting a tree of macro operations representing parameters containing a query frame query that can be processed by one or more queries of a query frame processing a client query The service provider executes. 26.如权利要求25所述的方法，其中宏操作树呈现步骤还包括提供执行选项，用于允许执行查询框架查询，以及用于呈现包含执行的查询结果的视图。26. The method of claim 25, wherein the macro operation tree presenting step further comprises providing an execution option for allowing execution of a query frame query and for presenting a view containing the results of the executed query. 27.如权利要求17所述的方法，其中：27. The method of claim 17, wherein: 分析步骤还包括获得作为查询计划处理的结果所产生的查询执行计划的记录信息，该查询执行计划包括可由查询处理服务提供器执行的宏操作；The step of analyzing further includes obtaining recorded information of a query execution plan generated as a result of the query plan processing, the query execution plan including macro operations executable by the query processing service provider; 格式化步骤还包括格式化表示可执行的宏操作的可视呈现部件以表示查询执行计划；及The formatting step also includes formatting a visual presentation component representing executable macro operations to represent a query execution plan; and 呈现步骤还包括呈现用于确认执行计划的可视呈现部件。The presenting step also includes presenting a visual presentation component for validating the execution plan. 28.如权利要求17所述的方法，还包括通过以下获得记录信息的步骤：28. The method of claim 17, further comprising the step of obtaining record information by: 捕捉在处理客户端查询的过程中所发生的查询处理事件；Capture query processing events that occur during the processing of client queries; 将所捕捉到的查询处理事件中的主要查询处理事件识别为方法调用；及identifying a primary query processing event of the captured query processing events as a method call; and 将每个方法调用记录为由记录元素表示。Record each method call as represented by a record element. 29.一种可加载到数字计算机的内部存储器中的计算机程序产品，该计算机程序产品包括软件代码部分，该软件代码部分在所述产品在计算机上运行时执行用以实现如权利要求17至28中所述的发明。29. A computer program product loadable into the internal memory of a digital computer, the computer program product comprising software code portions which are executed when said product is run on a computer for implementing claims 17 to 28 the invention described in.
CN2009801133489A 2008-04-16 2009-04-15 Query processing visualization system and method for visual query processing Pending CN102007476A (en)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
CA2629922 2008-04-16
CA002629922A CA2629922A1 (en) 2008-04-16 2008-04-16 Query processing visualization system and method of visualizing query processing
US12/104,108 US8122050B2 (en) 2008-04-16 2008-04-16 Query processing visualization system and method of visualizing query processing
US12/104,108 2008-04-16
PCT/EP2009/054425 WO2009127639A1 (en) 2008-04-16 2009-04-15 Query processing visualization system and method of visualizing query processing

Publications (1)

Publication Number Publication Date
CN102007476A true CN102007476A (en) 2011-04-06

Family

ID=40786528

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2009801133489A Pending CN102007476A (en) 2008-04-16 2009-04-15 Query processing visualization system and method for visual query processing

Country Status (4)

Country Link
JP (1) JP5349581B2 (en)
KR (1) KR20100135789A (en)
CN (1) CN102007476A (en)
WO (1) WO2009127639A1 (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102789488A (en) * 2012-06-29 2012-11-21 用友软件股份有限公司 Data query processing system and data query processing method
CN107622103A (en) * 2011-05-02 2018-01-23 起元技术有限责任公司 Manage data query
CN107729365A (en) * 2017-09-07 2018-02-23 中国科学院自动化研究所 Embodied spillover and optimization method and device
CN111177249A (en) * 2019-12-10 2020-05-19 浙江大学 A multi-data source data visualization method and device based on federated learning idea
US11093223B2 (en) 2019-07-18 2021-08-17 Ab Initio Technology Llc Automatically converting a program written in a procedural programming language into a dataflow graph and related systems and methods
US11308161B2 (en) 2015-02-18 2022-04-19 Ab Initio Technology Llc Querying a data source on a network
US11593369B2 (en) 2010-01-15 2023-02-28 Ab Initio Technology Llc Managing data queries
TWI862111B (en) * 2023-05-19 2024-11-11 韓商韓領有限公司 Operating method for electronic apparatus for providing information and electronic apparatus supporting thereof

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110137922A1 (en) * 2009-12-07 2011-06-09 International Business Machines Corporation Automatic generation of a query lineage
WO2020165642A1 (en) * 2019-02-12 2020-08-20 Shivashankar Vidya Devanahalli System and method for visualization of system generated logs
CN114201602B (en) * 2022-02-15 2022-05-06 支付宝(杭州)信息技术有限公司 Method and apparatus for generating natural language sentences for visual data analysis
KR102713444B1 (en) * 2023-03-30 2024-10-07 쿠팡 주식회사 Apparatus for providing statistical information associated with service

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH03260742A (en) * 1990-03-12 1991-11-20 Hitachi Ltd Program trace display method
CA2019327C (en) * 1990-06-19 2000-02-29 Peter K.L. Shum User inquiry facility for data processing systems
US6096095A (en) * 1998-06-04 2000-08-01 Microsoft Corporation Producing persistent representations of complex data structures
US7136868B2 (en) * 2003-06-06 2006-11-14 Microsoft Corporation Database object script generation method and system
US7231375B2 (en) * 2003-10-10 2007-06-12 Microsoft Corporation Computer aided query to task mapping
KR101098181B1 (en) * 2003-12-02 2011-12-27 마이크로소프트 코포레이션 Methods and systems for analyzing data in N-dimensional raw OLAP cubes and methods for converting (N + Q) -dimensional on-demand queries to N-dimensional queries for execution by N-dimensional raw OLAP cubes
US20060085401A1 (en) * 2004-10-20 2006-04-20 Microsoft Corporation Analyzing operational and other data from search system or the like
CA2518902C (en) * 2005-06-23 2010-11-30 Cognos Incorporated System and method for query planning and execution

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11593369B2 (en) 2010-01-15 2023-02-28 Ab Initio Technology Llc Managing data queries
CN107622103A (en) * 2011-05-02 2018-01-23 起元技术有限责任公司 Manage data query
CN107622103B (en) * 2011-05-02 2021-12-28 起元技术有限责任公司 Managing data queries
CN102789488B (en) * 2012-06-29 2016-05-04 用友网络科技股份有限公司 Data query treatment system and data query processing method
CN102789488A (en) * 2012-06-29 2012-11-21 用友软件股份有限公司 Data query processing system and data query processing method
US11308161B2 (en) 2015-02-18 2022-04-19 Ab Initio Technology Llc Querying a data source on a network
CN107729365A (en) * 2017-09-07 2018-02-23 中国科学院自动化研究所 Embodied spillover and optimization method and device
CN107729365B (en) * 2017-09-07 2020-02-07 中国科学院自动化研究所 Materialized view selection and optimization method and device
US11093223B2 (en) 2019-07-18 2021-08-17 Ab Initio Technology Llc Automatically converting a program written in a procedural programming language into a dataflow graph and related systems and methods
CN111177249B (en) * 2019-12-10 2022-05-17 浙江大学 A multi-data source data visualization method and device based on federated learning idea
CN111177249A (en) * 2019-12-10 2020-05-19 浙江大学 A multi-data source data visualization method and device based on federated learning idea
TWI862111B (en) * 2023-05-19 2024-11-11 韓商韓領有限公司 Operating method for electronic apparatus for providing information and electronic apparatus supporting thereof
TWI882919B (en) * 2023-05-19 2025-05-01 韓商韓領有限公司 Operating method for electronic apparatus for providing information and electronic apparatus supporting thereof

Also Published As

Publication number Publication date
WO2009127639A1 (en) 2009-10-22
JP2011517823A (en) 2011-06-16
KR20100135789A (en) 2010-12-27
JP5349581B2 (en) 2013-11-20

Similar Documents

Publication Publication Date Title
CN102007476A (en) Query processing visualization system and method for visual query processing
US8122050B2 (en) Query processing visualization system and method of visualizing query processing
US8489474B2 (en) Systems and/or methods for managing transformations in enterprise application integration and/or business processing management environments
JP6985279B2 (en) Systems and methods for inferring data transformations through pattern decomposition
US7673340B1 (en) System and method for analyzing system user behavior
US11847040B2 (en) Systems and methods for detecting data alteration from source to target
US20050234894A1 (en) Techniques for maintaining collections of generated web forms that are hyperlinked by subject
US10963800B2 (en) Service layer augmentation of response to semantically-informed query of arbitrary external data sources
US8140545B2 (en) Data organization and evaluation using a two-topology configuration
EP1810131A2 (en) Services oriented architecture for data integration services
US20240036890A1 (en) System and method of a modular framework for configuration and reuse of web components
US20110145005A1 (en) Method and system for automatic business content discovery
US20200012643A1 (en) Method for managing and executing decoders and transformations using linked data and a service layer
US12039416B2 (en) Facilitating machine learning using remote data
CN118885523B (en) Implementation Method of Building Heterogeneous Data Warehouse
Burattini et al. Towards linked data for ecosystems of digital twins
US20150088773A1 (en) Method and system for in-memory policy analytics
JP2023548152A (en) System and method for providing a query execution debugger for use in a data analysis environment
Schuchardt et al. Applying content management to automated provenance capture
Allen et al. Provenance capture and use: A practical guide
US20250362995A1 (en) Log data condensation for interoperability with language models
CA2629922A1 (en) Query processing visualization system and method of visualizing query processing
Bozzato et al. Semantic Visual Query Answering on Heterogeneous Territorial Data
CN120104847A (en) Application tag configuration method, device, computer equipment and storage medium
Jiang et al. Building business intelligence applications having prescriptive and predictive capabilities

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20110406