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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Query execution for intervals

Re: Query execution for intervals

From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 6 Feb 2006 10:01:00 -0800
Message-ID: <1139248860.609378.165550@g47g2000cwa.googlegroups.com>


frebe73_at_gmail.com wrote:
> I am writing a calendar client application. I am trying to decide if
> the calendar data should be managed by an emedded RDBMS (hsqldb) or
> just using ical text files (using ical4j). Using ical files I will have
> to traverse every event to find out if it should be displayed in the
> view. Are you saying that using a RDBMS, the query engine also has to
> traverse the evernt in a linear way? From this aspect, would you
> recommend ical files or a RDBMS?

I believe bitmapped indexes behave in linear way, although with very generous coefficient. Don't know about R-Trees. I suggest you to experiment with db queries before making any design decision. Received on Mon Feb 06 2006 - 12:01:00 CST

Original text of this message

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