Network Computing is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

CA's AllFusion ERwin Data Modeler r7: Page 2 of 4

Data models can be created in several ways. You may need to create a data model from objects that exist in your database schema, for example. AllFusion ERwin DM lets database designers integrate database objects between the design phase and the implementation phase of the database-development lifecycle. The product supports more than a dozen popular DBMSs.

Testing AllFusion ERwin DM with SQL Server 2000 and Oracle 9i proved the integration was seamless. After we ran the simple setup procedure, AllFusion ERwin DM established the connection with the database server and moved database objects seamlessly between the two environments.

You can just as easily generate SQL of the database objects and build a database with just a few clicks of the mouse. You also can save the generated SQL as a .sql file and modify it to suit your shop's needs. The generated SQL isn't pretty, but it's functional. The sample SQL we generated worked flawlessly, even with recursive relationships, check constraints and composite primary keys. CA says its product also supports all Oracle 10g syntax and database objects.

AllFusion ERwin DM's logical, clean layout makes it easy to build a database model from scratch. Entity Relationship Diagrams (data models that represent a logical view of a database and identify relationships among entities) can be created without referencing the product's extensive documentation. Just open a new document, determine the model type--logical, physical, or both--drag the entity icon from the tool bar and place it in the work area. Right click on the entity to see a list of choices. Select the attributes option and a neat dialog box appears, with options to add, change and delete attributes, as well as establish your primary key. The software also comes with templates that you can use to create your model, or you may derive a new data model from an existing one.

Problem Solved