Durability is the property that makes sure that transactions are permanently stored and do not disappear or are erased by accident, even during a database crash. It is accomplished by storing all transactions into a non-volatile storage medium. Durability is part of the ACID acronym, which was popularized by Theo Harder and Andreas Reuter in […]
A database view is a subset of a database that is based on a query that runs on one or more database tables. Database views are saved in the database as named queries and can be used to save complete queries that are frequently used. Static and Dynamic Views There are two types of database […]
Data obfuscation consists of changing sensitive data or personally identifying information (PII), intending to protect confidential information in non-productive databases. A successful obfuscation is when the data maintains referential integrity, as well as its original characteristics, which guarantees that the development, testing, and installation of the applications are successful. This technique is used in non-productive […]
In database technologies, rollback is a command that returns the database to some previous point, and it is used to restart the current transaction and reestablish the last commitment boundary. Rollbacks are essential for database integrity as they indicate that the database can be restored to a clean copy even after an incorrect operation. By […]