chapter 11Database Implementation
In this chapter, we cover some considerations regarding the implementation of a database system. These include cursor processing, transaction management, performance tuning, and change control.
CHAPTER OBJECTIVES
In this chapter, the reader should:
• Know how to use cursors in database applications.
• Understand database transactions and how to implement them.
• Understand database performance-tuning concepts.
Cursor Processing
Before we embark on transaction management, which includes a discussion of the locking mechanisms required to support concurrent updates of the database, we must explore the way application programs handle database queries. The collection of rows returned by the execution of a database ...
Get Databases DeMYSTiFieD, 2nd Edition, 2nd 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.
