SCM-RM Mapping Definition in the Knowledge Base

Definition of relational model and SCM-RM mapping is done in the SCM knowledge base at the same time. The definition has been placed in the separate application domain “Production Implementation”. See SCM knowledge base definition for details about definition rules. The application domain contains only the application domain “ISCO_MES” representing a Manufacturing Execution System of an Iron & Steel Corporation. The last contains server definition and several nested application domains, one for each table of the system.

Production Implementation\ISCO_MES.scm

<?xml version="1.0" encoding="UTF-8" ?>

<scm>

<server name="ISCO_MES" connect_string=""/>

</scm>

Production Implementation\ISCO_MES\Commercial Order.scm

<?xml version="1.0" encoding="UTF-8" ?>

<scm>

<import>

<serverimp>Production Implementation.ISCO_MES.ISCO_MES</serverimp>

<conceptimp>General.Physical Object.Gravity.Mass</conceptimp>

<conceptimp>General.Physical Object.Moment</conceptimp>

<conceptimp>Production.Commercial Order.Commercial Order</conceptimp>

<conceptimp>Production.Commercial Order.Optimal Mass</conceptimp>

<conceptimp>Production.Commercial Order.Optimal Date</conceptimp>

</import>

<table name="MES.COMORDERS" serverref="ISCO_MES">

<field name="COMORDER_ID" pk="true"><conceptref>Commercial Order</conceptref></field>

<field name="OPT_MASS"><conceptref>Optimal Mass</conceptref></field>

<connectionref>

<conceptref>Commercial Order</conceptref>

<conceptref>Optimal Mass</conceptref>

</connectionref>

<connectionref>

<conceptref>Mass</conceptref>

<conceptref>Optimal Mass</conceptref>

</connectionref>

<field name="OPT_DATE"><conceptref>Optimal Date</conceptref></field>

<connectionref>

<conceptref>Commercial Order</conceptref>

<conceptref>Optimal Date</conceptref>

</connectionref>

<connectionref>

<conceptref>Moment</conceptref>

<conceptref>Optimal Date</conceptref>

</connectionref>

</table>

</scm>

Production Implementation\ISCO_MES\Mass Transition.scm

<?xml version="1.0" encoding="UTF-8" ?>

<scm>

<import>

<serverimp>Production Implementation.ISCO_MES.ISCO_MES</serverimp>

<conceptimp>General.Physical Object.Gravity.Mass</conceptimp>

<conceptimp>Production.Material Unit.Material Unit</conceptimp>

<conceptimp>Production.Indiscrete.Mass Transition</conceptimp>

<conceptimp>Production.Indiscrete.Consumed Material Unit</conceptimp>

<conceptimp>Production.Indiscrete.Produced Material Unit</conceptimp>

</import>

<table name="MES.MASSTRANSES" serverref="ISCO_MES">

<field name="CONSUMED_MATUNIT_ID" pk="true"><conceptref>Consumed Material Unit</conceptref></field>

<field name="PRODUCED_MATUNIT_ID" pk="true"><conceptref>Produced Material Unit</conceptref></field>

<field name="MASS"><conceptref>Mass</conceptref></field>

<connectionref>

<conceptref>Mass Transition</conceptref>

<conceptref>Consumed Material Unit</conceptref>

</connectionref>

<connectionref>

<conceptref>Mass Transition</conceptref>

<conceptref>Produced Material Unit</conceptref>

</connectionref>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Consumed Material Unit</conceptref>

</connectionref>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Produced Material Unit</conceptref>

</connectionref>

<connectionref>

<conceptref>Mass Transition</conceptref>

<conceptref>Mass</conceptref>

</connectionref>

</table>

</scm>

Production Implementation\ISCO_MES\Material Unit.scm

<?xml version="1.0" encoding="UTF-8" ?>

<scm>

<import>

<serverimp>Production Implementation.ISCO_MES.ISCO_MES</serverimp>

<conceptimp>General.Physical Object.Geometry.Thickness</conceptimp>

<conceptimp>General.Physical Object.Geometry.Width</conceptimp>

<conceptimp>General.Physical Object.Gravity.Mass</conceptimp>

<conceptimp>Production.Material Unit.Material Unit</conceptimp>

<conceptimp>Production.Material Unit.Producing Production Unit</conceptimp>

<conceptimp>Production.Material Unit.Consuming Production Unit</conceptimp>

<conceptimp>Production.Material Unit.Material Unit State</conceptimp>

<conceptimp>Production.Commercial Order.Commercial Order</conceptimp>

<conceptimp>Production.Production Division.Production Unit</conceptimp>

</import>

<table name="MES.MATUNITS" serverref="ISCO_MES">

<field name="MATUNIT_ID" pk="true"><conceptref>Material Unit</conceptref></field>

<field name="GEOMETRY">

<field name="THICKNESS"><conceptref>Thickness</conceptref></field>

<field name="WIDTH"><conceptref>Width</conceptref></field>

</field>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Thickness</conceptref>

</connectionref>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Width</conceptref>

</connectionref>

<field name="CREATION_PRODUNIT_ID"><conceptref>Producing Production Unit</conceptref></field>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Producing Production Unit</conceptref>

</connectionref>

<connectionref>

<conceptref>Production Unit</conceptref>

<conceptref>Producing Production Unit</conceptref>

</connectionref>

<field name="CONSUME_PRODUNIT_ID"><conceptref>Consuming Production Unit</conceptref></field>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Consuming Production Unit</conceptref>

</connectionref>

<connectionref>

<conceptref>Production Unit</conceptref>

<conceptref>Consuming Production Unit</conceptref>

</connectionref>

<field name="COMORDER_ID"><conceptref>Commercial Order</conceptref></field>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Commercial Order</conceptref>

</connectionref>

<field name="STATE"><conceptref>Material Unit State</conceptref></field>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Material Unit State</conceptref>

</connectionref>

<field name="MASS"><conceptref>Mass</conceptref></field>

<connectionref>

<conceptref>Material Unit</conceptref>

<conceptref>Mass</conceptref>

</connectionref>

</table>

</scm>

Production Implementation\ISCO_MES\Production Division.scm

<?xml version="1.0" encoding="UTF-8" ?>

<scm>

<import>

<serverimp>Production Implementation.ISCO_MES.ISCO_MES</serverimp>

<conceptimp>Production.Production Division.Production Division</conceptimp>

<conceptimp>Production.Production Division.Subordinate Production Division</conceptimp>

<conceptimp>Production.Production Division.Higher Production Division</conceptimp>

<conceptimp>Production.Production Division.Full Name</conceptimp>

</import>

<table name="MES.PRODDIVISIONS" serverref="ISCO_MES">

<field name="PRODDIVISION_ID" pk="true">

<conceptref>Production Division</conceptref>

<conceptref>Subordinate Production Division</conceptref>

</field>

<connectionref>

<conceptref>Production Division</conceptref>

<conceptref>Subordinate Production Division</conceptref>

</connectionref>

<field name="HIGHER_PRODDIVISION_ID"><conceptref>Higher Production Division</conceptref></field>

<connectionref>

<conceptref>Subordinate Production Division</conceptref>

<conceptref>Higher Production Division</conceptref>

</connectionref>

<connectionref>

<conceptref>Production Division</conceptref>

<conceptref>Higher Production Division</conceptref>

</connectionref>

<field name="FULLNAME"><conceptref>Full Name</conceptref></field>

<connectionref>

<conceptref>Production Division</conceptref>

<conceptref>Full Name</conceptref>

</connectionref>

</table>

</scm>

Production Implementation\ISCO_MES\Production Unit.scm

<?xml version="1.0" encoding="UTF-8" ?>

<scm>

<import>

<serverimp>Production Implementation.ISCO_MES.ISCO_MES</serverimp>

<conceptimp>Production.Production Division.Production Division</conceptimp>

<conceptimp>Production.Production Division.Production Unit</conceptimp>

<conceptimp>Production.Production Division.Average Capacity</conceptimp>

</import>

<table name="MES.PRODUNITS" serverref="ISCO_MES">

<field name="PRODUNIT_ID" pk="true"><conceptref>Production Unit</conceptref></field>

<connectionref>

<conceptref>Production Division</conceptref>

<conceptref>Production Unit</conceptref>

</connectionref>

<field name="AVGCAPACITY"><conceptref>Average Capacity</conceptref></field>

<connectionref>

<conceptref>Production Unit</conceptref>

<conceptref>Average Capacity</conceptref>

</connectionref>

</table>

</scm>

Production Implementation\ISCO_MES\Slab.scm

<?xml version="1.0" encoding="UTF-8" ?>

<scm>

<import>

<serverimp>Production Implementation.ISCO_MES.ISCO_MES</serverimp>

<conceptimp>Production.Material Unit.Material Unit</conceptimp>

<conceptimp>General.Physical Object.Chemical Composition.Carbon Concentration</conceptimp>

<conceptimp>Production.Indiscrete.Metallurgic.Slab</conceptimp>

</import>

<table name="MES.SLABS" serverref="ISCO_MES">

<field name="SLAB_ID" pk="true"><conceptref>Slab</conceptref></field>

<connectionref>

<conceptref>Slab</conceptref>

<conceptref>Material Unit</conceptref>

</connectionref>

<field name="CARBON"><conceptref>Carbon Concentration</conceptref></field>

<connectionref>

<conceptref>Slab</conceptref>

<conceptref>Carbon Concentration</conceptref>

</connectionref>

</table>

</scm>