Xml based metalanguage for a database schema definition. The following artifacts could be generated from this definition: DDL scripts for various database servers, HTML - documentation, ERD.
The Mogwai ERDesigner is a entity relation modeling tool such as ERWin and co. The only difference is that it is Open Source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation. This tool was also designed to support a flexible plug in architecture, to extend the system simply by installing a new plug in. This way, everybody can implement new features and tools to make ERDesigner fit the requirements.
ERDesigner NG
* is based on Java and can be run on Windows and Unix systems
* has a powerfull WYSIWYG for physical database design
* handles tables, relations, indexes and comments
* supports subject areas
* supports MySQL, Oracle, Microsoft SQLServer and Postgres
* creates the SQL DDL statements for schema creation
* has an integrated schema version control system
* can generate schema migration scripts for every change
* stores the database definition as XML files for further processing
* can export the database schema as GIF, BMP, JPEG or SVG files
* has an integrated reverse engineering module for existing schemas
* it is based on GPL license
* support is available by authors and newsgroups
Data Architects, DBA's, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use of their resources. The Power*Architect allows these busy highly technical resources to perform this most intricate part of their job in a fraction of the time.
The Power*Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.
Plus, the Power*Architect has the ability to take snapshots of database structures, allowing users to design DW data models while working offline.
Whether you are building a Data Warehouse or using data models to communicate business rules, the Power*Architect will facilitate and automate your data modeling efforts.
Do you hate starting on a new project and having to try to figure out someone else's idea of a database? Or are you in QA and the developers expect you to understand all the relationships in their schema? If so then this tool's for you.
SchemaSpy is a Java-based tool (requires Java 1.4 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
SchemaCrawler is a command-line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is also an API that improves on the standard JDBC metadata.
Application Ermodeller is a free CASE tool for data modelling which is built in Java. This tool supports conceptual and logical data modelling and in the final step, it allows to create physical model that is specific for particular DBMS.
The basic idea is to support development of database via ER modelling in three levels of abstraction:
* conceptual
* logical
* physical
This separation allows to create database model independent on the particular database system. You may create conceptual model and logical model that are independent on any DBMS. Then, you may generate physical model for each DBMS you will use. Afterwards, physical models allows you to generate SQL data definition for your target DBMS.
The goal is to create an eclipse plugin to design and edit entity relationship diagrams. On the other side, the plugin should also be able to create SQL and Java-Code (Hibernate) out of the diagrams.
Open System Architect (OSA) is an application used for modelling a system. OSA currently supports data modelling (physical and logical) with UML in the works. The unique thing about OSA is that it is an Open Source product licensed under the General Publi
A. Fink, D. Schrausser, and A. Neubauer. 6. Arbeitstagung der Fachgruppe Differentielle Psychologie, Persönlichkeitspsychologie & Psychologische Diagnostik, Leipzig, Deutschland, Universität Leipzig, (September 2001)
A. Neubauer, D. Schrausser, and A. Fink. 6. Arbeitstagung der Fachgruppe Differentielle Psychologie, Persönlichkeitspsychologie & Psychologische Diagnostik, Leipzig, Deutschland, Universität Leipzig, (September 2001)
A. Neubauer, D. Schrausser, G. Sange, and G. Pfurtscheller. 5. Arbeitstagung der Fachgruppe Differentielle Psychologie, Persönlichkeitspsychologie & Psychologische Diagnostik, Wuppertal, Deutschland, Bergische Universität Wuppertal, (October 1999)
A. Neubauer, D. Schrausser, and H. Freudenthaler. 42. Kongreß der Deutschen Gesellschaft für Psychologie, Jena, Deutschland, Friedrich-Schiller-Universität Jena, (September 2000)
A. Neubauer, A. Fink, and D. Schrausser. Symposium 'Physiological approaches to human intelligence' at the 10th Biennial Meeting of the International Society for the Study of Individual Differences (ISSID), Edinburgh, United Kingdom, The University of Edinburgh, (July 2001)
D. Schrausser, A. Fink, and A. Neubauer. 5. Tagung der Österreichischen Gesellschaft für Psychologie (ÖGP), Wien, Österreich, Universität Wien, (March 2002)
D. Schrausser, A. Fink, and A. Neubauer. Symposium 'Physiological approaches to human intelligence' at the 10th Biennial Meeting of the International Society for the Study of Individual Differences (ISSID), Edinburgh, United Kingdom, The University of Edinburgh, (July 2001)