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

• US 9,336,267 B2
• Filed: 10/11/2006
• Issued: 05/10/2016
• Est. Priority Date: 10/11/2005
• Status: Active Grant

• Current Assignee: Heng Toon Ting
• Original Assignee: Heng Toon Ting
• Inventors: Ting, Heng Toon
• Primary Examiner(s): Ng, Amy
• Assistant Examiner(s): STITT, ERIK V
• Application Number:
  US11/548,308
• Publication Number:
  US 20070130113A1
• Time in Patent Office: 3,499 Days
• Field of Search: 715/764, 715/781, 715/783, 715/810, 715/763
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

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

Claims

1. A computer-implemented method for the visualization and navigation of data retrieved from at least one of a relational or a multidimensional database, the method performed by a computer processor and comprising the steps of:

designing a layout and format of at least one display module by a user to display the data;

partitioning the at least one display module by the user into a plurality of frames including frames A, B and C, wherein each frame has a user-definable size;

inserting controls into each of the plurality of frames by the user, wherein the controls are selected by the user and include any one of;

charts, dials, images, icons, text boxes, buttons, or pivot tables;

configuring and user-customizing properties and business rules associated with each of the controls in the frames to create dashboards, wherein a dashboard is a frame with the controls configured;

associating the dashboards by the user into multiple layers for each frame, wherein each layer includes a different dashboard displaying a different type of data in a same frame, the different types of data including any one of;

text, graphics, or other data such that frame A includes dashboards A1 through AX, frame B includes dashboards B1 through BY and frame C includes dashboards C1 through CZ where X, Y and Z are integers greater than 1; and

associating actions with the controls by the user in each dashboard, the actions enabling multi-path navigation across different frames and multi-layer navigation through the multiple layers of dashboards within a single frame, whereby activating a single control;

retrieves different content data from the database, the different content data being related to data displayed in the dashboard where the control was activated; and

updates the dashboard displayed in one or more frames, wherein the displayed dashboard includes a different dashboard with the different content data retrieved from the database such that at least one single controls updates a dashboard display of dashboards Ai, in frame A, Bj in frame B and Ck in frame C to a display of dashboards Ai′

, in frame A, Bj′

in frame B and Ck′

in frame C where i is not equal to i′ and

are both integers in the range of 1 to X,j is not equal to j′ and

are both integers in the range of 1 to Y, and k is not equal to k′ and

are both integers in the range of 1 to Z.

2. The computer-implemented method according to claim 1, wherein the actions connect to any one of:

other display modules, external Uniform Resource Locators (URLs), websites, or applications.

3. The computer-implemented method according to claim 1, wherein:

one of the plurality of frames is adapted to display representations relating to different stages of a process, and

controls in the one frame are associated with the representations, the controls having associated actions for extracting and displaying further information relating to the associated process stage in others of the plurality of frames.

4. The computer-implemented method according to claim 3, further comprising:

comparing a result of a query to the at least one of a relational or a multidimensional database with a target or threshold; and

color-coding the controls based on the comparing.

5. The computer-implemented method according to claim 1, wherein a number of dashboard levels for any one frame is independent of a number of dashboard levels in any other frame.

6. The computer-implemented method according to claim 1, comprising:

using a query generator with business rules capabilities for performing an ad-hoc query on the at least one of a relational or a multidimensional database.

7. A computer-implemented method for the navigation and visualization of data retrieved from at least one of a relational or a multidimensional database, the method performed by a computer processor and comprising the steps of:

partitioning a display screen by a user into a plurality of frames including frames A, B and C, wherein each frame has a user-definable size;

inserting and configuring controls by the user to form a dashboard within each frame, wherein the controls are selected by the user and include any one of;

charts, dials, images, icons, text boxes, buttons, or pivot tables, and the controls define queries to the at least one of a relational or a multidimensional database; and

associating the dashboards by the user into multiple layers for each frame, wherein each layer includes a different dashboard displaying a different type of data in a same frame, the different types of data including any one of;

text, graphics, or other data such that frame A includes dashboards A1 through AX, frame B includes dashboards B1 through BY and frame C includes dashboards C1 through CZ where X, Y and Z are integers greater than 1;

wherein configuring the controls includes defining actions associated with the controls, the actions relating to target dashboards in any layer, the target dashboards including dashboards within the same frame or in other frames;

whereby the actions enable multi-path navigation across different frames and multi-layer navigation through the multiple layers of dashboards within a single frame, whereby activating a single control;

retrieves different content data from the database, the different content data being related to data displayed in the dashboard where the control was activated; and

updates the dashboard displayed in one or more frames, wherein the displayed dashboard includes a different dashboard with the different content data retrieved from the database such that at least one single controls updates a dashboard display of dashboards Ai, in frame A, Bj in frame B and Ck in frame C to a display of dashboards Ai′

, in frame A, Bj′

in frame B and Ck′

in frame C where i is not equal to i′ and

are both integers in the range of 1 to X, j is not equal to j′ and

are both integers in the range of 1 to Y, and k is not equal to k′ and

are both integers in the range of 1 to Z.

8. The computer-implemented method according to claim 7, wherein the actions connect to any one of:

other display modules, external Uniform Resource Locators (URLs), websites, or applications.

9. The computer-implemented method according to claim 7, wherein a number of dashboard layers for any one frame is independent of a number of dashboard layers in any other frame.

10. The computer-implemented method according to claim 7, further comprising:

using a query generator with business rules capabilities for performing an ad-hoc query on the at least one of a relational or a multidimensional database.

11. A computer-implemented system for the visualization and navigation of data retrieved from at least one of a relational or a multidimensional database, the system executed by a processor and configured to:

design a layout and format of at least one display module by a user to display the data;

partition the at least one display module by the user into a plurality of frames including frames A, B and C, wherein each frame has a user-definable size;

insert controls into each of the plurality of frames by the user, wherein the controls are selected by the user and include any one of;

charts, dials, images, icons, text boxes, buttons, or pivot tables;

configure and user-customize properties and business rules associated with each of the controls in the frames to create dashboards, wherein a dashboard is a frame with the controls configured;

associate the dashboards by the user into multiple layers for each frame, wherein each layer includes a different dashboard displaying a different type of data in a same frame, the different types of data including any one of;

text, graphics, or other data such that frame A includes dashboards A1 through AX, frame B includes dashboards B1 through BY and frame C includes dashboards C1 through CZ where X, Y and Z are integers greater than 1;

associate actions with the controls by the user in each dashboard, the actions enabling multi-path navigation across different frames and multi-layer navigation through the multiple layers of dashboards within a single frame, whereby activating a single control;

retrieves different content data from the database, the different content data being related to data displayed in the dashboard where the control was activated; and

updates the dashboard displayed in one or more frames, wherein the displayed dashboard includes a different dashboard with the different content data retrieved from the database such that at least one single controls updates a dashboard display of dashboards Ai, in frame A, Bj in frame B and Ck in frame C to a display of dashboards Ai′

, in frame A, Bj′

in frame B and Ck′

in frame C where i is not equal to i′ and

are both integers in the range of 1 to X, j is not equal to j′ and

are both integers in the range of 1 to Y, and k is not equal to k′ and

are both integers in the range of 1 to Z; and

saving the dashboards to complete the at least one display module.

12. The system of claim 11, further configured to:

apply new business rules and calculations to the data displayed in a dashboard, to facilitate interaction with and analysis of the data; and

display the results of applying the new business rules and calculations to the data in the dashboard.

13. The system of claim 11, further comprising:

a query generator configured with business rules capabilities and functions, whereby the user may perform an ad-hoc query on the at least one of a relational or a multidimensional database by interacting with data displayed in one of the dashboards.

14. The system of claim 12, further configured to save the results of newly applied rules and calculations as a new element of the dashboard.

15. The system of claim 13, further configured to save the results of the query as a new element of the dashboard.

16. A computer-implemented design tool for the navigation and visualization of data retrieved from at least one of a relational or a multidimensional database, the design tool comprising:

a processor configured to partition a display screen by direction of a user into a plurality of frames including frames A, B and C, wherein each frame has a user-definable size;

the processor configured to insert and configure controls by the user within each frame of the plurality of frames to form a dashboard, wherein the controls are selected by the user and include any one of;

charts, dials, images, icons, text boxes, buttons, or pivot tables, and the controls define queries to the at least one of a relational or a multidimensional database, and any rules associated with those queries; and

the processor configured to associate the dashboards by the user into multiple layers for each of the plurality of frames, wherein each layer includes a different dashboard displaying a different type of data in a same frame, the different types of data including any one of;

text, graphics, or other data such that frame A includes dashboards A1 through AX, frame B includes dashboards B1 through BY and frame C includes dashboards C1 through CZ where X, Y and Z are integers greater than 1;

wherein the processor is configured to permit the user to associate actions with the controls within each dashboard to target dashboards in any of the layers, the target dashboards including dashboards within the same frame or in other frames;

whereby the actions enable multi-path navigation across different frames and multi-layer navigation through the multiple layers of dashboards within a single frame; and

whereby activating a single control;

retrieves different content data from the database, the different content data being related to data displayed in the dashboard where the control was activated; and

updates the dashboard displayed in one or more frames, wherein the displayed dashboard includes a different dashboard with the different content data retrieved from the database such that at least one single control updates a dashboard display of dashboards Ai, in frame A, Bj in frame B and Ck in frame C to a display of dashboards Ai′

, in frame A, Bj′

in frame B and Ck′

in frame C where i is not equal to i′ and

are both integers in the range of 1 to X, j is not equal to j′ and

are both integers in the range of 1 to Y, and k is not equal to k′ and

are both integers in the range of 1 to Z.