• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Misusing Excel as a Database ... > Using Labels Instead of Codes

Using Labels Instead of Codes

Traditionally, true databases have used numeric codes instead of text labels for fields that can take on only a fairly restricted set of values. For example, the label “Ford” might be represented by the number 1, “Chrysler” by the number 2, and “Toyota” by the number 3.

This approach had a special advantage when the availability of storage media was at a premium. If you have 1,000 records, you can store 1,000 byte values (1, 2, or 3, for example) in 1000 bytes. But if you store the car make in a text field, the value “Chrysler” forces that field to be at least seven characters—8 bytes, or 8000 bytes for 1,000 records. Years ago, that was a significant amount of space.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint