Mainstream IT Modeling

The Relational Model is based on a set of rules, called Database Normalization, used to organise and structure data in a system relevant and sustainable manner avoiding redundancies and allowing data retrieval and transactions.

There are three levels of data modeling:
(Quote: Alf Alexander Pedersen, databasedesign-resource.com)

The Conceptual Database Model, which is transformed into a
Logical Database Model, which in turn is used to generate the
Physical Database Model.

The Conceptual Model can, for simplicity, be seen as consisting of an Entity-Relationship Model with its Entities, Attributes and Conventions governing those Entities and Attributes.

Informal Predicates, or Conventional rules are spelled out in natural language and transformed into Formal Predicates, which in turn are defined as Constraints in the Logical Database Model.

From the finished Logical Database Model, one can generate all the necessary scripts (CREATE TABLE, INDEX, etc.) that will ultimately implement the Physical Database Model on the system’s hard disk (s).

The three levels of data modeling are compared by their different features:

The Conceptual Data Model serves to understand at high level what the different Entities are and how they relate to one another.

The Logical Data Model serves to understand the details of the data without worrying about how they will actually be implemented.

Finally the Physical Data Model serves to know exactly how to implement the Data Model in the Database of choice. In a Data Warehousing Project, sometimes the Conceptual Data Model and the Logical Data Model are considered as a single deliverable.

Author: Andrew Cywan

IT Architect, Application Developer

13 thoughts on “Mainstream IT Modeling”

  1. You actually make it seem so easy with your presentation but I find this topic to be actually something that I think I would never understand. It seems too complex and very broad for me. I’m looking forward for your next post, I will try to get the hang of it!|

  2. Thanks for your personal marvelous posting! I truly enjoyed reading it, you are a great author. I will always bookmark your blog and will eventually come back from now on. I want to encourage you to ultimately continue your great job.

  3. I don’t know how I stopped here but I think these posts are great. I do not know who you are but you are definitely going to be a famous blogger – if you aren’t already. Cheers!

  4. After looking into your articles on your website, I honestly like your technique of writing a blog. I added it to my bookmark list and will be checking back in the near future.

  5. Does having so much content and concepts make you ever run into any issues of plagorism or copyright infringement? My website has a lot of unique content I’ve either written myself or outsourced but it looks like a lot of it is popping up all over the internet without my authorization. Do you know any techniques to help stop content from being stolen? I’d definitely appreciate it.

    1. …Yes, being somewhat phylosophical about this, I think the world would be a much better place if people were honest about their Content …

      But I suppose you could say you win some, you loose some. Either way, you have to find methods of benefitting from your Content and ‘recognition’ is a keyword.

      Having said this, I do give some encouraging advice about ‘self fulfillment’ on the homepage of this website, and it boiles down to: research, research and research 🙂

  6. Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you can do with a few pics to drive the message home a little bit, but other than that, this is a fantastic blog. A great read. I’ll definitely be back.

  7. I’m really impressed with your writing talents as with the layout on your weblog. Is that a paid subject matter or did you modify it your self? Anyway keep up the nice quality writing, it’s uncommon to see a nice weblog like this one these days…

  8. Greetings! Very helpful advice within this post! It is the little changes that produce the greatest changes. Thanks a lot for sharing!

  9. Thanks for your marvelous posting! I quite enjoyed reading it, you are a great author. I will remember to bookmark your blog and will often come back from now on. I want to encourage you to continue your great posts, have a nice holiday weekend!|

  10. Hmm is anyone else having problems with the images on this blog loading? I’m trying to figure out if its a problem on my end or if it’s the blog. Any feed-back would be greatly appreciated.

Leave a Reply to Tresa Giombetti Cancel reply

Your email address will not be published. Required fields are marked *

Solve : *
25 − 15 =