Great articles by amazing contributors. Make sure you read every article in the latest edition of the DM Magazine. I’ve read the article about Roger Sander’s contribution to the DB2 Certification Exam Development team and the announcement of his latest certification guide, which is a supplement. I’ve bookmarked many of the other articles so I can read them over the coming week. I hope you find something interesting and useful in this edition!
Taming Big Data - The realm of huge information flows is governed by new rules. What changes in the multi-petabyte, microsecond response, multimedia world? And how will Big Data change your job?
by Lisa Stapleton
It’s not just huge volumes. It’s not just microsecond response times, it’s not just incredible variety. It’s all three. Dealing with “nice” data, stored in well-defined data warehouse structures and handled sometimes months or years after it is first collected, is an increasingly smaller part of the job of data management. Here’s how folks are learning to handle the rest of it—the unstructured data, and the data that constantly changes as customers take actions and applications process input.
Tuning SQL at the Senate: E Pluribus Unum - When the SQL flow in the United States Senate went from static to dynamic, the database team had to see many queries, but tune them as one.
by Ives Brant
“High-performance government” may sound like an oxymoron, but for the teams that monitor and tune databases for the U.S. Senate, high performance is absolutely necessary to handle the huge number of queries that hit the Senate’s financial management system. InfoSphere Optim Query Workload Tuner software running on IBM DB2 z/OS helps the U.S. Senate DBAs and software specialists reduce query response time from 20 to 30 seconds to less than 2 seconds when they generate new statistics for a workload of SQL queries.
The Man to See About Certification - The guru of DB2 certification tests talks about how he puts them together—and how they can help your career
by Howard Baldwin
Q&A with Roger Sanders who has helped IBM develop 17 DB2 certification exams, more than any other individual. Want to know why certification is important? Roger Sanders is the man to ask. We talked to him about how the tests are put together, how they can help a DBA’s career, and—oh yes—about the certification test he failed.
Get Your Head in the Clouds - Data Pros are adopting cloud computing concepts to offer databases as a service - easing management burdens and sending users to cloud nine.
by Jin Zhang
Tactics and strategies for moving away from traditional provisioning models in which DBAs function solely in reactive mode—responding to user requests in nonstop “database, clone, database, clone” activities—towards a database-as-a-service, or DBaaS (pronounced as “D-Baa-S”), model employing cloud computing practices.
To offer DBaaS on the cloud, enterprise IT departments must undergo a process of constructing and managing a private enterprise “data cloud”—a platform consisting of storage hardware, virtual images, database schemas and more—and making that cloud available to users through a services interface.
Smarter is… Making Watson Smarter…Faster
by Howard Baldwin
A deeper look at the Jeopardy-winning system and the technology that enables it to process information in near real-time.
IBM Information Governance Council - Information Governance Community growing worldwide - IGC draws 1500 members, solicits best practices ideas
by the Magazine Team
The wisdom of crowds isn't an oxymoron. Large groups have an uncanny ability to get the right answer - just see James Surowiecki's book on the subject for proof. So it's not unreasonable to say that the Information Governance Council (IGC) is getting smarter with each passing month.
Data Architect - Securing DB2 Data - Grant privileges to a what, not a who
by Robert Catterall
These days executives are more concerned than ever about unauthorized access to data entrusted to their organization. Their fears are justified: a recent study showed that a third of those polled would quit doing business with a company they perceived to be guilty of a data security breach.
Distributed DBA - Using the DB2 Problem Determination Tool
by Roger E. Sanders
Sooner or later, every DBA encounters problems. Consequently, a skill that every DBA must possess is the ability to perform a logical, systematic search of a database system for the source of any problems that might arise. The DB2 Problem Determination Tool can help.
Programmers Only - New Order by Information: Part 2. The Impact of using the RANDOM index option on ORDER BY sort avoidance
by Bonnie Baker
In the last issue, Bonnie Baker began a series of columns concerning new aspects of ORDER BY. This column - Part 2 - covers the impact of using the CREATE / ALTER INDEX RANDOM order option on sort avoidance.
Performance tuning on Informix - Fastest Informix DBA Contest III - Performance tuning an OLTP system
by Lester Knutsen
Performance tuning is a continuous process for every DBA. Advanced DataTools Corporation conducted three fastest Informix DBA contests to highlight and learn what goes on in this process.
Imagine What You Could Do - Free your mind, and your business will follow
by David Buelke
Big Data, Big Time - Series data, warehouse acceleration, and 4GLs
by Stuart Litel