ScholarLens Back to search
2017•Apress eBooksRequires access

Improving XML Performance

Alex Grinberg

Open publisher page 1 citations

Abstract

Performance efficiency is always a top concern for DBAs and developers. Indexes are a front runner to improve data delivery processes. However, the logical tree structure of XML data cannot be indexed in the same way as plain old relational data. Therefore, with the introduction of SQL Server 2005, Microsoft added an indexing mechanism for XML data type columns. XML data is not the same as scalar data in a table’s column, therefore the XML indexing mechanism provides for specialized primary and secondary XML indexes. In SQL Server 2012, the XML indexes are enhanced with a Selective XML Index, which provides an improvement in search efficiency for big XML data. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

About this research paper

What this paper is about

Performance efficiency is always a top concern for DBAs and developers. Indexes are a front runner to improve data delivery processes. However, the logical tree structure of XML data cannot be indexed in the same way as plain old relational data. Therefore, with the introduction of SQL Server 2005, Microsoft added an indexing mechanism for XML data type columns. XML data is not the same as scalar data in a table’s column, therefore the XML indexing mechanism provides for specialized primary and secondary XML indexes. In SQL Server 2012, the XML indexes are enhanced with a Selective XML Index, which provides an improvement in search efficiency for big XML data. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Performance efficiency is always a top concern for DBAs and developers. Indexes are a front runner to improve data delivery processes. However, the logical tree structure of XML data cannot be indexed in the same way as plain old relational data. Therefore, with the introduction of SQL Server 2005, Microsoft added an indexing mechanism for XML data type columns. XML data is not the same as scalar data in a table’s column, therefore the XML indexing mechanism provides for specialized primary and secondary XML indexes. In SQL Server 2012, the XML indexes are enhanced with a Selective XML Index, which provides an improvement in search efficiency for big XML data. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Key concepts: Computer science, Efficient XML Interchange, Streaming XML, XML validation, XML database, XML Encryption, XML Schema Editor, XML Signature

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Improving XML Performance — Research Paper | ScholarLens