Preparing for DB2 Near-Realtime Business Intelligence

xiv Preparing for DB2 Near-Realtime Business Intelligence

򐂰 Appendix C describes the data models used for the test scenarios. It shows

the Entity Relationship (ER) Model typically used for OLTP and how that data

can be used for development of the star schema data model most typically

used for data warehousing.

򐂰 Appendix D describes the implementation process for WebSphere MQ and

the DB2 MQ Listener products used for the project testing. It is intended as

information to make your implementation process easier and faster.

򐂰 Appendix E provides examples of some of the stored procedures and scripts

used in our implementation. They can be used for information purposes and

guidelines as you develop your stored procedures.

򐂰 Appendix F presents the results of related tests run in the Toronto Lab. The

tests are similar in some cases, and subsets in others. They are provided as

another source of validation for our test results.

The team that wrote this redbook

This redbook was produced by a team of specialists from around the world,

representing IBM and IBM Business Partners. The Team worked on-site at the

International Technical Support Organization in San Jose, California. The team is

depicted here.

Left to Right: (Back) Pagadala J. Suresh, Andy Perkins, Olaf Mueller

(Front) Zhi Yuan Pan, Roopa MS, Chuck Ballard

Preface xv

The following are brief biographical descriptions of the team members:

Chuck Ballard is a Project Leader at the International Technical Support

Organization, in San Jose, California. He has over 35 years experience, holding

positions in the areas of Product Engineering, Sales, Marketing, Technical

Support, and Management. His expertise is primarily in the areas of database,

data management, data warehousing, business intelligence, and process

re-engineering. He has written extensively on these subjects, taught classes, and

presented at conferences and seminars worldwide. Chuck has both a bachelor’s

degree and a master’s degree in Industrial Engineering from Purdue University.

Roopa MS is a Software Engineer in India and has three years of experience in

the area of databases and supply chain management. She holds a bachelor’s

degree in Electronics from Bangalore University. Her areas of expertise include

DB2 Administration and Performance Tuning on AIX®, especially with respect to

Enterprise Resource Planning application environments, such as SAP and

BaaN. Roopa is an IBM Certified Solutions Expert for DB2 V7.1 DB

Administration.

Olaf Mueller is an IT Specialist with IBM Global Services AMS SI e-Business

Integration in Duesseldorf, Germany. He has 13 years of experience as a

Database Specialist working in the areas of application development, database

architecture, and database administration. He is a IBM Certified Solutions Expert

for DB2 V7.1 DB Administration and DB2 V7.1 Family Application Development.

He is also a IBM Certified Advanced Technical Expert for DB2 Data Replication

and DB2 DRDA®. His areas of expertise also include Oracle and data modeling.

Zhi Yuan Pan is an Advisory IT Specialist in the Advanced Technical Support,

TSS, IBM China. He has ten years of experience in database software for

distributed platforms, and over seven years of experience in the IT industry

specializing in database post-sales and pre-sales support. His areas of expertise

include Data Replication, Information Integrator, MQSeries®, and AIX, and he is

an IBM Certified Database Administrator. Zhi Yuan holds a master’s degree in

Computer Software from Peking University.

Andy Perkins is a Certified Consulting IT Specialist supporting business

intelligence technical presales activities in the IBM Americas Business

Intelligence Solutions Center in Dallas, Texas. He has over 20 years of

experience in the IT field, concentrating primarily on DB2 and related solutions.

He holds a bachelor’s degree in Computer Science from the University of

Houston. His areas of expertise include DB2 UDB across all platforms, DB2

Warehouse Manager, and DB2 OLAP Server™.

Pagadala J. Suresh is a Software Engineer, in India, and has two years of

experience in the area of Web Technologies. He holds a master’s degree in

Computer Applications from Karnataka Regional Engineering College, Surathkal.