Database Management in the Real World
This chapter is devoted to four issues that are of particular importance in production-oriented, online database applications.
The first of these issues, security, is handled in nearly every relational database management system by two mechanisms: the assignment of permissions (also called privileges) with the SQL GRANT and REVOKE commands and the creation of views (through which users can be granted selective access to the database). Some systems also use procedures (sets of extended, often procedural, SQL statements that may accept parameters) as a method to control user actions. Different database management systems deal with the other three issues—transactions, performance, and integrity—in a wide variety ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition 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.
