Title:  
SybXML

Author:
Subramani Chellamuthu

Abstract:
SybXML is tool to generate XML schema based on Sybase database and vice
versa. The additional feature of this tool is to transfer data from XML
documents with optionally validate with inline XML schema into a Sybase
table and generate a XML document with optional inline XML schema based on
the Sybase table.


What:
SybXML is primarily used to generate XML schemas for Sybase database
structure and create database definition language for a given XML schema.
Both Sybase database schema and any single table structure will be able to
convert into a XML schema. This tool will facilitate and evolve such that
it will be a common platform for the database design based on XML schema.
This XML schema can then be converted to real database structures. This is
by creating a XML schema, which can be shared across various applications
that run on different database types. It will use an object-related
mapping and includes XML based mapping language.

This application will have two add-on features, one is transferring data
between XML document and a Sybase table and other one is to generated a
Java Bean for a given single table with single column primary key.

Why: 
Basically I am trying to create a tool that will help a developer in Java,
XML and database based application. Even during the requirement phase, the
database design can be completed without worrying about the type of the
database.

At my work, I support two application, both of them are currently moving
into web-based application. We spend lot of time in prototyping report
using sample XML. Manually generating the xml based on the SQL query is
cumbersome and tedious.

With this tool, it will make the screen and report prototyping faster and
easier.

How:
Design standpoint, I am going to focus on the test cases first, i.e. what
is going to be the output and the input. That will leave the major task of
the process, which can be easily tackled once the test cases are clear.
Technology wise, of course I am using Java and XML schema. But at this
point I am not sure of the any other technology evolution of this project.
This whole idea came to my mind yesterday when I was struggling with
design of XML structure and the illustration for a new web based report.
Thus I am changing the topic of my project from Business Integration
engine, though BIE is some sort of similar one importing BPML to BPEL.

Questions:
Please suggest any improvements /alterations to make this a complete tool
to generate XML schema and DDL.