Information Modelling

Information Modelling is not a new term, but nerd data folks hardly get in touch with it as it’s one level above of creating any special solution.

Let’s decode it…..

We also know when we start a project or solution, we begin with Conceptual Model then Logical Model then Physical Model etc. Unlike these models where we focus especially on either entities or relationships or process or constraints, Information Modelling represents entities, relationships, and processes within a system or organization.

Information modelling is a crucial aspect of designing data solutions that goes beyond merely structuring databases. It involves creating a comprehensive representation of how information is organized, flows, and is utilized within an organization or system. Information models provide a framework for understanding the relationships and dependencies among different elements of information, facilitating effective communication and management.

Let’s try to understand Information Modelling for a university i.e., imagine a large university with distinct departments like Admissions, Finance, and Student Services. Each department manages its data independently using specialized solutions.

• Conceptual Model: Each department has its conceptual model outlining the key entities and relationships. Admissions may have entities like "Applicant" and "Admission Decision."
• Logical Model: Logical models are crafted for individual solutions. Finance, for instance, has a logical model detailing tables for "Budget" and "Expenditure."
• Physical Model: Physical models delve into specific technologies. Student Services might implement its model using a relational database, defining tables like "Student Information."

Information Modelling Perspective:

Now, consider Information Modelling. It focuses on how data flows seamlessly across these departments. It looks at the relationships between the Applicant data in Admissions, the Budget data in Finance, and the Student Information data in Student Services.

• Relationships: Information Modelling highlights how an applicant's information might link to financial records and student records.
• Processes: It considers the end-to-end processes involving data, such as how an admitted student's information transitions from Admissions to Student Services.
• Rules: Information Modelling identifies overarching rules, like ensuring data consistency across departments or compliance with privacy regulations.

In essence, Information Modelling provides a panoramic view of how data traverses in a system or in an entire organization, linking various components, processes, rules i.e., in solutions and departments into a cohesive and interconnected whole.