Follow @DBDebunk Follow @ThePostWest

Re-write:

• Normalization and Further Normalization Part 1: Databases Representing What
• Normalization and Further Normalization Part 2: If You Need Them, You're Doing It Wrong

 

Follow @DBDebunk Follow @ThePostWest

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
http://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.

Follow @DBDebunk Follow @ThePostWest

See series starting at:

The Principle of Orthogonal Database Design Part I

Follow @DBDebunk Follow @ThePostWest

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

Follow @DBDebunk Follow @ThePostWest

See series starting at:

The Principle of Orthogonal Database Design Part I

Follow @DBDebunk Follow @ThePostWest

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. I usually prefer recent items, but once in a while I come across old ones that I just cannot resist.This is one is from 2003 and thingd have gotten worse.

3.
The link to my latest All Analytics column was posted on the FP ONLINE page.

4.
Links to online exchanges I participated in were posted on the FP ONLINE page.Here's a comment from one:

From my experience, that traditional model has changed as data warehouses are being driven to near real time business intelligence and used as a common repository for disparate systems. The separation between front line systems and data warehouses was due to software and hardware demands could not handle a mixed work load, minimizing costs, plus application products requiring different data stores. The world has moved on. There are DBMS's that can handle mixed work loads with enormous scalability. Application products are becoming broader in business features. Pricing models have changed.

So the whole idea of a distinction between operational databases and data warehouses significant enough to require distinct database technologies, let alone deviations from the relational model, has not exactly held water, has it? Which was pretty predictable.

5.
Roy Hann has posted a comment on my article on SQL redundancy: Fabian Pascal on Ingres

6.
An  old blog post that links to a page on my old site no longer available, so I don't know what the subject was, but something that makes sense, for a change:  How do we tell truths that might hurt

7.
An interesting read on renting software: You Will Subscribe To, Not Buy Software. Worth reading for some of the negatives of the Cloud which, as is usually the case, are disregarded when a fad is being pushed to extremes.

Follow @DBDebunk Follow @ThePostWest

Recently I came across SQL: The way you write your query matters by Iggy Fernandez that refers to an old article of mine in which I compared the performance of five PC DBMSs executing seven different syntactic SQL formulations of the same query. I got wildly different timings, ranging from 15 seconds to 2500 seconds!