Get Your IBM Update and Improve Big Business Efficiency.
IBM has added many features to DB2 10.1 to make it a lot more useful for big-data operations that are common in the modern day industry. The company also has a lot of secondary service businesses and systems that use the DB2 databases. There are three forms of DB2 databases. One of them is meant for mainframe, the other is used for IBM i that was previously known as OS/400, and the third one is for Linux, UNIX, and Windows platforms. The new releases also see IBM ramping up the compatibility with PL/SQL query language by Oracle. So if you intend to use these databases, Oracle PL/SQL can come in very handy.
The database used for Linux and Windows is called DB2 LUW, which had its latest 10.1 version released recently. Director of Product Strategy for Database Systems and Software, Bernie Spang said that DB2 10.1 mainly deals with big data and the details of data layer in different applications. The update for DB2 comes along with the upgrade for Info Sphere Warehouse. Both these products will be shipped on April 30 and that will mark the end of four years of work put in by hundreds of IBM engineers around the globe. The new database comes with various performance enhancements as well. You also get a new method for data-compression along with better compatibility with the databases from Oracle.
What has improved?
If you look at the new upgrade from a big-data point of view, you will see that IBM has strengthened the link between MapReduce clusters of Hadoop. These clusters run the Hadoop Distributed File System (HDFS). According to Spang, the previous connector used for linking Hadoop and DB2 was very basic. So IBM went back to the drawing board and created a connector that allows data warehouses to very easily suck and spit out data from Hadoop clusters. The new connector also meant a lot less work for database admins.
Access control and PL/SQL compatibility
Access control is always an important aspect and DB2 10.1 comes with fine-grained access controls for columns and rows. This makes it possible to lock out any user from any row or column of data. This even prevents you from partitioning an application for various user classes. IBM also added that the early access users for the 10.1 release are able to see 98% compatibility for PL/SQL queries that are running against DB2. This high percentage should be reason enough for people to go for Oracle PL/SQL training courses, if they are not very proficient in the language .
Data ingestion
Another big feature is called the continuous data ingest. This feature allows outside data feeds to send information into the database. It also enables the database to continuously send records to the data warehouse, without interrupting the queries which might be running on either box. Simply put, the ingestion process relies on parallely bringing the data into the warehouse and in the database. This is a truly unique method that has not been implemented by any other company.
Please Share This Knowledge With Others!
Carlos says
I was reading an article on the Oracle the other day and didn’t think much of it. But now that I am reading this as well I am thinking that this is something that I might need to look into if I plan to do any upgrading in the near future. From what I understand there are classes on how to use Oracle coming up so I will make sure to check that out.
Gwen says
You put together a very interesting article here. I understand that this particular upgrade is something that would be best used with Oracle but is that going to be the case with any new upgrade that is going to hit the market in the next two years? I have wanted to make an upgrade but I wasn’t to happy about the Oracle thing. I will have to do some more research.
Sandy says
I do not know anything about Oracle yet, is this something that you are going to have to have in order to use this new updated version? If that is the case I am going to have to get in on some of those classes that I read about yesterday where the Oracle is explained and you are shown how to use it. Thank you for the heads up I look forward to moving forward.
James says
The data ingestion sounds like a good idea but I also wonder how easy it will be for someone to plant a virus that way. I am sure this is something that has been studied and researched to death but it wasn’t mentioned in the article so I thought I would voice my concern. Great article, with a lot of new information that will be incredible.
Quentin says
This was a very interesting article that I had not heard anything about lately. Usually my IT people are on top of things like this and they let me know what new updates and features are going to be available because I like to have the newest and best of electronic software when ever possible. Thank you for posting this and I will be sure to show my team.
Patricia says
Thank you for posting this information. I’m not surprised that this has come out with these new features but I am surprised at Oracle. I have used it before and I have to say it is not the most user friendly out there. And for anyone who hasn’t used it before the training class is going to be a must in order to understand it and what businessman has time to go to a class.
Dennis says
Unfortunately I have to agree with Gwen on this one, I was not to happy about the Oracle thing either because I am not familiar with it and don’t know how it will work but that could be alleviated I know if I just took the training classes that will be available. But that is the other problem with this I do not have time to go to a class to learn this stuff.
Christopher says
This was very interesting. I am not very familiar with this DB2 yet but it sounds like something I would like to implement into the company if I can. The information you have provided is great and I am going to look into the classes I read about on Oracle to see how it works exactly. Thank you for the post it was put together in a very professional manner.