When a 4GL client updates a record in the database, the actions taken behind the scenes are quite a bit more complex than you might imagine. In this talk, we describe what happens in the 4GL client and the database when executing a simple 4GL program. We will look at compiling, client side data structures and the various operations that take place on the client side. Then the actions performed in the database.

(this talk was given in 2010 at a New England PUG meeting)

dba_day_behind_the_scenes_gus_v04.pptx