Database-Based Maintenance Improvement Solution for Small and Medium-sized applications

Many project managers who have worked on small and medium-sized projects have such feelings that it is difficult to maintain the software during the maintenance period.

Why?

1. The customer's final requirements have changed too much at the beginning of requirement analysis.

2. the buckets that are not tested in the software development project cause some error data in the database. Then some small tools of software engineers were corrected. But the problem is not thorough.

 

I think a better solution is:
Whether the software runs correctly or not depends on the database structure and data storage restrictions.

Starting from this point, I think that in the project development project, the customer's business rules are written as SQL scripts to check whether the currently running data is correct.

No matter how the requirements change, the corresponding business rules will be added to the script as long as the changes occur. In this way, the system executes user data after many major changes in demand.

The Business Rule Check script can better ensure data correctness.

Of course, the business check rules written by SQL scripts must be strictly tested to ensure their correctness. In addition, SQL scripts must generate detailed documents for output of data with errors, which is convenient.

Consult engineers.

 

The above is just my words. I hope you will discuss more about the development and management experiences of Small and Medium Projects.

In addition, maintaining such an SQL script also increases the development cost of the project.