Joe Celko's thinking in sets: auxiliary, temporal, and virtual tables in SQL
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam
Elsevier / Morgan Kaufmann
c2008
|
| Schriftenreihe: | Morgan Kaufmann series in data management systems
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Beschreibung: | Includes index 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 |
| Beschreibung: | 1 Online-Ressource (xv, 362 p.) |
| ISBN: | 9780123741370 0123741378 9780080557526 008055752X |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV042305688 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 150129s2008 |||| o||u| ||||||eng d | ||
| 020 | |a 9780123741370 |9 978-0-12-374137-0 | ||
| 020 | |a 0123741378 |9 0-12-374137-8 | ||
| 020 | |a 9780080557526 |c electronic bk. |9 978-0-08-055752-6 | ||
| 020 | |a 008055752X |c electronic bk. |9 0-08-055752-X | ||
| 035 | |a (OCoLC)228148104 | ||
| 035 | |a (DE-599)BVBBV042305688 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 | ||
| 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 |b Elsevier / Morgan Kaufmann |c c2008 | |
| 300 | |a 1 Online-Ressource (xv, 362 p.) | ||
| 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 | |
| 500 | |a Includes index | ||
| 500 | |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 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 | 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 | 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 |3 Volltext |
| 912 | |a ZDB-33-ESD |a ZDB-33-EBS | ||
| 940 | 1 | |q FAW_PDA_ESD | |
| 940 | 1 | |q FLA_PDA_ESD | |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-027742680 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Datensatz im Suchindex
| _version_ | 1804152889079234560 |
|---|---|
| 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 | BV042305688 |
| collection | ZDB-33-ESD ZDB-33-EBS |
| ctrlnum | (OCoLC)228148104 (DE-599)BVBBV042305688 |
| 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>03217nmm a2200565zc 4500</leader><controlfield tag="001">BV042305688</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">150129s2008 |||| o||u| ||||||eng d</controlfield><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="c">electronic bk.</subfield><subfield code="9">978-0-08-055752-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">008055752X</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-08-055752-X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)228148104</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV042305688</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1046</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="b">Elsevier / Morgan Kaufmann</subfield><subfield code="c">c2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xv, 362 p.)</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="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="500" 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">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=" " 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="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="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-33-ESD</subfield><subfield code="a">ZDB-33-EBS</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FAW_PDA_ESD</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FLA_PDA_ESD</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-027742680</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></record></collection> |
| id | DE-604.BV042305688 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T01:17:53Z |
| institution | BVB |
| isbn | 9780123741370 0123741378 9780080557526 008055752X |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-027742680 |
| oclc_num | 228148104 |
| open_access_boolean | |
| owner | DE-1046 |
| owner_facet | DE-1046 |
| physical | 1 Online-Ressource (xv, 362 p.) |
| psigel | ZDB-33-ESD ZDB-33-EBS FAW_PDA_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 Elsevier / Morgan Kaufmann c2008 1 Online-Ressource (xv, 362 p.) txt rdacontent c rdamedia cr rdacarrier Morgan Kaufmann series in data management systems Includes index 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 Declarative programming fast SQL (Computer program language) fast SQL (Computer program language) Declarative programming COMPUTERS / Programming Languages / General bisacsh SQL (Computer program language) blmlsh Declarative programming blmlsh 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 Volltext 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 Declarative programming fast SQL (Computer program language) fast SQL (Computer program language) Declarative programming COMPUTERS / Programming Languages / General bisacsh SQL (Computer program language) blmlsh Declarative programming blmlsh 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 | Declarative programming fast SQL (Computer program language) fast SQL (Computer program language) Declarative programming COMPUTERS / Programming Languages / General bisacsh SQL (Computer program language) blmlsh Declarative programming blmlsh SQL (DE-588)4134010-3 gnd |
| topic_facet | Declarative programming SQL (Computer program language) COMPUTERS / Programming Languages / General SQL |
| url | http://www.sciencedirect.com/science/book/9780123741370 |
| work_keys_str_mv | AT celkojoe thinkinginsets AT celkojoe joecelkosthinkinginsetsauxiliarytemporalandvirtualtablesinsql |