yzc888

              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.

                          Foreign exchange

                          Finance

                          game

                          image

                          Second-hand housing

                          culture

                          video

                          Variety show

                          news