金皇朝|2

                              June 5, 2010

                              Algebraix

                              I talked Friday with Chris Piedemonte and Gary Sherman, respectively the Cofounder/CTO and Chief Mathematician of Algebraix, who hooked up together for this project back in 2003 or 2004. (Algebraix is the company formerly known as XSPRADA.) Algebraix makes an analytic DBMS, somewhat based on the ideas of extended set theory, that runs on SMP (Symmetric MultiProcessing) boxes. Like all analytic DBMS vendors, Algebraix has on some occasions run some queries orders of magnitude faster than they ran on the systems users were looking to replace.

                              Algebraix’s secret sauce is that the DBMS keeps reorganizing and recopying the data on disk, to optimize performance in response to expected query patterns (automatically inferred from queries it’s seen so far). This sounds a lot like the Infobright story, with some of the more obvious differences being:? Read more

                              June 5, 2010

                              Extended set theory, aka “What is a tuple anyway?”

                              The Algebraix folks are trying to repopularize David Childs’ idea of “Extended set theory.” In a nutshell, the extended set theory idea is:

                              A tuple is a set of (field-name, field-value) pairs.

                              I’ve been fairly negative about the extended set theory concept – but in fairness, that may be because I misunderstood how other people thought of tuples. Any time I’ve had to formalize what I thought of a tuple as being, I came up with something very much like the above, except that if one wants to be relational one needs a requirement like:

                              In any one tuple, each field-name must be unique.

                              In line with that definition, I’d say a table is something like:? Read more

                              Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

                              Login

                              Search our blogs and white papers

                              Monash Research blogs

                              User consulting

                              Building a short list? Refining your strategic plan? We can help.

                              Vendor advisory

                              We tell vendors what's happening -- and, more important, what they should do about it.

                              Monash Research highlights

                              Learn about white papers, webcasts, and blog highlights, by RSS or email.

                                                          constellation

                                                          city

                                                          culture

                                                          city

                                                          Mobile phone

                                                          search for

                                                          Celebrity

                                                          Variety show

                                                          Finance