Method for selecting a data set from a plurality of data sets by means of an input device

• US 8,972,467 B2
• Filed: 08/31/2010
• Issued: 03/03/2015
• Est. Priority Date: 08/31/2010
• Status: Active Grant

• Current Assignee: Sovanta AG
• Original Assignee: Sovanta AG
• Inventors: Heinrich, Claus, Kern, Michael
• Primary Examiner(s): Reyes, Mariela
• Assistant Examiner(s): CONYERS, DAWAUNE A
• Application Number:
  US13/202,455
• Publication Number:
  US 20140157142A1
• Time in Patent Office: 1,645 Days
• Field of Search: 707/770, 707/758, 707/7.41, 707/826, 715/744
• US Class Current: 707/826
• CPC Class Codes: G06F 3/0412 Digitisers structurally integrated in a display
• CPC Class Codes: G06F 3/048 Interaction techniques based on graphical user interfaces [GUI]
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes

Abstract

The invention relates to a computer-implemented method for selecting a data set from a plurality of data sets by means of a multi-touch input device, the data sets being connected with each other according to a topology of a graph, the input device comprising:

• • a multi-touch screen,
  • a motion sensing unit, and
  • an acceleration sensing unit,

the method comprising:

• • displaying a view by the multi-touch screen, the view comprising a plurality of GUI elements, each GUI element representing one of the data sets, whereby one of the GUI elements is used as current GUI element;
  • detecting, by the motion sensing unit, one or more first tilting motions;
  • determining at least one candidate GUI element in dependence on the one or more first tilting motions;
  • highlighting the at least one candidate GUI element;
  • detecting a first shaking motion;
  • automatically selecting, upon the detection of the first shaking motion, the data set represented by the highlighted GUI element.

Claims

1. A method for providing a plurality of aggregated Key Performance Indicator values (KPI-values) of a plurality of different KPIs to one or more views of a GUI of a client processing device, the method comprising:

providing the client processing device, the client processing device being a mobile, hand-held electronic appliance, the client processing device comprising;

a touch-screen for displaying the one or more views,

an application program,

wherein the client processing device is adapted to receive log-in data of a user, and

a first database,

providing a server processing device, the server processing device being operatively coupled to a second database, wherein the first database and the second database respectively comprise an organization graph, each organization node of the organization graph having assigned one or more KPI values, the server processing device comprising;

a plurality of web-service interfaces being accessible by the application program, each interface being operable to receive and process a request for one or more KPIs being particular to said interface, each interface being operable to return an aggregated KPI value read from the second database, wherein the first and the second database respectively comprise a first table for storing O-aggregated KPI-values, each O-aggregated KPI value being calculated for one of the organization nodes and one of the KPIs by aggregating KPI values of said one KPI being respectively assigned to said one organization node or to any of its direct or indirect child nodes,

receiving the log-in data of the user by the application program,

identifying one organization node of the organization graph as the organization node representing the logged-in user and using said identified node as current organization node,

A) determining one or more first KPIs for the current organization node;

B) accessing, by the application program, the first table of the first database for retrieving O-aggregated KPI values for one or more first KPIs for the current organization node,

C) in case the O-aggregated KPI values could not be retrieved from the first database, determining from the plurality of web service interfaces one or more first web-service interfaces being operable to receive and process a request for the first KPIs,

D) querying, by the application program, the determined first web service interfaces via a network for receiving the O-aggregated KPI values of the first KPIs,

E) storing, by the application program, the O-aggregated KPI values received from the second database in the first table of the first database,

F) displaying, by the application program, the O-aggregated KPI values retrieved from the first database or received from the second database in an organization view, the organization view displaying the current organization node and its direct child organization nodes, the organization view enabling the user to navigate within the organization graph, whereby a selection of one of the displayed organization nodes triggers there-execution of the steps A-F, wherein the selected organization node is used as the current organization node

wherein the content of the first table of the first database is automatically filled by the application program with O-aggregated KPI values by submitting a plurality of requests to the first web service interfaces until for each KPI and for each organization node being the organization node representing the logged-in user or being one of the direct or indirect child nodes of said organization node the corresponding O-aggregated KPI value is received from the second database and is stored to the first table of the first database.

2. The method of claim 1,

whereby the first and the second database further respectively comprise a region graph, the region graph comprising region nodes, each region node representing a geographic region, each region node being stored in association with one or more of the organization nodes,

whereby the first and the second databases respectively comprise a second table for storing R-aggregated KPI-values, each R-aggregated KPI value being calculated for a unique combination of one of the region nodes and one of the KPIs by aggregating KPI values of said one KPI being assigned to any of a set of organization nodes, said set comprising said one organization node and its direct and indirect child organization nodes, the organization nodes of said set being stored in association with said one region node,

whereby according to the structure of the second table each table row represents a unique combination of a region node and an organization node, each of the KPIs being represented by one column of the second table, whereby each cell specified by a particular row and a particular KPI-representing column is used for storing an R-aggregated KPI-value calculated for the KPI of said cells'"'"' row and for the region node and the organization node of said cell'"'"'s column,

the method further comprising:

displaying a region view on the GUI, wherein at least some region GUI elements of the region view respectively represent one of the region nodes,

receiving a signal being indicative of one of the region GUI elements selected by the user,

identifying one region node of the region graph as being represented by the selected region GUI element and using the identified region node as current region node,

G) determining one or more second KPIs for the current region node,

H) accessing, by the application program, the second table of the first database for retrieving R-aggregated KPI values for one or more second KPIs for the current region node,

I) in case the R-aggregated KPI values could not be retrieved, determining from the plurality of web service interfaces one or more second web-service, interfaces being operable to receive and process a request for the second KPIs,

J) querying, by the application program, the determined second web service interfaces via a network for receiving the R-aggregated KPI values of the second KPIs,

K) storing, by the application program, the R-aggregated KPI values received from the second database in the second table of the first database,

L) displaying, by the application program, the R-aggregated KPI values retrieved from the first database or received from the second database, in the region view of the GUI, the region view displaying at least one region GUI element representing the current region node, the region view enabling the user to navigate within the region graph, whereby a selection of one of the displayed region nodes triggers the re-execution of the steps G-K, whereby the selected region node is used as the current region node.

3. The method of claim 2,

wherein the second table of the first database is automatically filled by the application program with R-aggregated KPI values by submitting a plurality of requests to the second web service interfaces until for each combination of a region node and an organization node, said organization node being the organization node representing the logged in user or any of its direct or indirect child nodes, all R-aggregated KPI values stored in the second database are received and are stored to the second table of the first database.

4. The method of claim 2, whereby the application program is operable to automatically and dynamically switch between using the second database for retrieving the O- and/or R-aggregated KPI values to be displayed,

wherein the first database is used by the application program by default, wherein in case the first database is outdated, the application program switches to the second database and updates the first database in parallel,

wherein in case no network connection to the server is available when starting or executing the update of the first database, the application program does not start the updating process and automatically uses the first database or uses those parts of the first database having already been received during the update process before the network connection was terminated.

5. The method of claim 2, whereby the requested O- and/or R-aggregated KPI values returned by the requested web service interfaces are returned in the form of BLOBs.

6. The method of claim 2,

whereby the first and the second database further respectively comprise a third table, whereby according to the structure of the third table:

each row represents a unique combination of a particular organization node and a particular KPI,

each of a plurality of T -columns respectively represents a top rank position, and

each of a plurality of L-columns respectively represent a low rank position, whereby the T-aggregated KPI values and the L-aggregated KPI values stored in the cells of the third table are calculated for each unique combination of one of the KPIs and one of the organization nodes by;

using all organization nodes being direct child nodes of said one organization node as current organization nodes,

for each of said current organization nodes, and for said one KPI, calculating an O-aggregated KPI value,

sorting said O-aggregated KPI values in descending order for generating a sorted list of the top O-aggregated KPI values, Page 6 of 17 U.S. application Ser. No. 13/202,455

storing at least some of said sorted O-aggregated KPI values at the top positions of said sorted list as T -aggregated KPI values into a corresponding number of cells, whereby each T-aggregated KPI value is stored into a cell whose column represents a top rank position being identical to the position of said T-aggregated KPI value within said sorted list; and

storing at least some of said sorted O-aggregated KPI values at the lowest positions of said sorted list as L-aggregated KPI values into a corresponding number of cells, whereby each L-aggregated KPI value is stored into a cell whose column represents a low rank position being identical to the position of said L-aggregated KPI value within said sorted list;

the method further comprising;

displaying a top/low view, wherein one or more T/L GUI elements of the top/low view respectively represent one of the KPIs,

receiving a signal being indicative of one of the T/L-GUI elements having been selected by the user;

determining one or more third KPIs;

accessing, by the application program, the third table of the first database for retrieving T- and/or L-aggregated KPI values for each of said third KPIs,

in case the T- and/or L-aggregated KPI values could not be retrieved, determining from the plurality of web service interfaces one or more third web-service interfaces being operable to receive and process a request for the third KPIs,

querying, by the application program, the determined third web service interfaces via the network for receiving the T- and/or L-aggregated KPI values of the third KPIs,

storing, by the application program, the T- and/or L-aggregated KPI values received from the second database in the third table of the first database,

displaying, by the application program, the T- and/or L-aggregated KPI values retrieved from the first database or received from the second database in the top/low view of the GUI.

7. The method of claim 6, wherein the aggregated data values are calculated by a data aggregation module running on the server processing device, wherein the structure of the first, second and third table of the first database respectively is identical to or is a sub-structure of the structure of the first, second and third table of the second database, and wherein preferentially at least some organization nodes in the first and/or second database are stored in association with a compressed image of a user represented by said organization node, the image compression being executed by said data aggregation module.

8. The method of claim 6,

wherein the second table of the first database is automatically filled by the application program with R-aggregated KPI values by submitting a plurality of requests to the second web service interfaces until for each combination of a region node and an organization node, said organization node being the organization node representing the logged in user or any of its direct or indirect child nodes, all R-aggregated KPI values stored in the second database are received and are stored to the second table of the first database, and/or

wherein the third table of the first database is automatically filled by the application program by submitting one or more requests to the third web service interfaces for receiving, for all combinations of one of the KPIs with one of the organization nodes, said one organization node being the organization node representing the logged in user or any of said node'"'"'s direct or indirect child nodes, all T-aggregated KPI values and all L-aggregated values contained in the second database, the received L- and T-aggregated data values being stored to the third table of the first database.

9. The method of claim 8, wherein the first database and the third database, is emptied upon each termination of the application program.

10. The method of claim 6, wherein the first database is an in-memory database, and wherein the first database is automatically kept up-to-date by executing the following steps:

M) determining, by the application program, whether the first database is empty or is outdated,

N) in case the first database is outdated, the application program automatically deletes the aggregated KPI values stored in the first database, thereby creating an empty database,

O) in case it was determined in M) that the first database is empty or in case the database was emptied in step N), operating the application program in update mode,

wherein in the update mode the step of accessing the first database for retrieving O-, R-, L- and/or T-aggregated KPI values is skipped, and wherein only the second database is accessed via the plurality of web services for retrieving the O-, R-, L- and/or T- aggregated KPI values for display,

wherein in the update mode the application program automatically, as a background process, submits one or more update requests to the plurality of web-services until the first database is updated, and

wherein the update-mode is terminated as soon as the first database is updated.

11. The method of claim 6, whereby the application program is operable to automatically and dynamically switch between using the second database for retrieving the O-, R-, L- and/or T- aggregated KPI values to be displayed, wherein the first database is used by the application program by default,

wherein in case the first database is outdated, the application program switches to the second database and updates the first database in parallel,

wherein in case no network connection to the server is available when starting or executing the update of the first database, the application program does not start the updating process and automatically uses the first database or uses those parts of the first database having already been received during the update process before the network connection was terminated.

12. The method of claim 6,

wherein the O- and R-aggregated KPI values are pre-calculated by the server processing device for all organization nodes of the organization graph, the pre-calculated O- and R-aggregated KPI values being stored in the second database,

wherein the L- and/or T-aggregated KPI values are pre-calculated by the server processing device for all organization nodes belonging to the n top hierarchical levels of the organization graph, n being an integer larger 0 and smaller than 5, the pre-calculated L- and/or T-aggregated KPI values being stored in the second database,

wherein all other L- and/or T-aggregated KPI values are calculated by the server processing device upon having received a request via one of the web service interfaces, said calculated L- and/or T-aggregated KPI values being stored in the second database, and

wherein the client processing device does not calculate any of the O-, R-, L- and/or T-aggregated KPI values but rather receives each of said values from the first or second database.

13. The method of claim 6, whereby the requested O-, R-, L- and/or T-aggregated KPI values returned by the requested web service interfaces are returned in the form of BLOBs.

14. The method of claim 1, wherein the first database is an in-memory database, and wherein the first database is automatically kept up-to-date by executing the following steps:

M) determining, by the application program, whether the first database is empty or is outdated,

N) in case the first database is outdated, the application program automatically deletes the aggregated KPI values stored in the first database, thereby creating an empty database,

O) in case it was determined in M) that the first database is empty or in case the database was emptied in step N), operating the application program in update mode,

wherein in the update mode the step of accessing the first database for retrieving O-aggregated KPI values is skipped, and wherein only the second database is accessed via the plurality of web services for retrieving the O-aggregated KPI values for display,

wherein in the update mode the application program automatically, as a background process, submits one or more update requests to the plurality of web-services until the first database is updated, and

wherein the update-mode is terminated as soon as the first database is updated.

15. The method of claim 1, wherein the first database is an in-memory database, and wherein the first database is automatically kept up-to-date by executing the following steps:

M) determining, by the application program, whether the first database is empty or is outdated,

N) in case the first database is outdated, the application program automatically deletes the aggregated KPI values stored in the first database, thereby creating an empty database,

O) in case it was determined in M) that the first database is empty or in case the database was emptied in step N), operating the application program in update mode,

wherein in the update mode the step of accessing the first database for retrieving O- and/or R-aggregated KPI values is skipped, and wherein only the second database is accessed via the plurality of web services for retrieving the O-and/or R-aggregated KPI values for display,

wherein in the update mode the application program automatically, as a background process, submits one or more update requests to the plurality of web-services until the first database is updated, and

wherein the update-mode is terminated as soon as the first database is updated.

16. The method of claim 1,

wherein the first database is an in-memory database,

wherein the client processing device comprises a computer-readable, non-volatile storage medium,

wherein a third database is persistently stored by the application program in said non-volatile storage medium, the third database being an encrypted copy of the first database, the encryption being executed by the application program,

wherein the first database is not encrypted,

wherein the application program, upon program start, creates the first database by reading the persistent first database from the non-volatile storage medium, decrypting the content of the third database, initializing the first database in the memory and filling the first database with the decrypted content of the third database.

17. The method of claim 1, wherein the first database and, if present, also the third database, is emptied upon each termination of the application program.

18. The method of claim 1, whereby the application program is operable to automatically and dynamically switch between using the second database for retrieving the O-aggregated KPI values to be displayed,

wherein the first database is used by the application program by default,

wherein in case the first database is outdated, the application program switches to the second database and updates the first database in parallel,

wherein in case no network connection to the server is available when starting or executing the update of the first database, the application program does not start the updating process and automatically uses the first database or uses those parts of the first database having already been received during the update process before the network connection was terminated.

19. The method of claim 1, whereby the requested O-aggregated KPI values returned by the requested web service interfaces are returned in the form of a binary large objects (BLOBs).

20. The method of claim 1, wherein the application program comprises a learning module, the method further comprising the step of:

logging, by the learning module, identifiers of the one or more first, second and/or third web service interfaces used over a time period,

calculating, by the learning module applying a learning algorithm on the logged web service interface identifiers, for each of the web service interfaces a score value, said score value being indicative of the probability that the logged-in user submits a web service request for an aggregated KPI value to any of said first, second and/or third web service interfaces,

automatically submitting, upon a log-in operation of the user, by the application program, one or more prefetching web service requests in dependence of the calculated score value.

21. The method of claim 20, wherein a higher usage probability of a web service interface is indicated by a higher score value, wherein the order of the first, second and third web service interfaces used for updating the first database depends on the score value of each respective web service, whereby the higher the score value, the earlier the web service interface is requested during the update process.

22. A non-transitory computer-readable storage medium, the storage medium comprising computer-interpretable instructions which, when executed by a processor, cause the processor to execute the steps of claim 1.

23. A computing system for providing a plurality of aggregated KPI-values of a plurality of KPIs, from a server processing device to one or more views of a GUI of at least one client processing device, comprising:

the client processing device, the client processing device being a mobile, hand-held electronic appliance, the client processing device comprising;

a touch-screen for displaying the one or more views, an application program,

wherein the client processing device is adapted to receive log-in data of a user, and

a first database, the first database comprising a first table for storing O-aggregated KPI-values, each O-aggregated KPI value being calculated for one organization node of an organization graph and for one of the KPIs by aggregating KPI values of said one KPI being respectively assigned to said one organization node or to any of its direct or indirect child nodes,

wherein the client processing device is adapted to receive the log-in data of the user by the application program,

wherein the client processing device is adapted to identify one organization node of the organization graph as the organization node representing the logged-in user and using said identified node as current organization node,

the server processing device, the server processing device being operatively coupled to a second database, wherein the second database comprises a copy of said organization graph, the server processing device comprising;

a plurality of web-service interfaces being accessible by the application program, each interface being operable to receive and process a request for one or more of the plurality of KPIs being particular to said interface, each interface being operable to return an aggregated KPI value read from the second database, wherein the second database comprises a further first table for storing O-aggregated KPI-values, each O-aggregated KPI value being calculated for one of the organization nodes and one of the KPIs by aggregating KPI values of said one KPI being assigned to said one organization node or to any of its direct or indirect child nodes, wherein the application program is operable to execute the steps of;

A) determining one or more first KPIs for the current organization node;

B) accessing the first table of the first database for retrieving O-aggregated KPI values for one or more first KPIs for the current organization node,

C) in case the O-aggregated KPI values could not be retrieved from the first database, determining from the plurality of web service interfaces one or more first web-service interfaces being operable to receive and process a request for the first KPIs,

D) querying the determined first web service interfaces via a network for receiving the O-aggregated KPI values of the first KPIs,

E) storing the O-aggregated KPI values received from the second database in the first table of the first database,

F) displaying the O-aggregated KPI values retrieved from the first database or received from the second database in an organization view, the organization view displaying the current organization node and its direct child organization nodes, the organization view enabling the user to navigate within the organization graph, whereby a selection of one of the displayed organization nodes triggers there-execution of the steps A-F, wherein the selected organization node is used as the current organization node

wherein the content of the first table of the first database is automatically filled by the application program with O-aggregated KPI values by submitting a plurality of requests to the first web service interfaces until for each KPI and for each organization node being the organization node representing the logged-in user or being one of the direct or indirect child nodes of said organization node the corresponding O-aggregated KPI value is received from the second database and is stored to the first table of the first database.