Fabian Pascal

Data Fundamentals for Analysts: Nested Facts and the (1st) Normal Form

NO RATINGS
View Comments: Newest First | Oldest First | Threaded View
dbdebunker
User Rank
Data Doctor
Re: Had a laugh
dbdebunker   5/6/2016 11:30:05 AM
NO RATINGS
Let's hope the users will be too :).

magneticnorth0
User Rank
Data Doctor
Re: Had a laugh
magneticnorth0   5/6/2016 2:53:15 AM
NO RATINGS
John Cleese explains how it could be: bigthink.com/videos/john-cleese-on-political-correctness

I'm just thankful that my next database project is building the database from scratch.

dbdebunker
User Rank
Data Doctor
Re: Had a laugh
dbdebunker   5/1/2016 2:43:15 AM
NO RATINGS
It may have been in the past for you, but I assure you the vast majority of databases are not properly designed today. And that is not laughing matter.

magneticnorth0
User Rank
Data Doctor
Had a laugh
magneticnorth0   4/30/2016 9:22:59 PM
NO RATINGS
I laughed when I saw your title because, years ago, I had to work with a database that was in dire need of normalization. It was hell. I wasn't laughing then, but I'm glad that it's now in the past.

Information Resources
More Blogs from Fabian Pascal
Data warehouses are essentially databases biased for particular data applications and against others. They are rooted in poor database foundation knowledge and logical-physical confusion.
Analysts should avoid relying on techniques that undermine the soundness of database design.
The emphasis on coding in place of education obscures and disregards the core practical objective of database management to minimize programming.
Those delving into data science have to learn the important difference between prediction and explanation, as we discovered in post-election discussions and finger-pointing.
Don't be fooled by the promises that denormalization in data management will provide performance gains at no cost. The real cost will be at the expense of analytics.
Radio Show
A2 Conversations
UPCOMING
Jessica Davis
Monetize Your Data: Turning Insights Into Action


3/29/2017   REGISTER   0
UPCOMING
Jessica Davis
The Art of Psycho-demographic Analytics


5/23/2017   REGISTER   0
ARCHIVE
James M. Connolly
Evolution of the Data Scientist Role


3/23/2017  LISTEN   31
ARCHIVE
Jessica Davis
Data Analysts in Training: Meeting Tomorrow's Demand


3/8/2017  LISTEN   63
ARCHIVE
Jessica Davis
Our Bodies, Our Data: Medical Records For Sale


2/21/2017  LISTEN   63
ARCHIVE
Jessica Davis
Energy Analytics: Using Data to Find Savings


2/14/2017  LISTEN   44
ARCHIVE
Jessica Davis
Sharpen Your Analytics & Data Management Strategy


2/8/2017  LISTEN   74
ARCHIVE
Jessica Davis
Analytics: Make the Most of Data's Potential in 2017


1/19/2017  LISTEN   19
ARCHIVE
Jessica Davis
A2 Radio: Can You Trust Your Data?


12/20/2016  LISTEN   70
ARCHIVE
James M. Connolly
Retail Analytics: See Where Style Meets Statistics


12/6/2016  LISTEN   53
ARCHIVE
James M. Connolly
Why the IoT Matters to Your Business


11/29/2016  LISTEN   45
ARCHIVE
James M. Connolly
Will Data and Humans Become Friends in 2017?


11/22/2016  LISTEN   40
Information Resources
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS