Database Designing
Many times it is observed that we do not get the performance of system what we actually expect.
The reason behind this is people concentrate on coding(front end) but neglect towards database design,in which quering is also very important.Un-neccesary Complex queries reduce the performance & response time of system.So here are few things which can avoid the degradation of performance & helpout with good results.
What do you mean by Best Database design ?
1. When the data availability is easy
2. Normalized according to requirement
3. Uniqueness
4. Retriving data with minimal queries
5. The most important thing,if in case there is any change in scope then it should be easy to make it with minimal efforts
Database designing is key factor in any project.The performance of project is depend upon how is your databse designed.
Some Key factors / good habits for database designing:
1.Proper ER diagram
2.Normalization according to requirement
3.Relationship among tables
4.Nomenclature for database,tables,attributes
5.Indexing
6.Primary key
7.Constraint
8.maximum row size of table
9.Integrity
Comparing this points in practicle will help to design better database
Subscribe to:
Post Comments (Atom)
2 comments:
Nice Blog..will comment in brief later
Nice to start with, but I mean that's pretty much the basics. You can give more details to try to be different
Post a Comment