| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Query execution for intervals
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
![]() |
![]() |