[Using Sakai] Sakai database structure and details

[Mark Norton]

In general, Sakai tools shouldn't access database tables directly 
associated with Sakai services.  If you want something about a Sakai 
site, using the SiteManager API.  If you are developing new tables 
associated with an application, then you should develop your own service 
to manage that data.  This allows you to expose the API to that service 
to other tools for integration purposes.

Database schemas are compartmentalized for a reason.  They are subject 
to change pretty much without notice.  Tables are sometimes changed 
locally to optimize the database along special lines.  As long as these 
changes don't affect the service implementations, all is well, because 
tools access the data through the service APIs.

I think that 98% of the time access to data through the APIs will meet 
your needs.  That 2% are the special cases.  It is sometimes desirable 
to do a join against other tables, for example.  Such cases are not 
portable, however.  I strongly urge you to look at the service API.  
Most of the important services are now bundled into the Sakai kernel.

- Mark Norton

On 10/14/2011 3:08 AM, Rajan wrote:
>
> Dear all
>
> We are the users of Sakai CLE and I am involved in customizing the 
> product. Where can I find the detailed database structure (we are 
> using Oracle DB) and various tables used (purpose and stored 
> information) .
>
> Can you provide source of information pl.
>
> regards
>
> *Rajan P R*
>
> *Manager (Systems)*
>
> *e-Learning  Department, Strategic Traning Unit*
>
> *SBIICM Campus, *
>
> *Road No 12, Banjara Hills*
>
> *Hyderabad - 500 034*
>
> *Phone : 040 - 23388048*
>
> *Mobile: +91 96666 27940***
>
> Description: 
> http://3.bp.blogspot.com/_SWYxbjK223E/SxG5xh55ZFI/AAAAAAAAAIQ/6XO0G_2YgvU/s320/think-before-u-print.gif
>
> 	
>
> *You Have the Power to Conserve***
>
>
> --- Disclaimer --- The information in this mail is confidential and is 
> intended solely for addressee. Access to this mail by anyone else is 
> unauthorised. Copying or further distribution beyond the original 
> recipient may be unlawful. Any opinion expressed in this mail is that 
> of sender and does not necessarily reflect that of State Bank group. ---
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20111014/fbfad9b4/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 7254 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20111014/fbfad9b4/attachment-0001.png