220 likes | 396 Views
Customized Access Authorization. By Phil Boyer and Wei Wu Washington Research Library Consortium. Washington Research Library Consortium 901 Commerce Drive Upper Marlboro, MD 20774 301-390-2000 www.wrlc.org. Gallaudet.
E N D
Customized Access Authorization By Phil Boyer and Wei Wu Washington Research Library Consortium
Washington Research Library Consortium 901 Commerce Drive Upper Marlboro, MD 20774 301-390-2000 www.wrlc.org Gallaudet George Mason Catholic • American WRLC George Washington University of DC Marymount
Catholic University University of DC Gallaudet University American University George Washington University The Washington Research Library Consortium WRLC Marymount University Washington, DC George Mason University Total 7 member libraries
WRLC Members • Seven universities in the Washington DC metropolitan area • 5 private and 2 public • Total 75,000 students (head count) • (Largest has 20,000; smallest has 2,000) • Total about 5 million volumes • (Largest has 1.4 million; smallest has 170,000)
WRLC Members Share • Collections • Computer technology • Facilities
Cooperative Collection Development Reciprocal Borrowing Shared Electronic Library System Offsite Storage WRLC Programs WRLC Virtual Library
WRLC Reciprocal Borrowing Program • Students, faculty and staff may borrow from any member library using their own university ID • Patrons may return items to any member library • All patrons are registered in a single shared patron file
WRLC Electronic Resource Subscriptions • Core databases are available to all members (general periodical indexes, newspaper abstracts, full article images) • Members may subscribe to supplemental (optional) databases, to be accessed from the shared computing system • WRLC can serve as the contracting agent for supplemental subscriptions, to secure consortial pricing where available
WRLC ALADIN System Overview Over 700 stations in member libraries From campus networks To and from the INTERNET T-1 circuits T-1 circuits Wide-area network supporting approx. 750 simultaneous users Servers at WRLC Sun Microsystems Ultra Enterprise 6000 and 4000s
IBM Mainframe IBMAIX Notis VSAM PatronFile SiteSearch 3.x CGI SNA UserID PatronGroups Assembler Perl C Korn shell
Sun Solaris IBMAIX Voyager Oracle PatronTable SiteSearch 3.x CGI Socket UserID PatronGroups Perl Perl C Korn shell
Migration from SiteSearch 3 to 4 • Preserve the current “look and feel” • No logo menu, the patron sees either a list of databases or a logon screen • Go production in 60 days • Change the locally mounted databases to UMI and OVID
Sun Solaris Sun Solaris Voyager Oracle PatronTable SiteSearch 4.x Access SQLNet UserID PatronGroups Java JDBC
www.aladin.wrlc.orgindex.html • “Refresh” to the following URL: /www.aladin.wrlc.org/WebZ/WRLCConnect:sessionid=0 • If the browser can’t handle the “refresh”, links are provided to access the Voyager catalog or a logon screen
index.htmlWRLCConnect.java • If a valid ip address, get the list of databases from Access and display homeframe.html • else display the logon or Patron Validation screen
Library Catalogs WRLC Libraries Catalog George Mason University Library Catalog For current George Mason library material, please search the GMU catalog. Trinity College Library Catalog WRLC Libraries Websites WRLC Image Collections Patron Validation To access library catalogs and other public databases, select one of the links on the left. To access article databases and other resources, enter your Library Patron ID and click the Go! button. Patron ID: Patron ID may be your Social Security Number, University ID number, or Library User Barcode number. Enter only digits...no spaces or hyphens.
Patron ValidationWRLCLogon.java • If a valid ID, which could be SSN, barcode or University ID, get the list of databases from Access and display homeframe.html • else display a logon failure message and repeat the Patron Validation process
Library Catalogs WRLC Libraries Catalog George Mason University Library Catalog For current George Mason library material, please search the GMU catalog. Trinity College Library Catalog WRLC Libraries Websites WRLC Image Collections Article and Other Databases ABI/Inform ACM Digital Library Art Abstracts Books in Print Cinahl ERIC First Search MathSciNet Newspaper Abstracts STAT-USA World News Connection
Authostable: autho pwd userdbkey style sessions name ----------------------------------------------------------------------------------------------------------------- 61 password au wrlc 100 American University 145 password au wrlc 100 American University 51 password ga wrlc 100 Gallaudet University 173 password mu wrlc 100 Marymount University 67 password tc wrlc 100 Trinity College …... ip:299.* NULL auIP wrlc 100 American University …...
Userdbtable: userdbkey dbid ------------------------------ au 126 au 1 auIP 126 auIP 1 gw 278 gw 1 gwIP 278 gwIP 1 tc 306 all 82 all 1 allIP 82 allIP 1
Dbstable: dbid dbname authotype sessions ------------------------------------------------------------------------------------------- 306 CONTEMPORARYWOMEN 1 5 278 AMERICANMATH 1 5 268 CAMRIDGESCIABALPIP 1 5 251 HARPWEEKAUIP 1 5 195 MATHSCINETIP 1 5 127 PSYCINFOUDC 1 5 82 PSYCINFOAU 1 5 ….. 1 VOYAGER 1 5
Summary • Two java programs which use the Authorize verb: WRLCConnect.java and WRLCLogon.java • Three java programs to query an Oracle patron table: Patron.java, Barcode.java and InstID.java • JDBC • Some html screens