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
Left to Right: (Back) Pagadala J. Suresh, Andy Perkins, Olaf Mueller
(Front) Zhi Yuan Pan, Roopa MS, Chuck Ballard
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
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.