[Building Sakai] Sakai database graphic representation

[Algaze, Louis Contractor, eDataTech]

Mathieu,

I've recently been working on generating SQLs to pull summary data from the database, although many have discouraged querying the database directly and recommended using the APIs/web services, but I'm much more comfortable with SQL than WS and feel like we can get more info this way. We are currently on 2.7.1 and expect to re-create some, if not many of these when we go to 3 and will need to check as we update to newer releases.

I'd be happy to share any SQLs I figure out/create (wiki?) if there is interest and would be interested in seeing other's SQLs.

I also generated a diagram using MySQL Workbench and would be happy to share that with you, or anyone who asks (once again, wiki?).  Although many of the tables do not have associations as they are in the application.

Feel free to contact me directly if there is interest for the diagram and SQLs.

Thank you,

Louis Algaze


From: Mathieu Plourde <mathieu at udel.edu<mailto:mathieu at udel.edu>>
Date: Mon, 18 Apr 2011 11:13:26 -0400
To: Sakai Server <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Subject: [Building Sakai] Sakai database graphic representation

Hi!

Can anyone point me to a visual output of the Sakai CLE database (relational representation)? One of our MIS professors wants to analyze it to determine what can be extracted regarding learning analytics for a research paper.

I've checked Confluence, but I'm not as familiar with the developers' corner of it.

Mathieu
==================================
Mathieu Plourde, MBA
Project Leader, LMS/Educational Technologist
IT Client Support & Services
mathieu at udel.edu<mailto:mathieu at udel.edu>
Office: 302-831-4060
==================================
IT Support Center: http://www.udel.edu/help
Sakai at UD Support and Training: http://www.udel.edu/sakai/training

_______________________________________________ sakai-dev mailing list sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110418/f6cb46ed/attachment.html