Universal Database Management Tools

Database is used more and more extensively in the various trades and occupations. Along with evolution of information, these different commercial databases have also created a problem of isomerous database. It is not convenient for the database administrator and user, they need to be familiar with many kinds of database management system to manage and use database in many kinds of database management platform. It is very useful to develop a Universal Database Management Tool which masks the isomerism data source and provides a universal management platform for the database administrator and user.This dissertation has studied the relational database management system. Based on the demand of a Universal Database Management Tool, this dissertation applises ADO.NET to construct a Universal Database Management Tool based on .NET framework. The tool can manage and use isomerous data and can migrate data between databases. Data access of the tool is powerful, and it can hot switch database server.Accessing database is the most frequent operation in the database management system. Therefore, the key technology of developing a Universal Database Management Tool is to design a universal data access component, this component can mask isomerism database, and provide a universal interface of data access. This dissertation deeply study Microsoft's universal data access technology, and propose a solution of universal data access model, and implement the solution by applying design patterns.In the database management system, it is very important to edit and execute SQL statements for administrator and user. Studing Microsoft's technology specification"Rich Text Format Specification (v1.7)", this dissertation designed a rich text box control, not only printing reserved keywords with syntax highlight but also prompting the keywords available by the intellisence. When the user type a letter which a keyword start with, the control can provide keywords available and can help the user to complete to type automatically the best keyword which is prompted by the intellisence.The Universal Database Management Tool can manage and use isomerous data source with universal interface. During developing the Universal Database Management Tool, a syntax highlight rich text control with intellisence and a universal data access component were designed and implemented. Both of them can be reused in the development of software based on .NET framework.