TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Madeline Betts <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 13 Jun 2017 08:55:16 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (5 kB) , text/html (8 kB) , image001.png (5 kB)
Hi,

I'd be interested to know what other institutions do too. We don't have any of our views documented but it would certainly be helpful when making changes to views and embarking on upgrades.

One question I have though, is how can we simply identify any interdependencies?

Best Wishes

Madeline

Madeline Betts
Collections Database Manager
Tate
+44(0) 20 7887 8983
[log in to unmask]<mailto:[log in to unmask]>

[cid:image001.png@01D2AFBA.0DF87410]<http://www.tate.org.uk/>

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Shepherd, Rupert
Sent: 13 June 2017 09:20
To: [log in to unmask]
Subject: Documenting views inline

Dear colleagues

Are any of you creating documentation of your database views within the views themselves - by which I mean not just commented code, but standardised descriptions of the view, any interdependencies, etc. ? If so, do you have an established format you'd be willing to share?

Between GS views and our own, we have over 600 views at the National Gallery, and before we start creating any more, I'd like to make it easier for us to see in future why we created them, what they depend on, what depends upon them, etc.

With thanks and best wishes

Rupert

Rupert Shepherd, PhD FSA
Collection Information Manager
[log in to unmask]<mailto:[log in to unmask]>
Tel: +44 (0)20 7747 5921

[The National Gallery, Trafalgar Square, London WC2N 5DN]<http://www.nationalgallery.org.uk>
[The Credit Suisse Exhibition: Michelangelo & Sebastiano]<http://www.nationalgallery.org.uk/whats-on/exhibitions/the-credit-suisse-exhibition-michelangelo-sebastiano>
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

Please note that any information sent, received or held by Tate may be disclosed under the Freedom of Information Act 2000

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

ATOM RSS1 RSS2