Database architecture of OLTP in the SaaS-based multi-tenant Educational Enterprise Resource Planning (Java Enterprise Edition(JEE) Based Engineering approach)

Abstract

In conventional delivery mode of Educational Enterprise Resource Planning (EERP) 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 related to data management. As technologies like virtualization assume important places within the IT landscape, higher education leaders will need to consider which institutional services they wish to leave to customer choice, which ones they wish to outsource "somewhere else: of course cloud," and which services they should operate centrally or locally on campus. In order to solve the problems mentioned above perfectly, Educational Enterprise Resource Planning information system begins to be constructed based on SaaS. In this paper, a schema of distributed database architecture in the SaaS-based multi-tenant Educational Enterprise Resource Planning information systems (OLTP) JEE based application is proposed and a distributed database access process module is implemented.