Language:
English
繁體中文
Help
回圖書館首頁
手機版館藏查詢
Login
Back
Switch To:
Labeled
|
MARC Mode
|
ISBD
XML and JSON recipes for SQL Server ...
~
Grinberg, Alex.
Linked to FindBook
Google Book
Amazon
博客來
XML and JSON recipes for SQL Server = a problem-solution approach /
Record Type:
Electronic resources : Monograph/item
Title/Author:
XML and JSON recipes for SQL Server/ by Alex Grinberg.
Reminder of title:
a problem-solution approach /
Author:
Grinberg, Alex.
Published:
Berkeley, CA :Apress : : 2018.,
Description:
xxiii, 289 p. :ill., digital ;24 cm.
[NT 15003449]:
Part I: XML in SQL Server -- 1. Introducing XML -- 2. Building XML -- 3. Manipulating XML Files -- 4. Shredding XML -- 5. Modifying XML -- 6. Filtering XML -- 7. Improving XML Performance -- Part II: JSON in SQL Server -- 8. Constructing JSON -- 9. Converting JSON to Row Sets -- 10. Modifying JSON.
Contained By:
Springer eBooks
Subject:
XML (Document markup language) -
Online resource:
http://dx.doi.org/10.1007/978-1-4842-3117-3
ISBN:
9781484231173
XML and JSON recipes for SQL Server = a problem-solution approach /
Grinberg, Alex.
XML and JSON recipes for SQL Server
a problem-solution approach /[electronic resource] :by Alex Grinberg. - Berkeley, CA :Apress :2018. - xxiii, 289 p. :ill., digital ;24 cm.
Part I: XML in SQL Server -- 1. Introducing XML -- 2. Building XML -- 3. Manipulating XML Files -- 4. Shredding XML -- 5. Modifying XML -- 6. Filtering XML -- 7. Improving XML Performance -- Part II: JSON in SQL Server -- 8. Constructing JSON -- 9. Converting JSON to Row Sets -- 10. Modifying JSON.
Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle. Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. XML is also used in SQL Server's BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you'll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications. What You Will Learn: Build XML and JSON objects in support of automation and data transfer Import and parse XML and JSON from operating system files Build appropriate indexes on XML objects to improve query performance Move data from query result sets into JSON format, and back again Automate the detection of database performance problems by querying and parsing the database's own execution plans Replace external and manual JSON processes with SQL Server's internal, JSON functionality.
ISBN: 9781484231173
Standard No.: 10.1007/978-1-4842-3117-3doiSubjects--Topical Terms:
549275
XML (Document markup language)
LC Class. No.: QA76.76.H94
Dewey Class. No.: 006.74
XML and JSON recipes for SQL Server = a problem-solution approach /
LDR
:03500nmm a2200325 a 4500
001
2133099
003
DE-He213
005
20180816165358.0
006
m d
007
cr nn 008maaau
008
181005s2018 cau s 0 eng d
020
$a
9781484231173
$q
(electronic bk.)
020
$a
9781484231166
$q
(paper)
024
7
$a
10.1007/978-1-4842-3117-3
$2
doi
035
$a
978-1-4842-3117-3
040
$a
GP
$c
GP
041
0
$a
eng
050
4
$a
QA76.76.H94
072
7
$a
UN
$2
bicssc
072
7
$a
UMT
$2
bicssc
072
7
$a
COM021000
$2
bisacsh
082
0 4
$a
006.74
$2
23
090
$a
QA76.76.H94
$b
G866 2018
100
1
$a
Grinberg, Alex.
$3
3300291
245
1 0
$a
XML and JSON recipes for SQL Server
$h
[electronic resource] :
$b
a problem-solution approach /
$c
by Alex Grinberg.
260
$a
Berkeley, CA :
$b
Apress :
$b
Imprint: Apress,
$c
2018.
300
$a
xxiii, 289 p. :
$b
ill., digital ;
$c
24 cm.
505
0
$a
Part I: XML in SQL Server -- 1. Introducing XML -- 2. Building XML -- 3. Manipulating XML Files -- 4. Shredding XML -- 5. Modifying XML -- 6. Filtering XML -- 7. Improving XML Performance -- Part II: JSON in SQL Server -- 8. Constructing JSON -- 9. Converting JSON to Row Sets -- 10. Modifying JSON.
520
$a
Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle. Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. XML is also used in SQL Server's BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you'll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications. What You Will Learn: Build XML and JSON objects in support of automation and data transfer Import and parse XML and JSON from operating system files Build appropriate indexes on XML objects to improve query performance Move data from query result sets into JSON format, and back again Automate the detection of database performance problems by querying and parsing the database's own execution plans Replace external and manual JSON processes with SQL Server's internal, JSON functionality.
650
0
$a
XML (Document markup language)
$3
549275
650
0
$a
JSON (Document markup language)
$3
2135005
650
1 4
$a
Computer Science.
$3
626642
650
2 4
$a
Database Management.
$3
891010
650
2 4
$a
Microsoft and .NET.
$3
3134847
710
2
$a
SpringerLink (Online service)
$3
836513
773
0
$t
Springer eBooks
856
4 0
$u
http://dx.doi.org/10.1007/978-1-4842-3117-3
950
$a
Professional and Applied Computing (Springer-12059)
based on 0 review(s)
Location:
ALL
電子資源
Year:
Volume Number:
Items
1 records • Pages 1 •
1
Inventory Number
Location Name
Item Class
Material type
Call number
Usage Class
Loan Status
No. of reservations
Opac note
Attachments
W9341834
電子資源
11.線上閱覽_V
電子書
EB QA76.76.H94
一般使用(Normal)
On shelf
0
1 records • Pages 1 •
1
Multimedia
Reviews
Add a review
and share your thoughts with other readers
Export
pickup library
Processing
...
Change password
Login