Joe Celko's Trees and hierarchies in SQL for smarties:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam
Morgan Kaufmann
c2004
|
| Schlagworte: | |
| Online-Zugang: | FAW01 FAW02 Volltext |
| Beschreibung: | Includes bibliographical references (p. [215]-216) Graphs, trees, and hierarchies -- Adjacency list model -- Path enumeration models -- Nested set model of hierarchies -- Frequent insertion trees -- The linear version of the nested sets model -- Binary trees -- Other models for trees -- Proprietary extensions for trees -- Hierarchies in data modeling -- Hierarchical encoding schemes -- Hierarchical database systems (IMS) Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. Includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code, available for download from www.mkp.com |
| Beschreibung: | 1 Online-Ressource (xii, 224 p.) |
| ISBN: | 0080491693 1417537078 1558609202 1592782426 9780080491691 9781417537075 9781558609204 9781592782420 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043072446 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2004 |||| o||u| ||||||eng d | ||
| 020 | |a 0080491693 |9 0-08-049169-3 | ||
| 020 | |a 1417537078 |9 1-4175-3707-8 | ||
| 020 | |a 1558609202 |9 1-55860-920-2 | ||
| 020 | |a 1592782426 |9 1-59278-242-6 | ||
| 020 | |a 9780080491691 |9 978-0-08-049169-1 | ||
| 020 | |a 9781417537075 |9 978-1-4175-3707-5 | ||
| 020 | |a 9781558609204 |9 978-1-55860-920-4 | ||
| 020 | |a 9781592782420 |9 978-1-59278-242-0 | ||
| 035 | |a (OCoLC)56344458 | ||
| 035 | |a (DE-599)BVBBV043072446 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.133 |2 22 | |
| 100 | 1 | |a Celko, Joe |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Joe Celko's Trees and hierarchies in SQL for smarties |c Joe Celko |
| 246 | 1 | 3 | |a Trees and hierarchies in SQL for smarties |
| 264 | 1 | |a Amsterdam |b Morgan Kaufmann |c c2004 | |
| 300 | |a 1 Online-Ressource (xii, 224 p.) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Includes bibliographical references (p. [215]-216) | ||
| 500 | |a Graphs, trees, and hierarchies -- Adjacency list model -- Path enumeration models -- Nested set model of hierarchies -- Frequent insertion trees -- The linear version of the nested sets model -- Binary trees -- Other models for trees -- Proprietary extensions for trees -- Hierarchies in data modeling -- Hierarchical encoding schemes -- Hierarchical database systems (IMS) | ||
| 500 | |a Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. Includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code, available for download from www.mkp.com | ||
| 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 | 7 | |a Trees (Graph theory) |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 blmlsh | |
| 650 | 7 | |a Trees (Graph theory) |2 blmlsh | |
| 650 | 7 | |a SQL (Computer program language) |2 local | |
| 650 | 7 | |a Trees (Graph theory) |2 local | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a Trees (Graph theory) | |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Graphentheorie |0 (DE-588)4113782-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | 1 | |a Graphentheorie |0 (DE-588)4113782-6 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028496638 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177 |l FAW01 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175456951336960 |
|---|---|
| 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 | BV043072446 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)56344458 (DE-599)BVBBV043072446 |
| dewey-full | 005.133 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.133 |
| dewey-search | 005.133 |
| dewey-sort | 15.133 |
| 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>03685nmm a2200649zc 4500</leader><controlfield tag="001">BV043072446</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2004 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080491693</subfield><subfield code="9">0-08-049169-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1417537078</subfield><subfield code="9">1-4175-3707-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1558609202</subfield><subfield code="9">1-55860-920-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1592782426</subfield><subfield code="9">1-59278-242-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080491691</subfield><subfield code="9">978-0-08-049169-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781417537075</subfield><subfield code="9">978-1-4175-3707-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781558609204</subfield><subfield code="9">978-1-55860-920-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781592782420</subfield><subfield code="9">978-1-59278-242-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)56344458</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043072446</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><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.133</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="245" ind1="1" ind2="0"><subfield code="a">Joe Celko's Trees and hierarchies in SQL for smarties</subfield><subfield code="c">Joe Celko</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Trees and hierarchies in SQL for smarties</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam</subfield><subfield code="b">Morgan Kaufmann</subfield><subfield code="c">c2004</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xii, 224 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="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references (p. [215]-216)</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Graphs, trees, and hierarchies -- Adjacency list model -- Path enumeration models -- Nested set model of hierarchies -- Frequent insertion trees -- The linear version of the nested sets model -- Binary trees -- Other models for trees -- Proprietary extensions for trees -- Hierarchies in data modeling -- Hierarchical encoding schemes -- Hierarchical database systems (IMS)</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. Includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code, available for download from www.mkp.com</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="7"><subfield code="a">Trees (Graph theory)</subfield><subfield code="2">fast</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">Trees (Graph theory)</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">local</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Trees (Graph theory)</subfield><subfield code="2">local</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">Trees (Graph theory)</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="650" ind1="0" ind2="7"><subfield code="a">Graphentheorie</subfield><subfield code="0">(DE-588)4113782-6</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="1"><subfield code="a">Graphentheorie</subfield><subfield code="0">(DE-588)4113782-6</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://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028496638</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://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177</subfield><subfield code="l">FAW01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177</subfield><subfield code="l">FAW02</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043072446 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:16:35Z |
| institution | BVB |
| isbn | 0080491693 1417537078 1558609202 1592782426 9780080491691 9781417537075 9781558609204 9781592782420 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028496638 |
| oclc_num | 56344458 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (xii, 224 p.) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2004 |
| publishDateSearch | 2004 |
| publishDateSort | 2004 |
| publisher | Morgan Kaufmann |
| record_format | marc |
| spelling | Celko, Joe Verfasser aut Joe Celko's Trees and hierarchies in SQL for smarties Joe Celko Trees and hierarchies in SQL for smarties Amsterdam Morgan Kaufmann c2004 1 Online-Ressource (xii, 224 p.) txt rdacontent c rdamedia cr rdacarrier Includes bibliographical references (p. [215]-216) Graphs, trees, and hierarchies -- Adjacency list model -- Path enumeration models -- Nested set model of hierarchies -- Frequent insertion trees -- The linear version of the nested sets model -- Binary trees -- Other models for trees -- Proprietary extensions for trees -- Hierarchies in data modeling -- Hierarchical encoding schemes -- Hierarchical database systems (IMS) Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more. This book covers SQL-92 and SQL:1999. Includes graph theory and programming techniques. Running examples throughout the book help illustrate and tie concepts together. Loads of code, available for download from www.mkp.com COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast Trees (Graph theory) fast SQL (Computer program language) blmlsh Trees (Graph theory) blmlsh SQL (Computer program language) local Trees (Graph theory) local SQL (Computer program language) Trees (Graph theory) SQL (DE-588)4134010-3 gnd rswk-swf Graphentheorie (DE-588)4113782-6 gnd rswk-swf SQL (DE-588)4134010-3 s Graphentheorie (DE-588)4113782-6 s 1\p DE-604 http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177 Aggregator Volltext 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Celko, Joe Joe Celko's Trees and hierarchies in SQL for smarties COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast Trees (Graph theory) fast SQL (Computer program language) blmlsh Trees (Graph theory) blmlsh SQL (Computer program language) local Trees (Graph theory) local SQL (Computer program language) Trees (Graph theory) SQL (DE-588)4134010-3 gnd Graphentheorie (DE-588)4113782-6 gnd |
| subject_GND | (DE-588)4134010-3 (DE-588)4113782-6 |
| title | Joe Celko's Trees and hierarchies in SQL for smarties |
| title_alt | Trees and hierarchies in SQL for smarties |
| title_auth | Joe Celko's Trees and hierarchies in SQL for smarties |
| title_exact_search | Joe Celko's Trees and hierarchies in SQL for smarties |
| title_full | Joe Celko's Trees and hierarchies in SQL for smarties Joe Celko |
| title_fullStr | Joe Celko's Trees and hierarchies in SQL for smarties Joe Celko |
| title_full_unstemmed | Joe Celko's Trees and hierarchies in SQL for smarties Joe Celko |
| title_short | Joe Celko's Trees and hierarchies in SQL for smarties |
| title_sort | joe celko s trees and hierarchies in sql for smarties |
| topic | COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast Trees (Graph theory) fast SQL (Computer program language) blmlsh Trees (Graph theory) blmlsh SQL (Computer program language) local Trees (Graph theory) local SQL (Computer program language) Trees (Graph theory) SQL (DE-588)4134010-3 gnd Graphentheorie (DE-588)4113782-6 gnd |
| topic_facet | COMPUTERS / Programming Languages / C♯ COMPUTERS / Programming Languages / Java COMPUTERS / Programming Languages / Pascal SQL (Computer program language) Trees (Graph theory) SQL Graphentheorie |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=114177 |
| work_keys_str_mv | AT celkojoe joecelkostreesandhierarchiesinsqlforsmarties AT celkojoe treesandhierarchiesinsqlforsmarties |