Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL
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...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam Boston
Elsevier / Morgan Kaufmann
© 2008
|
| Schriftenreihe: | Morgan Kaufmann series in data management systems
|
| Schlagworte: | |
| Online-Zugang: | DE-860 URL des Erstveröffentlichers |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV046124687 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 190827s2008 xx a||| o|||| 00||| eng d | ||
| 015 | |a GBB6H5440 |2 dnb | ||
| 020 | |a 9780123741370 |9 978-0-12-374137-0 | ||
| 020 | |a 0123741378 |9 0-12-374137-8 | ||
| 020 | |a 9780080557526 |9 978-0-08-055752-6 | ||
| 020 | |a 008055752X |9 0-08-055752-X | ||
| 020 | |a 128117212X |9 1-281-17212-X | ||
| 020 | |a 9781281172129 |9 978-1-281-17212-9 | ||
| 035 | |a (ZDB-33-ESD)ocn228148104 | ||
| 035 | |a (OCoLC)228148104 | ||
| 035 | |a (DE-599)BVBBV046124687 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 082 | 0 | |a 005.13 |2 22 | |
| 100 | 1 | |a Celko, Joe |e Verfasser |4 aut | |
| 240 | 1 | 0 | |a Thinking in sets |
| 245 | 1 | 0 | |a Joe Celko's thinking in sets |b auxiliary, temporal, and virtual tables in SQL |c Joe Celko |
| 246 | 1 | 3 | |a Thinking in sets |
| 264 | 1 | |a Amsterdam |a Boston |b Elsevier / Morgan Kaufmann |c © 2008 | |
| 300 | |a 1 online resource (xv, 362 pages) |b illustrations | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Morgan Kaufmann series in data management systems | |
| 520 | |a 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 | ||
| 650 | 7 | |a COMPUTERS / Programming Languages / General |2 bisacsh | |
| 650 | 7 | |a SQL (Computer program language) |2 blmlsh | |
| 650 | 7 | |a Declarative programming |2 blmlsh | |
| 650 | 7 | |a Declarative programming |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a Declarative programming | |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 856 | 4 | 0 | |u http://www.sciencedirect.com/science/book/9780123741370 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-33-ESD | ||
| 347 | |a text file | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-031505141 | |
| 966 | e | |u http://www.sciencedirect.com/science/book/9780123741370 |l DE-860 |p ZDB-33-ESD |q FLA_PDA_ESD |x Verlag |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1819307080028258304 |
|---|---|
| any_adam_object | |
| author | Celko, Joe |
| author_facet | Celko, Joe |
| author_role | aut |
| author_sort | Celko, Joe |
| author_variant | j c jc |
| building | Verbundindex |
| bvnumber | BV046124687 |
| collection | ZDB-33-ESD |
| ctrlnum | (ZDB-33-ESD)ocn228148104 (OCoLC)228148104 (DE-599)BVBBV046124687 |
| dewey-full | 005.13 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.13 |
| dewey-search | 005.13 |
| dewey-sort | 15.13 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03343nam a2200565zc 4500</leader><controlfield tag="001">BV046124687</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">190827s2008 xx a||| o|||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB6H5440</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780123741370</subfield><subfield code="9">978-0-12-374137-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0123741378</subfield><subfield code="9">0-12-374137-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080557526</subfield><subfield code="9">978-0-08-055752-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">008055752X</subfield><subfield code="9">0-08-055752-X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">128117212X</subfield><subfield code="9">1-281-17212-X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781281172129</subfield><subfield code="9">978-1-281-17212-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-33-ESD)ocn228148104</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)228148104</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046124687</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.13</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Celko, Joe</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="240" ind1="1" ind2="0"><subfield code="a">Thinking in sets</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Joe Celko's thinking in sets</subfield><subfield code="b">auxiliary, temporal, and virtual tables in SQL</subfield><subfield code="c">Joe Celko</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Thinking in sets</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam</subfield><subfield code="a">Boston</subfield><subfield code="b">Elsevier / Morgan Kaufmann</subfield><subfield code="c">© 2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xv, 362 pages)</subfield><subfield code="b">illustrations</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">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Morgan Kaufmann series in data management systems</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / General</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Declarative programming</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Declarative programming</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Declarative programming</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="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="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://www.sciencedirect.com/science/book/9780123741370</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-33-ESD</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031505141</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://www.sciencedirect.com/science/book/9780123741370</subfield><subfield code="l">DE-860</subfield><subfield code="p">ZDB-33-ESD</subfield><subfield code="q">FLA_PDA_ESD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV046124687 |
| illustrated | Illustrated |
| indexdate | 2024-12-24T07:47:15Z |
| institution | BVB |
| isbn | 9780123741370 0123741378 9780080557526 008055752X 128117212X 9781281172129 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031505141 |
| oclc_num | 228148104 |
| open_access_boolean | |
| physical | 1 online resource (xv, 362 pages) illustrations |
| psigel | ZDB-33-ESD ZDB-33-ESD FLA_PDA_ESD |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | Elsevier / Morgan Kaufmann |
| record_format | marc |
| series2 | Morgan Kaufmann series in data management systems |
| spelling | Celko, Joe Verfasser aut Thinking in sets Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL Joe Celko Amsterdam Boston Elsevier / Morgan Kaufmann © 2008 1 online resource (xv, 362 pages) illustrations txt rdacontent c rdamedia cr rdacarrier Morgan Kaufmann series in data management systems 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 COMPUTERS / Programming Languages / General bisacsh SQL (Computer program language) blmlsh Declarative programming blmlsh Declarative programming fast SQL (Computer program language) fast SQL (Computer program language) Declarative programming SQL (DE-588)4134010-3 gnd rswk-swf SQL (DE-588)4134010-3 s 1\p DE-604 http://www.sciencedirect.com/science/book/9780123741370 Verlag URL des Erstveröffentlichers Volltext text file 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Celko, Joe Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL COMPUTERS / Programming Languages / General bisacsh SQL (Computer program language) blmlsh Declarative programming blmlsh Declarative programming fast SQL (Computer program language) fast SQL (Computer program language) Declarative programming SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4134010-3 |
| title | Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL |
| title_alt | Thinking in sets |
| title_auth | Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL |
| title_exact_search | Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL |
| title_full | Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL Joe Celko |
| title_fullStr | Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL Joe Celko |
| title_full_unstemmed | Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL Joe Celko |
| title_short | Joe Celko's thinking in sets |
| title_sort | joe celko s thinking in sets auxiliary temporal and virtual tables in sql |
| title_sub | auxiliary, temporal, and virtual tables in SQL |
| topic | COMPUTERS / Programming Languages / General bisacsh SQL (Computer program language) blmlsh Declarative programming blmlsh Declarative programming fast SQL (Computer program language) fast SQL (Computer program language) Declarative programming SQL (DE-588)4134010-3 gnd |
| topic_facet | COMPUTERS / Programming Languages / General SQL (Computer program language) Declarative programming SQL |
| url | http://www.sciencedirect.com/science/book/9780123741370 |
| work_keys_str_mv | AT celkojoe thinkinginsets AT celkojoe joecelkosthinkinginsetsauxiliarytemporalandvirtualtablesinsql |