Thursday, July 22, 2010

"If I can't picture it, I can't understand it." - Albert Einstein

New book recommendation:
Refactoring SQL Applications by Stephan Faroult
I found the book easy to read, well thought out and covers efficiently designing code to access the database, efficiently designing SQL and how to refactor existing applications and testing the results for accuracy and performance. Excellent book. What's that have to do with pictures and visualization? Stephan Faroult includes some new and innovative ways to visually represent SQL statements in such a way as to see patterns and problems. Look to see these methods in a future version of DB Optimizer! In discussion DB Optimizer with Stephan, he mention a quote that rings so true for me:

"If I can't picture it, I can't understand it." - Albert Einstein:

Along the same lines
"It is impossible to even think without a mental picture." - Aristotle:
"Man's mind cannot understand thoughts without images of them." - Thomas Aqunias:
"The evolution of images is a kind of intermediate between that of the perceptions and that of the intelligence." - Jean Piaget:

Mathematics is cognitive process-thinking-that requires the dual coding of imagery and language. Imagery is fundamental to the process of thinking with numbers. Albert Einstein, whose theories of relativity helped explain our universe, used imagery as the base for his mental processing and problem solving. Perhaps he summarized the importance of imagery best when he said, "If I can't picture it, I can't understand it." - NANCI BELL AND KIMBERLY TULEY

One of my favorite examples of the power of graphics to easily, quickly and powerful display quantitative information is Anscombe's Quartet. From http://en.wikipedia.org/wiki/Anscombe's_quartet
Anscombe's Quartet
IIIIIIIV
xyxyxyxy
10.08.0410.09.1410.07.468.06.58
8.06.958.08.148.06.778.05.76
13.07.5813.08.7413.012.748.07.71
9.08.819.08.779.07.118.08.84
11.08.3311.09.2611.07.818.08.47
14.09.9614.08.1014.08.848.07.04
6.07.246.06.136.06.088.05.25
4.04.264.03.104.05.3919.012.50
12.010.8412.09.1312.08.158.05.56
7.04.827.07.267.06.428.07.91
5.05.685.04.745.05.738.06.89


Edward Tufte uses this example from Anscombe to show 4 datasets of x
and y that have the same mean, standard deviation, and regression
line, but which are qualitatively different. - http://matplotlib.sourceforge.net/examples/pylab_examples/anscombe.html

No comments:

Post a Comment