Database Design Tool: CWD4ALL for Modeling SQL and Multidimensional Data

App Server
2003 Market
2004 Market

BizIntel
Open Source BI

Compliance
SOX

DBMS
2003 Market
2004 Market

Integration
ETL, EAI and EII

Modeling
CWD4ALL

Presentations

By Ken North

Database designs can be complex, particularly for applications that use hundreds of tables. Database administrators (DBAs) and developers typically deal with the complexity by developing a data model before generating a database. Skilled DBAs and developers are usually on the lookout for tools that simplify data modeling. One such product from the Ikan Group is for the SQL and online analytical processing (OLAP) communities, particularly those using Oracle, IBM DB2 and Microsoft SQL Server.

Ikan Group has released CWD4ALL for SQL Developer, the latest in a line of Entity Attribute Relationship (EAR) modeling tools. CWD4ALL for SQL Developer integrates with SQL Developer, the Oracle graphical tool for creating and browsing databases. CWD4ALL provides EAR modeling for Oracle 8i, 9i, 10g and other database systems. It provides logical, relational and physical modeling and supports multi-dimensional data modeling.

The multidimensional data models comply with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) specification.

CWD4ALL includes features for OLAP, ODBC and JDBC connectivity. For OLAP, there's support for Oracle Analytical Workspaces. For connectivity, there's an ODBC and JDBC bridge for accessing catalog information for purposes such as reverse engineering.

The ODBC and JDBC bridge provides access to the database objects of DB2, Microsoft SQL Server and Oracle objects. For Oracle, the bridge supports Tables, Views, Users, Clusters, Sequences, Synonyms, Tablespaces, Temp Tablespaces and Undo Tablespaces. For SQL Server, the objects include Tables, Views, Users, Logins, Roles, Rules, Defaults, Procedures and Datatypes.

Next>> 2