database

job: Associate Director for Digital Library Software Development

By Valentina Asciutti at Wed, 20/10/2010 - 17:08

Read more about Associate Director for Digital Library Software Development

job: Two ICT posts at Imperial War Museum

By Valentina Asciutti at Wed, 29/09/2010 - 12:25

Read more about Two ICT posts at Imperial War Museum

tool: PostgreSQL

Purpose:

PostgreSQL is a powerful, open source object-relational database system.

Features:

• fully ACID compliant
• full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages)
• includes most SQL 2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP
• supports storage of binary large objects, including pictures, sounds, or video
• multi-Version Concurrency Control (MVCC)
• Highly customisable

A&H use case 1 description:

The “Great Britain Historical Geographical Information System (GBHGIS)” has used PostgreSQL to store the geographically-located historical statistics for Great Britain.

Creator:

Michael Stonebraker

Publisher:

PostgreSQL Global Development Group

Data capture:

Manual input and transcription

Specifications:

PHP

eXtensible Markup Language (XML)

Suite:

Software/programming languages used:

PostgreSQL

Tags:

database

query language

Alternate tool(s):

FileMaker, MySQL, SQLite, Firebird

Licence:

PostgreSQL License

lifecycleStage:

structuring

Platform:

All major operating systems

By Valentina Asciutti at Thu, 17/06/2010 - 10:44

Read more about PostgreSQL

tool: Oracle Database

Purpose:

Oracle Database is a relational database management system (RDBMS).

Features:

• Supports symmetric multiprocessing (SMP)
• Stores data logically in the form of tablespaces and physically in the form of datafiles
• Transportable tablespaces
• Advanced Queuing (AQ)
• 64-bit database
• Data Mining Option

A&H use case 1 description:

The “Great Britain Historical Geographical Information System (GBHGIS)” project has used Oracle Database to store all the geographically-located historical statistics for Great Britain.

Creator:

Software Development Laboratories (SDL)

Publisher:

Oracle Corporation

Data analysis:

Data mining

Specifications:

eXtensible Markup Language (XML)

Software/programming languages used:

Oracle Database

Suite:

Oracle

Data capture:

Manual input and transcription

Alternate tool(s):

Firebird, Ingres

Tags:

Licence:

lifecycleStage:

Platform:

By Valentina Asciutti at Thu, 17/06/2010 - 10:25

Read more about Oracle Database

tool: ToadHMS

Purpose:

A data management tool for the storage and presentation of text, images and spatial data. It has been built upon the principles of the world wide web, enabling researchers to configure the system, input or upload new content, manipulate existing content and make it available access through a web browser. ToadHMS (The Oxford ArchDigital Heritage Management System) was developed in PHP and can be integrated with a number of database back-end systems, including MySQL and SQL Server. It uses open source tools, such as ImageMagick to automate data management tasks.

Features:

Searchable database
Photo album creation and management

A&H use case 1 description:

The RISM project has used the software to catalogue and present music manuscripts of the 17th and 18th centuries in the UK and Ireland.

A&H use case 2 description:

The Worcestershire On-line Ceramic Database has used the software to catalogue pottery found on archaeological sites in Worcestershire. Records contain photographs of the pottery, accompanied by descriptive metadata on the fabric (clay type and inclusions), manufacture, forms, source, distribution and estimated date of creation (http://www.worcestershireceramics.org/).

A&H use case 3 description:

The Portable Antiques scheme has used the software to enable members of the public to record archaeological objects found in England and Wales (http://www.findsdatabase.org.uk/hms/).

Creator:

Oxford Archdigital Limited (original creator), Clarinet Systems Ltd (current maintainer)

Publisher:

Clarinet Systems Ltd

Tags:

GIS

heritage management system

database

photo album

Licence:

GNU General Public License

Data structuring and enhancement: