1. Quote of the Week
"Which leads to another bad experience: the pernicious use of foreign keys. In the ORMs I've used, links between classes are represented in the data model as foreign keys which, if not configured carefully, result in a large number of joins when retrieving the object. (A recent count of one such table in my work resulted in over 600 attributes and 14 joins to access a single object, using the preferred query methodology.)
...When you have foreign keys, you refer to related identities with an identifier. In your application, "identifier" takes on various meanings, but usually it's the memory location (a pointer). In the database, it's the state of the object itself. These two things don't really get along because you can really only use database identifiers in the database (the ultimate destination of the data you're working with)." --wozniak.ca
2. To Laugh or Cry?
- The Lesser Known Normal Forms of Database Design
- A Unique Journey in Search of Keys
- Dataset: Databases for lazy people
- Data Modelling
3. Of Interest
- Lies, Damned Lies and “Eventual Consistency”
- NoSQL Meets Bitcoin and Brings Down Two Exchanges
- What's Wrong With Object-Oriented Programming
4. Added links
- On Making Relational Division Comprehensible (PDF) (to LINKS page)
- HaskellDB Examples (to LINKS page)
- HaskellDB (to Software list on HOME page)
And Now for Something Completely Different
The PostWest (A decaying civilization whose whole future is behind it)
- Loneliness will be the next great moneyspinner
- Cut-throat academia leads to 'natural selection of bad science'
- Top EU lawyer says Hamas should be dropped from terror list
- Workplace wellness programs are a shamHow ITT Tech Screwed Students and Made Millions
- Uber Accused of Cashing In On Bomb Explosion
- Bay Area shareholder sues Wells Fargo over unauthorized accounts
- Your new iPhone’s features include oppression, inequality – and vast profit
- Why the silencing of KrebsOnSecurity opens a troubling chapter for the ‘Net'
- Facebook inflated video viewing stats for two years
- Russia: Mossad, other foreign agents killed in Aleppo strike
- A Shocking Amount of E-Waste Recycling Is a Complete Sham
- Why Britain, France are building a wall in Calais to keep out migrants
- Walmart Is Cutting 7,000 Jobs Due To Automation
- Italy rescues 3,000 migrants from Mediterranean as arrivals surge
Article of the Week
Decline and fall: how American society unravelled
Pinch me of the week
Syria says Israeli 'terrorism' threatens entire regionVideo of the week
The Secret History of the Global Financial Collapse
Book of the week (purchase via this link to support this site)
Kramer, M., THE WAR ON ERROR: ISRAEL, ISLAM AND THE MIDDLE EAST
No comments:
Post a Comment