Transcript Building Frameworks of Organizational Intelligence Joe Zucca Director for Planning and Communication University of Pennsylvania Libraries.

Building Frameworks of Organizational Intelligence
Joe Zucca
Director for Planning and Communication
University of Pennsylvania Libraries
Building Frameworks of Organizational Intelligence
Sample Data Structure I: Data Farm Funds Report - Biology
Building Frameworks of Organizational Intelligence
Sample Data Structure I: Data Farm Funds Report - Casalini Libri
Building Frameworks of Organizational Intelligence
Sample Data Structure II - Data Farm Table - Funds Process
Building Frameworks of Organizational Intelligence
Sample Data Structure III - Voyager Funds Schema
bib_
master
bib_text
invoice
invoice_
status
Invoice_
line_item
line_item
fund
invoice_
line_item
_funds
purchase_
order
vendor
Building Frameworks of Organizational Intelligence
Working with data structures
Information Loop
Service Environment
Catalog
ERED
Funds
SFX | ERM?
Data Farm
Environment
Integrate
Circulation
Inform
DYNIX
BorrowDirect
WEB
Apache
ezproxy
Report Builder
Ref|Instruct
Dashboard
Data Streams
People and
Network Data
Clean | Anonymize
Normalize
Data Bureau
Building Frameworks of Organizational Intelligence
Data Farm Oracle Space-Overview
30+ gb, in 162 tables, for collecting and disseminating management info
E-Resource Use
Circulation
Reference Contact
Web Analytics
Acquisitions Funds
Resolve Resource
Image Collection Use
Holdings
Resolve People
Consortia ILL/DocDel
Tech Processing
Workflow
Resolve Places
Digital Library
70-Member ILL Coop.
Copier | Printer Use
Voyager-Supported Services
Building Use
Staff Census
Gate Swipes
Reference & Instruction (dynamic)
Resolution Services
Administration
LDAP
Building Frameworks of Organizational Intelligence
Service Environment
Data Farm Silos
Catalog
ERED
Funds
SFX | ERM?
Circulation
DYNIX
BorrowDirect
WEB
Apache
ezproxy
Ref|Instruct
funds
Building Frameworks of Organizational Intelligence
A different take on a management information framework
Building Frameworks of Organizational Intelligence
Sample Data Structure: EZ-Proxy Log
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/cgibin/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
Building Frameworks of Organizational Intelligence
Sample Data Structure: EZ-Proxy Log
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/cgibin/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
Building Frameworks of Organizational Intelligence
Sample Data Structure: EZ-Proxy Log
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/cgibin/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
Building Frameworks of Organizational Intelligence
Sample Data Structure: EZ-Proxy Log
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/cgibin/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
Building Frameworks of Organizational Intelligence
Sample Data Structure: EZ-Proxy Log
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/cgibin/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)
Building Frameworks of Organizational Intelligence
Sample Data Structure: EZ-Proxy Log
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/cgibin/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.”
Building Frameworks of Organizational Intelligence
Sample Data Structure: EZ-Proxy Log
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-80E985076F88F67F
TRANSLATION:
•
July 26, 2007 at 3:41 pm
•
A library staff (Provost’s center affiliate)
•
Using a staff computer (MAC|OSX|Safari) located in Van Pelt Library
•
Logged into PsychInfo (CSA) and in the same session,
Made an open-url connection to an article on reading aptitude
published in the Journal of Experimental Child Psychology.
•
Building Frameworks of Organizational Intelligence
Events: a Structure for Library
Decision Metrics
Org|Program
Staff
Unrestricted
Restricted
Level
Library
Program
Course
Descriptor
Fund Code
Service
Genre
Budget
Dept
Expnd Amt
Client
Program
EVENT
Bibliographic
Content
Dept
Reqmnt
School
URL
Client
Environment
School
IP-Domain
Dept
Rank
Date|Time
Major
Campus
Location
Building Frameworks of Organizational Intelligence
Service Environment
Data Farm Silos
Catalog
ERED
Funds
SFX | ERM?
Circulation
DYNIX
BorrowDirect
WEB
Apache
ezproxy
Ref|Instruct
funds
Building Frameworks of Organizational Intelligence
Data Farm Framework
Service Environment
Repository processes
Catalog
ERED
Funds
SFX | ERM?
Circulation
DYNIX
Sources
DATA STORE
XML
BorrowDirect
WEB
Apache
ezproxy
Analysis
logs
Ref|Instruct
query (xsql)
parse, resolve,
anonymize,
secure!
oracle
perl
store as
metridoc.xml
oracle
XL
Building Frameworks of Organizational Intelligence
Event Elements Articulated in an XML Schema
METRIDOC
<ENVIRONMENTAL>
<v.domain>
<p.domain>
<date>
<time>
<session>
<url>
</ENVIRONMENTAL>
Library
Program
Budget
Client
Program
EVENT
Content
Client
Environment
<CLIENT>
<school>
<dept>
<rank>
</CLIENT>
<LIBRARY PRGRM>
<service genre>
<staff_name>
<staff_org>
<staff_prgm>
</LIBRARY PRGRM>
<CONTENT>
<title>
<author>
<holdings>
<call_no>
<isbn>
<issn>
<url>
<res_id>
<sfx_id>
</CONTENT>
Building
of Organizational
Intelligence
BuildingFrameworks
Frameworks
of Organizational
Intelligence
URL
METRIDOC
Event Elements Articulated in an XML Schema
IP-Domain
Date|Time
Library
Program
Budget
Client
Program
EVENT
Content
Client
Environment
<ENVIRONMENTAL>
<v.domain>
<p.domain>
<date>
Environment
<time>
<session>
<url>
</ENVIRONMENTAL>
Campus
Location
<CLIENT>
<school>
<dept>
<rank>
</CLIENT>
<LIBRARY PRGRM>
<service genre>
<staff_name>
<staff_org>
<staff_prgm>
</LIBRARY PRGRM>
<CONTENT>
<title>
<author>
<holdings>
<call_no>
<isbn>
<issn>
<url>
<res_id>
<sfx_id>
</CONTENT>
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
<ENVIRONMENTAL>
<v.domain>
<p.domain>
<date>
<time>
<session>
<url>
</ENVIRONMENTAL>
School
Library
Program
Dept
Budget
Client
Program
Client
<CLIENT>
<school>
<dept>
<rank>
</CLIENT>
Major
EVENT
Content
Client
Environment
Rank
<LIBRARY PRGRM>
<service genre>
<staff_name>
<staff_org>
<staff_prgm>
</LIBRARY PRGRM>
<CONTENT>
<title>
<author>
<holdings>
<call_no>
<isbn>
<issn>
<url>
<res_id>
<sfx_id>
</CONTENT>
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
<ENVIRONMENTAL>
<v.domain>
<p.domain>
<date>
<time>
<session>
<url>
</ENVIRONMENTAL>
Library
Program
Budget
Service Genre
Client
Program
EVENT
Content
Client
Environment
Library
Program
Org|Program
Staff
<CLIENT>
<school>
<dept>
<rank>
</CLIENT>
<LIBRARY PRGRM>
<service genre>
<staff_name>
<staff_org>
<staff_prgm>
</LIBRARY PRGRM>
<CONTENT>
<title>
<author>
<holdings>
<call_no>
<isbn>
<issn>
<url>
<res_id>
<sfx_id>
</CONTENT>
Building Frameworks of Organizational Intelligence
METRIDOC
Event Elements Articulated in an XML Schema
<ENVIRONMENTAL>
<v.domain>
<p.domain>
<date>
<time>
<session>
<url>
</ENVIRONMENTAL>
Library
Program
<CLIENT>
<school>
<dept>
<rank>
</CLIENT>
Budget
Client
Program
<LIBRARY PRGRM>
<service genre>
<staff_name>
<staff_org>
<staff_prgm>
</LIBRARY PRGRM>
EVENT
Content
Client
Environment
Bibliographic
Content
<CONTENT>
<title>
<author>
<holdings>
<call_no>
<isbn>
<issn>
<url>
<res_id>
<sfx_id>
</CONTENT>
Building Frameworks of Organizational Intelligence
Schematic
Workflow
Event
schema
Data
Source
instructions
Penn
Community
voyager
Staff db
Javabased
processes
metridoc.xml
Data Store
<ENVIRONMENTAL>
<van_pelt>
<p.location>
<26-jul-2007>
<15:41:01>
<10335905>
< http://www.csa… >
< http://www.library.upe..>
<macOSX>
<safari2.0.4>
</ENVIRONMENTAL>
<CLIENT>
<LIB>
<admin>
<staff>
</CLIENT>
<LIBRARY PRGRM>
<urs>
<olson>
<5035>
<colldev>
</LIBRARY PRGRM>
<CONTENT>
<psycinfo>
<CSA>
<1017-7041>
<1901-3425>
<1452845903>
< http://www.csa… >
<sfx_id>
</CONTENT>
Building Frameworks of Organizational Intelligence
55
158
13
89
20
3
4
13
5
5
3
17
27
34
0
4
450
2.08%
59
6
228
7
17
0
0
31
2
0
45
2
0
0
20
0
417
1.93%
45
5
26
11
249
0
0
8
0
0
13
3
0
2
1
1
364
1.68%
249
68
4
8
0
4
7
0
4
4
0
0
0
0
0
0
348
1.61%
161
9
68
0
15
0
0
38
6
0
17
0
0
0
9
0
323
1.49%
42
2
177
0
12
1
0
34
0
0
19
0
0
0
2
0
289
1.34%
nt
rc
e
Pe
To
ta
l
C
O
M
ED
U
M
N
W
R
K
SO
C
TA
L
21,634 article views]
D
EN
R
TN
H
W
SH
um
VE
T
251
54
27
7
0
69
6
0
10
3
1
1
0
0
0
0
429
1.98%
SA
R
340
61
124
21
38
11
12
26
6
1
17
9
0
0
5
2
673
3.11%
N
304
334
39
49
11
131
50
14
34
38
1
23
25
10
1
27
1,091
5.04%
EN
G
S
R
1,736
195
87
10
50
16
4
8
21
2
5
1
0
0
0
0
2,135
9.87%
SA
SSS
ci
11,101
2,193
323
437
101
202
288
54
130
107
20
21
3
9
6
4
14,999
69.33%
SA
SSc
i
Health Science
Chemistry
Arts & Humanities
Engineering
Business & Econ
Agriculture
Library & Info Sci
Physics
Enivronmental Sci
Life Science
Social Sciences
Info Tech
Material Science
Math Science
Law
Earth Science
N
U
M
ED
Faculty Use of Electronic Journals: School by Journal Topic
55
14,398 66.55%
0
3,085 14.26%
29
1,145
5.29%
0
639
2.95%
12
525
2.43%
0
437
2.02%
0
371
1.71%
12
238
1.10%
2
220
1.02%
0
160
0.74%
6
147
0.68%
0
77
0.36%
0
55
0.25%
0
55
0.25%
0
44
0.20%
0
38
0.18%
116
21,634 100.00%
0.54% 100.00%
Building Frameworks of Organizational Intelligence
Faculty Use of Electronic Journals: School by Journal Topic – Aggregated [21,634 article views]
Subjects
Faculties
Science
Science
Social Sci Humanities
94.5%
51.8%
27.2%
Social Sci
3.0%
24.2%
15.0%
Humanities
2.5%
24.0%
57.9%
100.0%
100.0%
100.0%
Building Frameworks of Organizational Intelligence
Faculty Use of Electronic Journals: Correlation by School
MED
NURS ENGRNG
WHRTN
EDUCN SOC WRK
DENTAL
[pearson r | 21,634 article views]
VET
COMMN SAS-HUM SAS-SSci
MED
1.000
NURS
0.995
1.000
ENGRNG
0.337
0.258
1.000
WHRTN
0.082
0.114
-0.011
1.000
EDUCN
0.142
0.178
-0.088
0.084
1.000
SOC WRK
0.884
0.910
0.113
0.155
0.532
1.000
DENTAL
0.997
0.985
0.393
0.066
0.120
0.863
1.000
VET
0.965
0.961
0.291
0.044
0.184
0.861
0.962
1.000
COMMN
0.829
0.863
0.060
0.272
0.604
0.986
0.802
0.810
1.000
SAS-HUM
0.152
0.189
-0.085
0.082
0.991
0.535
0.131
0.190
0.603
1.000
SAS-SSci
0.943
0.953
0.267
0.173
0.455
0.972
0.931
0.924
0.954
0.462
1.000
SAS-SCI
0.745
0.687
0.722
-0.052
0.020
0.521
0.789
0.783
0.448
0.018
0.661
SAS-SCI
1.000
Building Frameworks of Organizational Intelligence
Faculty Use of Electronic Journals: Multi-Dimensional Scaling Model
Derived Stimulus Configuration
Euclidean distance model
SAS_HUM
1.0
EDUCATION
SOCIAL_WORK
ANBERG
0.5
Dimension 2
SAS_SS
VET NURSING
MEDICAL
0.0
DENTAL
WHARTON
-0.5
SAS_SCI
-1.0
-1.5
ENGINEERING
-2.0
-2
-1
0
Dimension 1
1
Building Frameworks of Organizational Intelligence
Consortial Borrowing Activity:
Class PN1993-1999, Motion Pictures 2002-2007
2000
1800
Count of Requests
1600
1400
1200
1000
800
600
400
200
0
2002
2003
2004
2005
2006
2007
Building Frameworks of Organizational Intelligence
Consortial Borrowing Activity:
Class PN1993-1999, Motion Pictures [7,512 requests, 1999-Dec 2008]
100%
90%
80%
of Request
PctRequests
70%
60%
50%
40%
20% of titles account for nearly 50% of requests
30%
20%
10%
0%
0%
10%
20%
30%
40%
50%
Pct ofTitles
Titles
60%
70%
80%
90%
100%
Building Frameworks of Organizational Intelligence
The Emergence of
Cinematic Time
PN1995.5 T55 D63 2002
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
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.
Building Frameworks of Organizational Intelligence
Questions?
Joe Zucca
[email protected]
215-573-4643
University of Pennsylvania Library
Office of Planning and Communication