Database: Creating a Database for APAC

I created a database with information about published columns from the Agricultural Policy Analysis Center (APAC).  By establishing controlled vocabulary, and assigning keywords to each column, I developed a database that allows the staff at APAC to access their information, which is an example of Information Organization.

I talked with the authors to establish needs, priorities, and did a rough gap analysis. While conducting the reference interview, I identified a win-win situation whereby I could fulfill a project for a class, and create a usable product in real life, and create a database for the first time. A competency linked example would be the controlled vocabulary that is industry specific

The APAC,  based out of the University of Tennessee Institute of Agriculture strives to present “critical knowledge and policy analysis to help you understand the consequences of agricultural policies and economic conditions”. Since July of 2000 the APAC  publishes weekly columns on the spectrum of important agricultural topics.

These individual columns are published to educate stakeholders, first and foremost, farmers, but also policy makers, market analysts and economic players in the agricultural world.  By tracking the overarching themes, we can discern patterns in each of the topics covered in the columns, like the farm bills, climate, production agriculture, economics, land use trends, global and national markets. These themes, gathered together to show the data trends, will further assist farmers in future decisions. The data already tracked are massive; organizing the data illuminates those themes. Additionally, since the columns are ongoing, this database will allow the authors to continuously update the database for an evergreen resource. This is an example of liaison librarianship.

Competencies: Specialized Subject KnowledgeEmotional Intelligence