The Oracle SQL Developer Data Modeler, which integrates with Oracle SQL Developer, arrived today as a standalone tool that supports logical, relational, multi-dimensional and data type modeling.

The tool is also available for Oracle Database 10g, said the release. Oracle SQL developer data modeler is generally available now and can be downloaded from the Oracle Technology Network (OTN).

經上網查詢, 發現 Oracle SQL Developer Data Modeler 可由現行資料庫的結構, 反轉為 ER 圖的功能, 可以看出 table 的關聯性, 故演練一下, 並作成筆記. 當然, table 之間必須要建立 Primary Key, Foreign Key 的關聯, 否則轉出的 ER 圖, 其效果不大.

Oracle SQL Developer Data Modeler supports both Barker and Bachman notations so developers can switch between models to suit the audience's needs or create and save different visual displays; and ...

Oracle SQL Developer Data Modeler 3.0 is designed to be used with Oracle Database 11g, IBM DB2 for Linux, UNIX and Windows (V7 and V8), IBM DB2 for OS/390 and z/OS, and Microsoft SQL Server 2000 and ...