Managing Data for Maximum Utility

1
Managing Data for Maximum Utility From Tables and
Spreadsheets to Relational Databases and XML
Caryn Anderson Simmons College Boston, MA - 22
April 2006
2
Managing Data for Maximum Utility

• What are Data?
• What matters when managing Data?
• What tools can you use?
• Where can you learn more?

3
Managing Data for Maximum Utility

• What are Data?
• What matters when managing Data?
• What tools can you use?
• Where can you learn more?

• Data, Information, Knowledge, Intelligence
• Data personality
• Data Evolution Continuum

• People
• Preservation

• Tables
• Spreadsheets
• Relational Databases
• XML

• Tools
• Information Visualization

4
Managing Data for Maximum Utility
What are Data?
Data, Information, Knowledge
Intelligence What are the distinctions?
5
Managing Data for Maximum Utility
What are Data?
Data, Information, Knowledge
Intelligence Dictionaries define data as
factual information (measurements or statistics)
used as a basis for reasoning, discussion, or
calculation information as the communication
or reception of knowledge or intelligence
knowledge as the condition of knowing something
gained through experience or the condition of
apprehending truth or fact through reasoning, and
intelligence as the ability to understand and
to apply knowledge. (Bouthillier
Shearer, 2002)
6
Managing Data for Maximum Utility
What are Data?
Data, Information, Knowledge
Intelligence Knowledge differs from
information in that it is predictive and can be
used to guide action while information merely is
data in context. For example, if the raw data
is 10 degrees, then information would be it is
10 degrees outside, and the knowledge would be
that 10 degrees is cold and one must dress
warmly. In other words, knowledge is closer to
action while information could be seen as
documentation of any of pieces of knowledge.
(Bouthillier Shearer, 2002)
Bouthillier, F., and Shearer, K. (2002,
October). Understanding knowledge management and
information management the need for an empirical
perspective. Information Research. 8(1).
Retrieved April 17, 2006, from Information
Research Web site http//informationr.net/ir/8-1/
paper141.html
7
Managing Data for Maximum Utility
What are Data?

• Data Personality
• type text, numbers, digital objects?
• context financial, scientific, personnel,
  health, inventory, operational, scheduling,
  reference, assessment,
• confidentiality choice, law,
• volume small, large, potential for growth,

8
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation

• types
• source info
• confidentiality
• clean or dirty

9
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation Storage

• types
• source info
• confidentiality
• clean or dirty

• space
• formats
• metadata
• deposit/input
• updates

10
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation Storage Interaction

• types
• source info
• confidentiality
• clean or dirty

• space
• formats
• metadata
• deposit/input
• updates

• sharing
• context
• analysis
• meaning
• more data

11
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation Storage Interaction
Presentation

• types
• source info
• confidentiality
• clean or dirty

• space
• formats
• metadata
• deposit/input
• updates

• sharing
• context
• analysis
• meaning
• more data

• summative
• predictive
• dynamic

12
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation Storage Interaction
Presentation
Data Information
Knowledge
measurements statistics facts
add context meaning
summarize predict help decisions spur action
13
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
often an iterative process
Generation Storage Interaction
Presentation
Data Information
Knowledge
measurements statistics facts
add context meaning
summarize predict help decisions spur action
14
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
frequently requiring more data and/or more
analysis
Generation Storage Interaction
Presentation
Data Information
Knowledge
measurements statistics facts
add context meaning
summarize predict help decisions spur action
15
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation Storage Interaction
Presentation
Data Information
Knowledge
measurements statistics facts
add context meaning
summarize predict help decisions spur action
16
Managing Data for Maximum Utility
What matters when managing Data?

• Frequently, poor data management decisions are
  the result of the exclusive consideration of
• the types of data involved, and
• the tools that the person responsible is
  familiar with.
• When the only tool you have is a hammer,
• you tend to treat everything as if it were a
  nail.
• Abraham Maslow

17
Managing Data for Maximum Utility
What matters when managing Data?

• Two most important factors
• People
• Data should be easy to engage with and easy to
  understand by everyone that encounters it.
• Preservation
• The security, privacy and integrity risks
  increase as the handling of data increases.

18
Managing Data for Maximum Utility
What matters when managing Data?

• People
• Who will enter/interact/view the data?
• affiliation
• level of personal investment
• intellectual competence
• technical competence
• What will they do with it?
• record
• analyze
• make decisions
• How will they access it?
• information retrieval
• information visualization

19
Managing Data for Maximum Utility
What matters when managing Data?

• Preservation
• What are the data personalities?
• type
• context
• confidentiality
• volume
• Where do they hang out?
• home
• work/play
• wandering
• When is there the greatest risk?
• risk areas
• legal obligations
• risk agents

20
Managing Data for Maximum Utility
What tools can you use?

• Tables
• Tables 101
• Pros
• Cons
• Examples
• OVDLT Literature Review
• MLIP Cohort Meeting Schedule
• Leadership Model

21
Managing Data for Maximum Utility
What tools can you use?

• Tables
• Pros
• easy to learn and use in word documents
• reasonable control of presentation
• some sorting allowed
• good for one-time only, non-duplicating,
  non-interacting data
• Cons
• duplication of data
• no calculations
• no re-use of data easily
• only simple alignment
• other

22
Managing Data for Maximum Utility
What tools can you use?
Tables Examples OVDLT - Open Video Digital
Library Toolkit Literature Review MLIP -
Managerial Leadership in the Information
Professions Cohort Meeting Schedule MLIP
Leadership Model
23
Managing Data for Maximum Utility
What tools can you use?

• Spreadsheets
• Spreadsheets 101
• Pros
• Cons
• Examples
• NEASIST Registration
• Simmons ERM
• JMA reports

24
Managing Data for Maximum Utility
What tools can you use?

• Spreadsheets
• Pros
• best for numbers and currency
• sophisticated sorting and calculating
• visualization of information (charts)
• can feed mail merge with word documents
• Cons
• duplication of data for multi-faceted
  relationships
• selection of portions of data complicated
• re-use of data requires complex, error-prone,
  manual formulation
• formulas contained within discrete cells no
  calculation on the fly
• other

25
Managing Data for Maximum Utility
What tools can you use?
Spreadsheets Examples NEASIST - New
England chapter of the American Society of
Information Science Technology Event
Registration Simmons ERM - Electronic Resource
Management JMA - John More Association
Reports
26
Managing Data for Maximum Utility
What tools can you use?

• Relational Databases
• Databases 101
• Pros
• Cons
• Examples
• I2S Network (Access)
• ERUS (and ERMI guidelines)
• Open Video
• Backpackit
• del.icio.us
• blogs

27
Managing Data for Maximum Utility
What tools can you use?

• Database Development
• Clarify
• Visualize
• Specify
• Build
• Test
• Adjust

28
Managing Data for Maximum Utility
What tools can you use?

• Database Development
• Clarify your thinking about data and user
  scenarios
• Visualize the relationships between the entities
• Specify the details of the entities and
  relationships
• Build the database according to specifications
• Test the database against user scenarios
• Adjust the structure, editing or reports
  functions

29
Managing Data for Maximum Utility
What tools can you use?

• Clarify
• Introduction / History
• Collection Description
• Users
• User Activities (Needs)
• User Personas with specific use scenarios

30
Managing Data for Maximum Utility
What tools can you use?

• Visualize
• Entities
• attributes
• Relationships
• one to one
• one to many
• many to many
• recursive

31
Managing Data for Maximum Utility
What tools can you use?

• Specify
• Data Dictionary
• Relational Schema
• Attributes
• Relationships

32
Managing Data for Maximum Utility
What tools can you use?

• Build
• Select a data management tool
• Build according to specs
• Test
• Test database against user scenarios
• Adjust
• Adjust structures, interfaces and/or reporting
  functions

33
Managing Data for Maximum Utility
What tools can you use?

• Relational Databases
• Pros
• handles complex multi-faceted relationships
• analysis easily customized
• easy selection of sub-groups of data
• scalable for large amounts of data
• accessible from web interfaces (though with some
  work)
• Cons
• learning curve steeper than for tables and
  spreadsheets
• difficult to see all data at a glance
• if not web-accessible, partners must have same
  application
• other

34
Managing Data for Maximum Utility
What tools can you use?
Relational Databases Examples I2S -
Integration and Information Sciences Network
(Access) ERUS - Electronic Resource Usage
Statistics Open Video Backpackit del.icio.us
Blogs
35
Managing Data for Maximum Utility
What tools can you use?

• XML
• XML 101
• Pros
• Cons
• Examples
• OAI PMH
• EAD / MODS
• ICISC RSS
• SUSHI
• Bloglines

36
Managing Data for Maximum Utility
What tools can you use?
The Display of the Document
My First XML Chapter 1 Introduction to XML
What is HTML? What is XML? Chapter 2 XML
Syntax Elements must have a closing tag
Elements must be properly nested
original slide content courtesy of Shaoping Moss
37
Managing Data for Maximum Utility
What tools can you use?
An HTML Document An HTML document describes the
book
lth1gtMy First XMLlt/h1gt lth2gtIntroduction to
XMLlt/h2gt ltpgtWhat is HTML?lt/pgt ltpgtWhat is
XML?lt/pgt lth2gtXML Syntaxlt/h2gt ltpgtElements must
have a closing tag.lt/pgt ltpgtElements must be
properly nested.lt/pgt
original slide content courtesy of Shaoping Moss
38
Managing Data for Maximum Utility
What tools can you use?
An XML Document An XML document describes the
book
ltbookgt lttitlegtMy First XMLlt/titlegt
ltchaptergtIntroduction to XML ltparagtWhat is
HTML?lt/paragt ltparagtWhat is XML?lt/paragt
lt/chaptergt ltchaptergtXML Syntax
ltparagtElements must have a closing tag.lt/paragt
ltparagtElements must be properly
nested.lt/paragt lt/chaptergt lt/bookgt
original slide content courtesy of Shaoping Moss
39
Managing Data for Maximum Utility
What tools can you use?
HTML Elements/Tags An HTML document describes
the book
lth1gtMy First XMLlt/h1gt lth2gtIntroduction to
XMLlt/h2gt ltpgtWhat is HTML?lt/pgt ltpgtWhat is
XML?lt/pgt lth2gtXML Syntaxlt/h2gt ltpgtElements must
have a closing tag.lt/pgt ltpgtElements must be
properly nested.lt/pgt

• Are
• defined by HTML standard
• always the same
• can be used in any order

original slide content courtesy of Shaoping Moss
40
Managing Data for Maximum Utility
What tools can you use?
XML Elements/Tags An XML document describes the
book
ltbookgt lttitlegt My First XMLlt/titlegt
ltchaptergt Introduction to XML ltparagt What
is HTML?lt/paragt ltparagt What is XML?
lt/paragt lt/chaptergt ltchaptergt XML
Syntax ltparagt Elements must have a closing
tag. lt/paragt ltparagt Elements must be
properly nested. lt/paragt lt/chaptergt lt/bookgt

• Are
• defined by user/groups (DTD/Schema)
• different for each DTD/Schema
• hierarchical (tree structure)

original slide content courtesy of Shaoping Moss
41
Managing Data for Maximum Utility
What tools can you use?
XML is flexible and extensible An XML document
describes the book for a different user group
ltmanuscriptgt ltnamegt My First XML lt/namegt
ltpartgt Introduction to XML ltsectiongt What
is HTML? lt/sectiongt ltsectiongt What is XML?
lt/sectiongt lt/partgt ltpartgt XML
Syntax ltsectiongt Element Rules lt/sectiongt
ltparagt Elements must have a closing tag.
lt/paragt ltparagt Elements must be properly
nested. lt/paragt lt/partgt lt/manuscriptgt
Instead of book
Extend to accommodate greater detail of part
section AND paragraph
original slide content courtesy of Shaoping Moss
42
Managing Data for Maximum Utility
What tools can you use?
Differences between HTML and XML XML is not a
replacement for HTML. XML and HTML were designed
with different goals. - XML was designed to
describe data and to focus on what data is. -
HTML was designed to display data and to focus on
how data looks. HTML structure and tags are very
loose while XML structure and tags are strict -
XML documents must be well-formed. - XML
elements must be properly nested. - All XML
elements must be closed. - Tag names must be
case consistent.
original slide content courtesy of Shaoping Moss
43
Managing Data for Maximum Utility
What tools can you use?
Differences HTML
XML

Content Format Selection Organization

• Held in specific containers that describe what
  the data is (ltbookgt, ltchaptergt, etc.)
• -XSLT files define the formats of each section
  (i.e. font, color, size, etc.)
• -multiple XSLTs for same XML
• -XSLT selects and determines order of display of
  content
• Multiple XSLTs for same XML (one to produce just
  book title list, one to display full text, one
  for citations, etc.)

• - Held in generic containers (lth1gt, ltpgt, etc.)
• In the default format of the content tag OR
• As defined by a Cascading Style Sheet (internal
  or external)
• -All content always included (no option to easily
  select or suppress content must manually change
  document)
• Content only displayed in the order written (to
  change order you must manually change document

original slide content courtesy of Shaoping Moss
44
Managing Data for Maximum Utility
What tools can you use?
Differences HTML
XML

Analogy What you can get
Address List in plain WORD document One
document of your list of contacts with all the
information that you have for each person in the
order you typed it.

• Address List in database or MAIL MERGE data file
• Friends Family with full addresses for Holiday
  cards
• E-mail list of just Professional contacts for
  announcing new product
• Special formatting of whole list for better
  display on PDA
• Etc. etc. etc. all from SAME XML document

original slide content courtesy of Shaoping Moss
45
Managing Data for Maximum Utility
What tools can you use?

• How to Build an XML file family
• Establish the Document Type Definition (DTD) or
  Schema
• Write a well-formed XML document that holds
  your data in the containers established by your
  DTD/Schema
• Validate your XML document to make sure you
  conformed to your DTD/Schema
• Build as many different XSL documents as you
  need to select data from your XML file, organize
  it the way you want it to appear, and format it
  so it looks the way you want.
• Now you can link your XML file to whatever XSL
  you want
• to get the kind of display you want at any given
  time.

original slide content courtesy of Shaoping Moss
46
Managing Data for Maximum Utility
What tools can you use?
The XML family unit of files and languages
http//www.mysite.org/myfile.xml WEB PAGE
5. Displays content to browser
1. Calls the .xml file
Uses HTML for formatting
XML Where the data is held
XSL Instructions for using XML data and
displaying it
2. Calls .xsl for display instructions
Uses XSLT to select data from .xml file and
format it
DTD or Schema The organizational chart for the
data
3. Looks in .xml for content
Uses XSL-PATH to access certain spots in the .xml
file
File type .xml
File type .xsl
4. Returns content to .xsl
Uses XSL-FO for specifying formatting semantics
(?)
File types .dtd .xml (schemas)
For validation during creation
Languages used in XSLT documents during creation
47
Managing Data for Maximum Utility
What tools can you use?
The DTD or Schema
means there can be as many of this element as
you want
lt!ELEMENT booklist (book)gt lt!ELEMENT book
(booktitle,author,country,publisher,price,year)gt
lt!ELEMENT booktitle(PCDATA) lt!ELEMENT
author(PCDATA)gt lt!ELEMENT country(PCDATA)gt lt!ELE
MENT publisher(PCDATA)gt lt!ELEMENT
price(PCDATA)gt lt!ELEMENT year(PCDATA)gt
The DTD establishes the hierarchy of
elements/tags.
original slide content courtesy of Shaoping Moss
48
Managing Data for Maximum Utility
What tools can you use?
The XML Document
lt?xml version"1.0" encoding"UTF-8" ?gt lt!DOCTYPE
list SYSTEM "dtdforbooklist.dtd"gt lt?xml-stylesheet
type"text/xsl" href"xslforbooklist.xsl"?gt ltbook
listgt ltbookgt ltbooktitlegtHTML and XHTMLthe
Definitive Guidelt/booktitlegt ltauthorgtChuck
Muscianolt/authorgt ltauthorgtBill
Kennedylt/authorgt ltcountrygtUSAlt/countrygt ltpubli
shergtO Reillylt/publishergt ltpricegt19.95lt/pricegt
ltyeargt2000lt/yeargt lt/bookgt ltbookgt ltbooktitlegt
XHTML 1.0 Language Sourcebooklt/booktitlegt ltautho
rgtIan S. Grahamlt/authorgt ltcountrygtUSAlt/countrygt
ltpublishergtJohn Wiley and Sonslt/publishergt ltpr
icegt30.00lt/pricegt ltyeargt2000lt/yeargt lt/bookgt lt/b
ooklistgt
This is what DTD is being used.
This is what XSL is being used.
original slide content courtesy of Shaoping Moss
49
Managing Data for Maximum Utility
What tools can you use?
Validate your XML file Upload your XML file to
this validator http//www.stg.brown.edu/service/x
mlvalid/ You will either need to place your
DTD on a web server so that the validator can
find it (and put the right URL in the header of
the XML), or you can put the DTD lines inside of
your XML file (at the top). The validation
service has a FAQ, but if you are getting stuck,
it might be a good time for some remedial XML at
the 3W Schools http//www.w3schools.com/
50
Managing Data for Maximum Utility
What tools can you use?
The XSL Document
lt?xml version"1.0" encoding"UTF-8"?gt ltxslstyles
heet xmlnsxsl"http//www.w3.org/1999/XSL/Transfo
rm" version"1.0"gt ltxsltemplate
match"/"gt lthtmlgt ltbodygt lth1gtMy Book
Collectionlt/h1gt lttable border"1"gt lttr
bgcolor"9acd32"gt ltthgtTitlelt/thgt
ltthgtAuthorlt/thgt ltthgtPublisherlt/thgt
ltthgtCountrylt/thgt ltthgtPricelt/thgt
lt/trgt ltxslfor-each select"booklist/book"gt ltxsls
ort select"publisher"/gt ltxslif
test"yeargt1995"gt lttrgt lttdgtltxslvalue-of
select"booktitle"/gtlt/tdgt lttdgtltxslvalue-of
select"author"/gtlt/tdgt lttdgtltxslvalue-of
select"publisher"/gtlt/tdgt lttdgtltxslvalue-of
select"country"/gtlt/tdgt lttdgtltxslvalue-of
select"price"/gtlt/tdgt lt/trgt lt/xslifgt lt/xslfor-
eachgt lt/tablegt lt/bodygt lt/htmlgt lt/xsltemplategt lt/x
slstylesheetgt
xsltemplate is XSLT for use the template
below
match is X-PATH for link to or start with
and / means the root element (booklist in
this case)
This is basic HTML for the template
xslfor-each with the select instruction is
XSLT for select from each of the books in the
booklist
xslsort with the select instruction is XSLT
for sort by publisher
xslif with the test instruction is XSLT for
only those books when the year is later than
1995
xslvalue-of with the select instruction is
XSLT for use the data from this element
You must close your XSLT commands
You must close the HTML tags of your template
51
Managing Data for Maximum Utility
What tools can you use?
The Web Page
original slide content courtesy of Shaoping Moss
52
Managing Data for Maximum Utility
What tools can you use?

• DONE! not so hard
• Logical
• Flexible
• Extensible
• Interoperable!!

original slide content courtesy of Shaoping Moss
53
Managing Data for Maximum Utility
What tools can you use?

• XML
• Pros
• enables easy sharing (particularly over http)
  platform independent
• enables customized presentation
• highly structured for easy translation data
  definitions included
• highly customizable within structure
• easy selection within subsets
• Cons
• calculations and analysis can be complicated
• steep learning curve
• parameters extremely strict (closing tags)
• requires translation by sharing partner
• other

54
Managing Data for Maximum Utility
What tools can you use?
XML Examples OAI PMH Open Archives
Initiative Protocol for Metadata Harvesting EAD
/ MODS Encoded Archival Description / Metadata
Object Description Schema ICISC RSS
International Calendar of Information Science
Conferences RSS feed SUSHI Standardized Usage
Statistics Harvesting Initiative Bloglines
55
Managing Data for Maximum Utility
What tools can you use?

• Want to try some RSS?
• XML without the DTDs or XSLs
• Easy way to broadcast news information
• Build an XML file, place on web server
• Use javascript RSS converters to quickly
  repurpose your own feed as content on your HTML
  web page.

original slide content courtesy of Shaoping Moss
56
Managing Data for Maximum Utility
What tools can you use?
RSS Build the .xml file
lt?xml version"1.0" ?gt ltrss version"2.0"gt ltchanne
lgt lttitlegtInternational Calendar of Information
Science Conferenceslt/titlegt ltdescriptiongtA
collaboration between the International
Information Issues SIG and the European and New
England chapters of ASISampT (American Society
for Information Science and Technology) this
master calendar of relevant conferences is
offered to help connect and support like-minded
professionals working on information problems
around the world.lt/descriptiongt ltlinkgthttp//icisc
.neasist.org/lt/linkgt ltitemgt lttitlegtConferences
Added - Weeks Ending 7 April 2006lt/titlegt ltdescrip
tiongt lt!CDATA ltpgtSeptember 2006lt/pgt ltulgt ltligtlta
href"http//www.icwe.net/icde22/english/exhibiti
on.htm" target"blank"gt(3-6 September 2006)
BRASIL, Rio de Janeiro 22a. Conferencia Mundial
de educacao a distincia do ICDE 22nd ICDE World
conference on Distance Education
lt/agtlt/ligt ltligtlta href"http//www.ascleiden.nl/Get
Page.aspx?url/events/event1142937906"
target"blank"gt(6-8 September 2006) NETHERLANDS,
Leiden Bridging the North-South Divide in
Scholarly Communication on Africa
lt/agtlt/ligt ltligtlta href"http//www.distant-learning
.net/index.shtml" target"blank"gt(11-13 September
2006) EGYPT, Cairo 5th International Internet
Education Conference and Exhibition
lt/agtlt/ligt ltligtlta href"http//www.hmlibrary.ac.in/
" target"blank"gt(18-22 September 2006) INDIA,
Vadodara Digital Libraries lt/agtlt/ligt lt/ulgt gt lt
/descriptiongt ltlinkgthttp//icisc.neasist.org/quick
calendar.htmlmonthlt/linkgt lt/itemgt lt/channelgt lt/r
ssgt
By declaring the RSS version, you dont need a
DTD or XSL.
Open the channel of communication.
Title of your feed.
Describe your feed.
Link to your web page.
Title of your entry.
If you dont use these tags, none of the HTML
formatting inside will work (p, ul, strong, etc.)
Direct link to this item on your web page.
Always close your tags!
57
Managing Data for Maximum Utility
What tools can you use?
RSS Making, Subscribing, Repurposing Some
quick tutorials to get yourself going with RSS
fast Sullivan, Danny. (2003). Making an RSS
Feed. SearchEngineWatch http//searchenginewatch
.com/sereport/article.php/2175271 Subscribing to
RSS Feeds with feed readers or browsers
http//icisc.neasist.org/rssinstructions.html
Use RSSExpress Lite to create javascript for
the feed you want to use on your HTML page
http//rssxpress.ukoln.ac.uk/lite/include/ See
the .xml file from the previous slide (the most
current version) http//icisc.neasist.org/iciscfe
ed.xml See the .xml from the previous slide
repurposed on an HTML page http//www.utip.info/g
sliscedata.html
58
Managing Data for Maximum Utility
EXAMPLES

• Now lets try it with your data!
• Discussion
• Problem-Solving
• Database Development
• Questions

59
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation Storage Interaction
Presentation

• types
• source info
• confidentiality
• clean or dirty

• space
• formats
• metadata
• deposit/input
• updates

• sharing
• context
• analysis
• meaning
• more data

• summative
• predictive
• dynamic

60
Managing Data for Maximum Utility
What are Data?
Data Evolution Continuum
Generation Storage Interaction
Presentation
Data Information
Knowledge
measurements statistics facts
add context meaning
summarize predict help decisions spur action
61
Managing Data for Maximum Utility
What matters when managing Data?

• People
• Who will enter/interact/view the data?
• affiliation
• level of personal investment
• intellectual competence
• technical competence
• What will they do with it?
• record
• analyze
• make decisions
• How will they access it?
• information retrieval
• information visualization

62
Managing Data for Maximum Utility
What matters when managing Data?

• Preservation
• What are the data personalities?
• type
• context
• confidentiality
• volume
• Where do they hang out?
• home
• work/play
• wandering
• When is there the greatest risk?
• risk areas
• legal obligations
• risk agents

63
Managing Data for Maximum Utility
Where can you learn more?
Tools Spreadsheets Nelson, Stephen L. (2002).
Excel Data Analysis for Dummies. For Dummies
http//www.dummies.com/WileyCDA/DummiesTitle/produ
ctCd-0764516612.html Relational
Databases Greenspan, Jay. Your First Database.
Webmonkey.com. http//www.webmonkey.com/webmonkey
/backend/tutorials/tutorial3.html Merrall,
Graeme. MySQL/PHP tutorial. Webmonkey.com.
http//www.webmonkey.com/webmonkey/programming/php
/tutorials/tutorial4.html Publicly Available
Database applications. Association for Computing
Machinery (SIG MOD - Mgt. of Data).
http//www.sigmod.org/databaseSoftware/
Hernandez, Michael J. (2003). Database Design
for Mere Mortals A Hands-on Guides to Relational
Database Design. Reading, MA AddisonWesley.
64
Managing Data for Maximum Utility
Where can you learn more?
Tools Relational Databases (Examples ERUS
http//focus.ischool.utexas.edu/projects/erus/
Backpackit http//www.backpackit.com Open
Video http//www.openvideo.org del.icio.us
http//del.icio.us Bloglines
http//www.bloglines.com
65
Managing Data for Maximum Utility
Where can you learn more?
Tools XML W3 Schools tutorials on all kinds
of web-based languages and tools from the World
Wide Web Consortium http//www.w3schools.com/
Library of Congress standards descriptions
and DTDs for MARCXML, MODS, MADS, EAD, etc.
http//www.loc.gov/standards/ (FYI this stuff
is a little hard to wade through find what you
need. Look for tag library in EAD and elements
and attributes in MODS to get a sense of what
the tags are) OAI-PMH tutorial and
introduction from the Open Archives Initiative
http//www.oaforum.org/tutorial/index.php SUSHI
(http//www.niso.org/committees/SUSHI/SUSHI_comm.h
tml) ViDe Users Guide Dublin Core Application
Profile for Digital Video video specific, but
good XML examples http//www.vide.net/workgroups/
videoaccess/resources/vide_dc_userguide_20010909.p
df
66
Managing Data for Maximum Utility
Where can you learn more?
Tools RSS Sullivan, Danny. (2003). Making an
RSS Feed. SearchEngineWatch http//searchenginew
atch.com/sereport/article.php/2175271 Subscribing
to RSS Feeds with feed readers or browsers
http//icisc.neasist.org/rssinstructions.html
Use RSSExpress Lite to create javascript for
the feed you want to use on your HTML page
http//rssxpress.ukoln.ac.uk/lite/include/

67
Managing Data for Maximum Utility
Where can you learn more?
Information Visualization Wikipedia good
overview of areas and some good references
http//en.wikipedia.org/wiki/Information_visualiz
ation Edward Tufte site includes a variety of
topical forums http//www.edwardtufte.com/tufte/
Sparkline Wiki PHP library Examples of use on
the web http//sparkline.wikispaces.com/Examples
GIS - http//www.gis.com/ iDashboards
http//www.oracle.com/technology/partners/pdf/iDas
hboards204.020Whitepaper.pdf OLIVE On-Line
Library of Information Visualization Environments
taxonomy of information visualization
summarizing work of Rob Schneiderman and others
http//www.otal.umd.edu/Olive/
68
Managing Data for Maximum Utility
Where can you learn more?
Other Reber, Elaine. Creating Confidentiality
Agreements that Protect Data and Privacy The
Challenge of Keeping up With Changes in State and
Federal Regulations (PPS) http//www.educause.ed
u/ir/library/powerpoint/SPC0551.pps
69
Managing Data for Maximum Utility
Contact Information Caryn Anderson Program
Coordinator Ph.D./Managerial Leadership in the
Information Professions Simmons College GSLIS 300
The Fenway Boston, MA 02115 617.521.2829 caryn.an
derson_at_simmons.edu