Relational database replication tool based on XML Schema
xsd2pgschema is a Java application suite, which converts XML Schema 1.1 (hierarchical data model) to PostgreSQL DDL (relational data model) and supports XML data migration into PostgreSQL based on the XML Schema without defects on information content. It also supports full-text indexing via either Apache Lucene or Sphinx Search utilizing the relational data model. File conversion from XML to CSV, TSV, or JSON is possible as well as mapping XML Schema to JSON Schema.
Obtained PostgreSQL...
....
-------
Requirements:
For the Java HTTP server:
- J2SE (SDK for compilation)
For the exampe web app:
- Apache2 with mod_rewrite and mod_proxy
Client-side for the web app:
- www browser supporting JS with jQuery
---
Setup:
- run Server.class from Java server files (java Server) in a terminal/console
- unpack example app files under/within your apache2 document root file structure
- open index.html (with a www browser, from a www server)
- observe terminal output