DESAIN BASIS DATA APLIKASI PERPUSTKAAN DIGITAL PERPUSNAS: EVALUASI STRUKTUR DAN EFISIENSI PENYIMPANAN DATA

Abstract

Digital transformation in library management has driven the need for efficient, integrated, and reliable database systems. This research aims to evaluate the database structure of the digital library application of the National Library of the Republic of Indonesia (Perpusnas) to assess storage efficiency, data integrity, and support for system scalability. Using a descriptive qualitative approach, data was collected through system documentation analysis and semi-structured interviews with Perpusnas technical staff. The study results indicate that the system uses PostgreSQL with a database structure normalized to the third standard form (3NF). However, several issues were found, including metadata duplication between physical and digital collections, slow performance of complex search queries, and limitations in applying relational constraints. These findings indicate the need for further optimization of the database structure regarding entity-relationship design, indexing, and integrity control. The recommendations are expected to support the development of a more efficient and sustainable national digital library system.