The new version of DB2 Express-C
, version 10, is out, and it's more flexible and powerful than ever before! Starting from the fact that it now allows you to use 4GB of RAM instead of 2GB, this will boost different database operations. The database size is still unlimited (compared to 11GB for Oracle XE, or 10GB for SQL Server Express). Speaking of Oracle, DB2 Express-C includes the "Oracle compatibility feature
", which means that as much as 98% of code written for Oracle could run with no changes
on DB2 Express-C!.
There are other cool new features in DB2 Express-C that you can use and configure with minimal effort. For example, "Time Travel Query
" allows you to develop "time-aware" applications with minimal effort. This is helpful for audit purposes, governance, and to solve problems because this feature will let you query your data as it was in a given period of time that you specify. This can help you to easily and quickly create charts like the ones you see for stock prices, for example.
Check out the article "DB2 Express-C 10: Even more value
" for more details, and download and try DB2 Express-C 10
! It's free!
About two weeks ago, BigDataUniversity.com
launched a Hadoop Programming Challenge
with the opportunity to give 3 students a free trip to Las Vegas (all travel expenses paid!) and participate in the Information on Demand
(IOD) conference. Students completing the Hadoop Fundamentals I
course would be given the details of the challenge. If you click on the "Participants" link in the course, you will see (as of today) that there are about 1000 people registered in the course
. That means 3 out of 1000 would be traveling to Las Vegas... That is not a bad ratio, but if you think about it, it is very likely not all registered students will complete the course. Say 300 (30%) complete it. This means 3 out of 300 would make it to Vegas!... but wait ...it gets better. Those who complete the course receive the details of the programming challenge. The challenge requires you to write some code. My guesstimate is that maybe 30 students (10% of 300) will actually submit their program... So now we have 3 out of 30 flying to Vegas!. Now, in my experience judging submissions for other challenges, out of those 30, some submissions will be incomplete or disqualified, some would be too simple... So say 50% are like that....that means 3 out of 15 (or 1 in 5) could be in Vegas this October!
Now remember: This is not a lottery, this is a challenge; therefore you have a say on the outcome
. If you put the effort and are creative we can see you at IOD!...moreover, you may network with executives from many companies including IBM and that may open the door to more opportunities!
would be a good reason for participating...Just imagine!
P.S: Yes, this post will make more people think about participating, but in my opinion, the ratio would still be very good!...I don't think 10000 people would be participating as the submission deadline is this September 30th!
Good luck! Raul.
Today, DB2 University (db2university.com)
was made available (in beta) to the community. DB2 university is an online educational Web site delivering free and paid courses by experienced professionals and teachers. Why DB2 University?
DB2 University represents many things:Flexibility
Online delivery of education is a growing trend. It allows students to learn at their own pace, in the comfort of their home, or wherever they may be. It allows companies to have their employees gain skill at a lower cost (No traveling expenses required).
The DB2 community demanded a site like this, and finally we have it! DB2 University delivers courses about DB2 and other technologies online, in either self-paced or Instructor-led format. The site has a sample of courses right now that you can check out:
- SQL Fundamentals I
- DB2 Essential Training I
- DB2 Essential Training II
- Data Studio Essential Training I
Some of these courses have been translated to different languages (Portuguese, Spanish, Russian); and they all have a corresponding book that can be used as a reference. For example, the SQL Fundamentals I course is based on the Database Fundamentals
eBook just published; the DB2 Essential Training I & II courses are based on the Getting started with DB2 Express-C
eBook, and the Data Studio Essential Training I course is based on the Getting started with IBM Data Studio for DB2
Books, videos, online delivery... A complete set of materials in different formats!Quality, easily consumable material
Before DB2 University was released -- and this applies to internet content in general -- you could find a lot of material about DB2 on the Web; however, in many cases it was hard to make sense what was relevant or not. Some of the material out there is obsolete, incorrect, or too complex; and this would cause you a headache more than helping you. Moreover, there is no logical flow when reading this material. You just get an ocean of information that is hard to digest.
At DB2 University, we use Moodle open source course management system (CMS). A CMS helps instructors organize the material in a relevant and easily digestable way. Now students can go through the material with a logical flow that will save them time in their learning. They can also be confident the material is relevant, up-to-date, and of great quality, since it's been prepared by experienced professionals and teachers.
The Moodle version running on DB2 University was enabled to use DB2 as its database server. This means Moodle is helping DB2, and DB2 is helping Moodle!Recognition
Everyone taking a course likes to have some document to attest they completed the course. At DB2 University, we offer completion certificates to all students passing a course.A real-life reference: Moodle using DB2, DB2 on the Cloud
Every time you access DB2 University you are seeing DB2 in action!. As mentioned earlier, Moodle CMS was enabled to run on DB2. Moreover, every time you access DB2 University, you are also seeing DB2 in action on the Cloud!. Yes, DB2 University was implemented on the Amazon Cloud. We manage it using Rightscale
, a Cloud management platform. Working on the Cloud also enabled us to set up a disaster recovery site at a low cost, so we use a different elastic cloud computing (EC2) instance to run a DB2 Stand-by server in a HADR configuration
There are many more things to say about DB2 University and how it was implemented. A developerWorks article
published on January 13th has more details. It is the first in a series of articles describing how DB2 University was implemented, including it's open-ID sign up capabilities (that is, how ChannelDB2/Facebook/Yahoo/Google IDs can be used to log on to DB2 University), and also using an Android phone to access your marks at DB2 university.
I would like to end this post by inviting you once again to try out DB2 University
. Right now we have a special promotion where the top 20 students passing some of the courses offered will receive free or discounted IBM Certification exam vouchers, and also free hard copies of books!
We would like to hear any feedback you may have about the site so we can improve it!. Moreover, if you would like to host your quality material in our site, please let us know! It could be hosted either as a free or a fee-based course. It's up to you!