[REBOL] Re: KDB was {Re: Re: dbms3.r 0}
From: jason:cunliffe:verizon at: 18-Jan-2002 13:31
> JC> <quote>
> JC> Why is Kdb so fast?
> JC> The main reason is that Kdb tables are "inverted", i.e. the
> JC> data in each column is stored together, instead of in the row
> JC> orientation used by most RDBMS's. The column data is also
> JC> organized for optimal processing speed. </quote>
>
> Well, that's like having all columns indexed. It's nice when
> you'll be searching an all columns with the same frequencies, I'm
> not sure in other cases (in paticular, inserts and updates will be
> much slower).
I don't know about that. Kdb is incredibly fast [and small] and scales well.
It really is worth downloading the demo and taking it for a testdrive,
especially with its built in http port. Like I said, its very rebolistic. I
am not proposing we use it directly, but yes for hands.on inspiration.
The desing aspect which I think is most relevant to your work, is the way
Dkb is built on top of the K data analysis language. This is what strikes me
as rebolistic.
Your preference for REBOL base structure is entirely in keeping with this.
Looking over the K and Kdb docs and playing around with the demo
interactively certainly encourages one to think differntly about the rdb
dialect set which might be possible and desirable. That may be puting the
cart before the horse, or it might be a viable alternative.
regards
./Jason
PS. I proposed to install a vanilla site to help rdbms3r. Have been
rebuilding our server but ran into nasty scsi motherboard problem.
Mercifully now sleuthed and fixed, so hope to have be back online next week.
I'll be able to focus on using it then, instead of building it :)
