Follow @DBDebunk
Follow @ThePostWest
"To Laugh or Cry?" Test Your Foundation Knowledge
Tuesday, January 20, 2015 6:30 PM
Microsoft
1065 La Avenida
Building 1
Mountain View, CA
(map)
RSVP here
You are a DBMS ace, able to squeeze every ounce of performance out of it. But how about your foundation knowledge, how good a grasp of data fundamentals do you possess? Are you a data management ace too?
The two are distinct and while the former is necessary for a career, it is insufficient for an informed, intelligent, reliable and productive data management practice. The industry is full of myths, misconceptions and traps and without foundation knowledge you are unable to see through them.
This is your opportunity to test yourself. If your instinct is neither to laugh, nor to cry at the contents of this presentation, education may be in order.
• How misconceptions that you are unaware of, lead you astray;
• Practical implications thereof;
• How foundation knowledge, scarce in the industry, is the only way to see through them.
Monday, January 5, 2015
Understand Property Rules & Domains
Follow @DBDebunk
Follow @ThePostWest
My January post @All Analytics
To ensure operations on database tables or extracts thereof make sense and result interpretation is correct, the analyst must know what the tables mean. The meaning is not in the tables, but in the business rules it is associated with it, which may be undocumented.
Read it all. (Please comment there, not here)
My January post @All Analytics
To ensure operations on database tables or extracts thereof make sense and result interpretation is correct, the analyst must know what the tables mean. The meaning is not in the tables, but in the business rules it is associated with it, which may be undocumented.
Read it all. (Please comment there, not here)
Thursday, January 1, 2015
New Version and Revision of Papers
Follow @DBDebunk
Follow @ThePostWest
Pls see the PAPERS page for current version of this paper, when it becomes available.
Pls see the PAPERS page for current version of this paper, when it becomes available.
Thursday, December 11, 2014
Happy Holidays!
Follow @DBDebunk
Follow @ThePostWest
To all my readers and colleagues, Happy Hanukkah, Merry Xmas and a healthy, prosperous and Happy New Year!!!!
Sunday, December 7, 2014
Weekly Update
Follow @DBDebunk
Follow @ThePostWest
1. Quote of the Week
2. To Laugh or Cry?
3. Online debunkings
4. Interesting elsewhere
5. And now for something completely different
Fascinating:
About The PostWest:
1. Quote of the Week
Relational is/was a way for humans to understand how computers could organise data. From a day back when disks were expensive. --LinkedIn.com
2. To Laugh or Cry?
How Google Will Use Firebase to Supercharge Its Cloud ComputingAnother reinvention of a (square) weheel.
3. Online debunkings
Calendar supertype
4. Interesting elsewhere
On Persistence and Data ManagementAn oldie but goodie; check out my comment.
5. And now for something completely different
Fascinating:
John Cleese on the Black Knight and Douglas Adams' High Heels
About The PostWest:
White House exempts Syria airstrikes from tight standards on civilian deathsRemember all the fuss about Israel not doing enough to prevent civilian deaths? The hypocrisy!
Wednesday, December 3, 2014
Analytics & SQL Tables
Follow @DBDebunk
Follow @ThePostWest
My December blog @All Analytics.
Manipulating/extracting data from SQL databases and interpreting results without knowledge of what the source tables mean is almost certain to lead analysis astray. To ensure sensible analysis and properly interpreted results, the conscientious analyst may have to do some digging that requires basic database knowledge. Here's why.
Read it all. (Please comment there, not here)
Manipulating/extracting data from SQL databases and interpreting results without knowledge of what the source tables mean is almost certain to lead analysis astray. To ensure sensible analysis and properly interpreted results, the conscientious analyst may have to do some digging that requires basic database knowledge. Here's why.
Read it all. (Please comment there, not here)
Sunday, November 30, 2014
SQL's Incomplete Set-lization, Part 2
Follow @DBDebunk
Follow @ThePostWest
[FP: Two weeks ago I posted a debunking of an article blaming some SQL sins. Erwin has some additional comments.]
by Erwin Smout
[FP: Two weeks ago I posted a debunking of an article blaming some SQL sins. Erwin has some additional comments.]
1. Multisets
From the original article:
It is beyond any doubt that set is the basis of mass data computation. Although SQL has the concept of set, it is limited to describing simple result set, and it does not take the set as a basic data type to enlarge its application scope.
Sidestepping several possible nitpicks here, such as e.g., that SQL allows duplicate rows and thus, in its basic form, has bag, not set algebra, the intention behind the complaint here is mostly accurate.
Subscribe to:
Posts (Atom)