Why structured data modelling exercise is essential for the quality of a software?

Why structured data modelling exercise is essential for the quality of a software?

RDBMS has dominated as well dominating the data world. Often in hurry a structured data modelling exercise is jumped by software architects to save time. Is that a right approach?

In a software development, cost of fixing a bug phenomenally increases with the elongation of the defect escape duration.

For example, a bug escaped from requirement stage caught at deployment stage is extremely costly than when it is caught at the design stage itself.

I would have designed 10000s of tables under numerous database systems, RDBMS, NDBMS, NoSQL etc. I applied what I studied in my Information Engineering in these, viz., the Yourdon-deMarco Method of Normalization, Entity Relationship Diagram followed after Gane & Sarsen method of System Analysis using Context Diagram, Data Flow Diagrams etc. Initially it was a tedious procedure but later I realized my thought pattern itself gets aligned to these scientific methods resulting in numerous advantages, top ones are as follows:

  • I realized without my knowledge I was taking care of many requirements that my users would need, most of them achieved by just using SQL statements itself.
  • Integrity of data was a seamless realization.
  • Thorough representation of data dictionary helped in organizing the huge volume of data in a manner to scale up the success of business analytics.
  • Automatic explanation of business algorithm to developers connecting the user stories with the data model thereby drastically reducing errors.
  • Increased amount of reusability of data.
  • Lower maintenance cost.
  • Ultimately a robust design.

Faster, Cheaper, Better - is the mantra I follow and I certainly celebrate to the Data Modelling principles.

To view or add a comment, sign in

More articles by Manikandan R

  • The most precious alphabet for your software UI

    Simply draw the alphabet "F" on your screen. Bingo - you have influenced the human behaviour! When the human eyes sees…

    1 Comment
  • Be on top of your mind

    7 things to eliminate Ever experienced your mind is not in your control, keeps disturbing you a lot? Be it work or…

    1 Comment
  • Information Technology - What's Up Next?

    Is it true that the world of Information Technology is going through a recession? Emotionally it may sound real, right…

  • Innovation - Start With Pain

    Innovation & Invention - how are they different? Many people in IT industry confuse these 2 terminologies. In my career…

  • Automate to speed up your deliveries

    how often during software development do we encounter a situation where time becomes a major constraint Do we have a…

    1 Comment
  • Say no to "Bandage"

    When we grow in IT sector, how often we are pressurised as developers to fix the root cause. "Do causal analysis, ask 6…

    1 Comment
  • Customisation - how much does it take?

    Often we end up either as a software product developer or as a business IT leader or as a solution architect - "how…

  • Offline: Hell or Heaven?

    "Enough Bandwidth Still Insufficient", often we come across this, especially in the world of internet. No network, poor…

    2 Comments
  • Start with the VIEW

    MVC: very familiar and most popular in our architectural world!!! Is it just the model - view - controller containing…

    2 Comments

Explore content categories