Modifying an existing data model

From the developerWorks archives

Ajith Punnakula, Rahul Jain, and Balaji Kadambi

Date archived: September 6, 2016 | First published: May 02, 2013

Business applications commonly need to reuse aggregated or processed data from a set of data sources over a single series of operations. An example for this could be generation of reports for analysis and decision making. In order to support this need, some database vendors have introduced support for temporary tables that can hold such aggregated or processed data. Beginning with IBM® InfoSphere® Data Architect version 8.5, you can model created global temporary tables (CGTTs) for DB2® for z/OS® version 10 and DB2 for Linux®, UNIX®, and Windows® version 9.7. This two-part series will demonstrate how you can accelerate data modeling with CGTTs with DB2 for z/OS version 10 and DB2 for Linux, UNIX, and Windows version 9.7 by adopting InfoSphere Data Architect 8.5.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=900948
ArticleTitle=Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 2: Modifying an existing data model
publish-date=05022013