SQL Power Architect 数据库建模

SQL Power Architect 是一个Java开发的数据库建模工具，特别适合做数据仓库和数据集市的应用建模，它允许设计人员同时打开多个数据源连接，并直接从数据库中获取模型定义，可进行不同数据库之间的模型、表、列的拖放操作。特点：Accesses source databases via JDBCConnects to multiple source databases concurrentlyCompares data models & database structures and identifies discrepanciesDrag-and-drop source tables & columns into the playpenRemembers the origin of each columnGenerates source-to-target visual Mapping ReportsForward/reverse engineers PostgreSQL, Oracle, MS SQL Server & moreSaves source data structure snapshots in the project, so you can work remotelyAll project data is stored in an easy-to-parse XML formatOLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & LevelsGPL (version 3) licensed