Given the set of SS-tables in LSM.         And the hash func…

Given the set of SS-tables in LSM.         And the hash functions H1(v), H2(v) where v is a search key as: H1(Alan) = 8                                        H2(Alan) = 2 H1(Bobby) = 3                                     H2(Bobby) = 7 H1(Cathy) = 0                                      H2(Cathy) = 7 H1(Paul) = 7                                        H2(Paul) = 8 H1(Zack) = 2                                       H2(Zack) = 6 H1(David) = 0                                      H2(David) = 1 H1(Eric) = 2                                         H2(Eric) = 3 H1(Fred) = 1                                        H2(Fred) = 1 H1(Harry) = 3                                      H2(Harry) = 8 H1(Owen) = 2                                      H2(Owen) = 0 What are bloom bitmap filters for B1? (length = 10 bits) B1 0 1 2 3 4 5 6 7 8 9 B1 0 _______   B1 1 _______   B1 2 _______   B1 3 _______   B1 4 _______   B1 5 _______   B1 6 _______ B1 7 _______ B1 8 _______   B1 9 _______ Given the set of SS-tables in LSM.          And the hash functions H1(v), H2(v) where v is a search key as: H1(Alan) = 8                                        H2(Alan) = 2 H1(Bobby) = 3                                     H2(Bobby) = 7 H1(Cathy) = 0                                      H2(Cathy) = 7 H1(Paul) = 7                                        H2(Paul) = 8 H1(Zack) = 2                                       H2(Zack) = 6 H1(David) = 0                                      H2(David) = 1 H1(Eric) = 2                                         H2(Eric) = 3 H1(Fred) = 1                                        H2(Fred) = 1 H1(Harry) = 3                                      H2(Harry) = 8 H1(Owen) = 2                                      H2(Owen) = 0 What are bloom bitmap filters for B2? (length = 10 bits) B2 0 1 2 3 4 5 6 7 8 9 B2 0 _______   B2 1 _______   B2 2 _______   B2 3 _______   B2 4 _______   B2 5 _______   B2 6 _______ B2 7 _______ B2 8 _______   B2 9 _______

Given the set of SS-tables in LSM.  And the hash functions H…

Given the set of SS-tables in LSM.  And the hash functions H1(v), and H2(v) where v is a index key value as: H1(Alan) = 8                                        H2(Alan) = 2 H1(Bobby) = 3                                     H2(Bobby) = 7 H1(Cathy) = 0                                      H2(Cathy) = 7 H1(Paul) = 7                                        H2(Paul) = 8 H1(Zack) = 2                                       H2(Zack) = 6 H1(David) = 0                                      H2(David) = 1 H1(Eric) = 2                                         H2(Eric) = 3 H1(Fred) = 1                                        H2(Fred) = 1 H1(Harry) = 3                                      H2(Harry) = 8 H1(Owen) = 2                                      H2(Owen) = 0 Given B1 0 0 1 0 1 1 0 1 1 0 0 1 2 3 4 5 6 7 8 9   B2 0 1  1 1 0 0 1 1 1 0 0 1 2 3 4 5 6 7 8 9 Which one(s) are occurred when searching the following index keys: Cathy, David and Owen?   

According to the following SQL commands run on SQLite3: CRE…

According to the following SQL commands run on SQLite3: CREATE TABLE t(id integer, name text); INSERT INTO t SELECT ABS(RANDOM()%100) AS id, ‘No name’ AS name FROM generate_series(1, 1000); CREATE INDEX name_idx ON t(name); CREATE INDEX id_idx ON t(id); SELECT * FROM dbstat; Using the above table to answer the following questions: If there is RAID level 0 using 3 hard drives for store B+ tree of table t, how many blocks for each drive? _______ blocks

Show the B-Tree Index(m=3) after insert the following input…

Show the B-Tree Index(m=3) after insert the following input index:                    5, 10, 5, 11, 4, 8, 6, 8, 13, 3, 6, 5, 6, 10.                  Note. Please show each steps, not only the final answer.     (Please upload file to answer the question.)