Research Of Data Access Layer Based On Database Dictionary

At present, in software development technologies, relational database is the most popular database technology, and object-oriented technology is the most popular database application software technology. But the relational database itself is impossible to achieve the seal of database operation and data. So in most cases software developers are facing with how to design a good data accessing structure which could link data and the operation, to have access to high performance, maintainability, scalability and flexibility of the system.The purpose of this thesis is to study a suitable Data accessing layer structure for Management Information Systems. The structure is a flexible combination of the existing design models and data access layer based on the data dictionary database access technology. And it is a structure which is layered explicit, and easy to develop and maintain. This model can be used as reference to development the similar systems.First, the popular data access technology is outlined in this thesis, then analysis of 3-tier architecture using design patterns and SQL generator based on data dictionary technology is presented. Finally, a new data access layer structure based on data dictionary is devised, which is combining the advantages of both from the aspect of scalability and maintainability of the software. And its implementation and application is introduced in a practical project.