Research And Application Of Design Pattern Of Small-Medium Scale MIS

With the development of IT, the requirement for small-medium scale MIS has increased rapidly in every industry and business of the society. Small-medium scale MIS has become one of most popular application software. At the same time, the development always starts again from the zero for that the developers neglects their own experience and refinement of their solution, and this causes too much duplicated work and the bad design problem, it also causes the fact that the efficiency and the quality of the small-medium scale MIS can not satisfy the real requirement of customers.Design pattern is a greater granularity of software reuse. It can solve the main problems in the development of small-medium scale MIS. As the design pattern has been proved to be the outstanding design, it records the skill and the experience of the developer. Therefore the design pattern is accepted by most of software developer now, and the research and application of design pattern has become more and more thorough and widespread. Nowadays it has become a hot technology in software engineering domain. However the research of the design pattern in small-medium scale MIS is extremely few in both home and abroad, there are still many problems in the small-medium scale MIS. Therefore it has vital practical significance to do the research and the application of design pattern in the small-medium scale MIS.This thesis takes educational administration MIS of Shandong University of Science and Technology as an example, introduces the practical application of the design pattern in the software development: using the factory method pattern to produce the similar user interface in order to eliminate the duplicated work problem in the development of small-medium scale MIS, decoupling the tightly coupled component objects in the user interface by using the observer pattern. Thus the software has the flexibility, the extendibility and the maintainability. To solve the problem existing in the instantiation of design pattern such as the coupling between the application logic and the pattern logic, pattern overlapping and the documentation problem, this thesis also proposes a solution which separates the pattern logic and the application logic based on the friend class, this solution has resolved the problem which exists in the design pattern instantiation very well. The writing of the database query sentence also is one of main works in the development of small-medium scale MIS, therefore, in this thesis, I introduce the idea of reuse of the design experience of the design pattern into the writing of the database query sentence, combing with the basic operations of relational algebraic, according to the common problems which appears when writing the database query sentences, combining their practical experience, abstracting excellent solution from the multiple solutions, I propose a pattern set which can solve these frequently asked questions based on the Transact-SQL. Every pattern in the pattern set at least resolves one common question about database query. The patterns in this pattern set have been applied in the development of the educational administration MIS of Shandong University of Science and Technology and perform a very good role.The achievements of research in this thesis is very important for the development of small-medium scale MIS, they can reduce the development period of the small-medium scale MIS and improve its quality.