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 


  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