Chapter 13

Multiple Column Data Elements

Abstract

The concept of a data element being atomic or scalar is usually taken to mean that it is represented with a single column in a table. This is not always true.

Keywords

Vectors

Coordinates

Atomic

Scalar

Longitude

Latitude

HTM

IPv4 address

IPv6 address

ISO 4217 currency code

Hierarchical data elements

Social security numbers

Rational numbers

Vadim Tropashko

International System of Units

ISO 9407

The concept of a data element being atomic or scalar is usually taken to mean that it is represented with a single column in a table. This is not always true. A data element is atomic when it cannot be decomposed into independent, meaningful parts. Doing so would result in attribute splitting, a very ...

Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.