Question: QUESTION 2 Consider data presented in Annex 2. Construct an UB-Tree index on the Time and Product dimensions, which should serve queries as 'How many

QUESTION 2 Consider data presented in Annex 2.

QUESTION 2 Consider data presented in Annex 2. Construct an UB-Tree index on the Time and Product dimensions, which should serve queries as 'How many cell phones did we sell in Q1 and Q2?' For the UB-Tree, consider a size of 5 records for a HDD block. Present the following: a. The Z-curve and the corresponding Z-regions; b. A mapping between the sale ids and the UB index ids; c. How many blocks do we need to access in order to answer the query on the UB Index and how many would we need without it? Annex 2: ID Qty ID_Prod 5 ID_Day 1 1 2 2 1 3 3 1 4 2 2 5 1 3 6 3 2 7 8 1 8 7 1 9 5 2 10 6 1 11 5 3 12 3 3 13 2 3 14 8 4 15 6 2 7 2 16 17 5 4 Year ID Product Group Category 1 Nokia N8 Cell Phones Electronics 2 BlackBerry Bold Cell Phones Electronics 3 BlackBerry Storm Cell Phones Electronics 4 Apple Iphone Cell Phones Electronics 5 Samsung UE46 TV Electronics 6 Panasonic TX50 TV Electronics 7 Philips 46PFL TV Electronics 8 Panasonic TX46 TV Electronics 18 3 4 2010 ID Qtr 1 01 2 02 3 Q3 4 04 2010 19 4 1 2010 20 2 4 2010 21 1 4 QUESTION 2 Consider data presented in Annex 2. Construct an UB-Tree index on the Time and Product dimensions, which should serve queries as 'How many cell phones did we sell in Q1 and Q2?' For the UB-Tree, consider a size of 5 records for a HDD block. Present the following: a. The Z-curve and the corresponding Z-regions; b. A mapping between the sale ids and the UB index ids; c. How many blocks do we need to access in order to answer the query on the UB Index and how many would we need without it? Annex 2: ID Qty ID_Prod 5 ID_Day 1 1 2 2 1 3 3 1 4 2 2 5 1 3 6 3 2 7 8 1 8 7 1 9 5 2 10 6 1 11 5 3 12 3 3 13 2 3 14 8 4 15 6 2 7 2 16 17 5 4 Year ID Product Group Category 1 Nokia N8 Cell Phones Electronics 2 BlackBerry Bold Cell Phones Electronics 3 BlackBerry Storm Cell Phones Electronics 4 Apple Iphone Cell Phones Electronics 5 Samsung UE46 TV Electronics 6 Panasonic TX50 TV Electronics 7 Philips 46PFL TV Electronics 8 Panasonic TX46 TV Electronics 18 3 4 2010 ID Qtr 1 01 2 02 3 Q3 4 04 2010 19 4 1 2010 20 2 4 2010 21 1 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question 2 Consider a random variable T that has a t-dstribution with k - 13 degrees of freedom. What is P(T >-0.6) 0 0.6000 0 0.3821 0 0.4375 0 0.7206 0 0.2794 Question 34 pts Consider a random...

JPMA-01726; No of Pages 12 Available online at www.sciencedirect.com ScienceDirect International Journal of Project Management xx (2015) xxx - xxx www.elsevier.com/locate/ijproman Does Agile work? A...

413-432_CH18_Nachmias.qxd 1/17/07 3:47 PM Page 413 Chapter Index Construction and Scaling Methods INDEX CONSTRUCTION The Purpose of the Index The Sources of the Data The Base of Comparison Methods of...

MKT500 Week 8 Discussion Board 8 attached are the questions, scenario, and supportive reading materials. MKT500 DB 8 "The Importance of Social Media and Web Analytics" 1.) From the scenario,...

1. The year is 2002, and you have been hired as a marketing consultant and given the responsibility of shaping Virgin Mobile USA's advertising strategy. From the case study, describe what Virgin...

What is the best way to apply the evaluation of projects by real options and solve Maria's problem? Approximate the value of a real call (a purchase option for a project), valuing it as if it were a...

4 easy accounting questions and a comfortable due date. Sorry I can't offer any more tutor credit. Thanks in advance! :-) Question 1: A few years ago, a publishing company in the fourth quarter had a...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

For the exclusive use of A. Young NA0232 Daktronics (A): The U.S. Digital Signage Industry in 2010 Joseph Kavanaugh, Sam Houston State University Joshua Warne and Carol J. Cumber, South Dakota State...

Another alternative fuel to be seriously considered is hydrogen. It can be produced from water by various techniques that are under extensive study. Its biggest problem at the present time is cost,...

If y=sin(m sinx), then prove that dy (1-x)y - xy + my = 0, where y = dx andy2 d'y dx

What is the lie factor in this graphics? Thin line, teperaning is milea per tollon in 1 9 9 A , is 0 . 6 incher loeg. This lin, reperenetige as . s miles por pillo in retse is 9 . 3 inder lone. 0 . 6...

Chapter 3 Confidence Intervals (Sample Size) 32-\"? I 1 A political candidate has asked you to conduct a poll to determine what percentage of people support her. If the candidate only wants a 1.59:\"...