O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required