SQL server advanced data types : JSON, XML, and beyond (Record no. 44891)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 02787nam a22001935i 4500 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| ISBN | 9781484239001 (hard : alk. paper) |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.133 |
| Item number | CAR |
| 100 ## - MAIN ENTRY--AUTHOR NAME | |
| Personal name | Carter, Peter A. |
| 245 00 - TITLE STATEMENT | |
| Title | SQL server advanced data types : JSON, XML, and beyond |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication | New York : |
| Name of publisher | Apress, |
| Year of publication | [2018] ©2018 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Number of Pages | xv, 392 pages : |
| Other physical details | illustrations |
| 500 ## - GENERAL NOTE | |
| General note | Includes index.<br/>"Taking full advantage of SQL server's ever-growing support for modern data"- |
| 505 ## - FORMATTED CONTENTS NOTE | |
| Formatted contents note | SQL server data types --<br/>Understanding XML --<br/>Constructing XML with T-SQL --<br/>Querying and shredding XML --<br/>XML indexes --<br/>Understanding JSON --<br/>Constructing JSON from T-SQL --<br/>Shredding JSON data --<br/>Working with the JSON data type --<br/>Understanding spatial data --<br/>Working with spatial data --<br/>Working with hierarchical data and hierarchyID. |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc | 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 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | SQL server |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | Data types (Computer science) |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | JSON (Document markup language) |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Reference Books |
| Collection code | Home library | Current library | Shelving location | Date acquired | Source of acquisition | Cost, normal purchase price | Full call number | Accession Number | Koha item type |
|---|---|---|---|---|---|---|---|---|---|
| Reference | Main Library | Main Library | Reference | 08/11/2021 | Purchase | 8190.00 | 005.133 CAR | 016127 | Reference Books |