Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: University Assignment

Re: University Assignment

From: Martin Haltmayer <Martin.Haltmayer_at_d2mail.de>
Date: Sun, 23 Dec 2001 19:15:12 +0100
Message-ID: <3C261F30.53FA93C0@d2mail.de>


Hi Ben,

a problem that pops up again and again in the emerging Internet application area is the problem of scrolling forth and back through a cursor in a dialogue application. If this seems to simple then add a positioning statement before.

Example: you may have a table of your customers (custno, custname). Your primary key is custno. You define a unique key on (custname, custno). Now you want to have a dialogue application that allows you to position to the first customer starting with the strings "Ab". You may find "Abraham". Now you want to press the "next" button that may show you "Absalom". Then you want to press the "previous" button to get "Abraham" again. Then you want to press "previous" and you want to receive "Abigail". Now do this for a customer table of 1,000,000 customers and 1,000 concurrent sessions. This is a challenge.

This simple example turns out to be a nightmare if you not only have the surname but the firstname as well. You may have an unique index (custname, custfirstname, custno).

Another example is word search in text strings. For simplicity assume you have texts up to 4,000 characters wide. You want to allow for case insensitive searches for complete words without using Intermedia text (which has a lot of problems, especially with foreign umlauts). What auxiliary tables and indexes do you need to allow for a fast search method if you want to be able to search for several words with an AND condition? How do you eliminate "stop words", i. e. words that do not contribute to the selectivity of your search? Can you automate the creation of stop word lists?

Regards,

Martin

Ben wrote:
>
> Hi!
>
> If any Oracle experts could help me, I'd be very grateful! Just
> received a uni assignment on Tuning Techniques for Orcacle 8i. What we
> need to do is evaluate some performance aspect of Oracle, for example
> indexing, clustering, normalisation and query complexity. We need to
> pick a suitable research question, set up the experiment: designinga
> suitable data model and query set, build the database and generate
> data (100,000 + records has been advised).
>
> I was hoping someone would be able to offer some advice, as to what
> the best performance aspect is that I could carry out and what the
> best way would be to conduct it (generating the data too!!). If there
> are any good urls, (or even if someone has done what I need!!!!) I'd
> also be very interested to see. It's a case of setting the experiment
> up, and goign to uni and conducting the experimetns at different times
> of the day (network performance also needs to be taken into
> consideration).
>
> If anyone has any great ideas, please get back to me.
>
> Cheers!
Received on Sun Dec 23 2001 - 12:15:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US