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.
- Comparing the Informix Version 11 Editions by Carlton Doe
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.
- Run Oracle applications on DB2 10 for Linux, UNIX, and Windows by Serge Rielau
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.]
- Hadoop Tutorial: Hello World with Java, Pig, Hive, Flume, Fuse, Oozie, and Sqoop with Informix, DB2, and MySQL by Martin Lurie
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.
- Migrating from the DB2 Control Center to IBM Data Studio by Antonio Maranhao, Kevin Jiang
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.
- Designing a database for multi-tenancy on the cloud by Raul Chong
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.
- Physical database design for OLTP environments by Amyris Rada and others
This article focuses on physical database attributes that are affected by the specifics of DB2 database servers in online transaction processing (OLTP) environments
- IBM federated database technology by Eileen Lin, Laura Haas
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.
- A flexible data integration architecture using InfoSphere DataStage and InfoSphere Federation Server by Wendy Tam and others
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.
- Starting your education in big data: free courses with hands-on labs you can run on the cloud by Raul Chong
Learn about current free, online courses that are available at BigDataUniversity.com. Follow the suggested path to get started and grow your knowledge on big data, and get ready to implement it to meet your own business needs.
- Analyzing social media and structured data with InfoSphere BigInsights by Cynthia Saracco, Anshul Dawra
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!