The Database Design Resource Center

seperate schema per customer with duplicate database objects in each

I worked as a DBA for a company that provided a custom application that ran on a single server and database instance. The company had several clients which connected to the centralized server and database instance. New customers were being added very quickly as the company grew.

The problem was that the database was designed such that each customer had a seperate schema with exact duplicate database objects (tables, indexes, stored procedures, etc.) in each schema for each customer. There was no reason for this approach and it sure made everything related to maintenance, admin a nightmare. Not to mention that this approach did not scale very well at all as new customers were added. There are so many things wrong with this approach and it caused so many headaches. I will leave this to your imagination.

A seperate schema for each customer could have been used for login security but there was no need to duplicate the database objects in each schema.



Comments for seperate schema per customer with duplicate database objects in each

Average Rating starstarstarstarstar

Click here to add your own comments

Jul 28, 2016
Rating
starstarstarstar
buy facebook likes NEW
by: nitinrathod

Are you aiming to boost the credibleness of the Face-book fan page? OR are you worried to be decieved when buying Facebook. http://www.likesrank.com/

Oct 31, 2015
Rating
starstarstarstar
database NEW
by: merlin

Great site and a great topic as well I really get amazed to read this. It’s really good. I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. celebrity clothing

Oct 28, 2015
Rating
starstarstarstarstar
database NEW
by: Henrietta Gill

Even i love this blog so much. As i has acquired more than a few designs which evokes me to turn out to be a excellent artist. I do great custom essay writing service and love to attract my desired designs in my free time. This blog gave me just right danger to learn the best advantage in drawing.
How to write a personal statement for college like a pro visit homepage

Oct 06, 2015
Rating
starstarstarstarstar
There was no NEW
by: Simon Collins

There was no reason for this approach and it sure made everything related to maintenance, admin a nightmare.

buy soundcloud followers

Jul 07, 2015
Rating
starstarstarstarstar
Lipozene Reviews NEW
by: Lipozene Reviews

Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something
Lipozene Reviews

Jun 12, 2015
Rating
starstarstarstarstar
Good post NEW
by: Elva Steuber

You have a great site!
I really would like to place some ads on your site, is it possible? My site is Costummer and I think your blog is an ideal place for adveritising.
Please, answer me and we'll discuss all details, I will pay nice money and really want to be on yout site!

Many thanks for answering!

May 12, 2015
Rating
starstarstarstarstar
great comments NEW
by: John

In many countries of the work we are looking those student who have much desire to get education but due to some financial problem they skip their study. So if any person have these problems in their studies then they should must visit this essay writing service reviews and get valuable information in their writing.

Mar 05, 2014
Rating
starstarstarstarstar
My collegues wanna do just the same thing NEW
by: Ann

I can totally agree with you and it must be a nightmare.
Our system now is still in planning stage and some of my collegues come out this idea and insist to do that.
I worked as a DBA for several years and cannot image how it will go with such a stupid DB design.
I really hope you can help me knock their heads and stop them to do so.

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 © 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.