The Database Design Resource Center

Object Relational Overkill

by {name changed to protect the innocents}

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

Nov 05, 2015
its quality NEW
by: Anonymous

SRSG is the pioneer to offer full-service basket of broadcast IT and media technology products and services.
Apple service center Mumbai
Dejero 20/20 Transmitter
ipad service center in Delhi
Mac pro service center in Kolkata
Media office interiors

Oct 25, 2015
sophisticated points NEW
by: Eric Abron

Compared to the information I've read on the theme, the one is replete with sophisticated points of view. The website routinely suggests a ton of fascinating materials for an excellent academic paper work.

Oct 06, 2015
Good post NEW
by: Ms. Sincere Thiel

You are a great blogger!

When you started your first entries?
I also try to develop my site (Scary Halloween Costumes), but I can't adverstand how you write so great articles.
Could I suggest to place some ads on your blog? I really love your style and your audience, I think halloween costumes will be interested for them.
I will you pay the amount you want, answer me, please! Thank you!

Aug 17, 2015
thanks NEW
by: Carol T. McHale

I am really enjoying reading your well written articles. I think you spend numerous effort and time updating your site. I have bookmarked it and I am taking a look ahead to reading new articles.

Aug 13, 2015
SQL database NEW
by: Betty M. Durkin

Man, you rock. Your website amazing. I've found needed information for my term paper. And provided images are going to make my life much more easily at my Database class! Thanks to editing services I found you)

Jun 13, 2015
Good post NEW
by: Ms. Tatyana Lang

Hello! Many thanks for your site!
Could you help me, please? I want to share your article on my site Findema is it possible?

I will link for you as an author! Thanks for answering!

Jun 11, 2015
Good post NEW
by: Mr. Adan Nolan

Hi! You have an amazing niche site!
May I ask to do a favor for me, please? I also have a site (about halloween costumes) and it will be great if I cound share one of your article on my blog.

Is it possible? I will link for you as an author! Thanks for answering!

Jun 03, 2015
Education NEW
by: Anonymous

Education tells people the value of their single life alone. As many of the people think about the rush essay services for their life as just because they don’t have any friend so that they are dumb. While education let people know the power of themselves.

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

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

Jul 24, 2008
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.

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

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

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

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: 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.