Logical Data Modeling

What Does Logical Data Modeling Mean?

Logical data modeling is the process of representing data architecture and organization in a graphical way without any regard to the physical implementation or the database management system technology involved in storing the data. A logical data model provides all the information about the various entities and the relationships between the entities present in a database.

Advertisements

Techopedia Explains Logical Data Modeling

A logical data model represents the organization of a set of data by standardizing the people, places, things (entities) and the rules and relationships between them using a standard language and notation. It provides a conceptual abstract overview of the structure of the data.

Logical data modeling does not provide any information related to how the structure is to be implemented or the means (technologies) that are needed to implement the data structure shown. It is a technology-independent model of data that is developed from the initial structures identified by the conceptual model of data. Some of the information presented by a logical data model includes the following:

  • Entities
  • Attributes of entities
  • Key groups (primary keys, foreign keys)
  • Relationships
  • Normalization
Advertisements
Margaret Rouse

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.