Data warehouse para el Centro de Documentación Regional "Juan Bautista Vázquez"

Abstract

The decision-making process in academic libraries is paramount; however highlycomplicated due to the large number of data sources, processes and high volumes ofdata to be analyzed. Academic libraries are accustomed to producing and gatheringa vast amount of statistics about their collection and services. Typical data sourcesinclude integrated library systems, library portals and online catalogues, and systemsof consortiums and quality surveys. Unfortunately, these heterogeneous datasources are only partially used for decision-making processes due to the wide varietyof formats, standards and technologies, as well as the lack of efficient methods ofintegration. This thesis presents the analysis, design and implement of Data Warehousefor an academic library Juan Bautista Vázquez". Firstly, an appropriatemethodology documented in a previous study is used for data collection. This methodology incorporates key elements including process analysis, quality estimation, information relevance and user interaction that may influence a library decision. Based on the above mentioned approach, this study defines a set of queries of interestto be issued against the integrated system proposed. Then, relevant data sources,formats and connectivity requirements for a particular example are identified. Next,Data Warehouse architecture is proposed to integrate, process, and store the collecteddata transparently. Eventually, the stored data are analyzed through reportingtechniques of analytical processing and prototype of Bibliomining. By doing so, thethesis provides the design of an integrated solution that assists library managers tomake tactical decisions about the optimal use and leverage of their resources and ofservices.