New Way to Model Data

by Andrew M
The article I read this week was entitled “Software Tool for Automated Analysis of Conceptual Data Model” by Z. Kazi and B. Radulovic. This article goes over the idea that databases can be majorly improved if they are efficiently and correctly made from the get go. The authors point out that many times there are issues created because the admins who are creating the database either do not have the knowledge or the skill to create the initial data model correctly. The proposed solution is to use a few tools to help enable database admins to create better and more efficient databases. The first tool they suggest using is CASE. This software tool helps to create the actual data model itself in the correct form. Next, a tool named PROLOG is used which actually tests the model and gives back input. This program shows the relationships that the user has modeled and also how they relate to each other. PROLOG prints out a form in which it can show attributes of a certain entity and also the rules governing that specific entity. The authors feel that if these tools are used that databases can be created much more efficiently.

I personally found this article extremely interesting. While this article was a little hard at times to read, in the end I would highly suggest it. The article was well written and gave a very nicely detailed synopsis of how data models are created and how they work. I feel that after reading this article I actually understand databases more.

I also found that in this article they used many figures or pictures to demonstrate their points which greatly strengthened their argument. I have posted the link to this article below. It is a very good article which I highly suggest everyone check out.

Kazi, Z., Radulovic, B. (23-27 May 2011). “Software tool for automated analysis of conceptual data model.” MIPRO, 2011 Proceedings of the 34th International Convention, 935-940.

http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=5967190&isnumber=5967009

3 thoughts on “New Way to Model Data

  • October 6, 2012 at 4:23 pm
    Permalink

    It is true that many projects, not just relating to databases, are ruined from the beginning by poor planning and design. I looked over the article and saw that it is quite in depth which makes it great reference material. Nice find!

  • October 6, 2012 at 5:47 pm
    Permalink

    This article is completely different from mine. In my article, the author suggests to draw out the model on paper first before working on the software. It is because the software is harder to navigate and we will easily miss the concept because we focusing too much on the design. But also agree with the author that using software will help create the initial start. I used Access in my accounting class to design database and it really help me because there are rules already build in the software, therefore, it will prevents me from making a false/wrong relationship, primary key, or foreign key.

  • October 7, 2012 at 6:34 pm
    Permalink

    I agree with the article. If you don’t have a solid beginning to a database, then what can you expect from the database later? Design is critical in all aspects of the world. With a majority of business now relying on their databases to store and obtain data, the design and functionality is going to play a huge part in whether or not they are successful. If the administration does not have the knowledge or tools to complete the job, the business is going to have a bad time down the road. I would say design is key!

Comments are closed.