Indexes can be added and removed at any time. Rules can be used to return different sets based on permissions, turn an attempted update into a delete, etc. Temporary tables, which are automatically dropped at the end of a database connection. Transactions, Concurrency Transactions allow all data modifications to be encapsulated in atomic blocks. This allows the database to rollback and restore all original data if there is an error in the transaction or if the database server crashes.
Transactions are a critical feature for ensuring data integrity in database-backed applications.
ACID compliant Support for rollback Serializable transaction isolation Works transparently with transaction features of interface programs, such as Perl's DBI, Zope, JDBC and ODBC transactions, etc. Readers do not block writers and writers do not block readers. Better than row-level locking. Various row and table level locks are available as well. Supports Kerberos authentication.