Consumer Table and View Naming Convention

Consumer Table and View Naming Convention

Table and Views exist to group data in logical relations within a Data Broker dataset.

Table / View Variables

Entity A data entity is an object in a data model. Data is typically designed by breaking items down into smaller parts for data representation of data relationships. For example, a customer may include a list of contacts. Each contact may contain an address.

Data Classification (Optional) Data classification is the process of analyzing structured or unstructured data and organizing it into categories based on file type, contents, or other metadata. This helps groups quickly identify their data.

• Data Classification examples:

  • fct = Fact data is information about a thing that has happened. It is an immutable event at a specific point in time.

  • cdc = Change data capture indicates this table / view contains all instances of a specific thing and receives all changes to those things.

  • cmd = Command data represents operations that occur against the system. This data is typically found as the request-response pattern, where you have a verb and a statement. Examples might include UpdateUser and UserUpdated.

  • sys - System data are used for internal topics within a single service. They are operational data that does not contain any relevant information outside of the owning system. This data is not meant for public consumption.

  • map - Internal processing table for Data Broker Adapter Service

  • raw - Producer source system raw extract without transformations

  • deref - Producer source system lookup table for dereferencing raw data key values to translated values