Top Ten developerWorks Articles published in 2012
svisser1 2700018UK9 Comment (1) Visits (2352)
developerWorks: a treasure chest full of great content from experts. Articles, tutorials, best practices, downloads, spotlights, podcasts, videos... so much is available to help you deepen your skills... all for FREE.
2012 was a busy year and I’m pleased to tell you the top 10 articles that were published. Were you one of the readers who helped make these articles to the top? Check it out. Read the ones you missed. Share the ones you liked.
Confused about the various editions of IBM® Informix®? In this article, get an introduction to each edition, then you can compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease of use, reliability, stability, and access to extensibility features.
IBM® DB2® 10 for Linux®, UNIX®, and Windows® has out-of-the-box support for Oracle's SQL and PL/SQL dialects. This allows many applications written against Oracle to execute against DB2 virtually unchanged. In this article, get a high-level overview of what Oracle compatibility means in DB2. Whether you want to switch your custom application to DB2 or extend your DBMS vendor support to DB2, now is your time. [2012 15 May: This article has been updated to include new resources.]
This article is focused on explaining Big Data and then providing simple worked examples in Hadoop, the major open-source player in the Big Data space. You'll be happy to hear that Hadoop is NOT a replacement for Informix® or DB2®, but in fact plays nicely with the existing infrastructure. There are multiple components in the Hadoop family and this article will drill down to specific code samples that show the capabilities. No Elephants will stampede if you try these examples on your own PC.
Since the IBM® DB2® Control Center tools have been deprecated in DB2 9.7, users have been encouraged to adopt IBM Data Studio and IBM InfoSphere® Optim™ tools for managing DB2 databases. IBM Data Studio 3.1 was released in October 2011 with several enhancements over previous versions, making it an excellent replacement for Control Center. This article aims to help DB2 users who are familiar with Control Center tools to quickly transition to IBM Data Studio.
Learn some considerations that new software as a service (SaaS) vendors need to take into account when developing applications or modifying existing ones to enable them for multi-tenancy on the cloud. The article discusses the considerations only from a database perspective — specifically, from an IBM® DB2® perspective. Six cases or methods are described.
This article focuses on physical database attributes that are affected by the specifics of DB2 database servers in online transaction processing (OLTP) environments
In a large modern enterprise, information is almost inevitably distributed among several database management systems. Despite considerable attention from the research community, relatively few commercial systems have attempted to address this issue. This article describes the technology that enables clients of IBM's federated database engine to access and integrate the data and specialized computational capabilities of a wide range of relational and nonrelational data sources.
Combine InfoSphere® DataStage® and InfoSphere Federation Server to provide an efficient and flexible architecture for moving and transforming data. This article promotes the use of InfoSphere Federation Server as a "data pre-processor" for InfoSphere DataStage, and demonstrates situations in which the combination reduces both the elapsed runtime (by as much as 91 percent) and overall resource consumption of the job. The article does not promote the combination of InfoSphere Federation Server and InfoSphere DataStage for all data consolidation scenarios, rather it attempts to characterize the situations in which the combination is most beneficial.
about current free, online courses that are available at
If you want to work with "big data" without writing code or scripts, you'll want to look into BigSheets. BigSheets is a spreadsheet-style tool for business analysts provided with IBM® InfoSphere® BigInsights, a platform based on the open source Apache Hadoop project. This article teaches you the basics of using BigSheets to analyze social media and structured data collected through sample applications provided with BigInsights. You'll learn how to model this data in BigSheets, manipulate this data using built-in macros and functions, create charts to visualize your work, and export the results of your analysis in one of several popular output formats.
Congratulations to all these authors for a job very well done! I hope you plan to write more this year because we’d like more great content from you!