Lotus Notes is not a relational database – Lotus Notes Database
The power of storing Notes databases in DB2 comes not just from the performance improvements that will be available for applications that need it, but more from the ability to see the Notes data in some kind of relational form and work with it from there, while still maintaining the Notes access controls against the data.
Just don’t get too carried away about your Notes data magically being relational, though! Firstly, the DB2 option is only available on servers. Local databases on clients are still stored as .NSF files. The server’s NSF layer maps the data to DB2. The storage in DB2 is that of the Notes data model, it’s not suddenly made the data all fully relational. While you can read — and write — the data with SQL from non-Notes applications, you will still be dealing with the Notes data model.
Viewed 7816 times by 2925 viewers
