CN101622619B

CN101622619B - Method and system for navigation and visualization of data in relational and/or multidimensional databases

Info

Publication number: CN101622619B
Application number: CN2007800520057A
Authority: CN
Inventors: 丁行俊
Original assignee: TING HENG TOON (MY); TING HENG TOON MY
Current assignee: Tokuda Mihiro business intelligence Ltd
Priority date: 2007-04-10
Filing date: 2007-04-10
Publication date: 2013-03-27
Anticipated expiration: 2027-04-10
Also published as: WO2008122830A1; EP2137643A4; HK1140557A1; CN101622619A; EP2137643A1

Abstract

A computer-implemented design tool for the navigation and visualization of data in at least one relational and/or multidimensional database. The design tool allows a user to partition a display screen into a plurality of frames, to insert and configure controls within each frame to form a dashboard, the controls defining queries to the database(s) and any rules associated with those queries, and to create the dashboards in multiple levels for each of the frames. Configuring the controls permits a user to define drill actions for the controls within each dashboard to target dashboards in any of the multiple levels, both within the same frame as the starting dashboard, as well as in any or all of the other frames. The user-defined drill actions provide for powerful and highly flexible multi-path and multi-level navigation to achieve visualization of data in the database(s), by displaying on the display screen a respective target dashboard of any one of the multiple levels in each frame according to the controls selected by the user.

Description

The method and system that is used for the data of navigation and visual relational database and/or multi-dimensional database

Technical field

The present invention relates to the technical field of graphical user interface.It relates generally to for the method and system that shows data, and relates in particular to for navigation and the visual method and system that is stored in the data of relational database and/or multi-dimensional database.

Background technology

Owing to the technical progress of processor, data storage device and storer becomes possible the appearance of powerful computing machine and the higher network bandwidth of being convenient to internet use, so that computing machine becomes a modern professional pith.These are progressive guided exploitation with Data Collection, organize and be stored in the route that the critical software in the relational database is used.Subsequently, mapped from the data of relational database and be filled to further multi-dimensional database with the mode organising data of multi-dimensional relation.

Can be along the data in the definition of a plurality of dimensions and the mapping multi-dimensional database.For example, the data in the sale multi-dimensional database can comprise the dimension for dissimilar product, position, client, marketing channel and time dimension.

Access also uses the ability that is stored in the data in these relational databases and/or the multi-dimensional database to become a professional importance.Along with the increase of data type and capacity, to the user provide comprehensively and " wieldy " navigation and visualization tool the data from relational database and/or multi-dimensional database are conducted interviews, analyze and management becomes more and more important.

The purpose of any Information Visualization System all is to utilize the human perception process and so that information and user-friendly mode organising data to be provided with computer graphical.Therefore, having made very large effort develops for showing and the instrument of visual data from relational database and/or multi-dimensional database.

The navigation of prior art and visualization tool are too rigid on their data representation method, and do not align by the navigation and visual presentation of data go out comprehensive view.In addition, these traditional instruments only allow the user to design and are used for demonstration and navigation from " one click (the one click) " of the data of relational database and/or multi-dimensional database or order predetermined single path and one direction (unidirectional) navigation that is associated.Therefore, the user may not browse relational database and/or multi-dimensional database with a series of paths of the specific thought process that is fit to business demand or user.

Therefore, need a kind of demonstration and visual improved computer implemented method and system that multipath and multistage navigation (multi-level navigation) are provided to being stored in the data in relational database and/or the multi-dimensional database.

Need in addition a kind ofly for the user provides improved computer implemented method and system to the comprehensive graphics view that is stored in the data in relational database and/or the multi-dimensional database, the user is fit to these users' business demand and navigate in the path of thought process with a series of simultaneously.

Also need a kind of improved computer implemented method and system that comprehensive business intelligence (businessintelligence) system is provided for the user, the user is for cooperating and communicate by letter from the information of relational database and/or multi-dimensional database demonstration simultaneously.

Still need to provide a kind of for navigation with show comprehensive and user-friendly improved computer implemented method and the system of the data that are stored in relational database and/or multi-dimensional database.

The invention provides such method and system and satisfy top four and other needs.

Summary of the invention

In order to overcome shortcoming of the prior art, the method that the invention provides a kind of novelty is navigated (navigate) and is shown the data that are stored in relational database and/or the multi-dimensional database.

In one embodiment, the invention provides a kind of computer-implemented business intelligence instrument for navigation and the data of visual at least one relational database and/or multi-dimensional database.This design tool allows the user that display screen is divided into a plurality of frameworks (frame); Insert and configure control (control) to form instrument panel (dashboard) in each framework, described control definition is to the inquiry of (one or more) database and any rule that is associated with these inquiries; And be that each framework creates multistage instrument panel.The configuration control is permitted the user and is drilled through action (drill-action) for the control in each instrument panel is defined in multistage any grade target instrument panel, these two instrument panels all with the identical framework of beginning instrument panel in, and in any or all framework of other framework.By according to by arbitrary grade respective objects instrument panel in multistage in showing each framework of screen display of the control of user selection, user-definedly drill through action multipath and the multistage navigation of powerful and high flexibility are provided, thereby realize visual to the data in (one or more) database.

From broad aspect, the invention provides for navigation and the visual method and system that is stored in the data of relational database and/or multi-dimensional database.The present invention provides by the access of user-friendly interface to data for the user, and this interface allows the user to check, understand and navigate from the data of relational database and/or multi-dimensional database.

Enforcement of the present invention comprises following content.

According to aspects of the present invention, provide a kind of for the visual and navigation method from the computer system of the data of relational database and/or multi-dimensional database.The method comprises that definition can be used for showing better (one or more) business module for the information of specific transactions purpose and target (objective).Described (one or more) business module can be Sales module, finance module, operational module etc., and perhaps it can be the single business module that different business objectives is combined into.

According to aspects of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises the device (means) that can be used to show better for (one or more) business module of the information of specific transactions purpose and target be used to defining.Described (one or more) business module can be Sales module, finance module, operational module etc., and perhaps it can be the single business module that different business objectives is combined into.

According to another aspect of the present invention, provide a kind of for the visual and navigation method from the computer system of the data of relational database and/or multi-dimensional database.The method comprises that (one or more) business module that will see at computer screen is divided into a plurality of frameworks.The purpose of these divisions (partition) is to enable multipath and multistage navigation.Framework is used to hold (house) control (chart, index dial, GIS (Geographic Information System), the map that produces, image, icon, annotation box, button, color coding (color-coded) alarm button, label, PivotTables etc.), and these controls can be linked to data source with the form to the inquiry of relational database and/or multi-dimensional database.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for being divided at (one or more) business module that computer screen is seen the device of a plurality of frameworks.The purpose of these divisions is to enable multipath and multistage navigation.Framework is used to hold control (chart, index dial, GIS (Geographic Information System), image, annotation box, button, alarm button, PivotTables etc.), and these controls can be linked to data source with the form to the inquiry of relational database and/or multi-dimensional database.

According to another aspect of the present invention, provide a kind of for the visual and navigation method from the computer system of the data of relational database and/or multi-dimensional database.The method comprises control (chart, index dial, GIS (Geographic Information System), image, icon, annotation box, button, color coding alarm button, label, PivotTables etc.) is inserted in the framework of defined (one or more) business module.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for the device that control (chart, index dial, GIS (Geographic Information System), image, icon, annotation box, button, color coding alarm button, label, PivotTables etc.) is inserted into the framework of defined (one or more) business module.

According to another aspect of the present invention, provide a kind of for the visual and navigation method from the computer system of the data of relational database and/or multi-dimensional database.The method is included in a plurality of frameworks and configures control.These configurations can comprise the attribute of control, namely define the inquiry to (one or more) data source of relational database and/or multi-dimensional database; The business rule (mathematical computations) that definition is associated with described inquiry; Alarm and threshold condition that definition is associated with described inquiry; In case definition alert threshold condition is run counter to the alarming method that (breach) take (e-mail alert, SMS[cellular short message services] alarm etc.); The definition control drill through action etc.For dissimilar control, configuration attribute may be different with function.In case the control of framework is configured fully, it just can be called as instrument panel.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for the device at different frames configuration control.These configurations can comprise the attribute of control, namely define the inquiry to (one or more) data source of relational database and/or multi-dimensional database; The business rule (mathematical computations) that definition is associated with described inquiry; Alarm and threshold condition that definition is associated with described inquiry; In case the alarming method that definition alert threshold condition is taked by running counter to (e-mail alert, SMS[cellular short message services] alarm etc.); The definition control drill through action etc.For dissimilar control, configuration attribute may be different with function.In case the control of framework is configured fully, it just can be called as instrument panel.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.Any control that the method is included as in the instrument panel configures the action that drills through that is used for the multipath navigation purpose.Each control can be configured to have to (one or more) target instrument panel (targetedDashboard) and take office alternatively what its business module, URL (URL(uniform resource locator)), website or application etc. one or morely drill through action (link).The user can specify target framework zone or the space for these target service modules that will be shown or any other URL (URL(uniform resource locator)), website or application etc.After appointment drills through action, can be terminal user's " preservation " module.In terminal user's environment, in case mouse is clicked control, specified drill through action and will occur.(one or more) target instrument panel and any other target service module, URL (URL(uniform resource locator)), website or application etc. will be displayed in corresponding frame area or the space, and will automatically be extracted and be presented on the control of (one or more) target instrument panel from the relation data of relational database and/or multi-dimensional database.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.Any control that this system is included as in the instrument panel configures the device that drills through action that is used for the multipath navigation purpose.Each control can be configured to have to (one or more) target instrument panel and take office alternatively what its business module, URL (URL(uniform resource locator)), website or application etc. one or morely drill through action (link).The user can specify target framework zone or the space for these target service modules that will be shown or any other URL (URL(uniform resource locator)), website or application etc.After appointment drills through action, can be terminal user's " preservation " module.In terminal user's environment, in case mouse is clicked control, specified drill through action and will occur.(one or more) target instrument panel and any other target service module, URL (URL(uniform resource locator)), website or application etc. will be displayed in corresponding frame area or the space, and will automatically be extracted and be presented on the control of (one or more) target instrument panel from the relation data of relational database and/or multi-dimensional database.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method comprises with instrument panel with to any other links of other business module, URL (URL(uniform resource locator)), website or application etc. and being kept in the business module, to reach the purpose of navigation and visual data from relational database and/or multi-dimensional database.The user can change to edit any these instrument panels in the future by the configuration to control.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises with instrument panel with to any other links of other business module, URL (URL(uniform resource locator)), website or application etc. and is kept in the business module device with the purpose that reaches navigation and visual data from relational database and/or multi-dimensional database.The user can change to edit any these instrument panels in the future by the configuration to control.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method is included in and designs and create the not at the same level of instrument panel in the business module.

This provides the method that is used for the novelty of multipath and multistage navigation.In this novel method, the control in the instrument panel (chart, index dial, GIS (Geographic Information System), image, icon, button, color coding alarm button, label) can be configured to have the action of drilling through.These have drilled through action definition will be extracted and be presented at (one or more) target instrument panel in the business module.In case the user has clicked control, multipath and multistage navigation are just correspondingly activated to extract and are shown (one or more) target instrument panel.And from (one or more) target instrument panel, control can be defined to get by drilling (drill to) any other (one or more) target instrument panel again.Therefore, the user can define unrestricted multipath and multistage navigation is better visual to realize.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for the device not at the same level that creates instrument panel at business module.This provides the method that is used for the novelty of multipath and multistage navigation.In this novel method, the control in the instrument panel (chart, index dial, GIS (Geographic Information System), image, icon, button, color coding alarm button, label) can be configured to have the action of drilling through.These have drilled through action definition will be displayed on (one or more) target instrument panel in the business module.In case the user has clicked control, multipath and multistage navigation are just correspondingly activated to show (one or more) target instrument panel.And from (one or more) target instrument panel, control can be defined to get by drilling any other (one or more) target instrument panel again.Therefore, the user can define unrestricted multipath and multistage navigation is better visual to realize.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method is included as and drills through all business modules that action is associated with (one or more) instrument panel any general " backward " and " forward " button is provided.This has eliminated the user and designed such feature and the needs of function in each instrument panel." backward " that this is general and " forward " button will automatically be any effect that drills through backward (drill backward) or drill through forward of having moved that drills through.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system is included as with (one or more) instrument panel any and drills through the device that all business modules that action is associated provide general " backward " and " forward " button.This has eliminated the user and designed such feature and the needs of function in each instrument panel." backward " that this is general and " forward " button will automatically be any effect that drills through backward or drill through forward of having moved that drills through.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method comprises and is placed on (one or more) color coding alarm button on the image or is close to image, to pass on better the visual meaning with the image correlation connection.Image can be map, process, activity (activity), people's picture etc.In addition, (one or more) color coding alarm button can be placed on the dynamic map that is produced by GIS (Geographic Information System) mapping system (mappingsystem).This provides the better reception and registration from the information of GIS for the just shown data from relational database and/or multi-dimensional database.

The color coding alarm button can be " flash of light " and be green, yellow or red with different color codings.When the measurement result of reality was compared with target or canonical measure result, green was usually used to represent that " good (Good) ", yellow are used to represent " average (Average) ", redness is used to represent " bad (No Good) ".Just shown information is convenient to understand in this color coding system, and easily passes on meaning, state or the general health (overall health) of the business that is associated with information in the business module.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for being placed on (one or more) color coding alarm button on the image or being close to image to pass on better the device of the visual meaning that joins with image correlation.Image can be map, process, activity, people's picture etc.(one or more) color coding alarm button can be placed on the dynamic map that is produced by GIS (Geographic Information System) mapping system.

The color coding alarm button can be " flash of light " and be green, yellow or red with different color codings.When the measurement result of reality was compared with target or canonical measure result, green was usually used to represent that " good ", yellow are used to represent " on average ", redness is used to represent " bad ".Just shown information is convenient to understand in this color coding system, and easily passes on meaning, state or the general health of the business that is associated with information in the business module.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method comprises one or more annotation box (note) controls (one or more) is placed in framework or the instrument panel to reach the purpose of describing or upgrade the action of being taked for the information in the instrument panel.This is convenient to cooperate and the easily meaning, the state that are associated with information in instrument panel and the overall traffic module of reception and registration or the action of taking.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for the device that one or more annotation box (note) controls (one or more) is placed on framework or instrument panel, to reach the purpose of describing or upgrade the action of being taked for the information in the instrument panel.This is convenient to cooperate and the easily meaning, the state that are associated with information in instrument panel and the overall traffic module of reception and registration or the action of taking.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The mouse that the method is included in the user illustrates " the text pop-up window " of reality and the desired value of this control on control the time.This is particularly useful to index dial and alarm button, wherein exist keeping visual clean and tidy and simple demand, and simultaneously when this increase in demand the user can both show in the mode of going deep into details.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises the device for " the text pop-up window " of the reality that this control is shown and desired value when user's mouse is on control.This is particularly useful to index dial and alarm button, and their exist keeping visual clean and tidy and simple demand, and simultaneously when this increase in demand the user can both show in the mode of going deep into details.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method comprises that permission is applied to new business rule and mathematical computations chart and can directly checks the result under user model.The user can preserve the new chart that forms by business rule, to be used for analyzing better the data from relational database and/or multi-dimensional database.

The user can carry out additional extemporaneous (ad-hoc) inquiry for relational database and/or multi-dimensional database.The user can preserve from the extemporaneous new chart of inquiring about to analyze better the data from relational database and/or multi-dimensional database.

The user can be with on any chart " drag and drop " another chart in the instrument panel, or " drag and drop " are to another instrument panel.New chart can show the data from these two charts.The user can preserve new chart to analyze better the data from relational database and/or multi-dimensional database.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for allowing that new business rule and mathematical computations be applied to chart and can directly check result's device under user model.The user can preserve the new chart that forms by business rule, to be used for analyzing better the data from relational database and/or multi-dimensional database.

The user can carry out the additional extemporaneous inquiry for relational database and/or multi-dimensional database.The user can preserve from the extemporaneous new chart of inquiring about to analyze better the data from relational database and/or multi-dimensional database.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method comprises having the feature that is similar to " drilling through (drill-down) downwards " is come analysis diagram with any element (element) by the click chart details.After this, the user can come " upwards drilling through (drill-up) " by the icon of clicking above the chart that provides under user working time (Run-Time) pattern.In the analysis to chart, the user can come " expansion and contraction characteristic chart (expand and contractchart features) " with more feature and the function of access chart by the icon of clicking above the chart.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises having be used to providing the feature that is similar to " drilling through " downwards with the device of the details of analysis diagram usually of any unit by clicking chart.After this, the user can come " upwards drilling through " by the icon of clicking above the chart that provides under user's pattern working time.

In the analysis to chart, the user can come " expansion and contraction characteristic chart " with more feature and the function of access chart by the icon of clicking above the chart.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method comprises, and the Query Builder with business rule ability and function (generator) that provides under the user model in working time is provided.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.The Query Builder with business rule ability and function that provides under user model working time is provided in this system.

According to another aspect of the present invention, provide a kind of for the visual and navigation method in computer system from the data of relational database and/or multi-dimensional database.The method comprises uses Query Builder to the extemporaneous inquiry of relational database and/or multi-dimensional database.

After each inquiry, new chart will eject, and wherein show the result of inquiry.Inquiry can be repeated repeatedly, causes showing a plurality of ejection charts.The user can continue to think one or more business rule or the mathematical computations of arranging in these charts.The user can be with any chart " drag and drop " to another chart, and the result who makes up can be shown as new chart.

The user can be with on another chart (master map table) in the instrument panel of any chart " drag and drop " in these charts, or " drag and drop " are to another instrument panel.New chart can show the data from these two charts.The user can preserve new chart to analyze better the data from relational database and/or multi-dimensional database.

According to another aspect of the present invention, provide a kind of for the visual and navigation system from the data of relational database and/or multi-dimensional database.This system comprises for the device that provides with Query Builder the extemporaneous inquiry of relational database and/or multi-dimensional database.

After each inquiry, new chart will eject, and wherein show the result of inquiry.Inquiry will be repeated repeatedly, cause showing a plurality of ejection charts.The user can continue as one or more business rule or the mathematical computations of arranging in these charts.The user can be with any chart " drag and drop " to another chart, and the result who makes up can be shown as new chart.

In basic embodiment, only individual module need to be created and preserve.Yet, in fact, usually can create very expediently and preserve the module that two or more relate to the different business aspect, for example Sales module, finance module, operational module etc.In this case, definedly when creating each module drill through the link that action can be included in other module.This provides high-grade user convenient, because the control of clicking in the navigation of a module can directly call (call up) another module.Therefore, the user avoids having to close existing module and opening new module in order to switch to another module from a module.

Advantage of the present invention comprises following one or more.The present invention is the integrated service intelligence tool that a kind of user of permission communicates and cooperates in user-friendly mode.It extends to such an extent that exceed traditional business intelligence based on report and use.

Automatically trigger alarm and provide powerful operation service intelligent capability (operational business intelligence capability) with SMS for the user via e-mail.This provides better support for operation and has eliminated continuous inspection and checked needs from the data of relational database and/or multi-dimensional database.

Generating code has been eliminated the needs to manual programming, therefore allows the programmer to concentrate on business field rather than business intelligence instrument.The user can easily create themselves business module in the situation that do not carry out any programming.User interface can be created to satisfy concrete service needed fast and easily.

Multipath and multistage navigation characteristic make the user navigate at any angle and to check data and make thus the more approaching data that are stored in relational database and/or the multi-dimensional database of user.Exploratory navigation feature permission user like this obtains the higher levels of understanding that is stored in the data in relational database and/or the multi-dimensional database and makes thus better professional the decision.

To the browsing of following detailed description, other side of the present invention and feature will be clearly for those skilled in the art in conjunction with the drawings.

Description of drawings

Figure 1A is the simplified block diagram according to the method and system that can be used to visual and navigation multidimensional data of one embodiment of the present of invention of describing.

Figure 1B is the simplified block diagram according to the method and system that can be used to visual and navigation relation data of an alternative embodiment of the invention of describing.

Fig. 2 is the exemplary configurations of the multi-dimensional database that gathers (summarized) data is arranged in explanation with different dimensions (dimension) figure.

Fig. 3 is that explanation is according to an embodiment of the invention by being configured to navigate and the flow process of the step that the method for the business module of display system is performed.

Fig. 4 A is the figure of the typical framework subregion in the explanation business module.

Fig. 4 B is the figure of " multistage instrument panel " in the explanation business module.This provides " multipath (multi-path) " and " multistage (multi-level) " to drill through action.

Fig. 5 is that explanation can be inserted in the framework figure with the control that forms the instrument panel in the business module.

Fig. 6 is the figure that the general survey of the design interface that is used to the design and structure business module is described.This is according to an embodiment of the inventionly can be used for the main design interface of system of visual and navigation relation data and/or multidimensional data for design.

Fig. 7 A is figure-left panel of selecting of explanation deviser's difference in functionality (being module browser (Module explorer), tool box (Tool Box), resource browser (ResourceExplorer) and instrument panel storehouse (Dashboard Gallery)).

Fig. 7 B is the typical sequence of left panel function is selected in explanation during the process of design business module figure.

Fig. 8 A is figure-right panel (being attribute) that explanation deviser's difference in functionality is selected.

Fig. 8 B is the difference in functionality of declared attribute and the figure of configuration.

Fig. 9 is the figure of the initial setting up of the new group in the specification module browser.

Figure 10 is the figure of the new group of explanation name in the module browser.

Figure 11 is the figure of explanation initial setting up of new business module under the new module group that creates.

Figure 12 is the figure of the new business module under the new module group that creates of explanation name.

Figure 13 is that explanation is for the figure of the selection of the predefine framework zoning template of the new business module that just is being designed.

Figure 14 is the figure of the example of explanation predefine framework subregion and layout.This only is available layout and the example of subregion, and actual method and system is not subjected to the restriction of illustrated example.

Figure 15 is the figure that explanation resets the size of the framework in the business module.

Figure 16 is explanation is inserted into control framework from the tool box figure.

Figure 17 A is that explanation is to the configuration of the inquiry (Query) of relational database and/or multi-dimensional database and the figure of definition.

Figure 17 B is that explanation is by dragging inquiry (Query) icon and placing it in the control will the inquiry (Query) of relational database and/or multi-dimensional database be linked to the figure of control.

Figure 18 A is figure-the arrange alert threshold of control of one of declared attribute (Properties) function.

Figure 18 B is figure-the arrange e-mail alert of explanation another attribute (Properties) function.

Figure 18 C is the figure-(font) type that sets font, size (size) of explanation another attribute (Properties) function etc.

Figure 19 is the figure of example of the complete first order of the explanation business module that comprises three (3) individual instrument panels.

Figure 20 is the figure in explanation instrument panel storehouse.This is in order to create new instrument panel to reach the purpose of navigation relation data according to an embodiment of the invention and/or multidimensional data in multistage instrument panel.

Figure 21 is the figure-by select target framework (Frame) and target instrument panel (Target Dashboard) (one or more) are set to drill through action of explanation another attribute (Properties) function.Alternatively, the user can be set to the action that drills through of business module (BusinessModules), and any other link of arriving target URL (URL(uniform resource locator)), website or application etc.

Figure 22 A is that explanation is convenient to pass on better and the figure of the method understood, wherein the color coding button is placed on the map image or map from GIS (Geographic Information System).

Figure 22 B is that explanation is convenient to pass on better and the figure of the method understood, wherein the color coding button is placed on the procedural image side.

Figure 23 is the figure of the explanation method being convenient to navigate in business module better, and wherein general " backward (Back) " and " forward (Forward) " are available for all business modules under the working time user model.

Figure 24 is that explanation is convenient to pass on better and the figure of the method that cooperates the annotation box that wherein is provided for explaining under the user model in working time (Commentary Box).

Figure 25 is that the better figure of the method for visual information is convenient in explanation, wherein when user's mouse is being used on the control of instrument panel under the user model of some relevant controls, under user model, provide " Pop-up text window (pop-up text window) ".

Figure 26 is the figure of the example of the navigation of the explanation business module that is used for being named as Sales module (Sales Module) under the working time user model and display system.

Figure 27 is the figure of the example of the navigation of the explanation business module that is used for being named as procedure module (Process Module) under the working time user model and display system.

Figure 28 is the figure of the example of the navigation of the explanation business module that is used for being named as human resources module (Human Resource Module) under the working time user model and display system.

Figure 29 A is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses, and " upwards drilling through " icon 32 and " expansion and shrink characteristic chart " icon 34 were provided under the user model in working time.

Figure 29 B is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses, can obtain more characteristic chart and function when wherein the user clicks " mode of extension (expand mode) " icon above the chart under the working time user model.

Figure 30 is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses and extemporaneous inquiry, and the Query Builder with business rule ability and function (Query Generator) wherein is provided under the user model in working time.

Figure 31 is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses and extemporaneous inquiry, wherein the chart that produces of Query Builder can combine or uses with business rule with other chart, and then can the result be moved to any master map table in the business module by " drag and drop ".

Figure 32 is that explanation can be used the present invention and be comprised the figure of example of the computing system environments of memory device, storage device interface, CPU (central processing unit) (CPU), memory devices, display interface, display monitor, computer bus, mouse, keyboard and wireless device.

Embodiment

In the following description of preferred embodiment, the accompanying drawing of the part that formation be the following describes carries out reference, and illustrates in the mode that specific embodiment of the present invention is carried out in explanation.Although will be described in conjunction with the preferred embodiments, should be appreciated that and do not plan to limit the invention to these embodiment.On the contrary, the present invention plans to cover replacement, modification and the equivalent that is included in the spirit and scope of the present invention that are defined by the following claims.Therefore, do not plan to limit the invention to shown preferred embodiment, but the present invention should meet the therewith disclosed principle in the place the widest scope consistent with feature.

Definition

According to the present invention, introduce some and related to the term in relational database and/or multi-dimensional database and business intelligence field, will be convenient to be familiar with fully the present invention to the understanding of these terms.

" control " refers to for the assembly that shows information.The example of control is chart, index dial, GIS (Geographic Information System), label, image, icon, annotation box, button, alarm button, PivotTables etc.

" framework " refers to the subregion that computing machine or other display screen are divided into less window.Framework is used to hold control (chart, label, image, annotation box, button, alarm button, PivotTables etc.), and alternatively from the content of other business module, outside URL (URL(uniform resource locator)), website and/or application.In the situation that framework holds control, in case (one or more) control in the framework is configured to have such as business rule, controlled attribute and/or the attribute to the link of other instrument panel fully, it just is called as instrument panel.

" instrument panel " refers to the framework that comprises control and it is linked to external data source or business rule, control such as chart, index dial, GIS (Geographic Information System), label, image, annotation box, button, alarm button, the PivotTables etc.In yet another aspect, except information can be linked to the data that are stored in one or more databases, instrument panel was as presentation slides (presentation slide).

" multistage instrument panel " refers to the not at the same level of the interior instrument panel of business module.This " multipath " and " multistage " that allows user to be assigned to the target instrument panel in not at the same level drills through action.

" business module " refers to the set (collection) of the instrument panel of multistage form, and allows the user to carry out multipath and multistage navigation.(one or more) business module can be used to show better the information for specific transactions purpose and target.It can be Sales module, finance module, operational module etc., and perhaps it can be a single business module that is combined into by different business objectives.

" inquiry " refer to from the user, just be converted to the traffic issues of relational database and/or the understandable term of multi-dimensional database, and its result returns with the understandable term of user.

" business rule " refers to and inquires about the mathematic(al) representation that is associated.

" drill through action " and refer to user assignment to the Management Information Base of control, it is specified in order to the guidance path that shows suitable (one or more) instrument panel and to any other link of target service module, ULR (URL(uniform resource locator)), website or application etc. and the link of arriving other (one or more) module.

" multipath navigation " refer to take in order to arrive the different navigation path of (one or more) target instrument panel that will be shown.These paths can utilize the single mouse of the startup control on the computer screen or keyboard clicked simultaneously and carry out.Any specific guidance path can be with respect to the instrument panel level on " upwards drilling through ", " drilling through downwards " or " drilling through from the side (drill-sideways) " direction.

" multistage navigation " refers to the different navigation level of the instrument panel in the module.These grades can be used the single mouse of the startup control on the computer screen or keyboard clicked simultaneously and carry out.

" metadata " refers to about being stored in the structural information of the data in (one or more) relational database and/or the multi-dimensional database.

" cube (Cube) " refers to relational database and/or multi-dimensional database, wherein arranges that with different dimensions combined data is to reach the purpose of relationship analysis and/or multidimensional analysis.

" GIS " refers to (one or more) Geographic Information System.

" URL " refers to URL(uniform resource locator).

Detailed description and optimal mode

Use description to now the method and system of navigation and visual data from (one or more) relational database and/or multi-dimensional database.In this system, developer's interactively structure visualization system, the tectonic block of this visualization system comprises instrument panel, data source and resource.

With reference to Figure 1A, the simplified block diagram of method and system visual and the navigation multidimensional data that is used for according to an embodiment of the invention has been described.

This block diagram shows Correlation coefficient in the future and gathers, shines upon according to the data in storehouse and be filled to multi-dimensional database.In multi-dimensional database, data are organized by the further mode with multi-dimensional relation.Can be along the data in the definition of a plurality of dimensions and the mapping multi-dimensional database.For example, the data in the sale multi-dimensional database can comprise dimension and the time dimension for dissimilar product, position, client, marketing channel.

Multi-dimensions database system comprises two functions, i.e. multidimensional database server and multi-dimensional database itself.

The multidimensional data library storage about the structural information (metadata) of data and data itself the two.The multidimensional data of multidimensional database server managed storage in multi-dimensional database.Particularly, multidimensional database server allow the user define multidimensional data structure, download data in the multi-dimensional database and to the data that are stored in the multi-dimensional database and carry out user's inquiry.Information to the multidimensional database server inquiry comprises two zones: metadata and user data.The common description scheme information of metadata is such as which multi-dimensional database, available data file, (if any) business rule, dimension, level, drill through path, measurement etc. downwards.User data comprises the real data that is stored in according in the multi-dimensional database of metadata description or definition.

The user can be mutual by user interface, usually by carrying out alternately by means of computing machine or other display screen with mouse, keyboard or any user interface facilities.By the computer program that activates in this system the user is asked or is communicated to alternately visual and navigational system.These requests or can adopt alternately the form of multipath and multistage navigation.In case activate the computer program in visual and the navigational system, request just is communicated to multi-dimensions database system.Multi-dimensions database system retrieval from the metadata of asking of multi-dimensional database and data and by user interface with described presentation of data to the user.

With reference to Figure 1B, the simplified block diagram of method and system that is used for visual and navigation relation data has according to another embodiment of the invention been described.

The relation data library storage about the structural information (metadata) of data and data itself the two.The relation data of relational database server managed storage in relational database.Particularly, relational database server allow user's defining relation data structure, download data in the relational database and to the data that are stored in the relational database and carry out user's inquiry.Information to the relational database server inquiry comprises two zones: metadata and user data.The common description scheme information of metadata, for example which relational database, available data file and business rule (if any).User data comprises the real data that is stored in according in the relational database of metadata description or definition.

The user can be mutual by user interface, usually by carrying out alternately by means of computing machine or other display screen with mouse, keyboard or any user interface facilities.By the computer program that activates in this system the user is asked or is communicated to alternately visual and navigational system.These requests or can adopt alternately the form of multipath and multistage navigation.In case activate the computer program in visual and the navigational system, request just is communicated to relational database system.Relational database system retrieval from the metadata of asking of relational database and data and by user interface with described presentation of data to the user.

Fig. 2 is that explanation is with the figure of the exemplary configurations of the multi-dimensional database of different dimensions layout combined data.In this example, show for the data structure of selling the four-dimension (i.e. zone, client, product and timetable) in the cube (Sales Cube).This structure allows user's definition to analyze or the purpose of visualized data to reach from the multi-dimensional query of any dimension in the four-dimension.

Fig. 3 shows the simplified block diagram 10 of method and system that is used for being designed for the business module of visual and navigation relation data and/or multidimensional data according to described one embodiment of the present of invention.

The method and system comprise that definition can be used for showing better (one or more) business module for the information of specific transactions purpose and target.Described (one or more) business module can be Sales module, finance module, operational module etc., and perhaps it can be the single business module that different business objectives is combined into.

The user can will be divided into different framework 14 at (one or more) business module that computer screen is seen and begin to design business module 12 by design at first.The user has the option of the different zoning of from available template base selection.Zoning new when being necessary can be added in the storehouse.The purpose of these framework subregions 14 is to enable multipath and multistage navigation.Framework can be used to hold control 16 (chart, index dial, image, icon, annotation box, button, color coding alarm button, label, PivotTables etc.), and these controls can be linked to data source with the form to the inquiry of relational database and/or multi-dimensional database.

Then, the user can begin control 16 (chart, index dial, image, icon, annotation box, button, color coding alarm button, label, PivotTables etc.) is inserted in institute's definition frame of (one or more) business module.

Now, the user can continue to configure the control 16 in a plurality of frameworks.These configurations can comprise the attribute of control, namely define to the inquiry of (one or more) data source of relational database and/or multi-dimensional database; The business rule (mathematical computations) that definition is associated with described inquiry; Alarm and threshold condition that definition is associated with described inquiry; In case the alarming method (e-mail alert, SMS alarm etc.) that definition alert threshold condition is taked by running counter to; The definition control drill through action etc.For dissimilar control, configuration attribute may be different with function.In case the control of framework is configured fully, it just can be called as instrument panel 18.

The user can continue that now instrument panel 18 is saved in the business module, to reach the purpose of navigation and visual data from relational database and/or multi-dimensional database.The user can change to edit any these instrument panels 16 in the future by the configuration to control.

According to the present invention, in order to realize multipath and multistage navigation, the user can design and create not at the same level 20 of instrument panel in business module.This provides the method that is used for the novelty of multipath and multistage navigation.In this novel method, the control in the instrument panel (chart, index dial, GIS (Geographic Information System), image, icon, button, color coding alarm button, label) can be configured to have drill through the action 22.These drill through action 22 and have defined any other link that will be extracted and be presented at (one or more) the target instrument panel in the business module and arrive alternatively target service module, URL (URL(uniform resource locator)), website or application etc.Under the working time user model, in case the user clicks control, (one or more) multipath and multistage navigation will be activated according to " drilling through action " of definition with future Correlation coefficient according to the extraction of the data of storehouse and/or multi-dimensional database and be presented on (one or more) target instrument panel, and will be presented in specific frame area or the space from the information of any target instrument panel, URL (URL(uniform resource locator)), website or application etc.And from (one or more) target instrument panel, control can be defined by getting by drilling any other (one or more) target instrument panel again.Therefore, the user can define unconfined multipath and multistage navigation is better visual to realize.Certainly, in fact, some controls can define halt, begin to drill through action from this halt again.

In the final step of design business module, the user is kept at whole module 24 in the Design Mode.The business module of preserving can use under user model immediately, checks, navigates and show the data that are stored in relational database and/or the multi-dimensional database for the user.

Fig. 4 A is the figure of the typical framework subregion in the explanation business module.The user has from the storehouse of predefined framework subregion Selection Framework layout or designs the option of themselves layout.In current embodiment, framework does not have overlapping at display screen.

Fig. 4 B is the figure of " multistage instrument panel " in the explanation business module.This provides " multipath " and " multistage " to drill through action.In given example, in business module, exist to amount to three independent frameworks (framework A, framework B and framework C).These single frameworks can be configured and be configured to a plurality of instrument panels.The number of the instrument panel level of each framework is not limited and does not rely on its adjacent framework.For example, for framework A, it can be configured and be configured to instrument panel level: A1 to AX, and wherein X can be any given number.Similarly, for framework B, it can be configured and be configured to instrument panel level: B1 to BY, and wherein Y can be any given number.Similarly, for framework C, it can be configured and be configured to instrument panel level: C1 to CN, and wherein N can be any given number.

The user has for any given business module structure and configures the dirigibility of instrument panel level of any number of each framework.In each instrument panel, the user can be inserted into the control of any number wherein.Therefore, have the unconfined guidance path group with multipath and multistage mode, according to the needs of user's business and operation with their designs in system.This provides the method that is used for the novelty of multipath and multistage navigation.

Fig. 5 is that explanation can be inserted in the framework figure with the control that forms the instrument panel in the business module.In this example, three frameworks of total are described.This three (3) individual framework is configured and is configured to instrument panel A1, instrument panel B1, instrument panel C1.The instrument panel of the level one (1) of this expression business module.

The user can continue to construct in mode similarly the instrument panel of level 2: instrument panel A2, instrument panel B2, instrument panel C2, etc.

In illustrated example, instrument panel A1 comprises: the control, image and the note that include three (3) individual buttons.

Three (3) individual buttons among the instrument panel A1 can further be defined by having the action of drilling through, so that any instrument panel in the business module is extracted and is presented in the space of given framework.Drilling through action when user's button click is activated.

Image among the instrument panel A1 can be used to describe the association that is displayed on the information in the business module.For example, it can be the picture of product.In this case, it means that chart, index dial and cartographic representation in the corresponding instrument panel (instrument panel B1 and instrument panel C1) is to the measurement of given product.Therefore, the purpose of image is to make the understanding maximization that aligns shown information.This image also can further be defined by having and drill through action so that any instrument panel in the business module is extracted and is presented in the space of given framework.Equally, activation drills through action when the user clicks image.

Similar to the purpose of image, the note among the instrument panel A1 is used to reach the purpose of improving the understanding that aligns shown information.Explain the means of communication between the user that also can be used as system.It can be used to describe just shown information, perhaps even be used for recording and take the action that maybe will take about just shown up-to-date information.

In instrument panel C1, control (alarm button) is stacked on another control world map or the map of GIS (Geographic Information System) Dynamic Generation (namely from).Do like this to make the visual maximization that aligns shown information.Alarm button can be " flash of light " and can be used for representing to the measurement result of the given position in the map conditioned disjunction situation (green, yellow or red) with respect to its target or threshold value.Alarm button also can further be defined as has the action of drilling through so that any instrument panel in the business module is extracted and is presented in the space of given framework.Equally, under the working time user model, when the user clicks alarm button, activate and drill through action.

With reference to figure 6, this is the figure that the general survey of the design interface that is used to the design and structure business module is described.This is to be used for design according to embodiments of the invention can be used for the main design interface of system of visual and navigation relation data and/or multidimensional data.

Main design interface comprises left panel, centre panel and right panel.

In left panel, the user can select four (4) individual different functions by the icon of clicking the left panel bottom.Selected function will appear on the left panel and utilize its function for the user.These four functions are as follows: module browser, tool box, resource browser and instrument panel storehouse.

Centre panel comprises the instrument panel space.This is for control being inserted into framework and configuration control to realize the perform region of instrument panel.

Left panel comprises the attribute function of control.The user can the use attribute function configures target and alarm, e-mail alert, business rule configuration, the color setting that drills through action, font, background and text, color coding, data typing, frame size etc.

Fig. 7 A is figure-left panel (being module browser, tool box, resource browser and instrument panel storehouse) that explanation deviser's difference in functionality is selected.

The module browser can be used to create the group folders (Group folder) that comprises the different business module.It also can be used for creating business module.Usually, this is the main body of whole business modules, because it has held all business modules that design in Design Mode.It is the trunk of whole visual and navigational system.The user can the access modules browser with search and locate any instrument panel, thereby reach the purpose of upgrading or changing the attribute of any control.

The tool box comprises the storehouse of control.During Design Mode, the user can be with any control in these controls (index dial, alarm button, chart, form, button, label, image, annotation box etc.) " drag and drop " to framework.This provides the ability that creates visualization system for the user.

The major function of resources bank (Resource Library) is to allow user's definition to be used for relational query and/or the multi-dimensional query of control.After having defined inquiry, the user can be with in any control of inquiry " drag and drop " in the framework.

Instrument panel storehouse main services is in the purpose of design fresh target instrument panel.All target instrument panels will remain in the instrument panel storehouse, until the defined action that drills through from control to the target instrument panel.When this occurs, the target instrument panel will be passed to one of business module in the module browser.

The major function of attribute is that the permission user configured and customize the control in the framework before the control in the framework is preserved into instrument panel.Attribute can comprise following configuration: target and alarm, e-mail alert, business rule configuration, the color setting that drills through action, font, background and text, color coding, data typing, frame size etc.

With reference to figure 9, this is the figure of the initial setting up of the new group in the specification module browser.According to one embodiment of present invention, the module browser is to be used to Major Systems visual and navigation relation data and/or multidimensional data.It comprises all business modules and is grouped under the different files.In order in the module browser, to create new group, the user can be with the mouse (not shown) with right button and left button or any other computing machine selection equipment select to have designator module browser node of (pointer), and in the situation that selects " establishment group " function with mouse right click module browser node.

Figure 10 is the figure of the new group in the explanation name module browser.After right click module browser node and selection " establishment group " function, pop-up window reveals the title of inputting new group for the user.

Figure 11 is the figure of the initial setting up of the new business module under the new module group that creates of explanation.In order in the module browser, to create new business module, the user can select to have with the mouse (not shown) with right button and left button or any other computing machine selection equipment the group folders node of designator, and in the situation that selects " creation module " function with mouse right click group folders node.

Figure 12 is the figure of the new business module in the explanation name module browser.After right click group folders and selection " creation module " function, pop-up window reveals the title of inputting new module for the user.

Figure 13 is that explanation is for the figure of the selection of the predefine framework zoning template of the new business module that just is being designed.The user has the option of selecting as required or designing any new layout from template base.

Figure 14 is the figure of the example of explanation predefine framework subregion and layout.This only is available layout and the example of subregion, and actual method and system is not subjected to the restriction of illustrated example.The user can be when the new business module of design selects from any framework zoning.

Figure 15 is the figure that explanation resets the size of the framework in the business module.The user selects to reset the framework of size by the zone of clicking framework with any other selection equipment of mouse or computing machine.After finishing this, the user can or drag framework the edge so that framework diminish or become the size that resets greatly framework.The user also can select to reset by the new size that selected framework is inputted in direct property box configuration (property box configuration) to the left panel place size of framework.

If the size of module is greater than being allocated for the space that shows in computer monitor and control unit, then (one or more) scroll bar can automatically appear at the bottom of (one or more) framework and/or right hand edge so that the user checks just shown information.

Figure 16 is explanation is inserted into control framework from the tool box figure.In order to finish such insertion, the respective icon that the user at first locates by the bottom of clicking left panel is selected the tool kit function in the left panel.

In case selected tool kit function, it just appears and is left panel.Previous left panel will disappear and will be replaced by new selection-tool box.Now, the user can continue with from the tool box with control " drag and drop " to corresponding framework.

Figure 17 A is that explanation is to the configuration of the inquiry (Query) of relational database and/or multi-dimensional database and the figure of definition.In order to finish such configuration and definition, the respective icon that the user at first locates by the bottom of clicking left panel is selected the resource browser function in the left panel.

In case selected the resource browser function, it just appears and is left panel.Previous left panel will disappear and will be replaced by new selection-resource browser.Now, the user can continue with defining relation inquiry and/or multi-dimensional query.

Figure 17 B is that explanation will be inquired about (Query) is linked to control from relational database and/or multi-dimensional database figure by dragging inquiry (Query) icon and placing it in the control.In case defined relational query and/or multi-dimensional query according to the illustrated method of Fig. 7 A, the user just can be with should the target control of inquiry " drag and drop " in the framework.

For each control that will be linked to relational database and/or multi-dimensional database, repeat the step among Figure 17 A and Figure 17 B.After the step in Figure 17 A and Figure 17 B, the user can continue to utilize the corresponding configuration in the attribute function to come control in the Configuration Framework.

Figure 18 A is the figure of one of declared attribute (Properties) function (alert threshold of control is set).In order to finish such setting, the user at first comes control in the Selection Framework by clicking control.The user can continue to select configure alert (AlertConfiguration) function of attribute function (being arranged in right panel) by clicking the corresponding description shown in attribute (Property) menu.

In case selected the configure alert function, just manifested " Pop-up " window.Now, the user can continue with input details and click in " Pop-up " window " application (Apply) " button this configuration to be applied to control.

Figure 18 B is the figure of explanation another attribute (Properties) function (e-mail alert is set).In order to finish such setting, the user at first comes control in the Selection Framework by clicking control.The user can continue to select the e-mail alert function of attribute function (being arranged in right panel) by clicking the corresponding description shown in the attribute menu.

In case selected the e-mail alert function, just manifested " Pop-up " window.Now, the user can continue with input details and click " application " button in " Pop-up " window this configuration to be applied to control.

Figure 18 C is the figure of explanation another attribute (Properties) function (type that sets font, size etc.).In order to finish such setting, the user at first comes control in the Selection Framework by clicking control.The user can continue to select font (Font) function of attribute function (being arranged in right panel) by clicking the corresponding description shown in the attribute menu.

In case selected font functionalities, just manifested " Pop-up " window.Now, the user can continue with input details and click " application " button in " Pop-up " window this configuration to be applied to control.

Figure 19 is the figure of example of the complete first order of the explanation business module that comprises three (3) individual instrument panels.All instrument panels all fully dispose corresponding attribute.This is to the described flow process of Figure 18 C and the result of execution in step according to top Figure 11.

Figure 20 is the figure in explanation instrument panel storehouse.This is in order to create new instrument panel according to embodiments of the invention in multistage instrument panel, to reach the purpose of navigation relation data and/or multidimensional data.

In order to finish such establishment, the user at first selects instrument panel library facility in the left panel by the corresponding icon of clicking the left panel bottom.

In case selected the instrument panel library facility, it just appears and is left panel.Previous left panel will disappear and will be replaced by new selection-instrument panel storehouse.Now, the user can continue to input the title of the new instrument panel that will design.

The user can continue to design new instrument panel with the size by the regulation instrument panel.Typically, this size should be corresponding to the virtual framework space that will finally show this instrument panel.It can be more greater or lesser than target virtual framework space.If it is less than virtual framework space, in case instrument panel is extracted and is presented in the virtual target frame space of business module so, just have a bit empty space in the framework.If it is larger than virtual framework space, when instrument panel was extracted and is presented in the virtual target frame space of business module, (at bottom and/or the right hand edge of framework) can appear in (one or more) scroll bar automatically so.

Newly-designed instrument panel will remain in the instrument panel storehouse, be described in the control to link the instrument panel of new establishment until drill through action.When this occurs, the new instrument panel that creates will be passed to the module browser, wherein drilling through the be activated instrument panel of stylish establishment of path and will be extracted being used for and show when control.

Figure 21 be the figure-this function of explanation another attribute (Properties) function namely by selecting to drill through action with the setting (one or more) of getting off:

I) instrument panel (Dashboard): select target framework (target Frame) and target instrument panel (Target Dashboard)

Ii) module (Module): select target framework or complete browser window (FullBrowser Window) and object module (Target Module)

Iii) URL: select target framework or complete browser window and target URL

In order to finish such setting, the user at first comes control in the Selection Framework by clicking control.The user can continue to select the holding function that drills through of attribute function (being arranged in right panel) by clicking the corresponding description shown in the attribute menu.

In case selected to drill through holding function, just manifested " Pop-up " window.Now, the user can continue to input details, for example target framework and target instrument panel.Target framework is the virtual framework space in the business module, and instrument panel is extracted out to be used for demonstration in this virtual framework space.Except being defined into the drilling through the action of (one or more) instrument panel, the user has and will drill through action definition to business module, (one or more) that are used for the URL of website or application for being displayed on virtual framework or being shown as the option of (one or more) target (Target) of complete browser window.

The target instrument panel can be in two (2) individual positions (instrument panel storehouse or module browser) arbitrary (1) individual place.If it is the new instrument panel that creates, it will be arranged in the instrument panel storehouse so.Newly-designed instrument panel will be retained in the instrument panel storehouse until drill through action and be described in the control to link the instrument panel of new establishment.When this occurs, the new instrument panel that creates will be passed to the module browser, wherein drilling through the be activated instrument panel of stylish establishment of path and will be extracted being used for and show when control.

If the target instrument panel is by the action link that drills through from another control, instrument panel will be arranged in the module browser of business module so.This system allows the target instrument panel to be linked to one (1) individual or a plurality of controls.

Figure 22 A is that explanation is convenient to pass on better and the figure of the method understood, wherein the color coding button is placed on the map image or map from GIS (Geographic Information System).GIS map permission user is alternately further and dwindle (zoom down) to details, such as the physical location that is provided by Interactive GIS.This allow user promptly visual on map any given position measurement result with respect to situation or the condition of target or threshold value.

Figure 22 B is that explanation is convenient to pass on better and the figure of the method understood, wherein the color coding button is placed on process (process) image-side.This allows the hurriedly state of some measurement results of visualization process easily at a glance of user.If there is alert consitions, the alarm button that is color-coded so (Alert Button) will be glimmered with redness.Then the user can click the more details that this alarm button is got alert consitions by drilling.

Figure 23 is the figure of the explanation method being convenient to navigate in business module better, and wherein general " backward (Back) " and " forward (Forward) " function are available for all business modules under the working time user model.This provides flexibly guidance path and has eliminated the needs of such characteristic Design in each control.

Figure 24 is that explanation is convenient to pass on better and the figure of the method that cooperates the annotation box that wherein is provided for explaining under the user model in working time (Commentary Box).This feature also can be used to reach the purpose of passing on when processing the warning red condition action that will be taked by the party responsible.

Figure 25 is that the better figure of the method for visual information is convenient in explanation, wherein when on user's the control of mouse in instrument panel, provides " Pop-up text window " under user model.Simple and clean and tidy visual in order to realize.Sometimes be necessary to hide detailed information.Under these circumstances, when user's mouse is on this assembly, detailed information will only appear and be " Pop-up text window ".This method for visualizing is desirable for index dial (Dial) and alarm button.

" Pop-up text window " can show the details of control: the title of control, the measurement of control, the green for control, yellow and red target.

Figure 26 is the figure of explanation example of the navigation under the working time user model and display system for the business module that is named as Sales module.

Figure 27 is the figure of explanation example of the navigation under the working time user model and display system for the business module that is named as procedure module.

Figure 28 is the figure of explanation example of the navigation under the working time user model and display system for the business module that is named as the human resources module.

In the example by the business module of the user model of Figure 26, Figure 27 and Figure 28 explanation, the user can carry out relationship analysis and/or multidimensional analysis to chart.New business rule and mathematical computations chart can be applied to, and under user model, the result can be directly checked.The user can preserve new chart that (Save) form by business rule to analyze better the data from relational database and/or multi-dimensional database.

The user can carry out additional extemporaneous inquiry to relational database and/or multi-dimensional database.The user can preserve from the extemporaneous new chart of inquiring about to analyze better the data from relational database and/or multi-dimensional database.

Figure 29 A is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses." upwards drilling through " icon 32 and " expansion and contraction characteristic chart " icon 34 were provided under the user model in working time.

In the analysis to chart, the user can usually " drill through " by any unit that clicks chart the details with analysis diagram downwards.After finishing this, the user can be by the icon 32 " upwards drilling through " that provides under user's pattern working time be provided.

In the analysis to chart, the user can be by clickable icon 34 " expansion and shrink characteristic chart " with more features and the function of access chart.

Figure 29 B is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses, and characteristic chart and changes of function were provided under the user model in working time.

Can be by clicking " expansion (expand) " thereby to show that more icons visit these characteristic charts and function for the icon 34 that the user correspondingly selects.

Icon 34 can again be clicked correspondingly " shrink (contract) " and be hidden characteristic chart and function.

The below is exemplary and nonrestrictive characteristic chart and function:

42 change chart is shown as bar chart.

44 change chart is shown as pie chars.

46 change chart is shown as Line Chart.

48 change chart is shown as form.

50 change chart is shown as storehouse bar chart (Stack Bar Chart).

The application that 52 output charts are shown to Microsoft Excel or are equal to.

The document that 54 output charts are shown to Microsoft Word or are equal to.

The expression application that 56 output charts are shown to Microsoft PowerPoint or are equal to.

58 output charts are shown to other form and are not limited to JPEG, Bitmap, XML, text.

60 output charts show to be used for the printout in the printing device such as printer.

62 send chart by internet, wireless application or any other communication media with Email.

64 are applied to chart with the business rule such as mathematical function (Mathematical Function).

Use and change the attribute that characteristic chart (Change Chart feature) changes subtype.This can comprise given chart " sense organ (look and feel) " and this chart is changed over dissimilar chart.

The user has " preservation " new chart to analyze better and visual option.

66 pairs show chart application " ascending order (Ascending) " function, so that it will come displayed value from the minimum to the mxm..

68 pairs show chart application " descending (Descending) " function, so that it will come displayed value from the mxm. to the minimum.

70 display applications that will " turn back to original (Back to Original) " are in chart.

72 are presented at chart on the computer monitor and control unit with " full frame (Full Screen) ".

74 based on chart values demonstration " front (Top) " several elements.

76 based on the several elements of chart values demonstration " rear (Bottom) ".

Figure 30 is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses and extemporaneous inquiry, and the Query Builder with business rule ability and function wherein is provided under the user model in working time.

The user can come relational database and/or multi-dimensional database are carried out extemporaneous inquiry with Query Builder.The chart that in addition, business rule can be applied to just be shown.

Figure 31 is the figure that explanation is convenient to better relation data and/or multidimensional data are carried out the method and system of graphic analyses and extemporaneous inquiry, and the Query Builder with business rule ability and function wherein is provided under the user model in working time.

The user can come relational database and/or multi-dimensional database are carried out extemporaneous inquiry with Query Builder.After each inquiry, less chart will eject, and wherein the result of inquiry is shown.Inquiry can be repeated repeatedly, causes showing a plurality of ejection charts.The user can continue to think one or more business rule or the mathematical computations of arranging in these charts.The user also can " drag and drop " or the result of combination chart, and the new chart with the result who makes up will be shown.

Figure 32 is the figure that explanation can be used the example of computing system environments 80 of the present invention.This system environments 80 comprises memory device 82, storage device interface 84, CPU (central processing unit) (CPU) 86, memory devices 88, display interface 90, display monitor 92, computer bus 94, mouse 96, keyboard 98 and wireless device 100.

Utilize the operation of computer bus 94, mouse 96, keyboard 98 and wireless device 100 can be provided to the input of computer system.

Software code (perhaps its whole or its part) can be stored in the two the combination of computer readable memory devices 88 or memory device 82 or memory devices 88 and memory device 82.In addition, the computer data signal of expression software code can be contained in the carrier wave that can be transmitted via communication network.

CPU (central processing unit) (CPU) 86 can reference-to storage equipment 88 and memory device 82, and can control by execution the program in memory devices 88 or the memory device 82 of being stored in the operation of computing machine.

Can provide performed program and the graphic interface between the user together with the operation of display interface 90, display monitor 92.

The method and system of the data that are used for navigation and visual relational database and/or multi-dimensional database described in the invention can be implemented by the combination of any hardware, software or hardware and software with above-mentioned functions.

Will be understood that, the present invention is best suited for software and realizes, and the mode that combines with the computing machine with the unit with Standard User interfacing equipment or networking and being used.Can software be offered the user by many methods, the method is on-line purchase and permanent haulage line or wireless connections download by arriving the Internet for example, or is recorded on the computer program medium of any type such as light, magnetic, magneto-optic and solid-state memory.Detailed disclosing is enough to make those of ordinary skills to write out the necessary program code of described function herein.

(one or more) relational database and/or multi-dimensional database may be provided on the computer system, and this computer system is with operation application of the present invention or identical via the computer system of combinations communication link long range positioning and access or these options.

Although illustrated and described specific embodiment of the present invention, can such embodiment be changed and revise in the situation that do not depart from the real scope of the present invention.Therefore, scope of the present invention does not plan to be restricted to explanation of the present invention and description.

Claims

1. one kind is used for visual and navigation from least one the computer implemented method of data of relational database or multi-dimensional database, and the method may further comprise the steps:

A) define at least one and be used to show module for comprehensive graphics view of the information of particular organization or business purpose and target;

B) will become a plurality of frameworks at least one Module Division that display screen is seen, its middle frame is the subregion that display screen is divided into less window;

C) control is inserted in the defined framework of described at least one module, wherein control definition is at least one the inquiry in relational database or the multi-dimensional database, and any rule that is associated with these inquiries;

D) attribute and the business rule of the control in the described framework are configured to create instrument panel, wherein instrument panel is the framework that comprises pre-configured control;

E) set up multistage described instrument panel for each described framework, described multistage instrument panel refers to the not at the same level of instrument panel in the module, is used for allowing the user to be assigned to the multipath of the target instrument panel in not at the same level and multistagely drills through action; And

F) for the relevant control in each described instrument panel, for the multipath of described instrument panel and multistage navigation and arranging to other drill through action finishing at least one module,

Wherein, describedly drill through action by according to the instrument panel that is come any one-level in multistage in described each framework of demonstration screen display by the control of user selection, provide multipath and multistage navigation to realize visual to the data at least one relational database and/or the multi-dimensional database

The navigation of described multipath refer to take in order to arriving the different navigation path of one or more target instrument panels that will be shown, and,

Multistage navigation refers to the different navigation level of the instrument panel in the module.

2. computer implemented method according to claim 1 also is included as the action that drills through that control in the instrument panel is set to any other module, outside URL(uniform resource locator), website or application.

3. computer implemented method according to claim 1, wherein said control is configured to have the action that drills through at least to instrument panel, URL or application.

4. computer implemented method according to claim 1, a framework in wherein said a plurality of framework is adapted to be and shows the expression relevant with the different phase of process, show explicitly corresponding control with described expression, described control has for the action that drills through of extracting and show the further information relevant with the process stage that is associated at one or more other frameworks of described a plurality of frameworks.

5. computer implemented method according to claim 4, wherein according to the relevant result of at least one the inquiry in described relational database or the multi-dimensional database and the comparison of target or threshold value, the control that shows explicitly with described expression is carried out color coding.

6. computer implemented method according to claim 1, wherein each in a plurality of frameworks comprises respectively nonoverlapping border.

7. computer implemented method according to claim 1, the number that wherein is used for any one instrument panel level of described framework does not rely on the number of the instrument panel level in any other framework.

8. computer implemented method according to claim 1, wherein said method also is included in step b) use afterwards the Query Builder with business rule ability, to be used for carrying out the extemporaneous inquiry at least one of described relational database or multi-dimensional database.

9. computer implemented method that is used for navigation and visual data at relational database or multi-dimensional database at least one, the method may further comprise the steps:

A) display screen is divided into a plurality of frameworks, its middle frame refers to the subregion that display screen is divided into less window;

B) in each framework of described a plurality of frameworks, insert and configure control to form instrument panel, wherein instrument panel is the framework that comprises pre-configured control, and wherein control definition is at least one the inquiry in relational database or the multi-dimensional database, and any rule that is associated with these inquiries; And

C) be that each framework in described a plurality of framework creates multistage described instrument panel, described multistage instrument panel refers to the not at the same level of instrument panel in the module, is used for allowing the user to be assigned to the multipath of the target instrument panel in not at the same level and multistagely drills through action;

The step that wherein configures control comprises that the user is the action that drills through that control in each instrument panel is defined into any grade target instrument panel in the multistage instrument panel, described target instrument panel is included in the instrument panel in the framework identical with described each instrument panel, and is included in the instrument panel in other framework in described a plurality of framework;

Whereby, describedly drill through action by according to the instrument panel that is come any one-level in multistage in described each framework of demonstration screen display by the control of user selection, provide multipath and multistage navigation to realize visual to the data in described at least one relational database and/or the multi-dimensional database

10. one kind is used for visual and navigation from least one the computer implemented system of data of relational database or multi-dimensional database, and this system comprises for following device:

At least one is used to show device for the module of comprehensive image views of the information of particular organization or business purpose and target to be used for definition;

Be used for becoming at least one Module Division that display screen is seen the device of different frames, its middle frame is the subregion that display screen is divided into less window;

Be used for control is inserted into the device of the defined framework of described module, wherein the control definition is at least one the inquiry in relational database or the multi-dimensional database, and any rule that is associated with these inquiries;

Be used for the attribute of the control of described framework and the device that business rule is configured to create instrument panel, wherein instrument panel is the framework that comprises pre-configured control;

Be used for setting up for each described framework the device of multistage described instrument panel, described multistage instrument panel refers to the not at the same level of instrument panel in the module, is used for allowing the user to be assigned to the multipath of the target instrument panel in not at the same level and multistagely drills through action;

Be used for the relevant control for each described instrument panel, for the multipath of described instrument panel and the multistage navigation and arrange to drill through and move to finish the device of at least one module to other;

11. computer implemented system according to claim 10, wherein said control comprises chart, index dial, Geographic Information System GIS, label, image, icon, annotation box, button, alarm button, PivotTables,

For the ease of the mutual and analysis to the chart in the instrument panel of any described module, generator, the user can be applied to chart with new business rule and mathematical computations whereby, and directly checks its result under user model.

12. computer implemented system according to claim 10, wherein said control comprises chart, index dial, Geographic Information System GIS, label, image, icon, annotation box, button, alarm button, PivotTables,

This system comprises and can operate under working time, user model and be the each extemporaneous Query Builder query generation chart, that have business rule ability and function, and the user uses described Query Builder that in described relational database or the multi-dimensional database at least one carried out extemporaneous inquiry whereby.

13. computer implemented system according to claim 12, generator wherein, whereby user's chart that business rule can be applied to just be shown and it is stored as new chart or the user can save as new chart for the chart that each extemporaneous inquiry generates.

14. a computer-implemented design tool that is used for the data at least one of navigation and visual relational database or multi-dimensional database, this design tool comprises:

Be used for display screen is divided into the device of a plurality of frameworks, its middle frame is the subregion that display screen is divided into less window;

Be used in each framework of described a plurality of frameworks, inserting and configuring control with the device of formation instrument panel, wherein instrument panel is the framework that comprises pre-configured control, and wherein control definition in described relational database or the multi-dimensional database at least one inquiry and any rule that is associated with these inquiries; And

Be used to each framework in described a plurality of framework to create the device of multistage described instrument panel, described multistage instrument panel refers to the not at the same level of instrument panel in the module, is used for allowing the user to be assigned to the multipath of the target instrument panel in not at the same level and multistagely drills through action;

The described device that wherein is used for the configuration control comprises that the user is the action that drills through that the control of each instrument panel is defined into any grade target instrument panel in the described multistage instrument panel, described target instrument panel is included in the instrument panel in the framework identical with described each instrument panel, and is included in the instrument panel in other framework in described a plurality of framework;

Whereby, describedly drill through action by according to the instrument panel that is come any one-level in multistage in described each framework of demonstration screen display by the control of user selection, multipath and multistage navigation are provided, thereby realize visual to the data in described relational database or the multi-dimensional database at least one

15. computer-implemented design tool according to claim 14 also is included as the action that drills through that control in the instrument panel is set to any other module, outside URL(uniform resource locator), website or application.

16. computer-implemented design tool according to claim 14, wherein said control are configured to have the action that drills through at least to instrument panel, URL or application.

17. computer-implemented design tool according to claim 14, each framework in wherein said a plurality of frameworks comprises respectively nonoverlapping border.

18. computer-implemented design tool according to claim 14, the number that wherein is used for any one instrument panel level of described framework does not rely on the number of the instrument panel level in any other described framework.

19. computer-implemented design tool according to claim 14, wherein said instrument also are included in display screen is divided into the Query Builder with business rule ability of extemporaneous inquiry that is used for after a plurality of frameworks carrying out at least one of described relational database or multi-dimensional database.

20. computer-implemented design tool according to claim 14, generator wherein, whereby user's chart that business rule can be applied to just be shown and it is stored as new chart or the user can save as new chart for the chart that each extemporaneous inquiry generates.