Change search
ReferencesLink to record
Permanent link

Direct link
Interactive visualization of financial data: Development of a visual data mining tool
Uppsala University, Disciplinary Domain of Science and Technology, Mathematics and Computer Science, Department of Information Technology.
2012 (English)Independent thesis Advanced level (professional degree), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

In this project, a prototype visual data mining tool was developed, allowing users to interactively investigate large multi-dimensional datasets visually (using 2D visualization techniques) using so called drill-down, roll-up and slicing operations. The project included all steps of the development, from writing specifications and designing the program to implementing and evaluating it.

Using ideas from data warehousing, custom methods for storing pre-computed aggregations of data (commonly referred to as materialized views) and retrieving data from these were developed and implemented in order to achieve higher performance on large datasets. View materialization enables the program to easily fetch or calculate a view using other views, something which can yield significant performance gains if view sizes are much smaller than the underlying raw dataset. The choice of which views to materialize was done in an automated manner using a well-known algorithm - the greedy algorithm for view materialization - which selects the fraction of all possible views that is likely (but not guaranteed) to yield the best performance gain. The use of materialized views was shown to have good potential to increase performance for large datasets, with an average speedup (compared to on-the-fly queries) between 20 and 70 for a test dataset containing 500~000 rows.

The end result was a program combining flexibility with good performance, which was also reflected by good scores in a user-acceptance test, with participants from the company where this project was carried out.

Place, publisher, year, edition, pages
2012. , 49 p.
UPTEC F, ISSN 1401-5757 ; 12023
Keyword [en]
visual data mining, visualization, data warehousing, software engineering, materialized views, OLAP, OLAP cubes, greedy algorithm, high-performance query
National Category
Engineering and Technology
URN: urn:nbn:se:uu:diva-181225OAI: diva2:555392
Educational program
Master Programme in Engineering Physics
Available from: 2012-10-03 Created: 2012-09-19 Last updated: 2012-10-03Bibliographically approved

Open Access in DiVA

Master thesis - Interactive Visualization of Financial Data(911 kB)458 downloads
File information
File name FULLTEXT01.pdfFile size 911 kBChecksum SHA-512
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Saltin, Joakim
By organisation
Department of Information Technology
Engineering and Technology

Search outside of DiVA

GoogleGoogle Scholar
Total: 460 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

Total: 313 hits
ReferencesLink to record
Permanent link

Direct link