Database Concepts for the Systems Analyst
Databases
- Relational Database Management Systems:
- High-end relational databases also extend the SQL language to support triggers and stored procedures.
- Triggers are programs embedded within a table that are automatically invoked by a updates to another table.
- Stored procedures are programs embedded within a table that can be called from an application program.
- Both triggers and stored procedures are reusable because they are stored with the tables themselves.
- This eliminates the need for application programmers to create the equivalent logic within each application that use the tables.