DSpace Entity Relationship Diagram (ERD) and DSpace Data Dictionary

[Olumide Oladimeji Agbabiaka]

Good day to you all,

Is there anyone who has DSpace Entity Relationship Diagram (ERD) and DSpace Data Dictionary? I'm dire in need of them please, I'm carrying out a research work on repository with biasness on DSpace.

Best regards,
AGBABIAKA, Olumide O.

[Tim Donohue]

Hi,

It's unclear to me exactly what you are looking for, as DSpace doesn't have a "data dictionary" and we don't have an official Entity Relationship Diagram either.  

If you want an overview of how objects are related in DSpace, there's a small diagram in the documentation at https://wiki.lyrasis.org/display/DSDOC7x/Functional+Overview

If you want to understand the underlying database structure, that can be found in the docs at: https://wiki.lyrasis.org/display/DSDOC7x/Storage+Layer

All DSpace Documentation is publicly available on our wiki (https://wiki.lyrasis.org/display/DSDOC7x/), so hopefully the information you are looking for can be found there.  If not, you may need to ask more specific questions on this mailing list to let us know what you are looking for.

Tim

---

From: dspace-c...@googlegroups.com <dspace-c...@googlegroups.com> on behalf of Olumide Oladimeji Agbabiaka <olumide....@gmail.com>
Sent: Thursday, October 6, 2022 6:29 AM
To: DSpace Community <dspace-c...@googlegroups.com>
Subject: [dspace-community] DSpace Entity Relationship Diagram (ERD) and DSpace Data Dictionary

 

--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups "DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-communi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/dd8c3700-4b35-44ef-adf1-822d2675a18an%40googlegroups.com.

[Tianyi Gu]

Hello there,

You run the SQL script as bellow:

 

SELECT *

FROM metadatafieldregistry a JOIN

metadataschemaregistry b

ON a.metadata_schema_id=b.metadata_schema_id;

Then you will get all the metadata names and, the scope_note, which is definition of the metadata. So you can use it as a data dictionary.