IBM Systems Magazine, Mainframe - November/December 2016 - 14

CURRENTS

Giving Data STRUCTURE
Find the right database management systems to maximize information

D

ata is everywhere, and organizations are struggling to efficiently and
affordably manage it. A database management system (DBMS) provides a
secure, central repository that reduces redundancy and can be easily accessed
by authorized users. For IBM z Systems* users, databases are broken into categories
based on data structure or size: inverted list, hierarchical, network or relational (see
"Know Your Database Types" on page 16). The key is to have the information and
tools to choose the best DBMS solution (see "7 Tips for Choosing a DBMS" on page 16).

Caroline Vitse
is a freelance
writer based
in Rochester,
Minnesota.

DBMS Options
According to Harry Batten,
z Systems executive IT architect, benefits of DBMS include
enhanced data integrity, improved
flexibility of information systems,
and increased data access and
availability. IBM z* users have
several DBMS options:
ĀÃ '%ŪÃIRUÃ]26ÃDÃUHODWLRQDOÃ
DBMS that can be used
ZLWKÃWKHÃ,%0Ã'%ŪÃ$QDO\WLFVÃ
Accelerator appliance
ĀÃ ,%0Ã,06ÃZKLFKÃZDVÃRULJLnally a hierarchical DBMS and
now offers SQL support

ĀÃ ,QWHJUDWHGÃ'DWDEDVHÃ0DQagement System, a network
DBMS with SQL support
ĀÃ 'DWDFRP'%ÃDÃUHODWLRQDOÃ
DBMS
ĀÃ $GDEDVÃDQÃLQYHUWHGOLVWÃ'%06Ã
with SQL support
All of these options handle
WUDGLWLRQDOÃ]26ÃZRUNORDGVÃVXFKÃ
as batch and online transaction
SURFHVVLQJÃ2/73Ã:KDWÃGLIIHUVÃ
among them, Batten says, are
performance, resource requirements and ease of use.
"For many years, clients looked-
and are still looking-for a simpler,

14 // NOVEMBER/DECEMBER 2016 ibmsystemsmag.com

faster and ubiquitous development model for DBMS application
development," he notes. "In
parallel, there has been a movePHQWÃWRÃILQGÃZD\VÃWRÃUHGXFHÃ&38Ã
consumption and elapsed time for
applications, which has led to the
advent of specialty engines, such
DVÃ],,3VÃ,%0Ã]Ã6\VWHPVÃ,QWHJUDWHGÃ
,QIRUPDWLRQÃ3URFHVVRUVÃDQGÃ
DSSOLDQFHVÃOLNHÃWKHÃ,%0Ã'%ŪÃ
Analytics Accelerator appliance."
From a z Systems perspective,
Batten says, the DBMS tends
to be a one-size-fits-all model.
:KLOHÃVRPHÃFXVWRPHUVÃVFDOHÃWRÃ
accommodate many terabytes of


http://www.ibmsystemsmag.com

IBM Systems Magazine, Mainframe - November/December 2016

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - November/December 2016

Editor's Desk: Mastering their craft
IBM Perspective: Expanding mainframe ecosystem creates opportunities for Gen Z
Partner PoV: Workplace Diversity: Attract the best talent by encouraging more options for women
IT Today: Financial Feasibility: IBM Global Financing designs customized solutions for technology investments
Currents: Giving Data Structure: Find the right database management systems to maximize information
Case Study: Investing in a Difference: Primerica Life Insurance Co. improves processing and performance
Cover Story: Sparking Student Interest: IBM Master the Mainframe World Championship exposes top students to analytics and data storage
Feature: The Modern Mainframer: The IBM z platform attracts recent grads to its orbit
Women in Tech: Taking a Seat at the IT Table: Women meet challenges, savor successes in the IT field
Tech Corner: Get in the Cloud: z/OS solutions can connect to the cloud through REST interfaces
Solutions: API Integration Platform 3.0, OpenLegacy; Ivory Service Architect V5.1, GT Software
Stop Run: Code Your Own Way: High school girls take charge of their futures
Reference Point - Global Events, Education, Resources for Mainframe
Linux on z Systems E-book
2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - November/December 2016 - Intro
IBM Systems Magazine, Mainframe - November/December 2016 - Cover1
IBM Systems Magazine, Mainframe - November/December 2016 - Cover2
IBM Systems Magazine, Mainframe - November/December 2016 - 1
IBM Systems Magazine, Mainframe - November/December 2016 - 2
IBM Systems Magazine, Mainframe - November/December 2016 - 3
IBM Systems Magazine, Mainframe - November/December 2016 - 4
IBM Systems Magazine, Mainframe - November/December 2016 - 5
IBM Systems Magazine, Mainframe - November/December 2016 - Editor's Desk: Mastering their craft
IBM Systems Magazine, Mainframe - November/December 2016 - 7
IBM Systems Magazine, Mainframe - November/December 2016 - IBM Perspective: Expanding mainframe ecosystem creates opportunities for Gen Z
IBM Systems Magazine, Mainframe - November/December 2016 - Partner PoV: Workplace Diversity: Attract the best talent by encouraging more options for women
IBM Systems Magazine, Mainframe - November/December 2016 - 10
IBM Systems Magazine, Mainframe - November/December 2016 - IT Today: Financial Feasibility: IBM Global Financing designs customized solutions for technology investments
IBM Systems Magazine, Mainframe - November/December 2016 - 12
IBM Systems Magazine, Mainframe - November/December 2016 - 13
IBM Systems Magazine, Mainframe - November/December 2016 - Currents: Giving Data Structure: Find the right database management systems to maximize information
IBM Systems Magazine, Mainframe - November/December 2016 - 15
IBM Systems Magazine, Mainframe - November/December 2016 - 16
IBM Systems Magazine, Mainframe - November/December 2016 - 17
IBM Systems Magazine, Mainframe - November/December 2016 - Case Study: Investing in a Difference: Primerica Life Insurance Co. improves processing and performance
IBM Systems Magazine, Mainframe - November/December 2016 - 19
IBM Systems Magazine, Mainframe - November/December 2016 - 20
IBM Systems Magazine, Mainframe - November/December 2016 - 21
IBM Systems Magazine, Mainframe - November/December 2016 - 22
IBM Systems Magazine, Mainframe - November/December 2016 - 23
IBM Systems Magazine, Mainframe - November/December 2016 - Cover Story: Sparking Student Interest: IBM Master the Mainframe World Championship exposes top students to analytics and data storage
IBM Systems Magazine, Mainframe - November/December 2016 - 25
IBM Systems Magazine, Mainframe - November/December 2016 - 26
IBM Systems Magazine, Mainframe - November/December 2016 - 27
IBM Systems Magazine, Mainframe - November/December 2016 - Feature: The Modern Mainframer: The IBM z platform attracts recent grads to its orbit
IBM Systems Magazine, Mainframe - November/December 2016 - 29
IBM Systems Magazine, Mainframe - November/December 2016 - 30
IBM Systems Magazine, Mainframe - November/December 2016 - 31
IBM Systems Magazine, Mainframe - November/December 2016 - 32
IBM Systems Magazine, Mainframe - November/December 2016 - Women in Tech: Taking a Seat at the IT Table: Women meet challenges, savor successes in the IT field
IBM Systems Magazine, Mainframe - November/December 2016 - 34
IBM Systems Magazine, Mainframe - November/December 2016 - 35
IBM Systems Magazine, Mainframe - November/December 2016 - 36
IBM Systems Magazine, Mainframe - November/December 2016 - 37
IBM Systems Magazine, Mainframe - November/December 2016 - 38
IBM Systems Magazine, Mainframe - November/December 2016 - 39
IBM Systems Magazine, Mainframe - November/December 2016 - 40
IBM Systems Magazine, Mainframe - November/December 2016 - 41
IBM Systems Magazine, Mainframe - November/December 2016 - 42
IBM Systems Magazine, Mainframe - November/December 2016 - 43
IBM Systems Magazine, Mainframe - November/December 2016 - Tech Corner: Get in the Cloud: z/OS solutions can connect to the cloud through REST interfaces
IBM Systems Magazine, Mainframe - November/December 2016 - 45
IBM Systems Magazine, Mainframe - November/December 2016 - 46
IBM Systems Magazine, Mainframe - November/December 2016 - Solutions: API Integration Platform 3.0, OpenLegacy; Ivory Service Architect V5.1, GT Software
IBM Systems Magazine, Mainframe - November/December 2016 - Stop Run: Code Your Own Way: High school girls take charge of their futures
IBM Systems Magazine, Mainframe - November/December 2016 - Cover3
IBM Systems Magazine, Mainframe - November/December 2016 - Cover4
IBM Systems Magazine, Mainframe - November/December 2016 - Reference Point - Global Events, Education, Resources for Mainframe
IBM Systems Magazine, Mainframe - November/December 2016 - RF2
IBM Systems Magazine, Mainframe - November/December 2016 - Linux on z Systems E-book
IBM Systems Magazine, Mainframe - November/December 2016 - L2
IBM Systems Magazine, Mainframe - November/December 2016 - L3
IBM Systems Magazine, Mainframe - November/December 2016 - L4
IBM Systems Magazine, Mainframe - November/December 2016 - L5
IBM Systems Magazine, Mainframe - November/December 2016 - L6
IBM Systems Magazine, Mainframe - November/December 2016 - L7
IBM Systems Magazine, Mainframe - November/December 2016 - L8
IBM Systems Magazine, Mainframe - November/December 2016 - L9
IBM Systems Magazine, Mainframe - November/December 2016 - L10
IBM Systems Magazine, Mainframe - November/December 2016 - L11
IBM Systems Magazine, Mainframe - November/December 2016 - L12
IBM Systems Magazine, Mainframe - November/December 2016 - L13
IBM Systems Magazine, Mainframe - November/December 2016 - L14
IBM Systems Magazine, Mainframe - November/December 2016 - L15
IBM Systems Magazine, Mainframe - November/December 2016 - L16
IBM Systems Magazine, Mainframe - November/December 2016 - L17
IBM Systems Magazine, Mainframe - November/December 2016 - L18
IBM Systems Magazine, Mainframe - November/December 2016 - L19
IBM Systems Magazine, Mainframe - November/December 2016 - L20
IBM Systems Magazine, Mainframe - November/December 2016 - L21
IBM Systems Magazine, Mainframe - November/December 2016 - L22
IBM Systems Magazine, Mainframe - November/December 2016 - L23
IBM Systems Magazine, Mainframe - November/December 2016 - 2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - November/December 2016 - SE2
IBM Systems Magazine, Mainframe - November/December 2016 - SE3
IBM Systems Magazine, Mainframe - November/December 2016 - SE4
IBM Systems Magazine, Mainframe - November/December 2016 - SE5
http://www.ibmsystemsmagmainframedigital.com/mspcomm/ibmsystemsmag/ibmsystems_mainframe_20200708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2020mfse
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
https://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
https://www.nxtbookmedia.com