Web services database cluster structure and method thereof

Abstract

There is disclosed configuring of clustered web services nodes accessing a common database, including implementing a data virtualization layer at each node to abstract an instance of the database from a web service application. In one embodiment, at each node is performed creating a first, data virtualization entity bean having all read and write operations of an application-developed (master) entity bean, creating a second entity bean that carries only the read operations of the master entity bean and addresses the replica instance, receiving an operation request at the first entity bean, and routing a request to either the master entity bean or the second entity bean depending upon the requested operation to access the respective database instance. In another embodiment, at each node is performed implementing an empty database instance having a schema matching the common database, identifying a relevant partitioning in a query utilizing the empty database, and routing the query to a respective partitioned database instance.

Description

technical field [0001] The present invention relates to web services utilizing database clusters, for example to enable electronic commerce. Background technique [0002] E-commerce is increasingly becoming a part of everyday life. Procurement inquiries and purchase orders for goods and services are generated through electronic networks, most commonly through the public Internet. High-volume e-commerce applications require an infrastructure that provides high availability, guaranteed quality of service (QoS) and response time with load balancing, fault tolerance, and stability for high availability. Such systems are deployed on clusters, where cluster nodes host application servers (and applications) and database instances (primary and replica) to share the workload and provide high availability and improved response time. [0003] One known method for implementing e-commerce applications is J2EE (Java 2 Platform, Enterprise Edition, published by Sun Microsystems). J2EE ...

AI Technical Summary

Problems solved by technology

[0022] 2. Database products that offer data partitioning may require additional database administration because the solution is an extension to standard database technology

The lack of support for the above features makes J2EE applications tightly coupled with database vendors, or the data partition logic must be encapsulated in the application layer, which complicates application portability

Images