SQL clearly explained:
Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book included some material about the object-relat...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Burlington, MA
Morgan Kaufmann
© 2010
|
| Ausgabe: | 3rd ed |
| Schriftenreihe: | Morgan Kaufmann series in data management systems
|
| Schlagworte: | |
| Online-Zugang: | FLA01 URL des Erstveröffentlichers |
| Zusammenfassung: | Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right. All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language. There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition. Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system Explains use of SQL to enter, modify or delete data to maintain database structural elements Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content |
| Beschreibung: | 1 online resource (xvii, 462 pages) illustrations |
| ISBN: | 9780123756985 0123756987 9780080517582 0080517587 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV046125448 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 190827s2010 |||| o||u| ||||||eng d | ||
| 015 | |a GBB049200 |2 dnb | ||
| 020 | |a 9780123756985 |9 978-0-12-375698-5 | ||
| 020 | |a 0123756987 |9 0-12-375698-7 | ||
| 020 | |a 9780080517582 |9 978-0-08-051758-2 | ||
| 020 | |a 0080517587 |9 0-08-051758-7 | ||
| 035 | |a (ZDB-33-ESD)ocn613958927 | ||
| 035 | |a (OCoLC)613958927 | ||
| 035 | |a (DE-599)BVBBV046125448 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 082 | 0 | |a 005.13/3 |2 22 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Harrington, Jan L. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a SQL clearly explained |c Jan L. Harrington |
| 250 | |a 3rd ed | ||
| 264 | 1 | |a Burlington, MA |b Morgan Kaufmann |c © 2010 | |
| 300 | |a 1 online resource (xvii, 462 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 Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right. All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. | ||
| 520 | |a While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language. There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. | ||
| 520 | |a (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition. Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system Explains use of SQL to enter, modify or delete data to maintain database structural elements Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content | ||
| 650 | 7 | |a COMPUTERS / Programming Languages / C♯ |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / Java |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / Pascal |2 bisacsh | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 650 | 4 | |a SQL (Computer program language) | |
| 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 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 0123756979 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9780123756978 |
| 856 | 4 | 0 | |u http://www.sciencedirect.com/science/book/9780123756978 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-33-ESD | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-031505902 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u http://www.sciencedirect.com/science/book/9780123756978 |l FLA01 |p ZDB-33-ESD |q FLA_PDA_ESD |x Verlag |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804180444543975424 |
|---|---|
| any_adam_object | |
| author | Harrington, Jan L. |
| author_facet | Harrington, Jan L. |
| author_role | aut |
| author_sort | Harrington, Jan L. |
| author_variant | j l h jl jlh |
| building | Verbundindex |
| bvnumber | BV046125448 |
| classification_rvk | ST 271 |
| collection | ZDB-33-ESD |
| ctrlnum | (ZDB-33-ESD)ocn613958927 (OCoLC)613958927 (DE-599)BVBBV046125448 |
| dewey-full | 005.13/3 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.13/3 |
| dewey-search | 005.13/3 |
| dewey-sort | 15.13 13 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 3rd ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04558nmm a2200553zc 4500</leader><controlfield tag="001">BV046125448</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">190827s2010 |||| o||u| ||||||eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB049200</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780123756985</subfield><subfield code="9">978-0-12-375698-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0123756987</subfield><subfield code="9">0-12-375698-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080517582</subfield><subfield code="9">978-0-08-051758-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080517587</subfield><subfield code="9">0-08-051758-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-33-ESD)ocn613958927</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)613958927</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046125448</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/3</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="100" ind1="1" ind2=" "><subfield code="a">Harrington, Jan L.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL clearly explained</subfield><subfield code="c">Jan L. Harrington</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">3rd ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Burlington, MA</subfield><subfield code="b">Morgan Kaufmann</subfield><subfield code="c">© 2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xvii, 462 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">Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right. All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. </subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language. There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. </subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">(Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition. Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system Explains use of SQL to enter, modify or delete data to maintain database structural elements Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / C♯</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / Java</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / Pascal</subfield><subfield code="2">bisacsh</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="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="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">0123756979</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9780123756978</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://www.sciencedirect.com/science/book/9780123756978</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="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031505902</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="966" ind1="e" ind2=" "><subfield code="u">http://www.sciencedirect.com/science/book/9780123756978</subfield><subfield code="l">FLA01</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.BV046125448 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T08:35:52Z |
| institution | BVB |
| isbn | 9780123756985 0123756987 9780080517582 0080517587 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031505902 |
| oclc_num | 613958927 |
| open_access_boolean | |
| physical | 1 online resource (xvii, 462 pages) illustrations |
| psigel | ZDB-33-ESD ZDB-33-ESD FLA_PDA_ESD |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | Morgan Kaufmann |
| record_format | marc |
| series2 | Morgan Kaufmann series in data management systems |
| spelling | Harrington, Jan L. Verfasser aut SQL clearly explained Jan L. Harrington 3rd ed Burlington, MA Morgan Kaufmann © 2010 1 online resource (xvii, 462 pages) illustrations txt rdacontent c rdamedia cr rdacarrier Morgan Kaufmann series in data management systems Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right. All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language. There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition. Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system Explains use of SQL to enter, modify or delete data to maintain database structural elements Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast SQL (Computer program language) SQL (DE-588)4134010-3 gnd rswk-swf SQL (DE-588)4134010-3 s 1\p DE-604 Erscheint auch als Druck-Ausgabe 0123756979 Erscheint auch als Druck-Ausgabe 9780123756978 http://www.sciencedirect.com/science/book/9780123756978 Verlag URL des Erstveröffentlichers Volltext 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Harrington, Jan L. SQL clearly explained COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast SQL (Computer program language) SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4134010-3 |
| title | SQL clearly explained |
| title_auth | SQL clearly explained |
| title_exact_search | SQL clearly explained |
| title_full | SQL clearly explained Jan L. Harrington |
| title_fullStr | SQL clearly explained Jan L. Harrington |
| title_full_unstemmed | SQL clearly explained Jan L. Harrington |
| title_short | SQL clearly explained |
| title_sort | sql clearly explained |
| topic | COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast SQL (Computer program language) SQL (DE-588)4134010-3 gnd |
| topic_facet | COMPUTERS / Programming Languages / C♯ COMPUTERS / Programming Languages / Java COMPUTERS / Programming Languages / Pascal SQL (Computer program language) SQL |
| url | http://www.sciencedirect.com/science/book/9780123756978 |
| work_keys_str_mv | AT harringtonjanl sqlclearlyexplained |