Posts tagged sunburst
ADF 12c – The Hierarchical Mystery Tour – Treemap, Sunburst, Treetable, Hierarchy Viewer and Thematic Map0
Hierarchical data is common phenomenon in the real world. Presenting such data to allow users to quickly grasp the composition of numbers, to compare quantities, to navigate through a data set and to have a pleasant experience with potentially dreary facts is quite valuable. ADF 12c (as well as previous releases) offer a wealth of components that help us present data in interesting, meaningful ways. For hierarchical data, components that come to mind include the Hierarchy Viewer, the Treemap and Sunburst components and if the data is of a geographical nature the Map components. Of course the tree and treetable and pivot table can be used to present such data as well.
This article demonstrates the use of a number of these components on population statistics for cities, countries, continents and regions. I hope you spot the hierarchical pattern in this list. This YouTube movie (4.20 minute, no sound) shows the components in actions. The resources section of this article makes the JDeveloper 12c (12.1.2) application available for download, with all the source code inside.
The recent JDeveloper/ADF 11gR1 Patch Set 6 release introduced the Sunburst component, one of the many data visualization components in ADF. Sunburst (sometimes called Rings Chart) provides an attractive and useful way to quickly learn about the hierarchical build of certain values. One well known example is the space usage on a storage device, such as on the Gnome desktop on Linux – see on the right.
The left side of the figure shows the directories on the file system and their relative and absolute size. The rings chart or sunburst makes it abundantly clear which directories contain the most data and which subdirectories inside are the big ones.
The ADF DVT Sunburst component allows us to create a similar representation of the build up of a values from their constituents and their constituents. A simple and not very exciting example is presented in this article: the salary distribution in table EMP – per department (level 1) and per employee (level 2). We will also compare this presentation as sunburst with the counterpart presentation using Treemap. The two are quite similar and can be used in similar circumstances, depending on whether the focus of using the data visualization More >
One of my favorite areas of ADF is Data Visualization. The rich, interactive and (un)usually attractive components that allow me to spice up an ADF application in a very easy straightforward way have a special appeal. We all know that pictures speak volumes. And that a plain table presents data while a carefully designed visualization presents information and perhaps even a call to action. One of my highlights during Oracle Open World 2012 was – not surprisingly – the presentation by the ADF DVT team – Katrina, Hugh and Jairam – together with Yiannis and Vangelis from PCS in Greece who built a wonderful ADF application for private investment management, with beautiful and very effective data visualizations all over the place.
The story of ADF DVT is one that started probably even before ADF with the BI Beans and before that perhaps even with Oracle Graphics. However, forget about all that history and look to the present and the future. No presentation of Fusion Applications is held without showing off its many data visualizations as a means to turn data into information and information into action. Drawing the user to exceptions, deadlines, alerts, patterns and items to act on is More >