Re: mini database - educational project

"Matias Woloski" <woloski_at_sion.com> wrote in message news:bij7uh$a918l$1_at_ID-148083.news.uni-berlin.de...
> > > The first will be faster and easier to implement but it has the
downside
> > of
> > > depend on the RAM of the system. The second will work on every
scenario
> > but
> > > will be much slower than the first considering it will work with
files.
> >
> > If you say "academic", then forget about the "file". Main memory
database
> > even more theoretically legitimate then file based.
>
> I don't think I understand. You are saying that I should stay out of a
file
> based approach? why? can you give me more arguments?
> I'm really thinking about doing it file based because of the memory
> restriction. Apart from that the profesor warn us about that: "You could
> have a 2gb table stored in the file system, so you won't be able to load
the
> whole in memory"
>
> Now you would say "so you have no option". That's not completly true,
> because when they evaluate the solution, they do some tests and you have
to
> pass more than 60% of the tests. So maybe one or two tests are big files,
> but the other tests other functionality. I hope you understand ...

The question to ask is whether you write cache subsystem or a system that answers queries. I thought that RDBMS means the latter. Received on Wed Aug 27 2003 - 23:46:25 CEST