Naming Conventions use cases
When using Naming Conventions, it is often useful to experiment at a small scale to understand the behavior and possibilities, prior to deploying at a larger scale.
The enabling of Naming Conventions is not mandatory, and can be done for some targets and not others, if that's what you wish. It is performed in the menu Tools > Options > Naming Conventions for each target. There are 3 possible options for each target: disabled, Business-to-Technical, or Technical-to-Business.
Typically there are no reasons to enable Technical-to-Business. The functionally makes most sense when enabled for Business-to-Technical. It does exist however for ad-hoc manipulations, as illustrated below.
Note: even if Naming Conventions are disabled in Tools > Options, it is possible to couple names of any individual object, as described here. Similarly, even if Naming Conventions are enabled in Tools > Options, it is possible to decouple names of any individual object.
When reading this page of use cases, it is assumed that you have reviewed the documentation page, and maybe even viewed the video.
For naming conventions to work best, it is strongly suggested to make the rules of business-to-technical and technical-to-business symmetrical. Some features are not. For example, the removal of vowels or specific characters during business-to-technical transformation cannot be reconstructed during technical-to-business transformation. It is preferable to leverage an abbreviations file.
Use Case # 1: apply Naming Conventions to an existing data model
Whenever you make a change to the Naming Conventions screen in Tools > Options, the application displays a dialog to apply the changes to model open at the time of the change. You may choose to apply the changes to only the names already coupled in the open model. Or to the entire modeL.
Important note: only the model open at the time of the change is concerned by these changes. If you want to apply the naming conventions to other model, you must proceed as follows...
1) open the model for which you want the set Naming conventions to be applied
2) go to Tool > Options > Naming Conventions
3) scroll down to the bottom of the dialog and click the button "Apply options to current model"
4) choose whether you want the conventions to be applied only to the already coupled names, or to the entire model
5) click the Apply button.
If for example your model had no coupling of names previously, and your naming conventions are now set for this target to coupling of Business-to-Technical names, then if you choose to apply to the entire model, then all the names of all the objects will have their technical names derived from their business names according to the set rules.
You can see below in case # 3 why it may be very important to only apply rules to previously coupled names, instead of to the entire model.
Use Case # 2: clear all technical names in a data model
Warning: this function allows to clear data. Be careful to not lose any valuable data that you might have wanted to retain.
When you disable the coupling in Tools > Options > Naming Conventions, the application displays, similarly to case # 1 above, a dialog. But in this case a checkbox allows, if checked, to clear the technical names.
Again, it is possible to have this performed for only names previously coupled, or to the entire model.
Use Case # 3: handle evolution of abbreviations and/or transformation rules
This is a very real use case! Many companies have had databases in production for a long time, meaning that technical names are in place. Let's say that you now want to make naming conventions evolve, or to change some abbreviations, or simply to create naming conventions when none were in place before. It would be hard to impose a change of physical table names or column names. In this case, you want to keep existing technical names, but you want any future object to follow the (updated) naming conventions.
Let's say that you have a model that was created with old naming conventions. You want to retain the physical/technical names as they are going forward, but you also want new objects to be created with the new rules or the abbreviations. You need to follow these steps:
1) decouple all the existing names
- go to Tools > Options > Naming Conventions
- disable name coupling by choosing No in the dropdown list "Enable name coupling"
- click Apply
- choose "To the entire model" -- DO NOT check the Clear checkbox
- Click Apply
2) re-enable Business-to-Technical name coupling with the new rules.
3) when presented with the dialog to apply the naming conventions configuration, click Cancel so no changes are applied. All future objects created in the model will be created with coupling, using the conventions rules.
Make sure to perform this operation for each model of the same target to which the rules would apply.
Use case # 4: technical names to construct business names
In some cases, you might not have business names at all in your models. Maybe this is the first time that data modeling is performed.
Prior to reverse-engineering from your database instance or from DDLs, you would want to assemble an abbreviations file. Abbreviations files in Hackolade Studio work both directions: in Business-to-Technical coupling, by taking full words or expressions listed in the first column of the CSV, and abbreviating them according to what's in the second column of the CSV in the corresponding line. It also works during reverse-engineering, by parsing technical names separated by underscores or camelCases, finding the abbreviation in the second column, and translating into a business name using the first column of the CSV in the corresponding line. Even if your coupling is set to Business-to-Technical, the application knows to convert technical names to business names during reverse-engineering.