Performance Comparison of Storing and Retrieving for Automated Library System (ALIST) Data Logs between ORACLE and SOLR

Abstract

The purpose of this research was to compare the data log size and retrieving time between ORACLE database and SOLR database of library searching log (Online Public Access Catalog) and library circulation system log of the automated library system (ALIST). The research result found that the data size in SOLR was smaller than in ORACLE about 42 percent. Retrieving time of alphabetic criteria, date criteria and data grouping and counting (facet) with SOLR was about 75 percent small than ORACLE while retrieving time of searching with numerical criteria and single alphabetic criteria on ORACLE was smaller than SOLR approximately 30 percent.