TAILIEUCHUNG - Indexing XML Data Stored in a Relational Database

In traditional SAS programs, PROCS are called as part of a workflow that usually includes SAS DATA steps along with PROC steps, which invoke SAS procedures. For example, a very basic SAS program includes a DATA step that creates the SAS data set from raw data files and a PROC step that invokes an appropriate SAS procedure to process the SAS data set. A PROC invocation typically takes one or more tables as input and produces a new table as output. Various programming options and control statements can also be specified on the PROC invocation. These dictate how the PROC. | Indexing XML Data Stored in a Relational Database Shankar Pal Istvan Cseri Oliver Seeliger Gideon Schaller Leo Giakoumakis Vasili Zolotov Microsoft Corporation One Microsoft Way Redmond WA 98052 USA shankarp istvanc oliverse gideons leogia vasilizo @ Abstract As XML usage grows for both data-centric and document-centric applications introducing native support for XML data in relational databases brings significant benefits. It provides a more mature platform for the XML data model and serves as the basis for interoperability between relational and XML data. Whereas query processing on XML data shredded into one or more relational tables is well understood it provides limited support for the XML data model. XML data can be persisted as a byte sequence BLOB in columns of tables to support the XML model more faithfully. This introduces new challenges for query processing such as the ability to index the XML blob for good query performance. This paper reports novel techniques for indexing XML data in the upcoming version of Microsoft SQL Server and how it ties into the relational framework for query processing. 1. Introduction Introducing XML 3 support in relational databases has been of keen interest in the industry in the past few years. One solution is to generate XML from a set of tables based on an XML schema definition and to decompose XML instances into such tables 2 5 11 16 20 . Once shredded into tables the full power of the relational engine such as indexing using B trees and query capabilities can be used to manage and query the data. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage the VLDB copyright notice and the title of the publication and its date appear and notice is given that copying is by permission of the Very Large Data Base Endowment. To copy otherwise or to republish requires a fee and or special permission from the Endowment

• Cơ sở dữ liệu
• equally weighted
• sample period
• Ultrasonic Pulse Velocity
• Cementitious Materials
• Macro Micro
• Mechanical Behavior