Design And Implementation Of General Data Management System

In modern enterprises, especially the IT related, database is usually used as the tools for data storage and management. Oracle and MySQL are two commonly employed databases. Generally, in order to achieve the data query and management, the business department needs to put forward a requirement of data management system. And then, the technical staff will develop the corresponding graphical system to enable the users to query and modify the data via a self-service manner. The core of the data management system is the system authentication management and database table operations, which are add, delete, alter, query and so on. In the development of the data management system, besides the different operation caused by the different database table structure, most of the coding work is duplicated which will due to low development efficiency.In this paper, a general service system for high level application is promoted through analysis and research on the architecture of the data application system, specification and separation of the operation process and abstract of the connection between the system generality and components. The goal to rapidly publishing qualified system can be achieved via coding and configuration following the specification and adding plug-ins to the system.There are kinds of ways to specify and structure software. The system can be break down to roles and actions via the software engineering theory of object-oriented design pattern, which is more flexible and spreadable than the other theories. It can short the development period; decrease maintains cost and match general level of the modern software technology.The goal of this paper is to discuss the possibility of providing application with a plug-in manner in a rapidly changing system of data structure and requirement via design and architecture the base of data management system and make further argumentation of the theory and realistic meaning in the software design and implement level through developing the object relationship diagram and showing the core functional code.The final achievement of the general data management system is the both a commercial product and a suit of reusable reference software design model. On the other hand, general database management system is just an implementation of the model mentioned above. With this model, the user could develop application systems meeting their requirements in short time by adjusting the component specification and modifying the operation process. All the convenience and flexibility are based on the object oriented service system architecture and logic separation of application and data with a plug-in manner. Meanwhile, the support system itself is a combination of smaller core and plug-in, which can be replaced any time according to the requirement so that this will achieve the most reusability with the minor modification.A conclusion can be presented by the argumentation of this paper:to construct a system, there is always a simple core to provide the basic service no matter how complex and flexible of the business requirement. The outer logic can be varied but with a specific plug-in manner, the low-coupling-high-cohesion of the software design theory can be achieved.