Comments
Table Constraints and Data Science
View Comments: Newest First | Oldest First | Threaded View
Re: The Data Scientist: Classical vs. Commercial Understanding of The Database
  • 7/12/2015 2:59:22 AM
NO RATINGS

Amazing .  I am beginning to understand just how bad this situation actually is - I am getting my "RDM second wind"  so to speak, so the true understanding of these concepts is a challenge I intend to keep chipping away at.   

 

I will certainly start reading your papers on the subject.   I love intellectual challenges and this is certainly one of them.  Thank you for your guidance on a subject that has stumped many brighter than I. 

Re: The Data Scientist: Classical vs. Commercial Understanding of The Database
  • 7/12/2015 2:36:38 AM
NO RATINGS

Actually, SQL is not really relational--the people who designed it at IBM did not understand the RDM either. This is a very serious problem, as most practitioners assume it is and don't realize that in fact the guarantee of correctness of RDM is lost with SQL.

I would be very careful with what you read online about RDM--more often than not it is misleading or wrong. I strongly recommend my papers.

 

The Data Scientist: Classical vs. Commercial Understanding of The Database
  • 7/12/2015 1:13:10 AM
NO RATINGS

"...A true data scientist must master relational theory, yet no long lists of desirable skills include it. Without it, he is unaware of the risk factors for data analysis in SQL databases and how to eliminate or minimize their effects, neither can he assume on database designers, data administrators or application developers to do it for him."


After reviewing the components of Relational Theory, I can now appreiate and support this statement.

I admit that I had not fully appreciated the importance of relational theory as it relates to the true understanding of Databases and how it is the basis of SQL. After doing some research of my own https://en.wikibooks.org/wiki/Relational_Database_Design/Basic_Concepts

I wonder how many who consider themselves Data Scientist (or potentially one ) actually appreciate and understand importance of relational theory themselves ?  

Since this is the first I have heard of this argument, I would guess not many. The bar for this function just became a little higher.

Thanks for considerable food for thought and continuing education Fabian.



INFORMATION RESOURCES
ANALYTICS IN ACTION
CARTERTOONS
VIEW ALL +
QUICK POLL
VIEW ALL +