DATABASE DEBUNKINGS

1.
The Quote of the Week was posted on the QUOTES page.

2.
A 'To Laugh or Cry' item was posted on the LAUGH/CRY page. The perils of online business modeling and database design and the time and effort imposed by the absence of foundation knowledge.

3.
Links to online exchanges I participated in were posted on the FP ONLINE page.

4.
The SCHEDULE page is now displaying an online monthly calendar which will be updated with my public seminars/lectures, with links to the details. The direct link is
pub11.bravenet.com/calendar/show.php?usernum=894201442.

5.
Recommendations:

• Added Nijssen's CONCEPTUAL SCHEMA AND RELATIONAL DATABASE DESIGN to the recommended books (available via the home page). It is, in my opinion, the best that can be done at the informal conceptual/business level.

•  Mosley, B., and Marks, P., Out of the Tar Pit. A good read on complexity and the benefits of the relational model (h/t Eric Kaun). 

• North, D., Our Obsession with Efficiency. A slide presentation on the subject.

6.
Miscellaneous:

• Somebody was endorsed for 'Thought Leadership'. I guess this reflects the increasing rarity of thinking and thinkers. Time to appoint Chief Thought Officers.

• Solutions Developer. An excellent example of the factotum approach to hiring and the exclusive demand for tool experience. Consider the probability that one person can be sufficiently competent in all the tools, without any guarantee of foundation knowledge. Related: A Data Warehouse quiz.

• Making Friends with Science provides some context for the previous two items:

Making friends is truly the beginning of making lasting memories. To make friends with science is truly to start with making good friends that make lasting memories about science. I'm starting a new revolution in the way science will be made socially for the community and ask the community to step in and help make science fun, engaging, real, social and most importantly lasting friendships.

This is the second part of a joint reply by David McGoveran (DM) and myself (FP) to Erwin Smout's (ES) comments on David's 4th part in our earlier series on database design, missing data, relational fidelity and SQL. You may have to go back and read the pertinent text to follow the exchange. The format is (a)quoted DM text (b)ES comments (c) DM response (d) FP comments, if any.

1.
The Quote of the Week was posted on the QUOTES page.

2.
A 'To Laugh or Cry' item was posted on the LAUGH/CRY page.

3.
Links to online exchanges I participated in were posted on the FP ONLINE page.

4. 
Looking for non-proprietary reference Semantic Data Model of Distribution Requirement Plan 

Is there any standard LDM exists for Automotives like CLDM or FSLDM 

Require database for banking customers  

Database table normalization

Detect a pattern? 

5.
My predicted consequences of the BigData and BI fad come to pass. On the one hand: 

Big Data News Roundup From Porn to Data-ism

On the other:

Trends Shows Problems of Big Data Without Context

What is the purpose of DENSITY in STATISTICS

This is the first part of a reply by David McGoveran and to Erwin Smout's comments on David's 4th part of our earlier series on database design, missing data, relational fidelity and SQL, with some comments by myself. The format is (a) quoted DM original text (b) ES comments (c) DM response (d) my comments, if any.