https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39557
Bug ID: 39557
Summary: Normalize MARC21 XML metadata into structured MySQL
database tables via Koha Plugin
Change sponsored?: ---
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: MARC Bibliographic data support
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
The proposed plugin (Koha::Plugin::HKS3::NormalizeMARC2DB) aims to normalize
MARC21 XML metadata from the biblio_metadata.metadata table into structured
MySQL database tables. Currently, MARC21 XML is stored as a single XML blob,
making advanced querying, reporting, and integration difficult.
This plugin introduces an automatic normalization step triggered by the
after_biblio_action hook whenever metadata is added or modified. It splits MARC
XML into normalized relational tables fully supporting repeatable fields,
subfields, and indicators.
Advantages:
Significantly simplifies complex querying and reporting of MARC21 data.
Enhances data integrity and consistency.
Facilitates integration with external reporting tools, analytics, and
applications.
Improves database performance for MARC metadata queries.
Provides clear and structured access to MARC data elements.
This approach aligns with best practices for database normalization and can
substantially enhance Koha's extensibility and interoperability.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
