Introduction slide for lecture 14 of Developing Web-based Database Applications In December 2006 I was honored to provide my first public presentation ever as guest speaker for Harvard University's course Developing Web-based Database Applications (CSCI E-253). This course is part of the Extension School curriculum for the Master of Liberal Arts in Information Technology and the Certificate in Applied Science concentration in Information Systems and Electronic Commerce, and it focuses on the use of Oracle and ColdFusion MX as the vehicle of learning database design for the Web.

The instructor requested that I provide 2 hours of material for the full lecture on the topic of administering a ColdFusion server. This resulted in a very comprehensive crash course presentation on ColdFusion MX 7 Server Administration from page request flow, to understanding directory structure and critical config files, to managing the web server connector stub, to walking through the ColdFusion Administrator, and including ColdFusion and JVM tuning. As a conservative estimate, I spent nearly 30 hours of my own time to build the presentation.

The course was part of Harvard's Distance Education program, which provides live, streaming video from the classroom to remote students around the country and around the world, in addition to the local students in the classroom. My presentation was conducted in state of the art video production classroom equipped with a control booth, several remote controlled cameras, and two slide screens. The control booth technician made me feel like I was on a Hollywood stage, providing hand signals to me as he counted down to begin live broadcast.

Surprisingly, I did a decent job without any major hitches. You can imagine how stressing this scenario was for a first-time presenter. Based on this experience, I intend to review my presentation to expand or contract some topics as necessary. Then if there's a need, I may offer the presentation to other groups when time permits. Since having joined the ranks of ColdFusion QA this year I've been much busier than I was in Technical Support, and even more now that my wife and I immersed in house hunting and negotiating, but things should slow down by the Spring and allow me to get back to this.

For now, here's a few screen shots from the preso, and I may generate blog entries for each of these topics in the near future, but hopefully there's some value in just having these cartoon diagrams. You may also want to check out last year's post on How ColdFusion Receives and Processes Requests.

ColdFusion Server Architecture diagram
ColdFusion Connector diagram
ColdFusion Request Flow diagram
ColdFusion Request Processing Flow diagram