top of page
Writer's pictureBlair Kjenner

Automatically generate views from the data dictionary

In this post I am going to describe the View Generate utility that was developed using Postgres that is a part of an enterprise system platform that has an inherent capability to exchange data between systems.


The View Generate utility automatically generates views based on the data dictionary. The key features of the view generate are:


- It uses the foreign key relationship data to create joins to parent tables.

- It uses the translation for master records. For example, the translation for a contact record is the name of the contact. As a result, the view will show the name of the contact for any foreign key references to contact data.

- It uses the business name for columns rather than the table column name. For example, it will name the column ActivityType rather than using acttypeid.

- It accommodates links to multi-link foreign keys (see www.3d-ess.com/videos - 030.020 Multilink join).


The view utility saves developers tremendous effort in creating views. It also allows the architects to quickly change standards for all views simply by updating the procedure and regenerating the views.


If you are interested in checking out the source code for the View Generate tool, please click on the following link. www.3d-ess.com\sourcecode - 500 Procedures\spsysViewCreate.sql.


Thank you for your attention. I appreciate your comments, questions and likes.


7 views0 comments

Recent Posts

See All

Comments


bottom of page