Back To Schedule
Thursday, November 3 • 2:30pm - 3:10pm
Albatross: Rolling on a Sea of Data

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

In this session we will discuss the creation of a database for the purpose of pulling together journal usage data and cost data in a central environment where the data can be queried to use in return on investment analysis. Our database is named "Albatross" referencing The Rime of the Ancient Mariner, by Samuel Taylor Coleridge, it is both an omen of good or bad luck and represents the challenges and triumphs our team experienced in development.

We will share some of the challenges encountered while designing the database structure and creating a working database from the design. We will then discuss issues related to normalizing the data and our processes for creating effective workflows. We will also discuss the skill sets of the individuals who contributed to the creation process.

In examining the design process, we will share and walk through our final entity relational diagram and the reasoning behind why it is structured as it is. We will also explore our method of automating workflows through scripting in SQL and Python. In addition, we will talk about the normalization of five years of COUNTER and non-standard journal usage data, standardizing titles, packages, publishers, and platforms.

Finally, we will discuss our plans for assessment, analysis, and visualization of data retrieved from our database. This will be a look at future plans for using LibInsight to publish and create access to this data while allowing the curated data to be further paired with other data for more in depth analysis.


Annette Bailey

Associate Director, Metadata Services, Virginia Tech
avatar for Tracy Gilmore

Tracy Gilmore

Collections Assessment Librarian, Virginia Tech
Tracy Gilmore is the Collections Assessment Librarian at Virginia Tech University Libraries. She coordinates assessment activities and strategies for developing the library’s digital collections. Her current research interests include discovery service usability, usage, and acc... Read More →
avatar for Anthony Wright de Hernandez

Anthony Wright de Hernandez

Community Collections Archivist, Virginia Tech
Anthony Wright de Hernandez is Community Collections Archivist for University Libraries at Virginia Tech. He is a member of the SAA Finance Committee. He holds an MLIS from the University of Washington iSchool. Anthony works primarily with traditionally marginalized communities to... Read More →
avatar for Leslie O'Brien

Leslie O'Brien

Director, Collections & Technical Services, Virginia Tech
Leslie has held a variety of positions within collections and technical services at Virginia Tech 20+ years. Before that, she worked in special libraries in Washington, DC. She manages collections assessment, metadata creation for the institutional repository, cataloging, interlibrary... Read More →

Thursday November 3, 2016 2:30pm - 3:10pm EDT
Cooper Room, Courtyard Marriott 125 Calhoun Street, Charleston, SC 29401