IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 30

When you consider an application’s life and its data, you must consider its entire life, including retirement. However, application retirement doesn’t i nc lude comple te d ata r e t i r e me nt . Organizations should take unused data out of production, but not purge it from the data center until they’re legally, contract ually and organizationally permitted. Let’s examine each of these life stages in more detail. There’s often a debate about where 9 Z h ^ \ c·A s m a n y of t he business logic should reside: Do you data sources within your put it in the application or in the dataorganization are already in base? I won’t address those issues in place, you may be asking, this article, instead I’ll focus on what “What does design mean?” de ve lopme nt mea n s . For e xa mple , I’m not saying you must data access can be both an art and a start over, as that wouldn’t science. Data access is important for m a ke a n y s e n s e a nd you’d probably stop r ead i ng r ig ht about 9ZkZade can have multiple meanings security, performance and enforcement now. What I’m saying is: As you move without setting some context. In this of business rules, but how an organization implements data access var ies. forward, design must be a part of what sense, it can take on two meanings: Several frameworks can be used: You you do when considering application and 1. To i mplement t he data mode l: can write it yourself, or it can be done database enhancements and changes. Yes, that’s something every system administrator does Figure 1 Example Healthcare Architecture today in some par t, but Channels Business Units Data Systems how much time is spent really designing changes to existing systems? How DB App DW Core Finance about when you move from Systems Administration CRM DB App multiple systems through ERP Provider consolidation into an ERP? Core Sales & Design is an important area DB App DW Systems Marketing CRM DB App to focus on, as it all starts Health Plans ODS there. Wit h new reg u lat ions Core Care DB App DW f r om gov e r n me nt s a nd Systems Management CRM DB App industries, going back in CIF Contact Centers time might be necessar y Patient/ Member as well. You must ensure Core Ancillary DB App DW Systems Services the data privacy that you CRM DB App may not have paid much Internet attention to in the past. Core New Business You must define very clear DB App DW Systems Development CRM DB App and concise policies around Partners data retention. As you move Employers data f rom on line transaction-processing (OLTP) 30 J U LY/A UGUS T 20 09 ibms ystemsmag .com /mainframe systems into warehouses, what are the cleansing policies and how do the designs from single implementations translate into the data warehouse? These are questions you and your team must answer daily. Having a way to manage these requirements across the enterprise is a good start. Creating a common understanding and requirement capture is one of the key design elements. Once you document and understand the requirements, modeling the desired architectures and relating the requirements to them will become the next phase of design: development. develop t he physica l database structures, write SQL, identify triggers, build out storage spaces, etc. 2. To write application code to design the application and its access to the database.

IBM Systems Magazine, Mainframe digital edition - July/August 2009

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe digital edition - July/August 2009

IBM Systems Magazine, Mainframe digital edition - May/June 2009
Table of Contents
Editor’s Desk: Cooking Up a Data Solution
Trends: IBM’s Scorpion Team Provides an Updated Method for Analyzing and Optimizing IT Infrastructures
Focus on Storage: Tivoli Storage Manager 6 Accommodates Surging Data
Case Study: Insurance Company Swiss Mobiliar Uses BMC Software’s APPTUNE to Ensure its Applications Perform Well
Cover Story: An Integrated Data-Management Approach Supports Data Throughout its Lifecycle
Feature: InfoSphere Warehouse Expands Data-Warehouse Tooling to the System z for Operational BI Functionality
Technical Corner: Planning for a z/OS V1.9 Migration
Product News
Advertiser’s Index
Stop Run: IBM Jams Tap Into the Power of the Crowd
Reference Point
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - IBM Systems Magazine, Mainframe digital edition - May/June 2009
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover2
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 1
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Table of Contents
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 3
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 4
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 5
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 6
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 7
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Editor’s Desk: Cooking Up a Data Solution
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 9
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Trends: IBM’s Scorpion Team Provides an Updated Method for Analyzing and Optimizing IT Infrastructures
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 11
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 12
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 13
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 14
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 15
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 16
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 17
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Focus on Storage: Tivoli Storage Manager 6 Accommodates Surging Data
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 19
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20a
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20b
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20c
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 20d
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 21
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Case Study: Insurance Company Swiss Mobiliar Uses BMC Software’s APPTUNE to Ensure its Applications Perform Well
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 23
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 24
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 25
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 26
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 27
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover Story: An Integrated Data-Management Approach Supports Data Throughout its Lifecycle
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 29
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 30
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 31
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 32
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 33
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 34
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 35
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Feature: InfoSphere Warehouse Expands Data-Warehouse Tooling to the System z for Operational BI Functionality
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 37
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 38
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 39
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 40
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 41
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Technical Corner: Planning for a z/OS V1.9 Migration
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 43
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 44
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - 45
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Product News
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Advertiser’s Index
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Stop Run: IBM Jams Tap Into the Power of the Crowd
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover3
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Cover4
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - Reference Point
IBM Systems Magazine, Mainframe digital edition - July/August 2009 - RF2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20191112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/relevantz_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2019mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20181112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2018mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20171112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_sesupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_linuxsupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20161112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/MainframeSecurity
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20151112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910_se
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910
http://www.ibmsystemsmagmainframedigital.com/MFSkills
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506_supp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20141112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_gt_201405
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/BigData
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20131112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20121112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/buyersguide2013
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/ibmsystems_mainframe_2012bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20111112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20101112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910_bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20091112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090506
http://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
http://www.nxtbook.com/nxtbooks/mspcomm/ibmsystems_mainframe_200901
http://www.nxtbookMEDIA.com