Data Types in the Medical Record

  • Prakash M. Nadkarni
Part of the Health Informatics book series (HI)


This chapter partly recapitulates databases/statistics 101. The principles laid here are essential to appreciating the design decisions that are made for electronic medical records. It may be elementary to those with a database-design or statistics background, who may wish to skim rapidly or skip ahead to the very last section of this chapter, where I recommend and describe a specific approach for representing enumerated data types.


Data Type Short Text Decimal Number Unstructured Data Original Message 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    Stevens SS. On the theory of scales of measurement. Science. 1946;103(2684):677-680.CrossRefGoogle Scholar
  2. 2.
    Michell J. Measurement: a beginner’s guide. J Appl Meas. 2003;4(4):298-308.PubMedGoogle Scholar
  3. 3.
    Goldberg D. What every computer scientist should know about floating-point arithmetic computing surveys. ACM Comput Surv. 1991;23(1):1-44.CrossRefGoogle Scholar
  4. 4.
    Clarke D. The trouble with rounding floating point numbers. The Register. London; 2006.Google Scholar
  5. 5.
    Ben-Gan I, Sarka D, Wolter R. Inside SQL Server 2005: T-SQL Programming. Redmond: Microsoft; 2005.Google Scholar
  6. 6.
    Melton J, Simon AR, Gray J. SQL 1999: Understanding Relational Language Components. San Mateo: Morgan Kaufman; 2001.Google Scholar
  7. 7.
    Davidson L. Ten common database design mistakes. 2007 [cited 1/5/09]; Available from:

Copyright information

© Springer-Verlag London Limited 2011

Authors and Affiliations

  • Prakash M. Nadkarni
    • 1
  1. 1.School of MedicineYale UniversityNew HavenUSA

Personalised recommendations