SQL and Relational Theory: how to write accurate SQL code
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Sebastopol, CA
O'Reilly & Associates
2009
|
| Ausgabe: | 1. Aufl. |
| Schriftenreihe: | Theory in practice
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XIX, 404 S. |
| ISBN: | 9780596523060 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV035658226 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 090803s2009 |||| 00||| eng d | ||
| 015 | |a 08,N45,0012 |2 dnb | ||
| 016 | 7 | |a 990908194 |2 DE-101 | |
| 020 | |a 9780596523060 |c : EUR 38.00 (freier Pr.) |9 978-0-596-52306-0 | ||
| 024 | 3 | |a 9780596523060 | |
| 035 | |a (OCoLC)233931602 | ||
| 035 | |a (DE-599)DNB990908194 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-858 |a DE-11 | ||
| 050 | 0 | |a QA76.73.S67 | |
| 082 | 0 | |a 005.7565 |2 22 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 100 | 1 | |a Date, Chris J. |d 1941- |e Verfasser |0 (DE-588)120054884 |4 aut | |
| 245 | 1 | 0 | |a SQL and Relational Theory |b how to write accurate SQL code |c C. J. Date |
| 250 | |a 1. Aufl. | ||
| 264 | 1 | |a Sebastopol, CA |b O'Reilly & Associates |c 2009 | |
| 300 | |a XIX, 404 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Theory in practice | |
| 650 | 4 | |a Relational databases | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 655 | 7 | |0 (DE-588)4123623-3 |a Lehrbuch |2 gnd-content | |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017712687&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-017712687 | ||
Datensatz im Suchindex
| _version_ | 1804139347227705344 |
|---|---|
| adam_text | Titel: SQL and relational theory
Autor: Date, Chris J.
Jahr: 2009
CONTENTS
PREFACE xiii
1 SETTING THE SCENE 1
The Relational Model Is Much Misunderstood 2
Some Remarks on Terminology 3
Principles, Not Products 1
A Review of the Original Model 5
Model us. Implementation 13
Properties of Relations 17
Base vs. Derived Relations 19
Relations vs. Reluars 21
Values vs. Variables 23
Concluding Remarks 21
Exercises 25
2 TYPES AND DOMAINS 27
Types and Relations 27
Equality Comparisons 28
Data Value Atomicity 31
What s a Type? 37
Scalar vs. Nonscalar Types 10
Scalar Types in SQL 12
Type Checking and Coercion in SQL 13
Collations in SQL 15
Row and Table Types in SQL 17
Concluding Remarks 19
Exercises 50
3 TUPLES AND RELATIONS, ROWS AND TABLES 53
What s a Tuple? 53
Rows in SQL 57
What s a Relation? 60
Relations and Their Bodies 61
Relations Are n-Dimensional 62
Relational Comparisons 63
TABLE_DUM and TABLE_DEE 61
Tables in SQL 65
Column Naming in SQL 66
Concluding Remarks 68
Exercises 69
* NO DUPLICATES, NO NULLS 71
What s Wrong with Duplicates? 71
Duplicates: Further Issues 76
Avoiding Duplicates in SQL 77
What s Wrong with Nulls? 79
Avoiding Nulls in SQL 82
A Remark on Outer Join 84
Concluding Remarks 85
Exercises . 86
5 BASE RELVARS, BASE TABLES 89
Data Definitions 90
Updating Is Set Level 90
Relational Assignment 92
More on Candidate Keys 94
More on Foreign Keys 97
Relvars and Predicates 100
Relations vs. Types 102
Exercises 105
6 SQL AND RELATIONAL ALGEBRA I:
THE ORIGINAL OPERATORS 107
Some Preliminaries 107
More on Closure 110
Restriction 113
Projection 114
Join 115
Union, Intersection, and Difference 118
Which Operators Are Primitive? 120
Formulating Expressions a Step at a Time 121
What Do Relational Expressions Mean? 122
Evaluating SQL Table Expressions 123
Expression Transformation 121
The Reliance on Attribute Names 127
Exercises 129
7 SQL AND RELATIONAL ALGEBRA II:
ADDITIONAL OPERATORS 133
Semijoin and Semidifference 133
Extend 131
Image Relations 136
Divide 139
Aggregate Operators 111
image Relations bis 115
Summarization 116
Summarization bis 151
Group and Ungroup 152
What If Queries 151
What About ORDER BY? 155
Exercises 156
8 SQL AND CONSTRAINTS 161
Type Constraints 162
Type Constraints in SQL 165
Database Constraints 166
Database Constraints in SQL 170
Transactions 171
Why Database Constraint Checking Must Be Immediate 172
But Doesn t Some Checking Haue to Be Deferred? 175
Constraints and Predicates 177
Miscellaneous Issues 179
Exercises 181
9 SQL AND VIEWS 185
Views Are Rehars 186
Views and Predicates 190
Retrieval Operations 190
Views and Constraints 192
Update Operations 195
What Are Views For? 199
Views and Snapshots 200
Exercises 201
10 SQL AND LOGIC 205
Simple and Compound Propositions 206
Simple and Compound Predicates 209
Quantification 211
Relational Calculus 215
More on Quantification 221
Some Equivalences 227
Concluding Remarks 229
Exercises 230
11 USING LOGIC TO FORMULATE SQL EXPRESSIONS 233
Some Transformation Laws 231
Example 1: Logical Implication 236
Example 2: Universal Quantification 236
Example 3: Implication and Universal Quantification 238
Example t: Correlated Subqueries 210
Example 5: Naming Subexpressions 211
Example 6: More on Naming Subexpressions 211
Example 7: Dealing with Ambiguity 215
Example 8: Using COUNT 217
Example 9: Join Queries 218
Example 10: UNIQUE Quantification 2t8
Example 11: ALL or ANY Comparisons 219
Example 12: CROUP BYand HAVING 253
Exercises 251
12 MISCELLANEOUS SQL TOPICS 255
SELECT* 256
Explicit Tables 256
Name Qualification 256
Range Variables 257
Subqueries 259
Possibly Nondeterministic Expressions 262
Empty Sets 263
A BNF Grammar for SQL Table Expressions 261
Exercises 266
A THE RELATIONAL MODEL 269
The Relational Model vs. Others 271
The Relational Model Defined 271
Objectives of the Relational Model 278
Some Database Principles 279
What Remains to Be Done? 280
B DATABASE DESIGN THEORY 285
The Place of Design Theory 286
Functional Dependencies and Boyce/Codd Normal Form 288
Join Dependencies and Fifth Normal Form 294
Two Cheers for Normalization 300
Orthogonality 304
Some Remarks on Physical Design 306
Concluding Remarks 308
Exercises 309
C ANSWERS TO EXERCISES 313
Chapter 1 313
ChapterZ 319
Chapter 3 326
Chapter t 330
Chapter 5 335
Chapter 6 340
Chapter 7 348
Chapter 8 358
Chapter 9 366
Chapter 10 372
Chapter 11 378
Chapter 12 380
Appendix B 380
D SUGGESTIONS FOR FURTHER READING 389
INDEX 397
|
| any_adam_object | 1 |
| author | Date, Chris J. 1941- |
| author_GND | (DE-588)120054884 |
| author_facet | Date, Chris J. 1941- |
| author_role | aut |
| author_sort | Date, Chris J. 1941- |
| author_variant | c j d cj cjd |
| building | Verbundindex |
| bvnumber | BV035658226 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.73.S67 |
| callnumber-search | QA76.73.S67 |
| callnumber-sort | QA 276.73 S67 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)233931602 (DE-599)DNB990908194 |
| dewey-full | 005.7565 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7565 |
| dewey-search | 005.7565 |
| dewey-sort | 15.7565 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1. Aufl. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01578nam a2200445 c 4500</leader><controlfield tag="001">BV035658226</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">090803s2009 |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">08,N45,0012</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">990908194</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780596523060</subfield><subfield code="c">: EUR 38.00 (freier Pr.)</subfield><subfield code="9">978-0-596-52306-0</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9780596523060</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)233931602</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)DNB990908194</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-858</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.73.S67</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">22</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Date, Chris J.</subfield><subfield code="d">1941-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)120054884</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL and Relational Theory</subfield><subfield code="b">how to write accurate SQL code</subfield><subfield code="c">C. J. Date</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. Aufl.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Sebastopol, CA</subfield><subfield code="b">O'Reilly & Associates</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIX, 404 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Theory in practice</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="0">(DE-588)4123623-3</subfield><subfield code="a">Lehrbuch</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017712687&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-017712687</subfield></datafield></record></collection> |
| genre | (DE-588)4123623-3 Lehrbuch gnd-content |
| genre_facet | Lehrbuch |
| id | DE-604.BV035658226 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T21:42:38Z |
| institution | BVB |
| isbn | 9780596523060 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-017712687 |
| oclc_num | 233931602 |
| open_access_boolean | |
| owner | DE-858 DE-11 |
| owner_facet | DE-858 DE-11 |
| physical | XIX, 404 S. |
| publishDate | 2009 |
| publishDateSearch | 2009 |
| publishDateSort | 2009 |
| publisher | O'Reilly & Associates |
| record_format | marc |
| series2 | Theory in practice |
| spelling | Date, Chris J. 1941- Verfasser (DE-588)120054884 aut SQL and Relational Theory how to write accurate SQL code C. J. Date 1. Aufl. Sebastopol, CA O'Reilly & Associates 2009 XIX, 404 S. txt rdacontent n rdamedia nc rdacarrier Theory in practice Relational databases SQL (Computer program language) SQL (DE-588)4134010-3 gnd rswk-swf (DE-588)4123623-3 Lehrbuch gnd-content SQL (DE-588)4134010-3 s DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017712687&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Date, Chris J. 1941- SQL and Relational Theory how to write accurate SQL code Relational databases SQL (Computer program language) SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4134010-3 (DE-588)4123623-3 |
| title | SQL and Relational Theory how to write accurate SQL code |
| title_auth | SQL and Relational Theory how to write accurate SQL code |
| title_exact_search | SQL and Relational Theory how to write accurate SQL code |
| title_full | SQL and Relational Theory how to write accurate SQL code C. J. Date |
| title_fullStr | SQL and Relational Theory how to write accurate SQL code C. J. Date |
| title_full_unstemmed | SQL and Relational Theory how to write accurate SQL code C. J. Date |
| title_short | SQL and Relational Theory |
| title_sort | sql and relational theory how to write accurate sql code |
| title_sub | how to write accurate SQL code |
| topic | Relational databases SQL (Computer program language) SQL (DE-588)4134010-3 gnd |
| topic_facet | Relational databases SQL (Computer program language) SQL Lehrbuch |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017712687&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT datechrisj sqlandrelationaltheoryhowtowriteaccuratesqlcode |