IBM Informix: Integration Through Data Federation

This IBM Redbooks publication describes how to create and implement a federated data management environment. That environment can enable access to, and use of, multiple heterogeneous data sources as if they were all resident in the same data management system. We use Informix Dynamic Server (IDS) and DB2 as the primary data sources, along with Informix Extended Parallel Server (XPS), Red Brick Warehouse, Oracle9i, and Microsoft Excel as data sources. We also use data management tools, such as IBM DB2 Information Integrator and Informix Enterprise Gateway Manager, to provide the data federation. For data access tools, we use DB2 Command Center, Server Studio JE for Informix, and Brio Explorer to show data federation in action. With the combined functionality of the Informix and DB2 database management systems and the DB2 Information Integrator, you can implement a very powerful federated data management environment. Informix customers will be well positioned to take advantage of the expanded capabilities for integration through data federation, as well as future enhancements.

Chapter 1. Data federation overview
Chapter 2. The data federation project
Chapter 3. Overview of project data sources
Chapter 4. DB2 Information Integrator
Chapter 5. Informix Enterprise Gateway Manager
Chapter 6. Data federation in action
Chapter 7. Optimization in a federated environment
Chapter 8. Hints and tips
Appendix A. DB2 II and Informix EGM function summary
Appendix B. Nonrelational wrappers

• IBM System z10 Enterprise Class Technical Introduction, SG24-7515-02
• IBM Power 595 Technical Overview and Introduction, REDP-4440-00
• TCP/IP Tutorial and Technical Overview, GG24-3376-07

Publish Date
08 September 2003

Rating:
(based on 2 reviews)

Rate this book

Author(s)

Chuck Ballard is a Project Leader at the International Technical Support Organization, in San Jose, California. He has over 35 years of 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 Bachelors degree and a Masters degree in Industrial Engineering from Purdue University.

• Chuck Ballard

Nigel Davies is an IT Architect working at the Cumberland Forest Application Centre in Sydney for IBM Global Services Australia. Although now living and working in Australia, he is originally from the United Kingdom, where he earned his Masters degree in Chemistry at Oxford University. He has over 22 years of experience in the IT industry. During this time he has worked as a programmer, designer, business analyst, DBA, and even project manager, before finally settling down as an IT architect. Nigel has been working with DB2 since 1987 and has previously published articles on DB2 performance for the UK trade journal Info Plus. He has worked for IBM GSA for seven years.

• Nigel Davies

Marcelo Gavazzi is an Advisory Software Engineer within the IBM Software Group organization working at the Latin America Call Center in Miami, Florida. He is originally from Brazil and holds a degree in Computer Sciences from Universidade Mackenzie. He has more than ten years of experience supporting RDBMS systems, including Informix database servers and DB2 UDB. Marcelo is a certified "Informix Dial-up engineer" for interventions on critical systems throughout the Latin America region, providing diagnostics and fixes in the emergency support line. He is also involved in training projects disseminating new technologies to the technical support community. He holds professional certifications on both Informix and DB2 UDB products.

• Marcelo Gavazzi

Jochen Stephani is a DM Consultant/IT Specialist working on the Technical Sales Team in IBM's Information Management Division in Munich, Germany. He joined Informix in April 1996 and has more than seven years of experience working with Informix databases on high-end OLTP and business intelligence projects, including benchmarks, prototyping, and performance tuning. He has contributed to many important projects across the region and is a 'trusted advisor' for strategic customers. Based on his experience and product skills, his major focus as a DM Consultant is to provide architectural guidance. He holds a degree in Computer Sciences from the Fachhochschule of Rosenheim.

• Jochen Stephani

Martin Lurie (pictured at left) was the remote team member. Marty is a Systems Engineer in IBM's Data Management Division, and is located in Boston, Massachusetts. He is an IBM-certified DB2 DBA, IBM certified Business Intelligence Solutions Professional, and an Informix-certified Professional.

• Martin Lurie

ISBN

0738499897

IBM Form Number
SG24-7032-00

Number of pages
264