Site: http://www.dbms2.com/ Link: http://www.dbms2.com/feed/
by Curt Monash via DBMS 2 : DataBase Management System Services on 5/15/2009 8:01:53 AM
Last month, I wrote “This is a REALLY good time to actively strengthen the MySQL forkers,” largely on behalf of closed-source/dual-source MySQL storage engine vendors such as Infobright, Kickfire, Calpont, Tokutek, or ScaleDB. Yesterday, two of my three candidates to lead the effort — namely Monty Widenius/MariaDB/Monty Program AB and Percona — came together to [...] ...
[ read more ]
by Curt Monash via DBMS 2 : DataBase Management System Services on 5/4/2009 12:03:44 PM
As I hoped, there were some very helpful responses to my post listing ways to improve analytic effectiveness. Here’s a second draft incorporating them. Comments continue to be very welcome. I need to finalize this soon. Analyze more data De-anonymize transactions (e.g., retail store loyalty programs) — yes, this is mainly a 1990s idea, [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 4/22/2009 7:23:59 AM
A DBMS transparency layer, roughly speaking, is software that makes things that are written for one brand of database management system run unaltered on another.* These never seem to sell well. ANTs has failed in a couple of product strategies. EnterpriseDB’s Oracle compatibility only seems to have netted it a few sales, and only [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 4/22/2009 6:04:46 AM
For a guy who doesn’t go to the MySQL conference and routinely gets flamed by the MySQL community for being insufficiently adoring of their beloved product, I sure have been putting up a lot of MySQL-related posts recently. Here’s another, zooming through a few different topics. MySQL 5.4 was announced this week. The highlights seem to [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 4/20/2009 9:41:44 PM
As my first three posts on the Oracle/Sun merger suggested, I think Oracle will do a better job with MySQL product development than Sun has. But of course that’s a low hurdle. And so it leaves open the questions: What should and/or will be the most widely adopted code lines of MySQL (or other open source [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 4/1/2009 6:59:23 AM
I keep not finding the time to write as much about business intelligence as I’d like to. So I’m going to do one omnibus post here covering a lot of companies and trends, then circle back in more detail when I can. Top-level highlights include: Jaspersoft has a new v3.5 product release. Highlights [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 3/21/2009 6:40:20 PM
Internet News offers an overview of how Oracle’s own version of Red Hat Enterprise Linux does or doesn’t different from generic RHEL. The defining example appears to be an alternate file system that Oracle finds useful, but Red Hat doesn’t want to bother offering. (Oracle says it donates all extensions back to the community, [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 3/20/2009 5:31:20 PM
Oracle has introduced what amounts to a half-rack Exadata machine. My thoughts on this basically boil down to “makes sense” and “no big deal.” Specifically: The new Baby Exadata still holds 10 terabytes or more. Most specialty analytic DBMS purchases are still for databases of 10 terabytes or smaller. Large enterprise data warehouse projects are often being [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 3/20/2009 9:10:47 AM
Data warehouse load speeds are a contentious issue. Vertica contrived a benchmark with a 5 1/2 terabyte/hour load rate. Oracle has gotten dinged for very low load speeds, which then are hotly debated. I was told recently of a Greenplum partner’s salesman steering a prospect who needed rapid load speeds away from Greenplum, which seemed [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/26/2009 7:06:27 PM
I’ve talked with a whole lot of vendors recently, some here at TDWI, as well as users, fellow analysts, and so on. Repeated themes include: Large enterprise data warehouse projects are often being deferred or cut back. (My sense is that a little of this happened in 2008, but more is happening with new budget [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/23/2009 6:06:12 PM
Stuart Frost of Microsoft (nee’ DATAllegro) checked in, with Microsoft’s TDWI-timed announcements. The news part was something called “SQL Server Fast Track“, which is the Microsoft SQL Server equivalent to Oracle’s “recommended configurations” or IBM’s “BCUs.” SQL Server Fast Track is further being portrayed as an incremental step toward Madison, Microsoft’s future high-end [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/23/2009 2:32:15 PM
Vertica is virtualizing via VMware, and has suggested a few operational benefits to doing so that might or might not offset VMware’s computational overhead. But on the whole,it seems virtualization’s major benefits don’t apply to the large-database MPP data warehousing. A couple of years ago, I outlined four criteria for when to virtualize. Just to be [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/23/2009 2:31:51 PM
(In other news, the sixth sick sheik’s sixth sheep is sick … but I digress.) It seems that every analytic DBMS vendor feels compelled to issue at least one press release the week of winter TDWI. Vertica’s grand revelation this year is that you can use Vertica with VMware.* Of course, VMware working the way it [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/12/2009 5:44:25 AM
IBM is making DB2, Informix Dynamic Server, and other products available in the Amazon cloud. The press release says test and development are free, while production will be charged at an hourly rate. No doubt more price details will be forthcoming when the whole thing is fully in production. Frankly, I’ve lost track of who all [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/7/2009 11:55:15 AM
I chatted yesterday with the general business side (as opposed to the trading operation) of a household-name brokerage firm, one that’s in no immediate financial peril. It seems their #1 analytic-technology priority right now is changing planning from an annual to a monthly cycle.* That’s a smart idea. While it’s especially important in their [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/6/2009 1:15:18 PM
I’ve now posted a final version of the slide deck* I first posted Wednesday. And I do mean final; TDWI likes its slide decks locked down weeks in advance, because they go to the printer to be memorialized on dead trees. I added or fleshed out notes on quite a few slides vs. the prior [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/4/2009 1:54:20 AM
The most ridiculous analyst study I can recall — at least since Aberdeen pulled back from the “You pay; we say” business — is Winter Corporation’s list of large data warehouses. (Failings include that it only lists warehouses run by software from certain vendors; it doesn’t even list most of the largest warehouses from those [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/2/2009 6:14:51 PM
I’d been promising Intelligent Enterprise editor Doug Henschen an article on Oracle Exadata for months. It’s finally up. For a variety of reasons, it was a lot more work than one might at first guess. One such reason is that it spawned four related blog posts over the past few days. As I post this, there [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 2/1/2009 4:46:44 AM
Ideally, administering a relational database management system should be simple — describe the tables, load the data, and rely on the system to take care of everything else. Complexity comes primarily in two (somewhat overlapping) forms: Manual steps required for the system’s regular operation, that in principle could be automated away, but actually haven’t been. Manual [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 1/27/2009 2:30:37 AM
Chris Maxcer reports that a DB2 storage engine for MySQL is coming soon. But that’s specifically on the i Series — i.e., the heirs of the AS/400 and before that System 38 product lines. While those are arguably the best systems IBM ever produced, it’s still a non-event for most of the IT market. DB2 [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 1/22/2009 5:33:43 AM
A few days ago I tore into the Gartner Magic Quadrant for Data Warehouse DBMS. Well, the 2009 Gartner Magic Quadrant for Business Intelligence Platforms is out too. (Link here. Last year’s here. Hat tip for both to Doug Henschen.) Unlike the data warehouse MQ, Gartner’s BI MQ clusters its “Leaders” together tightly. But while [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 11/21/2008 7:55:31 PM
To a large extent, MySQL lives in two different alternate universes from most other DBMS. One is for low-end, simple database applications. For example, of all the DBMS I write about, MySQL is the one I actually use in my own business — because MySQL sits underneath WordPress, and WordPress is what runs my [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 11/20/2008 1:08:35 AM
When enterprises buy new brands of analytic DBMS, they almost always run proofs-of-concept (POCs) in the form of private benchmarks. The results are generally confidential, but that doesn’t keep a few stats from occasionally leaking out. As I noted recently, those leaks are problematic on multiple levels. For one thing, even if the [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 11/19/2008 11:21:28 PM
Given how the product’s rollout has been handled, it seems necessary to comment on MySQL’s recently released MySQL Query Analyzer without actually having much information on the subject. Mark Callaghan offers a good take — he’s generally very favorable, but notes that MySQL has some limitations that Query Analyzer has trouble getting around. ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 10/24/2008 2:34:56 AM
Carson Schmidt is, in essence, Teradata’s VP of product development for everything other than applications and database software. For example, he oversees Teradata’s hardware, storage, and switching technology. So when Teradata Chief Development Officer Scott Gnau didn’t have answers at his fingertips to some questions about SSDs (Solid-State Drives), he bucked me over to [...] ...
by Curt Monash via DBMS 2 : DataBase Management System Services on 10/23/2008 7:55:18 AM
Once Netezza hit the market, Teradata had a classic “disruptive” price problem – it offered a high end product, at a high price, sporting lots of features that not all customers needed or were willing to pay for. Teradata has at times slashed prices in competitive situations, but there are obvious risks to that, [...] ...
The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.