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

clude other InfoSphere and Cognos products and even supplement it with additional technologies, such as WebSphe r e * MQ of f e r i n g s . InfoSphere Warehouse is the core of the IBM System z warehouse offerings. InfoSphere Warehouse V9.5.2 has three functional areas: physical-data modeling; SQL-based data movement and transformation; and an online analytical processing (OLAP) server. Data mining is being considered for a future release. An Eclipseba sed i nteg r ated de ve lopment env ironment (I DE ) , ca lled Design Studio, helps you develop physical relational database models, datamovement f lows and OLA P cubes. A Web-based administration console is used to manage the runtime environment handling such f unctions as deploying, scheduling and monitoring the data-movement flows and creating and managing cube servers. Cube servers run outside of WAS in Linux for System z. Physical Data Modeling The physical data model (see Figure 2, page 39) is a representation of the real objects existing in a r e lat iona l d at aba se , t he mos t common being tables and columns. You can develop a physical data model from scratch or you can reverse engineer it from existing data connections or f rom data definition (DDL) files. The datamovement and cube-development functions require a physical data model. You can analyze the physical data model in Design Studio, a subset of I nfoSphere Data A rch itect, for ad herence to convent ions and best practices. Comparing the model and database determines differences and then Design Studio generates the delta DDL to sync the model and database. You can create multiple diagrams over the model to have different subset views, perhaps by application area. You can modify the model using the diagrams. Design Studio If you’re familiar with other IBM Eclipsebased tooling the Design Studio IDE will seem very familiar. Design Studio has a Data Project Explorer for organizing your work into projects and a Data Source Explorer for connecting to and working with live databases. Graphical editors develop physical data models and data-movement f lows using a palette of operators and objects. You can use various other views to see job status, the job log, sample data, view errors and warnings, etc. Bei ng a n Ec l ipse-ba sed produc t , Design Studio inherits many Eclipse software-based functions. One of which is capability to work with source-code repositories. Even a basic repositor y provides versioning and team check in and check out. Design Studio can work with any source-code repository that has 38 J U LY/A UGUS T 20 09 an Eclipse client plugin. A client plugin for concurrent versions system (CVS) is provided as part of the Eclipse base, but you can use others such as IBM Rational ClearCase after installing the appropriate client plugin. You can install other IBM Eclipseba sed produc t s i nto one Ec l ipse installation so you can use multiple products without leaving the IDE. I have InfoSphere Data Architect V6.5.1, Data Studio Developer V2.1 (now renamed IBM Optim Development Studio) and Optimization Expert V2.1 (now renamed Optim Query Tuner) installed into my Design Studio. I can now seamlessly work with logical and physical data models, use the physical data model in my warehouse projects, develop custom-stored procedure logic for use in data-movement flows, model my cube and optimize my SQL without leaving Design Studio (see Figure 1, page 37). For more information on Optim, see “Organizations Thrive on Data” (page 28). The Administration Console manages t h e r u n t i m e e n v i r o n m e n t . I t ’s a WebSphere Application Server (WAS) appl icat ion r u n n i ng i n L i nu x * on System z and is accessed with a Web browser. It has three primary functions: conf iguration, data movement, and applications and cube server management. Data Movement and Transformation I n a l l data wa r e hou se s , data mu st be acqu i r e d , br oug ht to t he d at awarehouse environment and transformed to be loaded into the target tables. InfoSphere Warehouse’s SQL Warehousing Tool (SQW) turns DB2 into a transformation engine and can be considered an ELT tool. You can acquire data from common relational sources, such as DB2, Informix*, SQL Ser ver, Oracle and more, or from flat files. You can load data from these sources into DB2, where SQL style transformations would be applied before populating the final target tables. ibms ystemsmag .com /mainframe

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_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