DMG Forums | Project 2 discussion
DMG Forums >> 6th Semester >> CSEN 604 - Databases II >> Project 2 discussion Page of 3
Project 2 discussion
Author Topic
mohamed.hazem@student.guc.edu.eg

Student

Join Date: 10/18/2008
Posts: 4

Posted: 5/8/2009 2:13:39 PM

Quote:
Quoted From Muaz.Al-Jarhi@student.guc.edu.eg:

Tell me how are you going to use the BasicQueryPlanner? arent you going to use the mehod inside it which is createPlan(QueryData data, Transaction tx)? else how will you use it? Of-course you know that it has only this method.



You don't need to call the createPlan() method explicitly, the db handles all the logic for us .. We just need to extract certain info as I said before .. you can use the instance "p" to access the methods you need .. like p.blocksAccessed() and so on ... please read the code of the BasicQueryPlanner and understand how it works ... and after all, maybe I'm wrong :-)
fatma.meawad@guc.edu.eg

GUC Faculty

Join Date: 10/7/2008
Posts: 14

Posted: 5/8/2009 8:50:02 PM

Muaz,

Hazem's comment are correct. You don't need to do all this. You don't need to do all this. Simpledb.planner().CreatePlan (....) is what starts the simpledb processing of any query (through basic or heuristic) and it takes a string of a query. You don't handle a query data at all, you can send a new empty transaction or u can create a transaction. There are many ways to start this but none of them requires you to interfer in the processing of the query or even worry about it. You just need to trace it and visualise it (print it to a GUI in a form of a tree)
Muaz.Al-Jarhi@student.guc.edu.eg

Student

Join Date: 10/16/2008
Posts: 6

Posted: 5/8/2009 9:58:24 PM

What is the total cost of a query process? How to get it?
fatma.meawad@guc.edu.eg

GUC Faculty

Join Date: 10/7/2008
Posts: 14

Posted: 5/8/2009 11:36:31 PM

Muaz,

since simpledb does very naive cost estimation, all what you can do is just add up, the total block accesses for each operation and display it.
It is far from accurate but that is the only logical thing to do.
ayman.al-serafi@student.guc.edu.eg

Student

Join Date: 10/12/2008
Posts: 1

Posted: 5/9/2009 12:47:59 AM

Phew!!!!! That was one of the most annoying, longest, difficult project in my 3 years of university. Too much thinking required, too little time.

I have to confess though that I have learned A LOT from doing this project, but in the hardest way possible, and with the help of my supportive group members and MET friends (If only we had some tutorial about this project it would have been a good kickoff.)

I just want to share the thought with you guys once I have submitted the work I can do in a very few time (6 days!) My outcome was not the best visualiser expected ever! :-D It is a silly little program that prints some simple labels with some data...but the amount of brainwork spent to produce this was enormous. :-)

How was your experience guys?? :-( or :-)
ibrahim.el-sayed@student.guc.edu.eg

Student

Join Date: 10/10/2009
Posts: 1

Posted: 11/21/2009 8:41:50 AM

« First    « Previous Page of 3   


RenewSession