Research And Implementation Of Database Conceptual Model Visualization Based On The MDA

With the continuous development of the software industry, the deepening awareness of software engineering, database modeling in software development process has become an important role.Two data models in database design are the concept model which has noting to do with the specific database model and the physical model associated with the specific database model. Traditional database model always separate the concept model design and the physical model design. When the physical model need to be amended,in order to maintain the consistency of the document, the concept model has to be modified.When the model is large, the workload is considerable, greatly reduced the productivity of database design.To solve these problems, this paper gives a: the database conceptual model visualization design based on the MDA. In the Proposal, conceptual model of the database is equivalent to PIM in the MDA model, physical model is equivalent to PSM in MDA model. In this paper, the research work mainly on the following areas:1. Introducing the MDA standards, the main model, conducting depth study for MDA's key technologies, pointing out the difficulties in the implementation of MDA is conversion between models,as data files in conversion, MDA should uniform format, proposing XML data format is the best document storage format.2. Design the system EREditor about the database conceptual model visualization. This system followed MDA architecture's the standards and using the Java. In design model, the system using MVC model to separate model, view and control in favor of the expand of tools fuction; The system using C/S structure, making the concept of software design model can be passed to the server, facilitating the server make the conversion between the concept model and physical model. At the same time, the system can receive and verify the concept model which is converted by physical model or transmited from the server. As Java is platform-independent language, using of Java making the system EREDitor in line with the MDA's PIM (platform-independent Model) technical standards.3. Establishing XML storage of the conceptual model of visualization. Design DTD files in accordance with XML1.0 norms, this will inevitably improve the efficiency of database design and consistency of the database documents.The XML storage of the database conceptual model can lay the foundation for complete reverse engineering.4. Applying the system EREditor to Flight booking system's concept model, verify the tool's feasibility and correctness.