当前位置：网站首页>Module-3: Outsourcing student management system architecture design document

Module-3: Outsourcing student management system architecture design document

2022-04-21 20:56:00 【InfoQ】

Preface

This paper is the detailed architecture design document of outsourcing student management system , It is used to guide the subsequent development of outsourcing student management system 、 Testing and operation and maintenance

glossary

Nginx： Is a high-performance HTTP And reverse proxy web The server

Mysql： A relational database management system

Laravel: It's a set of simplicity 、 elegant PHP Web Development framework (PHP Web Framework)

Swoole: Is a production environment oriented PHP Asynchronous network communication engine

Quasar： An open source based on vue Of GUI frame

1. Business background

With the continuous expansion of the scale of the school , The increase in the number of students , The information that needs to be processed is also increasing . It brings the following problems ：

Occupy a lot of teacher resources to deal with student information .

Manual data processing is inefficient , It's easy to make mistakes , Difficult to maintain .

Based on the above questions , We need to introduce the student management system , Realize the systematization of students' information relationship 、 Normalization 、 automation , The main task is to count all kinds of student information for daily management , Such as query 、 modify 、 increase 、 Delete 、 And students' course selection 、 Performance query and other functions of the design of the management system .

2. Constraints and restrictions

Must be in 2022.06.30 Number completed

The cost cannot exceed 50 ten thousand

Database adoption Mysql

3. Overall framework

3.1 Architecture analysis

3.1.1 High availability

For the student system , The loss of data will affect the teaching operation of the school , And it requires a lot of manual re entry , It's a very serious thing .

3.1.2 High performance

Estimate based on user size , No need for high performance considerations . If there is a need for highly concurrent scenarios for course selection , It can be solved by queuing and other technical solutions .

3.1.3 Scalable

It is expected that the system will use 3 To 5 year , The requirement for the amount of data is not high , But consider all kinds of demand expansion .

3.1.4 Security

Data involves student privacy , Permission involves system security , Just make strength requirements for background password management .

3.2 Overall framework

The whole system is divided into ： Student subsystem

、 Course subsystem 、 Permission subsystem

Use Nginx Responsible for requesting access , Reverse proxy requests to specific subsystems

Data storage requires some high availability , use MySql Lord 、 Backup Architecture

4. Detailed design

4.1 Core functions

4.1.1 Core business process analysis ：

4.2 Key design

1） Business scalability

Split into 3 Subsystem , Each subsystem is responsible for business realization in different fields , It is convenient for subsequent expansion of other functions

2） Data storage reliability

The data is stored in MySQL in , Each group has one main and one standby MySQL The server ,MySQL Copy data between servers to ensure high availability of data storage . If there is a replication delay between the master and the slave , Just at the right time MySQL The data cannot be recovered due to the failure of the primary server , Part of the message will be lost forever , In this case, there is no targeted design ,DBA It is necessary to monitor the replication delay between the master and the slave , When the replication delay exceeds 30 It needs to give an alarm and deal with it in time .

3） Back and forth

Administrators 、 Teachers' use scenarios are mainly PC End oriented , The main functions are basically crud, Students' use scenarios need to consider the implementation of mobile . Therefore, the development mode of separation of front and back is considered for the student subsystem . Front end use vue3 , The back-end using laravel The framework provides the interface . The teacher and the administrator help each other DCatAdmin The extension can quickly build the authority system and manage the background system .

4.3 design code

Permission subsystem development and use Laravel9+dcatadmin

Course subsystem development and use laravel9+dcatadmin

Student subsystem development and use laravel9 + swoole ;quasar + vue3 Developing front end systems

The data response between services adopts json Format

The interface follows Restful style

5. Quality design

5.1. ...Testability

api Interface to use apifox Conduct management , And configure automated test cases

laravel Unit testing is integrated in the framework , Function test and other modules , It can facilitate rapid development and testing

Back and forth , Students use Quasar frame , It is also integrated. unit testing 、 Browser test function , It can be tested separately .

5.2. Maintainability

The management background can use modules Expand and develop in modules .

5.3. Observability

The management system itself is a management background , It has certain observability .

Use laravel frame DCatAdmin Expand ,

The background operation has its own log management , Record key operations .

Can be built telescope Expand system monitoring , Log analysis , Abnormal record management, etc

6. Evolution planning

6.1 Student management system phase I

Focus on realizing core functions , First ensure that the system can operate correctly , Meet the use requirements of core scenarios . In the process, we will continue to collect the feedback from teachers and students .

6.2 Student management system phase II

Continuously improve the system after listening to users' feedback , Further tap user needs , Improve the system in terms of performance and user experience . In terms of performance, you can consider using swoole , At present, with the help of laravel9 Framework of the octane Extension can be very convenient to use swoole , Performance available 10 The above promotion .