How to make your database sing.

1. How to make your database sing. Presented by: Vicki Stephens Library Adviser National Library of New Zealand vicki.stephens@dia.govt.nz

2. http://schools.natlib.govt.nz/

3. In the beginning…. The Grand Vizier of Persia in the 10th century took his entire library with him wherever he went. The 117,000-volume library was carried by 400 camels trained to walk in alphabetical order.

4. …Card Catalogues

5. Cataloguing Standards • Dewey Decimal System • Anglo American Cataloguing Rules AACR2 • Library of Congress Subject Headings

6. Integrated Library Systems ILS

7. International Standards / Protocols MARC & Z39.50 • MARC = Machine Readable Cataloguing • Z39.50 = Direct connection between ILS and external cataloguing database e.g. SCIS

8. MARC + Z39.50 = One Catalogue Record

9. Libraries have adapted…

12. Computers in libraries are like icing on cake - they add to the whole experience, but just make a sticky mess without a firm foundation. From The Warrior Librarian http://www.warriorlibrarian.com

13. What is the primary purpose of your Library Management System?

14. Managed Learning Environments Roadshow http://www.slideshare.net/paul.seiler/2009-mle-roadshow-4

18. http://schools.natlib.govt.nz/

20. ILMS & OPAC • ILMS = Integrated library management system • OPAC = Online Public Access Catalogue (WebOPAC)

23. ILS/OPAC features: Web Home Page Book Review Feature Web access from Home Citation and Bibliography Building Video viewing Secure Website access Blog/Wiki features Mobile Phone Apps

26. What is effective information retrieval? Effective Data Input = Effective Data Output Hider, P (with Harvey, R) 2008

27. Data input must: • adhere to widely-understood standards • require minimal effort • meet the minimum requirement of the system • maintain a high level of accuracy and consistency

28. Data output must: • be readily understood by the user • match users request • be user-friendly • respond to users requests as rapidly as possible • not be restricted to a limited number of terminals, but should be capable of being used simultaneously • by all users who require it. • – networked and multiple users required.

29. Why is it necessary for libraries to organise information effectively?

31. IT Setup Essentials Z39.50 Email address SMTP Server address Proxy - Proxy Host, Proxy Port, Proxy User and Proxy Password IP Address  And.. Port Forwarding/Mapping Barcode Reader

33. Input & Amend Catalogue Record Amend the following Catalogue fields: • Accession/Barcode number – (Place barcode on back cover of book 1 cm in from hinge 1 cm in from top of cover) • Classification - (Be consistent e.g. put books about New Zealand 993 not 919.3 and 993) • Type – Non-Fiction, Fiction, Quick Pick/Read, Senior Fiction, Picture Book, Sophisticated Picture Book, Graphic Novel, Reference, Magazine etc, (Sticker the spine appropriately) • Source (Supplied By)– Suppliers name, Donation, Duffy Book etc, • Location – In Library, Staff Room, Teachers Resource Room etc…

34. Classification Modification • 398.2 Can consistently truncate to this number • 411 / 421 Alphabet books – may be better in Picture Books • 428.6 Readers – class with fiction or subject area • 513.2 Counting books – may be better in Picture Books • 811 / 821 Rhyming books - Relocate to Picture Books with 1st letter of author’s surname • 910s Geography number – option to prefer the history number in primary schools, 919.3 = NZ geography, 993 = NZ history Can shelve books together under 993 • 920 Prefer subject classifications for biographies. eg Book about the golfer Tiger Woods can be shelved in the golfing section. A book on scientists can be shelved in the science section. Whereas a book on a range of people (sports players, scientists, politicians, explorers etc can be shelved at 920. • 993.1 Use 993 for New Zealand

35. Amend the following Catalogue fields: Cont…. • Media – Book, DVD, Website, Board Game, Kit, Poster etc. • Purchase price - (Actual/Discounted price) if unknown or donated enter $0.00 (zero) Usually excludes GST. GST is claimed back by Schools. This is really important to get right as it affects your auditing and budget. • Overdue/Replacement cost - Consider processing costs and replacement cost of similar title. Important as if a book is destroyed despite being donated what would it cost to replace. But wait there’s more….

36. Keywords & Subject Headings – Add any keywords as necessary. • Subject Heading words can be keywords. Subject Headings however need to use the international standard vocabulary e.g. Bugs is a keyword, but a book called Bugs will always have the Subject Heading - Insects. • For Maori Subject Headings use Ngā Ūpoko Tukutuku:http://mshupoko.natlib.govt.nz/mshupoko/ • For Maori Keywords try http://www.maoridictionary.co.nz/

37. Subject Headings & Keywords A subject heading is controlled vocabulary usingapproved headings – targeted and consistent eg Insects A keyword is uncontrolled vocabulary - inexact and broad-ranging eg Bugs, Creepy crawlies

38. SCIS Subject headings • Cataloguing aid with standardised terms • Provide consistency in subject authority files • Include some Maori headings, and growing number being added • Can be copied and pasted into your library catalogue subject headings field

41. SCIS Websites

42. Use Your URL

44. http://www.nzta.govt.nz/resources/roadcode/road-code-index.htmlhttp://www.nzta.govt.nz/resources/roadcode/road-code-index.html

45. http://en.childrenslibrary.org/

46. http://www.childrenslibrary.org/icdl/SaveBook?bookid=mrzispy_00260005&lang=English&ilang=Englishhttp://www.childrenslibrary.org/icdl/SaveBook?bookid=mrzispy_00260005&lang=English&ilang=English

47. The Future…?

48. Managed Learning Environments Roadshow http://www.slideshare.net/paul.seiler/2009-mle-roadshow-4

49. User Created/Generated Content