研发过程数据库设计评审优化实践

Optimization practice of database design review in R&D process

数据库是整个软件应用的根基,是软件设计的起点,它起着决定性的质变作用。如果在数据库设计方面考虑不全,一是系统会留下很多隐患,如写代码时才发现问题以及系统上线运转后出现问题,从而大幅增加后期维护成本。二是系统变动时,数据库无法低成本快速地适配,甚至可能推翻重来。为及时应对多变的市场需求,快速迭代开发已成常态,保证数据库的可靠性、灵活性愈发重要。如何在有限的迭代开发周期内,快速且高质量完成数据库变更设计、风险评估,成为如今数据库设计过程中避不开的话题。

Database is the foundation of the whole software application and the starting point of software design.It plays a decisive role in qualitative change.I£the database design is not fully considered^first,the system will leave many hidden dangers?such as problems found when writing code and problems after the system goes online,which will greatly increase the later maintenance costs.Second,when the system changes,the database cannot adapt quickly at low cost,and may even be overturned.In order to respond to changing market demands in a timely manner,rapid iterative development has become the norm,and it is increasingly important to ensure the reliability and flexibility o£the database.How to complete the database change design and risk assessment with high speed and quality within the limited iterative development cycle has become an unavoidable topic in the database design process.