Open AccessActive Database System Approach and Rule Based in the Development of Academic Information System
Author(s) -
Mohamad Amin,
Andino Maseleno,
Karthik Ravi Shankar,
Eswaran Perumal,
Vidhyavathi Ramasamy,
S.K. Lakshmanaprabu
Publication year - 2018
Publication title -
international journal of engineering and technology
Language(s) - English
Resource type - Journals
ISSN - 2227-524X
DOI - 10.14419/ijet.v7i2.26.14361
Subject(s) - active database , database , computer science , database testing , database design , physical data model , database theory , event (particle physics) , database schema , centralized database , view , database tuning , database server , container (type theory) , software , programming language , engineering , mechanical engineering , physics , quantum mechanics
Active database system is a database system which is capable of generating a certain action automatically if it detects an event that meets certain conditions. The existence of Event Condition Action (ECA) rules and functional components such as triggers, stored procedures, and stored functions that are owned by active database system make the database system has the ability to automatically monitor input and output data. Separation of ECA rules components in the database with the application program will also facilitate the development of information systems. This research applies active database system in academic information system, so that academic business rules can be planted in database software and be able to produce the right solution automatically. The addition of active database system components to the database software makes procedures such as subject distribution, study plans, academic leave, values, thesis defense and other processes can be monitored by the system automatically. This can be done because between applications and databases use the model driven approach parameters to communicate with each other. The results of this research prove that a database is not only has function as a container of data, but can control the information system actively, this is caused by the logic of programs that are generally planted in the application layer that can be moved and planted in the database software.