Chapter 14. Design Considerations

Today you learn what you need to think about when designing your databases or applications, as well as maintaining the system. You learn what resources you should consider when implementing an application. From a programming perspective, you learn the basics of managing data concurrency by understanding row and table-level locking. Also covered are some programming techniques you can use to reduce network traffic between a database client and server. These techniques include using stored procedures, blocking SQL statements, and retrieving groups of rows. Database structures such as indexes also are reviewed to see how they can improve application performance.

The guidelines covered during this lesson should be ...

Get Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition now with O’Reilly online learning.

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