Database – Best Practices

Enterprise database is the heart of an e-commerce applications. As the organisation reaches new heights and expand applications, it means more traffic. More users means more database contention. While designing a database schema and using it, these expansion of business must be kept in mind. The database must keep on performing at its best at all peaks of business.

Design, deployment, usage and migration of databases are major concerns for an enterprise database. Ignorance while designing and deploying databases might become major design flaws which will result in failure of the application.

These articles tries to identify best database practices to be kept in mind.

• Database Design Practices
• Database Deployment Practices [Coming Soon!]
• Database Usage Practices
• Database Migration Practices [Coming Soon!]

These are NOT any kind of standards which have to strictly followed, they are basically guidelines and information that helps in building a robust, scalable and portable database.

NOTE: The actual scenario might not comply with these guidelines. However, it is recommended to document any alternatives that go against these practices.