Chapter 6. Getting Relational: Database Schema Design
In which my car leaves me stranded on the highway, and we finally discuss the integration of XML and SQL!
A database schema is a collection of database objects that are designed together to fulfill a specific function. The most commonly known database object is a database table, in which information is stored in columns and rows (see the section Structured Query Language (SQL) in Chapter 2), but other commonly used database objects include sequences (incremental number generators), stored procedures (sometimes called by database-specific terms such as Oracle's PL/SQL), and triggers (stored procedures that “fire off” before, during, or after a specific event, like the insertion or deletion ...
Get XML and SQL: Developing Web Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
