Engineering MySQL Subroutines for Integrity

Michael McLaughlin (BYU - Idaho)
Average rating: ***..
(3.00, 1 rating)

Integrating MySQL subroutines starts with good database design. Good database design requires understanding the business problem and technology stack possibilities. Web 2.0 and AJAX raise the ante with more complex transaction control problems. This presentation addresses how to create MySQL stored programs to solve these problems.

Topics Include:

Merits of functions over procedures Merits of definer and invoker rights Merits of MySQL security-layers with stored programs Simplification of PHP when using stored programs Transaction control provided by stored programs Approaches for page and page-fragment refreshes

Photo of Michael McLaughlin

Michael McLaughlin

BYU - Idaho

I teach database technology and systems analysis in the Computer Information Technology Department at BYU – Idaho. I’ve worked as an application developer, DBA, and database designer for over twenty-five years with Oracle, MySQL, and DB2 databases. I’ve authored or co-authored books on PHP and Oracle programming.

Comments on this page are now closed.

Comments

Billy Vitro
04/15/2011 11:53am PDT

This presentation covered a lot of ground, and missed depth. It seemed like the presenter should have assumed a level of understanding of stored procedures by the attendees, and given specific examples of how to improve those. For example, covering JavaScript and CSS was mostly a waste of time.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts