CWD4ALL
Home Up Reshape XML CWD4ALL

 

CWD4ALL 2 ]

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
Memory
PROLIANT BL20P G3 XEON 3.6G 2P
iTunes Logo 88x31-1

 

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

2006, North Summit Media. All rights reserved.