O'Reilly logo

Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition by Susan Visser, Bill Wong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required