Usability - Productivity - Business - The web - Singapore & Twins

Lotus Notes Documents as RDBMS schema

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

Posted by on 05 November 2007 | Comments (4) | categories: Show-N-Tell Thursday


  1. posted by Slawek Rogulski on Wednesday 07 November 2007 AD:
    For the sake of the exercise it might be an idea to do an OR mapping, say to Hibernate.
  2. posted by Gerry King on Saturday 10 November 2007 AD:
    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.
  3. posted by Stephan H. Wissel on Sunday 11 November 2007 AD:
    @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?
    Emoticon smile.gif stw
  4. posted by Vikram on Thursday 10 January 2013 AD:
    This is something really good.. but the diagram does not describes things in details.. can you please elaborate some more..