Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL / [electronic resource] :

• 作者： Celko, Joe.
• 其他作者：
  • ScienceDirect (Online service)
• 其他題名：
  • Thinking in sets
  • Thinking in sets
• 出版： Amsterdam ;Boston : Elsevier / Morgan Kaufmann
• 叢書名： The Morgan Kaufmann series in data management systems
• 主題： SQL (Computer program language) , Declarative programming. , Electronic books.
• ISBN： 9780123741370 (paper) 、 0123741378 (paper)
• FIND@SFXID: CGU
• 資料類型: 電子書
• 內容註: Table of Contents -- Preface xvii -- 1 SQL Is Declarative, Not Procedural -- 1.1 Different Programming Models -- 1.2 Different Data Models -- 1.2.1 Columns Are Not Fields -- 1.2.2 Rows Are Not Records -- 1.2.3 Tables Are Not Files -- 1.2.4 Relational Keys Are Not Record Locators -- 1.2.5 Kinds of Keys -- 1.2.6 Desirable Properties of Relational Keys -- 1.2.7 Unique But Not Invariant -- 1.3 Tables as Entities -- 1.4 Tables as Relationships -- 1.5 Statements Are Not Procedures -- 1.6 Molecular, Atomic, and Subatomic Data Elements -- 1.6.1 Table Splitting -- 1.6.2 Column Splitting -- 1.6.3 Temporal Splitting -- 1.6.4 Faking Non-1NF Data -- 1.6.5 Molecular Data Elements -- 1.6.6 Isomer Data Elements -- 1.6.7 Validating a Molecule -- 2 Hardware, Data Volume, and Maintaining Databases -- 2.1 Parallelism -- 2.2 Cheap Main Storage -- 2.3 Solid-State Disk -- 2.4 Cheaper Secondary and Tertiary Storage -- 2.5 The Data Changed -- 2.6 The Mindset Has Not Changed -- 3 Data Access and Records -- 3.1 Sequential Access -- 3.1.1 Tape-Searching Algorithms -- 3.2 Indexes -- 3.2.1 Single-Table Indexes -- 3.2.2 Multiple-Table Indexes -- 3.2.3 Type of Indexes -- 3.3 Hashing -- 3.3.1 Digit Selection -- 3.3.2 Division Hashing -- 3.3.3 Multiplication Hashing -- 3.3.4 Folding -- 3.3.5 Table Lookups -- 3.3.6 Collisions -- 3.4 Bit Vector Indexes -- 3.5 Parallel Access -- 3.6 Row and Column Storage -- 3.6.1 Row-Based Storage -- 3.6.2 Column-Based Storage -- 3.7 JOIN Algorithms -- 3.7.1 Nested-Loop Join Algorithm -- 3.7.2 Sort-Merge Join Method -- 3.7.3 Hash Join Method -- 3.7.4 Shins Algorithm -- 4 Lookup Tables -- 4.1 Data Element Names -- 4.2 Multiparameter Lookup Tables -- 4.3 Constants Table -- 4.4 OTLT or MUCK Table Problems -- 4.5 Defi nition of a Proper Table -- -- 5 Auxiliary Tables -- 5.1 Sequence Table -- 5.1.1 Creating a Sequence Table -- 5.1.2 Sequence Constructor -- 5.1.3 Replacing an Iterative Loop -- 5.2 Permutations -- 5.2.1 Permutations via Recursion -- 5.2.2 Permutations via SQL is declarative, not procedural -- Auxiliary tables -- Temporal tables -- Virtual tables -- Auxiliary tables -- Views -- Virtual tables -- Complicated functions via tables -- Temporal tables -- Scrubbing data with non-1nf tables -- Thinking in SQL -- Group characteristics -- Turning specifications into code -- Using procedure and function calls -- Numbering rows -- Keeping computed data -- Triggers for constraints -- Procedural and data-driven solutions. Includes index.
• More
• 摘要註: Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity. This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, youll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, youll be coding more quickly, writing more efficient code, and applying the full power of SQL Filled with the insights of one of the worlds leading SQL authorities - noted for his knowledge and his ability to teach what he knows. Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance). Presents clear guidance for selecting and correctly applying the right table technique.
• 讀者標籤：

  需登入
• 引用連結：

  Copy Link
• 目前引用數
• Share: