O'Reilly logo

Joe Celko's Data, Measurements and Standards in SQL 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 4. Scales
“Where is the wisdom? Lost in the knowledge.
Where is the knowledge? Lost in the information.”
—T. S. Eliot
“Where is the information? Lost in the data.
Where is the data? Lost in the #@$%?!& database.”
—Joe Celko
There are different types of scales. And not all data can be measured with a scale. We like to think in terms of “something physical” that can be detected with a device, like mass, length, or electrical current, so that we can look for a known scale. But life is not that easy.
In the commercial world, some of the most important data is stored as text. Contracts, laws, regulations, manuals, and so forth are vital for any enterprise. There are some de jure and de facto search standards for text, but we are dealing with semantics ...

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