I would like to thank you Michael for the providing with the links. I will certainly look it through closely.
Bala, I would like to thank you also but have to underscore that the most common approach is appreciated. ANSY SQL to PL-SQL transformation is only example. I also need to transform the ANSY SQL2 to DB2 SQL notation. I think the XML schema approach would play here a very important role. For data mapping we need some power API like XML Schema. Maybe for the data transforming to another schema we'll need XSLT API. Working directly with data base schema is absolutely not necessary because I am interesting in building the database independent layer that would based on the most common ANSY SQL approach. Anyway, thank you all. I got something to think over. Dmitriy Bocharov Aplana Software >From: "Michael Fontan" <[EMAIL PROTECTED]> >Reply-To: "JDJList" <[EMAIL PROTECTED]> >To: "JDJList" <[EMAIL PROTECTED]> >Subject: [jdjlist] RE: SQL-XML-SQL >Date: Fri, 14 Jun 2002 07:48:53 +0200 > >Hi Dmitriy! > >I very often use a great CASE tool for DB Engineering called DB-MAIN. >www.db-main.be or http://www.info.fundp.ac.be/~dbm/ > >It implements a schema transformation approch which can transform a >entity-relationship schema to SQL DDL, DTD, and others. > >HTH > >Michael > >------------------------------------------------------------ > Michael Fontan [EMAIL PROTECTED] > Database Administrator > > >-----Original Message----- >From: Dmitriy Bocharov [mailto:[EMAIL PROTECTED]] >Sent: Thursday, June 13, 2002 5:15 PM >To: JDJList >Subject: [jdjlist] SQL-XML-SQL > > >Hello all. > >Just simple question. > >Does anybody know the flexible and power tool and/or API for describing the >SQL in terms of objects, building the element tree of the SQL, mapping it >to >the some XML schema and finally transforming the mapped SQL to the other >SQL >notations, for example to the PL-SQL? > >So the start point is: we have to generate the ANSI SQL from some >description. > >And finally we have to transform it to the some more specific SQL, for >example in PL-SQL. > >Any links to the sources and suggestions would be very appreciated. > > >Dmitriy Bocharov >Aplana Software Inc >[EMAIL PROTECTED] > > >To change your membership options, refer to: >http://www.sys-con.com/java/list.cfm _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
