In this section: 

Viewing Data Models

Click on the Models tab and choose a repository to interact with the data sets contained in the repository.  

If your license does not include access to the data modeling functionality and features, you will be prompted to enable it on the license configuration page.  See Configuring the License and Database for instructions on enabling additional features. 

Data all sets within a repository are represented as diagrams in the Models tab of Test Data Assistant.

You can use the scroll wheel on your mouse to zoom in and out.

You can click and drag on an object to arrange the objects.

You can click on an empty area of the diagram to move all objects at once.

Understanding Data Model Components

A model is a repository-level collection of data sets, record types, members, and keys.  

Data Sets and Record Types

Data sets are high-level organizational structures within a repository. A data set is identified by a record type. In the following image, the "getItemById" data set is a "getItemByIdResponse" type of record.

  

Keys and Members

A data set contains keys and members. Keys are unique data fields that can be called by a tool so that responses with all the data in the row can be used in a test. Members are the data value fields. In the following image, "IMDBID" is a key and "Title" and "ProductionBudget" are members. 

A list of members is represented as a stack. If the generation settings for a member has been configured, a gear icon will appear on the member label (see Working with Data Models). 

Members can also represent a record type. In the following image, the dark boxes labeled "Results" are members of the "Results" record type (circle), but they also represent other record types ("addResponse", "subtractResponse", and "divideResponse").

Relationships within a Model

Relationships between objects are represented by lines and arrows. Clicking on an object opens a sidebar the provides additional information about the data structure. In the following model, the record type "test" is highlighted and it's relationships are summarized in the sidebar.

The arrow to the record type from the "test" data set indicates that the record type is referenced by the data set.

The line between record type and the primitives "bizarre", "cn2", "cn3", "cn0", and "bizarre_2" indicate that they are members of the "test" record type.

In the following model, a line between the key "titleKeyword" and the data set "getItemByTitle" indicates that "titleKeyword" is a key in the data set. This relationship is summarized in the sidebar when the key is selected.

Additionally, the record type "getItemByTitleResponse" is referenced by the data set and appears in the sidebar under the Value Types label.

Foreign key constraints are represented by a dotted line. In the following model, the key member "IMDBID" is a foreign key of the member "Title." A foreign key is a field in one data set that uniquely identifies a field in another data set. See Inferring Data Constraints for information about foreign keys.

  • No labels