Joe Celko's Data, Measurements and Standards in SQL

Joe Celko has been deeply aware of the code of SQL programmers and found a consistent and troubling pattern. This translates into a series of internationalization and business interdependence. Such incompatibility severely hinders information flow and the quality of company data.

Data, Measurements and Standards in SQL. I was able to use a SQL statement, which can be used in any other way.

This book does not limit itself. It is also a detailed synopsis of measurement scales.

* One-stop-shopping opportunity for database programmers.

* Enables readers to write and implement a portable ladder.

* Expert advice from the author of the ANSI SQL standards and readership award winning column in Intelligent Enterprise.


0.0. Introduction
1.0. Scales and Measurement Theory
2.0. Data Encoding Schemes
2.1. classification
2.2. Check Digits
3.0. Physical Measurements
3.1. Brief History of Measurement Standards
3.2. Rise of ISO and Other Organizations
3.3. ISO-2955 Standard
3.3.1. Basic Units
3.3.2. Compound Units
3.4. Color Systems
4.0. Temporal Measurements
4.1. The Calendar
4.1.1. A History of the Common Era Calendar
4.1.2. ISO-8601 Standard
4.1.3. Implementations in SQL
4.2. The Clock
4.2.1. Leap Seconds, UTC and Atomic Clocks
4.2.2. Time Zones in SQL
5.0. Industry Standards For Products
5.1. UPC and EAN Bar Codes
5.2. Standard Packaging Units
5.2.1. US Systems
5.2.2. European Union and Other European Systems
5.2.3. Asian and Other Systems
5.3. Bank Standards
5.3.1. Account Numbers
5.3.2. Checking
5.3.2.1. US Banking System
5.3.2.2. IBAN and Other International Standards
6.0. Postal Address Encoding
6.1. Formatting Names
6.2. ZIP Codes in the United States
6.3. Various Foreign Systems
6.4. Systems Used by UPS and other Delivery Services
7.0. currency
7.1. GAAP Rules in the United States
7.2. Rules for Euro Conversions
8.0. Internet
8.1. Email Addresses
8.2. IP Addresses
9.0. Business Codes
9.1. The Rise and Fall of EDI and ANSI X12
9.2. XML Standards in Various Industries
9.3. Company Identifiers
9.3.1. DUNS
9.3.2. Stock Ticker Symbols
9.4. Chart of Accounts
10.0. Medical Systems
10.1. ICD Codes
10.2. HIPAA Codes
10.3. Drug Codes
11.0. General Classification Systems
11.1. Alphabetic Order
11.1.1. History
11.1.2. Problems with Foreign Alphabets
11.2. Dewey Decimal Classification
11.3. Library of Congress