EP2137643A1 - Procédé et système pour une navigation et une visualisation de données dans des bases de données relationnelles et/ou multidimensionnelles - Google Patents

Procédé et système pour une navigation et une visualisation de données dans des bases de données relationnelles et/ou multidimensionnelles

Info

Publication number
EP2137643A1
EP2137643A1 EP07734323A EP07734323A EP2137643A1 EP 2137643 A1 EP2137643 A1 EP 2137643A1 EP 07734323 A EP07734323 A EP 07734323A EP 07734323 A EP07734323 A EP 07734323A EP 2137643 A1 EP2137643 A1 EP 2137643A1
Authority
EP
European Patent Office
Prior art keywords
user
dashboard
controls
relational
frames
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Withdrawn
Application number
EP07734323A
Other languages
German (de)
English (en)
Other versions
EP2137643A4 (fr
Inventor
Heng Toon Ting
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Publication of EP2137643A1 publication Critical patent/EP2137643A1/fr
Publication of EP2137643A4 publication Critical patent/EP2137643A4/fr
Withdrawn legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26—Visual data mining; Browsing structured data

Definitions

  • the present invention resides in the technical field of graphical user interfaces. It relates generally to a method and system for displaying data, and more particularly, to a method and system for navigating and visualizing data stored in relational and/or multidimensional databases.
  • the data in multidimensional databases can be defined and mapped along multiple dimensions.
  • the data in a sales multidimensional database may include dimensions for the different types of products, locations, customers, sales channels and time dimensions.
  • a goal of any information visualization system is to use computer graphics to utilize human perceptual processes and organize data in an informative and user-friendly manner.
  • efforts have been made to develop tools for the display and visualization of data from relational and/or multidimensional databases .
  • Prior art navigation and visualization tools are too rigid in their presentation of data, and do not present a comprehensive view for the data that are being navigated and visualized.
  • those traditional tools only allow users to design pre-defined, single path and single direction (one- way) navigation associated with 'one click' or command for the display and navigation of data from relational and/or multidimensional databases.
  • the user may not be able to navigate through a relational and/or multidimensional database in a sequence of paths that fits the business requirements or the user's particular thought process.
  • the present invention provides such a method and system to meet the above four and other needs.
  • the present invention provides a novel method to navigate and display data stored in relational and/or multidimensional databases.
  • the invention provides a computer-implemented business intelligence tool for the navigation and visualization of data in at least one relational and/or multidimensional database.
  • the design tool allows a user to partition a display screen into a plurality of frames, to insert and configure controls within each frame to form a dashboard, the controls defining queries to the database(s) and any rules associated with those queries, and to create the dashboards in multiple levels for each of the frames.
  • Configuring the controls permits a user to define drill-actions for the controls within each dashboard to target dashboards in any of the multiple levels, both within the same frame as the starting dashboard, as well as in any or all of the other frames.
  • the user-defined drill-actions provide for powerful and highly flexible multi-path and multi-level navigation to achieve visualization of data in the database(s), by displaying on the display screen a respective target dashboard of any one of the multiple levels in each frame according to the controls selected by the user.
  • the invention provides a method and system for the navigation and visualization of data stored in relational and/or multidimensional databases.
  • the invention provides user access to data through a user-friendly interface that allows the user to view, understand and navigate data from relational and/or multidimensional databases.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of defining business module(s) which may be used to better display information for the specific business purpose and objectives.
  • Business module(s) may be Sales Module, Finance Module, Operations Module etc. or it can be a combination of different business objectives into one single business module.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for defining business module(s) which may be used to better display information for the specific business purpose and objectives.
  • Business module(s) may be Sales Module, Finance Module, Operations Module, etc. or it can be a combination of different business objectives into one single business module.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of partitioning the business module(s) as seen on the computer screen into different frames. The purpose of these partitions is to enable the multi- path and multi-level navigations.
  • the frames are used to house controls (charts, dials, GIS (Geographical Information System), generated maps, images, icons, commentary box, buttons, color-coded alert buttons, labels, pivot tables, etc.) which may be linked to data sources in the form of queries to relational and/or multidimensional databases.
  • controls charts, dials, GIS (Geographical Information System), generated maps, images, icons, commentary box, buttons, color-coded alert buttons, labels, pivot tables, etc.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for partitioning the business module(s) as seen on the computer screen into different frames. The purpose of these partitions is to enable the multi-path and multi-level navigations.
  • the frames are used to house controls (charts, dials, GIS (Geographical Information System), images, commentary box, buttons, alert buttons, pivot tables, etc.) which may be linked to data sources in the form of queries to relational and/or multidimensional databases.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of inserting controls (charts, dials, GIS (Geographical Information System), images, icons, commentary box, buttons, color-coded alert buttons, labels, pivot tables, etc.) into the defined frames of the business module(s).
  • controls charts, dials, GIS (Geographical Information System), images, icons, commentary box, buttons, color-coded alert buttons, labels, pivot tables, etc.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for inserting controls (charts, dials, GIS (Geographical Information System), images, icons, commentary box, buttons, color-coded alert buttons, labels, pivot tables, etc.) into the defined frames of the business module(s).
  • controls charts, dials, GIS (Geographical Information System)
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of configuring the controls in the different frames. These configurations may include the properties of the controls i.e.
  • defining the query from the data source(s) of the relational and/or multidimensional databases defining the business rules (mathematical computations) associated to the query, defining the alert and threshold conditions associated to the query, defining the alert method (email alert, SMS [cellular Short Message Service] alert, etc.) once the alert threshold condition is breached, defining the drill action of the control, etc.
  • the configuration properties and functions may be different for the different type of controls. Once the controls of a frame are fully configured, it may be referred to as a Dashboard.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for configuring the controls in the different frames.
  • These configurations may include the properties of the controls i.e. defining the query from the data source(s) of the relational and/or multidimensional databases, defining the business rules (mathematical computations) associated to the query, defining the alert and threshold conditions associated to the query, defining the alert method (email alert, SMS . [cellular Short Message Service] alert, etc.) once the alert threshold condition is breached, defining the drill action of the control, etc.
  • the configuration properties and functions may be different for the different type of controls. Once the controls of a frame are fully configured, it may be referred to as a Dashboard.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of configuring the drill-actions for any of the controls in the Dashboards for the purpose of multi-path navigations.
  • Each control may be configured with one or more drill-actions (links) to the targeted Dashboard(s) and, optionally, to any other Business Modules, URLs (Uniform Resource Locators), websites or applications, etc.
  • the user may specify the targeted Frame areas or space for these targeted Business Modules or any other URLs (Uniform Resource Locators), websites or applications, etc. to be displayed.
  • the module may be 'saved' for the end-user.
  • the targeted Dashboard(s) and any other targeted Business Modules, URLs (Uniform Resource Locators), websites or applications, etc. will be displayed in the respective frame areas or space, and related data from relational and/or multidimensional databases will be automatically extracted and displayed on the controls of the targeted Dashboard(s).
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for configuring the drill-actions for any of the controls in the Dashboards for the purpose of multi-path navigations.
  • Each control may be configured with one or more drill-actions (links) to the targeted Dashboard(s) and, optionally, to any other Business Modules, URLs (Uniform Resource Locators), websites or applications, etc.
  • the user may specify the targeted Frame areas or space for these targeted Business Modules or any other URLs (Uniform Resource Locators), websites or applications, etc. to be displayed.
  • the module may be 'saved' for the end-user.
  • the targeted Dashboard(s) and any other targeted Business Modules, URLs (Uniform Resource Locators), websites or applications, etc. will be displayed in the respective frame areas or space, and related data from relational and/or multidimensional databases will be automatically extracted and displayed on the controls of the targeted Dashboard(s).
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of saving the Dashboards and any other links to other Business Modules, URLs (Uniform Resource Locators), websites or applications, etc. in the Business Module for the purpose of navigation and visualization of data from the relational and/or multidimensional databases.
  • the user may edit any of these Dashboards in the future by making changes to the configurations of the controls.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for saving the Dashboards and any other links to other Business Modules, URLs (Uniform Resource Locators), websites or applications, etc. in the Business Module for the purpose of navigation and visualization of data from the relational and/or multidimensional databases.
  • the user may edit any of these Dashboards in the future by making changes to the configurations of the controls.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of designing and creating different levels of Dashboards within a business module.
  • controls in a Dashboard may be configured with drill actions. These drill actions define the target Dashboard(s) which will be extracted and displayed in the business module. Once the user clicks on the control, a multi-path and multi-level navigation will be activated accordingly to extract and display the target Dashboard(s). And from the target Dashboard(s), controls can again be defined to drill to any other target Dashboard(s). Hence, the user is able to define unlimited multi-path and multi-level navigations to achieve better visualizations.
  • GIS Global System
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for creating different levels of Dashboards within a business module.
  • controls charts, dials, GIS (Geographical Information System), images, icons, buttons, color-coded alert buttons, labels
  • These drill actions define the target Dashboard(s) which will be displayed in the business module.
  • a multi-path and multi-level navigation will be activated accordingly to display the target Dashboard(s).
  • controls can again be defined to drill to any other target Dashboard(s).
  • the user is able to define unlimited multi-path and multi-level navigations to achieve better visualizations.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of providing universal 'Back' and 'Forward' buttons for all business modules in association to any the drill actions of Dashboard(s).
  • TMs eliminates the need for the user to design such features and functions in every Dashboard.
  • This universal 'Back' and 'Forward' button will automatically function as drill backward- or drill forward for any drill actions.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for providing universal 'Back' and 'Forward' buttons for all business modules in association to any the drill actions of Dashboard(s). This eliminates the need for the user to design such feature and function in every Dashboard. This universal 'Back' and 'Forward' button will automatically function as drill backward or drill forward for any drill actions.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of placing color-coded Alert Button(s) on an image or next to the image to better communicate the meaning of the visualization associated to the image.
  • An image may be a map, process, activity, picture of a person, etc.
  • the color-coded Alert Button(s) may be placed on a dynamic map generated by a GIS (Geographical
  • mapping system This is to provide better communication of information from the GIS with respect to data being displayed from relational and/or multidimensional databases.
  • the color-coded Alert Button may be 'blinking' and color-coded as green, yellow or red. Green color is typically used to represent 'Good', yellow color used to represent 'Average' and red color used to represent 'No Good', when comparing the actual measurements with a target or standard measurement. This color-coded system facilitates the comprehension of the information being displayed, and easily communicates the meaning, status or overall health of a business in association to the information in the Business Module.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for placing color-coded Alert Button(s) on an image or next to the image to better communicate the meaning of the visualization associated to the image.
  • An image can be a map, process, activity, picture of a person, etc.
  • the color-coded Alert Button(s) may be placed on a dynamic map generated by a GIS (Geographical Information System) mapping system.
  • GIS Geographic Information System
  • the color-coded Alert Button may be 'blinking' and color-coded as green, yellow or red. Green color is typically used to represent 'Good', yellow color used to represent 'Average' and red color used to represent 'No Good', when comparing the actual measurements with a target or standard measurement.
  • This color-coded system facilitates the comprehension of the information being displayed, and easily communicates the meaning, status or overall health of a business in association to the information in the Business Module.
  • the method comprises of placing one or more commentary box (annotation) control(s) in a Frame or Dashboard for the purpose of describing or updating actions taken with respect to the information in the Dashboard. This facilitates collaboration and easily communicates the meaning, status or actions taken in association to the information in the Dashboard and overall business module.
  • commentary box annotation
  • This facilitates collaboration and easily communicates the meaning, status or actions taken in association to the information in the Dashboard and overall business module.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for placing one or more commentary box (annotation) control(s) in a Frame or Dashboard for the purpose of describing or updating actions taken with respect to the information in the Dashboard. This facilitates collaboration and easily communicates the meaning, status or actions taken in association to the information in the Dashboard and overall business module.
  • commentary box annotation
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of displaying a 'text pop-up window' showing the actual and target values of the control when the user's mouse is over the control. This is especially useful for Dials and Alert Buttons, where there is a need to keep the visualization neat and simple and at the same time, the user is able to display in depth details whenever the need arises.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for displaying a 'text pop-up window' showing the actual and target values of the control when the user's mouse is over the control. This is especially useful for Dials and Alert Buttons, where there is a need to keep the visualization neat and simple and at the same time, the user is able to display in depth details whenever the need arises.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of allowing new business rules and mathematical calculations to be applied to the charts and the results to be viewed directly in the user mode. The user may Save the new chart formed by the business rules for better analysis of data from the relational and/or multidimensional databases.
  • the user may perform additional ad-hoc queries to the relational and/or multidimensional databases.
  • the user may Save the new chart from the ad-hoc queries for better analysis of data from the relational and/or multidimensional databases.
  • the user may 'drag and drop' any of the charts onto another chart within the Dashboard or to another Dashboard.
  • the new chart may display data from both the charts.
  • the user may Save the new chart for better analysis of data from the relational and/or multidimensional databases.
  • system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for allowing new business rules and mathematical calculations to be applied to the charts and results to be viewed directly in the user mode.
  • the user may Save the new chart formed by the business rules for better analysis of data from the relational and/or multidimensional databases.
  • the user may perform additional ad-hoc queries to the relational and/or multidimensional databases.
  • the user may Save the new chart from the ad-hoc queries for better analysis of data from the relational and/or multidimensional databases.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of having features like 'drill-down' to analyze the details of the charts by clicking on any of the elements of the chart. After doing so, the user may 'drill-up' by clicking on the icon above the charts provided in the user Run-Time mode. In the analysis of charts, the user may 'expand and contract chart features' by clicking on the icon above the chart to access more features and functions of the charts.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of having means for providing features like 'drill-down' to analyze the details of the charts by clicking on any of the elements of the chart. After doing so, the user may 'drill-up' by clicking on the icon above the charts provided in the user Run-Time mode.
  • the user may 'expand and contract chart features' by clicking on the icon above the chart to access more features and functions of the charts.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of using a Query Generator with Business Rules capabilities and functions that is provided in the Run-Time, user mode.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of a Query Generator with Business Rules capabilities and functions that is provided in the Run-Time, user mode.
  • a method in a computer system for the visualization and navigation of data from relational and/or multidimensional databases comprises of ad-hoc query on relational and/or multidimensional databases using the Query Generator. After each query, a new chart will pop-up with the results of the query being displayed. The query may be repeated multiple times, resulting in multiple pop-up charts being displayed. The user may proceed to set Business Rules or mathematical calculations to one or more of these charts. The user may 'drag and drop' any of the charts onto another chart and the combined results may be displayed as new chart.
  • the user may 'drag and drop' any of these charts onto another chart (main chart) within the Dashboard or to another Dashboard.
  • the new chart may display data from both the charts.
  • the user may Save the new chart for better analysis of data from the relational and/or multidimensional databases.
  • a system for the visualization and navigation of data from relational and/or multidimensional databases comprises of means for providing ad-hoc query on relational and/or multidimensional databases using the Query Generator.
  • a new chart will pop-up with the results of the query being displayed.
  • the query may be repeated multiple times, resulting in multiple pop-up charts being displayed.
  • the user may proceed to set Business Rules or mathematical calculations to one or more of these charts.
  • the user may 'drag and drop' any of the charts onto another chart and the combined results may be displayed as new chart.
  • the user may 'drag and drop' any of these charts onto another chart (main chart) within the Dashboard or to another Dashboard.
  • the new chart may display data from both the charts.
  • the user may Save the new chart for better analysis of data from the relational and/or multidimensional databases.
  • only a single module needs to be created and saved. In practice, however, it will normally be convenient to create and save two or more modules that relate to different business aspects, such as sales module, finance module, operations module, and the like.
  • the drill-actions that are defined when creating each module can include links to other modules. This provides a high-level of user-convenience in that a single-click on a control within the navigation of one module can call up another module straightaway. The user is thus saved from having to close the existing module and open up a new module, in order to switch from one module to another.
  • the invention is a comprehensive business intelligence tool that allows users to communicate and collaborate in a user-friendly manner. It extends beyond conventional report-based business intelligence applications.
  • the auto-trigger alerts via email and SMS provide the user with powerful operational business intelligence capabilities. This provides better support to the operations and eliminates the need to constantly check and view data from relational and/or multidimensional databases.
  • the generation code eliminates the need for manual programming, thus allowing the programmers to concentrate on the business domain rather than the business intelligence tool. Users can easily create their own business modules without any programming. User interfaces can be created quickly and easily to meet the specific business requirements.
  • the multi-path and multi-level navigation features enables the user to navigate and view data in any angle and thus bring the user closer to data stored in relational and/or multidimensional databases.
  • This exploratory navigation function allows the user to attain a greater level of understanding of the data stored in relational and/or multidimensional databases and thus make better business decisions.
  • FIG. IA a simplified block diagram of a method and system that may be utilized to visualize and navigate multidimensional data in accordance with an embodiment of the present invention that is described.
  • FIG. IB a simplified block diagram of a method and system that may be utilized to visualize and navigate relational data in accordance with another embodiment of the present invention that is described.
  • FIG. 2 is a diagram illustrating a typical arrangement of a multidimensional database where summarized data is arranged in different dimensions.
  • FIG. 3 is a flow illustrating steps performed by a method to construct the Business Module for the navigation and display system according to an embodiment of the invention.
  • FIG. 4A is a diagram illustrating a typical Frame partition in a Business Module.
  • FIG. 4B is a diagram illustrating 'multiple level Dashboards' in a Business Module. This provides for 'multi-path' and 'multi-level' drill actions.
  • FIG. 5 is a diagram illustrating the Controls that may be inserted to the Frames to form Dashboards in a Business Module.
  • FIG. 6 is a diagram illustrating the overview of the design interface used to design and construct the Business Module. This is the main design interface for designing the system that may be utilized to visualize and navigate relational and/or multidimensional data in accordance with an embodiment of the present invention.
  • FIG. 7A is a diagram illustrating the different function selections of the designer - Left Panel namely, Module Explorer, Tool Box, Resource Explorer and Dashboard Gallery.
  • FIG. 7B is a diagram illustrating the typical sequence in selecting the Left Panel functions during the process of designing a Business Module.
  • FIG. 8A is a diagram illustrating the different function selections of the designer - Right Panel namely, Properties.
  • FIG. 8B is a diagram illustrating the different function and configurations of the Properties.
  • FIG. 9 is a diagram illustrating the initial set-up of a new group in the Module Explorer.
  • FIG. 10 is a diagram illustrating the naming a new group in the Module Explorer.
  • FIG. 11 is a diagram illustrating the initial set-up of a new Business Module under the newly created module group.
  • FIG. 12 is a diagram illustrating the naming a new Business Module under the newly created module group.
  • FIG. 13 is a diagram illustrating the selection of a pre-defined Frame partition layout template for the new Business Module that is being designed.
  • FIG. 14 is a diagram illustrating examples of the pre-defined Frame partitions and layouts. This is only an example of the layouts and partitions available and the actual method and system is not limited by the examples being illustrated.
  • FIG. 15 is a diagram illustrating the re-sizing of the Frames in a business module.
  • FIG. 16 is a diagram illustrating the insertion of controls to the Frames from the Tool Box.
  • FIG. 17A is a diagram illustrating the configuration and definition of the Query to the relational and/or multidimensional databases. .
  • FIG. 17B is a diagram illustrating the linking of Query from relational and/or multidimensional databases to a control - by dragging the Query icon and dropping it to the control.
  • FIG. 18A is a diagram illustrating one of the Properties functions - the setting of the alert thresholds for the control.
  • FIG. 18B is a diagram illustrating another one of the Properties functions - the setting of email alert.
  • FIG. 18C is a diagram illustrating another one of the Properties functions - the setting of font types, size, etc.
  • FIG. 19 is a diagram illustrating an example of a completed first level of a business module comprising of three (3) Dashboards.
  • FIG. 20 is a diagram illustrating the Dashboard Gallery. This is for the creation of new dashboards in the multi-level Dashboards for the purpose of navigating relational and/or multidimensional data in accordance with an embodiment of the present invention.
  • FIG. 21 is a diagram illustrating another one of the Properties functions - the setting of the drill action(s) by selecting the target Frame and Target Dashboard.
  • the user may set drill actions to Business Modules, and any other links to targeted URLs (Uniform Resource Locators), websites or applications, etc.
  • targeted URLs Uniform Resource Locators
  • FIG. 22A is a diagram illustrating a method to facilitate better communication and understanding, wherein color-coded buttons are placed over a map image or maps from GIS (Geographical Information System).
  • GIS Geographic Information System
  • FIG. 22B is a diagram illustrating a method to facilitate better communication and understanding, wherein color-coded buttons are placed at the side of a process image.
  • FIG. 23 is a diagram illustrating a method to facilitate better navigations in business modules, wherein a universal 'Back' and 'Forward' is available for all business modules in the Run-Time, user mode.
  • FIG. 24 is a diagram illustrating a method to facilitate better communication and collaboration, wherein a Commentary Box for annotations is provided in the Run-Time, user mode.
  • FIG. 25 is a diagram illustrating a method to facilitate better visualization of information, wherein a 'pop-up text window' is provided in the user mode when user's mouse is over the control in the Dashboard, user mode for some of the relevant Controls.
  • FIG. 26 is a diagram illustrating an example of the navigation and display system in the Run- Time, user mode for a business module named Sales Module.
  • FIG. 27 is a diagram illustrating an example of the navigation and display system in the RunTime, user mode for a business module named Process Module.
  • FIG. 28 is a diagram illustrating an example of the navigation and display system in the RunTime, user mode for a business module named Human Resource Module.
  • FIG. 29A is a diagram illustrating a method and system to facilitate better chart analysis of relational and/or multidimensional data, a 'drill-up' icon 32 and 'expand and contract chart features' icon 34 are provided in the Run-Time, user mode.
  • FIG. 29B is a diagram illustrating a method and system to facilitate better chart analysis of relational and/or multidimensional data, wherein more charting features and functions are available when the user clicks on the 'expand mode' icon above the chart, in the Run-Time, user mode.
  • FIG. 30 is a diagram illustrating a method and system to facilitate better chart analysis and ad-hoc query of relational and/or multidimensional data, wherein a Query Generator with Business Rules capabilities and functions is provided in the Run-Time, user mode.
  • FIG. 31 is a diagram illustrating a method and system to facilitate better chart analysis and ad-hoc query of relational and/or multidimensional data, wherein charts generated by the Query Generator may be combined with other charts or applied with Business Rules, and the results may then be moved by 'drag and drop' to any main charts within the Business Module.
  • FIG. 32 is a diagram illustrating an example of a computer system environment in which the present invention may be applied, and comprising of storage device, storage device interface, Central Processing Unit (CPU), memory device, display interface, display monitor, computer bus, mouse, keyboard, and wireless device.
  • CPU Central Processing Unit
  • Controls refers to components for the display of information. Examples of Controls are charts, dials, GIS (Geographical Information System), labels, images, commentary box, buttons, alert buttons, pivot tables, etc.
  • Frames refers to the partitions of a computer or other display screen into smaller windows. Frames are used to house controls (charts, labels, images, commentary box, buttons, alert buttons, pivot tables, etc.) and, optionally, contents from other Business Modules, external IMLs (Uniform Resource Locators), websites and/or applications. In the case of a Frame housing controls, it may be referred to as a Dashboard once the control(s) in the Frame is/are fully configured with properties such as business rules, control properties and/or links to other Dashboards.
  • “Dashboard” refers to a Frame containing Controls such as charts, dials, GIS (Geographical Information System), labels, images, commentary box, buttons, alert buttons, pivot tables, etc. and which are linked to external data sources or business rules.
  • a Dashboard is like a presentation slide, except that the information may be linked to data stored in one or more databases.
  • Multi-Level Dashboards refers to the different levels of Dashboards within the business module. This allows the user to specify the 'multi-path' and 'multi-level' drill actions to the target Dashboards within the different levels.
  • Business Modules refers to a collection of Dashboards in multi-level format, and allowing the user to perform multi-path and multi-level navigations.
  • Business module(s) may be used to better display information for the specific business purpose and objectives. It may be Sales Module, Finance Module, Operations Module, etc. or it can be a combination of different business objectives into one single business module.
  • Query refers to a business question from the user that is being translated into terms that can be understood by the relational and/or multidimensional database and the results returned in terms that can be understood by the user.
  • Business Rules refers to mathematical expressions associated to the Query.
  • Drill Actions refers to a set of commands assigned by the user to the Control and specifying the navigation path to display the appropriate Dashboard(s) and any other links to targeted Business Modules, URLs (Uniform Resource Locators), websites or applications, etc. as well as links to other module(s) .
  • Multi-Path navigation refers to the different navigational paths taken to reach the targeted Dashboard(s) to be displayed. These paths may be executed simultaneously with a single mouse or keyboard click on the initiating Control on a computer screen. Any particular navigation path may be in a 'drill-up', 'drill-down' or 'drill-sideways' direction with respect to the Dashboard levels.
  • Multi-Level navigation refers to the different navigational levels of Dashboards in a module. These levels may be executed simultaneously with a single mouse or keyboard click on the initiating Control on a computer screen.
  • Methoda-Data refers to the structural information about the data stored in relational and/or multidimensional database(s).
  • Cubes refers to relational and/or multidimensional databases where summarized data is arranged in different dimensions for the purpose of relational and/or multidimensional analysis.
  • GIS Geographic Information System
  • URL refers to Uniform Resource Locator.
  • a method and system for navigation and visualization of data from relational and/or multidimensional database(s) will now be described.
  • a developer interactively builds a visualization system, whose building blocks include Dashboards, data sources and resources.
  • FIG. IA a simplified block diagram of a method and system that may be utilized to visualize and navigate multidimensional data in accordance with an embodiment of the present invention is described.
  • This block diagram shows that data from relational databases is summarized, mapped and populated to multidimensional databases.
  • the data is further organized in a multidimensional relationship manner.
  • the data in multidimensional databases can be defined and mapped along multiple dimensions.
  • the data in a sales multidimensional database may include dimensions for the different types of products, locations, customers, sales channels and time dimensions.
  • the multidimensional database system comprises of two functionalities, namely the multidimensional database server and the multidimensional database itself.
  • the multidimensional database stores both the structural information (meta-data) about the data and the data itself.
  • the multidimensional database server manages the multidimensional data stored in the multidimensional database. Specifically, the multidimensional database server allows users to define the structure of the multidimensional data, load data into the multidimensional database, and execute the user queries over the data stored in the multidimensional database.
  • Information queried from the multidimensional database server comprises of two areas: meta-data and user data.
  • the meta-data usually describe the structural information such as which multidimensional database, the available data files, business rules (if any), dimensions, levels, drill-down paths, measures, etc.
  • the user data comprises of the actual data stored in the multidimensional database according to the meta-data descriptions or definitions.
  • the user can interact through the user interface, usually by means of a computer or other display screen by using a mouse, keyboard or any user interface devices.
  • User requests or interactivity are communicated to the visualization and navigation system by the activation of the computer program in this system. These requests or interactivity can take the forms of multi-path and multilevel navigations.
  • the request is communicated to the multidimensional database system.
  • the multidimensional database system retrieves the requested meta-data and data from the multidimensional database and presents the data to the user through the user interface.
  • the relational database stores both the structural information (meta-data) about the data and the data itself.
  • the relational database server manages the relational data stored in the relational database. Specifically, the relational database server allows users to define the structure of the relational data, load data into the relational database, and execute the user queries over the data stored in the relational database.
  • Information queried from the relational database server comprises of two areas: meta-data and user data.
  • the meta-data usually describe the structural information such as which relational database, the available data files and business rules, if any.
  • the user data comprises of the actual data stored in the relational database according to the meta-data descriptions or definitions.
  • the user can interact through the user interface, usually by means of a computer or other display screen by using a mouse, keyboard or any user interface devices.
  • User requests or interactivity are communicated to the visualization and navigation system by the activation of the computer program in this system. These requests or interactivity can take the forms of multi-path and multilevel navigations.
  • the request is communicated to the relational database system.
  • the relational database system retrieves the requested meta-data and data from the relational database and presents the data to the user through the user interface.
  • FIG. 2 is a diagram illustrating a typical arrangement of a multidimensional database where summarized data is arranged in different dimensions.
  • it shows the database structure for four dimensions in a Sales Cube : Regions, Customers, Products and Timeline. This structure allows the user to define multidimensional queries from any of the four dimensions for the purpose of analysis or visualization of data.
  • FIG. 3 shows a simplified block diagram 10 of a method and system that may be utilized to design the Business Module for the visualization and navigation of relational and/or multidimensional data in accordance with an embodiment of the present invention that is described.
  • the method and system comprise of defining business module(s) which may be used to better display information for the specific business purpose and objectives.
  • Business module(s) may be Sales Module; Finance Module, Operations Module, etc. or it can be a combination of different business objectives into one single business module.
  • the user may start the design of the Business Module 12 by first designing the partitioning of the business module(s) as seen on the computer screen into different frames 14. The user has an option to select the different partition layouts from a library of templates available. New partition layouts may be added to the library as and when it becomes necessary.
  • the purpose of these frame partitions 14 is to enable the multi-path and multi-level navigations.
  • the frames are used to house controls 16 (charts, dials, images, icons, commentary box, buttons, color-coded alert buttons, labels, pivot tables, etc.) which may be linked to data source in the form of queries to relational and/or multidimensional databases.
  • buttons 16 charts, dials, images, icons, commentary box, buttons, color-coded alert buttons, labels, pivot tables, etc.
  • These configurations may include the properties of the controls, i.e. defining the query from the data source(s) of the relational and/or multidimensional databases, defining the business rules (mathematical computations) associated to the query, defining the alert and threshold conditions associated to the query, defining the alert method (email alert, SMS alert, etc.) once the alert threshold condition is breached, defining the drill action of the control, etc.
  • the configuration properties and functions may be different for the different type of controls. Once the controls of a frame are fully configured, it may be referred to as a Dashboard 18.
  • the user may now proceed to save the Dashboards 18 in the Business Module for the purpose of navigation and visualization of data from the relational and/or multidimensional databases.
  • the user may edit any of these Dashboards in the future by making changes to the configurations of the controls 16.
  • the user may design and create different levels of Dashboards 20 within a business module.
  • controls charts, dials, GIS (Geographical Information System), images, icons, buttons, color-coded alert buttons, labels
  • a Dashboard may be configured with drill actions 22.
  • These drill actions 22 define the targeted Dashboard(s) and, optionally, any other links to targeted Business Modules, URLs (Uniform Resource Locators), websites or applications, etc. which will be extracted and displayed in the business module.
  • multi-path and multi-level navigation(s) will be activated accordingly to the defined 'drill actions' to extract and display data from relational and/or multidimensional databases to the targeted Dashboard(s) and to display information from any targeted Business Modules, URLs (Uniform Resource Locators), websites or applications, etc. in the specified Frame area or space.
  • controls can again be defined to drill to any other target Dashboard(s).
  • some of the controls may define stop points from which no drill action can be made.
  • the user saves the entire module 24 in the design mode.
  • the saved Business Module is immediately available in the user mode for the user to view, navigate and display data stored in relational and/or multidimensional databases.
  • FIG. 4A is a diagram illustrating a typical Frame partition in a Business Module.
  • the user has the option to select the frame layout from the library of predefined Frame partitions or to design their own layouts.
  • the frames are non-overlapping on the display screen.
  • FIG. 4B is a diagram illustrating 'multiple level Dashboards' in a Business Module. This provides for 'multi-path' and 'multi-level' drill actions. In the given example, there is a total of three separate Frames (Frame A, Frame B and Frame C) in the Business Module. These individual Frames (Frame A, Frame B and Frame C) in the Business Module. These individual Frames (Frame A, Frame B and Frame C) in the Business Module. These individual
  • Frames can be constructed and configured to multiple Dashboards.
  • the number of Dashboard levels per Frame is unlimited and is not dependent on its neighboring frame. For example, for
  • Frame A it can be constructed and configured into Dashboard levels : Al to AX, where X can be any given number.
  • Frame B it can be constructed and configured into Dashboard levels : Bl to BY, where Y can be any given number.
  • Frame C it can be constructed and configured into Dashboard levels : Cl to CN, where N can be any given number.
  • the user has the flexibility to construct and configure any number of Dashboard levels per Frame for any given Business Modules. In each of the Dashboards, the user can insert any number of Controls to it. Hence, there is an unlimited set of navigation paths, in a multi-path and multi-level manner that can be designed into the system according to the business and operational needs of the users. This provides for the novel method for multi-path and multi-level navigations.
  • FIG. 5 is a diagram illustrating the controls that may be inserted to the Frames to form Dashboards in a Business Module.
  • the user can continue in a similar manner to construct Dashboard A2, Dashboard B2 and Dashboard C2 for Dashboards in Level 2, and so forth.
  • Dashboard Al contains controls comprising of three (3) buttons, and image and annotations.
  • the three (3) buttons in Dashboard Al can be further defined with drill-actions to extract and display any Dashboard in the Business Module within the space of the given Frame.
  • the drill action may be activated when the user clicks on the button.
  • the image in Dashboard Al may be used to depict an association of the information that is being displayed in the Business Module. For example, it may be a picture of a product. In this case, it would mean that the charts, dials and maps in the corresponding Dashboards - Dashboard Bl and
  • Dashboard Cl refer to the measurements of the given product. Hence, the purpose of an image is to maximize the comprehension of the information being displayed.
  • the image may also be further defined with drill-actions to extract and display any Dashboard in the Business Module within the space of the given Frame. Again, the drill action may be activated when the user clicks on the image.
  • the annotation in Dashboard Al is used for the purpose of improving the comprehensibility of the information being displayed.
  • Annotations can also be used as a communication tool between the users of the system. It can be used to describe the information that is being displayed or even to record the actions that are to be taken or being taken in regards to the latest information being displayed.
  • the controls are being superimposed onto another control, a world map or maps generated dynamically from GIS (Geographic Information System). This is done to maximize the visualization of the information being displayed.
  • the Alert Buttons may be 'blinking' and can be used to represent the condition or status (green, yellow or red) of the measurement of the given location in the map versus its target or threshold.
  • the Alert Buttons may also be further defined with drill-actions to extract and display any Dashboard in the Business Module within the space of the given Frame. Again, in the Run-Time, user mode, the drill action may be activated when the user clicks on the Alert Button.
  • this is a diagram illustrating the overview of the design interface used to design and construct the Business Module. This is the main design interface for designing the system that may be utilized to visualize and navigate relational and/or multidimensional data in accordance with the embodiments of the present invention.
  • the main design interface comprises of Left Panel, Middle Panel and Right Panel.
  • the user may select the four (4) different functions by clicking on the icons at the bottom of the Left Panel.
  • the selected function will appear on the Left Panel for the user to utilize its functionality.
  • the four functions are as follow: Module Explorer, Tool Box, Resource Explorer and Dashboard Gallery.
  • the Middle Panel comprises of the Dashboard space. This is the working area for inserting Controls to the Frames and configuring the Controls to realize Dashboards.
  • the Left Panel comprises of the property functions of the Controls.
  • the user may use the property functions to configure Targets and Alerts, E-Mail Alerts, Business Rules configurations, drill- actions, font, color settings for background and text, color-coding, data entry, Frame size, etc.
  • FIG. 7A is a diagram illustrating the different function selections of the designer - Left Panel namely, Module Explorer, Tool Box, Resource Explorer and Dashboard Gallery.
  • FIG. 7B is a diagram illustrating the typical sequence in selecting the Left Panel functions during the process of designing a Business Module.
  • the Module Explorer may be used to create the Group folders which contain the different Business Modules. It may also be used to create Business Modules. In general, this is the main body of the overall Business Modules as it houses all the Business Modules that were designed in the design mode. It is the backbone of the entire Visualization and Navigation system. Users may access the Module Explorer to search and locate any Dashboards for the purpose of updating or changing the properties of any of the Controls.
  • the Tool Box contains the libraries of Controls. User can 'drag-n-drop' any of these Controls (dials, alert buttons, charts, tables, buttons, labels, image, commentary box, etc.) to the Frames during the design mode. This provides the user with the capabilities in creating the Visualization of the system.
  • the main function of the Resource Library is to allow the user to define the relational and/or multidimensional queries for the Controls. After defining the query, the user may 'drag-n-drop' the query into any of the Controls in the Frame.
  • FIG. 8A is a diagram illustrating the different function selections of the designer - Right Panel namely, Properties.
  • FIG. 8B is a diagram illustrating the different function and configurations of the Properties.
  • the main function of the Property is to allow the user to configure and customize Controls in the Frame, before it is saved to become a Dashboard.
  • the Property may consist of the following configurations : Targets and Alerts, E-Mail Alerts, Business Rules configurations, drill-actions, font, color settings for background and text, color-coding, data entry, Frame size, etc.
  • FIG. 9 this is a diagram illustrating the initial set-up of a new group in the Module Explorer.
  • the Module Explorer is the main system that may be utilized to visualize and navigate relational and/or multidimensional data in accordance with an embodiment of the present invention. It consists of all the Business Modules and grouped under different folders.
  • the user may use a mouse having a right button and a left button (not shown) or any other computer selecting device, selects the Module Explorer node with the pointer, and in the case of using the mouse, right clicks on the Module Explorer node to select the 'Create Group' function.
  • FIG. 10 is a diagram illustrating the naming of a new group in the Module Explorer. After right clicking on the Module Explorer node, and selecting the 'Create Group' function, a pop-up window shows up for the user to enter the New Group name.
  • FIG. 11 is a diagram illustrating the initial set-up of a new Business Module under the newly- created module group.
  • the user may use a mouse having a right button and a left button (not shown) or any other computer selecting device, selects the Group folder node with the pointer, and in the case of using the mouse, right clicks on the Group folder node to select the 'Create Module' function.
  • FIG. 12 is a diagram illustrating the naming of a new Business Module in the Module Explorer. After right clicking on the Group folder, and selecting the 'Create Module' function, a pop-up window shows up for the user to enter the New Module name.
  • FIG. 13 is a diagram illustrating the selection of a pre-defined Frame partition layout template for the new Business Module that is being designed. The user has an option to select from the library of templates or design any new layout according to the requirements.
  • FIG. 14 is a diagram illustrating examples of the pre-defined Frame partitions and layouts. This is only an example of the layouts and partitions available and the actual method and system are not limited by the examples being illustrated. The user can choose from any of the Frame partition layouts in designing a new Business Module.
  • FIG. 15 is a diagram illustrating the re-sizing of the Frames in a Business Module.
  • the user selects the frame to be re-sized by clicking on an area of the frame by using a mouse or any other selection device of the computer. After doing this, the user can either drag the edge of the frame to make the frame smaller or bigger to re-size the Frame.
  • the user may also choose to re-size the Frame by entering the new size for the selected frame directly to the property box configurations at the left panel.
  • scroll bar(s) may automatically appear on the bottom and/or right edge of the Frame(s) to facilitate the user in viewing the information being displayed.
  • FIG. 16 is a diagram illustrating the insertion of controls to the Frames from the Tool Box. hi order to do this, the user first selects the Tool Box function in the Left Panel by clicking at the corresponding icon at the bottom of the Left Panel.
  • Tool Box function shows up as the Left Panel.
  • the previous Left Panel will disappear and will be replaced by the new selection - Tool Box.
  • the user may proceed to 'drag-n-drop' the Controls from the Tool Box into the respective Frames.
  • FIG. 17A is a diagram illustrating the configuration and definition of the Query to the relational and/or multidimensional databases.
  • the user first selects the Resource Explorer function in the Left Panel by clicking at the corresponding icon at the bottom of the Left Panel. Once the Resource Explorer function is selected, it shows up as the Left Panel. The previous Left Panel will disappear and will be replaced by the new selection - Resource Explorer. Now, the user may proceed to define the relational and/or multidimensional query.
  • FIG. 17B is a diagram illustrating the linking of Query from relational and/or multidimensional databases to a control - by dragging the Query icon and dropping it to the control.
  • FIG. 17A and FIG. 17B are repeated for every Control which is to be linked to the relational and/or multidimensional database.
  • the user may proceed to configure the Controls in the Frames with the respective configurations in the Property function.
  • FIG. 18A is a diagram illustrating one of the Properties functions - the setting of the alert thresholds for the control.
  • the user first selects the Control in the Frame by clicking on the Control.
  • the user may proceed to select the Alert Configuration function in the Property function (located at the Right Panel) by clicking at the corresponding description depicted in the Property menu.
  • a 'pop-up' window shows up. Now, the user may proceed to enter the details in the 'pop-up' window and click on the 'Apply' button to apply the configuration to the Control.
  • FIG. 18B is a diagram illustrating another one of the Properties functions - the setting of e-mail alert.
  • the user first selects the Control in the Frame by clicking on the Control.
  • the user may proceed to select the E-Mail Alert function in the Property function (located at the Right Panel) by clicking at the corresponding description depicted in the Property menu.
  • FIG. 18C is a diagram illustrating another one of the Properties functions - the setting of font types, size etc.
  • the user first selects the Control in the Frame by clicking on the Control.
  • the user may proceed to select the Font function in the Property function (located at the Right Panel) by clicking at the corresponding description depicted on the Property menu.
  • a 'pop-up' window shows up. Now, the user may proceed to enter the details in the 'pop-up' window and click on the 'Apply' button to apply the configuration to the Control.
  • FIG. 19 is a diagram illustrating an example of a completed first level of a Business Module comprising of three (3) Dashboards. All the Dashboards are fully configured with the properties accordingly. This is the result of steps being carried out according to the flow described in FIG. 11 to FIG. 18C above.
  • FIG. 20 is a diagram illustrating the Dashboard Gallery. This is for the creation of new dashboards in the multi-level Dashboards for the purpose of navigating relational and/or multidimensional data in accordance with an embodiment of the present invention.
  • the user first selects the Dashboard Gallery function in the Left Panel by clicking at the corresponding icon at the bottom of the Left Panel.
  • the Dashboard Gallery function shows up as the Left Panel.
  • the previous Left Panel will disappear and will be replaced by the new selection - Dashboard Gallery. Now, the user may proceed to enter the name of the new Dashboard to be designed.
  • the user may proceed to design the new Dashboard by stating the size for the Dashboard. Typically, this size should correspond to the virtual Frame space which will eventually display the Dashboard. It may be bigger or smaller than the targeted virtual Frame space. If it is smaller, there will be some empty space in the Frame once the Dashboard is extracted and displayed in the virtual target Frame space of the Business Module. If it is bigger, the scroll bar(s) may automatically appear (at the bottom and/or right edge of the Frame) when the Dashboard is extracted and displayed in the virtual target Frame space of the Business Module.
  • the newly designed Dashboard will remain in the Dashboard Gallery until a drill-action is described into one of the Controls to link the newly-created Dashboard. When this happens, the newly-created Dashboard will be transferred to the Module Explorer where it will be extracted for display when the drill path of the Control is activated.
  • FIG. 21 is a diagram illustrating another one of the Properties functions - the setting of the drill action(s) by selecting:
  • the user first selects the Control in the Frame by clicking on the Control.
  • the user may proceed to select the Drill-Action function in the Property function (located at the Right Panel) by clicking at the corresponding description depicted in the Property menu.
  • a 'pop-up' window shows up. Now, the user may proceed to enter the details, e.g. Target Frame and the Target Dashboard.
  • the Target Frame is the virtual Frame space in the Business Module where the Dashboard may be extracted to be displayed.
  • the user has an option to define Drill-Action(s) to Business Modules, URLs for websites or applications as Target(s) to be displayed within the virtual Frame or to be displayed as a Full Browser Window.
  • the target Dashboard may be in either one (1) of the two (2) locations - Dashboard Gallery or Module Explorer. If it is a newly-created Dashboard, it will be located in the Dashboard Gallery. A newly designed Dashboard will remain in the Dashboard Gallery until a drill-action is described into one of the Controls to link the newly created Dashboard. When this happens, the newly- created Dashboard will be transferred to the Module Explorer where it will be extracted for display when the drill path of the Control is activated. If the target Dashboard has already been linked by a Drill-Action from another Control, the Dashboard will be located in the Module Explorer of the Business Module. The system allows a target Dashboard to be linked to one (1) or more Controls.
  • FIG. 22A is a diagram illustrating a method to facilitate better communication and understanding, wherein color-coded buttons are placed over a map image or maps from GIS (Geographical Information Systems).
  • GIS Geographical Information Systems
  • the GIS maps allow the user to further interact and zoom down to details such as actual locations as provided by the interactive GIS system. This allows the user to quickly visualize the situation or condition of the measurement with respect to the target or threshold in any given location on the map.
  • FIG. 22B is a diagram illustrating a method to facilitate better communication and understanding, wherein color-coded buttons are placed at the side of a process image. This allows the user to easily visualize the status of several measurements of the process at a glance. If there is an alert condition, the Alert Button which is color-coded will blink in red color. The user may then click on this Alert Button to drill to more details of the alert condition.
  • FIG. 23 is a diagram illustrating a method to facilitate better navigations in business modules, wherein a universal 'Back' and 'Forward' function is available for all business modules in the Run-Time, user mode. This provides a flexible navigation path and eliminates the need to design this feature into every Control.
  • FIG. 24 is a diagram illustrating a method to facilitate better communication and collaboration, wherein a Commentary Box for annotations is provided in the Run-Time, user mode. This feature may also be used for the purpose of communicating actions to be taken by the responsible parties in addressing a red alert condition.
  • FIG. 25 is a diagram illustrating a method to facilitate better visualization of information, wherein a 'pop-up text window' is provided in the user mode, when the user's mouse is over the control in the Dashboard.
  • a 'pop-up text window' is provided in the user mode, when the user's mouse is over the control in the Dashboard.
  • the 'pop-up text window' may display the details for the Control : Name of the Control, the measurements of the Control, the green, yellow and red targets for the Control.
  • FIG. 26 is a diagram illustrating an example of the navigation and display system in the RunTime, user mode for a business module named Sales Module.
  • FIG. 27 is a diagram illustrating an example of the navigation and display system in the Run- Time, user mode for a business module named Process Module.
  • FIG. 28 is a diagram illustrating an example of the navigation and display system in the RunTime, user mode for a business module named Human Resource Module.
  • the user may perform relational and/or multidimensional analysis on the charts.
  • New business rules and mathematical calculations may be applied to the charts and results may be view directly in the user mode.
  • the user may Save the new chart formed by the business rules for better analysis of data from the relational and/or multidimensional databases.
  • the user may perform additional ad-hoc queries to the relational and/or multidimensional databases.
  • the user may Save the new chart from the ad-hoc query for better analysis of data from the relational and/or multidimensional databases.
  • the user may 'drag and drop' any of the charts onto another chart within the Dashboard or to another Dashboard.
  • the new chart may display data from both the charts.
  • the user may Save the new chart for better analysis of data from the relational and/or multidimensional databases.
  • FIG. 29A is a diagram illustrating a method and system to facilitate better chart analysis of relational and/or multidimensional data.
  • a 'drill-up' icon 32 and 'expand and contract chart features' icon 34 are provided in the Run-Time, user mode.
  • the user may 'drill-down' to analyze the details of the charts by clicking on any of the elements of the chart. After doing this, the user may 'drill-up' by clicking on the icon 32 provided in the user Run-Time mode.
  • the user may 'expand and contract chart features' by clicking on icon 34 to access more features and functions of the charts.
  • FIG. 29B is a diagram illustrating a method and system to facilitate better chart analysis of relational and/or multidimensional data, charting features and functions change that are provided in the Run-Time, user mode.
  • Icon 34 may be clicked again to 'contract' and hide the chart features and functions accordingly.
  • the user has the option to ' Save' the new chart for better analysis and visualization.
  • FIG. 30 is a diagram illustrating a method and system to facilitate better chart analysis and ad-hoc query of relational and/or multidimensional data, wherein a Query Generator with Business Rules capabilities and functions is provided in the Run-Time, user mode.
  • the user may perform an ad-hoc query on relational and/or multidimensional databases using the Query Generator.
  • Business Rules may be applied to the charts being displayed.
  • FIG. 31 is a diagram illustrating a method and system to facilitate better chart analysis and ad-hoc query of relational and/or multidimensional data, wherein a Query Generator with Business Rules capabilities and functions is provided in the Run-Time, user mode.
  • the user may perform an ad-hoc query on relational and/or multidimensional databases using the Query Generator. After each query, a smaller chart will pop-up with the results of the query being displayed. The query may be repeated multiple times, resulting in multiple pop-up charts being displayed.
  • the user may proceed to set Business Rules or mathematical calculations to one or more of the charts.
  • the user may also 'drag and drop' or combine the results of the charts and a new chart with the combined results will be displayed.
  • the user may 'drag and drop' any of these charts onto another chart (main chart) within the Dashboard or to another Dashboard.
  • the new chart may display data from both the charts.
  • the user may Save the new chart for better analysis of data from the relational and/or multidimensional databases.
  • FIG. 32 is a diagram illustrating an example of a computer system environment 80 in which the invention may be applied.
  • System environment 80 comprises of storage device 82, storage device interface 84, Central Processing Unit (CPU) 86, memory device 88, display interface 90, display monitor 92, computer bus 94, mouse 96, keyboard 98, and wireless device 100.
  • CPU Central Processing Unit
  • a mouse 96, keyboard 98 and wireless device 100 are able to provide inputs to the computer system.
  • the software code may be stored in a computer readable memory device 88 or storage device 82 or a combination of both the memory device 88 and the storage device 82. Further, a computer data signal representing the software code which may be embedded in a carrier wave that may be transmitted via a communication network.
  • the Central Processing Unit (CPU) 86 has access to memory device 88 and storage device 82, and is able to control operations of the computer by executing programs stored in the memory device 88 or storage device 82.
  • the display monitor 92 Operating together with the display interface 90, the display monitor 92 is able to provide graphic interface between programs executed and a user.
  • the method and system for navigation and visualization of data in relational and/or multidimensional databases of the described invention may be implemented by any hardware, software or a combination of hardware and software having the above described functions.
  • the invention is most suitably realized in software and used in conjunction with a stand-alone or networked computer having standard user-interface devices.
  • the software may be offered to users through a variety of methods such as online purchase and download over fixed line or wireless connection to the Internet, or recorded on a computer program medium of any kind such as optical, magnetic, magneto-optical and solid-state memory.
  • a computer program medium of any kind such as optical, magnetic, magneto-optical and solid-state memory.
  • relational and/or multidimensional database(s) may be provided on the same computer system as that running the application of the invention or located remotely and accessed via communication link, or a combination of these options.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

L'invention concerne un outil de conception mis en œuvre par ordinateur pour la navigation et la visualisation de données dans au moins une base de données relationnelle et/ou multidimensionnelle. L'outil de conception permet à un utilisateur de découper un écran d'affichage en une pluralité de cadres, d'insérer et de configurer des commandes dans chaque cadre pour former un tableau de bord, les commandes définissant des interrogations de la ou des bases de données et d'éventuelles règles associées à ces interrogations, et de créer les tableaux de bord à de multiples niveaux pour chacun des cadres. La configuration des commandes permet à l'utilisateur de définir des actions de pénétration pour les commandes dans chaque tableau de bord et de cibler des tableaux de bord dans n'importe lequel des multiples niveaux, tant dans le même cadre que le tableau de bord de départ que dans n'importe lequel ou dans la totalité des autres cadres. Les actions de pénétration définies par l'utilisateur permettent une navigation à multiples trajets et à multiples niveaux puissante et hautement flexible, pour obtenir la visualisation de données dans la ou les bases de données, par l'affichage sur l'écran d'un tableau de bord cible de l'un quelconque des multiples niveaux dans chaque cadre selon les commandes sélectionnées par cet utilisateur.
EP07734323A 2007-04-10 2007-04-10 Procédé et système pour une navigation et une visualisation de données dans des bases de données relationnelles et/ou multidimensionnelles Withdrawn EP2137643A4 (fr)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/IB2007/001004 WO2008122830A1 (fr) 2007-04-10 2007-04-10 Procédé et système pour une navigation et une visualisation de données dans des bases de données relationnelles et/ou multidimensionnelles

Publications (2)

Publication Number Publication Date
EP2137643A1 true EP2137643A1 (fr) 2009-12-30
EP2137643A4 EP2137643A4 (fr) 2012-03-21

Family

ID=39830510

Family Applications (1)

Application Number Title Priority Date Filing Date
EP07734323A Withdrawn EP2137643A4 (fr) 2007-04-10 2007-04-10 Procédé et système pour une navigation et une visualisation de données dans des bases de données relationnelles et/ou multidimensionnelles

Country Status (4)

Country Link
EP (1) EP2137643A4 (fr)
CN (1) CN101622619B (fr)
HK (1) HK1140557A1 (fr)
WO (1) WO2008122830A1 (fr)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2018063107A1 (fr) 2016-09-27 2018-04-05 E-Kalite Yazilim Donanim Muhendislik Tasarim Ve Internet Hizmetleri San. Tic. Ltd. Sti. Fonction de clone permettant de comparer une visualisation de données

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103930887B (zh) 2011-11-18 2017-11-07 惠普发展公司，有限责任合伙企业 使用行‑列数据存储的查询汇总生成
CN102521336B (zh) * 2011-12-08 2018-04-27 中国信息安全测评中心 一种基于动态关系的漏洞信息立方展示方法
CN103778140B (zh) * 2012-10-22 2017-04-05 苏州市迅泰信息科技有限公司 一种基于应用流程操作模式的可视化数据采集方法
US20140330821A1 (en) * 2013-05-06 2014-11-06 Microsoft Corporation Recommending context based actions for data visualizations
CN105488048A (zh) * 2014-09-16 2016-04-13 中兴通讯股份有限公司 一种数据查询的方法及装置
US10740873B2 (en) 2016-04-01 2020-08-11 Institute Of Remote Sesing And Digital Earth, Chinese Academy Of Sciences Extraction method for time-space-spectrum four-dimensional remote sensing data
CN107193950A (zh) * 2017-05-22 2017-09-22 环球智达科技（北京）有限公司 基于关系数据库的web数据可视化系统
CN108255541B (zh) * 2017-12-28 2021-09-24 东软集团股份有限公司 表单控件的数据源处理方法、装置、存储介质和电子设备
CN109710663B (zh) * 2018-12-29 2020-12-04 北京神舟航天软件技术有限公司 一种数据统计图表生成方法
CN115563385B (zh) * 2022-10-12 2023-07-28 中电金信软件有限公司 一种组合标签的生成方法及生成装置

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2001001206A2 (fr) * 1999-06-30 2001-01-04 Strategic Simulation Systems, Inc. Generateur de modeles du comportement dynamique de systemes et simulateur associe
US20030115207A1 (en) * 2001-09-25 2003-06-19 Bowman David M. Hierarchical hybrid OLAP analytics generators
US20030135481A1 (en) * 2001-12-07 2003-07-17 Philip Helmes Rules based method and system for project performance monitoring
US20040221259A1 (en) * 2003-05-01 2004-11-04 Devore Lyle E. Method and apparatus for status display with intermediate database access
US20060095858A1 (en) * 2004-10-29 2006-05-04 Hewlett-Packard Development Company, L.P. Hierarchical dataset dashboard view

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
AU2851600A (en) * 1999-01-15 2000-08-01 Metaedge Corporation Method for visualizing information in a data warehousing environment
AU2002334954B2 (en) * 2001-10-11 2008-07-31 Omniture, Inc. System, method, and computer program product for processing and visualization of information
US8165993B2 (en) * 2002-09-06 2012-04-24 Oracle International Corporation Business intelligence system with interface that provides for immediate user action
US20060031187A1 (en) * 2004-08-04 2006-02-09 Advizor Solutions, Inc. Systems and methods for enterprise-wide visualization of multi-dimensional data
US7788146B2 (en) * 2004-10-22 2010-08-31 Cfo Technology Corporation System for visualizing financial data
US9336267B2 (en) * 2005-10-11 2016-05-10 Heng Toon Ting Method and system for navigation and visualization of data in relational and/or multidimensional databases

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2001001206A2 (fr) * 1999-06-30 2001-01-04 Strategic Simulation Systems, Inc. Generateur de modeles du comportement dynamique de systemes et simulateur associe
US20030115207A1 (en) * 2001-09-25 2003-06-19 Bowman David M. Hierarchical hybrid OLAP analytics generators
US20030135481A1 (en) * 2001-12-07 2003-07-17 Philip Helmes Rules based method and system for project performance monitoring
US20040221259A1 (en) * 2003-05-01 2004-11-04 Devore Lyle E. Method and apparatus for status display with intermediate database access
US20060095858A1 (en) * 2004-10-29 2006-05-04 Hewlett-Packard Development Company, L.P. Hierarchical dataset dashboard view

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See also references of WO2008122830A1 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2018063107A1 (fr) 2016-09-27 2018-04-05 E-Kalite Yazilim Donanim Muhendislik Tasarim Ve Internet Hizmetleri San. Tic. Ltd. Sti. Fonction de clone permettant de comparer une visualisation de données
US10540076B2 (en) 2016-09-27 2020-01-21 E-Kalite Yazilim Donanim Muhendislik Tasarim Ve Internet Hizmetleri San. Tic. Ltd. Sti. Clone feature to compare data visualization

Also Published As

Publication number Publication date
EP2137643A4 (fr) 2012-03-21
CN101622619B (zh) 2013-03-27
WO2008122830A1 (fr) 2008-10-16
HK1140557A1 (en) 2010-10-15
CN101622619A (zh) 2010-01-06

Similar Documents

Publication Publication Date Title
US9336267B2 (en) Method and system for navigation and visualization of data in relational and/or multidimensional databases
US10740121B2 (en) User interface for navigating multiple applications
WO2008122830A1 (fr) Procédé et système pour une navigation et une visualisation de données dans des bases de données relationnelles et/ou multidimensionnelles
US10853382B2 (en) Interactive punchcard visualizations
US10222951B2 (en) Modeling system for graphic user interface
US10459939B1 (en) Parallel coordinates chart visualization for machine data search and analysis system
CA2766652C (fr) Matrices de documents evolutives et matrices de documents dissociables
JP6018045B2 (ja) 選択したデータの一時的な書式設定とグラフ化
US11037342B1 (en) Visualization modules for use within a framework for displaying interactive visualizations of event data
EP2321723B1 (fr) Génération d'interface utilisateur automatique pour interaction d'entité
US20100088618A1 (en) Developing user interface element settings
US10853380B1 (en) Framework for displaying interactive visualizations of event data
US20120054653A1 (en) Visualizing user interfaces
US10861202B1 (en) Sankey graph visualization for machine data search and analysis system
US7673245B2 (en) Converting user interface panels
CN113535165A (zh) 界面生成方法、装置、电子设备及计算机可读存储介质
Câmara et al. Handling complexity in GIS interface design
US8413062B1 (en) Method and system for accessing interface design elements via a wireframe mock-up
US8941658B2 (en) Method and apparatus for layered overview in visualization of large enterprise it environment
Wernert et al. PViN: a scalable and flexible system for visualizing pedigree databases
US20210154534A1 (en) System And Method For Generating Graphical Visualization
JP2003099466A (ja) コンテキストデータ表示方法、編集方法及びプログラム
Preim et al. ExPlates: Spatializing Interactive Analysis to Scaffold Visual Exploration
Guimarães et al. Using Multiple Coordinated Views for Multiple Datasets Analysis

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20091109

AK Designated contracting states

Kind code of ref document: A1

Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU LV MC MT NL PL PT RO SE SI SK TR

DAX Request for extension of the european patent (deleted)
A4 Supplementary search report drawn up and despatched

Effective date: 20120217

RIC1 Information provided on ipc code assigned before grant

Ipc: G06F 17/30 20060101AFI20120213BHEP

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: EXAMINATION IS IN PROGRESS

17Q First examination report despatched

Effective date: 20170516

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION IS DEEMED TO BE WITHDRAWN

18D Application deemed to be withdrawn

Effective date: 20170927