A replication method and system for a computer system having multiple
database servers for at least one database, wherein database servers are
provided with a unified view of the data content. The method includes the
steps of establishing connections to said multiple database servers for
communicating with said database servers; distinguishing between read and
update query requests; and assigning queries to respective ones of said
multiple database servers to preserve the consistency of the respective
unified view of data of said multiple database servers in case of
receiving update queries. Assigning each new query includes the steps of
distinguishing between read and update queries, determining possible
assignments of that new query to one or more of said multiple database
servers, each said possible update query assignment to one of said
multiple database servers being based on a transaction-based replication
scheme to preserve the unified view data of said multiple database
servers; and assigning that new query to one of said multiple database
servers as a function of said possible assignments of that new query, to
preserve respective unified view of data of said multiple database
servers.