
At Lotusphere 2003 in Orlando, IBM and Lotus demonstrated a prototype of Domino 7 with an optional feature of storage of Notes data in DB2. It appears, for this prototype at least, that this is optional on a per-database level. The DB2 storage replaces the actual .NSF file, while Domino still uses the internal NSF facility to access the data. So the whole Domino application runs, unchanged, but with the physical storage handled by DB2, and there is no .NSF file. You should still be able to replicate, and I would speculate that when that happens, if the target doesn't have DB2, it gets translated back to a .NSF file. It was also not clear whether the DB2 need to be physically on the same machine, or whether it can be on another server. And being DB2, it's going to be fast.
There's more. You can actually get at the data directly in SQL, with the proviso that the SQL is pre-processed by Domino so that ACLs are honoured, including having any Reader and Author field values in the data are checked, and data displayed - or updated - only if the user has access to that data. So you can write non-Notes programs to access the Notes data directly. Think of reporting and statistical analysis of the data. Think of joining Notes databases together in SQL selects.
And more: you will be able to create special views where the selection is actually an SQL statement, and the view is populated with the result set, every time it's needed. The view index is not stored. Click on it, and you get the document, as expected.
And yet more. Such views could be joins of multiple databases, or even Notes and non-Notes data, though here it's not clear what will happen when you click on the document.
Sounds cool. -- Mick Moignard