database articles bibliography glossary forum gallerylinks members
log in  
back

Dear Comrades,

For a limited time, a guest login has been created to allow people to sample the working parts of oberlinacoustics.net.

Simply go to www.oberlinacoustics.net/phptest and log on as username"guest" with password as "guest".

A BRIEF USERS GUIDE TO THE DATABASE.

For those not familiar with databases- A database consists of units called records and fields. Records can be thought of as a single card in a card filing system that contains a number of fields or entry boxes with discrete information about each subject. In this database, a record is a collection of information on a specific instrument and the time of its documentation. Mentioning the time/date of the making of each record is not just important for documenting the date-but also to be able to distinguish revisions of measurements through time. So for example: if you enter information about a certain instrument,and then enter the information again in a few months or years time, you can follow any changes that occur in that time. Each record will have its own ID# and there is a field on each record called "same instrument as record". Here several entries at different times can be documented,and each time you make a revision, there will be a specific ID# associated with it.

Editing the database/Little green pencils

Each member having logged on with their password, will see by each field, a little icon, which, when entries or changes are made should be clicked. When entries or changes have been made, the "Submit button should be clicked in order to upload the information. Dont forget the edit icon below the graduation maps! When the edit icon is activated, a new window will appear with editable boxes. In most cases, a list of boxes will appear, where you can edit a series of fields in one go, in edit mode. Some fields only open their respective edit box, where you can browse your hard drive for images or sounds for example.

Remember- All members can view their entries-but only they will be able to edit or add to them.

FILE SIZES (also for other sections than the database)

It is highly recommended to prepare images to be uploaded for the web i.e. to compress them and reduce their size. This makes viewing a lot quicker, saves server space and in most cases the quality will be more than adequate. Many of the images already in the gallery are under 200kb. Some sounds will need to be in uncompressed format (Wav) and should be kept short. The examples to be found on the sample record ID# 47 are only two taps long (approx. 2-4 seconds). This is more than enough, if the taps are well chosen from your rough recording beforehand. The field marked "bowed sound" should be uploaded in MP3 format, for subjective evaluation. MP3 compression uses psychoacoustic principles to remove the elements of sound that for most people are unimportant and donīt contribute to the general perception of sound and therefore saves a lot of space and processing power.

Some fields are pop-ups, so you can choose from a number of options, and the number and nature of those options might be modified in the future. The "edge thickness" field at the moment contains only one value, although thicknesses vary. This is thought of as an average thickness for the time being and might be revised later.

The graduation maps are fairly straightforward. Nota-bene- you must click the edit icon (little green pencil) to be able to make or edit entries.

When a number of records have been entered and you have clicked the "database" link you will see a list of records that are sortable by a few parameters- maker,instrument,contributor and date. Click on one of these headers and you can sort that particular category. Down below where it says "search" you can choose the criteria that you will search by. This might become a way to do simple statistical studies.

For example:

Show records where:
1. maker is antonio stradivari and
2. B1+(C3) is between 520 and 560 Hz and
3. Weight total is less than 390 g and
4. B1- is greater than 450 Hz and
5. AO is less than 280 Hz

This has been set up to get things started and could (and probably will) change in future. In other words, we donīt know exactly where all this will take us, but it seems exciting nonetheless.

So when you have an instrument you would like to include, sign in with your password and click "create new record" in the database section and go for it. Remember- it is not likely that for any instrument, you will be able to include all parameters, and a record containing only weights, frequency responses, or taps even, will still be useful.

At this point, we are about to launch the site properly, but a few fields will be added soon, among them;

Tap sound (criteria still to be sorted i.e. pencil? mic. position)
E1 front without bar (sound)
E2 front without bar (sound)
E5 front without bar (sound)

Please send an e-mail to myself at hansi@centrum.is or info@oberlinacoustics.net and include your username and password of choice.

Oh, and please do not make any entries as guest as they will have to be removed .

Best wishes,

Hans Johannsson

back


    Đ2007 oberlin.acoustics     info@oberlinacoustics.netimprint