Wednesday, July 30, 2014

Big Data & Analytics: Table Interpretations

My July Post @All Analytics

When, for analytical purposes, you combine data extracted from database tables whose real-world meaning you don't know, you're asking for trouble. The meaning, after all, isn't in the tables. Rather, the meaning is contained in the business rules on the basis of which the tables were designed and which are approximated in the database with integrity constraints. Interpreting results on the basis of just visual inspection of the tables therefore involves guesswork and is almost certain to be wrong.

Read it all. (And please comment there, not here)


Sunday, July 27, 2014

Weekly Update UPDATED

1. Quote of the Week
Q: In a nutshell, what does RDF based Linked Data facilitate?
A: The ability to find and describe stuff using attributes (relations, properties, features, fields, characteristics).

2. To Laugh or Cry?
Data Model now offers Relationship Modeling

3. Online Debunking
Data Vaults - Why Or Why Not

4. Elsewhere
5. And now for something completely different

In its decline, theWest is becoming impotent and increasingly irrelevant in world affairs e.g. Russia, Syria, Iraq, Afghanistan, China, Libya, you name it. It is taking hypocritically its frustration on Israel and the Jews--its classic scapegoating during crises--reinforced by fear from internal Islam.

I am restarting my PostWest blog and will link regularly to posts in this section.

Critical comments that
  • fail to show my facts to be false; or, if they are true, that my conclusions do not follow;
  • are posted anonymously
will not be published and addressed.

Sunday, July 6, 2014

Weekly Update

1. Quote of the Week
Don't confuse Data(base) Modeling with Business Modeling. All DBA are correct when they are talking about Database Modeling. If you want to ensure unique record on Business level, just add a unique composite index. (not as Key). But far to often, a unique record on business level is not ALWAYS unique (only most of the time)

2. To Laugh or Cry?
Create database vs schema

3. Online Debunkings

4. Interesting Elsewhere

5. And now for something completely different
 And if you like what they're doing to San Francisco, you'll love what they'll do to other cities:
Google Exec Rises Ire in Portland
 Symptoms of societal malaise.

View My Stats