machine models and lower bounds for query processing
play

Machine Models and Lower Bounds for Query Processing Nicole - PowerPoint PPT Presentation

May 16, 2023 •304 likes •1.46k views

Machine Models and Lower Bounds for Query Processing Nicole Schweikardt Humboldt-University Berlin PODS 2007 Beijing, China, 11 June 2007 M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY

  1. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  2. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  3. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  4. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  5. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  6. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  7. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  8. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  9. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  10. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  11. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  12. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Missing Number Puzzle M ISSING N UMBER Input: Stream x 1 , x 2 , x 3 , . . , x n − 1 of n − 1 distinct numbers from { 1 , . . , n } Question: Which number from { 1 , . . , n } is missing? Naive Solution: 2 5 1 3 4 8 6 · · · n requires n bits of storage 1 2 3 4 5 6 7 8 · · · n � � � � � � � � � Clever Solution: Store running sum O ( log n ) bits suffice s := x 1 + x 2 + x 3 + x 4 + · · · + x n − 1 Missing number = n · ( n + 1 ) − s 2 Lower Bound: at least log n bits are necessary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 10/52

  13. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (1/3) M ULTISET -E QUALITY Total input length: N = O ( m · n ) bits Input: Two multisets { x 1 , . . , x m } and { y 1 , . . , y m } of bit-strings x i , y j (for simplicity, all bit-strings have same length n ) Question: Is { x 1 , . . , x m } = { y 1 , . . , y m } ? Observation: Every deterministic solution requires Ω( N ) bits of storage. Proof: • Use fact from Communication Complexity: N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 11/52

  14. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Communication Complexity Yaos 2-Party Communication Model: • 2 players: Alice & Bob • both know a function f : A × B → { 0 , 1 } • Alice only sees input a ∈ A , Bob only sees input b ∈ B • they jointly want to compute f ( a , b ) • Goal: exchange as few bits of communication as possible Fact: Deciding if two m -element input sets a = { x 1 , . . , x m } ⊆ { 0 , 1 } n b = { y 1 , . . , y m } ⊆ { 0 , 1 } n and ` 2 n ´ of n -bit-strings are equal, requires at least log bits of communication. m N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 12/52

  15. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Communication Complexity Yaos 2-Party Communication Model: • 2 players: Alice & Bob • both know a function f : A × B → { 0 , 1 } • Alice only sees input a ∈ A , Bob only sees input b ∈ B • they jointly want to compute f ( a , b ) • Goal: exchange as few bits of communication as possible Fact: Deciding if two m -element input sets a = { x 1 , . . , x m } ⊆ { 0 , 1 } n b = { y 1 , . . , y m } ⊆ { 0 , 1 } n and ` 2 n ´ of n -bit-strings are equal, requires at least log bits of communication. m N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 12/52

  16. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (1/3) M ULTISET -E QUALITY Total input length: N = O ( m · n ) bits Input: Two multisets { x 1 , . . , x m } and { y 1 , . . , y m } of bit-strings x i , y j (for simplicity, all bit-strings have same length n ) Question: Is { x 1 , . . , x m } = { y 1 , . . , y m } ? Observation: Every deterministic solution requires Ω( N ) bits of storage. Proof: • Use fact from Communication Complexity: N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 13/52

  17. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (1/3) M ULTISET -E QUALITY Total input length: N = O ( m · n ) bits Input: Two multisets { x 1 , . . , x m } and { y 1 , . . , y m } of bit-strings x i , y j (for simplicity, all bit-strings have same length n ) Question: Is { x 1 , . . , x m } = { y 1 , . . , y m } ? Observation: Every deterministic solution requires Ω( N ) bits of storage. Proof: • Use fact from Communication Complexity: Deciding if two m -element sets of n -bit-strings are equial ` 2 n ´ requires at least log bits of communication. m • If 2 n = m 2 , then log ` 2 n ´ � m · log m bits of communication are necessary, and the m total length of the corresponding M ULTISET -E QUALITY input is N = Θ( m · log m ) . N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 13/52

  18. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (1/3) M ULTISET -E QUALITY Total input length: N = O ( m · n ) bits Input: Two multisets { x 1 , . . , x m } and { y 1 , . . , y m } of bit-strings x i , y j (for simplicity, all bit-strings have same length n ) Question: Is { x 1 , . . , x m } = { y 1 , . . , y m } ? Observation: Every deterministic solution requires Ω( N ) bits of storage. Proof: • Use fact from Communication Complexity: Deciding if two m -element sets of n -bit-strings are equial ` 2 n ´ requires at least log bits of communication. m • If 2 n = m 2 , then log ` 2 n ´ � m · log m bits of communication are necessary, and the m total length of the corresponding M ULTISET -E QUALITY input is N = Θ( m · log m ) . N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 13/52

  19. � � � � � � M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (2/3) Proof (continued): • Known: N = Θ( m · log m ) , and � m · log m bits of communication are necessary for solving M ULTISET -E QUALITY . • A deterministic data stream algorithm solving M ULTISET -E QUALITY with B bits of storage would lead to a communication protocol with B bits of communication. Lower bound on lower bound on memory size • Thus: � communication complexity of data stream algorithm N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 14/52

  20. � � � � � � M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (2/3) Proof (continued): • Known: N = Θ( m · log m ) , and � m · log m bits of communication are necessary for solving M ULTISET -E QUALITY . • A deterministic data stream algorithm solving M ULTISET -E QUALITY with B bits of storage would lead to a communication protocol with B bits of communication. Lower bound on lower bound on memory size • Thus: � communication complexity of data stream algorithm N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 14/52

  21. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (2/3) Proof (continued): • Known: N = Θ( m · log m ) , and � m · log m bits of communication are necessary for solving M ULTISET -E QUALITY . • A deterministic data stream algorithm solving M ULTISET -E QUALITY with B bits of storage would lead to a communication protocol with B bits of communication. ALICE BOB x 1 x 2 x 3 x m y 1 y 2 y 3 y m � � � � � � data stream algorithm memory buffer Lower bound on lower bound on memory size • Thus: � communication complexity of data stream algorithm N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 14/52

  22. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (2/3) Proof (continued): • Known: N = Θ( m · log m ) , and � m · log m bits of communication are necessary for solving M ULTISET -E QUALITY . • A deterministic data stream algorithm solving M ULTISET -E QUALITY with B bits of storage would lead to a communication protocol with B bits of communication. ALICE BOB x 1 x 2 x 3 x m y 1 y 2 y 3 y m � � � � � � data stream algorithm memory buffer Lower bound on lower bound on memory size • Thus: � communication complexity of data stream algorithm N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 14/52

  23. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (3/3) Theorem: The M ULTISET -E QUALITY problem can be solved by a randomised algorithm using O ( log N ) bits of storage in the following sense: Given m , n, and a stream of n-bit-strings a 1 , . . , a m , b 1 , . . , b m , the algorithm • accepts with probability 1 if { a 1 , . . , a m } = { b 1 , . . , b m } • rejects with probability � 0 . 9 if { a 1 , . . , a m } � = { b 1 , . . , b m } . Proof idea: Use “Fingerprinting”-techniques: • represent { a 1 , . . , a m } by a polynomial f ( x ) := P m i = 1 x a i • represent { b 1 , . . , b m } by a polynomial g ( x ) := P m i = 1 x b i • choose a random number r and check if f ( r ) = g ( r ) • accept if f ( r ) = g ( r ) ; reject otherwise. If { a 1 , . . , a m } = { b 1 , . . , b m } , then f ( x ) = g ( x ) , and thus the algorithm always accepts. If { a 1 , . . , a m } � = { b 1 , . . , b m } , then there are at most degree ( f − g ) many distinct r with f ( r ) = g ( r ) , and thus the algorithm rejects with high probability. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 15/52

  24. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (3/3) Theorem: The M ULTISET -E QUALITY problem can be solved by a randomised algorithm using O ( log N ) bits of storage in the following sense: Given m , n, and a stream of n-bit-strings a 1 , . . , a m , b 1 , . . , b m , the algorithm • accepts with probability 1 if { a 1 , . . , a m } = { b 1 , . . , b m } • rejects with probability � 0 . 9 if { a 1 , . . , a m } � = { b 1 , . . , b m } . Proof idea: Use “Fingerprinting”-techniques: • represent { a 1 , . . , a m } by a polynomial f ( x ) := P m i = 1 x a i • represent { b 1 , . . , b m } by a polynomial g ( x ) := P m i = 1 x b i • choose a random number r and check if f ( r ) = g ( r ) • accept if f ( r ) = g ( r ) ; reject otherwise. If { a 1 , . . , a m } = { b 1 , . . , b m } , then f ( x ) = g ( x ) , and thus the algorithm always accepts. If { a 1 , . . , a m } � = { b 1 , . . , b m } , then there are at most degree ( f − g ) many distinct r with f ( r ) = g ( r ) , and thus the algorithm rejects with high probability. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 15/52

  25. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (3/3) Theorem: The M ULTISET -E QUALITY problem can be solved by a randomised algorithm using O ( log N ) bits of storage in the following sense: Given m , n, and a stream of n-bit-strings a 1 , . . , a m , b 1 , . . , b m , the algorithm • accepts with probability 1 if { a 1 , . . , a m } = { b 1 , . . , b m } • rejects with probability � 0 . 9 if { a 1 , . . , a m } � = { b 1 , . . , b m } . Proof idea: Use “Fingerprinting”-techniques: • represent { a 1 , . . , a m } by a polynomial f ( x ) := P m i = 1 x a i • represent { b 1 , . . , b m } by a polynomial g ( x ) := P m i = 1 x b i • choose a random number r and check if f ( r ) = g ( r ) • accept if f ( r ) = g ( r ) ; reject otherwise. If { a 1 , . . , a m } = { b 1 , . . , b m } , then f ( x ) = g ( x ) , and thus the algorithm always accepts. If { a 1 , . . , a m } � = { b 1 , . . , b m } , then there are at most degree ( f − g ) many distinct r with f ( r ) = g ( r ) , and thus the algorithm rejects with high probability. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 15/52

  26. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The M ULTISET -E QUALITY Problem (3/3) Theorem: The M ULTISET -E QUALITY problem can be solved by a randomised algorithm using O ( log N ) bits of storage in the following sense: Given m , n, and a stream of n-bit-strings a 1 , . . , a m , b 1 , . . , b m , the algorithm • accepts with probability 1 if { a 1 , . . , a m } = { b 1 , . . , b m } • rejects with probability � 0 . 9 if { a 1 , . . , a m } � = { b 1 , . . , b m } . Proof idea: Use “Fingerprinting”-techniques: • represent { a 1 , . . , a m } by a polynomial f ( x ) := P m i = 1 x a i • represent { b 1 , . . , b m } by a polynomial g ( x ) := P m i = 1 x b i • choose a random number r and check if f ( r ) = g ( r ) • accept if f ( r ) = g ( r ) ; reject otherwise. If { a 1 , . . , a m } = { b 1 , . . , b m } , then f ( x ) = g ( x ) , and thus the algorithm always accepts. If { a 1 , . . , a m } � = { b 1 , . . , b m } , then there are at most degree ( f − g ) many distinct r with f ( r ) = g ( r ) , and thus the algorithm rejects with high probability. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 15/52

  27. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Outline Motivation Data Streams One External Memory Device Several External Memory Devices Finite Cursor Machines Summary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 16/52

  28. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Goal: Machine Model for . . . • fast & small internal memory vs. huge & slow external memory • external memory: random access vs. sequential scans ◮ machine model and complexity classes that measure costs caused by external memory accesses ◮ lower bounds for particular problems N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 17/52

  29. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Machine Model multi-tape Turing machine with • one “long” tape (that represents external memory) . . . . . . . limited access • some “short” tapes (that represent internal memory) . . . . . . . . limited size Input on the external memory tape. If necessary: Output on the external memory tape. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 18/52

  30. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Random Access An additional address tape (as part of the internal memory) • to specify addresses of tape positions on the external memory tape • a particular state which allows to move the external memory tape’s read/write head to the specified position in a single step N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 19/52

  31. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Head Reversals • When the external memory tape models a hard disk or a data stream, it should be read only in one direction (from left to right). • For our lower bounds we still allow head reversals on the external memory tape. (This makes our lower bound results only stronger.) • Allowing head reversals, we can ignore random access, because each “random access jump” can be simulated by at most 2 head reversals. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 20/52

  32. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Complexity Classes Let r : N → N and s : N → N . A ( r , s ) -bounded TM is a Turing machine with • one external memory tape, • internal memory tapes of total length s ( N ) , • less than r ( N ) head reversals on the external memory tape (where N = input length). ST ( r , s ) := the class of all problems that can be solved by a deterministic ( r , s ) -bounded TM. For classes R , S of functions we let ST ( R , S ) � := ST ( r , s ) . r ∈ R , s ∈ S N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 21/52

  33. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Complexity Classes Let r : N → N and s : N → N . A ( r , s ) -bounded TM is a Turing machine with • one external memory tape, • internal memory tapes of total length s ( N ) , • less than r ( N ) head reversals on the external memory tape (where N = input length). ST ( r , s ) := the class of all problems that can be solved by a deterministic ( r , s ) -bounded TM. For classes R , S of functions we let ST ( R , S ) � := ST ( r , s ) . r ∈ R , s ∈ S N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 21/52

  34. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Complexity Classes Let r : N → N and s : N → N . A ( r , s ) -bounded TM is a Turing machine with • one external memory tape, • internal memory tapes of total length s ( N ) , • less than r ( N ) head reversals on the external memory tape (where N = input length). ST ( r , s ) := the class of all problems that can be solved by a deterministic ( r , s ) -bounded TM. For classes R , S of functions we let ST ( R , S ) � := ST ( r , s ) . r ∈ R , s ∈ S N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 21/52

  35. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Complexity Classes ST ( 1 , s ) : • input is a data stream, • only internal memory available for the computation. ST ( r , s ) : • input on the hard disk, • this hard disk may be used throughout the computation, • � r ( N ) sequential scans of the hard disk, • internal memory of size � s ( N ) . N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 22/52

  36. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Complexity Classes ST ( 1 , s ) : • input is a data stream, • only internal memory available for the computation. ST ( r , s ) : • input on the hard disk, • this hard disk may be used throughout the computation, • � r ( N ) sequential scans of the hard disk, • internal memory of size � s ( N ) . N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 22/52

  37. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY An Easy Observation Fact: � � During an ( r , s ) -bounded computation, only O r ( N ) · s ( N ) bits can be communicated between the first and the second half of the external memory tape. Consequence: Lower bounds on communication complexity lead to lower bounds for the ST ( · · · ) classes. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 23/52

  38. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY An Easy Observation Fact: � � During an ( r , s ) -bounded computation, only O r ( N ) · s ( N ) bits can be communicated between the first and the second half of the external memory tape. Consequence: Lower bounds on communication complexity lead to lower bounds for the ST ( · · · ) classes. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 23/52

  39. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Some Results A lower bound for Sorting: S ORTING Input length N = m · ( n + 1 ) Input: bit-strings x 1 , . . . , x m ∈ { 0 , 1 } n (for arbitrary m , n ) Output: x 1 , . . . , x m sorted in ascending order Theorem: (Grohe, Koch, S., ICALP’05) ` ´ For all r , s : N → N we have: S ORTING ∈ ST ( r , s ) ⇐ ⇒ r ( N ) · s ( N ) ∈ Ω N . A Hierarchy of Head Reversals: Theorem: (Hernich, S., 2006) ` N ´ For every logspace-computable function r with r ( N ) ∈ o , and log 2 N “ ” N for every class S of functions such that O ( log N ) ⊆ S ⊆ o we have: r ( N ) · log N ST ( r ( N ) , S ) � ST ( r ( N )+ 1 , S ) Remark: An analogous result also holds for randomised versions of ST ( · , · ) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 24/52

  40. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Some Results A lower bound for Sorting: S ORTING Input length N = m · ( n + 1 ) Input: bit-strings x 1 , . . . , x m ∈ { 0 , 1 } n (for arbitrary m , n ) Output: x 1 , . . . , x m sorted in ascending order Theorem: (Grohe, Koch, S., ICALP’05) ` ´ For all r , s : N → N we have: S ORTING ∈ ST ( r , s ) ⇐ ⇒ r ( N ) · s ( N ) ∈ Ω N . A Hierarchy of Head Reversals: Theorem: (Hernich, S., 2006) ` N ´ For every logspace-computable function r with r ( N ) ∈ o , and log 2 N “ ” N for every class S of functions such that O ( log N ) ⊆ S ⊆ o we have: r ( N ) · log N ST ( r ( N ) , S ) � ST ( r ( N )+ 1 , S ) Remark: An analogous result also holds for randomised versions of ST ( · , · ) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 24/52

  41. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Query Processing on XML Streams Example: // auction [ seller=’P . Meier’ ] / bid XML Stream <auctions> <auction> XML Tree <bid> 100$ </bid> bid 100$ <product> product description </product> product product description <bid> 120$ </bid> auction <seller> bid 120$ P. Meier </seller> </auction> P. Meier seller <auction> auctions <seller> A. Schmidt </seller> <product> XYZ seller A. Schmidt </product> auction </auction> product XYZ </auctions> N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 26/52

  42. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Query Processing on XML Streams Example: // auction [ seller=’P . Meier’ ] / bid XML Stream <auctions> <auction> XML Tree <bid> 100$ </bid> bid 100$ <product> product description </product> product product description <bid> 120$ </bid> auction <seller> bid 120$ P. Meier </seller> </auction> P. Meier seller <auction> auctions <seller> A. Schmidt </seller> <product> XYZ seller A. Schmidt </product> auction </auction> product XYZ </auctions> N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 26/52

  43. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Query Processing on XML Streams Example: // auction [ seller=’P . Meier’ ] / bid XML Stream <auctions> <auction> XML Tree <bid> 100$ </bid> bid 100$ <product> product description </product> product product description <bid> 120$ </bid> auction <seller> bid 120$ P. Meier </seller> </auction> seller P. Meier <auction> auctions <seller> A. Schmidt </seller> <product> XYZ seller A. Schmidt </product> auction </auction> product XYZ </auctions> N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 26/52

  44. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Query Processing on XML Streams • XPath: a node-selecting XML query language, standardised by the W3C, the “navigation component” of XQuery and XSLT • Core XPath (Gottlob, Koch, 2000) : A logically “clean” fragment of XPath. Expressive power of Core XPath: weaker than node-selecting formulas from Monadic Second-Order Logic (MSO) Q -E VALUATION (for a Core XPath query Q ) Input: XML-document D Task: Compute the set of nodes selected by Q in S . Q -F ILTERING (for a Core XPath query Q ) Input: XML-document D Question: Does the query Q select at least one node in D ? N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 27/52

  45. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Query Processing on XML Streams • XPath: a node-selecting XML query language, standardised by the W3C, the “navigation component” of XQuery and XSLT • Core XPath (Gottlob, Koch, 2000) : A logically “clean” fragment of XPath. Expressive power of Core XPath: weaker than node-selecting formulas from Monadic Second-Order Logic (MSO) Q -E VALUATION (for a Core XPath query Q ) Input: XML-document D Task: Compute the set of nodes selected by Q in S . Q -F ILTERING (for a Core XPath query Q ) Input: XML-document D Question: Does the query Q select at least one node in D ? N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 27/52

  46. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Evaluation / Filtering on XML Streams Upper bounds (algorithms, systems): • large number of clever contributions by several research groups • various XPath fragments considered • many approaches based on finite automata, pushdown automata, or networks of automata Lower bounds (on memory for XPath processing on XML streams): • work by Bar-Yossef, Fontoura, Josifovski (PODS’04 and PODS’05) ◮ introduce particular fragments of XPath ◮ PODS’04: lower bounds for XPath filtering on XML streams ◮ PODS’05: lower bounds for XPath evaluation on XML streams: ◮ Proof method: communication complexity N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 28/52

  47. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Evaluation / Filtering on XML Streams Upper bounds (algorithms, systems): • large number of clever contributions by several research groups • various XPath fragments considered • many approaches based on finite automata, pushdown automata, or networks of automata Lower bounds (on memory for XPath processing on XML streams): • work by Bar-Yossef, Fontoura, Josifovski (PODS’04 and PODS’05) ◮ introduce particular fragments of XPath ◮ PODS’04: lower bounds for XPath filtering on XML streams ◮ PODS’05: lower bounds for XPath evaluation on XML streams: ◮ Proof method: communication complexity N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 28/52

  48. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) and Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) (b) There is a Core XPath query Q such that for all r , s with ` ´ r ( D ) · s ( D ) ∈ o height ( D ) we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (b): Communication complexity leads to a lower bound for the amount of information that has to be transported over the middle of the document . . . Consider the D ISJOINT -S ETS problem: Input: Two sets S 1 , S 2 ⊆ { 1 , . . , n } . Question: Is S 1 ∩ S 2 = ∅ ? Known: Requires at least n bits of communication. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 29/52

  49. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) and Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) (b) There is a Core XPath query Q such that for all r , s with ` ´ r ( D ) · s ( D ) ∈ o height ( D ) we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (b): Communication complexity leads to a lower bound for the amount of information that has to be transported over the middle of the document . . . Consider the D ISJOINT -S ETS problem: Input: Two sets S 1 , S 2 ⊆ { 1 , . . , n } . Question: Is S 1 ∩ S 2 = ∅ ? Known: Requires at least n bits of communication. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 29/52

  50. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) and Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) (b) There is a Core XPath query Q such that for all r , s with ` ´ r ( D ) · s ( D ) ∈ o height ( D ) we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (b): Communication complexity leads to a lower bound for the amount of information that has to be transported over the middle of the document . . . Consider the D ISJOINT -S ETS problem: Input: Two sets S 1 , S 2 ⊆ { 1 , . . , n } . Question: Is S 1 ∩ S 2 = ∅ ? Known: Requires at least n bits of communication. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 29/52

  51. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) and Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) (b) There is a Core XPath query Q such that for all r , s with ` ´ r ( D ) · s ( D ) ∈ o height ( D ) we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (b): Communication complexity leads to a lower bound for the amount of information that has to be transported over the middle of the document . . . Consider the D ISJOINT -S ETS problem: Input: Two sets S 1 , S 2 ⊆ { 1 , . . , n } . Question: Is S 1 ∩ S 2 = ∅ ? Known: Requires at least n bits of communication. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 29/52

  52. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) and Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) (b) There is a Core XPath query Q such that for all r , s with ` ´ r ( D ) · s ( D ) ∈ o height ( D ) we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (b): Communication complexity leads to a lower bound for the amount of information that has to be transported over the middle of the document . . . Consider the D ISJOINT -S ETS problem: Input: Two sets S 1 , S 2 ⊆ { 1 , . . , n } . Question: Is S 1 ∩ S 2 = ∅ ? Known: Requires at least n bits of communication. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 29/52

  53. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY . . . Proof of (b), continued • Encode the D ISJOINT -S ETS root problem by XML trees: left right • S 1 , S 2 ⊆ { 1 , . . , n } are encoded via x 1 blank left right x i = 1 ⇐ ⇒ i ∈ S 1 , y left right blank 1 y i = 1 ⇐ ⇒ i ∈ S 2 . x 2 blank left right y 2 • n ≈ height of document tree = left right blank amount of information that x 3 blank left right must be transported over the middle of the document. y 3 blank • Core XPath formulation of the D ISJOINT -S ETS problem: //*[right/right/1]/left/1 N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 31/52

  54. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY . . . Proof of (b), continued • Encode the D ISJOINT -S ETS root problem by XML trees: left right • S 1 , S 2 ⊆ { 1 , . . , n } are encoded via x 1 blank left right x i = 1 ⇐ ⇒ i ∈ S 1 , y left right blank 1 y i = 1 ⇐ ⇒ i ∈ S 2 . x 2 blank left right y 2 • n ≈ height of document tree = left right blank amount of information that x 3 blank left right must be transported over the middle of the document. y 3 blank • Core XPath formulation of the D ISJOINT -S ETS problem: //*[right/right/1]/left/1 N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 31/52

  55. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY . . . Proof of (b), continued • Encode the D ISJOINT -S ETS root problem by XML trees: left right • S 1 , S 2 ⊆ { 1 , . . , n } are encoded via x 1 blank left right x i = 1 ⇐ ⇒ i ∈ S 1 , y left right blank 1 y i = 1 ⇐ ⇒ i ∈ S 2 . x 2 blank left right y 2 • n ≈ height of document tree = left right blank amount of information that x 3 blank left right must be transported over the middle of the document. y 3 blank • Core XPath formulation of the D ISJOINT -S ETS problem: //*[right/right/1]/left/1 N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 31/52

  56. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) and (b) There is a Core XPath query Q such that for all r , s with r ( D ) · s ( D ) ∈ o ` height ( D ) ´ we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (a) Q -F ILTERING Problem: For every Core XPath query Q there is a bottom-up tree automaton that solves the filtering problem for Q . A run of this automaton can be simulated during a single forward-scan of the XML document. � solution of the Q -F ILTERING problem For the Q -E VALUATION problem use selecting tree automata: (1) forward scan of the XML document: simulate the run of a bottom-up tree automaton, use external memory to decorate the “closing bracket” of each node with the automaton’s state at that node. (2) backward scan of the “decorated” XML document: simulate the run of a top-down tree automaton, output the indices of those nodes at which a special selecting state is assumed. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 32/52

  57. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) and (b) There is a Core XPath query Q such that for all r , s with r ( D ) · s ( D ) ∈ o ` height ( D ) ´ we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (a) Q -F ILTERING Problem: For every Core XPath query Q there is a bottom-up tree automaton that solves the filtering problem for Q . A run of this automaton can be simulated during a single forward-scan of the XML document. � solution of the Q -F ILTERING problem For the Q -E VALUATION problem use selecting tree automata: (1) forward scan of the XML document: simulate the run of a bottom-up tree automaton, use external memory to decorate the “closing bracket” of each node with the automaton’s state at that node. (2) backward scan of the “decorated” XML document: simulate the run of a top-down tree automaton, output the indices of those nodes at which a special selecting state is assumed. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 32/52

  58. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY XPath Processing on XML Stored in External Memory Theorem: (Grohe, Koch, S., ICALP’05) (a) For every Core XPath query Q we have: Q -F ILTERING ∈ ST ( 1 , O ( height ( D ))) Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) and (b) There is a Core XPath query Q such that for all r , s with r ( D ) · s ( D ) ∈ o ` height ( D ) ´ we have: Q -F ILTERING �∈ ST ( r , s ) . Proof idea: (a) Q -F ILTERING Problem: For every Core XPath query Q there is a bottom-up tree automaton that solves the filtering problem for Q . A run of this automaton can be simulated during a single forward-scan of the XML document. � solution of the Q -F ILTERING problem For the Q -E VALUATION problem use selecting tree automata: (1) forward scan of the XML document: simulate the run of a bottom-up tree automaton, use external memory to decorate the “closing bracket” of each node with the automaton’s state at that node. (2) backward scan of the “decorated” XML document: simulate the run of a top-down tree automaton, output the indices of those nodes at which a special selecting state is assumed. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 32/52

  59. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY An Open Question: We have just seen that for every Core XPath query Q : Q -E VALUATION ∈ ST ( 2 , O ( height ( D ) + log ( size ( D )))) by an algorithm which performs one forward scan and one backward scan, and which needs to write onto the external memory tape during the forward scan. Open questions: ◮ Is a backward scan really necessary here? Obvious: a single forward scan doesn’t suffice. But what about 2 forward scans? ◮ Is writing to the external memory tape really necessary here? N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 33/52

  60. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Outline Motivation Data Streams One External Memory Device Several External Memory Devices Finite Cursor Machines Summary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 34/52

  61. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The Parallel Disk Model (PDM) Introduced by Vitter and Shriver, 1994 D = # independent disks Disk 1 Disk 2 Disk D B = block transfer size ( # data items ) M = internal memory size Internal memory ( # data items) N = problem size ( # data items ) CPU + good for designing and analysing external memory algorithms – no distinction between streaming and random access – not so suitable for proving lower bounds N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 35/52

  62. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Turing Machine Model multi-tape Turing machine with • t “long” tapes (that represent t external memory devices) . . . . . . . . . limited access • some “short” tapes (that represent internal memory) . . . . . . . . . . . . . . . . . limited size Input on the first external memory tape. If necessary: Output on the t -th external memory tape. ST ( r , s , t ) : complexity class similar to ST ( r , s ) , but with t long tapes ` ´ := S ST R , S , O ( 1 ) t � 1 ST ( R , S , t ) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 36/52

  63. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY The Sorting-Problem S ORTING Input length N = m · ( n + 1 ) Input: bit-strings x 1 , . . . , x m ∈ { 0 , 1 } n (for arbitrary m , n ) Output: x 1 , . . . , x m sorted in ascending order � � Recall: S ORTING ∈ ST ( r , s , 1 ) ⇐ ⇒ r ( N ) · s ( N ) ∈ Ω N . Theorem: (Chen, Yap, 1991) S ORTING ∈ ST ( O ( log N ) , O ( 1 ) , 2 ) Proof method: Refinement of Merge-Sort. Question: Is this optimal? . . . . . . . . . . . . . I.e..: What about o ( log n ) head reversals? N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 37/52

  64. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Lower Bound for Sorting with � 2 EM-tapes Problem: An additional external memory tape can be used to move around large parts of the input (with just 2 head reversals). � communication complexity does not help to prove lower bounds Intuition: Still, the order of the input strings cannot be changed so easily. Fact: For sufficiently small r ( N ) , s ( N ) , even with t � 2 external memory tapes, sorting by solely comparing and moving around the input strings is impossible. (For Comparison-Exchange Algorithms, according lower bounds are well-known.) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 38/52

  65. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Lower Bound for Sorting with � 2 EM-tapes Problem: An additional external memory tape can be used to move around large parts of the input (with just 2 head reversals). � communication complexity does not help to prove lower bounds Intuition: Still, the order of the input strings cannot be changed so easily. Fact: For sufficiently small r ( N ) , s ( N ) , even with t � 2 external memory tapes, sorting by solely comparing and moving around the input strings is impossible. (For Comparison-Exchange Algorithms, according lower bounds are well-known.) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 38/52

  66. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Lower Bound for Sorting with � 2 EM-Tapes Problem: Turing machines can perform much more complicated operations than just compare and move around input strings. Example: During a first scan of the input, compute the sum of the input numbers modulo a large prime. (In this way, already a single scan suffices to produce a number that depends in a non-trivial way on the entire input.) . . . Do some magic! — Recall the data stream algorithms for M ISSING N UMBER or M ULTISET -E QUALITY ! . . . Write the sorted sequence onto the output tape. N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 39/52

  67. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Lower Bound for Sorting Theorem: (Grohe, S., PODS’05) � o ( log N ) , N 1 − ε , O ( 1 ) � S ORTING �∈ ST (for every ε > 0 ) Proof method: 1. New machine model: List Machines • can only compare and move around input strings ( � weaker than TMs) • non-uniform & lots of states and tape symbols ( � stronger than TMs) 2. Simulate ( r , s , t ) -bounded TMs by list machines. 3. Prove that list machines cannot sort ( . . . use combinatorics). N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 40/52

  68. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Randomised ST-Classes: RST and co-RST Definition of RST: analogous to the class RP (randomised polynomial time): An RST-machine produces • no “false positives”, i.e., it rejects “no”-instances with prob. 1 • “false negatives” with prob. < 0 . 1, i.e. it accepts “yes”-inst. with prob. > 0 . 9 A co-RST-machine has complementary probabilities for accepting resp. rejecting: • no “false negatives”, i.e. it accepts “yes”-instances with prob. 1 • “false positives” with prob. < 0 . 1, i.e. it rejects “no”-inst. with prob. > 0 . 9 Theorem: (Grohe, Hernich, S., PODS’06) 8 �∈ RST ( o ( log N ) , N 1 − ε , O ( 1 )) (for every ε > 0 ) > < M ULTISET -E QUALITY ∈ co-RST ( 2 , O ( log N ) , 1 ) > ∈ ST ( O ( log N ) , O ( 1 ) , 2 ) : N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 41/52

  69. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Randomised ST-Classes: RST and co-RST Definition of RST: analogous to the class RP (randomised polynomial time): An RST-machine produces • no “false positives”, i.e., it rejects “no”-instances with prob. 1 • “false negatives” with prob. < 0 . 1, i.e. it accepts “yes”-inst. with prob. > 0 . 9 A co-RST-machine has complementary probabilities for accepting resp. rejecting: • no “false negatives”, i.e. it accepts “yes”-instances with prob. 1 • “false positives” with prob. < 0 . 1, i.e. it rejects “no”-inst. with prob. > 0 . 9 Theorem: (Grohe, Hernich, S., PODS’06) 8 �∈ RST ( o ( log N ) , N 1 − ε , O ( 1 )) (for every ε > 0 ) > < M ULTISET -E QUALITY ∈ co-RST ( 2 , O ( log N ) , 1 ) > ∈ ST ( O ( log N ) , O ( 1 ) , 2 ) : N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 41/52

  70. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Randomised ST-Classes: RST and co-RST Definition of RST: analogous to the class RP (randomised polynomial time): An RST-machine produces • no “false positives”, i.e., it rejects “no”-instances with prob. 1 • “false negatives” with prob. < 0 . 1, i.e. it accepts “yes”-inst. with prob. > 0 . 9 A co-RST-machine has complementary probabilities for accepting resp. rejecting: • no “false negatives”, i.e. it accepts “yes”-instances with prob. 1 • “false positives” with prob. < 0 . 1, i.e. it rejects “no”-inst. with prob. > 0 . 9 Theorem: (Grohe, Hernich, S., PODS’06) 8 �∈ RST ( o ( log N ) , N 1 − ε , O ( 1 )) (for every ε > 0 ) > < M ULTISET -E QUALITY ∈ co-RST ( 2 , O ( log N ) , 1 ) > ∈ ST ( O ( log N ) , O ( 1 ) , 2 ) : N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 41/52

  71. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Consequences • Separation of deterministic, randomised, and nondeterministic ST ( · · · ) -classes: NST ( R , S , O ( 1 )) | ← M ULTISET -E QUALITY ∈ NST ( 3 , O ( log N ) , 2 ) RST ( R , S , O ( 1 )) | ← M ULTISET -E QUALITY ∈ co-RST ( 2 , O ( log N ) , 1 ) ST ( R , S , O ( 1 )) for all R ⊆ o ( log n ) and O ( log n ) ⊆ S ⊆ O ( N 1 − ε ) • Lower bound for the worst-case data complexity of the evaluation of XPath queries against XML-streams: Theorem: There is an XPath query Q such that o ( log N ) , N 1 − ε , O ( 1 ) Q -F ILTERING �∈ co-RST ` ´ . N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 42/52

  72. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Consequences • Separation of deterministic, randomised, and nondeterministic ST ( · · · ) -classes: NST ( R , S , O ( 1 )) | ← M ULTISET -E QUALITY ∈ NST ( 3 , O ( log N ) , 2 ) RST ( R , S , O ( 1 )) | ← M ULTISET -E QUALITY ∈ co-RST ( 2 , O ( log N ) , 1 ) ST ( R , S , O ( 1 )) for all R ⊆ o ( log n ) and O ( log n ) ⊆ S ⊆ O ( N 1 − ε ) • Lower bound for the worst-case data complexity of the evaluation of XPath queries against XML-streams: Theorem: There is an XPath query Q such that o ( log N ) , N 1 − ε , O ( 1 ) Q -F ILTERING �∈ co-RST ` ´ . N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 42/52

  73. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Consequences • Separation of deterministic, randomised, and nondeterministic ST ( · · · ) -classes: NST ( R , S , O ( 1 )) | ← M ULTISET -E QUALITY ∈ NST ( 3 , O ( log N ) , 2 ) RST ( R , S , O ( 1 )) | ← M ULTISET -E QUALITY ∈ co-RST ( 2 , O ( log N ) , 1 ) ST ( R , S , O ( 1 )) for all R ⊆ o ( log n ) and O ( log n ) ⊆ S ⊆ O ( N 1 − ε ) • Lower bound for the worst-case data complexity of the evaluation of XPath queries against XML-streams: Theorem: There is an XPath query Q such that o ( log N ) , N 1 − ε , O ( 1 ) Q -F ILTERING �∈ co-RST ` ´ . N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 42/52

  74. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY ST-Classes with 2-Sided Bounded Error Definition of BPST: analogous to the class BPP (two-sided bounded error probabilistic polynomial time): An BPST-machine produces • “false positives” with prob. < 0 . 1, i.e., it rejects “no”-instances with prob. > 0 . 9 • “false negatives” with prob. < 0 . 1, it accepts “yes”-instances with prob. > 0 . 9 Theorem: (Beame, Jayram, Rudra, STOC’07) “ “ ” ” log N , N 1 − ε , O ( 1 ) S ET -D ISJOINTNESS �∈ BPST o (for every ε > 0 ) log log N Note: All currently known lower bound proofs for (deterministic or randomized) ST-classes with � 2 em-tapes rely on (1) a key lemma which reduces the problem of proving lower bounds for ST-machines to a purely combinatorial problem (see Lemma 4.13 in the PODS’07 proceedings) (2) a clever use of combinatorics N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 43/52

  75. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY ST-Classes with 2-Sided Bounded Error Definition of BPST: analogous to the class BPP (two-sided bounded error probabilistic polynomial time): An BPST-machine produces • “false positives” with prob. < 0 . 1, i.e., it rejects “no”-instances with prob. > 0 . 9 • “false negatives” with prob. < 0 . 1, it accepts “yes”-instances with prob. > 0 . 9 Theorem: (Beame, Jayram, Rudra, STOC’07) “ “ ” ” log N , N 1 − ε , O ( 1 ) S ET -D ISJOINTNESS �∈ BPST o (for every ε > 0 ) log log N Note: All currently known lower bound proofs for (deterministic or randomized) ST-classes with � 2 em-tapes rely on (1) a key lemma which reduces the problem of proving lower bounds for ST-machines to a purely combinatorial problem (see Lemma 4.13 in the PODS’07 proceedings) (2) a clever use of combinatorics N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 43/52

  76. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY ST-Classes with 2-Sided Bounded Error Definition of BPST: analogous to the class BPP (two-sided bounded error probabilistic polynomial time): An BPST-machine produces • “false positives” with prob. < 0 . 1, i.e., it rejects “no”-instances with prob. > 0 . 9 • “false negatives” with prob. < 0 . 1, it accepts “yes”-instances with prob. > 0 . 9 Theorem: (Beame, Jayram, Rudra, STOC’07) “ “ ” ” log N , N 1 − ε , O ( 1 ) S ET -D ISJOINTNESS �∈ BPST o (for every ε > 0 ) log log N Note: All currently known lower bound proofs for (deterministic or randomized) ST-classes with � 2 em-tapes rely on (1) a key lemma which reduces the problem of proving lower bounds for ST-machines to a purely combinatorial problem (see Lemma 4.13 in the PODS’07 proceedings) (2) a clever use of combinatorics N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 43/52

  77. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Some Future Tasks (1) All currently known lower bounds for the ST-models with � 2 em-tapes consider only o ( log N ) head reversals. To do: Show lower bounds for appropriate problems in a setting where Ω( log N ) head reversals and several em-tapes are available. Caveat: It is known that L OGSPACE ⊆ ST ( O ( log N ) , O ( 1 ) , 2 ) . (2) Study the related model with several em-tapes and intermediate sorting steps. This model is known as the StrSort model. (Aggarwal, Datar, Rajagopalan, Ruhl, FOCS’04 & Ruhl’s PhD thesis, 2003) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 44/52

  78. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Some Future Tasks (1) All currently known lower bounds for the ST-models with � 2 em-tapes consider only o ( log N ) head reversals. To do: Show lower bounds for appropriate problems in a setting where Ω( log N ) head reversals and several em-tapes are available. Caveat: It is known that L OGSPACE ⊆ ST ( O ( log N ) , O ( 1 ) , 2 ) . (2) Study the related model with several em-tapes and intermediate sorting steps. This model is known as the StrSort model. (Aggarwal, Datar, Rajagopalan, Ruhl, FOCS’04 & Ruhl’s PhD thesis, 2003) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 44/52

  79. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Some Future Tasks (1) All currently known lower bounds for the ST-models with � 2 em-tapes consider only o ( log N ) head reversals. To do: Show lower bounds for appropriate problems in a setting where Ω( log N ) head reversals and several em-tapes are available. Caveat: It is known that L OGSPACE ⊆ ST ( O ( log N ) , O ( 1 ) , 2 ) . (2) Study the related model with several em-tapes and intermediate sorting steps. This model is known as the StrSort model. (Aggarwal, Datar, Rajagopalan, Ruhl, FOCS’04 & Ruhl’s PhD thesis, 2003) N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 44/52

  80. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Outline Motivation Data Streams One External Memory Device Several External Memory Devices Finite Cursor Machines Summary N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 45/52

  81. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Finite Cursor Machines Introduced by Grohe, Gurevich, Leinders, S., Tyszkiewicz, Van den Bussche, ICDT’07 ◮ an abstract model for database query processing ◮ formal model: based on Abstract State Machines (instead of Turing machines) Informal Description of a FCM: ◮ works on a relational database (tables, not sets) (read-only access) ◮ on each table: a fixed number of cursors ◮ cursors are one-way, but can move asynchronously ◮ internal memory: ◮ finite state control ◮ fixed number of registers which can store bitstrings ◮ manipulation of output row and internal memory: via built-in bitstring functions on data elements and bitstrings N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 46/52

  82. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Finite Cursor Machines Introduced by Grohe, Gurevich, Leinders, S., Tyszkiewicz, Van den Bussche, ICDT’07 ◮ an abstract model for database query processing ◮ formal model: based on Abstract State Machines (instead of Turing machines) Informal Description of a FCM: ◮ works on a relational database (tables, not sets) (read-only access) ◮ on each table: a fixed number of cursors ◮ cursors are one-way, but can move asynchronously ◮ internal memory: ◮ finite state control ◮ fixed number of registers which can store bitstrings ◮ manipulation of output row and internal memory: via built-in bitstring functions on data elements and bitstrings N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 46/52

  83. M OTIVATION D ATA S TREAMS 1 E XTERNAL M EMORY D EVICE M ANY E XT .M EMORY D EVS . FCM S S UMMARY Finite Cursor Machines Introduced by Grohe, Gurevich, Leinders, S., Tyszkiewicz, Van den Bussche, ICDT’07 ◮ an abstract model for database query processing ◮ formal model: based on Abstract State Machines (instead of Turing machines) Informal Description of a FCM: Cursor 1 ◮ works on a relational database (tables, not sets) (read-only access) Cursor 2 ◮ on each table: a fixed number of cursors ◮ cursors are one-way, but can move asynchronously Cursor 3 ◮ internal memory: ◮ finite state control ◮ fixed number of registers which Cursor 1 can store bitstrings Cursor 2 ◮ manipulation of output row and internal memory: via built-in bitstring functions on data elements and bitstrings N ICOLE S CHWEIKARDT M ACHINE M ODELS AND L OWER B OUNDS FOR Q UERY P ROCESSING 46/52

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

Communication Lower Bounds for Statistical Estimation Problems via a Distributed Data Processing

Communication Lower Bounds for Statistical Estimation Problems via a Distributed Data Processing

Communication Lower Bounds for Statistical Estimation Problems via a Distributed Data Processing Inequality Mark Braverman Ankit Garg Tengyu Ma Huy Nguyen David Woodruff DIMACS Workshop on Big Data through the Lens of Sublinear Algorithms

730 views • 34 slides
Average - case Lower Bounds for Approximate Near - Neighbor fs om Isoperimetric Inequalities

Average - case Lower Bounds for Approximate Near - Neighbor fs om Isoperimetric Inequalities

Simple Average - case Lower Bounds for Approximate Near - Neighbor fs om Isoperimetric Inequalities Yitong Yin Nanjing University Nearest Neighbor Search ( NNS ) metric space ( X, dist) query x X database access y = ( y 1 , y 2 , . . . , y

384 views • 26 slides
Computational Lower Bounds for Statistical Estimation Problems Ilias Diakonikolas (USC) (joint

Computational Lower Bounds for Statistical Estimation Problems Ilias Diakonikolas (USC) (joint

Computational Lower Bounds for Statistical Estimation Problems Ilias Diakonikolas (USC) (joint with Daniel Kane (UCSD) and Alistair Stewart (USC)) Workshop on Local Algorithms, MIT, June 2018 THIS TALK General Technique for Statistical Query

455 views • 30 slides
Chapter 3: Top-k Query Processing and Indexing 3.1 Top-k Algorithms 3.2 Approximate Top-k Query

Chapter 3: Top-k Query Processing and Indexing 3.1 Top-k Algorithms 3.2 Approximate Top-k Query

Chapter 3: Top-k Query Processing and Indexing 3.1 Top-k Algorithms 3.2 Approximate Top-k Query Processing 3.3 Index Access Scheduling 3.4 Index Organization and Advanced Query Types 3-1 IRDM WS 2005 3.1 Top-k Query Processing with Scoring

592 views • 36 slides
Graph Oracle Models, Lower Bounds, and Gaps for Parallel Stochastic Optimization Jialei Wang

Graph Oracle Models, Lower Bounds, and Gaps for Parallel Stochastic Optimization Jialei Wang

Graph Oracle Models, Lower Bounds, and Gaps for Parallel Stochastic Optimization Jialei Wang Blake Woodworth Adam Smith (UChicago 2&quot; Investments) (TTIC) (Boston University) Nati Srebro H. Brendan McMahan (TTIC) (Google) Parallel

433 views • 19 slides
Query Processing Relevance feedback; query expansion; Web Search 1 Overview Indexes Query

Query Processing Relevance feedback; query expansion; Web Search 1 Overview Indexes Query

Query Processing Relevance feedback; query expansion; Web Search 1 Overview Indexes Query Indexi xing Ranki king Applica cation Results Documents User Information Query y Query analys ysis proce cess ssing Multimedia

740 views • 32 slides
Data Management Systems Query Processing Execution models Optimization heuristics

Data Management Systems Query Processing Execution models Optimization heuristics

Data Management Systems Query Processing Execution models Optimization heuristics &amp; Access to base tables rewriting Sorting and Aggregation Optimization cost models Joins Operators Gustavo Alonso Institute of

761 views • 57 slides
Conspiracies between Learning Algorithms, Lower Bounds, and Pseudorandomness Igor Carboni

Conspiracies between Learning Algorithms, Lower Bounds, and Pseudorandomness Igor Carboni

Conspiracies between Learning Algorithms, Lower Bounds, and Pseudorandomness Igor Carboni Oliveira University of Oxford Joint work with Rahul Santhanam (Oxford) Context Minor algorithmic improvements imply lower bounds (Williams, 2010). NEXP

696 views • 30 slides
Lower bounds for parameterized problems Dniel Marx 1 1 Institute for Computer Science and

Lower bounds for parameterized problems Dniel Marx 1 1 Institute for Computer Science and

Lower bounds for parameterized problems Dniel Marx 1 1 Institute for Computer Science and Control, Hungarian Academy of Sciences (MTA SZTAKI) Budapest, Hungary ICERM Providence, RI April 26, 2014 1 Lower bounds So far we have seen positive

1.14k views • 94 slides
1 Recap: Taking Differences Distribution of Integer Values 0.1 idea: use efficient coding

1 Recap: Taking Differences Distribution of Integer Values 0.1 idea: use efficient coding

Recap: Search Engine Query Processing Recap: Search Engine Query Processing Parallel query processing: divide docs between Basically, to process a query we need to traverse the many machines, broadcast results to all inverted lists of the

434 views • 6 slides
Data Management Systems Query Processing Introduction Execution models Optimization I

Data Management Systems Query Processing Introduction Execution models Optimization I

Data Management Systems Query Processing Introduction Execution models Optimization I heuristics &amp; rewriting Optimization II cost models Optimization III - Operators Gustavo Alonso Institute of Computing Platforms

327 views • 7 slides
Online Query Processing Exposure to online query processing algorithms and fundamentals A

Online Query Processing Exposure to online query processing algorithms and fundamentals A

Goals for Today Online Query Processing Exposure to online query processing algorithms and fundamentals A Tutorial Usage examples Basic sampling techniques and estimators Preferential data delivery Peter J. Haas Online

353 views • 10 slides
Lower Bounds on the Probability of a Finite Union of Events Jun Yang (joint work with Fady

Lower Bounds on the Probability of a Finite Union of Events Jun Yang (joint work with Fady

Lower Bounds on the Probability of a Finite Union of Events Jun Yang (joint work with Fady Alajaji and Glen Takahara) Department of Mathematics and Statistics, Queens University, Kingston, Canada ISIT 2014 Lower Bounds on P ( N Jun

228 views • 19 slides
Circuit Lower-bounds Lecture 24 Weak circuits are indeed weak 1 Circuit Lower-bounds 2

Circuit Lower-bounds Lecture 24 Weak circuits are indeed weak 1 Circuit Lower-bounds 2

Circuit Lower-bounds Lecture 24 Weak circuits are indeed weak 1 Circuit Lower-bounds 2 Circuit Lower-bounds Today: 2 Circuit Lower-bounds Today: PARITY AC 0 2 Circuit Lower-bounds Today: PARITY AC 0 Two different proofs! (Latter

1.59k views • 137 slides
CS4224/CS5424 Lecture 9 Distributed Query Processing Query Processing Translates query into a

CS4224/CS5424 Lecture 9 Distributed Query Processing Query Processing Translates query into a

CS4224/CS5424 Lecture 9 Distributed Query Processing Query Processing Translates query into a query plan that minimizes some cost function Minimize total cost CPU cost, I/O cost, &amp; communication cost Minimize response time

841 views • 52 slides
ADVANCED DATABASE SYSTEMS Query Execution &amp; Processing @ Andy_Pavlo // 15- 721 // Spring

ADVANCED DATABASE SYSTEMS Query Execution &amp; Processing @ Andy_Pavlo // 15- 721 // Spring

Lect ure # 13 ADVANCED DATABASE SYSTEMS Query Execution &amp; Processing @ Andy_Pavlo // 15- 721 // Spring 2020 2 ARCHITECTURE OVERVIEW Networking Layer SQL Query SQL Parser Planner Binder Rewriter Optimizer / Cost Models Compiler

881 views • 51 slides
Randomized Algorithms Randomized Algorithms Two Types of Randomized Algorithms Two Types of

Randomized Algorithms Randomized Algorithms Two Types of Randomized Algorithms Two Types of

Randomized Algorithms Randomized Algorithms Two Types of Randomized Algorithms Two Types of Randomized Algorithms and and Some Complexity Classes Some Complexity Classes Speaker: Chuang-Chieh Lin Advisor: Professor Maw-Shang Chang National

910 views • 52 slides
P and NP Lecture 22 1 Today Computational Complexity P , NP , PSPACE , EXP NP -completeness

P and NP Lecture 22 1 Today Computational Complexity P , NP , PSPACE , EXP NP -completeness

P and NP Lecture 22 1 Today Computational Complexity P , NP , PSPACE , EXP NP -completeness Non-deterministic Turing Machines CS 374 2 Resource Bounded Computation Interested in solving problems using limited time/memory T -time TM: On

346 views • 30 slides
Advanced Topics in Theoretical Computer Science Part 5: Complexity (Part 2) 5.07.2016 Viorica

Advanced Topics in Theoretical Computer Science Part 5: Complexity (Part 2) 5.07.2016 Viorica

Advanced Topics in Theoretical Computer Science Part 5: Complexity (Part 2) 5.07.2016 Viorica Sofronie-Stokkermans Universit at Koblenz-Landau e-mail: sofronie@uni-koblenz.de 1 Contents Recall: Turing machines and Turing computability

525 views • 35 slides
randomized computation Sometimes randomness helps in computation. randomized computation Augment

randomized computation Sometimes randomness helps in computation. randomized computation Augment

randomized computation Sometimes randomness helps in computation. randomized computation Augment our usual Turing machines with a read-only tape of random bits . start 0 2 accept 1 # # 0 1 1 0

736 views • 24 slides
CESNET storage activities overview Ji Hork (jiri.horky@cesnet.cz) 6th of March, 2013

CESNET storage activities overview Ji Hork (jiri.horky@cesnet.cz) 6th of March, 2013

12 th TF-Storage Meeting - Berlin CESNET storage activities overview Ji Hork (jiri.horky@cesnet.cz) 6th of March, 2013 History Relatively new activity to CESNET started in autumn 2010 with 2FTEs preparation phase continued until

441 views • 22 slides
SCSI support on Xen MATSUMOTO Hitoshi matsumotohitosh@jp.fujitsu.com Fujitsu Ltd. Why SCSI?

SCSI support on Xen MATSUMOTO Hitoshi matsumotohitosh@jp.fujitsu.com Fujitsu Ltd. Why SCSI?

SCSI support on Xen MATSUMOTO Hitoshi matsumotohitosh@jp.fujitsu.com Fujitsu Ltd. Why SCSI? Current Xen status personal use available business use reliability and availability are required reliability backup

525 views • 19 slides
Comparing Tape and Cloud Storage for Long-Term Data Preservation Matt Ninesling Matt Starr Eric

Comparing Tape and Cloud Storage for Long-Term Data Preservation Matt Ninesling Matt Starr Eric

Comparing Tape and Cloud Storage for Long-Term Data Preservation Matt Ninesling Matt Starr Eric Polet Director, Hardware Chief Technology Officer Program Manager, Engineering Emerging Markets Why are organizations looking to the clouds?

563 views • 16 slides
sys.backup b k Centralized Open Source backup solution for CARNet members solution for CARNet

sys.backup b k Centralized Open Source backup solution for CARNet members solution for CARNet

sys.backup b k Centralized Open Source backup solution for CARNet members solution for CARNet members Branko Radojevi , M.Sc. Deputy Director June 2011. (v 1.00) Just a few introductory words Just a few introductory words 40 years

385 views • 17 slides

More recommend