Re: Evaluating the performance of ORACLE 10 DBMS - Any ideas on a research question?

Read240_at_hotmail.com wrote:
> Hello,
>
> I have been asked to evaluate a performance aspect of ORACLE 10 DBMS,
> e.g. clustering, indexing, normalization, query complexity.
>
> I have been asked to pick a research question the following example has
> been given "does indexing improve query performance?".

Wow that's a really good question ( kidding ).

Probably the answer is " it depends " ... if you index the correct field in the correct manner and have relevant queries against it ... what do you think?

Doing some work that involves examing transaction based query performance against several variations of a normalized versus un-normalized design might be a good topic.

You should be able to google around and find some good ideas in that area. Try looking at http://asktom.oracle.com

>
> Once I have picked a question I shall design a data model and query set
> to generate data and run the experiment.

I would think you want to have a scope, a context, some background assumptions and some conjectures.

>
> Does anyone have any ideas on significant research questions I will be
> marked on the reasons why i believe the question is significant.

Is the above a sentence?

>
> Thank You
Received on Thu Jan 18 2007 - 12:06:47 CST