--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-commu...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/5d197adb-3a7b-4c79-8aa5-467eea9f023d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
hello,does this help?
Hi Everybody,--We're looking for more detailed information about the basic structure of Dataverse's postgres database, something along the lines of a database diagram. We've seen some of the flowchart pngs on github. But is there any additional dvndb documentation out there that could help us better understand the flow of information through the database? We don't have a java development team, so working through the application logic would be challenging for us, but we do have some database people that with a little guidance can help us with tweaks here and there.Thanks very much for the help. Best, Frank
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse-community@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/5d197adb-3a7b-4c79-8aa5-467eea9f023d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/1B790E1E-2EFF-492F-B77A-870EEB821B14%40gmail.com.To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse-community@googlegroups.com.
hello,does this help?
Hi Everybody,--We're looking for more detailed information about the basic structure of Dataverse's postgres database, something along the lines of a database diagram. We've seen some of the flowchart pngs on github. But is there any additional dvndb documentation out there that could help us better understand the flow of information through the database? We don't have a java development team, so working through the application logic would be challenging for us, but we do have some database people that with a little guidance can help us with tweaks here and there.Thanks very much for the help. Best, Frank
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
PhilI hope this helps!More commonly, database people are recruited to help you pull insights out of your database, to create reports. There's an ongoing effort at https://github.com/IQSS/dataverse/issues/4169 where we have been writing SQL queries for reporting purposes and putting those SQL queries in a Google Doc linked from that issue. If there's a query you'd like to contribute or get help with, you should suggest an edit to that Google doc or leave a comment. There's another effort underway where we are taking some of those SQL queries and coming up with a "metrics" API over at https://github.com/IQSS/dataverse/issues/4527 . Comments and feedback are welcome, as always.I should back up and say that I'm slightly alarmed by the suggestion of tweaks here and there. On rare occasions, we will advise minor database edits ( http://guides.dataverse.org/en/4.8.6/admin/user-administration.html#deleting-an-api-token comes to mind) but in general database updates should be coming from actions in the GUI or calls to the API. For example, if a UNF is missing, we have an API to add it into the database: http://guides.dataverse.org/en/4.8.6/api/native-api.html#dataset-integrityDon, thank you for giving my standard answer while I was still sleeping, which is a link to http://phoenix.dataverse.org/schemaspy/latest/relationships.html :)Frank, you and your database people should know that the SchemaSpy output (entity-relationship diagrams and navigation) represents the Dataverse database schema in the latest code in our main integration branch, which is called "develop". So, depending on how far back you are on Dataverse versions, your database might look slightly different. If you're interested in similar diagrams for your database, the command I use is checked into the source tree at https://github.com/IQSS/dataverse/blob/v4.8.6/scripts/deploy/phoenix.dataverse.org/post#L15(I use that "phoenix" server to run our API test suite, dropping the database on each deployment and run SchemaSpy at the end. For more details, please see http://guides.dataverse.org/en/4.8.6/developers/testing.html#the-phoenix-server . Maybe I should document the SchemaSpy bit.)
On Fri, Apr 27, 2018 at 5:52 AM, Donald Sizemore II <don.si...@gmail.com> wrote:
hello,does this help?
Hi Everybody,--We're looking for more detailed information about the basic structure of Dataverse's postgres database, something along the lines of a database diagram. We've seen some of the flowchart pngs on github. But is there any additional dvndb documentation out there that could help us better understand the flow of information through the database? We don't have a java development team, so working through the application logic would be challenging for us, but we do have some database people that with a little guidance can help us with tweaks here and there.Thanks very much for the help. Best, Frank
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/5d197adb-3a7b-4c79-8aa5-467eea9f023d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/1B790E1E-2EFF-492F-B77A-870EEB821B14%40gmail.com.
Hi Phil,
Definitely helps. Thanks very much for the reporting queries links (which we are very interested in) and especially the alarm. Right now we've got a dataverse development server that is made for education and testing, and is breakable by design - so no tweaks will see the light of day anytime soon... Primarily we're interested in small usability adaptations for our local user groups, for example, reordering the language and location vocabularies.Not sure how long it will take before we can contribute to the queries document, but if there is anything else we can help out with just let me know. Maybe contributing to the documentation process? We're gaining so much benefit from Dataverse right now that it would be great if we could return the favor somehow.Best, Frank
On Friday, April 27, 2018 at 12:58:29 PM UTC+2, Philip Durbin wrote:
PhilI hope this helps!More commonly, database people are recruited to help you pull insights out of your database, to create reports. There's an ongoing effort at https://github.com/IQSS/dataverse/issues/4169 where we have been writing SQL queries for reporting purposes and putting those SQL queries in a Google Doc linked from that issue. If there's a query you'd like to contribute or get help with, you should suggest an edit to that Google doc or leave a comment. There's another effort underway where we are taking some of those SQL queries and coming up with a "metrics" API over at https://github.com/IQSS/dataverse/issues/4527 . Comments and feedback are welcome, as always.I should back up and say that I'm slightly alarmed by the suggestion of tweaks here and there. On rare occasions, we will advise minor database edits ( http://guides.dataverse.org/en/4.8.6/admin/user-administration.html#deleting-an-api-token comes to mind) but in general database updates should be coming from actions in the GUI or calls to the API. For example, if a UNF is missing, we have an API to add it into the database: http://guides.dataverse.org/en/4.8.6/api/native-api.html#dataset-integrityDon, thank you for giving my standard answer while I was still sleeping, which is a link to http://phoenix.dataverse.org/schemaspy/latest/relationships.html :)Frank, you and your database people should know that the SchemaSpy output (entity-relationship diagrams and navigation) represents the Dataverse database schema in the latest code in our main integration branch, which is called "develop". So, depending on how far back you are on Dataverse versions, your database might look slightly different. If you're interested in similar diagrams for your database, the command I use is checked into the source tree at https://github.com/IQSS/dataverse/blob/v4.8.6/scripts/deploy/phoenix.dataverse.org/post#L15(I use that "phoenix" server to run our API test suite, dropping the database on each deployment and run SchemaSpy at the end. For more details, please see http://guides.dataverse.org/en/4.8.6/developers/testing.html#the-phoenix-server . Maybe I should document the SchemaSpy bit.)
On Fri, Apr 27, 2018 at 5:52 AM, Donald Sizemore II <don.si...@gmail.com> wrote:
hello,does this help?
http://phoenix.dataverse.org/schemaspy/latest/relationships.htmlpainstakingly pecked on my iphone.
Hi Everybody,--We're looking for more detailed information about the basic structure of Dataverse's postgres database, something along the lines of a database diagram. We've seen some of the flowchart pngs on github. But is there any additional dvndb documentation out there that could help us better understand the flow of information through the database? We don't have a java development team, so working through the application logic would be challenging for us, but we do have some database people that with a little guidance can help us with tweaks here and there.Thanks very much for the help. Best, Frank
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsubscribe...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/5d197adb-3a7b-4c79-8aa5-467eea9f023d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsubscribe...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/1B790E1E-2EFF-492F-B77A-870EEB821B14%40gmail.com.
--Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin
--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse-community@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/4d7104a8-0410-4a20-991e-925aca1e4ff4%40googlegroups.com.
Hi Phil,
hello,does this help?
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/5d197adb-3a7b-4c79-8aa5-467eea9f023d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/1B790E1E-2EFF-492F-B77A-870EEB821B14%40gmail.com.
--Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin
--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-community+unsub...@googlegroups.com.
To post to this group, send email to dataverse...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/4d7104a8-0410-4a20-991e-925aca1e4ff4%40googlegroups.com.
Hi Phil,Thanks. Our usability questions aren't problems so much as local preferences. So in the case of language this would be updating displayorder in controlledvocabularyvalue so that German is at the top of its list. For locations, Austria would be top. These are small things for sure, but some users have mentioned it and we figured it's worth exploring, if only to understand Dataverse internals a little better.