Design And Research Of SAAS-Based Database Archi Tecture

With the rapid development of information technologies, information management system has gradually begun to spread. More and more enterprises and universities have begun to build their own information management system used to regulate their routine work and improve their work efficiency. In traditional delivery mode of educational information systems, applications and databases are established for each college in universities independently. It not only causes resources to be wasted, but also brings about a series of problems such as data inconsistency, data redundancy, etc. In order to solve the problems mentioned above perfectly, educational information system begins to be constructed based on SaaS (Software as a service).This paper presents a multi-tenant system framework integrated with self-sensing tenants’ data access platform and gives the application of the framework in educational information management system. The framework has been divided based on the application level and it provides platform basic services, data services and business services. Sharing database sharing schema and mixted-mode data extension mechanism is adopted in this framework. Besides it provides authorization mechanism, role-based authentication mechanism and multi-tenant model organization trees etc which implement the access control and authentication.The self-sensing tenants’ data access platform reads the predefined rules by parsing the user-defined configuration model, and then parses and reconstructs the abstract tree of the database access language according to the tenant’s information and the predefined rules. By doing this, we can finally realize the purpose that limit the access scope of tenants. The platform can enable the SaaS extension and avoids changes to the existing business code. In addition, in order to improve the fault tolerance and access efficiency of the multi-tenant system, application level vertical data sharding and horizontal data sharding based on consistent hashing is adopted and database cluster is used to reduce the load of the single database server. In this way, data access efficiency is greatly improved.In this paper, we combine SaaS and distributed database and take related exploratory study, and proposed the multi-tenant framework which is suitable for midum enterprises and universities. The multi-tenant framework proposed in this paper has the characteristics such as practicability, versatility, flexibility and good scalability, and using this framework to construct information system can greatly reduce the cost of both software and hardware. The multi-tenant framework has been successfully applied to the information management system of Shandong University.