Searching on-line Part Two

The Pterosaur Database is now on-line in a limited form.  The listing of museums with pterosaur specimens and the listing of collection material has been put on-line in a test format.  The data still needs some adjustment, but it is available for the first time for everyone to search.

The first search up is the specimen search, where you can enter the name of a species or genus and see what comes up.  The data search gives basic information like description, museum and catalogue number as well as a few notes in some cases.


It is also possible to search by specimen type and by Museum.  The museum search is in two phases - firstly the general information search by country, key name words and town/city.  A second search page gives a choice of matches, and a selection of the record number presents a specimen list, as shown below;

First page requiring general information.

Second page giving a choice of matches.

 

Third page showing the museum list of specimens, postal address, contact telephone number and website where available.

There are several museums with pterosaur material that are represented by only type and figured specimens.  Some museums that hold pterosaur material have not been visited and are therefore not included here.

This database is a read only system to protect the data at source. However, a parallel database has been set up into which new specimens can be added.  When the input has been verified, the entries will be included in the main database.  Corrections can also be entered here by adding the correct entry and describing the alteration in the Notes field.

Any comments on the functionality of the on-line system will be appreciated in order to adapt it to the needs of users.

Bibliography on-line

For a few weeks, the current bibliography of The Pterosaur Database has been tested on-line.  It is now up and running in its current form, enabling the listing and printing of publications from a database file.

The records are extracted from a SQL database by a simple request program which was written specifically for this purpose.
Just enter an authors surname, part of a title or a date and see what comes up on  the list.

Searching for 'Bennett' brings up 47 publications from a current file set of 1438 records.

The data on this database cannot be amended or added to as it is a static file.  However, we are running a parallel database which can be interrogated and added to.  The data will be verified at intervals and where appropriate, transferred to the main database.  This will prevent corruption of the master database whilst allowing people to add new papers and texts for inclusion.
Feel free to comment on the functionality of the database.

Host Migration

The Pterosaur Database is moving to www.pterosaur.org.uk hosted by UK Web Hosting (Enix Ltd).  The website framework is now running and all of the database search elements should be in place by August.

It is good to have a host that responds rapidly to problems and provides skilled advice and support.  There are a few re-write issues to be resolved as the server structure is different to the previous server for which the website was designed.

The On-line Database Problem

Since February 2012 I have been unable to load data to the on-line database files on the Pterosaur Database.  This has been a concern for some time and I have tried to progress this issue with 1and1 to find out how they are moving on with the server error that is blocking the file uploads.

Unfortunately, the support desk of the company is set up to act as a firewall between the customer and the server administrators.  The server is in Germany and the support desk is in the Pillipines.  This is an on-going problem and after 4 attempts to enquire about progress, this is the best response so far:-

"Thank you for contacting us.

We sincerely apologize for the inconvenience that this has 
brought you,we have already informed our higher department 
regarding how urgent thiscase to be resolved.
And as of the moment they are doing there best to have this 
resolved atthe back end of the server. Once they are able to
find the cause for thisissue and have this fixed then we will 
sent you an email update for this.We understand that you 
might be anxious to have this resolved as soon as possible 
so thank you so much for your patience while we working on
the resolution.

If you have any further questions please do not hesitate to
contact us."

The first update enquiry response 3 days ago, when they had already replicated the error on two previous occasions was:-

"Thank you for contacting us.

We have tried testing in importing database composing of
2 data and it gonethrough. What is the data file size that 
are you trying to import?

If you have any further questions please do not hesitate to 
contact us."

I must say that for years, 1and1 have provided excellent service.  But now, the new support desk is a wast of time.  Each enquirey contact is treated as a new problem by a different opperative. The opperatives generally have a poor grasp of the English Language and they are limited in what responses thay can give.  The general policy seems to be - ask the customer a question, then the enquiry will come back to someone else - it is essentially a "pass it around" culture with no single point of contact responsibility.  When I have asked for the enquiry to be read by a supervisor, the response has been a further question.

My advice is, if you want to use databases on-line, avoid using 1and1 at present.

The datasets, I am sure, will eventually be uploaded, but there is no timescale for the completion of the on-line data.

A tail

 Within the collections on display at the Sedwick Museum, Cambridge is a specimen of a Dimorphodon macronyx tail.  This is catalogue number J.61175 and is part of the Whinborne Collection.  The fossil is from Lyme Regis in Dorset and may have been collected by Mary Anning from the Lower Lias of the Undercliff.  The tail is in a state of dissociation and may be the rotting offcast from a predators meal.

Removing the bones photographically from the matrix shows the caudal vertebrae and the stiffening rods that would have kept the tail rigid in life.  There is also some material on this slab that looks like a sternum fragment.  It is not easily defined from a photograph.  If there was a cartilage running from the sternum to the tail, this would not be an unusual association.

The only other tail of Dimorphodon macronyx is in the Natural History Museum, London.  Specimen number 41349 is a complete and rigid tail with all of the stiffening rods in their natural place close to the vertebrae.  The arrangement of rods is similar to that seen in Rhamphorhynchus.

The long tail of this type of pterosaur would have been used as a balancing organ and would most probably have had a vertical sail at the tip to give the animal directional stability when flying. The sail is only seen in some Rhamphorhynchus specimens where wing membrain is preserved.  Dimorphodon does not show this degree of preservation.

Acronym Confusion

The names of museums are often added to scientific papers as acronyms.  It occurred to me that if the pterosaur database included a searchable list of museum information, the appropriate acronyms could be used to link the museums to specimens.
This idea sounds good, but the truth is that museum acronyms are not standard.  Above is a picture of The Natural History Museum, London.  This is represented in many of the old papers as BMNH or BM(NH).  In newer papers it is seen as NHM, NHM London, NHMUK, NHMGB or BMNHL.  The change in name from British Museum of Natural History to Natural History Museum has been an issue here.
There are a number of websites that allow you to match a museum acronym to a museum.  In Europe, the Natural History Museum London usually comes up as NHMUK;  on U.S. searches it comes up as BMNH.  There seems to be no means of standardising the acronyms across the world, especially in scientific papers that were written some time ago.

To start to address this problem, I have written to the Museums Association in London to see if they have an existing UK standard for acronyms.  Lets see how we go on from there!

If anyone has any sound information I would like to hear about it.

Footnote:  An E-mail from the Museums Association informs me that the old ERGMA system of the 1970's, which allocated a code to every museum, was not supported by all museums and was dispensed with many years ago.  There is no clear standardisation of Museum Acronyms in the UK.

Still having server problems

Today all of the web database failed.  There is an issue with the server at 1and1 Internet - the host for the Pterosaur Database.  The support desk is powerless to do anything, but if I leave a message on the 1and1 facebook page, I get a lucid response.  Perhaps this is the way forward.

1and1 have been an excellent host for many years, but my recent experiences are unusually exceptional.  This issue first started in January this year and we are now into May and I have had no contact from the people who control the web servers.  This is not helping the reputation of a once excellent company.

It may be the case that like all big and successful companies, the infrastructure becomes overloaded as costs are cut.  As soon as we are able, the database pages will be re-instated.

Should this problem persist much longer Then a new host company may be the only solution to the problem.

Footnote: within a couple of hours of posting on the 1and1 facebook page, the databases were restored and running.  There are still issues with uploading data, but at least the uploaded data is now accessible again.