TitleBodyTechnical Expertise RequiredCostAdditional Information
Apache Velocity

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.

Archon users do not need to encode a finding aid, input a catalog record, or program a stylesheet. Archon operates through scripts that automatically make data elements in the system searchable and browsable on a repository website. Information can be input or edited using simple web forms. Archon automatically uploads the information, publishes the website, and generates EAD and MARC records.

No programmingFree

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. Updates can occur on multiple web pages by changing data in the database.

DBDesigner 4

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. For the MySQL database platform DBDesigner has largely been succeeded by MySQL Workbench which is an integrated development environment (IDE) .

No programmingFree
Enterprise Architect

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. Enterprise Architect supports modeling of database schema for many popular relational database management systems (RDBMS). It can be used to capture and trace formal requirements for designing, building, and deploying software and databases. Enterprise Architect also supports generation and reverse engineering of source code for a variety of programming languages. It has a built-in source code editor that lets you navigate from a visual model to source code in the same interface.

No programmingCost-basis

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). Outputs from the tool include entity-relationship (ER) diagrams and standard or custom reports on all objects in the design (tables, fields, relationships).

While users are charged for the full version of ERwin, there is a free "Community Edition" available for students and others new to modeling to try the functionality of the software on a small dataset. The Community Edition has a limit on the number of objects (25) that can be created in the data model.

No programmingCost-basis

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.

eXist typically runs as a Java web application under Tomcat, and also comes with a desktop application which is useful for uploading documents in batch-mode.


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.

Written in the PHP programming language, there are several versions (1,2 and 3) of Gallery available and still undergoing development. They differ slightly in their capabilities and in the type of database used. Gallery 1 uses an integrated file-based database system, Gallery 2 & 3 use an external database (e.g., MySQL).

No programmingFree
IBM DB2 software

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

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. Built into Data Architect are the technical specifications of a variety of popular IT platforms and services, which enables the designer to not only specify a data connection between two entities, but also save the technical requirements for making the connection functional. A good example of this feature is shown in the online Data Architect demo (see below for link) which shows a connection being made between an Oracle and an IBM DB2 database. The data model encapsulates all the information a systems engineer will need to actually build a connection between these two platforms. In addition, Data Architect provides a variety of output methods for its data models. For example a web designer can print out a site architecture report, while a database designer can actually output the SQL script necessary to build the database they just designed.


IBM has provided detailed technical documentation for Data Architect online: http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an...