Data Types in the Medical Record
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.
KeywordsData Type Short Text Decimal Number Unstructured Data Original Message
- 4.Clarke D. The trouble with rounding floating point numbers. The Register. London; 2006.Google Scholar
- 5.Ben-Gan I, Sarka D, Wolter R. Inside SQL Server 2005: T-SQL Programming. Redmond: Microsoft; 2005.Google Scholar
- 6.Melton J, Simon AR, Gray J. SQL 1999: Understanding Relational Language Components. San Mateo: Morgan Kaufman; 2001.Google Scholar
- 7.Davidson L. Ten common database design mistakes. 2007 [cited 1/5/09]; Available from:http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/.