Building Frameworks of Organizational Intelligence

1
Building Frameworks of Organizational
Intelligence Joe Zucca Director for
Planning and Communication University of
Pennsylvania Libraries
2
Building Frameworks of Organizational Intelligence
Sample Data Structure I Data Farm Funds Report -
Biology
3
Building Frameworks of Organizational Intelligence
Sample Data Structure I Data Farm Funds Report -
Casalini Libri
4
Building Frameworks of Organizational Intelligence
Sample Data Structure II - Data Farm Table -
Funds Process
5
Building Frameworks of Organizational Intelligence
invoice
bib_text
Sample Data Structure III - Voyager Funds Schema
bib_ master
Invoice_ line_item
invoice_ status
line_item
purchase_ order
invoice_ line_item _funds
fund
vendor
6
Building Frameworks of Organizational Intelligence
Working with data structures
7
Building Frameworks of Organizational Intelligence
Data Farm Oracle Space-Overview 30 gb, in
162 tables, for collecting and disseminating
management info
Reference Contact
Circulation
Acquisitions Funds
Web Analytics
Holdings
Image Collection Use
Consortia ILL/DocDel
Tech Processing Workflow
70-Member ILL Coop.
Copier Printer Use
Gate Swipes
8
Building Frameworks of Organizational Intelligence
Service Environment
Data Farm Silos
WEB Apache ezproxy
RefInstruct
funds
9
Building Frameworks of Organizational Intelligence
A different take on a management information
framework
10
Building Frameworks of Organizational Intelligence
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx-zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
11
Building Frameworks of Organizational Intelligence
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
xxx.xx.xxx.xxx (ip address) .edu on-campus
Van Pelt Library staff office July 26, 2007
341 p.m. Device Mac OSX Browser Safari
12
Building Frameworks of Organizational Intelligence
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
Referring URL library web page listing
resources on Psychology (community 59) Olson,
Coordinating Bibliographer
13
Building Frameworks of Organizational Intelligence
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
zucca Penn authentication key Provost cntr
LIBRARY staff
14
Building Frameworks of Organizational Intelligence
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
SessionID 10335905PsycInfo (resource identifier
7014)
15
Building Frameworks of Organizational Intelligence
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F
sfx_session_idJournal of Experimental Child
Psychology, Relations Among Musical Skills,
Phonological Processing and Early Reading Ability
in Preschool Children.
16
Building Frameworks of Organizational Intelligence
Sample Data Structure EZ-Proxy Log
xxx.xx.xxx.xxx -zucca26/Jul/2007154101
-0500 GET https//proxy.library.upenn.edu443/lo
gin?proxySessionID10335905url
http//www.csa.com/htbin/dbrng.cgi?usernameupenn3
accessupenn34catpsycinfoadv1 HTTP/1.1
3020http//www.library.upenn.edu/cgi-bin/res/sr.
cgi?community59 Mozilla/5.0 (Macintosh U PPC
Mac OS X en) AppleWebKit/418.9.1 (KHTML, like
Gecko) Safari/419.3 NGpmb6dT6JXswQH__utmc945657
61 ezproxyNGpmb6dT6JXswQH hp/
proxySessionID10335514 __utmc247612227
__utmz247612227.1184251774.1.1.utmccn(direct)
utmcsr(direct)utmcmd(none) UPennLibraryAAAAAU
aWP5oAACa4AwOOAg sfx_session_ids6A37A3E0-3B8E-
11DC-80E9-85076F88F67F

• TRANSLATION

• July 26, 2007 at 341 pm

• A library staff (Provosts center affiliate)

• Using a staff computer (MACOSXSafari) located
  in Van Pelt Library

and in the same session,

• Logged into PsychInfo (CSA)

• Made an open-url connection to an article on
  reading aptitude published in the Journal
  of Experimental Child Psychology.

17
Building Frameworks of Organizational Intelligence
Events a Structure for Library Decision Metrics
EVENT
18
Building Frameworks of Organizational Intelligence
Service Environment
Data Farm Silos
WEB Apache ezproxy
RefInstruct
funds
19
Building Frameworks of Organizational Intelligence
Data Farm Framework
Service Environment
Repository processes
Sources
Analysis
DATA STORE query (xsql) parse,
resolve, anonymize, secure! store
as metridoc.xml
oracle
XML
logs
perl
oracle
XL
20
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
ltENVIRONMENTALgt ltv.domaingt ltp.domaingt ltdategt lttime
gt ltsessiongt lturlgt lt/ENVIRONMENTALgt ltCLIENTgt ltscho
olgt ltdeptgt ltrankgt lt/CLIENTgt ltLIBRARY
PRGRMgt ltservice genregt ltstaff_namegt ltstaff_orggt lts
taff_prgmgt lt/LIBRARY PRGRMgt ltCONTENTgt lttitlegt ltau
thorgt ltholdingsgt ltcall_nogt ltisbngt ltissngt lturlgt ltre
s_idgt ltsfx_idgt lt/CONTENTgt
21
Building Frameworks of Organizational Intelligence
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
ltENVIRONMENTALgt ltv.domaingt ltp.domaingt ltdategt lttime
gt ltsessiongt lturlgt lt/ENVIRONMENTALgt ltCLIENTgt ltscho
olgt ltdeptgt ltrankgt lt/CLIENTgt ltLIBRARY
PRGRMgt ltservice genregt ltstaff_namegt ltstaff_orggt lts
taff_prgmgt lt/LIBRARY PRGRMgt ltCONTENTgt lttitlegt ltau
thorgt ltholdingsgt ltcall_nogt ltisbngt ltissngt lturlgt ltre
s_idgt ltsfx_idgt lt/CONTENTgt
22
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
ltENVIRONMENTALgt ltv.domaingt ltp.domaingt ltdategt lttime
gt ltsessiongt lturlgt lt/ENVIRONMENTALgt ltCLIENTgt ltscho
olgt ltdeptgt ltrankgt lt/CLIENTgt ltLIBRARY
PRGRMgt ltservice genregt ltstaff_namegt ltstaff_orggt lts
taff_prgmgt lt/LIBRARY PRGRMgt ltCONTENTgt lttitlegt ltau
thorgt ltholdingsgt ltcall_nogt ltisbngt ltissngt lturlgt ltre
s_idgt ltsfx_idgt lt/CONTENTgt
23
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
ltENVIRONMENTALgt ltv.domaingt ltp.domaingt ltdategt lttime
gt ltsessiongt lturlgt lt/ENVIRONMENTALgt ltCLIENTgt ltscho
olgt ltdeptgt ltrankgt lt/CLIENTgt ltLIBRARY
PRGRMgt ltservice genregt ltstaff_namegt ltstaff_orggt lts
taff_prgmgt lt/LIBRARY PRGRMgt ltCONTENTgt lttitlegt ltau
thorgt ltholdingsgt ltcall_nogt ltisbngt ltissngt lturlgt ltre
s_idgt ltsfx_idgt lt/CONTENTgt
24
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
ltENVIRONMENTALgt ltv.domaingt ltp.domaingt ltdategt lttime
gt ltsessiongt lturlgt lt/ENVIRONMENTALgt ltCLIENTgt ltscho
olgt ltdeptgt ltrankgt lt/CLIENTgt ltLIBRARY
PRGRMgt ltservice genregt ltstaff_namegt ltstaff_orggt lts
taff_prgmgt lt/LIBRARY PRGRMgt ltCONTENTgt lttitlegt ltau
thorgt ltholdingsgt ltcall_nogt ltisbngt ltissngt lturlgt ltre
s_idgt ltsfx_idgt lt/CONTENTgt
Biblio- graphic Content
25
Building Frameworks of Organizational Intelligence
Schematic Workflow
ltENVIRONMENTALgt ltvan_peltgt ltp.locationgt lt26-jul-20
07gt lt154101gt lt10335905gt lt http//www.csa gt lt
http//www.library.upe..gt ltmacOSXgt ltsafari2.0.4gt lt
/ENVIRONMENTALgt ltCLIENTgt ltLIBgt ltadmingt ltstaffgt lt/
CLIENTgt ltLIBRARY PRGRMgt ltursgt ltolsongt lt5035gt ltcol
ldevgt lt/LIBRARY PRGRMgt ltCONTENTgt ltpsycinfogt ltCSAgt
lt1017-7041gt lt1901-3425gt lt1452845903gt lt
http//www.csa gt ltsfx_idgt lt/CONTENTgt
Data Source instructions
Event schema
Penn Community
Java- based processes
voyager
Staff db
metridoc.xml
Data Store
26
Building Frameworks of Organizational Intelligence
Faculty Use of Electronic Journals School by
Journal Topic 21,634 article views
27
Building Frameworks of Organizational Intelligence
Faculty Use of Electronic Journals School by
Journal Topic Aggregated 21,634 article
views
28
Building Frameworks of Organizational Intelligence
Faculty Use of Electronic Journals Correlation
by School pearson r 21,634 article views
29
Building Frameworks of Organizational Intelligence
Faculty Use of Electronic Journals
Multi-Dimensional Scaling Model
30
Building Frameworks of Organizational Intelligence
Consortial Borrowing Activity Class
PN1993-1999, Motion Pictures 2002-2007
31
Building Frameworks of Organizational Intelligence
Consortial Borrowing Activity Class
PN1993-1999, Motion Pictures 7,512 requests,
1999-Dec 2008
Pct of Request
20 of titles account for nearly 50 of requests
Pct of Titles
32
Building Frameworks of Organizational Intelligence
Borrower Lender Req Date
Cornell Dartmouth 2003
Brown Penn 2003
Princeton Dartmouth 2003
Brown Cornell 2003
Princeton Dartmouth 2003
Princeton Dartmouth 2003
Princeton Cornell 2003
Yale Dartmouth 2003
Princeton Penn 2004
Penn Dartmouth 2004
Yale Brown 2004
Penn Yale 2004
Cornell Dartmouth 2004
Columbia Dartmouth 2005
Princeton Columbia 2005
Yale Dartmouth 2005
Penn Dartmouth 2005
Dartmouth Columbia 2005
Brown Dartmouth 2006
Columbia Dartmouth 2006
Princeton Dartmouth 2006
Penn Yale 2006
Penn Princeton 2006
Columbia Brown 2006
Cornell Yale 2006
Princeton Columbia 2007
Cornell Columbia 2007
The Emergence of Cinematic Time
PN1995.5 T55 D63 2002
33
Building Frameworks of Organizational Intelligence
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.
34
Building Frameworks of Organizational Intelligence
Questions?
Joe Zucca zucca_at_pobox.upenn.edu
215-573-4643
University of Pennsylvania Library
Office of Planning and Communication