DB Schema / Data model for Dspace 7

[Jorge Costa]

Hi.

Could I please get the db schema/ data model for Dspace 7 ?

Why ?

We are a large institution with various departments and are required to provide quarterly updates per departments. To this end we run SQL queries against the database.

We have preset queries which we used in Dspace 4 , which , with a press of a button spew out the required information.

These queries/selects obviously no longer work after our migration to dspace 7.

To assist in the "correction" of the queries I was asked to provide the schema ... the relationships between the tables in the actual database and what they hold.

I did attempt to find this on my own , but on the wiki the closest I found was dspace 6 schema .

Are they the same ?

[Tim Donohue]

Hi,

As you correctly noted, the latest schema diagram we have is for DSpace 6: https://wiki.lyrasis.org/display/DSDOC7x/Storage+Layer   This diagram is "semi-accurate" for DSpace 7, as v7 uses the same general table structure as v6... with a few new tables added to v7 to specifically support Configurable Entities & other new features in v7.

Unfortunately, we've not had a volunteer to help us regenerate that fancy diagram in the documentation (the previous v6 diagram was created with a paid tool).  If anyone is interested in helping generate a pretty diagram for v7, we'd appreciate volunteers.

In the meantime, there are many free database tools which can generate an interactive ERD (Entity Relationship Diagram) if you just point it at your database.  One I've used in the past is pgAdmin 4 (https://www.pgadmin.org/docs/pgadmin4/6.18/erd_tool.html). To get a dynamically built diagram for DSpace 7, you could point pgAdmin 4 against a DSpace 7 (Postgres) database, and use its built in ERD Tool.  The advantage to this is that you no longer are dealing with a static image file, the diagram is interactive & you can easily zoom in to get as much  detail on each table as you wish.

Tim

[Jorge Costa]

Hi Tim

Thanks for the quick reply , I will have a look and see if i can successfully run that tool to generate a diagram.

Just a quick question and .... only reply if you got this on the tip of your tongue.... where on earth is a collection/community name stored in this new structure ? I cant , for the life of me , find it ! Its vexing !

[Tim Donohue]

Hi Jorge,

As of DSpace 6 (and above), Communities & Collections have metadata just like Items.  So that means the Community/Collection name (or title) is stored in a "dc.title" metadata field linked to the Community/Collection, in the same way that an Item's name (or title) is also stored in a "dc.title" metadata field.

The same is also true for other metadata related to Communities/collections.  The description for each is stored in "dc.description" metadata, etc.

DSpace 7 continues this same pattern as DSpace 6.  There's no major changes to the core database table (that I can recall) in DSpace 7, just some new tables added to support features new to DSpace 7.

Tim

---

From: dspac...@googlegroups.com <dspac...@googlegroups.com> on behalf of Jorge Costa <jorge...@gmail.com>
Sent: Friday, January 27, 2023 3:35 AM
To: DSpace Technical Support <dspac...@googlegroups.com>
Subject: [dspace-tech] Re: DB Schema / Data model for Dspace 7

 

--
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 Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/cd90f361-4b13-44af-be0f-0727f076f7ccn%40googlegroups.com.