RE: {Spam?} RE: Can I optimize the engine here or do I have to get the developers to change the SQL?

> Date: Sun, 8 Nov 2009 11:20:02 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: {Spam?} RE: Can I optimize the engine here or do I have to get the developers to change the SQL? > > Ian Michael Gumby wrote: [SNIP] > > Ah, you don't really know how the time series datablade works, do you? > > So if you think about it, a column oriented datablade would use a lot of > > the same basic concepts in terms of memory and page storage. > > Really. Gosh, well, who would have thunk that a column oriented > DataBlade would also use memory and pages? Certainly not me. > Well the point is that you're not starting from scratch and that the lessons learned from implementing time series could be used to create a column oriented data type. > > Yeah there's more to it and the distributed query management would be > > different, but IDS would be the easiest database to implement these > > concepts. > > Yeah, apart from those minor issues, huh? And one other minor issue: who > wants this shit apart from you? > Hmmm. That's a good question. I mean if you ask who's looking at HBase, there's a lot of interest. If you're asking who's going to be interested in a database that can handle column oriented data and work in parallel to HBase? It will depend on cost, scalability and performance. Because you have a high cost per node when considering a database, you have to show that there is performance. The compelling reason why you want this is because when you're done doing a map reduction, then ending set of data could be used within the relational database. Even if you keep it within the HBase column oriented database, can you outperform HBase on its own. This isn't something you can simulate and extrapolate its performance, you have to build it, al least in terms of a POC. > > While you may see this as an abomination, others have been very > > successful in implementing this. > > Yeah, it's taking over the RDBMS market. Oracle for one are absolutely > shitting themselves. > Yeah, someone said Oracle was announcing something along the lines of a column oriented data type. Not sure and if only our favorite Oracle wonk posted here... ;-) But still Oracle will develop something, but that doesn't mean that it will work, or work well enough. I mean... there's this thing called Oracle RAC... :-) -G _________________________________________________________________ Windows 7: Unclutter your desktop. http://go.microsoft.com/?linkid=9690331&ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen:112009