國立虎尾科技大學 |

SQL Server Advanced Data Types = JSON, XML, and Beyond /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	SQL Server Advanced Data Types/ by Peter A. Carter.
其他題名:	JSON, XML, and Beyond /
作者:	Carter, Peter A.
面頁冊數:	XV, 392 p. 103 illus.online resource. :
Contained By:	Springer Nature eBook
標題:	Database management. -
電子資源:	https://doi.org/10.1007/978-1-4842-3901-8
ISBN:	9781484239018

SQL Server Advanced Data Types = JSON, XML, and Beyond /
Carter, Peter A.

SQL Server Advanced Data TypesJSON, XML, and Beyond /[electronic resource] :by Peter A. Carter. - 1st ed. 2018. - XV, 392 p. 103 illus.online resource.

1. SQL Server Data Types -- 2. Understanding XML -- 3. Constructing XML with T-SQL -- 4. Querying and Shredding XML -- 5. XML Indexes -- 6. Understanding JSON -- 7. Constructing JSON from T-SQL -- 8. Shredding JSON Data -- 9. Working with the JSON Data Type -- 10. Understanding Spatial Data -- 11. Working with Spatial Data -- 12. Working with Hierarchical Data with HierarchyID.

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.

ISBN: 9781484239018

Standard No.: 10.1007/978-1-4842-3901-8doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

SQL Server Advanced Data Types = JSON, XML, and Beyond /
LDR:03553nam a22004095i 4500 001 989165
003 DE-He213
005 20200703182519.0
007 cr nn 008mamaa
008 201225s2018 xxu| s |||| 0|eng d
020 $a 9781484239018 $9 978-1-4842-3901-8
024 7 $a 10.1007/978-1-4842-3901-8 $2 doi
035 $a 978-1-4842-3901-8
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Carter, Peter A. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1070187
245 1 0 $a SQL Server Advanced Data Types $h [electronic resource] : $b JSON, XML, and Beyond / $c by Peter A. Carter.
250 $a 1st ed. 2018.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2018.
300 $a XV, 392 p. 103 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a 1. SQL Server Data Types -- 2. Understanding XML -- 3. Constructing XML with T-SQL -- 4. Querying and Shredding XML -- 5. XML Indexes -- 6. Understanding JSON -- 7. Constructing JSON from T-SQL -- 8. Shredding JSON Data -- 9. Working with the JSON Data Type -- 10. Understanding Spatial Data -- 11. Working with Spatial Data -- 12. Working with Hierarchical Data with HierarchyID.
520 $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 $a Database management. $3 557799
650 1 4 $a Database Management. $3 669820
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484239001
776 0 8 $i Printed edition: $z 9781484239025
776 0 8 $i Printed edition: $z 9781484245828
856 4 0 $u https://doi.org/10.1007/978-1-4842-3901-8
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)