Alan Freedman -- The Computer Language Company - Computer Desktop Encyclopedia
Computer Desktop Encyclopedia
Longest-Running Tech Reference on the Planet

A CDE Definition

You'll love The Computer Desktop Encyclopedia (CDE) for Tech Term of the Day (TTOD)

LOOK UP ANOTHER TERM


variable length field

A record structure that holds fields of varying lengths. For example, PAT LOPEZ would take nine bytes and GEORGINA ALLISON BARTHOLOMEW would take 28 plus a couple of bytes that define the length of the field. If fixed length fields were used, at least 28 bytes would have to be reserved for both names.

Variable Length Text Fields
Years ago, storage was costly, and variable field lengths were essential. Today, storage is dirt cheap by comparison. However, if there are text elements in a database that vary greatly, variable length fields save a lot of space. In addition, databases in many companies have reached mammoth proportions, and storage savings are welcome.

More Processing
Variable lengths require more processing, because every field has to be encoded into the variable format before being written to storage. Conversely, after being read back into memory, the variable fields may have to be converted to a fixed length for processing.

The Compression Alternative
The same storage savings is often achieved by using fixed length fields and compressing the data in storage. With text, all contiguous blank bytes are filtered out. See real-time compression.




Size Matters
It can be difficult to figure out the size of a fixed length field. In the 1980s, this last name in the Manhattan White Pages had, count 'em, 25 letters.






real-time compression

The ability to compress data before it is written to the hard disk without any noticeable loss in speed compared to non-compressed data. Modern operating systems provide a real-time compression capability for a portion or all of the hard disk, and earlier products such as Stacker and SuperStor were third-party software that added this capability.

Images May Also Be Compressed
GIF images are compressed when they are saved, without any loss of data. JPEG images are also compressed, but eliminate pixels in the process (see lossy compression).



Personal Use Only

Before/After Your Search Term
BeforeAfter
VANETvariable length record
vanity searchingvariable playback
VAPvariable refresh rate
vapevariable resistor
vapingvariable speed playback
vaporwarevarname
VARvault app
variablevaulting
variable data printingVAX
variable declarationVAXcluster

Terms By Topic
Click any of the following categories for a list of fundamental terms.
Computer Words You Gotta KnowSystem design
Job categoriesUnix/Linux
Interesting stuffPersonal computers
InternetIndustrial Automation/Process Control
Communications & networkingAssociations/Standards organizations
HistoryDesktop publishing
Audio/VideoGraphics
MainframesSecurity
ProgrammingHealthcare IT
System design