wissel.net

« Switching between Domino server versions (Windows Edition) | Main| Tech University Jakarta - Project Worst Practices »

Lotus Notes Documents as RDBMS schema

I tried to draw a generic RDBMS schema description for a note. This is my first draft:

Posted by Stephan H Wissel On 05/11/2007, Category Show-N-Tell Thursday | Permalink |      

Comments

1 - For the sake of the exercise it might be an idea to do an OR mapping, say to Hibernate.

Posted by Slawek Rogulski At 11:00:03 On 11/07/2007 | - Website - |

2 - @Slawek: you are very much welcome to blog about that.
@Gerry: you are absolutely right. I was musing: how would the Notes datastore look like if it was relational. Other than this pretty picture I haven't found a good use for this (especially since the interesting parts like security, access control, encryption etc. would need to be handled by an application). But it is interesting to know isn't it?
stw

Posted by Stephan H. Wissel At 23:34:29 On 11/11/2007 | - Website - |

3 - Interesting but pointless... At the heart is the notesitem which is a 'triple' - the things that 'tuples' are made of. Which in turn are at the heart of relational theory.
To work effectively with Notes you have to leave this behind.

Posted by Gerry King At 23:28:16 On 11/10/2007 | - Website - |

Post A Comment

Name

Email

Website

Remember Me

Comments UBB Code Allowed

Comment Preview

Disclaimer

This site is in no way affiliated, endorsed, sanctioned, supported, nor enlightened by Lotus Software nor IBM Corporation. I may be an employee, but the opinions, theories, facts, etc. presented here are my own and are in now way given in any official capacity. In short, these are my words and this is my site, not IBM's - and don't even begin to think otherwise. (Disclaimer shamelessly plugged from Rocky Oliver)

© 2003 - 2009 Stephan H. Wissel - all rights reserved as listed here:
Unless otherwise labeled by its originating author, the content found on this site is made available under the terms of an Attribution/NonCommercial/ShareAlike Creative Commons License, with the exception that no rights are granted -- since they are not mine to grant -- in any logo, graphic design, trademarks or trade names of any type.