Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Web services database cluster structure and method thereof

A web service and database technology, applied in the field of web services, can solve problems such as portability and complexity

Inactive Publication Date: 2007-09-26
IBM CORP
View PDF0 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Web services database cluster structure and method thereof
  • Web services database cluster structure and method thereof
  • Web services database cluster structure and method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] overview

[0039] A data virtualization layer was developed to abstract the physical database instance from the application. The virtualization layer houses the data management and query routing delivery logic, and moves the data access logic from the application code to the middleware (such as an application server) that hosts the application.

[0040] The preferred J2EE technology for web application development is extended to provide scalable deployment of the database tier. The application layer deployed in application servers (such as IBM WebSphere and BEA Weblogic application server) is clustered in order to load balance web transactions, however, the database layer cannot be clustered using existing J2EE technology. Data objects or entity beans deployed in a J2EE architecture are by design attached to a single database instance, which leaves little option for clustering database instances by creating replicas or horizontally partitioned database clusters. Data ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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 ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06Q30/00G06F17/30H04L12/02H04L29/06
CPCG06F17/30575G06F16/27
Inventor V·S·巴特拉W-S·李
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products