Velocity is a Java-based template engine. Its template language references objects defined in Java code. When Velocity is used for web development, Web designers can work in parallel with Java programmers to develop web sites.
Velocity has broader uses, such as generation of SQL, PostScript and XML from templates. It can be used either as a standalone utility for generating source code and reports, or as an integrated component of other systems.
Archon is an open source, Web-based archive management system for archivists and manuscript curators that automatically publishes archival descriptive information and digital archival objects.
ColdFusion is both a platform and a language (ColdFusion Markup Language [CFML]) for enabling developers to build, deploy, and maintain Internet applications. ColdFusion is an Adobe product. ColdFusion is specifically designed to make it easier to connect HTML pages to a database and thereby create dynamically-generated web pages. Website content is managed in connection with a relational database and so can be generated on the fly.
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).
eXist is an open source database management system built on XML (extensible markup language) technology. eXist stores information (data or metadata) encoded in XML. The database is queried using XQuery (XML query language), and follows many other W3C XML standards, including XPath and XSLT.
eXist includes a query editor and debugger. There is a large library of example data, code and applications that can be adapted.
Gallery is a web-based image management system characterized as a "photo album organizer." Typical uses are to display collections of photographs on a web page. Index pages allow users to view small "thumbnail" versions of images, with the ability to zoom in to see images. Image upload capabilities and searching are also supported.
IBM's DB2 is a comprehensive relational database management system (RDBMS). Application versions are available for both desktops and servers and run on a variety of platforms. Unsupported open source versions are available.
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.
Microsoft SQL Server Analysis Services (SSAS) is part of Microsoft SQL Server, which is a relational database management system (RDBMS). SSAS contains online analytical processing (OLAP) and data mining functionality for business intelligence applications. Many of the business intelligence and data mining functions within SSAS are applicable to environmental datasets.
A diagramming program with support for a wide variety of modeling languages, such as Unified Modeling Language (UML), Deployment Diagrams, Network Diagrams and many others. It is also extensible to accommodate custom diagrams. Common uses might include Entity Relationship Diagrams for databases, Class Models for object oriented languages and the creation of workflows for documenting business processes.
MySQL is a relational database system (RDBMS) that runs as a server providing multi-user access to several databases. All major programming languages include libraries to access MySQL. It comes with a command line tool, with many third party graphical user interfaces also available. Although not considered a full enterprise RDBMS like Oracle or PostgreSQL, it supports most RDBMS technologies like foreign keys, triggers, views, indexing, and backup.
MySQL Workbench is an open source, visual based tool for MySQL database design, creation and administration. It is separate from, but connects to MySQL, which is database software built on a version of Structured Query Language or SQL (see MySQL tool description in the DataONEpedia).
OpenOffice Base is an open source desktop relational database application that is part of the OpenOffice suite of productivity tools offered free on the web by Oracle Corporation. OpenOffice Base is SQL compliant and provides a core database platform, a query tools set, report building module, and forms editor.
The Oracle Database is a proprietary relational database management system (RDBMS). There are various editions available depending on technical requirements. All editions are built using the same common code base which can scale from small, single-processor servers to clusters of multi-processor servers without changing the code. Oracle runs on various operating systems including: Apple Mac OS X Server, HP UNIX, HP OpenVMS, IBM AIX, IBM z/OS, Linux, Microsoft Windows and Sun Solaris.
pgAdmin is a design and management interface for the PostgreSQL database (open source object-relational database system). It is an open source administration and development platform.
The most useful features for non-programmers are:
phpMyAdmin is an open-source tools that provides for easy management of MySQL databases through a web-based user interface. Processes that can be completed through this tool include:
database management (creation and management of users, permissions, etc.)
create and execute queries
create and view tables, database rows and fields
execute stored procedures and triggers
import and export data
The combination of PostgreSQL and PostGIS provides a robust database platform that supports the integrated management of both geospatial data and attributes associated with those data in a database system that is supported by a large number of client applications, including GIS and mapping applications. PostgreSQL is an open source object-relational database server that implements the Structured Query Language (SQL) for database design, management, and use.
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.
SpatiaLite is an extension to the SQLite database that enables it to support spatial data.
SpatiaLite is conformant to OpenGIS specifications. It has the following features:
The SQL Server is a relational model database server produced by Microsoft that provides a high performance database platform that’s reliable, scalable, and easy to manage. Its primary query languages are T-SQL and ANSI SQL. There are several Editions of the Server available, which differ depending on the services they provide.
SQLite is a software library that implements a self-contained SQL database engine. SQLite can be used as a database underlying a website, or as a substitute for a Relational Database Management System (RDBMS).
Tableau supports the analysis of tabular data from spreadsheets and relational databases. The tool provides a visual interface that allows users to import data and interactively explore the data through visualizations. These visualizations are created through a graphical user interface that allows users to build queries by dragging and dropping attribute names from tables and spreadsheets.
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.
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).