SSQML Wiki
A schema to describe ANSI/ISO SQL in XML and associated tools
Status: Alpha
Brought to you by:
conceptualizer
SSQML: Standard Structured Query Markup Language
Javadocs for JAXB libs can be found at http://www.devspringsoftware.com/ssqml/javadoc/
Need to regenerate these classes so that xsd:choice elements are expressed as true choice in java not just present all choices without restriction.
SSQML: Standard Structured Query Markup Language
This is an XML dialect that allows any valid SQL statement, clause, expression, predicate, or query to be expressed fully in XML based on an XML compliant schema.
The schema is based on Backus Normal Form (BNF) representations of ANSI-ISO/IEC SQL Standards; ISO/IEC 9075 :2003, ISO/IEC 9075 :2006, ISO/IEC 9075 :2008, ISO/IEC 9075-14 :2013 XML-Related Specifications (SQL/XML)
Does not include support for Embedded SQL Ada, SQL C, SQL COBOL, SQL Fortran, SQL MUMPS, SQL Pascal, or SQL PL/I programs. These may be added in future.
This schema was generated by automation taking the SQL BNFs as input. It was then run through schema validators and manually modified further to result in a valid schema.
The schema was designed such that if an instance document has its tags removed and the order of the content preserved, a valid SQL statement or fragment will be left.
See schema main annotation for further info.
Last edit: ConceptExplorer 2013-03-28
I am trying to break up the initial single ssqml.xsd into several namespaces. This should be done some time early next week. At minimum, the static string types, enumerated types, and simpleType types will each be placed in their own schema under their own namespace. That still leaves over a thousand types in the core schema. In order to make this subsequent core more manageable also, it will need to be carefully organized into several smaller schemas as well but these will have to be based on the substantive meaning behind the types and will have to take into account dependencies such that no circular dependencies are created.
Not going to break up schema right now. Maybe later if I get complaints about it being too big.
Last edit: ConceptExplorer 2013-04-22