The Database Design Resource Center

Object Relational Overkill

by {name changed to protect the innocents}
(USA)

Perhaps you recognize the architect who thinks everything java is fantastically wonderful, but databases are a lot of trouble.

The java architect reduced the db design down to an "objects" table which could hold any kind of data and a "relationships" table that could describe any relationship between objects.

Implementing that in a top-drawer Rdbms was a mistake because inserting, updating or searching anything in that kind of structure was very dependent on the kind of object being manipulated. All the details (methods) were in java objects with multiple layers of inheritance and none of the business logic was in the db.

Though it performed badly, there was no convincing the architect to finess the details into multiple tables. He was busy redesigning, redeploying the java code whenever a new object type came along. "Besides," he said, "we can always deploy a new database" on another blade to overcome lagging database performance.

Comments for
Object Relational Overkill

Average Rating starstarstarstarstar

Click here to add your own comments

Mar 23, 2009
Rating
starstarstarstarstar
Candidate for a Darwin award
by: Anonymous

Humans like this "designer" should be prevented from breeding.

Jul 24, 2008
Rating
starstarstarstarstar
Idiots are everywhere
by: Alf Webmaster

Thanks for that. Yes, that's what happens when you don't know what you're doing...

Click here to add your own comments

Join in and write your own page! It's easy to do. How?
Simply click here to return to Worst Database Design Experience



Interview with
Donald Burleson

Interview with
Steven Feuerstein


What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:


Workshop

On rare occasions, I may perform a Database Design Workshop . Unfortunately, I am currently unable to, but maybe later...

Influence me

Influence the content on this site: I want to know what database information you need the most: Participate in my Database Design Content investigation. I would appreciate it if you took the time...

Database Normalization eBook:


Database Normalization eBook


XML RSS
Add to My Yahoo!
Add to My MSN
Add to Google


Site Build It!

ADD TO YOUR SOCIAL BOOKMARKS: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb

Copyright © 2004-2010 www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
*Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.