NAVIGATION ALONG DATABASE RELATIONSHIPS - An Adaptive Framework for Presenting Database Contents as Object Graphs

Ahmet Atli, Katja Nau, Andreas Schmidt

2011

Abstract

In this paper, we will present an approach to visualizing arbitrary relational database contents in the form of object graphs via the World Wide Web. The focus is on the relationships between the datasets rather than on the data itself. The tool allows definition of different node types representing the datasets and edges representing the foreign keys and relationship tables in the database schema. Each node type has a label, and optionally a short description and a user definable image associated with it. The information for these fields can be extracted 1 : 1 from the corresponding database tables or otherwise be aggregated from different tables. Along the edges, it is possible to navigate through the content of the database. At any time, exactly one node represents the center of the object graph. Starting from this graph, edges and other nodes down to a user-definable depth n are visualized. The depth n may vary along different node and edge types, so that it is possible to customize the representation of the object graph. The graphical representation of arbitrary database contents has been of great help to us. In addition to using it in the initial application area, we intend to use it in some other areas we had left unconsidered. From these, we can infer a number of suggestions as to how to improve our tool and make it more universal.

References

  1. Adobe Creative Team (2008). Adobe Flash CS4 Professional Classroom in a Book. Adobe Press.
  2. Adobe Creative Team (2008). Adobe Flash CS4 Professional Classroom in a Book. Adobe Press.
  3. Bauer, C. and King, G. (2006). Java Persistence with Hibernate. Manning Publications Co., Greenwich, CT, USA.
  4. Bauer, C. and King, G. (2006). Java Persistence with Hibernate. Manning Publications Co., Greenwich, CT, USA.
  5. Bibeault, B. and Katz, Y. (2008). jQuery in Action. Manning Publications.
  6. Bibeault, B. and Katz, Y. (2008). jQuery in Action. Manning Publications.
  7. Crane, D., Pascarello, E., and James, D. (2005). Ajax in Action. Manning Publications.
  8. Crane, D., Pascarello, E., and James, D. (2005). Ajax in Action. Manning Publications.
  9. DaNa (2010). DaNa - KnowledgeBase Nanomaterials. http://www.nanopartikel.info.
  10. DaNa (2010). DaNa - KnowledgeBase Nanomaterials. http://www.nanopartikel.info.
  11. Fruchtermann, T. and Reingold, E. (1991). Graph drawing by force-directed placement. Software: Practice and Experience, 21:1129-1164.
  12. Fruchtermann, T. and Reingold, E. (1991). Graph drawing by force-directed placement. Software: Practice and Experience, 21:1129-1164.
  13. Fry, B. (2007). Visualizing Data. O'Reilly Media, Sebastopol.
  14. Fry, B. (2007). Visualizing Data. O'Reilly Media, Sebastopol.
  15. GVS (2010). Graphviz - Graph Visualization Software. http://www.graphviz.org/.
  16. GVS (2010). Graphviz - Graph Visualization Software. http://www.graphviz.org/.
  17. May, W. (1999). Information extraction and integration with FLORID: The MONDIAL case study. Technical Report 131, Universität Freiburg, Institut für Informatik. Available from http://dbis.informatik.unigoettingen.de/Mondial.
  18. May, W. (1999). Information extraction and integration with FLORID: The MONDIAL case study. Technical Report 131, Universität Freiburg, Institut für Informatik. Available from http://dbis.informatik.unigoettingen.de/Mondial.
  19. ProtoVis (2010). Protovis - A graphical toolkit for visualization. http://vis.stanford.edu/protovis.
  20. ProtoVis (2010). Protovis - A graphical toolkit for visualization. http://vis.stanford.edu/protovis.
  21. Sencha (2010). Sencha http://www.sencha.com.
  22. Sencha (2010). Sencha http://www.sencha.com.
  23. Steele, J. and Iliinsky, N. (2010). Beautiful Visualization: Looking at Data through the Eyes of Experts. O'Reilly Media, Sebastopol.
  24. Steele, J. and Iliinsky, N. (2010). Beautiful Visualization: Looking at Data through the Eyes of Experts. O'Reilly Media, Sebastopol.
  25. Willis, C. L. and Miertschin, S. L. (2006). Mind maps as active learning tools. J. Comput. Small Coll., 21:266- 272.
  26. Willis, C. L. and Miertschin, S. L. (2006). Mind maps as active learning tools. J. Comput. Small Coll., 21:266- 272.
Download


Paper Citation


in Harvard Style

Atli A., Nau K. and Schmidt A. (2011). NAVIGATION ALONG DATABASE RELATIONSHIPS - An Adaptive Framework for Presenting Database Contents as Object Graphs . In Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST, ISBN 978-989-8425-51-5, pages 372-379. DOI: 10.5220/0003402703720379


in Harvard Style

Atli A., Nau K. and Schmidt A. (2011). NAVIGATION ALONG DATABASE RELATIONSHIPS - An Adaptive Framework for Presenting Database Contents as Object Graphs . In Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST, ISBN 978-989-8425-51-5, pages 372-379. DOI: 10.5220/0003402703720379


in Bibtex Style

@conference{webist11,
author={Ahmet Atli and Katja Nau and Andreas Schmidt},
title={NAVIGATION ALONG DATABASE RELATIONSHIPS - An Adaptive Framework for Presenting Database Contents as Object Graphs},
booktitle={Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,},
year={2011},
pages={372-379},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003402703720379},
isbn={978-989-8425-51-5},
}


in Bibtex Style

@conference{webist11,
author={Ahmet Atli and Katja Nau and Andreas Schmidt},
title={NAVIGATION ALONG DATABASE RELATIONSHIPS - An Adaptive Framework for Presenting Database Contents as Object Graphs},
booktitle={Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,},
year={2011},
pages={372-379},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003402703720379},
isbn={978-989-8425-51-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,
TI - NAVIGATION ALONG DATABASE RELATIONSHIPS - An Adaptive Framework for Presenting Database Contents as Object Graphs
SN - 978-989-8425-51-5
AU - Atli A.
AU - Nau K.
AU - Schmidt A.
PY - 2011
SP - 372
EP - 379
DO - 10.5220/0003402703720379


in EndNote Style

TY - CONF
JO - Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,
TI - NAVIGATION ALONG DATABASE RELATIONSHIPS - An Adaptive Framework for Presenting Database Contents as Object Graphs
SN - 978-989-8425-51-5
AU - Atli A.
AU - Nau K.
AU - Schmidt A.
PY - 2011
SP - 372
EP - 379
DO - 10.5220/0003402703720379