Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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 :)