Return to site

Application Modeling Tool

broken image


This article compares UML tools. UML tools are software applications which support some functions of the Unified Modeling Language.

  1. Application Modeling Tool Online

General[edit]

Threat modeling is a core element of the Microsoft Security Development Lifecycle (SDL). It's an engineering technique you can use to help you identify threats, attacks, vulnerabilities, and countermeasures that could affect your application. You can use threat modeling to shape your application's. Blender is the free and open source 3D creation suite. It supports the entirety of the 3D pipeline—modeling, rigging, animation, simulation, rendering, compositing and motion tracking, video editing and 2D animation pipeline.

NameCreatorPlatform / OSFirst public releaseLatest stable releaseOpen sourceSoftware licenseProgramming language used
ArgoUMLTigris.orgCross-platform (Java)1998-042011-12-15[1]YesEPLJava, C++ (as module)
AstahChange Vision, Inc.Cross-platform (Java)2009-10-192019-01-30NoCommercial. Free education edition, subscription modelJava
ATLObeo, INRIA
Free software community
Cross-platform (Java)Unknown2010-06-23YesEPLJava
Borland TogetherBorlandCross-platform (Java)Unknown2008NoCommercialUnknown
BOUMLBruno PagèsCross-platform2005-02-262019-07-15NoFree from v7.0, Commercial starting from v5.0 up to v6.12,GPL before v5.0[2]C++/Qt and Java ('plug-out')
CacooNulabWindows 7+, Mac OS XOctober 2010July 2018NoCommercial, Free edition availableHTML5
CaseCompleteSerlio SoftwareWindows20042013-04NoCommercialC#
ConceptDraw PROCS OdessaWindows, macOS19932010 (v9)NoCommercialUnknown
DiaAlexander Larsson/GNOME OfficeCross-platform (GTK+)2004?2012-07-05YesGPLC
Eclipse UML2 Tools[3]Eclipse FoundationCross-platform (Java)20072018-12-03YesEPL?Java
Edraw MaxEdrawsoftWindows, Linux, macOS20042015-03NoCommercialC++
Enterprise ArchitectSparx SystemsWindows (supports Linux and macOS installation)20002019-03-06NoCommercialC++
GliffyGliffyChrome, Safari, Firefox, Internet Explorer 9+2006-08-012015-01 (v. 5.1)NoCommercial, Free trialHTML5 and JavaScript
JDeveloperOracle CorporationCross-platform (Java)UnknownUnknownNoFreewareJava
LucidchartLucid SoftwareWindows, macOS, Linux, Solaris2008-122014-10-07NoCommercial / Free (educational)HTML5 and JavaScript
MagicDrawNo MagicCross-platform (Java)19982017-02-20 (v18.5)NoCommercialJava
Microsoft VisioMicrosoftWindows19922016 (v16.0)NoCommercialUnknown
Microsoft Visual StudioMicrosoftWindows1997-022016-06-27NoCommunity & Express editions: Registerware; Enterprise, Professional & Others editions: TrialwareC++, C#
ModelioModeliosoft (SOFTEAM Group)Windows, Linux, macOS20092019-04-17 (3.8.1)YesGPL and CommercialJava
MyEclipseGenuitecWindows, Linux2003[4]UnknownNoCommercialJava
NClassBalazs TihanyiWindows, macOS, Linux, Unix2006-10-152011-06-06YesGPLC#
NetBeans[5]Oracle CorporationWindows, macOS, Linux, Unix19962013-02-21YesCDDL or GPL2Java
Open ModelSphereGranditeCross-platform (Java)2002-022009-11-04YesGPLJava
PapyrusCommissariat à l'Énergie Atomique, Atos OriginWindows, Linux, macOS (Java)2013-06-272018-12YesEPLJava
PlantUMLArnaud RoquesCross-platform (Java)1999-04-302017-09-03YesGPLJava
Poseidon for UMLGentlewareCross-platform (Java)Unknown2009NoCommercialJava
PowerDesignerSybaseWindows19892018NoCommercialUnknown
PragmaDev StudioPragmaDevWindows, Linux, OS X20022018-02-07NoFree, CommercialPython, C, C++
Prosa UML ModellerInsoft OyWindows19962013-10-19NoCommercialC/C++
Rational RhapsodyIBMWindows, Linux19962019-04-23 (8.4.0) - 2019-08-08 (8.4 Interim Fix 1)NoCommercialC, C++, Java, Ada
Rational Rose XDEIBMWindows, Linux, UnixUnknownUnknownNoIBM EULAUnknown
Rational Software ArchitectIBMWindows, LinuxEarly 1990s2015-09-18NoIBM EULAJava/C++
Rational Software ModelerIBMWindows, Linux2004-10-132008-09NoIBM EULAUnknown
Rational System ArchitectIBMWindowsUnknown2013-03-15NoCommercialUnknown
Reactive BlocksBitreactiveWindows, macOS, Linux2011-11-132016-09-16NoCommercial, Free Community EditionJava
RISERISE to Bloome SoftwareWindows (.NET)20082010-09-03NoFreewareC#
Software Ideas ModelerDusan RodinaWindows (.NET), Linux (Mono)2009-08-06[6]2019-02-01NoCommercial, Freeware for non-commercial useC#
StarUMLMKLabWindows, macOS, Linux2005-11-012018-08-17NoCommercialDelphi
Umbrello UML ModellerUmbrello TeamUnix-like; Windows2006-09-092018-08-29YesGPLC++, KDE
UML DesignerObeoWindows, macOS, Linux20122017-09-18YesEPLJava, Sirius
UMLetThe UMLet TeamWindows, macOS, Linux2005-11-05[7]2016-11-24[7]YesGPLJava
UModelAltovaWindows2005-052018-10-17NoCommercialJava, C#, Visual Basic
UmpleUniversity of OttawaCross-platform; Java/Eclipse20082018-02-19YesMIT LicenseUmple, Java, PHP, Javascript
Visual Paradigm for UMLVisual Paradigm Int'l Ltd.Cross-platform (Java)2002-06-202018-11-28NoCommercial, Free Community EditionJava, C++
WhiteStarUMLjanszpilewskiWindows 7-102011-12-182017-05-14[8]YesGPL2Delphi
yEdyWorks GmbHWindows, macOS, Linux, UnixUnknown2016-07-15[9]NoFreeJava
NameCreatorPlatform / OSFirst public releaseLatest stable releaseOpen sourceSoftware licenseProgramming language used

Features[edit]

NameUML 2MDAXMITemplatesLanguages generatedLanguages reverse engineeredCan be integrated withDetails
PragmaDev StudioYesYesPartialNoC, C++NoIntegration with Reqtify traceability tool. Model simulator integrated with any FMI 2.0 supporting tool. Generated code can be integrated on the following RTOS: VxWorks, FreeRTOS, ThreadX, CMX, OSE Delta, OSE epsilon, uITRON 3, uITRON 4, Nucleus, posix, win32.Dedicated to modeling and testing of communicating systems. Based on ITU-T Z.109 UML profile, SDL-RT, SDL. The model can be simulated and can be exported to model checking tools. Full testing environment integrated based on TTCN-3.
ArgoUMLNoYesYesUnknownC++, C#, Java, PHP4, PHP5, RubyJava (other languages with plugins)UnknownClosely follows the UML standard
AstahYesNoYesUnknownJava, C++, C#, Python, Ruby and any other languages with pluginsJava, C++, C#, PHPMind Mapping, ER Diagram, DFD, Flowchart, CRUD, Traceability Map, Requirement Diagram and Requirement table. Provides API and Plugins, RTF, HTML Export.
ATLYesNoYesNoUnknownUnknownAvailable from the Eclipse M2M project (Model to Model).Can transform UML & EMF models into other models. It has a repository of transformations called ZOO about a large set of common industrial concerns and educational labs.
Borland TogetherYesYesNoYesJava 6, C++, CORBAUnknownEclipse and MS VS.NET 2005
BOUMLYesYesYesYesC++, Java, PHP, IDL, Python, MySQLC++, Java, PHP, MySQLUnknownUML 2. Solid code roundtrip, fast. Extensible through 'plug-outs' written in C++ or Java
CacooYesUnknownUnknownYesUnknownUnknownGoogle Drive, Google Docs, Typetalk, Adobe Creative Cloud, Slack, Atlassian Confluence, Dropbox, Visio, Box.
CaseCompleteUnknownUnknownExportUnknownUnknownUnknownUnknownProvides management and editing of use cases, their flow of events, and referenced requirements. Supports use case and activity diagrams.
DiaPartlyNoNoNoIncluded Python script codegen.py 'export filter' to Python, C++, JavaScript, Pascal, Java, PHP; external tools add Ada, C, PHP5, Ruby, shapefile, C#, SQL (Sybase, Postgres, Oracle, DB/2, MS-SQL, MySQL, …)NoNoUses Python as scripting language
Eclipse UML2 ToolsYesYesYesYesJava (or Eclipse project supported?)Java (or Eclipse project supported?)EclipseTen UML 2 diagram types.
Enterprise ArchitectYesYesYesSupports MDA templates and Code Generation templatesActionScript, C, C#, C++, Delphi, Java, PHP, Python, Visual Basic, Visual Basic .NET, DDL, EJB, XML Schema, Ada, VHDL, Verilog, WSDL, BPEL, Corba IDLActionScript, C, C#, C++, Delphi, Java, PHP, Python, Visual Basic, Visual Basic .NET, DDL, XML Schema, WSDLEclipse & Visual StudioUML 2.5, SysML, BPMN, SoaML, SOMF, WSDL, XSD, ArchiMate. Frameworks: UPDM, Zachman, TOGAF. Forward and Reverse Engineering for code and Database. Model Driven Integrated Development (Edit/Build/Debug) for Java, .Net, PHP & GNU compilers. Simulates Activity, State Machine, Sequence and BPMN diagrams.
GliffyYesUnknownUnknownYesUnknownUnknownGoogle apps, Google drive, JIRA, ConfluenceHas libraries of shapes for: UML class, sequence, activity, use case and more.
LucidchartUnknownUnknownUnknownUnknownUnknownUnknownGoogle Drive, Google Apps, JIRA, Confluence, Jive, and Box.
MagicDrawYesYesYesYesJava, C++, C#, CIL, CORBA IDL, DDL, EJB, XML Schema, WSDLJava, C++, C#, CIL, CORBA IDL, DDL, EJB, XML Schema, WSDLEclipse, EMF, NetBeansUML 2.3, Full round-trip support for Java, C++, C#, CL (MSIL) and CORBA IDL, Report generator from template in RTF, HTML, XML, ODT, ODS, ODP, and Text (DOCX, XLSX, PPTX since 16.8).
Microsoft VisioPluginUnknownPluginPluginUnknownUnknownUnknown
ModelioYesYesYesYesJava, C++, C#, XSD, WSDL, SQLJava, C++, C#Eclipse,EMFFull UML2, BPMN2, ArchiMate3. Documentation generation in HTML.Extensions providing documentation generation in Open XML format, support for TOGAF, SysML, SoaML, Hibernate, OMG MARTE standard. Support of model fragments for collaboration. Support of design patterns.
MyEclipseUnknownUnknownUnknownUnknownUnknownUnknownUnknown
NClassUnknownUnknownUnknownUnknownC#, JavaC#, JavaUnknown
NetBeansUnknownUnknownUnknownUnknownJavaJavaUnknownHas to be installed as a plug in to enable the UML modeling.
Open ModelSphereNoUnknownUnknownYesJava, SQLJavaUnknownSupports data, business-process and UML modeling
PapyrusYesUnknownYesUnknownAda 2005, C/C++, Java addinsUnknownEclipse
PlantUMLYesUnknownExportUnknownUnknownC#, grails, Java, Lua, PHP, SqlALchemyChrome, Word, Open Office, Google Docs, J2EE Servlet, JQuery, Sublime, Eclipse, NetBeans, IntelliJ, LaTeX, Emacs, Doxygen, etc.[10]Creates diagrams using simple text language. Sequence, use case, class, activity, component, state, object, and UI mock diagrams are supported. Outputs images in PNG or SVG format.
Poseidon for UMLYesUnknownUnknownUnknownUnknownUnknownUnknownCommercial version of ArgoUML
PowerDesignerYesYesYesYesJava, C#, VB .NETUnknownEclipseData-modeling, business-process modeling - round trip engineering
Prosa UML ModellerYesYesOpen modelbaseYesC++ Java, C#, SQL DDL and SQL queriesC++ Java and C# class headers are synchronized between diagrams and code in real-timeProgrammer's workbenches, documentation tools, version control systemsSupports following UML diagrams: Use case diagram, Sequence diagram, Collaboration diagram, Class diagram, Statechart diagram, Activity diagram, Component diagram, Deployment diagram and Package diagram
Rational RhapsodyYesYesYesYesC++, C, Java, Ada, Corba, Customizable for other languagesC++, C, Java, Ada, Customizable for other languagesVisual Studio, Eclipse, TcSE, WindRiver, Green Hills, QNX, Linux, Mathworks Simulink, DOORS, customizable for othersTargets real-time or embedded systems and software using industry standard languages (UML, SysML, AUTOSAR, DoDAF, MODAF, UPDM, DDS), full production-quality code generation (structural, behavioral, functional), simulation, model based testing, integration with numerous real time operating systems and IDE's
Rational Rose XDENoUnknownUnknownUnknownUnknownUnknownUnknown
Rational Software ArchitectYesYesYesUnknownJava, C#, C++, EJB, WSDL, XSD, IDL, SQLJava, C++, .NETEclipse
Rational Software ModelerYesYesUnknownUnknownUnknownUnknownEclipse
Rational System ArchitectNoUnknownExportUnknownC++, Java, WSDLC++, Java, WSDLUnknown
Reactive BlocksYesNoYesNoJavaUnknownEclipseCode generation from Activity Diagrams for J2SE, OSGi, Kura, and ESF, unit testing via JUnit, supports formal analysis and state space simulation
Software Ideas ModelerYesYesYesYesActionScript, C++, C#, Delphi, Java, JavaScript, PHP, Python, Ruby, SQL DDL, VB.NET, VB6, XSDC++, C#, VB.NET, Java, Object Pascal, PHP, RubyUnknownUML, BPMN, SysML, ArchiMate, JSD, Data Flow Diagram, Flowchart, Robustness Diagram, CRC, ERD, Mixed Diagram, HTA, UI, Venn, Behavior Tree, Structure Chart, Decision Table, Roadmap, Computer Network Diagram, Layer Diagram, Web Page Diagram, Grafcet, custom diagrams
StarUMLYesYesImportYesJava,C#,C++Java,C++,C# Code Generator and Reverse EngineerJavaScript, Node.jsPlug-in architecture: JavaScript, HTML5, Node.js
Umbrello UML ModellerYes[11]YesYesUnknownC++, Java, Perl, PHP, Python … 16C++, IDL, Pascal/Delphi, Ada, Python, Java; import XMI, RoseMDLKDE
UML DesignerYesYesYesUnknownAny kind of languages as it is compatible with code generator tools like Eclipse UMLGenerators or AcceleoAny kind of languages supported by Eclipse UML GeneratorsEclipseOpen source under EPL license, based on Eclipse, EMF, Sirius
UMLetNoUnknownUnknownNoUnknownUnknownEclipse
UModelYesYesYesYesJava, C#, Visual BasicJava, C#, Visual BasicEclipse, Visual StudioAlso supports business process modeling, SysML, and database modeling
UmpleClass, State, Composite Structure onlyNoYesYesJava, C++, SQL, Alloy, NuSMV, yUML, USEJavaCommand-line tools, Embeddable in web pages, EclipseInput or export can be by diagram or Umple textual form, separation of concerns (aspects, traits, mixins), embeds action code in Java and other languages, written in itself, documentation generation, plugin architecture for generators
Visual Paradigm for UMLYesUnknownCommercial versionUnknownJava, C#, C++, PHP, Ada, Action Script (all only in commercial version)Java, C# (binary), C++, PHP (all only in commercial version)Eclipse, NetBeans, IntelliJ and Visual StudioUML 2.4.1, SysML, BPMN, SoaML, SOMF, WSDL, XSD, ArchiMate. Frameworks: UPDM, Zachman, TOGAF. Forward and Reverse Engineering for code and Database. Model Driven Integrated Development (Edit/Build/Debug) for Java and .Net. Simulates Activity, State Machine, Sequence and BPMN diagrams. (only in commercial version)
WhiteStarUMLYesYesImportYesJava 1.5,C#,C++, SQLJava 1.5,C#,C++, SQLUnknownWhiteStarUml is a fork of StarUML with an intent to revive its Delphi code base by updating code to recent Delphi editions, reducing dependence on third party components and fixing bugs and adding new features.
yEdUnknownNoNo[12]UnknownUnknownUnknownUnknown
NameUML 2MDAXMITemplatesLanguages generatedReverse engineered languagesCan be integrated withDetails

References[edit]

  1. ^'ArgoUML'. ArgoUML. 2011-12-15. Retrieved 2012-01-23.
  2. ^'BOUML - an UML tool box'. 2017-05-31. Retrieved 2017-05-31.
  3. ^'Eclipse UML2 Tools'. Eclipse.org. 2007-08-24. Retrieved 2011-10-12.
  4. ^'Product History'.
  5. ^'UML modeling dropped as of v6.8'. Retrieved 2013-04-23.
  6. ^'Product History'. Retrieved 2013-09-05.
  7. ^ abThe UMLet Team (13 November 2016). 'UMLet - UML Tool for Fast UML Diagrams 14.2'. eclipse.org.
  8. ^'WhiteStarUML'. Source Forge. 2017-05-14. Retrieved 2017-08-22.
  9. ^'yWorks News'. yWorks. 2015-07-16. Retrieved 2016-08-03.
  10. ^'Running'. PlantUML. Retrieved 2014-11-06.
  11. ^'Umbrello Features'.
  12. ^'How to import XMI files into yEd?'.

External links[edit]

Wikimedia Commons has media related to UML tools.
  • UML Tools at Curlie.
Retrieved from 'https://en.wikipedia.org/w/index.php?title=List_of_Unified_Modeling_Language_tools&oldid=912264549'
Image source: pixabay.com

In software engineering, data modeling is the process of creating a data model for an information system. This is done by applying formal data modeling techniques.

Data is today a very important aspect of business and brands across the world and globe. That is why data modeling is used to define and analyse data requirements that are essential for supporting the business processes which is a part of the information systems of companies.

Hadoop, Data Science, Statistics & others

The process of data modeling therefore requires the close and active collaboration of professional data modellers, stakeholders as well as prospective users of the information system.

From requirements of data to creation of actual database, three different types data models are produced. Initially, the data requirements are recorded as a conceptual data model which is basically a set of technology independent specifications that are used to talk about the initial requirements of data.

Post this, the conceptual model is converted into a logical data model that documents the structure of data, which is then implemented into databases.

Multiple logical data models may be be needed to implement a single conceptual data model. The last step in data modeling involves the transformation of logical data model into a physical data model.

All in One Data Science Bundle (360+ Courses, 50+ projects)360+ Online Courses | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (3,220 ratings)
Related Courses
Data Scientist Training (76 Courses, 47+ Projects)Machine Learning Training (17 Courses, 11+ Projects)Cloud Computing Training (18 Courses, 4+ Projects)

In this model, data is organised into data, and creates accounts for access, performance and storage details.

This means that data modeling defines data elements as well as the structure and relationships between the elements. Used to model data in a systematic and proper manner, data modelling techniques helps companies to manage data as a valuable resource.

It therefore goes without saying that data modeling standards are an essential requirements for companies that conduct projects, where data has to be analysed and defined in a particular manner.

This post highlights some of the important data modeling tools that go a long way in help making data modeling a successful and effective endeavour for various brands and organisations.

Data Modeling Tools;

  1. Archi:

A free and open source visual modelling and design tool, Archi is used to create models and modelling sketches.

Application Modeling Tool

Initially funded by Jisc between 2010-2012, Archi was a part of the national project that helped to support a programme of the Enterprise Architecture in the higher education sector of the United Kingdom.

This data modeling tool, supports the ArchiMate 2.1 modelling language, which is a technical standard, created by the Open Group.

By providing an open source reference implementation of ArchiMate, Archi is presently one of the tools used to implement the Open Group ArchiMate Model Exchange File Format.

The 2.1 version of the tool is a free version and supports sketches, cross-platform and is open source platform as well.

  1. BiZZdesign Architect:

A visual data modeling and design tool, BiZZdesign Architect is used by the Enterprise Architecture to support the application of a number of enterprise architecture frameworks including ArchiMate and TOGAF.

By supporting modelling, visualization, analysis and documentation of enterprise architecture from multiple viewpoints and with multiple views, BiZZdesign Architecture also supports automatic data collection along with data import from office applications.

Released in 2004, BiZZdesign Architect was developed by BiZZdesign and was based on the results of the ArchiMate project.

This data modeling tool intends to offer clients a high value enterprise architecture data modeling tool that can be controlled by the business management.

In addition, it was recognised as a notable enterprise architecture tool by Garter and Forrester in 2012.

Some of the enterprise architecture framework that BiZZdesign supports includes ArchiMate, DYA framework, Pragmatic Enterprise Architecture framework, Tapscott among others.

  1. CA ERwin Data Modeler:

Another software tool for data modeling, CA ERwin Data modeling is used for developing custom made information system including data charts and databases for transactional systems, besides data requirement analysis and database design.

Based upon the IDEF1X method, this tool also supports diagrams displayed with information engineering notation.

Created by Logic Works, this tool was acquired by Platinum Technology in 1998 and was later obtained in 1999 by Computer Associates.

This tool was then added by Computer Associates to their AllFusion suite under the name of AllFusion ERwin Data Modeler, later named as CA ERwin Data Modeler.

Some other features of the tool include the following:

  • This tool allows for creation of purely logical models, from which physical models may also be created. This tool also supports the combination of physical and logical models , other than entity type and attract logical names and descriptions, logical domain and data types among others.
  • This tool also supports the naming of tables and columns, user defined data types, primary keys, foreign keys, alternative keys and the naming as well as definition of constraints.
  • The tool also compares automates bidirectional synchronisation of models, scripts and databases. If model changes are targeted, the tool has the capacity to generate a script to make these changes.
  • This tool includes an abbreviation/naming directory called Naming Standards Editor and a logical to RDBMS data type mapping facility called Datatype Standards editor. Both of these editors can create customizable entries and ensure basic rule enforcement for data management.
  • After the database engineer has created an effective physical model, the tool can be used to generate a SQL Data Definition language script, which can be directly executed on the RDBMS environment or saved to a file.
  • The version 7 of this tool also has an undo feature available.
  • A unique Bulk editor is also a part of the CA ERwin data modeler. This editor enables users to edit a collection of objects in a single editing session.
  1. Database Deployment Manager:

An open source desktop oriented multi platform database design tool, Database deployment manager is used by database administrators to create database structures, which are then deployed into an existing database.

By allowing the creation of diagrams, this tools allows the identification of basic relations between the defined structures. Some features of the tool are:

1. This tool can be used to create data types, which can be used to create tables.

2. Allows management of database views and tables.

3. Allows users to load/save startup for tables from CSV files

4. It allows validation of database design

5. Database deployment manager has a sql script generation for a target database engine and parallel deployment into chosen databases

Free xpadder download. 6. Has a unique visual query builder

7. The tool allows database mangers to browse an existing database and import tables into the solution

8. Object Oriented Modeling: Another feature of this tool is that it allows for the creation of database tables by following the paradigms of object oriented programming. Database managers can have a base table called table template and then they can derive tables from it.

  1. Database Workbench:

As stated in Wikipedia, this is a software application for development and administration of multiple relational databases that uses SQL, with interoperationality between different database system, Database workbench was developed by Upscale production.

As this tool supports multiple database systems, it provides software developers with a similar interface and development environment that would otherwise be using different database systems.

Initially created as developer tool, specifically for Interbase, The Database workbench was modelled after the SQL navigator tool for Oracle Database by Quest Software. In the early years, this tool was an open source.

Some of the relational databases that database workbench supports includes Oracle Datbase, Microsoft SQL server, Firebird, Nexus DB, MySQL, MariaDB among others.

The fifth version of this tool, runs on both versions (64 bit and 32 bit) of Windows and under Linux the tool can be operated by using Wine. Database workbench can be used to view, create and edit indexes, tables, stored procedures and other database meta data objects. This tool supports the following as well:

Software modeling tools

Initially funded by Jisc between 2010-2012, Archi was a part of the national project that helped to support a programme of the Enterprise Architecture in the higher education sector of the United Kingdom.

This data modeling tool, supports the ArchiMate 2.1 modelling language, which is a technical standard, created by the Open Group.

By providing an open source reference implementation of ArchiMate, Archi is presently one of the tools used to implement the Open Group ArchiMate Model Exchange File Format.

The 2.1 version of the tool is a free version and supports sketches, cross-platform and is open source platform as well.

  1. BiZZdesign Architect:

A visual data modeling and design tool, BiZZdesign Architect is used by the Enterprise Architecture to support the application of a number of enterprise architecture frameworks including ArchiMate and TOGAF.

By supporting modelling, visualization, analysis and documentation of enterprise architecture from multiple viewpoints and with multiple views, BiZZdesign Architecture also supports automatic data collection along with data import from office applications.

Released in 2004, BiZZdesign Architect was developed by BiZZdesign and was based on the results of the ArchiMate project.

This data modeling tool intends to offer clients a high value enterprise architecture data modeling tool that can be controlled by the business management.

In addition, it was recognised as a notable enterprise architecture tool by Garter and Forrester in 2012.

Some of the enterprise architecture framework that BiZZdesign supports includes ArchiMate, DYA framework, Pragmatic Enterprise Architecture framework, Tapscott among others.

  1. CA ERwin Data Modeler:

Another software tool for data modeling, CA ERwin Data modeling is used for developing custom made information system including data charts and databases for transactional systems, besides data requirement analysis and database design.

Based upon the IDEF1X method, this tool also supports diagrams displayed with information engineering notation.

Created by Logic Works, this tool was acquired by Platinum Technology in 1998 and was later obtained in 1999 by Computer Associates.

This tool was then added by Computer Associates to their AllFusion suite under the name of AllFusion ERwin Data Modeler, later named as CA ERwin Data Modeler.

Some other features of the tool include the following:

  • This tool allows for creation of purely logical models, from which physical models may also be created. This tool also supports the combination of physical and logical models , other than entity type and attract logical names and descriptions, logical domain and data types among others.
  • This tool also supports the naming of tables and columns, user defined data types, primary keys, foreign keys, alternative keys and the naming as well as definition of constraints.
  • The tool also compares automates bidirectional synchronisation of models, scripts and databases. If model changes are targeted, the tool has the capacity to generate a script to make these changes.
  • This tool includes an abbreviation/naming directory called Naming Standards Editor and a logical to RDBMS data type mapping facility called Datatype Standards editor. Both of these editors can create customizable entries and ensure basic rule enforcement for data management.
  • After the database engineer has created an effective physical model, the tool can be used to generate a SQL Data Definition language script, which can be directly executed on the RDBMS environment or saved to a file.
  • The version 7 of this tool also has an undo feature available.
  • A unique Bulk editor is also a part of the CA ERwin data modeler. This editor enables users to edit a collection of objects in a single editing session.
  1. Database Deployment Manager:

An open source desktop oriented multi platform database design tool, Database deployment manager is used by database administrators to create database structures, which are then deployed into an existing database.

By allowing the creation of diagrams, this tools allows the identification of basic relations between the defined structures. Some features of the tool are:

1. This tool can be used to create data types, which can be used to create tables.

2. Allows management of database views and tables.

3. Allows users to load/save startup for tables from CSV files

4. It allows validation of database design

5. Database deployment manager has a sql script generation for a target database engine and parallel deployment into chosen databases

Free xpadder download. 6. Has a unique visual query builder

7. The tool allows database mangers to browse an existing database and import tables into the solution

8. Object Oriented Modeling: Another feature of this tool is that it allows for the creation of database tables by following the paradigms of object oriented programming. Database managers can have a base table called table template and then they can derive tables from it.

  1. Database Workbench:

As stated in Wikipedia, this is a software application for development and administration of multiple relational databases that uses SQL, with interoperationality between different database system, Database workbench was developed by Upscale production.

As this tool supports multiple database systems, it provides software developers with a similar interface and development environment that would otherwise be using different database systems.

Initially created as developer tool, specifically for Interbase, The Database workbench was modelled after the SQL navigator tool for Oracle Database by Quest Software. In the early years, this tool was an open source.

Some of the relational databases that database workbench supports includes Oracle Datbase, Microsoft SQL server, Firebird, Nexus DB, MySQL, MariaDB among others.

The fifth version of this tool, runs on both versions (64 bit and 32 bit) of Windows and under Linux the tool can be operated by using Wine. Database workbench can be used to view, create and edit indexes, tables, stored procedures and other database meta data objects. This tool supports the following as well:

1. Visual database design/diagramming, both physical and conceptual

2. testing SQL queries and viewing query plans

3. Generates test data

4. Import and export of data

5. visual privilege management

6. open ODBC or ADO data sources and MS Access databases. In addition, this tool also has several productivity features like code templates, name templates, parameter insights, SQL insight including join completion among others.

  1. Sparx Systems Enterprise Architect:

Another visual modeling and design tool, Sparx Systems Enterprise Architect is based on the OMG UML. The platform supports design and construction of software systems, modeling business processes and data modeling industry based domains.

In use by business and companies, this tool is used to model the architecture of their systems on one hand and process the implantation of these models across full application development life cycle on the other hand.

Besides system data modeling, this tool covers the core aspects of application development life cycle from requirements management right up to design, construction, testing and maintenance phases.

It also provides support for traceability, project management and change control as well as facilities for model driven development of application code.

Used by both programmers and business analysts in both small developer companies to multi-national corporations, this tool can perform a lot of functions that vast and comprehensive.

Initially released by Enterprise Architect, Sparx Systems was released in the year 2000. Originally designed as a UML modeling tool, this tool has evolved to include a number of other specifications as well.

  1. ER/Studio:

A data architecture and database design software, ER?Studio was developed by Embarcadero Technologies. This tool works across multiple database platforms and is used effectively by data architects, data modellers, database architects and business analysts.

Used to create and manage database designs, document and refuse data assets, ER/Studio is one of the comprehensive data modelling tool that combines data business and application modeling into a multi-level design environment.

In addition to ER/Studio, the ER/Studio XE3 includes ER/Studio business architect (It is a process modeling tool that document business processes, enabling companies to understand and enhance the relationship between business process and data.), ER/Studio repository (A server side model management system that helps companies to save daily challenges of data modeling in a team environment.

This tool allows multiple users to not just work in a productive manner by also collaborate on data and business process modeling projects, thereby ensuring proper use of assets and resources), ER/Studio portal (a web based search and reporting tool used to access and query for improved understanding for data), MetaWizard (integrates metadata across modelling tools), Universal data models (helps to reduce the development time of database related projects by close to 60 percent) and ER/Studio Software Architect (it is an object oriented data modeling tool to visually analyse and design complex software applications, used by application architects).

  1. Future Selection Toolbox:

A software focusing mainly on feature selection in machine learning domain, Future Selection Toolbox was written C++ and developed at the Czech Academy of Sciences.

The third generation of this tool is much more versatile, advanced and efficient than the first version. With an emphasis on data pre-processing and classification, specifically feature collection, this tool has specific functions making it a more specialized choice over other tools like RapidMiner, PRTools and WEKA.

  1. IBM System Architect:

An enterprise architecture tool, IBM System Architect is used by numerous corporations and government agencies to create and manage systems, applications and databases, that in turn help to keep their organisations going ahead.

The importance of tactics and the initial instruction for the student's progress - the chess board and the importance of board visualization - the forms of interaction between pieces - basic information about the importance of interactions The game of chess is known to consist of 2 different parts: strategy and tactics, which are. Bain - Chess Tactics for Students.pdf - Free ebook download as PDF File (.pdf), Text File (.txt) or read book online for free. This is a digital PDF download of the book — NOT a hard copy of the book! An instructional workbook containing 434 carefully selected problems presented in worksheet format. Chess Tactics For Students has been extensively field tested with elementary, middle-school, and high-school students over a four-year period. Bain - Chess Tactics for Students.pdf. Click the start the download. DOWNLOAD PDF. Report this file. Description Download Bain - Chess Tactics for Students.pdf Free in pdf format. Sponsored Ads. Account 40.77.167.48. About Us We believe everything in the internet must be free. So this tool was designed for free. Chess tactics for students pdf. The Improving Chess Thinker, Dan Heisman, 2009, Games, 219 pages. Profiles different classes of chess players while explaining how readers can adjust their thinking processes to advance to.

This tool works with a number of framework like DoDAF, MODAF and NAF. Widely used in developing defines architectures, System Architecture has been referenced in textbooks that talk about enterprise architecture, UML and data modeling.

All in all, data modeling tools are an integral part of any brands and organisations. This is because data is essential for the success and growth of any enterprise.

Whether it is understanding the behaviour of the customers or making smart marketing choices, data management is today an integral part of the growth story of any brand.

That is why investing in and understanding data modeling tools will go a long way in helping a brand to sustain its growth story, not just in the present times but in the future as well.

Application Modeling Tool Online

Recommended Article





broken image