Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / DB Theory / March 2008

Tip: Looking for answers? Try searching our database.

Theory and practice

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tip - 07 Mar 2008 06:44 GMT
1. If you were asked to specify, based on your experience, what are
the top 10 data management problems rooted in poor foundational
knowledge, what would those be?

2. What kind of specific instances in practice that exemplify those
problems are sufficiently common, frequent and costly to raise
interest in proper education as a way to solve them. Any chance?
Roy Hann - 07 Mar 2008 07:35 GMT
> 1. If you were asked to specify, based on your experience, what are
> the top 10 data management problems rooted in poor foundational
> knowledge, what would those be?

I do a lot of product-specific training in the workplace.  Two weeks ago I
was training a roomful of university graduates for one of the big
consultancies.  One of the exercises incidentally asked the students to
compute a percentage.  I had to explain how.

Faced with that, it hardly seems worth considering your question above.

Ask me again in a few weeks when I've forgotten the experience.

> 2. What kind of specific instances in practice that exemplify those
> problems are sufficiently common, frequent and costly to raise
> interest in proper education as a way to solve them. Any chance?

Roy
Bob Badour - 07 Mar 2008 13:21 GMT
>>1. If you were asked to specify, based on your experience, what are
>>the top 10 data management problems rooted in poor foundational
[quoted text clipped - 8 lines]
>
> Ask me again in a few weeks when I've forgotten the experience.

Ah, but I bet they know how to put together an impressive PowerPoint slide.
David Cressey - 07 Mar 2008 12:27 GMT
> 1. If you were asked to specify, based on your experience, what are
> the top 10 data management problems rooted in poor foundational
[quoted text clipped - 3 lines]
> problems are sufficiently common, frequent and costly to raise
> interest in proper education as a way to solve them. Any chance?

There was a topic in this newsgroup about 4 years ago entitled "Stupid
database tricks".  You should be able to find most of the comments in that
topic by searching google groups,  which keeps old records of group
commentary.

That topic pretty well covered the ground of commonly occurring and very
destructive habits.
Marshall - 07 Mar 2008 14:56 GMT
> There was a topic in this newsgroup about 4 years ago entitled "Stupid
> database tricks".

I will never forget that thread as long as I live.

Marshall
Bob Badour - 07 Mar 2008 15:10 GMT
>>There was a topic in this newsgroup about 4 years ago entitled "Stupid
>>database tricks".
>
> I will never forget that thread as long as I live.

What was most memorable about it?
Marshall - 07 Mar 2008 17:13 GMT
> >>There was a topic in this newsgroup about 4 years ago entitled "Stupid
> >>database tricks".
>
> > I will never forget that thread as long as I live.
>
> What was most memorable about it?

I don't know if I can fully convey the depth of feeling that
thread brought me.

I had been working with SQL long enough that it was starting
to really gel for me. I really felt like I had a solid handle on it,
not just *how* to make it do stuff but *why* doing things one
way worked well and doing things a different way didn't work
well. Call me a solid journeyman at that point; a promising
intermediate, perhaps.

And I was starting to notice: people don't *get* it. It seemed like
no one got it. People I knew who I respected wanted to have
globally unique keys, or they wanted every table to have a
single integer primary key, even wanting to add them to tables
that were just two-fk join tables. Any of a host of crazy things.
One can just read the current thread with comp.object for
more examples.

I had only two hypotheses: either the entire world was mad, or
I was. Neither possibility was appealing.

Then that thread happened. And suddenly it was clear: I'm not
alone! Other people have the exact same problems, the same
frustrations. Even better: some of them are a lot further along
in this process, and I can learn from them. I am not speaking
of the problems of database theory, you understand. I am
speaking of the Curse of Cassandra.

Maybe it has become exaggerated in hindsight. Or perhaps
more likely, that thread has become emblematic of the entire
years-long process that I went through; shrunk in the machine
press of memory to a single cubic foot of twisted metal.

Still, when I run into those don't-get-it people, what appears
in my mind's eye is David Letterman, speaking in the voice
of David Cressey, reading off a five-by-eight index card,
dramatically and ironically announcing over a drumroll:

"And the number one stupid database trick: enforcing
integrity in the application."

And the audience applauds thunderously, and I am they
and they are I.

Marshall
JOG - 07 Mar 2008 17:54 GMT
> > >>There was a topic in this newsgroup about 4 years ago entitled "Stupid
> > >>database tricks".
[quoted text clipped - 46 lines]
> And the audience applauds thunderously, and I am they
> and they are I.

Waiter, I'll have a bit of whatever Marshall's just had please.

> Marshall
Marshall - 08 Mar 2008 04:24 GMT
> Waiter, I'll have a bit of whatever Marshall's just had please.

"Death by Elocution" -- a frothy chocolate concoction with raspberry
coulis.

Marshall
Gene Wirchenko - 08 Mar 2008 23:20 GMT
>> Waiter, I'll have a bit of whatever Marshall's just had please.
>
>"Death by Elocution" -- a frothy chocolate concoction with raspberry
>coulis.

    What a way to go.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
    I have preferences.
    You have biases.
    He/She has prejudices.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.