Art of BI: Expression Edition Databases – Good for Data Warehousing
Christian Screen | | June 28, 2011
In the past getting one’s hands a large scale enterprise relational database system such as DB2 or Teradata was a tremendous feat for any developer/implementer looking to boost their skills outside of MS Access. I am excited for the future now that it seems that all of the major database wielding organizations have jumped on the bandwagon to release “Express” editions of these once coveted and hard to gain access systems. As of late IBM has added itself to the line-up of companies that include Oracle, Microsoft, and even Teradata, by providing their “Express” edition offering of DB2.
Why They Release Express Editions?
The why should really come as no surprise to anyone ever involved in an open source project or even end-user of open source software. The goal is proliferation. The more developers that these database companies can provide their database offering to the more it has the chance of evolving in more ways than the company could imagine. It also gives way to a whole new developer base that actually learn how to use the database, integrate it, and potentially share information about it via books, forums, blogs, etc.
Are the Database Companies Loosing by Providing an Express Edition?
Let’s face it, companies are in existence because they are there to make money, not to lose it. Each one of these database companies has a strong strategy in place to ensure that the Express offering does not eat into their Full-Version sales of the database tool. By providing an express edition, these companies gain so much more than just immediate monetary return on investment. Through discussion groups, social media, etc. the database gain notoriety and great PR which is not directly quantifiable but certainly impacts the organization in a positive way.
Who are They Competing Against?
Free and Open Source Software databases are absolutely nothing new. If I were to put a finger on it I believe all large database organizations such as an IBM or Oracle are actually competing (in the case of Oracle, were competing) against MySQL and the amazing community that they have established over the last decade. On the compact database side, the clear competition to beat there is SQLite which is the main database tightly tucked inside almost every dynamic data driven iPhone and iPad application on the iTunes App Store.
These open source software databases have become more that products but they are now perspectives from which the largest enterprise database organizations are now try to carve their vantage. Clearly some are doing better than others but in the long run I think the competition is amongst each database organization itself. They are competition against themselves in order to define releases, to define how much scope of the full-version database to place into the expression version, and the like.
Where is the Benefit for End-Users?
From a system integrator perspective, having the ability to have a once shielded multi-million dollar database system now fit nicely on a my laptop or in a VM Image running on my laptop, is a tremendous advantage. One can now testing installation scenarios without requiring database server time or a company investing thousands of dollars and tons of hours setting up development environments on large scale physical servers. A developer working as a Programmer Level 2 in their basement cube can now explore the internals of Teradata or DB2 and escalate their position within their organization by simply taking the extra time to learn a new database skillset on their own time in the comfort of their own surroundings.
There are a myriad of benefits from leveraging the express versions of the enterprise databases. I implore everyone to take advantage whenever they can.
Of Course there are Limitations
Circling back around to the fact that database organizations are there to make money, don’t be naive that just because these database expression editions are free that they can do everything that the full-version can. If this were the case no organization would ever buy the full-version, right? So, each expression edition you find will come with some level of limitation. The most consistent limitation these express editions have is on the size which the database can grow. Most limit the database to under 3 GigaBytes of disk space. This clearly prevents the express edition for use in large data warehousing systems holding hundreds of Gigs worth of data. Some also limit the number of processors and some limit the number of functions available when compared to the full-version. I believe this is by design not only to prevent organizations from trying to leverage the express edition for large scale deployments but also to keep the footprint of the database small enough to fit on a laptop or small VM Image. Either way, when looking at an express edition for testing or your next application’s back-end data store, keep in mind to assess the limitations of the express version of the database in order to mitigate any conflicts you may encounter during development.
Where are These Expression Versions?
- TeraData Express:
- IBM DB2
- Oracle XE
- Microsoft SQL Server Express
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.
Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.