The Software Data Dictionary (SDD) may be a stand-alone project document; it may be included as part of an electronic database; or it may be written as an appendix in one of the project's primary documents, e.g., the systems requirement specification (see SWE-109) or the software design description document (see SWE-111 and SWE-112). Either format (hardcopy or electronic) is compliant with the requirement.
A data dictionary includes a set of meta-data that contains the definition and representation of data elements. A data dictionary lists all data elements but does not say anything about the relationships between elements. It gives a single point of reference for a data repository of an organization.
Some of the typical components of a data dictionary entry are:
- Name of the table.
- Name of the fields in each table.
- Data type of the field (integer, date, text, etc.).
- Brief description of the expected data for each field.
- Length of the field.
- Default value for that field.
- Whether the field is Nullable or Not Nullable.
- Constraints that apply to each field, if any.
Not all of these fields will apply for every single entry in the data dictionary.
Designers, programmers, users, maintainers, and administrators of a computer system as an administrative resource are the main users of the SDD. Data dictionaries are used to maintain information on systems hardware and software configurations, documentation, application, and users, as well as other relevant information.
The SDD can be produced:
- Automatically, using a software tool to interrogate the database and to map its content.
- Manually, by examining the code to determine and record its content.
- By a combination of the two.
An electronic data dictionary is said to be active or passive. The term "passive" applies to the data dictionary that must be updated manually, whereas the term "active" applies to the data dictionary that is updated automatically by a database manager tool as data in the database is updated.
The data in the SDD may be in the form of tables. Typically, the table definitions define the tables in the database, including a brief description of their use, the key fields, the primary key, and a list of the fields.
Guidance and examples for the required content of the SDD are included in the bullets below:
- Channelization data, e.g., bus mapping, vehicle wiring mapping, hardware channelization, provides a description of each data channel and where it maps to.
- Input/Output (I/O) variables provide a description of each I/O variable. Specify format, unit of measure, and definition.
- Rate group data, e.g., science data is collected at 1000 Hz, and health and status data is collected at 1 Hz.
- Raw and calibrated sensor data provide a description of the format, units of measure, and definition of each sensor. Specify data reduction for transforming raw data into calibrated data.
- Telemetry format/layout and data provide a description of the telemetry mode, format, packetization and definition:
- Specify what types of packets are allowed to be sent for each of the telemetry modes.
- Specify maximum data rate for each mode.
- The telemetry format usually includes data type, data representation, data size, acceptable range values, unit of measure, and the meaning of the data for each field.
- Data recorder format/layout and data
- Command definition, e.g., onboard, ground, test specific, provides a description for each of the commands processed by the software work package. Include the purpose, function, the format of the command and its parameters, and any restrictions attendant to the command.
- Effecter command information provides information about the setting of names or flags that cause command executions in the software work products.
- Operational limits, e.g., maximum/minimum values, launch commit criteria information.
Other candidate information for the software data dictionary includes:
- Data channelization.
- Data description.
- Data location.
- Data relationships.
- Data sources and destinations.
- Data structure.
- Data type.
- Data units.
- Data use.
- Data values, e.g., range and calibration data.
- Database schema and database management systems.
- Object-oriented class and method descriptions.
- Entity-relationship diagrams.
Finally, the SDD includes descriptions of each process carried by the database system, including:
- Where and how the data enters the system.
- What is done to the data, at what stage, and why.
- What the outputs of the system are (if any).
- How to control, update, and distribute the SDD.
When performing class F and G software development, the appropriate Center Chief Information Officer is expected to provide appropriate guidance for the fulfillment of this requirement. In all cases, engineering judgment is expected to be used when finalizing the approach to satisfying SWE-110.
Additional guidance related to the production of the SDD may be found in the work products generated by the following related requirements in this Handbook: