#free #data #modeling #tool, #data,process,modeling,case #tool,business, #software,engineering,database #reverse #engineering,modelling,design,flow,diagram, #er,conceptual,physical,re-engineering,modelsphere,java #designer, #dbms,evaluation,best #modeling #tool
Open ModelSphere –
Free Software Tool for Conceptual and Relational Data Modeling,
Business Process Modeling and UML Modeling
Open ModelSphere is a powerful free data, process and UML modeling tool / software. Open ModelSphere covers conceptual and logical data modeling as well as physical design, i.e. database modeling (database modelling). It supports several notations, e.g. Entity-Relationship, DATARUN and Information Engineering. Conceptual models can be converted to relational models and vice versa.
Thanks to its reverse engineering capabilities, Open ModelSphere allows graphical visualization of your relational database’s architecture, thus making modifications easy. As a complete data modeling tool / software, it allows the generation of SQL scripts from your model as well. Open ModelSphere supports all the database management systems in a generic manner. A standard built-in interface connects to SQL databases via ODBC/JDBC driver.
Open ModelSphere also includes expert modules to validate the integrity of your architecture and the coherence of what you established (meeting the requirements of each DBMS). This validation expertise will help you save research time among the multitude of restrictions that exists in each management system.
Open ModelSphere also helps systems analysts to integrate the creation of data flow and business process diagrams and to elaborate an enterprise’s workflow and logistics. You can specify resources, transactions, communicational exchanges, cost calculated in time, money and effort, etc. Open ModelSphere is not restricted to business process modeling, but also allows you to set up the technical design at the application system level.
Open ModelSphere supports you to schematize the various processes’ details in a hierarchical manner, thus enabling you to decompose a process in subprocesses. This way, it is easy to keep an overview, while having access to a very detailed view of the processes. When setting the data flow diagram, it becomes easier to design a relational database that meets the company’s needs, hence avoiding loss of time and money.
Last, but not least – Open ModelSphere provides the functionality of a rich UML modeling tool / software. You can create Activity, Class, Collaboration, Component, Deployment, Package, Sequence, Statechart and Use Case diagrams.
With respect to the coexistence of relational and object-oriented approaches, class models can be linked to data models. Moreover, class models can be generated from data models and vice versa.