Q: What is the difference between ER modeling and OLTP modeling? Is the result of ER modeling and OLTP model the same?

Chuck Kelley's Answer: If you take ER modeling through its full modeling processes, then you might have an OLTP model. ER is about defining Entities and Attributes and the relationships between them. Most of the time, this is the logical design. Then you use that logical model to create a physical model. It may or may not look like the logical design. Since both are ER models; the output of the physical model would be the SQL of the database; the model is to be used as an OLTP application, then the modeling would be and OLTP model.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access