Advanced SQL in DB2 – Part 1

Before going into advanced SOL, I want to give some information on data modelling :

Image from book


Data model is input to the process model. Process model is high level model in an enterprise. Why sound data design is required. Usually, it should meet current business requirements, and future business requirements.

Data model – Data modeling provides a framework in which a sound logical data design can be discovered and then documented. Data model is logical in nature and powerful in its simplicity, it is not vague.

Who are involved in data modelling:

  • Business systems analysts

  • Data analysts

  • Data architects

  • Data management engineers

Process of data model:

  • First we need to generate logical model
  • Generate Physical model based on logical model. Development of Physical data model is independent of any RDBMS or database
  • Physical model is further engineered to generate an implementation database based upon a particular software platform.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.