Hi, Please, i need the design concepts of ASP knid of application.
We have a customer, he wants web base soultion architecture for ASP Application Service Provider) Model. ( web application) He will have many customers, with similars functionalities. Here what should be our design approch. We thought of some solutions as provided below: 1) Have Central database, single application, with different access privilages to the commonly developed application, which identifies, who is the customer, and for every record in the database will have additional field, say customer ID ( cleint ID). 2) Different database ( in the case of Oracle multiple instances, or separate database in the case of MS SQL), and virtual hosting of the application on the same web/application server. Some our doubts : without creating the multiple instances, how to separate the d/b, having similar tables, with same structure( is it possible of having same table sets on different table space on one single Oracle instance). But how to control our database access from our Java applicatiom ( May be JSP/Java Bean/Servlet). here while getting the connection we have to specify the SID/Database name, in single instance server, there will be only one database. I want to know, whether PostgreSQL will handle the situation, as a extention to your solution. Please, throw some light on me, to handle the ASP kind of application which will cater many customers ( both at application level and Back end level). Thanks, ebreddy =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
