Tuesday, August 28, 2007

EnterpriseDB Webinar Recording - From Oracle to EnterpriseDB: An Oracle ACE's Journey

Well, the webinar has been done. The recording has been posted to something called Jumpcut. This is video and audio. Check it out and give me feedback.

If that doesn't play for you, you can watch it on Jumpcut, From Oracle to EnterpriseDB: An Oracle ACE's Journey.



Saturday, August 25, 2007

Bruce Momjian Interview in InformationWeek

InformationWeek has a good interview with Bruce: Open Source PostgreSQL Developer Bruce Momjian Spills The DB Beans.

In the interview, Bruce talks about how he spends one day a week at the EnterpriseDB site but most of his time working on Postgres.

There aren't a lot of quotes in the interview. I wonder if a longer interview is coming.

There are a few anti-comparisons between "bearded sage" Momjian and JBoss' Marc Fleury and, of course, the obligatory comparison to MySQL.

PostgreSQL sought to match major relational database systems and afterward addressed performance. "We didn't focus on performance until the end. MySQL had that right at the start," he acknowledges.

It's a short read but worth the time.


Wednesday, August 22, 2007

EnterpriseDB Webinar

I did the EnterpriseDB Migration webinar today. The webinar was recorded and will be posted on the EnterpriseDB web site. I'll update this post with a link as soon as it is.

I think it went well. Derek had a family emergency and was not able to participate but his stand-in Matthew Bennett knew his stuff. He did the intro and then the follow up. We both answered questions.

There were some really good questions. I will try to cover some those here, in the future. For now, you can view the powerpoint presentation.

I really like the plug. That's kind of a cool image.

Take care,


Sunday, August 19, 2007

EnterpriseDB Compatibilty features

A question that I am asked very often it exactly what features are compatible between EnterpriseDB and Oracle. The short story is that the areas that you think of as "development", i.e. SQL, Code, etc are the areas where the compatibility exists.

Maintenance tasks are generally familiar as is the overall architecture. Any modern database will have logging, recovery, backups, etc. In EnterpriseDB, the way you code an application will be compatible with Oracle and the maintenance of an EnterpriseDB database will be familiar.

EnterpriseDB has published a white paper called, Delivering Oracle Compatibility. This paper outlines the exact points of compatibility very succinctly. I hope they keep it updated for each release.

This bulleted list from the white paper outlines it pretty well:

  • Oracle SQL Compatibility. EnterpriseDB Advanced Server executes Oracle-specific SQL syntax.
  • PL/SQL Compatibility. EnterpriseDB Advanced Server executes PL/SQL, Oracle’s unique language for triggers, stored procedures, packages, and functions.
  • Data Dictionary Views. EnterpriseDB provides the most common Oracle catalog views.
  • Programming Flexibility and Drivers. EnterpriseDB supports the most common programming languages used to create database applications for Oracle including compatibility and interoperability with the Oracle Call Interface (OCI)™.
  • Migration Tools. EnterpriseDB provides a suite of automated tools to move Oracle data, packages, triggers, stored procedures, and functions to EnterpriseDB in one simple step.
  • Replication. EnterpriseDB Replication Server can replicate Oracle databases in near real-time to: improve database performance, run reporting and as the foundation for other applications at a small fraction of Oracle’s cost.
  • Enterprise-Class Reliability and Scalability. EnterpriseDB Advanced Server is a suitable replacement for Oracle in high-volume, mission-critical applications.
  • Oracle-Like Tools. EnterpriseDB Advanced Server includes a robust set of integrated tools that will be familiar to professional Oracle DBAs and developers.
The white paper lists specific functions and features that are Oracle compatible. If you are considering EnterpriseDB, you should read it. The one thing it doesn't list are those items that ARE NOT compatible, i.e. missing functions, incompatible syntax, data types issues. Fortunately, you can find those in my book. ;-)


Thursday, August 16, 2007

EnterpriseDB Webinar - From Oracle to EnterpriseDB: An Oracle ACE's Journey

I will be doing a webinar next week, Aug 22 at 1PM Eastern. If you can't make it in real-time, the webinar will be recorded and will be available for viewing afterwards on the EnterpriseDB.com web site.

The webinar was announced in the EnterpriseDB press release for my book, EnterpriseDB Announces Availability of Definitive Reference Book.

From the press release:

Lewis Cunningham will describe his progression from EnterpriseDB skeptic to advocate in a live Webinar, From Oracle to EnterpriseDB: An Oracle ACE's Journey, on Wednesday, Aug. 22 at 1:00 p.m. EDT. The Webinar will also feature a step-by-step migration of an Oracle application to EnterpriseDB Advanced Server. To register for the Webinar, please visit www.enterprisedb.com/bookwebcast.

I'm really looking forward to doing this webinar. I did the ODTUG Desktop Conference in 2005. I did a security presentation and an Oracle XE presentation. Those were kind of the same. I will be talking and doing a PPT. Q&A will follow the presentation.

I'm also excited that the book is almost out. I have no idea when it will actually be out but it should happen shortly. I hope you can make the presentation.


Monday, August 13, 2007

EnterpriseDB Wins Best Database Award at LinuxWorld

EnterpriseDB, the Oracle-compatible database company, today announced that EnterpriseDB Advanced Server has won the LinuxWorld Product Excellence Award for Best Database Solution. EnterpriseDB Advanced Server beat both Oracle 11g and Jaspersoft Business Intelligence Suite to take the top honor.

"EnterpriseDB uniquely enables enterprises to run applications written for Oracle databases for a tiny fraction of Oracle's cost," said Andy Astor, chief executive officer, EnterpriseDB. "We were thrilled in 2005 to have taken the LinuxWorld Product Excellence Award for our industry-changing product and again in 2006 for our continued innovation. This year's award for Best Database Solution, especially in light of the hype surrounding Oracle 11g, is a gratifying endorsement of our product and strategy."

I thought Oracle XE won this award last year? Has EnterpriseDB won it 3 years in a row?


Friday, August 10, 2007

EnterpriseDB - Measure ROI versus Oracle

EnterpriseDB has introduced a new feature called the ROI Calculator. The calculator allows you to enter an Oracle configuration and compare the cost to an equivalent EnterpriseDB cost. You can even add extras like the partitioning option, OLAP, Data Mining and Spatial. A nice addition is the ability to enter a discount for Oracle. Most organizations get at least a partial discount on their purchases. The ROI also includes a 5 year support cost which somewhat skews the results (but in a direction you will likely go anyway).

I played with several configurations to see how they compared. I started with a fairly common configuration, 4 CPU Enterprise Edition with Partitioning. I included a 20% discount for Oracle.

Even though I know that EnterpriseDB is a lot cheaper to license, I was somewhat surprised at the difference in this configuration: $428,800 for Oracle vs 100,000 for a difference of $328,800. Remember this is over 5 years.


I entered the values for a little bit more robust configuration but one that is still not totally unusual: 16 CPU EE with Partitioning and a 20% discount. The numbers are even more dramtic: $1,372,160 for Oracle and $400,000 for EnterpriseDB for a difference of $972,160. That's almost a million dollars over 5 years and that's with a 20% discount on Oracle.


Finally, I tried it with a very basic configuration: 4 CPU Standard Edition, no partitioning and a 20% discount. The totals: $100,800 for Oracle and $100,000 for EnterpriseDB. Much closer. In this configuration, you lose the ability to partition in Oracle (you can partition in all configurations of EnterpriseDB), but you gain RAC (included in an SE license without an extra cost).


All of these EnterpriseDB prices include the premium support costs. The differences are even more dramatic if you choose Basic support over the Premium support offering. A premium support license for 4 CPUs is $100,000 (over 5 years) where as a basic support is only $30,000. The same comparison with 16 CPUs is $400,000 for premium and $120,000 over 5 years.

All in all, this ROI calculator shows that significant savings can be made. You still need to verify that EnterpriseDB is compatible for your applications.

Tuesday, August 7, 2007

RAC on Open Source: EntepriseDB GridSQL

This is just too cool. Today, EnterpriseDB announced at LinuxWorld that they are offering GridSQL, a data warehouse and OLAP clustering solution. According to the doc, the EnterpriseDB page for GridSQL, the tool offers:

  • Quickly and easily create, maintain, and access very large databases for Business Intelligence and Data Warehousing applications
  • Offload reporting from expensive hardware platforms onto an inexpensive grid of commodity hardware, creating significant savings
  • Run reporting and other applications with very large datasets, improving organizational decision-making
  • Improve organizational productivity and agility by enabling quick access to large amounts of informationThis is supposed to be a true, shared nothing approach to clustering. I, obviously, haven't had the chance to play with it yet but I will.
This is a scale out package for large databases. So I am guessing that you would be able to partition data across multiple machines but that is a total guess on my part. It may be just a CPU boost instead. I need to do some more research.

According to the documentation, GridSQL includes parallel query where EnterpriseDB (the database) decides how to spread the query across all databases in the grid. It does include a parallel query optimizer.

This i s an incredible step for EnterpriseDB. Check out the press release. I wonder how long it will be before they release GridSQL for PostgreSQL? RAC on open source? Free RAC? Interesting.


Friday, August 3, 2007

EnterpriseDB Finalist in Two Categories at LinuxWorld

EnterpriseDB got the finalist nod for Best Database Solution, for the third year, and for GridSQL For EnterpriseDB. This is the first I have heard of GridSQL and I am looking forward to more info.

All it says in the announcement is:

GridSQL for EnterpriseDB Advanced Server is a new product that will be announced at LinuxWorld on Aug. 7, 2007.

About all I can think is that it is something like pgCluster which is a multi-master, bi-directional replication tool for PostgreSQL. I have a hard believing that's what it because 1) they already have a replication tool and 2) the naming would be incredibly unfortunate.

I say option 2 because when most people hear grid associated with "an Oracle compatible database", they think of Oracle RAC and/or Grid (which most people erroneously think is the same thing but that's a different blog).

So now I wait with baited breath. I wish I had gotten a head's up at least.

Software Blogs - Blog Catalog Blog Directory Software blogs Top Blog Sites Blog Flux Directory Lewis Cunningham