This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own

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

Assistant Director, Electronic Resources & Emerging Technology Services, Virginia Tech
Annette is the progenitress of the popular scholar's extension LibX (libx.org) and the new visualization of discovery code libFX (libfx.lib.vt.edu).  Is Annette a brunette Moses leading the Virginia Tech libraries into The Promised eLand or is she a modern-day Carrie Nation wreaking havoc in the saloons of print with her digital hatchet?  Yes, she is!
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 access.
avatar for Anthony Wright de Hernandez

Anthony Wright de Hernandez

Resident Librarian, Virginia Tech
Anthony Wright de Hernandez is the first resident librarian at Virginia Tech. He has over a decade of experience using and administering SQL databases. He now works primarily in Archives and Special Collections focusing on community collections. His primary research interest is on how libraries and archives can use technology to document and improve access to the histories of unique or underserved communities.

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