Skip to main content
Top
Published in: Datenbank-Spektrum 3/2012

01-11-2012 | Fachbeitrag

CityPlot: Colored ER Diagrams to Visualize Structure and Contents of Databases

Authors: Martin Dugas, Gottfried Vossen

Published in: Datenbank-Spektrum | Issue 3/2012

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

CityPlot generates an extended version of a traditional entity-relationship diagram for a database. It is intended to provide a combined view of database structure and contents. The graphical output resembles the metaphor of a city. Data points are visualized according to data type and completeness. An open source reference implementation is available from http://​cran.​r-project.​org/​.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Show more products
Literature
1.
go back to reference Chen P (1976) The entity-relationship model—toward a unified view of data. ACM Trans Database Syst 1(1):9–36 CrossRef Chen P (1976) The entity-relationship model—toward a unified view of data. ACM Trans Database Syst 1(1):9–36 CrossRef
2.
go back to reference Elmasri RA, Navathe SB (2010) Fundamentals of database systems, 6th edn. Pearson Addison-Wesley, Boston Elmasri RA, Navathe SB (2010) Fundamentals of database systems, 6th edn. Pearson Addison-Wesley, Boston
3.
go back to reference Silberschatz A, Korth HF, Sudarshan S (2010) Database system concepts, 6th edn. McGraw-Hill, New York Silberschatz A, Korth HF, Sudarshan S (2010) Database system concepts, 6th edn. McGraw-Hill, New York
4.
go back to reference Batini C, Ceri S, Navathe SB (1992) Conceptual database design—an entity-relationship-approach. Benjamin/Cummings, Redwood City MATH Batini C, Ceri S, Navathe SB (1992) Conceptual database design—an entity-relationship-approach. Benjamin/Cummings, Redwood City MATH
5.
go back to reference Markowitz VM, Shoshani A (1992) Representing extended Entity-Relationship structures in relational databases: a modular approach. ACM Trans Database Syst 17(3):423–464 CrossRef Markowitz VM, Shoshani A (1992) Representing extended Entity-Relationship structures in relational databases: a modular approach. ACM Trans Database Syst 17(3):423–464 CrossRef
6.
go back to reference Fahrner C, Vossen G (1995) A survey of database design transformations based on the entity-relationship model. Data Knowl Eng 15(3):213–250 MATHCrossRef Fahrner C, Vossen G (1995) A survey of database design transformations based on the entity-relationship model. Data Knowl Eng 15(3):213–250 MATHCrossRef
7.
go back to reference Naumann F, Freytag JCh, Leser U (2004) Completeness of information sources. Inf Syst 29(7):583–615 CrossRef Naumann F, Freytag JCh, Leser U (2004) Completeness of information sources. Inf Syst 29(7):583–615 CrossRef
8.
go back to reference Altman DG (1991) Practical statistics for medical research. Chapman & Hall, London Altman DG (1991) Practical statistics for medical research. Chapman & Hall, London
9.
go back to reference Keim D, Kohlhammer J, Ellis G, Mansmann F (2010) Mastering the information age—solving problems with visual analytics. The Eurographics Association, Goslar Keim D, Kohlhammer J, Ellis G, Mansmann F (2010) Mastering the information age—solving problems with visual analytics. The Eurographics Association, Goslar
11.
go back to reference R Development Core Team (2009) R—a language and environment for statistical computing. R Foundation for Statistical Computing, Vienna R Development Core Team (2009) R—a language and environment for statistical computing. R Foundation for Statistical Computing, Vienna
13.
go back to reference Flicek P, Ridwan Amode M, Barrell D et al. (2012) Ensembl 2012. Nucleic Acids Res 40:D84–D90 CrossRef Flicek P, Ridwan Amode M, Barrell D et al. (2012) Ensembl 2012. Nucleic Acids Res 40:D84–D90 CrossRef
14.
go back to reference Stolte Ch, Tang D, Hanrahan P (2002) Polaris: a system for query, analysis, and visualization of multidimensional relational databases. IEEE Trans Vis Comput Graph 8(1):1–14 CrossRef Stolte Ch, Tang D, Hanrahan P (2002) Polaris: a system for query, analysis, and visualization of multidimensional relational databases. IEEE Trans Vis Comput Graph 8(1):1–14 CrossRef
17.
go back to reference Dugas M, Kuhn K, Kaiser N, Überla K (2001) XML-based visualization of design and completeness in medical databases. Med Inform Internet Med 26(4):237–250 CrossRef Dugas M, Kuhn K, Kaiser N, Überla K (2001) XML-based visualization of design and completeness in medical databases. Med Inform Internet Med 26(4):237–250 CrossRef
Metadata
Title
CityPlot: Colored ER Diagrams to Visualize Structure and Contents of Databases
Authors
Martin Dugas
Gottfried Vossen
Publication date
01-11-2012
Publisher
Springer-Verlag
Published in
Datenbank-Spektrum / Issue 3/2012
Print ISSN: 1618-2162
Electronic ISSN: 1610-1995
DOI
https://doi.org/10.1007/s13222-012-0102-x

Other articles of this Issue 3/2012

Datenbank-Spektrum 3/2012 Go to the issue

Community

News

Premium Partner