Home Up


Fast, reliable data access for ODBC, JDBC, ADO.NET and XML
WSSC 2008: An event dedicated to SOA and Web Services Security
Got SOX compliance?
Movielink Logo 88x31
Business Intelligence with R&R ReportWorks
IBM eserver xSeries 306m 8849 - P4 3.4 GHz
iTunes Logo 88x31-1


Database Design: CWD4ALL for Modeling SQL and Multidimensional Data

App Server
2003 Market
2004 Market

Open Source BI


2003 Market
2004 Market




<<Previous 1 2

After refining and validating the data model, CWD4ALL users can generate the SQL Data Definition Language (DDL) for creating tables and other database objects. Besides Oracle databases, CWD4ALL for SQL Developer can also generate SQL DDL for IBM DB2 UDB, DB2 for z/OS, Microsoft SQL  Server 2000 and 2005. It can import Oracle Designer models and it stores metadata in XML format.

Reverse Engineering, Forward Engineering

CWD4ALL's reverse engineering capability enables a DBA or database designer to access the catalog of an existing database to generate a logical model of the database.

Figure 1:  View of a logical model with CWD4ALL

Ikan Group uses forward engineering to describe the process of creating a new database from a data model. When there is no existing database, the designer or DBA creates and refines a logical and physical model. The logical model defines relationships between data and it's independent of the SQL DBMS platform .

After the CWD4ALL user completes the process of refining and validating a model, he or she can generate the appropriate SQL DDL for the target database (DB2, Oracle or SQL Server). This process provides a measure of platform independence because it's possible to use a single logical model to generate DDL for disparate SQL platforms. 

Besides CWD4ALL for SQL Developer, Ikan Group also offers CWD4ALL for Oracle JDeveloper. It integrates with Oracle JDeveloper 10.1.2 or higher and requires JDK 1.4.1 or higher versions. CWD4ALL for Oracle JDeveloper runs with Microsoft Windows operating systems, including Windows 98/NT/2000 and Windows XP. Ikan Group is also enhancing CWD4ALL to support OLAP using Microsoft SQL Server 2005  Analysis Services.

CWD4ALL Trial Software

Ikan Group offers fully-functional 30-day trial versions of CWD4ALL, CWD4ALL for JDeveloper and CWD4ALL for SQL Developer. Download the CWD4ALL trial software from the company's web site.

About the Author

Ken North is a consultant, author, speaker and industry analyst. He is the editor of and he teaches Expert Series seminars. Ken is the author or co-author of several books, including Database Magic with Ken North and Windows Multi-DBMS Programming.

<<Previous 1 2

2006, North Summit Media. All rights reserved.