O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

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

Data-Manipulation Strategies

Proficiency in SQL and understanding database objects should be one of your main objectives as a database programmer. For example, if you are performing a query on a large table repeatedly, your database administrator might want to create summary tables instead. In addition, your applications can use temporary tables to store their data instead of caching it in memory.

You also can download considerable business functions in terms of computation and data processing to a DB2 server by taking advantage of features such as UDFs and stored procedures. You should try to do this whenever possible to consolidate your database programming code. This makes for easier code maintenance, and extends code reuse by making it available ...

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