Relational Database
A relational database is a way of storing information (data). The database matches data by using identical information that is found within the data set. The resulting groups of data are organized and are much easier for many people to understand.
For example, a database has all information about real-estate sales in a town. This information can be grouped by year, or by sale price, or by buyer's last name and so on. Such a grouping uses the relational model (a technical term for this is schema). Hence, such a database is called a "relational database."
From Wikipedia, the free encyclopedia
Relational Database Books
Fundamentals of Relational Database Management Systems By S. Sumathi, S. Esakkirajan
Relational Database Design Clearly Explained By Jan L. Harrington
Relational Database Index Design and the Optimizers By Tapio Lahdenmaki, Mike Leach
Handbook of relational database designCandace C. Fleming, Barbara Von Halle
ACID Properties
ACID is a concept used with Databases. It is an abbreviation. It stands for
- Atomicity - something is either done completely, or not done at all. The state of doing it is not visible outside the database.
- Consistency - The database is in a legal state at all times. When a transaction occurs, it can not break the rules. These rules are about integrity, what is allowed and what is not allowed in certain locations of the database.
- Isolation - There can be more than one transaction occurring at the same time. A certain transaction will not see changes made by other transactions.
- Durability - When a transaction is done, it will be committed. After it is committed, it can no longer be undone.Continue Reading....
From Wikipedia, the free encyclopedia
No comments:
Post a Comment