Tool Mentor: Reverse Engineering Databases Using Rational XDE Developer










var backPath = './../../../';
var imgPath = './../../../images/';
var nodeInfo=[{view: "view:_LVCagP5WEdmAzesbYywanQ", path: ["_LVCagP5WEdmAzesbYywanQ", "_gpYSoAILEdq-_NKqZM1EhA", "_qS-iwAIOEdqTna4sZVFRow", "{303A82D2-E3AB-4501-8563-0D4D43782AF9}", "{8F40AECA-8AAA-4409-81F0-BFB7B6BECDBC}"]}, {view: "view:_LVCagP5WEdmAzesbYywanQ", path: ["_LVCagP5WEdmAzesbYywanQ", "_zRigkAILEdq-_NKqZM1EhA", "_U5tiUAISEdqTna4sZVFRow", "{303A82D2-E3AB-4501-8563-0D4D43782AF9}", "{8F40AECA-8AAA-4409-81F0-BFB7B6BECDBC}"]}, {view: "view:_LVCagP5WEdmAzesbYywanQ", path: ["_LVCagP5WEdmAzesbYywanQ", "_AUv4MAIMEdq-_NKqZM1EhA", "_5ZuQsAIUEdqEutyfYo0quQ", "{303A82D2-E3AB-4501-8563-0D4D43782AF9}", "{8F40AECA-8AAA-4409-81F0-BFB7B6BECDBC}"]}, {view: "view:_FCx1oN7CEdmsEI4YDGX2ag", path: ["_FCx1oN7CEdmsEI4YDGX2ag", "_jD8dUAIbEdqEutyfYo0quQ", "_F1OgYAIbEdqEutyfYo0quQ", "{303A82D2-E3AB-4501-8563-0D4D43782AF9}", "{8F40AECA-8AAA-4409-81F0-BFB7B6BECDBC}"]}];
contentPage.preload(imgPath, backPath, nodeInfo, '', false, false, false);










Tool Mentor: Reverse Engineering Databases Using Rational XDE Developer















This tool mentor describes the use of reverse engineering in the Rational XDE developer software tool to generate a Data Model from an existing database schema or DDL script file.


Tool: Rational XDE Developer






Relationships



Related Elements


Database Design






Main Description



Overview This tool mentor describes the use of reverse engineering in the Rational XDE (TM) software tool to generate a Data Model from an existing database schema or DDL script file. The following steps are performed in this tool mentor: Reverse Engineer a Database Transform Tables to Classes <optional> Manage Changes to the Model and the Database Reverse Engineer a Database In Rational XDE, you can build a model of the physical database design through reverse engineering of the database or a Data Definition Language (DDL) file. Reference: Building Data Models by Reverse Engineering . You initiate the reverse engineering process using the Rational XDE data modeling Reverse Engineering Wizard.  (See Reverse Engineering DDLs or Databases .) The Reverse Engineering Wizard reads the database schema or DDL and creates: A package containing the tables, columns, constraints, relationships, stored procedures, and views. See Designing Data Models . A package containing the domains. See Domains . A database containing a realization relationship for each table. See Realize Relationships in Data Modeling . To reverse engineer a database, Rational XDE must be able to establish a connection to the database. (See Connecting to Database Management Systems .)  Note that the results of the reverse engineering process might vary with each DBMS. Refer to the following topics for further details on reverse engineering databases for a specific DBMS: Oracle Database Reverse Engineering SQL Server Database Reverse Engineering Sybase Database Reverse Engineering DB2 Database Reverse Engineering For more information on establishing database connections for a specific DBMS, consult the following topics in the Rational XDE online Help: Oracle Database Connections SQL Server Database Connections Sybase Database Connections DB2 Database Connections Transform Tables to Classes <optional> Once a database has been reverse engineered to create a model of the physical database design, you can optionally decide to transform the tables into classes that can become part of the logical database design in the Design Model or in a separate Logical Data Model. (See Logical Data Model .) You can transform one table or all the tables contained in a package or realized by a database. (See Transforming Tables to Classes .) The package must contain all of the participants in a relationship to transform that relationship to the Logical Data Model. For additional details on designing and modeling a database, see Tool Mentor: Designing and Modeling Databases in Rational XDE. Refer to the following topics in the Rational XDE online Help for further details on the table-to-class transformation process: Table to Class Transformation Table to Class Transformation Mapping Transforming Tables and Classes Manage Changes to the Model and the Database After a Data Model has been created through the reverse engineering process, updates to the Data Model and database must be controlled and managed. Rational XDE provides a Compare and Synchronize feature to assist the database designer in managing change. (See Comparing and Synchronizing in Data Modeling , Tool Mentor: Managing Databases in Rational XDE.) Use of the Compare and Synchronize feature is recommended over periodic reverse engineering, since using the reverse engineering process multiple times on the same model can cause duplicate tables and relationships in the Data Model.





This content developed or partially developed by Applied Information Sciences. ©  Copyright IBM Corp. 1987, 2006.  All Rights Reserved.







contentPage.onload();