Presentation Transcript
Slide1 : Building Frameworks of Organizational Intelligence
Joe Zucca
Director for Planning and Communication
University of Pennsylvania Libraries
Slide2 : Sample Data Structure I: Data Farm Funds Report - Biology Building Frameworks of Organizational Intelligence
Slide3 : Building Frameworks of Organizational Intelligence Sample Data Structure I: Data Farm Funds Report - Casalini Libri
Slide4 : Sample Data Structure II - Data Farm Table - Funds Process Building Frameworks of Organizational Intelligence
Slide5 : Sample Data Structure III - Voyager Funds Schema Invoice_
line_item invoice_
status purchase_
order line_item invoice_
line_item
_funds fund invoice vendor bib_
master bib_text Building Frameworks of Organizational Intelligence
Slide6 : Working with data structures Building Frameworks of Organizational Intelligence
Slide7 : Reference Contact Circulation Acquisitions Funds Holdings Copier | Printer Use Gate Swipes Web Analytics Image Collection Use Data Farm Oracle Space-Overview
30+ gb, in 162 tables, for collecting and disseminating management info Tech Processing Workflow Building Frameworks of Organizational Intelligence Consortia ILL/DocDel 70-Member ILL Coop.
Slide8 : Service Environment WEB
Apache
ezproxy Ref|Instruct Data Farm Silos funds Building Frameworks of Organizational Intelligence
Slide9 : A different take on a management information framework Building Frameworks of Organizational Intelligence
Slide10 : xxx.xx.xxx.xxx|-|zucca|[26/Jul/2007:15:41:01 -0500]| GET https://proxy.library.upenn.edu:443/login?proxySessionID=10335905&url= http://www.csa.com/htbin/dbrng.cgi?username=upenn3&access=upenn34&cat=psycinfo&adv=1 HTTP/1.1| 302|0|http://www.library.upenn.edu/cgi-bin/res/sr.cgi?community=59| Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3| NGpmb6dT6JXswQH|__utmc=94565761; ezproxy=NGpmb6dT6JXswQH; hp=/; proxySessionID=10335514; __utmc=247612227; __utmz=247612227.1184251774.1.1.utmccn=(direct)| utmcsr=(direct)|utmcmd=(none); UPennLibrary=AAAAAUaWP5oAACa4AwOOAg==; sfx_session_id=s6A37A3E0-3B8E-11DC-80E9-85076F88F67F Sample Data Structure: EZ-Proxy Log Building Frameworks of Organizational Intelligence
Slide11 : xxx.xx.xxx.xxx |-|zucca|[26/Jul/2007:15:41:01 -0500]| GET https://proxy.library.upenn.edu:443/login?proxySessionID=10335905&url= http://www.csa.com/htbin/dbrng.cgi?username=upenn3&access=upenn34&cat=psycinfo&adv=1 HTTP/1.1| 302|0|http://www.library.upenn.edu/cgi-bin/res/sr.cgi?community=59| Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3| NGpmb6dT6JXswQH|__utmc=94565761; ezproxy=NGpmb6dT6JXswQH; hp=/; proxySessionID=10335514; __utmc=247612227; __utmz=247612227.1184251774.1.1.utmccn=(direct)| utmcsr=(direct)|utmcmd=(none); UPennLibrary=AAAAAUaWP5oAACa4AwOOAg==; sfx_session_id=s6A37A3E0-3B8E-11DC-80E9-85076F88F67F xxx.xx.xxx.xxx (ip address) = .edu | on-campus | Van Pelt Library | staff office
July 26, 2007: 3:41 p.m.
Device= Mac | OSX Browser= Safari
Sample Data Structure: EZ-Proxy Log Building Frameworks of Organizational Intelligence
Slide12 : xxx.xx.xxx.xxx |-|zucca|[26/Jul/2007:15:41:01 -0500]| GET https://proxy.library.upenn.edu:443/login?proxySessionID=10335905&url= http://www.csa.com/htbin/dbrng.cgi?username=upenn3&access=upenn34&cat=psycinfo&adv=1 HTTP/1.1| 302|0|http://www.library.upenn.edu/cgi-bin/res/sr.cgi?community=59| Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3| NGpmb6dT6JXswQH|__utmc=94565761; ezproxy=NGpmb6dT6JXswQH; hp=/; proxySessionID=10335514; __utmc=247612227; __utmz=247612227.1184251774.1.1.utmccn=(direct)| utmcsr=(direct)|utmcmd=(none); UPennLibrary=AAAAAUaWP5oAACa4AwOOAg==; sfx_session_id=s6A37A3E0-3B8E-11DC-80E9-85076F88F67F Referring URL = library web page listing resources on Psychology (community 59) | Olson, Coordinating Bibliographer Sample Data Structure: EZ-Proxy Log Building Frameworks of Organizational Intelligence
Slide13 : xxx.xx.xxx.xxx |-|zucca|[26/Jul/2007:15:41:01 -0500]| GET https://proxy.library.upenn.edu:443/login?proxySessionID=10335905&url= http://www.csa.com/htbin/dbrng.cgi?username=upenn3&access=upenn34&cat=psycinfo&adv=1 HTTP/1.1| 302|0|http://www.library.upenn.edu/cgi-bin/res/sr.cgi?community=59| Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3| NGpmb6dT6JXswQH|__utmc=94565761; ezproxy=NGpmb6dT6JXswQH; hp=/; proxySessionID=10335514; __utmc=247612227; __utmz=247612227.1184251774.1.1.utmccn=(direct)| utmcsr=(direct)|utmcmd=(none); UPennLibrary=AAAAAUaWP5oAACa4AwOOAg==; sfx_session_id=s6A37A3E0-3B8E-11DC-80E9-85076F88F67F zucca [Penn authentication key] = Provost cntr | LIBRARY | staff Sample Data Structure: EZ-Proxy Log Building Frameworks of Organizational Intelligence
Slide14 : xxx.xx.xxx.xxx |-|zucca|[26/Jul/2007:15:41:01 -0500]| GET https://proxy.library.upenn.edu:443/login?proxySessionID=10335905&url= http://www.csa.com/htbin/dbrng.cgi?username=upenn3&access=upenn34&cat=psycinfo&adv=1 HTTP/1.1| 302|0|http://www.library.upenn.edu/cgi-bin/res/sr.cgi?community=59| Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3| NGpmb6dT6JXswQH|__utmc=94565761; ezproxy=NGpmb6dT6JXswQH; hp=/; proxySessionID=10335514; __utmc=247612227; __utmz=247612227.1184251774.1.1.utmccn=(direct)| utmcsr=(direct)|utmcmd=(none); UPennLibrary=AAAAAUaWP5oAACa4AwOOAg==; sfx_session_id=s6A37A3E0-3B8E-11DC-80E9-85076F88F67F SessionID 10335905=PsycInfo (resource identifier 7014) Sample Data Structure: EZ-Proxy Log Building Frameworks of Organizational Intelligence
Slide15 : xxx.xx.xxx.xxx |-|zucca|[26/Jul/2007:15:41:01 -0500]| GET https://proxy.library.upenn.edu:443/login?proxySessionID=10335905&url= http://www.csa.com/htbin/dbrng.cgi?username=upenn3&access=upenn34&cat=psycinfo&adv=1 HTTP/1.1| 302|0|http://www.library.upenn.edu/cgi-bin/res/sr.cgi?community=59| Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3| NGpmb6dT6JXswQH|__utmc=94565761; ezproxy=NGpmb6dT6JXswQH; hp=/; proxySessionID=10335514; __utmc=247612227; __utmz=247612227.1184251774.1.1.utmccn=(direct)| utmcsr=(direct)|utmcmd=(none); UPennLibrary=AAAAAUaWP5oAACa4AwOOAg==; sfx_session_id=s6A37A3E0-3B8E-11DC-80E9-85076F88F67F sfx_session_id=Journal of Experimental Child Psychology,
“Relations Among Musical Skills, Phonological Processing and Early Reading Ability in Preschool Children.” Sample Data Structure: EZ-Proxy Log Building Frameworks of Organizational Intelligence
Slide16 : xxx.xx.xxx.xxx |-|zucca|[26/Jul/2007:15:41:01 -0500]| GET https://proxy.library.upenn.edu:443/login?proxySessionID=10335905&url= http://www.csa.com/htbin/dbrng.cgi?username=upenn3&access=upenn34&cat=psycinfo&adv=1 HTTP/1.1| 302|0|http://www.library.upenn.edu/cgi-bin/res/sr.cgi?community=59| Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3| NGpmb6dT6JXswQH|__utmc=94565761; ezproxy=NGpmb6dT6JXswQH; hp=/; proxySessionID=10335514; __utmc=247612227; __utmz=247612227.1184251774.1.1.utmccn=(direct)| utmcsr=(direct)|utmcmd=(none); UPennLibrary=AAAAAUaWP5oAACa4AwOOAg==; sfx_session_id=s6A37A3E0-3B8E-11DC-80E9-85076F88F67F TRANSLATION:
Made an open-url connection to an article on reading aptitude published in the Journal of Experimental Child Psychology. Logged into PsychInfo (CSA) Using a staff computer (MAC|OSX|Safari) located in Van Pelt Library A library staff (Provost’s center affiliate) July 26, 2007 at 3:41 pm and in the same session, Sample Data Structure: EZ-Proxy Log Building Frameworks of Organizational Intelligence
Slide17 : EVENT Events: a Structure for Library Decision Metrics Building Frameworks of Organizational Intelligence
Slide18 : Service Environment WEB
Apache
ezproxy Ref|Instruct Data Farm Silos funds Building Frameworks of Organizational Intelligence
Slide19 : DATA STORE
query (xsql)
parse, resolve,
anonymize,
secure!
store as
metridoc.xml
Data Farm Framework oracle logs oracle XML Sources Repository processes Analysis perl XL Service Environment Building Frameworks of Organizational Intelligence
Slide20 : Event Elements Articulated in an XML Schema
METRIDOC Building Frameworks of Organizational Intelligence
Slide21 :
Event Elements Articulated in an XML Schema Building Frameworks of Organizational Intelligence METRIDOC Building Frameworks of Organizational Intelligence
Slide22 :
Event Elements Articulated in an XML Schema METRIDOC Building Frameworks of Organizational Intelligence
Slide23 :
Event Elements Articulated in an XML Schema METRIDOC Building Frameworks of Organizational Intelligence
Slide24 :
Event Elements Articulated in an XML Schema Biblio-
graphic
Content METRIDOC Building Frameworks of Organizational Intelligence
Slide25 : Data
Source
instructions Event
schema metridoc.xml voyager Penn
Community Staff db Java-
based
processes Data Store
<26-jul-2007>
<15:41:01>
<10335905>
< http://www.csa… >
< http://www.library.upe..>
<5035>
<1017-7041>
<1901-3425>
<1452845903>
< http://www.csa… >
Schematic
Workflow Building Frameworks of Organizational Intelligence
Slide26 : Building Frameworks of Organizational Intelligence Faculty Use of Electronic Journals: School by Journal Topic 21,634 article views]
Slide27 : Building Frameworks of Organizational Intelligence Faculty Use of Electronic Journals: School by Journal Topic – Aggregated [21,634 article views]
Slide28 : Building Frameworks of Organizational Intelligence Faculty Use of Electronic Journals: Correlation by School [pearson r | 21,634 article views]
Slide29 : Building Frameworks of Organizational Intelligence Faculty Use of Electronic Journals: Multi-Dimensional Scaling Model
Slide30 : Consortial Borrowing Activity:
Class PN1993-1999, Motion Pictures 2002-2007 Building Frameworks of Organizational Intelligence
Slide31 : Pct of Request Pct of Titles 20% of titles account for nearly 50% of requests Building Frameworks of Organizational Intelligence Consortial Borrowing Activity:
Class PN1993-1999, Motion Pictures [7,512 requests, 1999-Dec 2008]
Slide32 : Building Frameworks of Organizational Intelligence The Emergence of Cinematic Time PN1995.5 T55 D63 2002
Slide33 : Summary:
Exploring new frameworks that enrich organizational intelligence.
Taking advantage of xml extensibility to increase the descriptive power
of library data resources.
Aligning management information technology with the broader
direction in digital library design.
Evaluating the potential for shared, open-source solutions that
might promote collaborative data gathering and assessment.
Building Frameworks of Organizational Intelligence
Slide34 : Joe Zucca
zucca@pobox.upenn.edu
215-573-4643
University of Pennsylvania Library Office of Planning and Communication Questions? Building Frameworks of Organizational Intelligence
Catch the
buzz on authorSTREAM
Copyright © 2002-2008 authorSTREAM. All rights reserved.