Keep on Learning
Originally published on July 16, 2012 by Crysta Anderson at MasteringDataManagement
Mike Martin may be the only IBM Champion with an album currently available on iTunes. Based in the Philadelphia area, Mike and his band, Lo-Fi Genius, recorded an album, This is Rocket Science, including the song, “George Wendt Lives in My Building.” After all, George Wendt really did live in Mike’s building at one point.
Today, when he’s not making music, Mike is busy securing data. Luckily, Mike’s company, the Business & Technology Resource Group (BTRG), makes data security far easier than rocket science.
Mike is practice director of information governance for BTRG. He solves data quality, data growth, data privacy, data security, test data management and compliance problems for Fortune 1000 customers across many industries.
“A lot of our customers have mature systems that have accumulated quite a bit of data,” Mike said, noting that this leads to a familiar challenge: How can you manage volume, ensure high-performing systems and reduce costs?
Many companies seek to solve this challenge with a top-down approach. They launch an information governance program by establishing a council, naming data stewards and rolling out organization-wide policies. But as a member of the Information Governance Council, Mike takes a more solution-oriented, bottoms-up approach.
By looking for tangible pain points, such as data quality, data security or data volume, he offers clients a specific solution that delivers reportable ROI. Clients can then build from that success. “By solving significant problems that are in your enterprise systems, it gives you a foothold to really establish broader information governance,” Mike explained. “Then you already have an ROI and a case that you can use to internally sell that initiative.”
In the face of big data, information governance best practices and models still apply. In fact, Mike believes the stakes grow higher as data volumes increase. He noted, “Without good quality, the insights we would draw with a big data solution won’t be as valuable.”
BTRG works especially closely with IBM InfoSphere Optim, which enables data masking for non-production systems that are often shared with partners, employees, or others who need the data. Masking helps obscure personally identifiable or sensitive information. BTRG’s Data Masking Factory™ helps automate the requirements gathering, analysis, design, documentation and actual development. Mike explains that the tool exposes Optim’s “robust capabilities” while creating an easy-to-use checklist that lets users easily pick which fields to mask. The solution was one of only three finalists for the highly competitive IBM Beacon Award.
In one recent implementation spanning 18 mission-critical applications, BTRG completed the project in a mere 14 weeks. This was two weeks ahead of schedule, and 40% under budget. The best part? Based on the industry-standard Ponemon study that states every row of breached data costs a company approximately $204, Mike estimates they created $22 billion of data protection across 109 million rows of data.
On the production side, privileged users like DBAs and system admins certainly need greater. However, Mike helps clients use InfoSphere Guardium to monitor and log these activities, which can help stave off cyber attacks. Clients can mark certain data tables as “protected” and terminate connections if users try to access them. BTRG also helps clients take InfoSphere Guardium’s vulnerability assessments to a new level, extending the best practices and standards to the entire ERP system.
Listen to the podcast that was recorded with Mike, David Pittman, and Crysta Anderson to hear some great stories from Mike! You’ll be glad that you did!
Follow Mike on Twitter @BTRG_MikeMartin and check out the fun Mike had in the February 27 Tweetchat about Big Data & Governance:
Reading list mined from "Getting Control of Data in Big Data Era" Tweetchat
Recap of Tweetchat: "Getting Control of Data in Big Data Era"
Part 2: Recap of Tweetchat: "Getting Control of Data in Big Data Era"
What are you sacrificing for the promise of big data?
What is a Tweetchat and why should you join us?
Big Data & Database Technology
To find out more about managing big data, join IBM for a free event on April 30: Big Data at the Speed of Business
Look at all the great books that will be for sale at the IOD Conference at a 20% discount. There are more books that will be for sale at the Conference Bookstore, of course, but I've arranged a book signing session with the author(s) of the books mentioned in this blog entry.
For the first time ever, I've arrange to have these book signing sessions included into the SmartSite Agenda Builder! I'm very happy about this as it will help people remember when and where the sessions are taking place. In the past, people had to manually add the sessions to their schedule, which of course rarely happened.
1) Guest Speaker Book Signing
This signing will take place immediately following Atul’s appearance at the IOD General Session (8:00-9:30). Attendees must purchase the book at the conference bookstore and bring it to Atul for him to sign.
10:00 – 11:00
The Checklist Manifesto: How to Get Things Right
2) DB2 for z/OS book --- yes, finally a NEW DB2 book!!
Judy Nall’s book is for sale… she is a Gold Consultant and this is the first DB2 for z/OS book published in a few years.
3) Books for MDM, Information Architecture, and Business Intelligence.
This first signing takes place after the General Session on Wednesday.
4) Career Development
This book doesn’t relate technically to the conference, but the book was written by a long term DB2 developer and would benefit all attendees who are in the software industry in terms of career development.
Watch for future posts where I'll reveal the Flashbooks that will be launched at this year's conference and also for further details on each of the books that I've mentioned today.
I'm back to work after IOD and a well-needed vacation. Here is an update on how our community is growing. ChannelDB2.com has nearly 800 members! Many of them are students... but I hope all are finding information that is useful.
Here are some communities that you can join:
Channeldb2, Planetdb2, Informix Zone, the XML Contest homepage, DB2 ListServ, comp.databases.informix, developerWorks forums, groups on facebook and linkedin. There are groups within channeldb2.com that you can join: such as:
* DB2 in Books
* DB2 for Linux, UNIX, Windows
* DB2 for z/OS
* IOD Conference
We have a great community... I've witnessed it first hand! Be active so YOU can help make our online communities better!
What does “big data” mean to you? It is a term that is widely used and can convey all sorts of concepts, including: huge quantities of data, social media analytics, next generation data management capabilities, real-time data, and much more. Once you’ve figured out what “big data” actually means to you, you must then figure out how to manage and store it. Are your current systems able to handle this type of data? How can you be sure?
Several recent articles and blog entries discuss this theme.
The Commoditization of Commercial Database Management Systems?
by Craig Mullins
Databases are so popular these days that they are being taken for granted. This article argues that databases are intricate, multi-faceted and useful tools that are necessary to get the most out of the data that is being collected and should not be considered a commodity as no two offerings are alike.
The Continuing Role of the Database in the New Era of Big Data
by Bernie Spang
Massive amounts of complex big data must be stored in databases in order for it to be analyzed and made of use to businesses. What features in a database are necessary to take on this challenge?
Big Data: IBM’s Mainframe Customers Base Grows
by Dave Beulke
IBM’s Big Data solutions are being embraced by companies worldwide. This discussion shows that IBM Information Management solutions are well positioned to fill the needs to handle all your big data.
The Maturing of Big Data: From Herding Cats to Taming Tigers
by James Kobielus
With all the recent innovation in the big data market, has big data matured? Have we figured out how to make big data tigers jump through hoops, or are we still just herding cats?
Infographic: Taming Big Data
Lots of detail here. Take a look, share the graphic and tell us what you think of it.
Taming Big Data: 12 Best Practices for Analysts - Maria Deutscher
Are you ready to “sink your teeth” into Big Data Technology? Learn how to start using IBM’s technology correctly in order to get the most out of your efforts by learning these 12 best practices.
In addition to these articles, I highly suggest that you read the report Analytics: The Real-World Use of Big Data. It is based on the Big Data @ Work Survey conducted by IBM in mid-2012 with 1144 professionals from 95 countries across 26 industries.
“Across industries and geographies, our study found that
organizations are taking a pragmatic approach to big data.
The most effective big data solutions identify business
requirements first, and then tailor the infrastructure, data
sources and analytics to support the business opportunity.
These organizations extract new insights from existing and
newly available internal sources of information, define a big
data technology strategy and then incrementally upgrade their
infrastructures accordingly over time.”
Find out more about managing big data by joining this free IBM event on April 23 and by reading the posts on the Big Data Hub.
Conferences are a great way to learn a great deal in a short period of time and also a great way to meet people in the industry. Unfortunately, not many people are able to get budget to travel to the big conferences such as IDUG or IOD. The next best thing is to attend regional user conferences that bring the best of the best speakers to a location close to your home or office.
The are many regional user groups that take place regularly across the world, but the one I’ll tell you about is the one in my local: Toronto / Markham: Central Canada DB2 Users Group.
This year’s meeting takes place June 11-12, 2012 at the Institute for Learning.
What can you expect at this meeting? As usual, great speakers, great topics, networking opportunities, certification exams, and I may even show up to give people copies of the latest DB2 Flashbook.
Summary of Sessions and Speakers:
"Half Day with Bonnie Baker"
"What Can I Do To Protect DB2 Against Warehousing, WebSphere, and
"A New Catalog and Directory Structure in DB2 for z/OS"
"Looking Behind the Curtain of DB2 for z/OS 10 Performance and
Scalability: Storage Monitoring and Control"
"Gain Insight into DB2 for z/OS 10 Performance Updates and SAVE
"The Importance of Being Consistent - DB2 for z/OS and Remote Copy
Services for IBM System z"
"The Many Uses of Flash Copy with DB2 for z/OS"
"Temporal Data - An Insurance Policies Life"
"Application Performance - Tuning, Trending and Testing"
"Switching – What IS Access Path Stability?"
"It Could Happen To YOU – Scary Disaster Stories, Lessons Learned,
NOTHING is Impossible"
"DB2 for z/OS Utilities Update"
“Goin' Mobile [Beep Beep]"
“Take a REST from Using SOAP"
“Which DB2 High Availability Technology is Right for You?"
“Deep Dive into DB2 10 Query Performance Optimization: Statistics and
“Storage for DB2 Server"
“DB2 10 for LUW - Early Experiences with Storage Management and
“Upgrade Best Practices to DB2 10 for LUW”
“Stuffed with Great Enhancements DB2 9.7 Fix Pack New Features”
IBM Certification Exams :Tuesday June 12th
Come for the learning, but have a bit of fun while your at it! Looking forward to seeing everyone!
From the comfort of your desk, hear a keynote presentation by Harriet Fryman, Product Marketing Executive of IBM Business Analytics, attend breakout sessions featuring new capabilities with demonstrations, and interact with product experts.
This is a full-day, free event which takes place November 18, 2010 in the Americas and
IBM Cognos 10 represents the beginning of a series of new innovations from IBM Business Analytics that will change how organizations make decisions, allocate resources, and predict and plan the future. This is your chance to see IBM Cognos 10 in-depth, to chat with product experts, and to start planning for your organization’s future – without leaving your office.
Keynote: Introduction to IBM Cognos 10: Intelligence Unleashed
The event kicks off with a keynote presentation delivered by Harriet Fryman, Product Marketing Executive of IBM Business Analytics.We will share the vision of IBM Cognos 10, walk through the key innovations that revolutionize business intelligence, and speak to feedback from the early adopter customers. You will see IBM Cognos 10 software in action and hear about advances in the IBM Cognos platform.
Harriet Fryman’s keynote presentation will be followed by networking opportunities with solution experts and breakout sessions that will give you an in-depth look at the powerful new capabilities of IBM Cognos 10.
Content-rich tracks for IT, Office of Finance and Business Process Owners
Choose from these breakout sessions:
Authoring and Collaboration
Deployment and Adoption
Driving Actionable Analytics
Who should attend:
5 reasons to attend:
Today at the Toronto Lab, we had Stephan Jou present to us about Cognos. He gave an amazing demo of some of the products. As a door prize we were handing out copies of the Cognos Flashbooks:
Join me (as Scott's special guest) on Feb 12 at 11 am EST on
The DB2Night Show Episode #12- "The Wild Wonderful World of DB2 Resources"
What will I talk about?
I'm open to suggestions, but I'll likely cover the following:
1) Books published in 2009.
2) Books that are expected to publish in 2010.
3) Websites where you can get additional information about the books and have a chance to communicate directly with the authors of the books.
4) Opportunities for you to get involved in writing / reviewing or promoting books.
5) How to get a discount on books.
6) Future of publishing as ebook readers are becoming increasingly popular.
Is there something else you'd like me to discuss as well? Let me know!
Thanks for the opportunity Scott!
Register Now http://bit.ly/9cY0gL for the DB2 10 webcast.
Just a quick reminder that tomorrow 19th Oct 11 AM EST is our DB2 10 webcast - if you can't attend and then don't forget to register so you receive the replay information & charts . We have top DB2 speakers to answer your questions - Listen to Morgan Stanley talk about their Beta experiences
Rick Bowers, IBM DB2 for z/OS Director
Julian Stuhler Triton Consulting, DB2 Specialist, IBM Gold Consultant, IBM Data Champion
Fernando Lugo, Vice President, Enterprise Infrastructure, Morgan Stanley
Dil P. Sasidharan, Vice President, Morgan Stanley
John Campbell, Distinguished Engineer,
Jeff Josten, IBM Distinguished Engineer,
Roger Miller, IBM Technical Evangelist,
Terry Purcell, STSM, DB2 for z/OS Query Processing,
Haakon Roberts, IBM Distinguished Engineer
And... if you're at IOD next week, make sure you get the free Flashbook: DB2 10 for z/OS - Cost Savings ..... Out of the Box
Another great tweetchat took place today: Tweetchat: Enterprise Challenges of Incorporating #Hadoop
Were you able to join us? Not surprisingly, we’re getting more and more people joining us for each event. Here’s a list of those who tweeted to #bigdatamgmt today:
InfoMgmtExec, IBMbigdata, cdmaver, dmbanga, BigData_paulz, BIIGDATA, win_nalini, BTRG_MikeMartin, susvis, dvellante, suprgeek, IBM_DB2, jeffreyfkelly, katsnelson, furrier, BTRGIG, bm_iod, BTRG_MikeMartin, IBM_InfoSphere, CrystaAnderson, IBMPureSystems, jameskobielus, zacharyjeans, Natasha_D_G, TheSocialPitt, vishalsubra, ibmsysxblade, storageswiss, Dmattcarter, gargaurav_, wfavero, gourleymslc, planetrussell, bernie_o, platfora, Vladi_Sem, Wikibon, IBMSmrtrCmptng
If you’re looking some people to follow on twitter, that list would be a great start!
This is the list of recommendations that I mined from today’s tweets. Here is a storify summary of the chat.
Prezis by katsnelson
Get "A First-hand Account of the Big SQL Tech Preview" from Christy Maver
BIG DATA revolution :Big Data: A Revolution That Will Transform How We Live, Work, and Think by Viktor Mayer-Schonberger and Kenneth Cukier - Great book! Read it for inspiration!
If Hadoop Was Easy, Everyone Would Be Doing It: by Nancy Kopp
Find out how to rapidly protect sensitive information across your enterprise. Video: BTRG's Data Masking Factory™ for InfoSphere Optim™
Introducing the IBM Big SQL Technology Preview - blog by Susan Visser
Articles by jameskobielus:
Business Intelligence in the Hadoop Era: Drilling through petabytes of actionable intelligence
Hadoop: Nucleus of the Next-Generation Big Data Warehouse: How Hadoop complements data warehouses to create a powerful converged platform
Hadoop Cluster Management: Making your big data deployment truly enterprise-grade
Join the DB2Geeks next Wednesday for a tweetchat that is debate on the role of the DBA in the age of Java and noSQL databases:
Use hashtag #DB2Debate
Tip.. login with twitter to tweetchat.com to make it super easy for your to follow & join the conversation.
If you're a book lover like me... then you have many bookshelves filled to the brim with books, many of which have been read, but many others waiting to be read. And then there is the inevitable purchase of more books every time you walk into a bookstore! But how can you choose which one is best for you?
If you are looking for technical books, you should try either Safari or Books 24x7 (or really, both!). These online book engines allow you to search across an entire collection of books helping you pinpoint the information that you need RIGHT NOW! If you like, you can simply just continue to search, as you do on Google, and then read the sections that come up. Or you may choose to read the entire book electronically. Your choice.
A few years ago I ran a pilot of Safari in the Toronto Lab. Some of the feedback I received then was that this tool helped them discover a book that they didn't know existed. The person then went to an online bookstore and purchased the printed version of the book. So, not only can you read the entire book online, but you can use these tools as a way to screen / filter the unbelievably large collection of tech books to find what is best for you.
Now is a great time.... as Safari is offering a 10-day free trial to use the tool. If you work for IBM, you should already know that you have a free subscription to Books 24x7. The internal link can be found on the page w3.ibm.com/learning.
So, what's the difference between these two tools? The primary difference is the selection of books. Safari is jointly owned by O'Reilly and Pearson, so you'll find all of their titles in Safari. Books 24x7 typically covers all other books from a variety of publishers. The good news for IBM Press books is that these titles can be found in both.
I hope that you're able to take advantage of these trial offers and that you find the book you need! See our IBM IM Bookstore for the books that I'd suggest.
Did you know that data has temperatures? Can data run a fever? What happens if your data catches a cold? Or rather, turns cold from hot? What can and should you do? What techniques are available for optimizing performance in databases where some data is more popular (hot) than other data?
On Friday’s episode of the DB2Night Show, we'll be joined by various IBM experts who will help us answer these challenging questions! Kate Kurtz along with Maksym Petrenko and Jim Seeger from the IBM Smart Analytics Systems Best Practices team will share with us their expertise!
Topic: How do I handle multi-temperature data in my warehouse?
Speakers: Kate Kurtz, Maksym Petrenko, Jim Seeger
Host: Scott Hayes
Date: Friday, June 17
Time: 11:00 ET
One of the questions that comes up frequently is "How do I handle multi-temperature data in my warehouse?" This Friday, we will be discussing an overview of multi-temperature data management, and some of the strategies you can use to manage that data in your environment. There will also be a question and answer period - so take a look at the paper and store up your questions!
More about the speakers:
Maksym Petrenko joined IBM Toronto Lab in 2001 and has worked exclusively with DB2 software since then. As part of his career he was developer, technical support analyst, lab services consultant and beta enabler. His experience includes supporting clients with installation, configuration, application development, and performance issues related to DB2 Databases on Windows, Linux, and UNIX platforms. Maksym is a certified DB2 Advanced Database Administrator and DB2 Application Developer.
Jim Seeger is a Senior Software Engineer in the DB2 development group. Jim has worked on the DB2 kernel for almost 3 years. He has worked on the development of relational databases for 21 years. While working at IBM over the past 9 years, he has worked on storage area network file systems, storage virtualization products, high availability offerings and open standards storage management interfaces. Jim worked at NCR, Informix and EMC prior to joining IBM.
Katherine Kurtz has been a member of the DB2 development team since 1997 and is currently an Information Development Manger for DB2 LUW and the IBM Smart Analytics System for the DB2 LUW Development team at the IBM Canada Lab in Markham, Ontario. She holds a Bachelor of Mathematics (Computer Science and Pure Math) from the University of Waterloo and a Bachelor of Education from the University of Western Ontario. Katherine’s work is focused on understanding how customers use our products, and how IBM can make our products more consumable through the sharing of best practices that incorporate insight from IBM technical leaders in the Lab and in the field. Katherine also has deep experience in DB2 System Verification and Test, SAP/DB2 Integration, customer support, performance development and release management.
The DB2Night Show now has a LinkedIn Group - join us to stay up to date on our show and discuss show episodes! The group registration link can be found on www.DB2NightShow.com. We hope you will join us and participate as a studio audience member. One studio audience member will be randomly selected to win an electronic gift certificate! If you can't make the scheduled time, register anyways so that you get information about recorded replays.
Thanks for the information Kate!
Leveraging Spatial Capabilities in your Database
Date: 5/27/2010 (Thursday May 27, 2010)
Time: 11:30 AM - 1:00 PM Eastern (GMT-04:00)
10:30 AM Central / 8:30 AM Pacific / 16:30 hrs London / 17:30 hrs Frankfurt, Paris / India 9PM
Presented By: Sal Vella (IBM), David Adler (IBM)
This chat introduces the spatial capabilities of IBM relational databases, focusing on the DB2 LUW Spatial Extender. Much of the business data that we work with has a spatial characteristic, such as customer or office locations, sales regions, hazard polygons or facilities such as utility lines and highways. By representing this spatial information in a relational table as spatial datatypes, SQL queries can incorporate spatial functions to perform spatial analysis in the database. Business value is derived by being able to answer questions like:
- where are customers who may be interested in buying flood insurnce?
- what are the patterns of high crime activity
- should a new service center be constructed to support new customers
- where are preferred service providers along a route I plan to take
DB2 with the Spatial Extender is being used to answer these questions.
To learn more join experts from IBM labs - Sal Vella and David Adler.
Presentation charts for this Chat will be downloadable from ibm.com/db2/labchats
To register for this event and receive instructions for attending goto:
If clicking the above link does not work, please copy the entire link and paste tinyurl.com/spatialdb into your Web browser.
For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab
The IBM Data Management portfolio continues to grow to help you advance your skills. Study when and where you want with unlimited access to courses and labs for 90 days. New and popular courses include:
DB2 9 Administration Workshop for Windows
DB2 9 for LUW Quickstart for Experienced Relational DBAs
DB2 9.7 for LUW Quickstart for Experienced Relational DBAs
Fast Path to DB2 9 for Experienced Relational DBAs
Informix Dynamic Server 11 System Administration
Developing Applications Using Informix 4GL
Implementing Web Services using Informix 4GL
InfoSphere Warehouse 9 Components
svisser1 2700018UK9 Tags:  infomgmt education books facebook im certification information_management fan 5,489 Views
And… here’s another Facebook change:
We have a NEW Facebook page!
Enjoy the new page!
Register for this exclusive, free IDUG Webcast...Register now and plan to attend!
DB2 9.7: Get the Inside Scoop
Wednesday, June 24
Presented by Paul Zikopoulos
The release of DB2 9.7 for Linux, Unix and Windows is creating quite a stir in the industry. CNET said that "IBM puts Oracle to the Sword." ZDnet commented that "IBM's latest DB2 woos Oracle customers." Industry analyst Merv Adrian said, "This is a BIG deal." Beta participants claim that "this is a paradigm shift" and "simply amazing."
IDUG is pleased to host this unique 60-minute webcast on Wednesday, June 24 at 12:00pm Eastern. In this free event, you'll discover the new features of DB2 9.7 that will save you time, improve performance and lower your management costs. You'll be the first to know about the new technology your peers will be buzzing about by hearing it directly from the source.
Join renowned DB2 evangelist and respected author Paul Zikopoulos as he explains what the DB2 9.7 buzz is all about. Along with live Q&A, Paul will discuss DB2 9.7's new features for:
1. increasing performance, reliability and ease of use
In addition, IDUG President Michael McBride will discuss how this webcast is just one example of the many technical DB2 resources offered through IDUG's worldwide DB2 community.