SOA4DDB - Service Oriented Architecture (SOA) for Distributed Database
This is my final year reserch project. main objective of ths was to Develop an architecture and design methodology to model any standard RDBMS server as an XML-RPC based web service and extend these concepts to develop a new architectural design for high performance and loosely coupled distributed databases systems. Web services technologies are fundamentally changing the software industry, making the role of enterprise IT organizations more strategic, and recasting the software vendor-consumer relationship. Relational database management systems (RDBMS) Are still play significant role in enterprise computing by providing the backend facilities. Despite of traditional applications, distributed architectures are compulsory design issue in many enterprise application and RDBMS systems. XML is a one of the major factor effect to the success of web services also XML can be used as a data format for passing data between components on deferent platforms. Converting standard database operations such as update, query in to web services is the foremost objective of this project. Available web service standard such as SOAP, WSDL and Reliable messaging were studied and a successful methodology to perform above requirement was proposed.
STEP 1 -- Generating database model
Exposing a existing database into DB2XMLEngine. DB2XMLEngine collect all the required Meta data from given database and construct a xml model called
STEP 2 - code generation
STEP3 -3. Compiling and packaging
Generated Ant build file consist with targets for compiling, packaging the source code. Again AntBuilder compile all the .java file and package into AXIS2 specific packaging format called Apache Archive File (.aar) .Then the generated aar file deployed on AXIS2 repository. And can be accessed as a standers web service
Distributed transaction management architecture
- WSADL 1.1 , SOAP 1.2 , XMLSchema2 .0 , XSLT 2
- Apache AXIS2/Java 1.3 verstion.
- Apache ANT 1.7
- MySQL and MsSQLServer 2000