The Research Of Practice Teaching Management System Based On The Multitenant

At present, universities and colleges in our country are through information construction to strengthen the teaching management, improve the level of teaching management. Now, however, software developers for the development of colleges and universities teaching management platform using directional type development mode, this way of development has a high cost, low reusability and more difficult maintenance. With the development of the theory and technology of computer software, this article use the Saa S(software as a service) model, based on the theory and technology of multi-tenancy, studying the practice teaching management system that based on multi-tenant database in Saa S mode. The work and the major innovations of this thesis include:Firstly, this thesis studies put forward the hierarchical model of multi-tenant data management in Saa S mode. According to the hierarchical model of multi-tenant data management, for software service developers block many data model which has nothing to do with the tenant’s; Meet the needs of the tenant data pattern customiza- tion, Shared storage and isolation access by the tenant data models; The logic of data storage was achieved by logical storage model.Secondly, this thesis studies put forward the data storage model based on many common table and key/value pair. The data storage model based on many common table and key/value pair can not only improve the data storage density, reduce most of the empty value column should be reserved waste of storage space, but also to expand the tenant data part of the split, make the extension method is more flexible and convenient.Thirdly, it analyses and gives the problems of Multi-tenant database design in the practice teaching management system with Saa S mode, the corresponding of the tenants and its user, its user rights management, the expansion of the tenant data, which are inevitable in the process of multi-tenant database design that oriented Saa S application, and gives the concrete thinking and implementation method.Fourthly, based on the.NET environment, In order to SQL Server 2008 As a database management software, adopts the hierarchical model of multi- tenant data management and the data storage model based on many common table and key/v- alue pair, developed the practice teaching management system based on multi-tenant, reduces the development costs and maintenance costs of system, enhances the applicability and reusabi- lity of the system.