StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><a href="https://stackoverflow.com/questions/15683213/databse-architecture-single-db-vs-client-specific-db-for-building-enterprise-w/15697362#15697362">This</a> post has details on the database architecture for multitenancy.</p> <blockquote> <p>How can i design Multi tenant UI in Java ...</p> </blockquote> <p>This depends on the requirement. If the tenants views are completely different, different pages, layout, flow etc, then you can have a page per tenant. Usually the pages are similar except that the data view is different. In that case, same ui can be used across tenants and the view driven by tenant configuration. The view should be metadata driven. The view can be configurable by having a configuration mapping/db where each tenants configuration is stored. The tenant can choose what can be displayed during configuration.</p> <blockquote> <p>How can I design data access layer for separate database per tenant....</p> </blockquote> <p>This is controlled by the data source. You need to essentially differentiate the data connections and connection pools based on the tenant identifier. This can be achieved using a custom data access object where you instantiate the data source for different tenants. Hibernate provides support for multitenancy <a href="http://docs.jboss.org/hibernate/orm/4.1/devguide/en-US/html/ch16.html" rel="nofollow noreferrer">http://docs.jboss.org/hibernate/orm/4.1/devguide/en-US/html/ch16.html</a></p> <blockquote> <p>suggest me to choose technology stack in</p> </blockquote> <p>This is very broad question. I have some suggestions, take a look at <a href="https://stackoverflow.com/questions/15859245/architecture-for-saas-based-online-portal/16827027#16827027">this</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload