I have corrected a mistake in For Codd's Sake: a mathematical relation is not the Cartesian product (CP) of the domains over which it is defined. Two readers correctly pointed out what I actually wrote myself in my business modeling paper:
Mathematically, a relation on domains—which are sets of values of a type—is a subset of the Cartesian product of the domains.Note that the whole CP is also a subset, so it is also a relation, which happens to have useful applicability to business modeling and database design. In the database context, it can be pictured as the pool of all possible rows--past, present and future--for a R-tablevar defined by the domains' types. A database R-table is the set of actual rows at any point in time that is consistent with the set of all integrity constraints to which the R-table is subject (see Business Modeling for Database Design).
1. Quote of the Week
NoSQL usant correct m'y indeed totof n'y most of the dev ans devops who clearly thing nosql Means they will ne a le to do whatever they wants ans still have answers to their twisted query in a correct time. Those people see nosql as the mean to get ris of DBAs. And il not kiddin since it's happening right now un many companies i know of. --LinkedIn.com
2. To Laugh or Cry?
- Database Design Patterns
- Will Pattern Discovery Systems Trump Analyst's Rules-Based Models
- How do we do data modeling in NoSQL DB and Big Data
4. Interesting Elsewhere
5. And now for something completely different
- Beyonce and Miley Cyrus studies offered at US colleges
- Better than Scientology: The new Zuckerberg-based religion
Do you like this post? Please link back to this article by copying one of the codes below.URL: HTML link code: BB (forum) link code: