Have you ever needed to maintain and document your SQL database?
Have you coded errors in an SQL query?
Do you need to support multiple database vendors?
Are you tired of re-typing long table definitions?
Do you hand-code Java objects to map onto your database tables?
If you answered YES to any of the above, then you need ZsqlML.
ZsqlML is defined as an XML DTD allowing you to specify a relational database structure using an XML object hierarchy.
This ZsqlML database definition can be transformed using XSLT transformations into SQL script that can then be used to initialize a newly created database. The current archives supports the PostgreSQL database, but additional databases can easily be supported.
The ZSQL project also provides an XSL-FO style-sheet to generate PDF documentation from the database definition file, thereby ensuring that the database structure is clearly and accurately documented.
Finally, using the provided Java proxy class generation stylesheet, a complete type-safe Java-based object model is generated to mirror your database structure for easy and safe integration with your existing Java applications.
As with all software tools, additional applications for a standardised database structural definition are always possible, and furthermore, we welcome all suggestions and contributions.
This software package is governed by the GNU Lesser General Public Licence.
You are free to use this software and also to contribute to its ongoing development. In all cases, you must retain the copyright and owner file headers, and ensure that credit for this work is correctly acknowledged.
ZsqlML has been tested using Apache XML technologies, including the following:
|ZSQL Package Manifest:|
|Package documentation file|
|Package licence file|
|XML Document Type Definition|
|ZsqlML -> PostgresSQL Database Setup Script|
|ZsqlML -> PostgresSQL Database Reset Script.
This script can be used in test environments to re-initialize the database
|ZsqlML -> PDF|
|ZsqlML Shared templates|
|Sample ZsqlML database definition file|
In the spirit of Open Source development, we welcome your comments and feedback on ZSQL.
The project source files, and other information, can be found at sourceforge.net/projects/zsqlml.Feel free to join either the users or developers mailing lists and send us your contributions and suggestions. All contributions will be acknowledged in the readme file
Moderator: Adrian Geissel (Zenark)
Some things to do:
In keeping with the tradition of OSS projects, please check in the FAQ before contacting the mailing lists
Please visit the project page on SourceForge.net
The work invested in this project to-date has been sponsored by ZENARK, creators of ZDAM - Digital Asset Management.
© Copyright ZENARK - All Rights Reserved.
Last Updated: 27th-November-2001 (AG)