Forums Register Login

database design problem for asp model

+Pie Number of slices to send: Send
Hi,
I have been facing this problem from several projects. We often need to design databases for ASP model with lots of users from multiple organizations. There are three obvious choices available to me.
1. create org key in all the tables to differentiate data from each org
2. create a set of tables for each org, then use a association org table to switch
3. create one database for each org, use a controller database to switch
Each of these three has some pros and cons. The first one is easier to maintain and implement. The last one will at least piss off DBAs.
I personally will choose either the first or the last. The main thing in the first choice that worries me is database table locking time.
I am sure many other people will face the same problem, what's your take on that?
His brain is the size of a cherry pit! About the size of this ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1024 times.
Similar Threads
Please suggest
Having Trouble with JTables setValue and changes
Multiple Tables In the Database -- Use Multiple Entity Beans?
can i use one entity bean to access more than one tables
EJB Using the Oracle Database
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 23:31:49.