SQL Power Architect数据库建模

SQL Power Architect 是一个Java开发的数据库建模工具，特别适合做数据仓库和数据集市的应用建模，它允许设计人员同时打开多个数据源连接，并直接从数据库中获取模型定义，可进行不同数据库之间的模型、表、列的拖放操作。

特点：

• Accesses source databases via JDBC


• Connects to multiple source databases concurrently


• Compares data models & database structures and identifies discrepancies


• Drag-and-drop source tables & columns into the playpen


• Remembers the origin of each column


• Generates source-to-target visual Mapping Reports


• Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more


• Saves source data structure snapshots in the project, so you can work remotely


• All project data is stored in an easy-to-parse XML format


• OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels


• GPL (version 3) licensed