Design data environments

The content of each data environment should be designed in detail. Design requires a close knowledge of the performance characteristics of the data environment to ensure that the non-functional constraints imposed on the data can be met. For example, while a data model in Third Plus Normal Form is considered an adequate analysis model, the data implementation in a relational database will usually be partially de-normalized to meet the performance requirements. If a non-relational database is used, then the final implementation may bear little resemblance to the logical data model; see Figure 6.3.

Figure 6.3. Example of a logical schema

In addition, capabilities such as the use of indices to support ...

Get Service- and Component-based Development: Using Select Perspective™ and UML now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.