May, 2009
About DATallegro, the mythology of Ingres, opened the source,etc.
Sometimes, talk of a company of the competitor regarding one are close, possibility that one hear 100% strict and accurate. At yesterday, I statement sent out to hear peculiar to like ATallegro must open source it development no matter what it will be software more than once. Today, DATallegro CEO Stewart verifies frost as follows:
DATallegro have ‘ little? ) Open source anything voluntarily in law. Even if the edition of Ingres which they used is not GPL one.
They really return some and improve to Ingres (pass the source made? ) But not maintain them in person.
Whole MPP technology be had specially, no matter how be roprietary. (For example, compared with Ingres, they use the whole different optimists. Forget Ingres optimist is sow even in appropriate ... Read more
Are the data storing all regarding the order is entered in the warehouse now?
A lot of evidences point to a main example to move in the datum RDBMS warehouse, along the line:
Old way: Assume I/O is random; Through improving the alternative, so the low quantity of reducing the total amount of I / O. implements time
New way: To a near a total amount of driving random I/O, and so many order I/Os needed reach this goal.
The example includes:
Data warehouse utensil (see this discussion of special DATallegro building)
System of the special column (see Nathan the first opinion uses medicines in this very much to step in the discussion of the technological prototype of the amazing requirement)
The system of the memory of centre, especially the accelerator of Belfort Instrument Company of juice
Those hardware logic f... Read more
On Teradata and technology, new utensil seller
Today, give generously on Todd and Walter of Teradata and rude meadow, avoid their user’s meeting, and share the extremely little periodical that they transported and is discussed to be recent here. Stand up always, Teradata response to data warehouse utensil guy basically: Strategic point, those may be suitable for interrogating specifically well, or is suitable for the market of data, but preponderate extremely small in the true work load of mediating the data warehouse of enterprises, included in performance of li.
The concrete one buys back the food eaten to include:
From 2002, Teradata has a ylinder readoption, allow to become grains to read in the size of 2 million bytes compared with that can have been done with DATallegro or Netezza all the time coarsely. ... Read more
Greenplum compare with some introductions /forming contrast
Netezza reliance FPGAs. DATallegro use standard component basically, those include Infiniband card (and a little FPGA of theys make there of action that encrypt) . Greenplum, but claim, offer one used in software you can download very competitive datum warehouse solution of it from their website only so so. That says, their main marketing method seems it is through the utensil too, what the sun criticizes and sells especially things, combine Greenplum and open the software of source on humperbox. And those anything whole, according to the scale of inferring than DATallegro and Netezza high, because if you fasten a dozen 100 terabyte shelf with the chain together, you can deal with in petabyte.
Like take place on leading telephone often, I with talk one claim I person who ... Read more
Data warehouse utensil
If we confirm a ata applianceas special-purpose computer system warehouse, there are utensil administratibilities, manage a datum warehouse, there are two main competitors: Netezza and DATAllegro, begin twice, with two of user revealing on a small quantity. Seemed been just amalgamated competitor Teradata and pale cross into Kognitio ,But the two will not lead to today on that market. (I Suspect this in Teradata a mistake at the part, but it is too.) Though IBM certainly perceives the utensil match, IBM with DB2 any one in the two on z series wouldn is considered correctly to be utensil athletes. The accelerator of Belfort Instrument Company of juice does not insist on saying the data in this period.
In principle, Netezza similar to DATAllegro story spends and sets up and... Read more
Really big databases
Business Intelligence Lowdown has a well-dugg post listing what it claims are the 10 largest databases in the world. The accuracy leaves much to be desired, as is illustrated by the fact that #10 on the list is only 20 terabytes, while entirely unmentioned is eBay’s 2-petabyte database (mentioned here, and also here). Only two phone companies were listed, and no credit-raters. And for some databases listed, the size given seemed too low. E.g., for Google I’d guess that the average page size it indexes is 10K+ (vs. the 100K or so maximum), even with all the junk stuff in there, so it’s in the 100s of terabytes at a minimum, for raw data alone before considering indexes and so on.
Oracle, IBM, Teradata, Netezza, and DATAllegro have plenty of customers each above the 20 terabyte ... Read more
Bulletin on Cogito
My Bulletin on Cogito — i.e., a short-short white paper — is now available for download. Thankfully, it turned out to be pretty consistent with what I previously wrote on the company and its technology. The conclusion to the paper bears quoting here:
In deciding between conventional DBMS and specialty graph-oriented tools such as Cogito’s, there’s one key criterion: Path length. If path lengths are short and predictable, there’s a good chance that relational DBMS and their forthcoming extensions can do the job. In complex graphs with longer paths, however, relational approaches may not scale well. In such cases, specialty technologies warrant serious consideration.... Read more
IBM’s Oracle emulation strategy reconsidered
I’ve now had a chance to talk with IBM about its recently-announced Oracle emulation strategy for DB2. (This is for DB2 9.7, which I gather has been quasi-announced in April, will be re-announced in May, and will be re-re-announced as being in general availability in June.)
Key points include:
This really is more like Oracle emulation than it is transparency, a term I carelessly used before.
IBM’s Oracle emulation effort is focused on two technological goals:
Making it easy for an Oracle application to be ported to DB2.
Making it easy for an Oracle developer to develop for DB2.
The initial target market for DB2’s Oracle emulation is ISVs (Independent Software Vendors) much more than it is enterprises. IBM suggested there were a couple hundred ear... Read more
Clearing some of my buffer
I have a large number of posts still in backlog. For starters, there are ones based on recent visits with Aster, Greenplum, Sybase, Vertica, and a Very Large User. I suspect I’ll write more soon on Oracle as well. Plus there’s my whole future-of-online-media area. And quite a bit more will grow out of planned research.
So there are a whole lot of other worthy subjects I doubt I’ll be getting to any time soon. In some cases, of course, other people are doing great jobs of writing about same. Here are pointers to a few links that I am glad to recommend:
I wrote recently that I’ve discovered a number of different in-memory OLAP engines. Cindi Howson far outdid that, writing at length for Intelligent Enterprise on in-memory analytics, in an article that seems to itse... Read more
OLTP database management system market – the consensus isn’t ALL wrong (deck-clearing post #1)
Most of what I’ve written lately about database management seems to have been focused on analytic technologies. But I have a lot to say on the OLTP (OnLine Transaction Processing) side too. So let’s start by clearing the decks. Here’s a list of some consensus views that I in essence agree with:
Oracle is the top of the line, and has nothing wrong with it other than cost of ownership and the non-joys of doing business with Oracle Corporation.
DB2/mainframe is a fine product, but only if you like IBM mainframes.
DB2/open systems is another fine product, but it’s hard to think of reasons to use it over Oracle.
Microsoft SQL Server has great cost of ownership if you’re a Windows (server) shop anyway, especially on the administrative side. It does most but not... Read more
