Records and Columns
A record is an associated set of column values. Records are inserted and updated via Update operations and can be deleted via Delete operations. Columns are set and retrieved via SetColumns and RetrieveColumns operations, respectively. The maximum size of a record is 8110 bytes for 8 kilobyte pages with the exception of long value columns. Column types of LongText and LongBinary do not contribute significantly to this size limitation, and records can hold data much larger than a database page size when data is stored in long value columns. When a long value reference is stored in a record, only 9 bytes of in-record data are required. These long values may themselves be up to 2 gigabytes (GB) in size.
Records are typically uniform in that each record has a set of values for the same set of columns. In ESE, it is also possible to define many columns for a table, and yet have any given record contain only a small number of non-NULL column values. In this sense, a table can also be a collection of heterogeneous records.
ESE supports a wide range of columns values, ranging in size from 1-bit to 2 GB. Choosing the correct column type is important because the type of a column determines many of its properties, including its ordering for indexes. The following data types are supported by ESE:
Read more about this topic: Extensible Storage Engine
Famous quotes containing the words records and/or columns:
“It’s always the generals with the bloodiest records who are the first to shout what a hell it is. And it’s always the war widows who lead the Memorial Day parades.”
—Paddy Chayefsky (1923–1981)
“When I heard the learn’d astronomer,
When the proofs, the figures, were ranged in columns before me,”
—Walt Whitman (1819–1892)