Data Dictionary Namespaces

To avoid breaking compatibility for customers that have not upgraded to an Amdocs 6 databases, we have introduced a new Data Dictionary document namespace and accompanying .xsd file used for validation. This new Data Dictionary file format will contain the additional database schema features introduced by Amdocs 6.

Backwards Compatiblity

Existing Dovetail SchemaEditor customers should have no problem using their existing Data Dictionary documents with Dovetail SchemaEditor.

To avoid ambiguity, we chose to not allow use of the new Amdocs 6 compatible schema with pre Amdocs 6 databases. Data Dictionaries created with Amdocs 6 specific elements will not be usable on non Amdocs 6 databases. However, it is quite easy to manually remove the Amdocs 6 specific tags and change the namespace of the document.

Data Dictionary Example Documents

Below are examples of Data Dictionary documents of each file format. The differences are emphasized.

Pre Amdocs 6 Data Dictionary

<schema xmlns="http://www.dovetailsoftware.com/2006/10/DataDictionary.xsd">


  <sqlView id="2001" name="case_id_view" groupName="Support">


    <sql><![CDATA[Select objid from table_case]]></sql>	


    <description><![CDATA[Display a case database identifier]]></description>




    <sqlViewColumn name="objid" dataType="Integer" clarifyGenericFieldID="3" isPredefined="true" isMandatory="true" isUserDefined="false" isDirect="true">


      <description><![CDATA[Internal record number]]></description>


    </sqlViewColumn>


  </sqlView>




</schema>


Amdocs 6 or later Data Dictionary


<schema xmlns="http://www.dovetailsoftware.com/2009/03/DataDictionary.xsd">


 


  <sqlView id="2001" name="case_id_view" groupName="Support">


    <sql><![CDATA[Select objid from table_case]]></sql>


    <databaseSpecificSql>


         <description><![CDATA[Nothing is really that special about this oracle specific SQL]]></description>


         <sql targetDatabase="oracle"><![CDATA[select objid from table_case]]></sql>


       </databaseSpecificSql>


       <description><![CDATA[Display a case database identifier]]></description>




       <sqlViewColumn name="objid" dataType="Integer" clarifyGenericFieldID="3" isPredefined="true" isMandatory="true" isUserDefined="false" isDirect="true">


         <description><![CDATA[Internal record number]]></description>


       </sqlViewColumn>


  </sqlView>




</schema>


Upgrading to Amdocs 6


Users of Dovetail SchemaEditor version who have upgraded to Amdocs 6 should update the namespace of their Data Dictionary documents to match the Amdocs 6 example. In particular, the xmlns attribute on the root schema element should be: 


http://www.dovetailsoftware.com/2009/03/DataDictionary.xsd











See Also
Working with a Data Dictionary
Exporting a Schema
Modifying the Schema File
Preview Schema Changes
Applying Schema Changes



Next
Schema Script XML Reference











 Data Dictionary Namespaces