Terminology
Cross join ¶ definition: 'A join with no filtering condition; a complete Cartesian product between two tables.'
ety: ''
variants: ''
Inner join ¶ definition: 'A join that contains only the product rows that match a condition.'
ety: ''
variants: ''
Join ¶ definition: 'A Cartesian product between two tables that contains some or all of the contents of each of the source tables.'
ety: ''
variants: ''
Facts, Thoughts and Opinions
10 things you should know about NoSQL databases
Five advantages of NoSQL: Elastic scaling, big data, no need for DBAs, economics, flexible data models.
Five challenges of NoSQL: Maturity, support, analytics and business intelligence, administration, expertise.
ACID
Atomicity - Each transaction is "all or nothing": if one part of the transaction fails, the entire transaction fails, and the database state is left unchanged.
Consistency - Any transaction will bring the database from one valid state to another.
Isolation - Concurrent execution of transactions results in a system state that could have been obtained if transactions are executed serially.
Durability - Once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors.
Database Tables
You should build as many [database] tables as you need, but no more.
Images
- Subtopics
- Database Administration
- Writings
Sources & Bookmarks
| Name/Link | ¶ | Date |
|---|---|---|
| Database Development Patterns | ¶ | 2012-09-11 |
| FoundationDB | ¶ | 2014-04 |