Chapter 12. Creating Custom Functions
By itself, a database is nothing more than a container that holds data. The functions and tools are what make a database truly useful. Much of the work of designing an effective database is being able to model the business rules needed. Developing the proper table schema is one of the ways to model the business rules within the database; the other ways are through the creation of custom functions, triggers, and rules.
As a basic overview, functions, triggers, and rules compare as follows:
Functions. User-defined functions (also called stored procedures) are most useful as a way to implement commonly called code within the back end itself.
Triggers. These enable additional actions to be performed when a ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access