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

详细信息    查看全文

• 作者：Martin Dugas (1)
  Gottfried Vossen (2)
  
• 关键词：Entity ; relationship model ; Database contents ; Database visualization ; Data completeness
• 刊名：Datenbank-Spektrum
• 出版年：2012
• 出版时间：November 2012
• 年：2012
• 卷：12
• 期：3
• 页码：215-218
• 参考文献：1. Chen P (1976) The entity-relationship model鈥攖oward a unified view of data. ACM Trans Database Syst 1(1):9鈥?6 CrossRef
  2. Elmasri RA, Navathe SB (2010) Fundamentals of database systems, 6th edn. Pearson Addison-Wesley, Boston
  3. Silberschatz A, Korth HF, Sudarshan S (2010) Database system concepts, 6th edn. McGraw-Hill, New York
  4. Batini C, Ceri S, Navathe SB (1992) Conceptual database design鈥攁n entity-relationship-approach. Benjamin/Cummings, Redwood City
  5. Markowitz VM, Shoshani A (1992) Representing extended Entity-Relationship structures in relational databases: a modular approach. ACM Trans Database Syst 17(3):423鈥?64 CrossRef
  6. Fahrner C, Vossen G (1995) A survey of database design transformations based on the entity-relationship model. Data Knowl Eng 15(3):213鈥?50 CrossRef
  7. Naumann F, Freytag JCh, Leser U (2004) Completeness of information sources. Inf Syst 29(7):583鈥?15 CrossRef
  8. Altman DG (1991) Practical statistics for medical research. Chapman & Hall, London
  9. Keim D, Kohlhammer J, Ellis G, Mansmann F (2010) Mastering the information age鈥攕olving problems with visual analytics. The Eurographics Association, Goslar
  10. Wilkinson L, Friendly M (2009) The history of the cluster heat map. Am Stat 63(2):179鈥?84 CrossRef
  11. R Development Core Team (2009) R鈥攁聽language and environment for statistical computing. R Foundation for Statistical Computing, Vienna
  12. Heart disease data set. UCI machine learning repository. http://archive.ics.uci.edu/ml/datasets/Heart+Disease. Accessed May 2, 2012
  13. Flicek P, Ridwan Amode M, Barrell D et al. (2012) Ensembl 2012. Nucleic Acids Res 40:D84鈥揇90 CrossRef
  14. 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鈥?4 CrossRef
  15. Tableau Software Inc. http://www.tableausoftware.com/. Accessed May 4, 2012
  16. infovis Wiki: information visualizaton. http://www.infovis-wiki.net/index.php?title=Information_Visualization. Accessed May 4, 2012
  17. 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鈥?50 CrossRef
  
• 作者单位：Martin Dugas (1)
  Gottfried Vossen (2)
  
  1. Institute of Medical Informatics, University of M眉nster, Albert-Schweitzer-Campus 1, Geb盲ude A11, 48149, M眉nster, Germany
  2. Department of Information Systems, University of M眉nster, Leonardo-Campus 3, 48149, M眉nster, Germany
  
• ISSN：1610-1995

文摘

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/.