What Is Data Modeling?
How Data Modeling Helps Businesses
Types of Data Modeling
- Conceptual data modeling: This type of data modeling provides organizations with a big-picture view of the data that’s being used, how it’s being organized, and the relationship between various data points. For example, if a company wants to implement a new purchasing system, its conceptual data model may include data points such as client ID numbers, purchase order numbers, inventory data, accounts receivable information, and shipment dates.
- Logical data modeling: Logical data models are not specific to a database. IBM defines this model as one “that describes things about which an organization wants to collect data, and the relationships among these things.” Logical data models are often described as being the blueprint that users can draw from when creating other types of data models.
- Physical data modeling: Where logical data models serve as blueprints, physical data models are used to design and create databases. With physical data modeling, database designers draw information from conceptual and logical data models, and use that information to visualize how columns, graphs, tables, and other useful visual depictions will be represented to users.