SQL Power Architect數(shù)據(jù)庫建模

SQL Power Architect 是一個(gè)Java開發(fā)的數(shù)據(jù)庫建模工具，特別適合做數(shù)據(jù)倉庫和數(shù)據(jù)集市的應(yīng)用建模，它允許設(shè)計(jì)人員同時(shí)打開多個(gè)數(shù)據(jù)源連接，并直接從數(shù)據(jù)庫中獲取模型定義，可進(jìn)行不同數(shù)據(jù)庫之間的模型、表、列的拖放操作。

特點(diǎn)：

• 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