Updated on 2025-03-13 GMT+08:00

Overview

Overview

This chapter describes the database-related design and development specifications in the product design and development process based on the product lifecycle.

This chapter aims to improve the readability and code quality, and emphasizes the practicability and operability. It specifies the issues that may occur during the database development. The specifications are as follows:

Design specifications on database and performance

Programming specifications on typesetting, naming, comments, syntax, scripts, database, installation and deployment, and security

In addition, detailed rules and specific examples are provided for some specifications if necessary.

The development specifications are for reference only. The specific specifications should be comprehensively evaluated and implemented by database users based on the application technical architecture and planning.

Terms

This document uses the following terms for description:

  • Specification: database specification that must be complied with during programming and design. If you do not follow the specifications, the database reports an error.
  • Rule: a convention that must be followed during programming and design.
  • Recommendation: a convention that must be considered during programming and design.
  • Description: an explanation of a rule or recommendation.
  • Example: a positive or negative example of a rule or recommendation.

Applicability

This document is intended for designers, developers, development database administrators (DBAs), operation and maintenance (O&M) DBAs, and O&M personnel.