Blog

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.)