Joe Celko's Data, Measurements and Standards in SQL

個数：
電子版価格
¥7,344
  • 電子版あり

Joe Celko's Data, Measurements and Standards in SQL

  • 提携先の海外書籍取次会社に在庫がございます。通常3週間で発送いたします。
    【重要ご説明事項】
    1. 納期遅延や、ご入手不能となる場合が若干ございます。
    2. 複数冊ご注文の場合は、ご注文数量が揃ってからまとめて発送いたします。
    3. 美品のご指定は承りかねます。

    ●3Dセキュア導入とクレジットカードによるお支払いについて
  • 【入荷遅延について】
    世界情勢の影響により、海外からお取り寄せとなる洋書・洋古書の入荷が、表示している標準的な納期よりも遅延する場合がございます。
    おそれいりますが、あらかじめご了承くださいますようお願い申し上げます。
  • ◆画像の表紙や帯等は実物とは異なる場合があります。
  • ◆ウェブストアでの洋書販売価格は、弊社店舗等での販売価格とは異なります。
    また、洋書販売価格は、ご注文確定時点での日本円価格となります。
    ご注文確定後に、同じ洋書の販売価格が変動しても、それは反映されません。
  • 製本 Paperback:紙装版/ペーパーバック版／ページ数 309 p.
  • 言語 ENG
  • 商品コード 9780123747228
  • DDC分類 005.7585

Full Description

Joe Celko has looked deep into the code of SQL programmers and found a consistent and troubling pattern - a frightening lack of consistency between their individual encoding schemes and those of the industries in which they operate. This translates into a series of incompatible databases, each one an island unto itself that is unable to share information with others in an age of internationalization and business interdependence. Such incompatibility severely hinders information flow and the quality of company data.

Data, Measurements and Standards in SQL reveals the shift these programmers need to make to overcome this deadlock. By collecting and detailing the diverse standards of myriad industries, and then giving a declaration for the units that can be used in an SQL schema, Celko enables readers to write and implement portable data that can interface to any number of external application systems!

This book doesn't limit itself to one subject, but serves as a detailed synopsis of measurement scales and data standards for all industries, thereby giving RDBMS programmers and designers the knowledge and know-how they need to communicate effectively across business boundaries.

Contents

0.0. Introduction 1.0. Scales and Measurement Theory 2.0. Data Encoding Schemes 2.1. Classification 2.2. Check Digits 3.0. Physical Measurements3.1. Brief History of Measurement Standards 3.2. Rise of ISO and Other Organizations3.3. ISO-2955 Standard 3.3.1. Basic Units3.3.2. Compound Units3.4. Color Systems4.0. Temporal Measurements 4.1. The Calendar4.1.1. A History of the Common Era Calendar 4.1.2. ISO-8601 Standard 4.1.3. Implementations in SQL 4.2. The Clock4.2.1. Leap Seconds, UTC and Atomic Clocks4.2.2. Time Zones in SQL 5.0. Industry Standards For Products5.1. UPC and EAN Bar Codes5.2. Standard Packaging Units5.2.1. U.S. Systems5.2.2. European Union and Other European Systems 5.2.3. Asian and Other Systems5.3. Bank Standards5.3.1. Account Numbers5.3.2. Checking 5.3.2.1. U.S. Banking System5.3.2.2. IBAN and Other International Standards 6.0. Postal Address Encoding6.1. Formatting Names6.2. ZIP Codes in the United States 6.3. Various Foreign Systems 6.4. Systems Used by UPS and other Delivery Services7.0. Currency 7.1. GAAP Rules in the United States 7.2. Rules for Euro Conversions 8.0. Internet 8.1. Email Addresses8.2. IP Addresses 9.0. Business Codes9.1. The Rise and Fall of EDI and ANSI X129.2. XML Standards in Various Industries 9.3. Company Identifiers 9.3.1. DUNS 9.3.2. Stock Ticker Symbols9.4. Chart of Accounts10.0. Medical Systems10.1. ICD Codes 10.2. HIPAA Codes10.3. Drug Codes11.0. General Classification Systems11.1. Alphabetic Order11.1.1. History11.1.2. Problems with Foreign Alphabets11.2. Dewey Decimal Classification 11.3. Library of Congress