Re: [dspace-tech] Re: DB Schema / Data model for Dspace 7
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: dspace-tech@googlegroups.com on behalf of Jorge Costa Sent: Friday, January 27, 2023 3:35 AM To: DSpace Technical Support Subject: [dspace-tech] Re: DB Schema / Data model for Dspace 7 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 ! On Thursday, January 26, 2023 at 7:52:19 PM UTC Tim Donohue wrote: 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 On Wednesday, January 25, 2023 at 5:30:28 AM UTC-6 jorge...@gmail.com wrote: 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 ? -- 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+unsubscr...@googlegroups.com<mailto:dspace-tech+unsubscr...@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<https://groups.google.com/d/msgid/dspace-tech/cd90f361-4b13-44af-be0f-0727f076f7ccn%40googlegroups.com?utm_medium=email_source=footer>. -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/PH0PR22MB3274F2D6200162F131E8EAE5EDCC9%40PH0PR22MB3274.namprd22.prod.outlook.com.
[dspace-tech] Re: DB Schema / Data model for Dspace 7
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 ! On Thursday, January 26, 2023 at 7:52:19 PM UTC Tim Donohue wrote: > 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 > > On Wednesday, January 25, 2023 at 5:30:28 AM UTC-6 jorge...@gmail.com > wrote: > >> 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 ? >> >> -- 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+unsubscr...@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.
[dspace-tech] Re: DB Schema / Data model for Dspace 7
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 On Wednesday, January 25, 2023 at 5:30:28 AM UTC-6 jorge...@gmail.com wrote: > 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 ? > > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/43e9ad2e-99e4-4234-8241-c3d95518b810n%40googlegroups.com.
