SQL server advanced data types: JSON, XML, and beyond
Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
New York
Apress
[2018]
|
| Schlagworte: | |
| Zusammenfassung: | Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software. Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently. The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes. What You'll Learn: Understand the implementation of basic data types and why using the correct type is so important Work with XML data through the XML data type Construct XML data from relational result sets Store and manipulate JSON data using the JSON data type Model and analyze spatial data for geographic information systems Define hierarchies and query them efficiently through the HierarchyID type |
| Beschreibung: | Includes index. - "Taking full advantage of SQL server's ever-growing support for modern data"--Cover |
| Beschreibung: | xv, 392 Seiten Diagramme 24 cm |
| ISBN: | 1484239008 9781484239001 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV045395093 | ||
| 003 | DE-604 | ||
| 005 | 20190514 | ||
| 007 | t| | ||
| 008 | 190110s2018 xx |||| |||| 00||| eng d | ||
| 020 | |a 1484239008 |9 1-4842-3900-8 | ||
| 020 | |a 9781484239001 |9 978-1-4842-3900-1 | ||
| 035 | |a (OCoLC)1077713359 | ||
| 035 | |a (DE-599)BSZ512735263 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-91G |a DE-11 | ||
| 082 | 0 | |a 005.75 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a DAT 664f |2 stub | ||
| 100 | 1 | |a Carter, Peter |e Verfasser |0 (DE-588)1093622555 |4 aut | |
| 245 | 1 | 0 | |a SQL server advanced data types |b JSON, XML, and beyond |c Peter A. Carter |
| 264 | 1 | |a New York |b Apress |c [2018] | |
| 300 | |a xv, 392 Seiten |b Diagramme |c 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index. - "Taking full advantage of SQL server's ever-growing support for modern data"--Cover | ||
| 520 | 3 | |a Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software. Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently. The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes. What You'll Learn: Understand the implementation of basic data types and why using the correct type is so important Work with XML data through the XML data type Construct XML data from relational result sets Store and manipulate JSON data using the JSON data type Model and analyze spatial data for geographic information systems Define hierarchies and query them efficiently through the HierarchyID type | |
| 650 | 0 | 7 | |a JSON |0 (DE-588)1105592812 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a XML |0 (DE-588)4501553-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL Server |0 (DE-588)4343204-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datentyp |0 (DE-588)4011149-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL Server 2017 |0 (DE-588)1158534051 |2 gnd |9 rswk-swf |
| 653 | |a SQL server / SQL server | ||
| 653 | 0 | |a Data types (Computer science) | |
| 653 | 0 | |a JSON (Document markup language) | |
| 653 | 0 | |a XML (Document markup language) | |
| 653 | 0 | |a Data types (Computer science) | |
| 653 | 0 | |a JSON (Document markup language) | |
| 653 | 0 | |a XML (Document markup language) | |
| 689 | 0 | 0 | |a SQL Server 2017 |0 (DE-588)1158534051 |D s |
| 689 | 0 | 1 | |a Datentyp |0 (DE-588)4011149-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a SQL Server 2017 |0 (DE-588)1158534051 |D s |
| 689 | 1 | 1 | |a JSON |0 (DE-588)1105592812 |D s |
| 689 | 1 | 2 | |a XML |0 (DE-588)4501553-3 |D s |
| 689 | 1 | |5 DE-604 | |
| 689 | 2 | 0 | |a SQL Server |0 (DE-588)4343204-9 |D s |
| 689 | 2 | |8 1\p |5 DE-604 | |
| 689 | 3 | 0 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 3 | |8 2\p |5 DE-604 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |t SQL Server Advanced Data Types |d Berkeley, CA : Apress, 2018 |h Online-Ressource (XV, 392 p. 103 illus, online resource) |z 978-1-4842-3901-8 |
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 2\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-030781295 | |
Datensatz im Suchindex
| _version_ | 1825819552276021248 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Carter, Peter |
| author_GND | (DE-588)1093622555 |
| author_facet | Carter, Peter |
| author_role | aut |
| author_sort | Carter, Peter |
| author_variant | p c pc |
| building | Verbundindex |
| bvnumber | BV045395093 |
| classification_rvk | ST 271 |
| classification_tum | DAT 664f |
| ctrlnum | (OCoLC)1077713359 (DE-599)BSZ512735263 |
| dewey-full | 005.75 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75 |
| dewey-search | 005.75 |
| dewey-sort | 15.75 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV045395093</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20190514</controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">190110s2018 xx |||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484239008</subfield><subfield code="9">1-4842-3900-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484239001</subfield><subfield code="9">978-1-4842-3900-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1077713359</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BSZ512735263</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="049" ind1=" " ind2=" "><subfield code="a">DE-91G</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75</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">DAT 664f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Carter, Peter</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1093622555</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL server advanced data types</subfield><subfield code="b">JSON, XML, and beyond</subfield><subfield code="c">Peter A. Carter</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York</subfield><subfield code="b">Apress</subfield><subfield code="c">[2018]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xv, 392 Seiten</subfield><subfield code="b">Diagramme</subfield><subfield code="c">24 cm</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="500" ind1=" " ind2=" "><subfield code="a">Includes index. - "Taking full advantage of SQL server's ever-growing support for modern data"--Cover</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software. Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently. The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes. What You'll Learn: Understand the implementation of basic data types and why using the correct type is so important Work with XML data through the XML data type Construct XML data from relational result sets Store and manipulate JSON data using the JSON data type Model and analyze spatial data for geographic information systems Define hierarchies and query them efficiently through the HierarchyID type</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">JSON</subfield><subfield code="0">(DE-588)1105592812</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">XML</subfield><subfield code="0">(DE-588)4501553-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datentyp</subfield><subfield code="0">(DE-588)4011149-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL Server 2017</subfield><subfield code="0">(DE-588)1158534051</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">SQL server / SQL server</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Data types (Computer science)</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">JSON (Document markup language)</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">XML (Document markup language)</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">Data types (Computer science)</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">JSON (Document markup language)</subfield></datafield><datafield tag="653" ind1=" " ind2="0"><subfield code="a">XML (Document markup language)</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL Server 2017</subfield><subfield code="0">(DE-588)1158534051</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datentyp</subfield><subfield code="0">(DE-588)4011149-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">SQL Server 2017</subfield><subfield code="0">(DE-588)1158534051</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">JSON</subfield><subfield code="0">(DE-588)1105592812</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="2"><subfield code="a">XML</subfield><subfield code="0">(DE-588)4501553-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="3" ind2="0"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="3" ind2=" "><subfield code="8">2\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">Online-Ausgabe</subfield><subfield code="t">SQL Server Advanced Data Types</subfield><subfield code="d">Berkeley, CA : Apress, 2018</subfield><subfield code="h">Online-Ressource (XV, 392 p. 103 illus, online resource)</subfield><subfield code="z">978-1-4842-3901-8</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="883" ind1="1" ind2=" "><subfield code="8">2\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-030781295</subfield></datafield></record></collection> |
| id | DE-604.BV045395093 |
| illustrated | Not Illustrated |
| indexdate | 2025-03-06T05:00:13Z |
| institution | BVB |
| isbn | 1484239008 9781484239001 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-030781295 |
| oclc_num | 1077713359 |
| open_access_boolean | |
| owner | DE-91G DE-BY-TUM DE-11 |
| owner_facet | DE-91G DE-BY-TUM DE-11 |
| physical | xv, 392 Seiten Diagramme 24 cm |
| publishDate | 2018 |
| publishDateSearch | 2018 |
| publishDateSort | 2018 |
| publisher | Apress |
| record_format | marc |
| spelling | Carter, Peter Verfasser (DE-588)1093622555 aut SQL server advanced data types JSON, XML, and beyond Peter A. Carter New York Apress [2018] xv, 392 Seiten Diagramme 24 cm txt rdacontent n rdamedia nc rdacarrier Includes index. - "Taking full advantage of SQL server's ever-growing support for modern data"--Cover Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software. Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently. The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes. What You'll Learn: Understand the implementation of basic data types and why using the correct type is so important Work with XML data through the XML data type Construct XML data from relational result sets Store and manipulate JSON data using the JSON data type Model and analyze spatial data for geographic information systems Define hierarchies and query them efficiently through the HierarchyID type JSON (DE-588)1105592812 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf XML (DE-588)4501553-3 gnd rswk-swf SQL Server (DE-588)4343204-9 gnd rswk-swf Datentyp (DE-588)4011149-0 gnd rswk-swf SQL Server 2017 (DE-588)1158534051 gnd rswk-swf SQL server / SQL server Data types (Computer science) JSON (Document markup language) XML (Document markup language) SQL Server 2017 (DE-588)1158534051 s Datentyp (DE-588)4011149-0 s DE-604 JSON (DE-588)1105592812 s XML (DE-588)4501553-3 s SQL Server (DE-588)4343204-9 s 1\p DE-604 Datenbankverwaltung (DE-588)4389357-0 s 2\p DE-604 Erscheint auch als Online-Ausgabe SQL Server Advanced Data Types Berkeley, CA : Apress, 2018 Online-Ressource (XV, 392 p. 103 illus, online resource) 978-1-4842-3901-8 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Carter, Peter SQL server advanced data types JSON, XML, and beyond JSON (DE-588)1105592812 gnd Datenbankverwaltung (DE-588)4389357-0 gnd XML (DE-588)4501553-3 gnd SQL Server (DE-588)4343204-9 gnd Datentyp (DE-588)4011149-0 gnd SQL Server 2017 (DE-588)1158534051 gnd |
| subject_GND | (DE-588)1105592812 (DE-588)4389357-0 (DE-588)4501553-3 (DE-588)4343204-9 (DE-588)4011149-0 (DE-588)1158534051 |
| title | SQL server advanced data types JSON, XML, and beyond |
| title_auth | SQL server advanced data types JSON, XML, and beyond |
| title_exact_search | SQL server advanced data types JSON, XML, and beyond |
| title_full | SQL server advanced data types JSON, XML, and beyond Peter A. Carter |
| title_fullStr | SQL server advanced data types JSON, XML, and beyond Peter A. Carter |
| title_full_unstemmed | SQL server advanced data types JSON, XML, and beyond Peter A. Carter |
| title_short | SQL server advanced data types |
| title_sort | sql server advanced data types json xml and beyond |
| title_sub | JSON, XML, and beyond |
| topic | JSON (DE-588)1105592812 gnd Datenbankverwaltung (DE-588)4389357-0 gnd XML (DE-588)4501553-3 gnd SQL Server (DE-588)4343204-9 gnd Datentyp (DE-588)4011149-0 gnd SQL Server 2017 (DE-588)1158534051 gnd |
| topic_facet | JSON Datenbankverwaltung XML SQL Server Datentyp SQL Server 2017 |
| work_keys_str_mv | AT carterpeter sqlserveradvanceddatatypesjsonxmlandbeyond |