xsd2pgschema online with Winfy

We have hosted the application xsd2pgschema in order to run this application in our online workstations with Wine or directly.

Quick description about xsd2pgschema:

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 convesion 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 discletion. Moreover, differential upate, 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

Audience: Information Technology, Science/Research.
User interface: Console/Terminal.
Programming Language: Unix Shell, Java.
Database Environment: PostgreSQL (pgsql).

Categories: