1 / 62

How to make your database sing.

How to make your database sing. Presented by: Vicki Stephens Library Adviser National Library of New Zealand vicki.stephens@dia.govt.nz. http://schools.natlib.govt.nz/. In the beginning….

sarila
Download Presentation

How to make your database sing.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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…

  10. 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

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

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

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

  14. ILMS & OPAC • ILMS = Integrated Library Management System • OPAC = Online Public Access Catalogue (WebOPAC)

  15. 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…

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

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

  18. 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

  19. 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.

  20. 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

  21. 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…

  22. 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

  23. 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….

  24. 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/

  25. 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

  26. 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

  27. SCIS Websites

  28. Use Your URL

  29. http://schools.natlib.govt.nz/high-interest-topics

  30. http://schools.natlib.govt.nz/high-interest-topics/earthquakehttp://schools.natlib.govt.nz/high-interest-topics/earthquake

  31. http://schools.natlib.govt.nz/high-interest-topics/rugby-world-cup-2011http://schools.natlib.govt.nz/high-interest-topics/rugby-world-cup-2011

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

  33. http://en.childrenslibrary.org/

  34. 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

  35. The Future…?

More Related