DBMS on SWiK

SQL Buddy - Web based MySQL administration

Mon, 18 Aug 2008 23:36:51 -0700

Let's be honest – managing a database isn't terribly exciting. But you still want to use a product that looks half-decent and is intuitive to use. SQL Buddy was designed to meet the demands of modern web developers. Oh, and did I mention that its completely open source and free for everyone to use?

PostgreSQL vs EnterpriseDB: Hypocritical Crap?

Fri, 08 Aug 2008 05:09:18 -0700

Custom schema generation with Hibernate annotations - Java World

Fri, 08 Aug 2008 04:07:21 -0700

Dare Obasanjo aka Carnage4Life - Project Cassandra: Facebook's Open Source Alternative to Google BigTable

Mon, 14 Jul 2008 12:46:17 -0700

Welcome Back!

Mon, 14 Jul 2008 05:45:01 -0700

Apache Derby

Thu, 10 Jul 2008 13:49:41 -0700

PostgreSQL: The world's most advanced open source database

Wed, 09 Jul 2008 13:51:59 -0700

Query Processing at Light Speed

Mon, 07 Jul 2008 06:53:42 -0700

Query Processing at Light Speed

Mon, 07 Jul 2008 06:49:21 -0700

Query Processing at Light Speed

Wed, 18 Jun 2008 10:21:55 -0700

IBM may open-source DB2

Mon, 16 Jun 2008 07:19:15 -0700

PostgreSQL and XML updated

Fri, 13 Jun 2008 14:19:31 -0700

PostgreSQL and XML updated

Fri, 13 Jun 2008 14:17:17 -0700

Query Processing at Light Speed

Tue, 10 Jun 2008 12:13:28 -0700

MonetDB is a open-source database system for high-performance applications in data mining, OLAP, GIS, XML Query, text and multimedia retrieval.

Query Processing at Light Speed

Tue, 10 Jun 2008 12:13:03 -0700

MonetDB is a open-source database system for high-performance applications in data mining, OLAP, GIS, XML Query, text and multimedia retrieval.

Enterprise Open Source Database - Ingres

Sat, 07 Jun 2008 03:55:09 -0700

Greenplum - World's Best Database for BI

Thu, 29 May 2008 16:49:42 -0700

EnterpriseDB unveils the Postgres Plus story

Mon, 24 Mar 2008 05:48:35 -0700

EnterpriseDB is making a series of moves and announcements. Highlights include:

Renaming/repositioning the product as ?Postgres Plus.? The free product is now Postgres Plus, while the version you pay EnterpriseDB for is now Postgres Plus Advanced Server.
Repackaging the products, so that Postgres Plus Advanced Server is a strict superset of Postgres Plus.
New features added to Postgres Plus Advanced Server.
Features newly migrated from Advanced Server down to Postgres Plus.
A strategic investment by IBM.
Stressing Postgres in EnterpriseDB marketing, and dropping the tag-line defining themselves as ?the Oracle-compatible database company.?

So far as I can tell, most of the technical differences between Advanced Server and regular Postgres Plus lie in three areas:

Oracle compatibility
Automated tuning, under the name Dynatune
Transaction-timing performance features, such as bulk load and bulk commit

Significant technology in Postgres Plus ? much of which was previously available in EnterpriseDB Advanced Server — includes:

Automated installation tuning
GridSQL ? lightweight MPP data warehousing, originally acquired via the small acquisition of ExtenDB
Outside-the-DBMS memcache, which now works on an automatic least-recently-used basis just as one would expect it to.

And, to my great joy — somewhere in the product line (I’m not sure where) is MySQL compatibility.

One obvious question comes to mind: ?Why wasn’t the free version always just a subset of Advanced Server?? The answer is that the free/open source version was getting its patches quickly ? i.e., right in line with PostgreSQL — while the chargeable enterprise version was being held back for testing. EnterpriseDB estimates the time lag in that at roughly six months or so. To get the products’ schedules aligned, EnterpriseDB now seems to be splitting the difference, with Postgres Plus getting patches somewhat more slowly than PostgreSQL, and Advanced Server’s testing cycle being shorter than it used to be.

Please subscribe to our feed!

Technorati Tags: Postgres

IBM discontinues the solidDB MySQL engine

Mon, 10 Mar 2008 23:46:09 -0700

Last year, I thought that solidDB could at least potentially be an outstanding MySQL engine. But as per news posted on SourceForge last week, that’s not going to happen. At least, it’s not going to happen via any development efforts from IBM.

Please sign up for our feed!

Database management system choices ? mid-range-relational

Sun, 17 Feb 2008 22:44:59 -0800

This is the fourth of a five-part series on database management system choices. For the first post in the series, please click here.

The other threat to the high-end relational DBMS vendors aims squarely at the heart of their business. It’s the mid-range relational database management systems, which are doing an ever-larger fraction of what their high-end cousins can. That said, different products do different things well. So if you’re not blindly paying up for the security of an all-things-to-all-people high-end DBMS, there are a number of factors you might want to consider.

Need for attention. High-end OLTP DBMS generally need a lot of DBA attention. Mid-range products generally need less, sometimes a lot less. Most are newer or less-featured than the leading high-end products; either way, they’re apt to be simpler. And some are specifically designed to be used in OEM or embedded situations where DBAs may not be available.
Administrative tools. The flip side of administrative ease is administrative tools. Here the high-end products are generally ahead of the mid-range ones, and different mid-range products have different available tool sets. Part of Microsoft’s initial success in DBMS was due to better tools, thanks to their PC-oriented usability labs. Oracle later hired away Borland’s usability guru Dan Rosenberg, who helped narrow the gap.
Performance for the feature set you’ll use. Most relational OLTP DBMS have similar performance for simple applications running on single processors. But not every feature of every DBMS is equally well-tuned. Declarative referential integrity, replication, etc. can show considerable performance variations, especially among less-established products. And that’s just for tabular data. If you look at non-tabular datatypes, performance can vary greatly.
Scalability. While single-processor performance is pretty comparable among OLTP DBMS, scalability is whole different matter. Some struggle at 8 cores. Others go much higher.
Price and license terms. PostgreSQL and MySQL can be had for free. (At least for licenses; support is another matter.) Alternate versions of both cost money, but are much less expensive than, say, Oracle ? unless, of course, your enterprise already has an all-you-can-eat enterprise license. License and maintenance costs vary widely among DBMS products, and also vary greatly for the same products among different enterprises.

We’ve recently had some lively discussions of mid-range database management systems. Rather than try to recapitulate them, I’ll just link you back.

The case for mid-range DBMS.
The case against mid-range DBMS. This one generated a lot of flames.
A call for application examples that might clarify (or invalidate) my mid-range/high-end distinction. The replies were interesting, both for what they did include and what they didn’t.

The complete series

Please subscribe to our feed!

Technorati Tags: MySQL, PostgreSQL

EnterpriseDB on Elastra, early stages

Thu, 14 Feb 2008 06:46:00 -0800

I finally caught up with Bob Zurek about EnterpriseDB’s foray into the Elastra cloud. Here are some highlights:

There have been dozens of applicants for the EnterpriseDB/Elastra beta program. As is usual in limited beta programs, EnterpriseDB is trying to sort out the ones who’ll make a big commitment from the tire-kickers.
The main interest in EnterpriseDB/Elastra has come from ISVs, and secondarily from purely online businesses (e.g., SaaS vendors, web businesses, and a large MMO game vendors). There’s been a little interest from enterprises.
Significant fractions of the EnterpriseDB/Elastra beta applications come from each of the Oracle, PostgreSQL, and MySQL user communities. A few come from SQL Server. None come from DB2.
Bob praised Elastra for its technology in clustering, starting/stopping instances, etc. He also said that EnterpriseDB had “educated” Elastra on EnterpriseDB internals and/or admin tools, to make the integration work.
EnterpriseDB will start turning on a few beta Elastra customers any day now (i.e., it may well not take until March, the original target).

Please subscribe to our feed!

EnterpriseDB joins Elastra in the Amazon cloud

Thu, 31 Jan 2008 13:14:20 -0800

When Elastra announced their service to host MySQL and PostgreSQL in the Amazon S3/EC2 cloud, I immediately told my dear darling clients at EnterpriseDB they should do the same. Whereupon they told me it would happen soon. However, they neglected to tell me when it was actually announced. So I know no more than can be found in this Computerworld article.

But I’ll say this — it’s a very tempting option, both for new web-based applications or businesses, or simply as a development platform pending later redeployment.

[from rozza] Database gurus slammed for Google post

Fri, 25 Jan 2008 02:11:46 -0800

MapReduce: a "major step backwards"

Capabilities - Apatar - Open Source Data Integration & ETL

Thu, 24 Jan 2008 20:04:11 -0800

ozone

Thu, 24 Jan 2008 18:11:32 -0800

ozone is a fully featured, object-oriented database management system completely implemented in Java and distributed under an open source license. The ozone project aims to evolve a database system that allows developers to build pure object-oriented, pur

14 reasons not to use MySQL or other mid-range database management systems

Thu, 24 Jan 2008 16:03:04 -0800

I may argue for the use of open source and other mid-range database management systems, but a lot of industry sentiment remains on the other side. Vendors of high-end RDBMS naturally advocate enterprise-wide single-vendor adoption. Many CIOs and industry analysts, overwhelmed by product proliferation, think that’s a neat idea as well.

And in fairness, they’re not entirely wrong. Here are 14 reasons for using high-end relational database management systems, even on applications for which mid-range DBMS would suffice. (more…)

ContentBlogger: Beyond Search Engines: The Database is Now - Shore Communications Inc. - Commentary - Weblogs

Thu, 24 Jan 2008 12:13:19 -0800

eXist

Thu, 24 Jan 2008 02:12:16 -0800

Open Source Native XML Database

Ronald Bourret - XML and databases

Wed, 23 Jan 2008 04:35:37 -0800

Articles and software for storing XML data

Query Processing at Light Speed

Fri, 18 Jan 2008 08:57:34 -0800

<sep/>MonetDB is a open-source database system for high-performance applications in data mining, OLAP, GIS, XML Query, text and multimedia retrieval. MonetDB often achieves a 10-fold raw speed improvement for<sep/>