The Percarious-Ceiling-Fan OCLC Search System

This project entails a graphical user interface to query the OCLC MARC21 data-set, allowing not only to get only the specific desired information out of a large and complex record, but also allowing for advanced search tools such as AND/OR operators, allowing for additional words to separate the words of a search string, and fuzzy matching, as well as being able to produce graphs of different aspects of the results such as graphing the number of results by the decade they were published, graphing the language distribution of results, etc. Time permitting, we may even be able to look into methods of search optimization and other higher-level problems that the unique data set provides, but these are more secondary to the main goal of creating a user friendly tool to get the desired information out of a dirty, expansive, and complicated data set. For a user trying to study this data set, access to an easy to use searching tool is imperative. It is far too expansive for any person to look over manually, and each record has an extensive amount of information about each publication, most of which is not pertinent to what a person will be looking for at any given time. By creating a tool to make accessing and using this information easier, our users will be able to perform research on this data far easier than they were able to in years past.

How to use The Precarious Ceiling Fan Search System:


The Basic Search:

Using the selection options, choose which type of graph to output and what field to query; then submit the search term (i.e "james" in author)

The Advanced Search:

ANY: Searches the selected tags for any of the strings put into this field, using OR. Separate strings with commas.

EXACT: Searches the selected tags for any of the strings put into this field, using AND. Separate strings with commas.

NONE: Exclude results in which the selected tags contain the strings in this field. Separate strings with commas.

TAGS: Select tag(s) you are searching through in the database.

YEAR range: Select the range in which to get results. Valid range is 1500-1800 given the time period of this database.

LANGUAGE: Select which languages of books to search through. Uses the MARC21 Language codes found here.

REGION: Select which regions for books to search through. Uses the MARC21 Region codes found here.


Quick Tip: Not all prompts have to be filled in advanced search!

Demo Video:


Website Images:


Homepage Advanced Options Sign in Page Saved Searches Loaded Results