Systems Analysis and Design with UML, 4th Edition

CHAPTER 9

DATA MANAGEMENT LAYER DESIGN

A project team designs the data management layer of a system using a four-step process: selecting the format of the storage, mapping the problem domain classes to the selected format, optimizing the storage to perform efficiently, and then designing the necessary data access and manipulation classes. This chapter describes the different ways objects can be stored and several important characteristics that should be considered when choosing among object persistence formats. It describes a problem domain class to object persistence format mapping process for the most important object persistence formats. Because the most popular storage format today is the relational database, the chapter focuses on the optimization of relational databases from both storage and access perspectives. We describe the effect that nonfunctional requirements have on the data-management layer. Last, the chapter describes how to design data access and manipulation classes.

OBJECTIVES

• Become familiar with several object persistence formats
• Be able to map problem domain objects to different object persistence formats
• Be able to apply the steps of normalization to a relational database
• Be able to optimize a relational database for object storage and access
• Become familiar with indexes for relational databases
• Be able to estimate the size of a relational database
• Understand the affect of nonfunctional requirements on the data management layer
• Be able to design the data ...