Open Context Database SQL Dump: Legacy Schema Tables and New Schema Tables

Описание

Open Context ( https://opencontext.org ) publishes free and open access research data for archaeology and related disciplines. An open source (but bespoke) Django (Python) application supports these data publishing services. The software repository is here: https://github.com/ekansa/open-context-py The Open Context team runs ETL (extract, transform, load) workflows to import data contributed by researchers from various source relational databases and spreadsheets. Open Context uses PostgreSQL ( https://www.postgresql.org ) relational database to manage these imported data in a graph style schema. The Open Context Python application interacts with the PostgreSQL database via the Django Object-Relational-Model (ORM). In 2023, the Open Context team finished migration of from a legacy database schema to a revised and refactored database schema with stricter referential integrity and better consistency across tables. During this process, the Open Context team de-duplicated records, cleaned some metadata, and redacted attribute data left over from records that had been incompletely deleted in the legacy schema. This database dump includes all Open Context data organized with the legacy…

Описание из Zenodo, сокращённое.

Файлы (2)

• PDFoc_revised_schema_entity_relation_diagram.pdf19 кБ
• ZIPoc_legacy_and_new_schema.sql.zip4,7 ГБ

DataHunter не хранит и не раздаёт эти файлы: каждая ссылка ведёт к первоисточнику. Перед использованием проверьте там лицензию.