View source for Modeler:13/XML Schema

To fully understand the relation between a conceptual model in CaseTalk and the XSD it can produce requires some in depth insight.

= Network structured model =
CaseTalk models the conceptual model similar to a network structure. The databases it can generate are also network like structures. A table can refer to multiple other tables, and they in turn can reference back to the originating root table. This is in contrast to a typical XML message structure which is mostly hierarchical in nature. A root element contains child elements and they in turn can contain child elements.
= XSD building blocks =
In XSD both building blocks are defined as the structure in which the final XML elements are to be presented. The building blocks consist of Simple Types and Complex Types. They are roughly comparable to Database Domains and Database Tables, or Class Attributes and Class Types.

= XML Message =
The final XML messages to be used to exchange structured information should follow a strictly defined structure. This structure can be defined in XML using "element" notations. This structure can depend on the message to be exchanged. They also vary depending on the information needs, similar to a SQL Query which can vary independently of the underlying Database structure.
= Two Directions =
A brief example is described below to illustrate the possible messages, communicating the same facts with different structures.

* A sensor (with number 627) measures on a day (1-1-2014) the weight (10000KG) of a train (with train number 9876).
* A sensor (with number 627) measures on a day (1-1-2014) the weight (11000KG) of a train (with train number 6478).
* A sensor (with number 627) measures on a day (2-1-2014) the weight (9000KG) of a train (with train number 8265).
* A sensor (with number 627)  measures on a day (2-1-2014) the weight (17000KG) of a train (with train number 3345).

These may be presented in an XML message like such:
<code>
  <Sensor id="627">
    <Day date="1-1-2014">
      <Train number="9876" weight="10000"/>
      <Train number="6478" weight="11000"/>
    </Dag>
    <Day date="2-1-2014">
      <Train number="8265" weight="9000"/>
      <Train number="3345" weight="17000"/>
    </Day>
  </Sensor>
</code>
But with similar information a completely different message might be appropriate, where not the sensor but the train itself is the root of our message:
<code>
  <Train id="9876">
    <Day date="1-1-2014">
      <Sensor id="627" weight="10000"/>
      <Sensor id="628" weight="10001"/>
      <Sensor id="629" weight="10002"/>
    </Day>
    <Day date="2-1-2014">
      <Sensor id="627" weight="9999"/>
      <Sensor id="628" weight="9998"/>
      <Sensor id="629" weight="9997"/>
    </Day>
  </Train>
</code>
The examples above illustrate that identification structure and element relations are independent from the representation or reporting.

= Working hours project =

== Order ==
An example showing the "Order" from the a generated XSD from model [https://www.casetalk.com/support/publish.html?catalog=ea5d2f1c4608232e07d3aa3d998e5135&name=WorkingHours Working Hours]:
[[File:XSD_Order.png]]

== Employee Order ==
CaseTalk generates XSD Simple and Complex Types which resemble the grouped Label Types, Fact Types and Object Types.  A more complex example taken from the Working Hours project is the following. It contains references to other complex types in the XSD while also declaring a primary identification constraint over them.
[[File:XSD_Order_Employee.png]]

== Name of Division ==
The Division is identified by a division_nr. A different grouped fact type is called "Name Of Division". This fact type contains two roles in FCO-IM: one is played by Division, the other by Division_Name. Both roles contain seperate unique constraints. This fact type is generated as a complex type containing element type references.

[[File:XSD_Name_Of_Division.png]]

= Background =
The information in the XSD follows the structure as described on this webpage:
[http://www.sparxsystems.com/resources/xml_schema_generation.html]

To make a final clarification, XSD's can be written in numerous manners. The w3schools contain a clear example and CaseTalk uses the last notation manner illustrated on this page:
[http://www.w3schools.com/schema/schema_complex.asp]

= Conclusion =

The information models in CaseTalk remain essential to document and structure the conceptual models. How than the information is reported, presented or used is up to further design and influenced by the actual information needs. Tools like Altova's XmlSpy or Sparkx Enterprise Architect remain useful to assemble the final message structure after generating the conceptual list and documentation from CaseTalk.