Saturday, March 7, 2009

Summary of Popular Database System

In this article we'll explore the changes to several popular databases and compare what they have now and what they hold in the near future.

We will explore 3 databases: Microsoft SQL Server 2000->2005, MySQL 4.0 -> 5.0, and PostGreSQL 7.4->8.0->8.1.

For each database, we'll outline the key features, and what will be in the future additions. In the final part, we will compare side by side key features that we look for in a database management system and compare how each stacks up. + denotes not a new feature, * denotes new feature in this version, - nonexistent ranking 0-3 (0 nonexistent, 1 fair, 2 good, 3 excellent) .

Microsoft SQL Server
Microsoft SQL Server current edition is SQL Server 2000 Standard (note SQL Server 2005 Express is also now available, but the SQL Server 2005 Standard->Enterprise are still in beta), which has been out for a couple of years. In this year, they will be releasing the 2005 version which will have major enhancements. We'll outline the major features below.

The new version of SQL Server, SQL Server 2005 (called Yukon) will have major enhancements. The main ones are listed above. Perhaps the most powerful are the introduction of the PIVOT, UNPIVOT which convert a table to a cross tab query and convert a cross tab to standard tabular format, and CROSS APPLY and OUTER APPLY predicates which allow one to join correlated functions that return tables.

The new version will have native support for .NET languages as well (such as VB and C#).

MySQL is perhaps the most popular open source database around. What is most appealing about it is possibly the ease with which it can be installed and its support for numerous OSes.

In prior versions, MySQL lacked many options that a black-belt DB programmer or DBA would find useful. It is now beginning to make up for this in version MySQL 4.0 (recently released), and the upcoming MySQL 5.

PostGreSQL is perhaps the feature-rich open source database around. What is most appealing about it is its relative ease of setup, advanced ANSI-SQL and other Object Relational features, its support for numerous OSes, and its generous licensing model.

In prior versions (7.4 and below), PostGreSQL lacked native Windows support which was a big disadvantage when compared with databases such as MySQL. PostGreSQL 8.0 and above now sport native Windows support and a very simple to use Windows installer.

Popular Database System

No comments:

Post a Comment