Reportages Découverte Montmartre Les Secrets De La Butte | XENIA - They are Huge ! | complete Site Rip | 2018-07-20 | Chapter 34 : Brawl

XML Labling and Query Optimization

|
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 6 views
of 23

Please download to get full document.

View again

Description
XML Labling and Query Optimization. Sigmod2009 2009-7-3. Outline. XML DBS related researches in sigmod2009 DDE labeling Scheme XQuery Optimization conclusion. sigmod2009.
Share
Transcript
XML Labling and Query Optimization Sigmod2009 2009-7-3Outline
  • XML DBS related researches in sigmod2009
  • DDE labeling Scheme
  • XQuery Optimization
  • conclusion
  • sigmod2009
  • Research Session 16: Query Processing on Semi-structured DataCost Based Plan Selection for XPathHaris Georgiadis (Athens University of Economics and Business)Minas Charalambides (Athens University of Economics and Business)Vasilis Vassalos (Athens University of Economics and Business)ROX: Run-time Optimization of XQueriesRiham Abdel Kader (University of Twente)Peter Boncz (CWI)Stefan Manegold (CWI)Maurice Van Keulen (University of Twente)
  • Research Session 19: Semi-structured Data Management
  • DDE: From Dewey to a Fully Dynamic XML Labeling SchemeLiang Xu (National University of Singapore)Tok Wang Ling (National University of Singapore)Huayu Wu (National University of Singapore)Zhifeng Bao (National University of Singapore)Simplifying XML Schema: Effortless Handling of Nondeterministic Regular ExpressionsGeert Jan Bex (Hasselt University and Transnational University of Limburg)Wouter Gelade (Hasselt University and Transnational University of Limburg)Wim Martens (Technical University of Dortmund)Frank Neven (Hasselt University and Transnational University of Limburg)FlexRecs: Expressing and Combining Flexible RecommendationsGeorgia Koutrika (Stanford University)Benjamin Bercovitz (Stanford University)Hector Garcia-Molina (Stanford University) Outline
  • XML DBS related researches in sigmod2009
  • DDE labeling Scheme
  • XQuery Optimization
  • conclusion
  • Dewey labeling
  • Concatenation of its parent
  • labeling and local order
  • helpful for Keyword search
  • High cost of relabeling for
  • dynamic XML documentIs there a labeling scheme which not only has compact size and high query performance but also completely avoids relabeling?DDE Labeling (1)
  • Character
  • Can completely avoid relabeling
  • Efficiently support query
  • Not add the length of labeling
  • Only the definition of “preorder”
  • Preorder
  • labels A :a1.a2 … am and B : b1.b2 ...bn A≤dde B ifDDE: From Dewey to a Fully Dynamic XML Labeling SchemeLiang Xu, Tok Wang Ling School of Computing National University of singaporeDDE Labeling (2)
  • Leftmost insertion
  • insert before node A : a1.a2 … an (A is the first child ) a1.a2 … (an-1) ->this node.
  • Rightmost insertion
  • insert after node A : a1.a2 … an (A is the last child ) a1.a2 … (an + 1) -> this node.
  • Insertion below a leaf node
  • insertbelow a leaf node A :a1.a2 … an a1.a2 … an .1 -> this node.
  • Insertion between two consecutive siblings
  • insert between A and B A+B->this nodeDDE Labeling (3)--example1BA1.11.21.-11.0DC1.1.11.1.21.2.11.2.21.2.3HGFE3.3.51.1.1.12.2.35.4.8I3.3.5.1DDE Labeling (4)
  • AD relationship
  • A/m is an ancestorofB/n ifm<n and
  • PC relationship
  • A/m is the parentofB/n if m=n and A/m is an ancestorofB/n
  • Document order
  • A precedes B if A<ddeB
  • Sibling relationship
  • A is the sibling of B ifCDDE labeling(1)
  • Compact DDE
  • Enhance the performance of DDE for insertion
  • Relationship between them
  • CDDE label ->DDE labelCDDE labeling(2)—example1BA1.11.21.-11.0DC1.1.11.1.21.2.11.2.21.2.3HGFE3.1.51.1.1.12.1.35.1.8IKJ-1.3.3.5.2-1.3.3.5.1-2.3.3.5.3Outline
  • XML DBS related researches in sigmod2009
  • DDE labeling Scheme
  • XQuery Optimization
  • conclusion
  • Optimization of XQueries
  • Take Join Graph as input and care the correlations
  • Interleave optimization and execution steps
  • Use sample to estimate the cost
  • Use index to get sample
  • Use Chain Sampling to get optimal path
  • ROX: Runtime Optimization of XQueriesRiham Abdel Kader University of Twente Enschede, The NetherlandsJoin Graphslet $r := doc(“auction.xml”)for $a in $r//open auction[./r eserve]/bidder//personref,$b in $r//person[.//education]where$a/@person = $b/@idreturn$aRelated notation
  • CutOff Sampled Operators
  • :return a sample with size l :return partial execution results of the operator OP with size l
  • Weight of edge
  • cost(p)=cost(p’)+est*card(source) ÷T
  • Sf(p)=est/T
  • Chain Sampling
  • Chain Sampling makes ROX avoid local minimum due to correlations
  • only explore those paths that branch from the edge with the smallest weight
  • Find the optimal path pi
  • Example for Chain Samplingp1p2p2V4V1V2V3p3p4p3 is selectedV5V7p3V6V8[cost, sf ](p1) = [1500, 1.5][cost, sf ](p2) = [2000, 1][cost, sf ](p3) = [1300, 0.1][cost, sf ](p4) = [3200, 2]Optimization Algorithm
  • Reduce the intermediate results
  • exploring the search space by Chain Sampling
  • Find the optimal path
  • interleave optimization and execution steps
  • Illustrationlet$d := doc(“xmark.xml”)for $o in $d//open auction[.//current/text() < 145],$p in $d//person[.//province],$i in $d//item[./quantity = 1]where $o//bidder//personref/@person = $p/@id and $o//itemref/@item = $c/@idreturn $aIllustration(续)14p21311p2p210p212p29p28p14p17p1p135p16p1Outline
  • XML DBS related researches in sigmod2009
  • DDE labeling Scheme
  • XQuery Optimization
  • conclusion
  • conclusion
  • DDE and CDDE
  • They are tailored for both static and dynamic XML documents.
  • ROX: Runtime Optimization
  • To reduce the number of intermediate resultsThank you
    Related Search
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks