The Design And Implementation Of OpenBASE Enterprise Manager

Nowadays, we have been the Information Age. The amount of the world's data increases in an incredible speed. More and more corporations make the storage and management of data a single task. Therefore, there are increasing applicable chances for large scale relational database. In this background, the management of database system has been of great significance. Generally, Database Enterprise Manager is made up of a series of computer program. It provides the software environment for user or database administrator, who is responsible for managing the database system effectively and keeping integrity of data info. In the same time, it provides data information and function interfaces for user of authorization, and user can manage data in database, such as creation, maintenance, accessing and deletion. Database Enterprise Manager is a bridge of relation between people and data in database. Database Enterprise Manager is one of important elements of database.This subject is to design and implement the Enterprise Manager for relational database OpenBASE, and it performs well in the engineering projects.Considering the knowledge reusability of the program, MVC (Model-View-Controller) design pattern is used in this subject. There are MVC structures designed for all the tree, node and guide UI etc in the program. It makes functional extensibility a very easy thing. Java Swing component technology is also used in the design and the implementation. This brings Swing's superiority of Graphics User Interface into full play. We directly use GUI to operate and display various database objects, such as table, view, index, user, task etc. The input of complicated SQL statement is replaced simply by mouse's click, which make it much easier to manage database than before. Furthermore, we see that users are familiar with Windows operation system, so we make UI object in Windows style, such as tree structure of database, right key menu and etc. And, hot key help function is designed and implemented. These arc all strengthening for usability of OpenBASE Enterprise Manager.In the engineering application, OpenBASE Enterprise Manager, which is the set software of OpenBASE database, is used in many internal enterprises. Because of the cross-platform characteristic of Java, OpenBASE Enterprise Manager performances well in both Windows and Linux operation system, and the simply GUI gains database users' appreciation.