Design of database architecture in the saas-based multi-tenant educational information system

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). In this paper, a schema of distributed database architecture in the SaaS-based multi-tenant educational information systems is proposed and a distributed database access process module is implemented based on J2EE technology. Through parsing and adjusting database access language semantics in the system architecture layer, the process module redirects the database access target of every tenant. In this way, the process module parses the query statement and processes the query results with the whole process being transparent to tenants. In addition, framework of application system with process module integrated into is also given in this paper.