Developing new database systems can be a labor intensive process and requires a
strong foundation of database concepts including normalization, integrity and
optimization. Getting the balance between these factors is essential for
minimizing problems, maximizing the value from time invested, and creating
maintainable and extendable systems while providing effective and responsive
support for application systems.
Databases can be developed on top of a number of database management systems to
support many varying application frameworks, but all of these use a common theme
and Structured Query Language (SQL).
Database Management & Uses
So what’s the solution? Essentially, database management and maintenance should
be a structured, well planned and executed exercise, causing minimal disruptions
to system availability. The key objectives of database management are:
- Stable performance
Maintain the database at optimal performance.
- Safety: Protect your
database from unauthorized access, data leakage or data loss.
- Database integrity:
Detect database inconsistencies and corrupt data caused by hardware or
- Business Compliance:
Identify database structures, relationships and data that do not conform to
business rules or are erroneous.
- Disaster recovery:
Support disaster recovery planning through data and transaction log
- Downtime: Minimize
database downtime for maximum availability by scheduling maintenance during
off-peak hours or consider having a second production database.