anuj bhargava wrote:
Hello
I am Anuj and I am working on my final year project for which i need to
understand internals of derby specially locking. I have gone through
transaction and lock modules in derby. but i still didn't get it fully.
Is there any way or tool to trace functioning of derby like when a
transaction comes, which function is used to form query tree and then
optimization , and then how it interacts with lock manager like what
type of lock it gets, which function is used to release locks and then
commit transaction, where updated values before and after updatation
are stored if transaction is update one.
Hello Anuj,
I am not aware of any such specialized tools. My advice would be to
(continue) read the code and see if there are any papers/writeups that
can give you an overview. Then maybe use a debugger to step through a
simple transaction. You can then also change things in the setup, like
the isolation level.
I do not know much about the parser or optimizer, but I do know the
plans are created as generated Java byte code. There is an option to
dump the generated class files so that you can look at them (after using
a decompiler?).
There might be useful information here;
http://db.apache.org/derby/integrate/index.html (look in the left column
under Papers). I recommend looking at Dans presentation from Colorado
2004 (Software Summit).
Sorry I can't help you more, but maybe someone else will add some
valuable input. I think many people on the list are in release or
vacation mode, so a little patience and a reminder might pay off :)
Just out of curiosity, which version of Derby have you been studying?
There has been some changes in the areas you are looking into.
regards,
--
Kristian
Thx in anticipation
Anuj
