physical design

Importance Data Modeling {2}

by Claudia J
The article that I read about talked about that in order for us to be good in working with databases it is important to acquire knowledge in security management, data integration and data recovery in the case of a disaster. Designing a good database doesn’t consist only in linking tables together; it requires lots of skills combined to be able to pull off a complete database structure that will run optimally. Many companies tend to fail when trying to design a good database because developing a good database model requires lots of time to create a well-model design and most of the companies don’t count with the necessary time to allocate to the data modeling phase. read more...

Why You Want To Be Good At Data Modeling {1}

by Toan T

A good database is something every organization must have when managing large sets of data. However, building a good database is now no longer consider to be a main priority because time and cost during the development life cycle have become the major factors for a lot of companies such that database design of today no longer focus on the performance aspect but to rather have something that just “work”. This article addresses some of the flaws that exist and are often overlooked as well as focusing on the core problem that relates to poor performing databases. Building a good database is not something that can be simply created through coding but it something takes huge amount of time and effort as well as knowledge to lay down the proper foundation for the design. There was a myth that that many developers often discuss about was that database’s performance is derived from the code that it is written from. This is somewhat untrue to because there are other things that are performance related. Good code does have an impact in performance but the core issue that is most important is the physical design of the database. No matter how well the codes were written or how fast the hardware it is running on, performance constraints will always exist when the overall physical design is poorly implemented. Developers should thoroughly monitor the database’s performance and focus more on the logical aspects of designing because there must be something wrong when it takes 40 minutes to generate a report. read more...