DBDesigner 4 is an open source visual data design application that includes functionality for database design and data modeling. It is primarily designed for use with the Open Source database platform MySQL. It includes specific functionality for database and data design including documentation, Structured Query Language (SQL), and reverse database engineering for any ODBC-compatible database.
Enterprise Architect is a modeling, visualization, and design platform. It can be used in software design, data modeling, and database design and is useful for creating and analyzing UML diagrams. It has a built-in data modeling profile that extends UML to provide a mapping from the database concepts of tables and relationships onto the UML concepts of classes and associations.
CA ERwin Data Modeler (or ERwin for short) is a data modeling and database design tool that is used to create conceptual, logical, and physical data models. ERwin can create the actual database from the physical model, and create different physical implementations from a single logical model. ERwin can also reverse-engineer existing databases into a data model diagram. ERwin works with many database management systems (DBMS).
ESRI's ArcGIS Desktop software contains ModelBuilder, which is a work flow tool that enables the creation and execution of consistent, repeatable models that are comprised of one or more processing steps. ModelBuilder can be used to ensure the integrity of a particular model or set of analytical processes through modeling, storing, and publishing complex operations and workflows. ModelBuilder workflows can be created and executed on both the desktop and over the web.
The Forest Sector Carbon Calculator is a tool to help users learn about how carbon stores in the forest change over time.
GRASS (Geographic Resources Analysis Support System) is an Open Source Geographic Information System (GIS) that support 2d and 3d raster (gridded) and vector (point/line/polygon) data processing, analysis, and modeling capabilities.
IBM InfoSphere Data Architect is an enterprise data modeling application built on the Eclipse Integrated Development Environment (IDE) platform. Data Architect enables information designers to create both logical and physical data model diagrams, which can be used to describe a variety of applications and systems. For example, this tool can document a SQL database application, a complex website, a multi-server application platform, or a networked workflow process.
Kepler is a scientific workflow application that enables scientists, engineers, analysts, and computer programmers to create, execute, and share models and analyses. Kepler is a java-based application that can operate on data stored in a variety of formats, locally and over the internet, and is an effective environment for integrating disparate software components, such as merging "R" scripts with compiled "C" code, or facilitating remote, distributed execution of models.
OpenBUGS is software for running Markov Chain Monte Carlo (MCMC) simulations following Bayesian statistical theory. It is one of two software packages created for Bayesian Inference Using Gibbs Sampling, or BUGS. OpenBUGS is so named because it runs on multiple operating systems; the WinBUGS software can be used with Windows operating systems (see WinBUGS tool in the DataONEpedia for details).
OpenMI provides users with a standard interface that allows the construction of modeling workflows. OpenMI allows models to exchange data with each other and other modeling tools as they run, facilitating the modeling of process interactions. Models may come from many different sources, represent processes from different scientific domains, have different spatial and temporal resolutions, and have different spatial domains/representations.
PowerDesigner is a tool for creating business-process models, and conceptual, logical, and physical data models for database design, including relational and dimensional models. PowerDesigner can coordinate the business process model with the database design, ensuring that the process steps that create data have data representations in the logical model.
Protege is an open source ontology editor. An ontology is similar to a taxonomy in that it presents a controlled vocabulary for a given area of knowledge. However the relationships between the different objects can be far more complex and richly described.
It allows users to create ontologies in both the Frames and Web Ontology Language (OWL) frameworks. Protege allows users to
Rational Rose is a software development environment for using model descriptions and pattern languages to drive code development. Rational Rose is an IBM product. The emphasis of the "rational" development environment is to design major software engineering components at an abstract modeling level, initially unhindered by the challenges of implementing components and relationships as code.
SAS Enterprise Miner streamlines the data mining process to create predictive and descriptive models based on analysis of large amounts of data. Data can be accessed from local files or from remote database connections. SAS data mining software uses a point-and-click interactive interface to create workflows and analysis diagrams, and then execute them. SAS Miner can transform and manipulate data using filters and statistical analyses to extract desired data from large datasets.
Simulink is an add-on package for MATLAB that supports simulation and model-based design using a graphical block-programming scheme. An interactive graphical editor is provided for building models and simulations based on an extensive library of customizable program blocks and custom code. A Model Explorer application supports inspection and editing of models, signals, parameters and generated code.
Spotfire Miner is software for data mining of large datasets. It is sold commerically by TIBCO.
Users can connect to remote or local datasets, apply statistical and methodological filters, clean and transform the data, and finally apply a model to produce the desired mined data. Statistical models include clustering, regression analysis, and principal components analysis. Models based on historical data can then be used to predict future results based on newly mined data.
SPSS is a desktop statistical software package that is centered around modeling and statistics. SPSS can access data from many different proprietary and open source data sets and has decent graphing and very good statistical modeling capabilities. One weakness (Up to version 17), is the presentation quality of graphs. Other packages do a much better job at data presentation.
IBM SPSS Amos is a tool used for structural equation modeling. It features drag-and-drop drawing tools and produces graphics of final models for presentation.
Amos uses standard methods – including regression, factor analysis, correlation and analysis of variance. It can be used to create models to test hypotheses and confirm relationships amongst variables.
STELLA (Systems Thinking for Education and Research; from isee Systems) is a modeling software package that diagrams, charts, and uses animation help visual learners discover relationships between variables and helps simplify model building. Stella handles time series, sensitivity, and simulation models well and has a 'drag and drop' modeling interface. Users can download a free trial that has significant features.
Taverna is an open source family of tools for designing and executing workflows, created by the myGrid project. Written in Java, the family consists of the Taverna Engine (the workhorse), and the Taverna Workbench (desktop client) and Taverna Server (remote workflow execution server) that sit on top of the Engine.
The Predictive Ecosystem Analyzer (PEcAn) is an integrated ecological bioinformatics toolbox and data assimilation system that synthesizes information contained in ecological models, data, and expert knowledge. This is done using modern statistical methods and state-of-the art ecosystem models. PEcAn has a web interface that enables users to run ecosystem models, as well as a suite of R packages that can be used for model-data fusion and more sophisticated analysis.
WinBUGS is software for running Markov Chain Monte Carlo (MCMC) simulations following Bayesian statistical theory. It is one of two software packages created for Bayesian Inference Using Gibbs Sampling, or BUGS. WinBUGS is so named because it runs on windows operating systems; the OpenBUGS software can be used on other operating systems (see OpenBUGS entry).
xCase is a data modeling and database design tool that is used to create logical and physical data models. xCase can create the actual database from the physical model, and create different physical implementations from a single logical model. xCase can also reverse-engineer existing databases into a model diagram. xCase works with many database management systems (DBMS).