Design Applications Based on Data Integrity Issues

The Notes/Domino database architecture is not relational; rather, it is an object store. What this means is that unlike a relational database, where redundancy is minimized through normalization and linked tables, redundancy is not only common, but it is often necessary in your Notes/Domino applications. That being said, your goal should be to minimize redundancy as much as possible because it leads to wasted storage and obsolete data.

In a relational database, it is common to normalize data and store it in separate tables, which can be dynamically linked. Notes/Domino, however, doesn't provide the same level of capability in this area. For example, you build a customer relationship management ...

Get Lotus Notes® and Domino® 6 Application Development Exam Cram™ 2 (Exams 610, 611, and 612) now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.