IBM® InfoSphere® Data Architect (formerly Rational® Data Architect) is a collaborative enterprise data modeling and integration design tool to discover, model, relate, and standardize diverse and distributed data assets.
In Part 2 of this article series, use InfoSphere Data Architect 8.5 to modify an existing data model to incorporate changes in requirements for the created global temporary table. More >
- Modeling created global temporary tables for DB2 with
InfoSphere Data Architect 8.5, Part 1: Getting Started
Leverage InfoSphere Data Architect to create a physical data model with CGTT (created global temporary tables) and then generate a DDL with CGTT-specific syntax that you can run on a database server.
- Best practices for IBM InfoSphere Blueprint Director, Part
Use Blueprint Director to create effective blueprints from scratch; learn the benefits for creating and managing blueprints, visualizing the metadata landscape based on best practices; and incorporate the physical deployment landscape into your information blueprint.
- Multiple dimensional data modeling using InfoSphere Data
Architect, Part 3: Transformations
In Part 3 of this article series, learn how to transform models from a Cognos model to a cubing model, or from a cubing model to a Cognos model, and then update the models for consolidation.
- Dimensional modeling with InfoSphere Data Architect, Part 2:
Follow the workflow outlined in part two of this series to learn how to update existing data models and minimize the impact on the production environment by reverse engineering from an existing data source.
- Update: Creating scripts more efficiently in the SQL and
Get on board with new enhancements to the SQL and XQuery editor, a feature of Data Studio, InfoSphere Data Architect, and InfoSphere Optim Query Tuner.
- Bitemporal modeling with InfoSphere Data Architect, Part 2:
Modeling system period temporal requirement
In Part 2 of this series, learn how to model bitemporal properties within tables by modifying the physical data model that was created in Part 1, or reverse-engineering a database to create and then modify a new model using InfoSphere Data Architect 7.6.
- Bitemporal modeling with InfoSphere Data Architect, Part 1:
Modeling application period temporal requirement
Create a temporal logical data model, transform it into a physical model for DB2 for z/OS version 10, and then generate DDL with temporal-specific syntax that you can run on a database server.
- Dimensional modeling with IBM InfoSphere Data Architect,
Use this collaborative data design solution to discover, model, relate, and standardize diverse and distributed data assets. Part 1 focuses on using forward engineering to achieve a multidimensional data model.
- Integrating Rational Software Architect with InfoSphere Data
Make your application model and data model work together using this article, which is updated for the InfoSphere Data Architect product (formerly the Rational Data Architect product).