CN101622619A

CN101622619A - Be used for navigating and the method and system of the data of visual relational database and/or multi-dimensional database

Info

Publication number: CN101622619A
Application number: CN200780052005A
Authority: CN
Inventors: 丁行俊
Original assignee: 丁行俊
Current assignee: Tokuda Mihiro business intelligence Ltd
Priority date: 2007-04-10
Filing date: 2007-04-10
Publication date: 2010-01-06
Anticipated expiration: 2027-04-10
Also published as: CN101622619B; EP2137643A1; WO2008122830A1; EP2137643A4; HK1140557A1

Abstract

A kind ofly be used for navigating and the data computing machine of visual at least one relational database and/or multi-dimensional database is implemented design tool.This design tool allows the user that display screen is divided into a plurality of frameworks; Insert and dispose control to form instrument panel in each framework, this control definition is to inquiry of (one or more) database and any rule that is associated with these inquiries; And create for each framework and to have multistage instrument panel.The configuration control is permitted the drill through action of user for the target instrument panel in any level that the control in each instrument panel is defined in multistage, and these two instrument panels are all in the framework identical with the beginning instrument panel, also in any or all framework in other framework.By on display screen, show arbitrary grade respective objects instrument panel in multistage in each framework according to the control of selecting by the user, user-definedly drill through action the multipath and the multistage navigation of powerful and high flexibility are provided, thereby realize the visualization of data in (one or more) database.

Description

Be used for navigating and the method and system of the data of 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 the method and system that is used for video data, and relates in particular to and be used for navigating and the visual method and system that is stored in the data of relational database and/or multi-dimensional database.

Background technology

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

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

Visit 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 use computer graphical to utilize human perception and to provide information and user-friendly mode to organize data.Therefore, make very big effort and developed the instrument that is used to show with 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 data present comprehensive view.In addition, these traditional instruments only allow the user to design and are used to show and navigate and navigate to (unidirectional) from " one click (the one click) " of the data of relational database and/or multi-dimensional database or predetermined single path and the folk prescription that order 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 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 in addition, 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 ofly for the user provides the improved computer implemented method and the system of comprehensive business intelligence (businessintelligence) system, the user cooperates and communicates by letter at the information that shows from relational database and/or multi-dimensional database simultaneously.

Still need to provide a kind of comprehensive and user-friendly improved computer implemented method and system that is used for navigating and shows 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 and a kind ofly be used for navigating and the data computing machine of visual at least one relational database and/or multi-dimensional database is implemented the business intelligence instrument.This design tool allows the user that display screen is divided into a plurality of frameworks (frame); Insert and dispose control (control) to form instrument panel (dashboard) in each framework, described control definition is to 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 on display screen, show arbitrary grade respective objects instrument panel in multistage in each framework according to the control of selecting by the user, user-definedly drill through action the multipath and the multistage navigation of powerful and high flexibility are provided, thereby realize the visualization of data in (one or more) database.

From broad aspect, the invention provides and be used for navigating 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 visit 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 method that is used for visual and navigation from the data computing machine system of relational database and/or multi-dimensional database.This method comprises that definition can be used for showing better (one or more) business module of the information that is used for specific transactions purpose and target (objective).Described (one or more) business module can be Sales module, finance module, operational module or the like, 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 system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises the device (means) that is used to define (one or more) business module that can be used to show better the information that is used for specific transactions purpose and target.Described (one or more) business module can be Sales module, finance module, operational module or the like, 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 method that is used for visual and navigation from the data computing machine system of relational database and/or multi-dimensional database.This method comprises that (one or more) business module that will see is divided into a plurality of frameworks on computer screen.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 system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises the device that is used for (one or more) business module of seeing is divided into a plurality of frameworks on computer screen.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 method that is used for visual and navigation from the data computing machine system of relational database and/or multi-dimensional database.This 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 system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises the device that is used for 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 method that is used for visual and navigation from the data computing machine system of relational database and/or multi-dimensional database.This method is included in a plurality of frameworks and disposes control.These configurations can comprise the attribute of control, promptly 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 controls, configuration attribute may be different with function.In case the control of framework is disposed fully, it just can be called as instrument panel.

According to another aspect of the present invention, provide a kind of system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises the device that is used at different frames configuration control.These configurations can comprise the attribute of control, promptly 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 controls, configuration attribute may be different with function.In case the control of framework is disposed fully, it just can be called as instrument panel.

According to another aspect of the present invention, provide a kind of method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.Any control that this method is included as in the instrument panel disposes 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 what its business module, URL (URL(uniform resource locator)), website or application etc. alternatively 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 click to control, specified drill through action and will take place.(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 system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.Any control that this system is included as in the instrument panel disposes 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 what its business module, URL (URL(uniform resource locator)), website or application etc. alternatively 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 click to control, specified drill through action and will take place.(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 method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This 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 by the configuration to control in the future and edits any of these instrument panel.

According to another aspect of the present invention, provide a kind of system that is used for visual and navigation 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 by the configuration to control in the future and edits any of these instrument panel.

According to another aspect of the present invention, provide a kind of method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This 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 for the novelty that is used for 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 demonstration (one or more) target instrument panel.And from (one or more) target instrument panel, control can be defined once more to get (drill to) any other (one or more) target instrument panel by drilling.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 system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises the device not at the same level that is used for creating at business module instrument panel.This provides the method for the novelty that is used for 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 once more to get any other (one or more) target instrument panel by drilling.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 method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This 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 the 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 (drill backward) backward or drill through forward of having moved that drills through.

According to another aspect of the present invention, provide a kind of system that is used for visual and navigation 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 the 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 method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This method comprises and is placed on (one or more) color coding alarm button on the image or is close to image, to pass on the visual meaning that is associated with image better.Image can be map, process, activity (activity), people's a 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 at the data that just are being shown 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 used to represent usually that " good (Good) ", yellow are used to represent " average (Average) ", redness is used to represent " bad (No Good) ".The information that just is being shown is convenient to understand in this color coding system, and passes on easily 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 system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises and is used for being placed on (one or more) color coding alarm button on the image or is close to image to pass on the device of the visual meaning that is associated with image better.Image can be map, process, activity, people's a 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 used to represent usually that " good ", yellow are used to represent " on average ", redness is used to represent " bad ".The information that just is being shown is convenient to understand in this color coding system, and passes on easily 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 method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This 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 at the information in the instrument panel.This is convenient to cooperate and the meaning, the state that are associated with information in instrument panel and the overall traffic module of reception and registration or the action of being taked easily.

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

According to another aspect of the present invention, provide a kind of method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.The mouse that this method is included in the user illustrates " the text pop-up window " of the 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 system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises the device of " the text pop-up window " of reality that this control is shown when the mouse that is used for the user is on control and desired value.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 method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This 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 the data from relational database and/or multi-dimensional database better.

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 the data from relational database and/or multi-dimensional database better.

According to another aspect of the present invention, provide a kind of system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises the device that is used to allow that new business rule and mathematical computations be applied to 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 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 the data from relational database and/or multi-dimensional database better.

According to another aspect of the present invention, provide a kind of method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This method comprises having the details of feature to come analysis diagram by any element (element) of clicking chart that is similar to " drilling through (drill-down) downwards ".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) " more feature and function with the visit chart by the icon of clicking above the chart.

According to another aspect of the present invention, provide a kind of system that is used for visual and navigation from the data of relational database and/or multi-dimensional database.This system comprises having and is used to provide 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 " more feature and function with the visit chart by the icon of clicking above the chart.

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

According to another aspect of the present invention, provide a kind of system that is used for visual and navigation 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 method that is used for visual and navigation from the data of relational database and/or multi-dimensional database in computer system.This method comprises uses the extemporaneous inquiry of Query Builder to 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 being provided with in these charts.The user can be with any chart " drag and drop " to another chart, and the result who is made 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 the data from relational database and/or multi-dimensional database better.

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

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 being provided with in these charts.The user can be with any chart " drag and drop " to another chart, and the result who is made up can be shown as new chart.

In basic embodiment, only individual module need be created and preserve.Yet, in fact, can create and preserve the module that two or more relate to the different business aspect, for example Sales module, finance module, operational module or the like very expediently usually.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's facility, 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 under the situation of not carrying out any programming.User interface can be created fast and easily to satisfy concrete service needed.

Multipath and multistage navigation characteristic make the user navigate and to check data at any angle and make the more approaching data that are stored in relational database and/or the multi-dimensional database of user thus.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 better professional decision thus.

To the browsing of following detailed, others 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 of the general survey of the explanation design interface that is used to design and construct business module.This be according to an embodiment of the invention be used to design can be used for the main design interface of system of visual and navigation relation data and/or multidimensional data.

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 of creating.

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

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

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

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

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 be provided with alert threshold of control of one of declared attribute (Properties) function.

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

Figure 18 C is 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 " (Back) backward " 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 for cooperating, wherein the annotation box that is provided for explaining under the user model in working time (Commentary Box).

Figure 25 is that the figure of the method for visual information better 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 to be named as Sales module (Sales Module) in working time under the user model and display system.

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

Figure 28 is the figure of the example of the navigation of the explanation business module that is used to be named as human resources module (Human Resource Module) in working time under the 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 can the result be moved to any master map table in the business module by " drag and drop " then.

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 is described below 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 disclosed principle in the place the widest scope consistent with feature therewith.

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 the assembly that is used for display message.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 littler 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.Hold at framework under the situation of 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 that is used for specific transactions purpose and target.It can be Sales module, finance module, operational module or the like, 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 the Management Information Base that the user distributes to 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 taked 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 (drill-sideways) from the side " 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 the method and system of navigation and visual data from (one or more) relational database and/or multi-dimensional database now.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 and the data from relational database are gathered, shine upon and is 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 a plurality of dimension definition and the mapping multi-dimensional database.For example, the data of selling in the multi-dimensional database can comprise dimension and the time dimension that is used for dissimilar products, position, client, marketing channel.

The multi-dimensional 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 definition multidimensional data structure, download data in the multi-dimensional database and and carry out user inquiring the data that are stored in the multi-dimensional database.Comprise two zones to the multidimensional database server information inquiring: metadata and user data.The common description scheme information of metadata, for example 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 using mouse, keyboard or Any user interfacing equipment to carry out alternately by means of computing machine or other display screen.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 the form of multipath and multistage navigation alternately.In case activate the computer program in visual and the navigational system, request just is communicated to the multi-dimensional database system.Multi-dimensional database system retrieval is presented to the user from the metadata of being asked of multi-dimensional database and data and by user interface with described data.

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 the user definition relation data structure, download data in the relational database and and carry out user inquiring the data that are stored in the relational database.Comprise two zones to the relational database server information inquiring: 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 using mouse, keyboard or Any user interfacing equipment to carry out alternately by means of computing machine or other display screen.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 the form of multipath and multistage navigation alternately.In case activate the computer program in visual and the navigational system, request just is communicated to relational database system.Relational database system retrieval is presented to the user from the metadata of being asked of relational database and data and by user interface with described data.

Fig. 2 is the figure of explanation with the exemplary configurations of the multi-dimensional database of different dimensions layout combined data.In this example, show at the data structure of selling the four-dimension (i.e. zone, client, product and timetable) in the cube (Sales Cube).This structure allows user 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.

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

The user can be divided into different framework 14 by (one or more) business module that will see of design at first and begin to design business module 12 on computer screen.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 dispose the control 16 in a plurality of frameworks.These configurations can comprise the attribute of control, promptly 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 (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 controls, configuration attribute may be different with function.In case the control of framework is disposed fully, it just can be called as instrument panel 18.

The user can continue now so that 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 by the configuration to control in the future and edits any of these instrument panel 16.

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 for the novelty that is used for 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 target service module, URL (URL(uniform resource locator)), website or application etc. alternatively.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 will and being presented on (one or more) target instrument panel from the data extract of relational database and/or multi-dimensional database, and will be presented in the specific frame area or 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 once more.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 again from this halt.

In the final step of design business module, the user is kept at whole module 24 in the Design Mode.The business module of being preserved 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 on 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 the dirigibility of instrument panel level of disposing any number of each framework.In each instrument panel, the user can be inserted into the control of any number wherein.Therefore, have 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 for the novelty that is used for 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, or the like.

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 the information that is shown.This image also 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.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 the information that is shown.Explain the means of communication between the user that also can be used as system.It can be used to describe the information that just is being shown, perhaps even be used for writing down about the up-to-date information that just is being shown and the action taking maybe will take.

In instrument panel C1, control (alarm button) is overlayed on another control (i.e. world map or the map that dynamically produces from GIS (Geographic Information System)).Do like this and make the visual maximization that aligns the information that is shown.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 of the general survey of the explanation design interface that is used to design and construct business module.This is to be used to design according to embodiments of the invention to 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 to be used for control being inserted into framework and disposing control to realize the perform region of instrument panel.

Left panel comprises the attribute function of control.The user can the use attribute function disposes 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 or the like.

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 of creating visualization system for the user.

The major function of resources bank (Resource Library) is to allow user definition to be used for the 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.

The purpose of design fresh target instrument panel is mainly served in the instrument panel storehouse.All target instrument panels will remain in the instrument panel storehouse, up to define from control to the target instrument panel drill through action till.When this takes place, 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 disposed 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 or the like.

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 main system 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 use 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 right click module browser node is selected " establishment group " function under the situation of using mouse.

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 importing 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 of creating of explanation.In order in the module browser, to create new business module, the group folders node that the user can use mouse (not shown) with right button and left button or any other computing machine selection equipment to select to have designator, and right click group folders node is selected " creation module " function under the situation of using mouse.

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 importing new module for the user.

Figure 13 is the figure of selection of the predefine framework zoning template of the explanation new business module that is used for just 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 the available layout and the example of subregion, and practical methods and system are 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 the size of the framework in the business module is reset in explanation.The framework of size is selected to reset in the zone that the user clicks framework by any other selection equipment that uses mouse or computing machine.After finishing this, the user can or drag framework the edge so that framework diminish or become the size of resetting framework greatly.The user also can select to reset the size of framework by the new size that selected framework is imported in direct property box configuration (property box configuration) to the left panel place.

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 the information that just is being shown.

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 box function in the left panel.

In case selected the tool box 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 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 import 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 littler than virtual framework space,, just have a bit empty space in the framework in case instrument panel is extracted and is presented in the virtual target frame space of business module so.If it is bigger than virtual framework space, when instrument panel was extracted and is presented in the virtual target frame space of business module, (at the 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, till drilling through action and being described in the control with the instrument panel that links new establishment.When this takes place, the new instrument panel of creating 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 is that figure-this function of explanation another attribute (Properties) function promptly drills through action by selection 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 with 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 at arbitrary (1) the individual place in two (2) individual positions (instrument panel storehouse or module browser).If it is the new instrument panel of creating, it will be arranged in the instrument panel storehouse so.Newly-designed instrument panel will be retained in the instrument panel storehouse till drilling through action and being described in the control with the instrument panel that links new establishment.When this takes place, the new instrument panel of creating 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 further mutual and dwindle (zoom down) to details, such as the physical location that is provided by the interactive GIS system.This allow user promptly visual on map any given position measurement result with respect to the 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 user's state of some measurement results of visualization process easily at a glance hurriedly.If there is alert consitions, will be glimmered with redness by color-coded alarm button (Alert Button) so.The user can click the more details that this alarm button is got alert consitions by drilling then.

Figure 23 is the figure of the explanation method being convenient to navigate in business module better, and wherein general " (Back) backward " 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 for cooperating, wherein the annotation box that is provided for explaining under the user model in working time (Commentary Box).This feature also can be used to reach the purpose of the action that reception and registration will be taked by the party responsible when handling the warning red condition.

Figure 25 is that the figure of the method for visual information better 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 the data from relational database and/or multi-dimensional database better.

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 the data from relational database and/or multi-dimensional database better.

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 " details with analysis diagram by any unit that clicks chart 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 analysis to chart, the user can be by clickable icon 34 " expansion and shrink characteristic chart " with the more features and the function of visit 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 with " 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 be clicked once more correspondingly " to shrink (contract) " and to hide characteristic chart and function.

Be exemplary and nonrestrictive characteristic chart and function below:

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 will be applied to chart such as the business rule the 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 charts.

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 " preceding (Top) " several elements.

76 based on the several elements of chart values demonstration " back (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 use Query Builder to come relational database and/or multi-dimensional database are carried out extemporaneous inquiry.In addition, the chart that 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 use Query Builder to come relational database and/or multi-dimensional database are carried out extemporaneous inquiry.After each inquiry, less chart will eject, and wherein Cha Xun result 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 being provided with in these charts.The user also can " drag and drop " or the result of combination chart, and the new chart with the result who is made 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 come the operation of control computer by execution the program in memory devices 88 or the memory device 82 of being stored in.

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

Described in the invention be used for navigating and the method and system of the data of visual relational database and/or multi-dimensional database 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 unit with Standard User interfacing equipment or networking and being used.Can software be offered the user by many methods, the for example on-line purchase and pass through to the permanent haulage line of the Internet or wireless connections are downloaded of this method, or be recorded on the computer program medium of any kind such as light, magnetic, magneto-optic and solid-state memory.Detailed herein disclosing is enough to make those of ordinary skills to write out the necessary program code of described function.

(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 visit or these options.

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

Claims

1, a kind of at least one data computing machine implementation method that is used for visual and navigation from relational database or multi-dimensional database, this method may further comprise the steps:

A) define the module that at least one can be used to show better the information that is used for particular organization or business purpose and target;

B) at least one Module Division that will see on display screen becomes a plurality of frameworks;

C) control is inserted in the defined framework of described at least one module;

D) be configured in the attribute of the control in the described framework and business rule to create instrument panel;

E) set up multistage described instrument panel for each described framework; And

F) at the relevant control in each described instrument panel, for the multipath of described instrument panel and multistage navigation and be provided with and drill through action to finish at least one module to other.

2, a kind ofly be used for navigating and visual data computing machine implementation method at relational database or multi-dimensional database at least one, this method may further comprise the steps:

A) display screen is divided into a plurality of frameworks;

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

C) be that each described framework is created multistage described instrument panel;

The step that wherein disposes 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 described level, 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, provide multipath and multistage navigation to realize to the visualization of data at least one relational database and/or the multi-dimensional database by come on described display screen, to show the corresponding target instrument panel of any one-level in multistage in each framework according to the control of selecting by described user.

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

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

5, 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 corresponding control explicitly with described expression, described control has the action that drills through that is used for extracting and showing at one or more other frameworks of described a plurality of frameworks the further information relevant with the process stage that is associated.

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

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

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

9, computer implemented method according to claim 1, wherein said method also comprise the Query Builder that use has the business rule ability, to be used for carrying out the extemporaneous inquiry at least one of described relational database or multi-dimensional database.

10, a kind of at least one data computing machine implementation system that is used for visual and navigation from relational database or multi-dimensional database, this system comprises and is used for following device:

Define the module that at least one can be used to show the information that is used for particular organization or business purpose and target;

At least one Module Division that to see on display screen becomes a plurality of frameworks;

Control is inserted in the defined framework of described module;

Dispose the attribute of the control in the described framework and business rule to create instrument panel;

Set up multistage described instrument panel for each described framework;

At the relevant control in each described instrument panel, for the multipath of described instrument panel and multistage navigation and be provided with and drill through action to other; And

The difference setting of preserving instrument panel is to finish at least one module of preparing to be used for multipath and multistage navigation.

11, visual and navigational system according to claim 10, wherein for the ease of mutual and analysis to the chart in the instrument panel of any described business 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, visual and navigational system according to claim 10, wherein for the ease of mutual and analysis to the chart in the instrument panel of any described business module, generator, the user can carry out relationship analysis and/or multidimensional analysis to chart whereby, this system comprises the Query Builder that can operate, have business rule ability and function under working time, user model, the user uses described Query Builder to the extemporaneous inquiry of at least one execution in described relational database or the multi-dimensional database whereby.

13, visual and navigational system according to claim 11, generator wherein, the user can save as new chart with the rule newly used and the result of result calculated or inquiry whereby.

14, a kind of be used for navigating and at least one of visual relational database or multi-dimensional database in the data computing machine implement design tool, this design tool comprises:

Be used for display screen is divided into the device of a plurality of frameworks;

Be used for inserting and be configured in control in each frameworks of described a plurality of frameworks to form the device of instrument panel, wherein the 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;

The described device that wherein is used for disposing control is permitted the user is defined into any grade target instrument panel in the described level for the control of each instrument panel the action that drills through, 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 come on described display screen, to show the corresponding target instrument panel of any one-level in multistage in each framework according to the control of selecting by described user, multipath and multistage navigation are provided, thereby realize the visualization of data in described relational database or the multi-dimensional database at least one.

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

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

17, computer implemented method according to claim 2, each framework in wherein said a plurality of frameworks comprises nonoverlapping border respectively.

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

19, computer implemented method according to claim 2, wherein said method also comprise the Query Builder that use has the business rule ability, to be used for carrying out the extemporaneous inquiry at least one of described relational database or multi-dimensional database.

20, visual and navigational system according to claim 12, generator wherein, the user can save as new chart with the rule newly used and the result of result calculated or inquiry whereby.