slide1 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Building Frameworks of Organizational Intelligence Joe Zucca Director for Planning and Communication University PowerPoint Presentation
Download Presentation
Building Frameworks of Organizational Intelligence Joe Zucca Director for Planning and Communication University

Loading in 2 Seconds...

play fullscreen
1 / 34

Building Frameworks of Organizational Intelligence Joe Zucca Director for Planning and Communication University - PowerPoint PPT Presentation


  • 96 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Building Frameworks of Organizational Intelligence Joe Zucca Director for Planning and Communication University' - lexi


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Building Frameworks of Organizational Intelligence

Joe Zucca

Director for Planning and Communication

University of Pennsylvania Libraries

slide2

Building Frameworks of Organizational Intelligence

Sample Data Structure I: Data Farm Funds Report - Biology

slide3

Building Frameworks of Organizational Intelligence

Sample Data Structure I: Data Farm Funds Report - Casalini Libri

slide4

Building Frameworks of Organizational Intelligence

Sample Data Structure II - Data Farm Table - Funds Process

slide5

Building Frameworks of Organizational Intelligence

bib_text

invoice

bib_

master

Sample Data Structure III - Voyager Funds Schema

invoice_

status

Invoice_

line_item

line_item

purchase_

order

fund

invoice_

line_item

_funds

vendor

slide6

Service Environment

Information Loop

Inform

ERED

Catalog

Data Farm

Environment

Funds

SFX | ERM?

Integrate

Report Builder

DYNIX

BorrowDirect

Circulation

WEB

Apache

ezproxy

Ref|Instruct

Dashboard

Data Streams

Data Bureau

Clean | Anonymize

Normalize

People and

Network Data

Building Frameworks of Organizational Intelligence

Working with data structures

slide7

E-Resource Use

Resolve Resource

Resolve People

Resolve Places

Digital Library

Voyager-Supported Services

Building Use

Staff Census

Reference & Instruction (dynamic)

Resolution Services

LDAP

Administration

Building Frameworks of Organizational Intelligence

Data Farm Oracle Space-Overview

30+ gb, in 162 tables, for collecting and disseminating management info

Circulation

Reference Contact

Web Analytics

Acquisitions Funds

Image Collection Use

Holdings

Consortia ILL/DocDel

Tech Processing Workflow

70-Member ILL Coop.

Copier | Printer Use

Gate Swipes

slide8

ERED

Catalog

Funds

SFX | ERM?

DYNIX

BorrowDirect

Circulation

Building Frameworks of Organizational Intelligence

Service Environment

Data Farm Silos

WEB

Apache

ezproxy

Ref|Instruct

funds

slide9

Building Frameworks of Organizational Intelligence

A different take on a management information framework

slide10

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-80E9-85076F88F67F

slide11

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-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

slide12

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-80E9-85076F88F67F

Referring URL = library web page listing resources on Psychology (community 59) | Olson, Coordinating Bibliographer

slide13

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-80E9-85076F88F67F

zucca [Penn authentication key] = Provost cntr | LIBRARY | staff

slide14

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-80E9-85076F88F67F

SessionID 10335905=PsycInfo (resource identifier 7014)

slide15

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-80E9-85076F88F67F

sfx_session_id=Journal of Experimental Child Psychology,

“Relations Among Musical Skills, Phonological Processing and Early Reading Ability in Preschool Children.”

slide16

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-80E9-85076F88F67F

  • 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

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.
slide17

Org|Program

Staff

Unrestricted

Restricted

Library

Program

Service

Genre

Fund Code

Course

Descriptor

Level

Budget

Expnd Amt

Client

Program

Dept

Biblio-

graphic

Content

Dept

Reqmnt

School

URL

Client

Environment

School

IP-Domain

Dept

Rank

Date|Time

Campus

Location

Major

Building Frameworks of Organizational Intelligence

Events: aStructurefor Library DecisionMetrics

EVENT

slide18

ERED

Catalog

Funds

SFX | ERM?

DYNIX

BorrowDirect

Circulation

Building Frameworks of Organizational Intelligence

Service Environment

Data Farm Silos

WEB

Apache

ezproxy

Ref|Instruct

funds

slide19

ERED

Catalog

Funds

SFX | ERM?

DYNIX

BorrowDirect

Circulation

WEB

Apache

ezproxy

Ref|Instruct

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

XML

oracle

logs

perl

oracle

XL

slide20

Library

Program

Budget

Client

Program

EVENT

Content

Environment

Client

Building Frameworks of Organizational Intelligence

METRIDOC

Event Elements Articulated in an XML Schema

  • <ENVIRONMENTAL>
    • <v.domain>
    • <p.domain>
    • <date>
    • <time>
    • <session>
    • <url>
  • </ENVIRONMENTAL>
  • <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>
slide21

URL

IP-Domain

Environment

Date|Time

Campus

Location

Library

Program

Budget

Client

Program

EVENT

Content

Environment

Client

Building Frameworks of Organizational Intelligence

Building Frameworks of Organizational Intelligence

METRIDOC

Event Elements Articulated in an XML Schema

  • <ENVIRONMENTAL>
    • <v.domain>
    • <p.domain>
    • <date>
    • <time>
    • <session>
    • <url>
  • </ENVIRONMENTAL>
  • <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>
slide22

School

Dept

Client

Library

Program

Major

Budget

Rank

Client

Program

EVENT

Content

Environment

Client

Building Frameworks of Organizational Intelligence

METRIDOC

Event Elements Articulated in an XML Schema

  • <ENVIRONMENTAL>
    • <v.domain>
    • <p.domain>
    • <date>
    • <time>
    • <session>
    • <url>
  • </ENVIRONMENTAL>
  • <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>
slide23

Service Genre

Library

Program

Budget

Library

Program

Client

Program

EVENT

Org|Program

Content

Staff

Environment

Client

Building Frameworks of Organizational Intelligence

METRIDOC

Event Elements Articulated in an XML Schema

  • <ENVIRONMENTAL>
    • <v.domain>
    • <p.domain>
    • <date>
    • <time>
    • <session>
    • <url>
  • </ENVIRONMENTAL>
  • <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>
slide24

Library

Program

Budget

Client

Program

EVENT

Content

Environment

Client

Building Frameworks of Organizational Intelligence

METRIDOC

Event Elements Articulated in an XML Schema

  • <ENVIRONMENTAL>
    • <v.domain>
    • <p.domain>
    • <date>
    • <time>
    • <session>
    • <url>
  • </ENVIRONMENTAL>
  • <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>

Biblio-

graphic

Content

slide25

Building Frameworks of Organizational Intelligence

Schematic

Workflow

  • <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>

Event

schema

Data

Source

instructions

Penn

Community

Java-

based

processes

voyager

Staff db

metridoc.xml

Data Store

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

Building Frameworks of Organizational Intelligence

Consortial Borrowing Activity:

Class PN1993-1999, Motion Pictures 2002-2007

slide31

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

slide32

Building Frameworks of Organizational Intelligence

The Emergence of Cinematic Time

PN1995.5 T55 D63 2002

slide33

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.

slide34

Building Frameworks of Organizational Intelligence

Questions?

Joe Zucca

zucca@pobox.upenn.edu

215-573-4643

University of Pennsylvania Library Office of Planning and Communication