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 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.