Hi Richard, Arran, and everyone,
An overview of the SPECTRUM Partner systems overview is on Collections Link at http://www.collectionslink.org.uk/discover/manage-information/1074-software-survey-spectrum-partners-systems-overview
This links to more detailed information for each system (click on the system name under Software Package). There is an entry on Database Architecture for each system.
The survey will be updated this summer with new information from each SPECTRUM Partner AND adding the 3 new SPECTRUM Partner systems from Picturae, Semantika and Roger Layton Associates.
Best wishes,
Simon
Simon Sheffield
Online Services Officer
[log in to unmask]
OpenCulture 2012
Register online at http://www.collectionslink.org.uk/events/openculture-2012
www.collectionstrust.org.uk
www.collectionslink.org.uk
www.culturegrid.org.uk
Follow us on Twitter: http://www.twitter.com/collectiontrust
Company Registration No: 1300565
Registered Charity No: 273984
-----Original Message-----
From: Museums Computer Group [mailto:[log in to unmask]] On Behalf Of Richard Light
Sent: 09 May 2012 09:50
To: [log in to unmask]
Subject: Re: DB Formats
Arran,
Here (with Ross Parry's blessing :-) ) is the table in question. It comes from a unit within a core module entitled ‘Information, Collections and Preservation’ on Leicester’s Masters (and Postgraduate
Diploma) distance learning degree in ‘Digital Heritage’
http://www2.le.ac.uk/departments/museumstudies/postgraduate-study/digital-heritage/distance-learning
It doesn't claim to be complete, and obviously may be out of date.
Perhaps individual CMS suppliers could usefully comment on any errors or updates.
Richard
Database engines used by museum collections software
Supplier
Product
Database used
Adlib Information Systems
Adlib Museum
Adlib 'native' flat file database
Microsoft SQL Server 2005
Oracle 10g
DS Ltd.
CALM
Dscribe: a proprietary sophisticated structured text retrieval and relational system, which uses a dynamic full text index and allows 'messy' data schema
Gallery Systems
TMS
Microsoft SQL Server 2000
Oracle 8i Enterprise
Oracle 9i Standard or Enterprise
EmbARK
Relational database based on 4th Dimension (http://www.4d.com <http://www.4d.com/>). The Server version offers open access via ODBC and JDBC
KE Software
KE EMu
Object-oriented database supporting nested and multi valued fields and providing powerful text retrieval facilities.
Mobydoc
Micromusée
Relational database (Mobydoc database engine) standard and SQL version
MODES Users Association
MODES for Windows
Hierarchical database structure B-Tree Filer database engine
ModesXML
XML records with dynamic indexes, based on NexusDB server (relational database engine)
System Simulation
MUSIMS
The MUSIMS architecture is based on the information retrieval model complemented with relational indexing. The underlying database is Index+
Vernon Systems Ltd
Vernon CMS
Relational with multi-values. (Revelation's OpenInsight)
Zetcom Ltd
MuseumPlus
MS Access
Microsoft SQL Server
Oracle
Source: Collections Trust Software Survey: SPECTRUM Partners' Systems (http://www.mda.org.uk/software as of 15 October 2008)
On 09/05/2012 00:55, Arran Bevington-King wrote:
> Richard,
>
> Thank you for your reply.
>
> I do know of the list you refer and yes it does still exist on the following URL:
>
> http://www.collectionslink.org.uk/assets/software_survey.htm?phpMyAdmin=OYNyINPdn3sQmoXugKH1gcCLSW0
>
> however, whilst this does give a list of SPECTRUM partners, and indeed links to thier respective websites. it does not give me the format that the data is stored within. (Adlib does give it in the feild for cost)
>
> I have found this data ont he Adlib website and indeed on the MUA website but not the others.
>
> regards,
> Arran
>
> ****************************************************************
> website: http://museumscomputergroup.org.uk/
> Twitter: http://www.twitter.com/ukmcg
> Facebook: http://www.facebook.com/museumscomputergroup
> [un]subscribe: http://museumscomputergroup.org.uk/email-list/
> ****************************************************************
>
--
*Richard Light*
****************************************************************
website: http://museumscomputergroup.org.uk/
Twitter: http://www.twitter.com/ukmcg
Facebook: http://www.facebook.com/museumscomputergroup
[un]subscribe: http://museumscomputergroup.org.uk/email-list/
****************************************************************
****************************************************************
website: http://museumscomputergroup.org.uk/
Twitter: http://www.twitter.com/ukmcg
Facebook: http://www.facebook.com/museumscomputergroup
[un]subscribe: http://museumscomputergroup.org.uk/email-list/
****************************************************************
|