Methods, apparatus and systems for data sorting, visualisation and related applications

• US 9,798,707 B2
• Filed: 08/06/2014
• Issued: 10/24/2017
• Est. Priority Date: 08/06/2013
• Status: Active Grant

• Current Assignee: New BIS Safe Luxco S.A R.L
• Original Assignee: New BIS Safe Luxco S.A R.L
• Inventors: Cardno, Andrew John
• Primary Examiner(s): Cortes, Howard
• Application Number:
  US14/453,226
• Publication Number:
  US 20150046794A1
• Time in Patent Office: 1,175 Days
• Field of Search: None
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 40/117 Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/14 Tree-structured documents parsing G06F40/205; validation G06F40/226

Abstract

A method of creating a style sheet for the generation of a graphical representation of a data set made up of a plurality of data elements or values used in a data visualization computing system is described. The method having the steps of retrieving the data values of the data elements in the data set; determining the types of data elements in the set; obtaining the style attributes associated with each type of data element; developing a hierarchy of style attributes; and creating a style sheet to apply to the data set.

Claims

1. In a data visualization computing system, having a display device, a computer implemented method of creating a style sheet for the generation of a graphical representation of a data set made up of a plurality of data elements or values, the method having the steps of:

a) retrieving the data values of the data elements in the data set;

b) determining data types of the data elements in the set;

c) obtaining style attributes associated with each data type of data element, wherein the style attributes determine how the data elements are displayed in the generated graphical representation;

d) obtaining pre-set or pre-existing weightings for each data element;

e) developing a hierarchy of style attributes based on the weightings for each data element, wherein the generated graphical representation depends on the hierarchy and the style attributes applied depend on the order of the style attributes in the hierarchy;

f) creating a style sheet of the style attributes associated with the data type of data element and the hierarchy of style attributes to apply to the data set;

g) generating a graphical representation of the data set using the style sheet; and

h) displaying the graphical representation on the display, by;

i) rendering a rendered output including the graphical representation generated using the style sheet; and

ii) providing the rendered output to the display device and generating the graphical representation on the display device to allow a user to visualize the data,

wherein the user can change the weightings for each data element and when the user changes the weightings repeating steps e) to h).

2. The method as claimed in claim 1 wherein in the steps of obtaining the style attributes and developing a hierarchy of style attributes, a user sets relative weightings of each of the data elements.

3. The method as claimed in any claim 1 wherein the steps of obtaining the style attributes and developing a hierarchy of style attributes are divided into the steps of firstly sorting the retrieved data elements by function, and secondly applying a priority or weighting to each function.

4. The method as claimed in claim 3 wherein the hierarchy is developed according to the weightings, the hierarchy forming the framework or basis of the style sheet which is applied to the retrieved data elements to format an output for the data elements.

5. The method as claimed in claim 1 wherein the method also includes the step of applying a set of rules for overall presentational style, to generate the required elements that include but are not limited to font, font size, colour elements for background, text, table size, shading.

6. The method as claimed in claim 5 wherein the elements which relate to overall presentational style are associated with the hierarchy so that the overall appearance of the output depends on the hierarchy.

7. The method as claimed claim 1 wherein in the step of retrieving the data values of the data elements in the data set, a user sets parameters around the data values to be retrieved.

8. The method as claimed in claim 7 wherein the parameters include but are not limited to:

a date range, a time range, a location range or location subset, a transaction range or sub set.

9. The method as claimed in claim 7 wherein the user set parameters may be chosen from any combination of, but not limited to, the following elements:

a data range, a location range or number of locations, a sales range, a revenue range.

10. The method as claimed in claim 1 wherein the data elements can be any combination of, but not limited to, the following elements:

time of sale, location, time of use, size of sale.

11. The method as claimed in claim 1 wherein a user can manually input or rearrange the hierarchy either pre- or post-output.

12. The method as claimed in claim 1 wherein the generated graphical representation of the data is any of, but not limited to, the following formats:

table, bar chart, pie chart, scatter plot, line chart, heat map, box spiral.

13. The method as claimed in claim 1 wherein the method includes the step, after the hierarchy of style attributes has been developed, of assessing the overall pattern formed by the hierarchy and the data elements, and developing the overall pattern for the output using those data elements which form the majority, the minority of data elements within the retrieved data which do not naturally comply overridden to fit within the overall pattern.

14. The method of claim 13 wherein the method also includes the step of applying a set of rules for overall presentational style, the minority of data elements which do not naturally fit within the pattern presented in a different manner from the majority data elements.

15. The method as claimed in claim 13 wherein the method also includes the steps of applying a set of rules for overall presentational style, and assessing any results within the overall pattern that lie outside or deviate from the mean or average by an amount, those results presented in a different manner from the majority data elements.

16. The method as claimed in claim 15 wherein the amount is a default amount.

17. The method as claimed in claim 16 wherein the default amount is a percentage.

18. The method as claimed in claim 16 wherein the default amount is a numerical value based on the relevant data elements.

19. The method as claimed in claim 15 wherein the amount is a user-specified amount.

20. The method as claimed in claim 19 wherein the user-specified amount is a percentage.

21. The method as claimed in claim 19 wherein the user-specified amount is a numerical value based on the relevant data elements.