Data element name
A data element name is a unique name given to a term or data element in a data dictionary. In a formal data dictionary no two data elements may have the same name since the data element name becomes an identifier.
In a database driven data dictionary the data element Name often becomes the primary key of a Data Elements table of a data dictionary.
The data element name typically conforms to ISO/IEC 11179 metadata registry naming conventions and has at least three parts:
- Object, Property and Representation term.
Many standards require the use of Upper camel case to differentiate the components of a data element name. This is the standard used by ebXML, GJXDM and the NIEM.
Example of ISO/IEC 11179 naming in relational databases
ISO/IEC 11179 is applicable when naming tables and columns within a relational database.
Tables are Collections of Entities, and follow Collection naming guidelines. Ideally, a collective name is used: eg., Personnel. Plural is also correct: Employees. Incorrect names include: Employee, tblEmployee, and EmployeeTable.
Columns are Properties of the Entity and are named in a multi-part format:
[Object] [Qualifier] Property RepresentationTerm
The Object part may be omitted from a name when the property is within its object's context. The Qualifier is used when it is necessary to uniquely identify an element. For example, columns on the Work_Orders table would be expressed as:
WorkOrder_Number Requirements_Text Requesting_Employee_Number Approving_Employee_Number
For Requirements_Text, the full name (i.e., the name that goes in the registry, or data dictionary) is WorkOrder_Requirements_Text; the Object part is omitted because it is declared in the WorkOrders table.
The Requesting_Employee_Number and Approving_Employee_Number columns have Qualifiers to ensure that the data element names are unique and descriptive. The Object part of the element name is also omitted because it is declared within the object context.
Note that for the examples provided, an underscore was used as a separator. A separator is not mandated by ISO/IEC 11179 but is recommended.
Example of ISO/IEC 11179 name in XML
Users frequently encounter ISO/IEC 11179 when they are exposed to XML Data Element names that have a multi-part Camel Case format:
Object [Qualifier] Property RepresentationTerm
The specification also includes normative documentation in appendices.
For example the XML element for a person's given (first) name would be expressed as:
<PersonGivenName>John</PersonGivenName>
Where Person is the Object=Person, Property=Given and Representation term="Name". In this case the optional qualifier is not used.