Follow @DBDebunk
Follow @ThePostWest
My June post @All Analytics.
This may prove to be a trend, and while it will ease data analysts’
work, it also requires them to know and understand databases better,
rather than rely on IT staff. Since in my writings here and elsewhere I
demonstrate that even database professionals do not have a sufficient
grasp of data and database fundamentals -- those “invisible” aspects
that are not in any DBMS manual, or that you cannot get from just
working with a tool -- maybe this is a good time and place for database
education for analysts.
Read it all. (Please comment there, not here)
Friday, June 19, 2015
Sunday, June 14, 2015
The Cookbook Approach to Data Management
Follow @DBDebunk
Follow @ThePostWest
15 years ago I posted The Myth of Market Based Education @the old dbdebunk.com. Last week I deplored the substitution of tool training for education and increasingly young age at which it substitutes for education, preventing any independent and critical thinking rather than instilling it:
1. Quote of the Week
2. To Laugh or Cry?
15 years ago I posted The Myth of Market Based Education @the old dbdebunk.com. Last week I deplored the substitution of tool training for education and increasingly young age at which it substitutes for education, preventing any independent and critical thinking rather than instilling it:
... a systemic problem that perpetuates itself without a solution and worsens rather than improves, particularly with Google, Facebook, Twitter and Microsoft getting involved in the school and academic systems.Shortly thereafter
...the San Francisco School Board unanimously voted Tuesday to ensure every student in the district gets a computer science education, with coursework offered in every grade from preschool through high school, a first for a public school district. Tech companies, including Salesforce.com, as well as foundations and community groups, are expected to pitch in funding and other technical support to create the new coursework, equip schools and train staff to teach it.Basic computer literacy, perhaps, but computer science for pre-schoolers? Tech companies have a unique notion of the "science"--witness "data science"--they want to impart to young children. This week's quote is a description of it by one of my readers as experienced by his son:
1. Quote of the Week
My son, who is a sophomore in high school, had a class in Microsoft Excel and Access this semester. This "class" was created and delivered online, in the classroom, by Microsoft for the school systems. His "instructor" is a baseball coach. Anyway, he asked me for some help with a portion of the Access module on queries. The "lesson," a set of step by step instructions with no explanations, instructs the student to use the "find duplicates" query wizard. Directly following that was the "find unmatched" (meaning in their terms rows in one table that should also be in another table but are not) query wizard. This is yet another example proving your point.I rest my case.
2. To Laugh or Cry?
Small Data - Too many relationships spoil the model...3. Online Debunkings
Something doesn't make sense4. Interesting Elsewhere
How to interview an Oracle DBA candidate (NOT)5. And now for something completely different
Sunday, June 7, 2015
Forward to the Past: Sounds Familiar?
Follow @DBDebunk
Follow @ThePostWest
Working on a book of 2000-2006 material from the old dbdebunk.com, I came across the following 10/29/04 exchange. MySQL has probably improved--although, adding features post-hoc to products that were not explicitly designed for such upgrading is always problematic--more complex and limited than necessary. However, education and foundation knowledge have become worse and, from a foundational perspective, so have products and practices.
Working on a book of 2000-2006 material from the old dbdebunk.com, I came across the following 10/29/04 exchange. MySQL has probably improved--although, adding features post-hoc to products that were not explicitly designed for such upgrading is always problematic--more complex and limited than necessary. However, education and foundation knowledge have become worse and, from a foundational perspective, so have products and practices.
JG: fell asleep dreaming of column constraints. I woke up thinking of foreign keys. I've been married to MySQL for so long that I had no idea all of these other things were possible!Astounded? Nah, standard operating procedure.
Using a database and not knowing about foreign keys? My immediate reaction was to be astounded. However, he just happens to have begun with the least-robust database product on the market, and his learning is (evidently) confined to whatever product he happens to be using.
Saturday, May 30, 2015
Weekly Update
Follow @DBDebunk
Follow @ThePostWest
1. Quote of the Week
2. To Laugh or Cry?
4. Interesting Elsewhere
5. And now for something completely different
1. Quote of the Week
In this paper we briefly review some of these issues and then concentrate on the problem of generalizing the formal framework of the relational data model to include null values. A basic problem with null values is that they have many plausible interpretations.No, that's not the basic problem.
--Database Relations with Null Values, Bell Labs, 1983
2. To Laugh or Cry?
Relational table naming convention3. Online Debunkings
- Comments on "Table Constraints and Data Science"
- Comments on "1NF, Part 3: The Domain Imperative"
- Enterprise Data Modelling
4. Interesting Elsewhere
- Why even the most intelligent software architects don't understand the Relational Model
- Obfuscated SQL Contest Winners! (h/t Todd Everett)
5. And now for something completely different
Tuesday, May 26, 2015
R-table Constraints and Data Science
Follow @DBDebunk
Follow @ThePostWest
My May post @All Analytics.
I’ve often expressed skepticism here and elsewhere about “data science” as currently used and hyped. Science is about development, testing, and application of theories. Data science is about general theories of data. For example, "relational theory" is the application of logic and set theory to database management to guarantee provably logically correct data analysis results, yet it is absent from the list of desirable skills for “data scientists”.
Read it all. (Please comment there, not here)
My May post @All Analytics.
I’ve often expressed skepticism here and elsewhere about “data science” as currently used and hyped. Science is about development, testing, and application of theories. Data science is about general theories of data. For example, "relational theory" is the application of logic and set theory to database management to guarantee provably logically correct data analysis results, yet it is absent from the list of desirable skills for “data scientists”.
Read it all. (Please comment there, not here)
New Versions of All 6 Papers
Follow @DBDebunk
Follow @ThePostWest
I have just posted descriptions of all new versions of all six papers in the PRACTICAL DATABASE FOUNDATIONS Series:
#1: Business Modeling for Database Design
#2: The Costly Illusion: Normalization, Integrity and Performance
#3: The Last NULL in the Coffin: A Relational Solution to Missing Data
#4: The Key to Keys: A Matter of Identity
#5: Truly Relational: What It Really Means
#6: Domains: The Database Glue
The changes are significant and there are a few error corrections.
Since these are new versions, not revisions, the following applies:
For more details and how to order see PAPERS page.
I have just posted descriptions of all new versions of all six papers in the PRACTICAL DATABASE FOUNDATIONS Series:
#1: Business Modeling for Database Design
#2: The Costly Illusion: Normalization, Integrity and Performance
#3: The Last NULL in the Coffin: A Relational Solution to Missing Data
#4: The Key to Keys: A Matter of Identity
#5: Truly Relational: What It Really Means
#6: Domains: The Database Glue
The changes are significant and there are a few error corrections.
Since these are new versions, not revisions, the following applies:
- Those who ordered in 2015 get free copies.
- Those who ordered in 2014 get a 50% discount.
For more details and how to order see PAPERS page.
Sunday, May 17, 2015
Weekly Update
Follow @DBDebunk
Follow @ThePostWest
1. Quote of the Week
3. Online Debunkings
4. Interesting Elsewhere
5. And now for something completely different
1. Quote of the Week
He started his SQL Server career when he debuted as an accidental DBA in 2005. Seeing Reporting Services 2005 demoed for the first time sealed the deal, and it has been all data ever since, leaving the worlds of networking and systems admin behind. After being a full-time dev/operational DBA with everything since SQL 2000, he is now back to BI, as a Senior BI Engineer/Consultant. --Online Bio2. To Laugh or Cry?
- Relational table naming convention
- Database relationships
- Actions & Facts Revisited
- Null employee's proper surnameBasing Database Models in Reality A Blogger’s Challenge
3. Online Debunkings
4. Interesting Elsewhere
Obfuscated SQL Contest Winners!H/t Todd Everett.
5. And now for something completely different
Subscribe to:
Posts (Atom)