Digital Movie Poster Archive: A Relational Database From Conception to Implementation Using MySQL

Purpose: This project examines the development and implementation of a digital movie poster archive through the integration of metadata standards, controlled vocabularies, relational database architecture, and web-based information technologies. Grounded in the principles of library and information science, the project seeks to establish a systematic framework for organizing, describing, and retrieving film-related archival materials while emphasizing metadata interoperability, extensibility, and accessibility. Methods/Approach: The project employs a four-stage developmental approach encompassing metadata schema construction, thesaurus development, relational database design, and web-based data representation. A 14-element metadata schema incorporates established Schema.org properties alongside locally defined descriptive elements addressing collection-specific requirements. A controlled vocabulary establishes hierarchical, associative, and equivalence relationships among classification terms. Using MySQL, a relational database organizes five principal entities—movie posters, genre, extent, language, and type—through defined relationships and structured query operations. The final stage incorporates Hypertext Markup Language (HTML) and JavaScript Object Notation for Linked Data (JSON-LD) to demonstrate the representation of archival information within a web environment. Findings: The resulting prototype demonstrates the practical application of information organization principles through structured metadata records, relational database tables, and SQL-based retrieval operations. Sample queries illustrate the functionality of Boolean and keyword-based searching, while the accompanying web interface provides a preliminary model for presenting structured archival data. Implications: This project illustrates how established information science principles can inform the development of specialized digital collections. The integration of metadata standards, semantic relationships, and relational database technologies offers a foundational approach to archival organization and resource discovery, with potential applications in academic libraries, cultural heritage institutions, and digital repositories. Although limited to a small prototype collection, the project establishes a conceptual and technical foundation for further development and evaluation of digital archival systems.

Authors

Institutions

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-11-16
DOI
https://doi.org/10.5281/zenodo.24271847
Primary Topic
Digital and Traditional Archives Management
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

Digital Movie Poster Archive: A Relational Database From Conception to Implementation Using MySQL

Ricardo E. Johnson
Zenodo (CERN European Organization for Nuclear Research)
Digital and Traditional Archives Management
article

Digital Movie Poster Archive: A Relational Database From Conception to Implementation Using MySQL

Ricardo E. Johnson
article en

Abstract

Purpose: This project examines the development and implementation of a digital movie poster archive through the integration of metadata standards, controlled vocabularies, relational database architecture, and web-based information technologies. Grounded in the principles of library and information science, the project seeks to establish a systematic framework for organizing, describing, and retrieving film-related archival materials while emphasizing metadata interoperability, extensibility, and accessibility. Methods/Approach: The project employs a four-stage developmental approach encompassing metadata schema construction, thesaurus development, relational database design, and web-based data representation. A 14-element metadata schema incorporates established Schema.org properties alongside locally defined descriptive elements addressing collection-specific requirements. A controlled vocabulary establishes hierarchical, associative, and equivalence relationships among classification terms. Using MySQL, a relational database organizes five principal entities—movie posters, genre, extent, language, and type—through defined relationships and structured query operations. The final stage incorporates Hypertext Markup Language (HTML) and JavaScript Object Notation for Linked Data (JSON-LD) to demonstrate the representation of archival information within a web environment. Findings: The resulting prototype demonstrates the practical application of information organization principles through structured metadata records, relational database tables, and SQL-based retrieval operations. Sample queries illustrate the functionality of Boolean and keyword-based searching, while the accompanying web interface provides a preliminary model for presenting structured archival data. Implications: This project illustrates how established information science principles can inform the development of specialized digital collections. The integration of metadata standards, semantic relationships, and relational database technologies offers a foundational approach to archival organization and resource discovery, with potential applications in academic libraries, cultural heritage institutions, and digital repositories. Although limited to a small prototype collection, the project establishes a conceptual and technical foundation for further development and evaluation of digital archival systems.

Zenodo (CERN European Organization for Nuclear Research)
West Virginia University (US), University of Arizona (US)
Digital and Traditional Archives Management
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon