SQL Feeds - All your SQL feeds in one place.

Sponsors

Feed: DBMS 2 : DataBase Management System Services

Site: http://www.dbms2.com/ Link: http://www.dbms2.com/feed/

Friday, May 15, 2009

MySQL forking heats up, but not yet to the benefit of non-GPLed storage engine vendors

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 ]

Monday, May 04, 2009

37 Ways To Get More From Analytics, Version 2.0

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, [...] ...

[ read more ]

Wednesday, April 22, 2009

DBMS transparency layers never seem to sell well

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 [...] ...

[ read more ]

MySQL miscellany

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 [...] ...

[ read more ]

Monday, April 20, 2009

This week is a REALLY good time to actively strengthen the MySQL forkers

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 [...] ...

[ read more ]

Wednesday, April 01, 2009

Business intelligence notes and trends

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 [...] ...

[ read more ]

Saturday, March 21, 2009

Why should anybody worry about Oracle’s tweaks to Red Hat Enterprise Linux (RHEL)?

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, [...] ...

[ read more ]

Friday, March 20, 2009

Oracle introduces a half-rack version of Exadata

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 [...] ...

[ read more ]

Greenplum claims very fast load speeds, and Fox still throws away most of its MySpace data

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 [...] ...

[ read more ]

Thursday, February 26, 2009

Data warehousing business trends

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 [...] ...

[ read more ]

Monday, February 23, 2009

Microsoft SQL Server Fast Track

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 [...] ...

[ read more ]

Microsoft SQL Server Fast Track

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 [...] ...

[ read more ]

The questionable benefits of terabyte-scale data warehouse virtualization

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 [...] ...

[ read more ]

The questionable benefits of terabyte-scale data warehouse virtualization

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 [...] ...

[ read more ]

Vertica Virtualizes Via VMware

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 [...] ...

[ read more ]

Thursday, February 12, 2009

IBM in the cloud

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 [...] ...

[ read more ]

Saturday, February 07, 2009

Analytics’ role in a frightening economy

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 [...] ...

[ read more ]

Friday, February 06, 2009

Final (for now) slides on how to select a data warehouse DBMS

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 [...] ...

[ read more ]

Wednesday, February 04, 2009

Winter Corporation on Exadata

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 [...] ...

[ read more ]

Monday, February 02, 2009

Oracle Exadata article — up at last

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 [...] ...

[ read more ]

Sunday, February 01, 2009

Simplicity in analytic database management systems

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 [...] ...

[ read more ]

Tuesday, January 27, 2009

DB2 engine coming soon for MySQL — but that’s DB2 on the iSeries

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 [...] ...

[ read more ]

Thursday, January 22, 2009

Gartner’s 2009 Magic Quadrant for Business Intelligence

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 [...] ...

[ read more ]

Friday, November 21, 2008

High-end MySQL use

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 [...] ...

[ read more ]

Thursday, November 20, 2008

Interpreting the results of data warehouse proofs-of-concept (POCs)

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 [...] ...

[ read more ]

Wednesday, November 19, 2008

MySQL Query Analyzer

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. ...

[ read more ]

Friday, October 24, 2008

Carson Schmidt of Teradata on SSDs

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 [...] ...

[ read more ]

Thursday, October 23, 2008

How to tell Teradata’s product lines apart

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, [...] ...

[ read more ]

Legal Note

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.

Advertise with us