Upgrade to Pro — share decks privately, control downloads, hide ads and more …

ENUG 2013 Presentation: Item Checker

ENUG 2013 Presentation: Item Checker

At Yale’s main library, we have security measures in place where security staff checks to be sure that library materials are charged out to readers before they leave the building. They do this by looking at the due date slip for each book, matching the barcodes of the slip along with the book. We created a ‘home-grown’ system of electronically checking due dates as materials leave the building. The program gives out visual cues (similar to the red/green traffic light system) alerting the guard whether an item can leave the building or not.

Sarah Tudesco

October 11, 2013
Tweet

More Decks by Sarah Tudesco

Other Decks in Education

Transcript

  1. Oct 11, 2013 Cindy Greenspun - Access Services IT and

    Project Manager Item Checker aka red/green system Yue Ji – Senior Programmer / Analyst Sarah Tudesco – Assessment Librarian
  2. An idea was born when Yale and Harvard got together

    and talked about their ‘wish list’ of what could work better in the library.
  3. Several possible stake holders met to explore the feasibility of

    this idea: Director of Access Services Workstation Support Manager Senior Programmer/Analyst Manager of Enterprise Systems Access Services Project Manager Usability Assessment Librarian
  4. Hardware explored and tested: Cipher Lab Bluetooth scanner and iPad

    Gryphon 4100 scanner and laptop Motorola DS9208 and laptop
  5. Program Architecture Overview The Green/Red application is designed as three-tier

    architecture web application written in JSP, JavaScript, and AJAX. The three-tier architecture is intended to allow any of the three tiers to be upgraded or replaced independently. For example, a change of browser in the Presentation Tier would only affect the user interface code.
  6. Presentation Tier This is the topmost level of the application.

    It communicates with other tiers by outputting results to the browser tier. •Accepts the ITEM BARCODE •Displays the number of ITEMS that each patron has (passed) OR shows stop message
  7. Application Tier Also called logical tier which is pulled out

    from the presentation tier and, as its own layer. It controls an application’s functionality by performing detailed processing Verifies ITEM BARCODES •If ITEM BARCODE is not qualified, sends message back to Presentation Tier by using AJAX call back function. •If ITEM BARCODE is good, query database tables, process results back to Presentation Tier.
  8. Data Tier This tier consists of database servers. Here information

    is stored and retrieved. This tier keeps data independent from application servers or business logic. •PATRON and ITEM data are retrieved from Voyager Oracle database •Saves Gate Transaction data and Item Renew Online Status into a separate MySQL database
  9. Barcodes Scanned by Category 0 5,000 10,000 15,000 20,000 25,000

    30,000 35,000 40,000 45,000 3% 96% 2% 95% 2% 3% 96% 2% 3% 96% 1% 3% Jul-13 Aug-13 Sep-13 98% 1% 2% 97% 1% 2% 2% 97% 98% 1% 2% Feb-13 Jan-13 Mar-13 Apr-13 May-13 Jun-13 1% 2% 96% Oct-12 Nov-12 Dec-12 Sep-12 97% 1% 2% 2% 97% 1% 2% 98% 1% 1% 2% 96% 1% Stop Other Pass
  10. Barcodes Scanned by Exit Location 50% Sterling - Wall Street

    Exit 8% Bass 42% Sterling - High Street Exit
  11. Barcodes Scanned by Exit Location 0 5,000 10,000 15,000 20,000

    25,000 30,000 35,000 40,000 45,000 Aug-13 8% 41% 51% Jul-13 10% 33% 57% Jun-13 9% 40% 51% May-13 8% Feb-13 9% 42% 50% Jan-13 10% 41% 50% Dec-12 6% 42% 50% Apr-13 7% 43% 50% Mar-13 9% 42% 49% 43% 50% Nov-12 8% 44% 48% Sep-13 8% 45% 47% Sep-12 45% 7% Oct-12 4% 40% 56% 48% Sterling - High Street Exit Bass Sterling - Wall Street Exit
  12. Barcodes Scanned by Month 29,618 37,461 35,869 33,003 7,156 15,629

    13,635 13,130 23,737 44,289 30,312 29,826 27,539 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar 30,985 2012 2013 Aug 2012 data incomplete (project started on August 22, 2012
  13. Transactions by Hour: 9/10/2012-9/16/2012 179 0 100 200 300 1AM

    11PM 9PM 7PM 5PM 3PM 1PM 11AM 9AM Mon – 9/10/2012 211 0 100 200 300 3PM 1PM 11AM 9AM Tue – 9/11/2012 1AM 11PM 9PM 7PM 5PM 222 0 100 200 300 1AM 11PM 9PM 7PM 5PM 3PM 1PM 11AM 9AM Wed – 9/12/2012 183 0 100 200 300 Thu – 9/13/2012 1AM 11PM 9PM 7PM 5PM 3PM 1PM 11AM 9AM 171 0 100 200 300 5PM 3PM 7PM Fri – 9/14/2012 9PM 9AM 11AM 1PM 116 0 100 200 300 2PM 6PM 3PM 4PM 5PM Sat – 9/15/2012 11AM 1PM 12PM 10AM 75 0 100 200 300 12PM 2PM 4PM 12AM 10PM Sun – 9/16/2012 8PM 6PM
  14. Transactions by Hour: 9/9/2013-9/15/2013 178 0 100 200 300 1PM

    11AM 9AM Mon – 9/9/2013 1AM 11PM 9PM 7PM 5PM 3PM 164 0 50 100 150 200 Tue – 9/10/2013 1AM 11PM 9PM 7PM 5PM 3PM 1PM 11AM 9AM 169 0 50 100 150 200 1PM 11AM 9AM Wed – 9/11/2013 1AM 11PM 9PM 7PM 5PM 3PM 152 0 100 200 300 9PM 7PM 5PM 3PM 1PM 11AM 9AM Thu – 9/12/2013 1AM 11PM 216 0 100 200 300 Fri – 9/13/2013 9PM 7PM 5PM 3PM 1PM 11AM 9AM 85 0 100 200 300 Sat – 9/14/2013 6PM 5PM 4PM 3PM 2PM 1PM 12PM 11AM 10AM 77 0 100 200 300 Sun – 9/15/2013 12AM 10PM 8PM 6PM 4PM 2PM 12PM
  15. Items Renewed Online by Month 0 5,000 10,000 15,000 20,000

    25,000 30,000 35,000 40,000 45,000 12,580 95% 5% May-13 22,835 93% 7% Apr-13 42,690 92% 8% Mar-13 29,408 93% 7% Feb-13 29,044 95% 5% Jan-13 Sep-13 29,754 97% 3% Aug-13 14,976 96% 4% Jul-13 13,006 96% 4% Jun-13 26,860 97% 3% Dec-12 28,943 93% 7% Nov-12 36,566 95% 5% Oct-12 34,911 96% 4% Sep-12 32,140 98% 2% Checkouts and Desk Renewals Renewed Online