From Analysis to Interactive Exploration : Building Visual Hierarchies from OLAP Cubes

Mansmann, Svetlana; Mansmann, Florian

From Analysis to Interactive Exploration : Building Visual Hierarchies from OLAP Cubes

Dateien

From_Analysis_to_Interactive_Exploration.pdfGröße: 1.73 MBDownloads: 487

Datum

2006

Open Access-Veröffentlichung

Open Access Green

Sammlungen

Informatik und Informationswissenschaft

Publikationstyp

Beitrag zu einem Konferenzband

Publikationsstatus

Published

Erschienen in

IOANNIDIS, Yannis, ed. and others. Advances in Database Technology - EDBT 2006 : 10th International Conference on Extending Database Technology, Munich, Germany, March 26-31, 2006. Berlin: Springer, 2006, pp. 496-514. Lecture Notes in Computer Science. 3896. ISBN 978-3-540-32960-2

Zusammenfassung

We present a novel framework for comprehensive exploration of OLAP data by means of user-defined dynamic hierarchical visualizations. The multidimensional data model behind the OLAP architecture is particularly suitable for sophisticated analysis of large data volumes. However, the ultimate benefit of applying OLAP technology depends on the "intelligence" and usability of visual tools available to end-users. The explorative framework of our proposed interface consists of the navigation structure, a selection of hierarchical visualization techniques, and a set of interaction features. The navigation interface allows users to pursue arbitrary disaggregation paths within single data cubes and, more importantly, across multiple cubes. In the course of interaction, the navigation view adapts itself to display the chosen path and the options valid in the current context. Special effort has been invested in handling non-trivial relationships (e.g., mixed granularity) within hierarchical dimensions in a way transparent to the user. We propose a visual structure called Enhanced Decomposition Tree to use along with popular "state-of-the-art" hierarchical visualization techniques. Each level of the tree is produced by a disaggregation step, whereas the nodes display the specified subset of measures, either as plain numbers or as an embedded chart. The proposed technique enables a stepwise descent towards the desired level of detail while preserving the history of the interaction. Aesthetic hierarchical layout of the node-link tree ensures clear structural separation between the analyzed values embedded in the nodes and their dimensional characteristics which label the links. Our framework provides an intuitive and powerful interface for exploring complex multidimensional data sets.

Fachgebiet (DDC)

004 Informatik

Zitieren

ISO 690

MANSMANN, Svetlana, Florian MANSMANN, 2006. From Analysis to Interactive Exploration : Building Visual Hierarchies from OLAP Cubes. In: IOANNIDIS, Yannis, ed. and others. Advances in Database Technology - EDBT 2006 : 10th International Conference on Extending Database Technology, Munich, Germany, March 26-31, 2006. Berlin: Springer, 2006, pp. 496-514. Lecture Notes in Computer Science. 3896. ISBN 978-3-540-32960-2

BibTex

@inproceedings{Mansmann2006Analy-5415,
  year={2006},
  title={From Analysis to Interactive Exploration : Building Visual Hierarchies from OLAP Cubes},
  number={3896},
  isbn={978-3-540-32960-2},
  publisher={Springer},
  address={Berlin},
  series={Lecture Notes in Computer Science},
  booktitle={Advances in Database Technology - EDBT 2006 : 10th International Conference on Extending Database Technology, Munich, Germany, March 26-31, 2006},
  pages={496--514},
  editor={Ioannidis, Yannis},
  author={Mansmann, Svetlana and Mansmann, Florian}
}

RDF

<rdf:RDF
    xmlns:dcterms="http://purl.org/dc/terms/"
    xmlns:dc="http://purl.org/dc/elements/1.1/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:bibo="http://purl.org/ontology/bibo/"
    xmlns:dspace="http://digital-repositories.org/ontologies/dspace/0.1.0#"
    xmlns:foaf="http://xmlns.com/foaf/0.1/"
    xmlns:void="http://rdfs.org/ns/void#"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema#" > 
  <rdf:Description rdf:about="https://kops.uni-konstanz.de/server/rdf/resource/123456789/5415">
    <dc:contributor>Mansmann, Svetlana</dc:contributor>
    <foaf:homepage rdf:resource="http://localhost:8080/"/>
    <dcterms:title>From Analysis to Interactive Exploration : Building Visual Hierarchies from OLAP Cubes</dcterms:title>
    <dc:creator>Mansmann, Svetlana</dc:creator>
    <dcterms:isPartOf rdf:resource="https://kops.uni-konstanz.de/server/rdf/resource/123456789/36"/>
    <dc:rights>Attribution-NonCommercial-NoDerivs 2.0 Generic</dc:rights>
    <dspace:hasBitstream rdf:resource="https://kops.uni-konstanz.de/bitstream/123456789/5415/1/From_Analysis_to_Interactive_Exploration.pdf"/>
    <void:sparqlEndpoint rdf:resource="http://localhost/fuseki/dspace/sparql"/>
    <dcterms:abstract xml:lang="eng">We present a novel framework for comprehensive exploration of OLAP data by means of user-defined dynamic hierarchical visualizations. The multidimensional data model behind the OLAP architecture is particularly suitable for sophisticated analysis of large data volumes. However, the ultimate benefit of applying OLAP technology depends on the "intelligence" and usability of visual tools available to end-users. The explorative framework of our proposed interface consists of the navigation structure, a selection of hierarchical visualization techniques, and a set of interaction features. The navigation interface allows users to pursue arbitrary disaggregation paths within single data cubes and, more importantly, across multiple cubes. In the course of interaction, the navigation view adapts itself to display the chosen path and the options valid in the current context. Special effort has been invested in handling non-trivial relationships (e.g., mixed granularity) within hierarchical dimensions in a way transparent to the user. We propose a visual structure called Enhanced Decomposition Tree to use along with popular "state-of-the-art" hierarchical visualization techniques. Each level of the tree is produced by a disaggregation step, whereas the nodes display the specified subset of measures, either as plain numbers or as an embedded chart. The proposed technique enables a stepwise descent towards the desired level of detail while preserving the history of the interaction. Aesthetic hierarchical layout of the node-link tree ensures clear structural separation between the analyzed values embedded in the nodes and their dimensional characteristics which label the links. Our framework provides an intuitive and powerful interface for exploring complex multidimensional data sets.</dcterms:abstract>
    <dcterms:rights rdf:resource="http://creativecommons.org/licenses/by-nc-nd/2.0/"/>
    <dc:creator>Mansmann, Florian</dc:creator>
    <dc:language>eng</dc:language>
    <dcterms:bibliographicCitation>First publ. in: Advances in database technology - EDBT 2006: 10th International Conference on Extending Database Technology, Munich, Germany, March 26 - 31, 2006 / Yannis Ioannidis ... (eds.). Berlin: Springer, 2006, pp. 496-514</dcterms:bibliographicCitation>
    <dc:contributor>Mansmann, Florian</dc:contributor>
    <dspace:isPartOfCollection rdf:resource="https://kops.uni-konstanz.de/server/rdf/resource/123456789/36"/>
    <dcterms:available rdf:datatype="http://www.w3.org/2001/XMLSchema#dateTime">2011-03-24T15:55:10Z</dcterms:available>
    <dcterms:hasPart rdf:resource="https://kops.uni-konstanz.de/bitstream/123456789/5415/1/From_Analysis_to_Interactive_Exploration.pdf"/>
    <dc:format>application/pdf</dc:format>
    <dc:date rdf:datatype="http://www.w3.org/2001/XMLSchema#dateTime">2011-03-24T15:55:10Z</dc:date>
    <dcterms:issued>2006</dcterms:issued>
    <bibo:uri rdf:resource="http://kops.uni-konstanz.de/handle/123456789/5415"/>
  </rdf:Description>
</rdf:RDF>

Universitätsbibliographie

Ja