Downloadxsd2pgschema 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 database can be optimized at user's discretion. Moreover, differential update, and XPath query evaluation over PostgreSQL are possible.
PgSchema server, serialized relational data model server, can be used to speed up the analysis of complex XML Schema.
Large XML file can be split through xmlsplitter, a flexible XML splitter based on XPath and StAX.
Features
- Conform to W3C XML Schema Definition Lauguage 1.1
- Generete complete PostgreSQL DDL from XML Schema 1.1 (relationally extended)
- Generate minimum PostgreSQL DDL from XML Schema 1.1 (inlining simple content)
- Optionally, reduce database size by mapping integers and decimals to primitive types
- Generate JSON Schema from XML Schema 1.1 (mapping strategy is selectable)
- Migrate XML data into relational database (PostgreSQL)
- Assist PostgreSQL index creation based on XML Schema and data size
- File conversion from XML to CSV, TSV, or JSON
- Indexing XML contents using Apache Lucene or Sphinx Search (xmlpipe2)
- Fast XML Schema analysis with help of PgSchema server
- Parallel data processing of multiple XML documents
- Parallel XML Schema validtion of multiple XML documents
- Validate XML Schema itself using W3C's schema for schema
- Differential update based on modification date and checksum
- Splitting large XML file for pre-processing
- XPath 1.0 parser being aware of XML Schema
- Query translation from XPath 1.0 to SQL (PostgreSQL)
- XPath 1.0 query evaluation to XML over PostgreSQL
- XPath 1.0 query evaluation to JSON over PostgreSQL
- Preserving document order as is
- No defects on information content including wild card
License
Apache License V2.0Follow xsd2pgschema
User Reviews
-
Extremely well documented and purpose driven tool.