any DBAs out there?

Post Reply
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post by Malcolm »

Have you ever seriously used an E-R diagram for anything? It's like taking a logical design scheme and shooting out its kneecaps.
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
Mommy Dearest
Posts: 1393
Joined: Tue May 25, 2004 12:59 pm

Post by Mommy Dearest »

Malcolm wrote:Have you ever seriously used an E-R diagram for anything? It's like taking a logical design scheme and shooting out its kneecaps.
As in "Doing Business As"?
Top
thibodeaux
Posts: 8121
Joined: Thu May 20, 2004 7:32 pm

Post by thibodeaux »

Data-Base Administrator.

I am not a DBA, but I've done my share of table and proc development. Never done an ERD. Foreign Key? Wuzzat?
Top
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post by Malcolm »

thibodeaux wrote:Data-Base Administrator.

I am not a DBA, but I've done my share of table and proc development. Never done an ERD. Foreign Key? Wuzzat?
They just seem so damned worthless to me, like someone intentionally went out of their way to make them bafflingly limited.

Fucking lame-ass database course.
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
TheCatt
Site Admin
Posts: 57678
Joined: Thu May 20, 2004 11:15 pm
Location: Cary, NC

Post by TheCatt »

I'm a fake DBA, but I only used ERDs as a developer. I usually would do a logical diagram, then follow with a physical table diagram. Used them for programs with over 15 entities, going up to 200-300 entities.

I like em, but almost all my development is very DB-centric, so getting the DB right matters a ton.



Edited By TheCatt on 1190465542
It's not me, it's someone else.
Top
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post by Malcolm »

Mayhaps it just reminds me too much of the fucking UML diagrams in the equally fucking lame-ass software engineering course.
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
TheCatt
Site Admin
Posts: 57678
Joined: Thu May 20, 2004 11:15 pm
Location: Cary, NC

Post by TheCatt »

Maybe. I just think of it as a map of the database. Helpful for designing ETL processes and such.
It's not me, it's someone else.
Top
GORDON
Site Admin
Posts: 56735
Joined: Sun Jun 06, 2004 10:43 pm
Location: DTManistan
Contact:
Contact GORDON

Post by GORDON »

Having come of age on an AS/400, I've always thought the job of "DBA" was a scam. I've never seen a dedicated DBA in a 400 shop, and I've been around and in some huge shops.
"Be bold, and mighty forces will come to your aid."
Top
TheCatt
Site Admin
Posts: 57678
Joined: Thu May 20, 2004 11:15 pm
Location: Cary, NC

Post by TheCatt »

Oracle is a scam.
It's not me, it's someone else.
Top
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post by Malcolm »

TheCatt wrote:Oracle is a scam.

So's auto insurance. But it still turns a profit.



Edited By Malcolm on 1190563709
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
Post Reply

Return to “Tech stuff”