Plumbing and Counting: An Update on the Penn Library Data Farm

1. Plumbing and Counting…An Update on the Penn Library Data Farm ALCTS: Best Practices: Collection Management and the Application of New Measures for Library Assessment Joe Zucca Assessment, Planning and Publications Librarian University of Pennsylvania

2. 4. Pass to vendor site 1. User initiates a session using pages spawned by Oracle 2. URS db swaps handle for authentic url 3. Proxy scan 3.1 Authentication challenge 5. URS logs event 5.1 Proxy server logs the event 5.2 Data Farm Schematic View of the Clickstream

3. Person Resolution Table Domain Map Transaction Tables Resources Tables Data Farm Schema & Key Relays Voyager Web Site URS DB Proxy Source Data Farm E-Resources Database (Elec. Acquisitions)

4. The “Back 40”

5. E-Resource Use By Broad Category. All Domains & Wharton 18 Month Survey Measured in E-Resource Requests All Wharton Domains Cml % Domain Cml% All Electronic Resources 3,885,753 100.0% 87,824 100.0% Licensed Resources 3,345,800 86.3% 81,849 93.2% Public Web Resources 537,822 13.9% 5,956 6.8% Penn-Created Resources 228,461 05.9% 3,217 3.7% Penn Research Guides 124,159 03.2% 1,746 2.0% Government Resources 62,568 01.6% 1,768 2.0%

6. Top-20 Licensed Resources Used in the Wharton Domain 18 Month Survey Measured in E-Resource Requests

7. Use of the Philosopher’s Index 18 Month Survey Measured in Login Requests

8. Use of the Philosopher’s Index Within Libraries18 Month Survey Measured in Login Requests (1,066 logins)

9. How Users Navigate to Electronic Resources. 18 Month Survey Measured in Requests for E-Resources by Referrer

10. E-Resource Tool – How Do “Communities” Work

11. Profile of Community Use - Philosophy 18 Month Survey Measured in Login Requests (7,936 logins, 190 resources) • Facts about Readers Who Select the Philosophy Community: • Avoid Title-Word Searches (only 1% of request) • Usually Browsed by Resource Type (71% of the time) • Prefer Resource Types, in Rank Order: 1. E-Journal 2. Databases, Article Indexes 3. Encyclopedia 4. E-Book, 5. Library Research Guide • Use Up to 12 Different Literature Indexes • Read 170 Different E-Journals in the Field • Use 4 Encyclopedia • Seldom Use Catalogs?

12. Data Relays in the Future? • Today: Static Search, User-Initiated Search of the Repository • Tomorrow: Dynamic Knowledge Channels: The “Portal-Friendly” Data Farm

13. How Are the Data Used? • Analyze Cost-Efficiency of Licensed Resources

14. Plumbing and Counting…An Update on the Penn Library Data Farm ALCTS: Best Practices: Collection Management and the Application of New Measures for Library Assessment Joe Zucca Assessment, Planning and Publications Librarian University of Pennsylvania zucca@pobox.upenn.edu

15. Multiple Vendors. Regression of Data Farm Login Requests on Vendor Session Counts, Jl2003-Dec2003 [63 observations]

16. ScienceDirect: Regression of Data Farm Counts on Elsevier Article View Counts, Jl2003-Dec2003. [1,270 observations]

20. Count By Title and Domain

21. Resource Type and Domain Result (Biology)

22. Count By Resource Type and Domain

23. Resource Type and Domain Result (Wharton)