Volume 9 Number 2 (Feb. 2014)
Home > Archive > 2014 > Volume 9 Number 2 (Feb. 2014) >
JSW 2014 Vol.9(2): 382-388 ISSN: 1796-217X
doi: 10.4304/jsw.9.2.382-388

The Advantages of Using CHECK Constraints in The Academic Database Tables

Ema Utami
Magister of Informatics Engineering of The College of Information Systems and Computer Science AMIKOM, Ring Road Utara ST, Condong Catur, Depok Sleman Yogyakarta Indonesia

Abstract—Database plays important role on both web-based or desktop-based information system. Nowadays web-based information systems dominate information system application. Relational database systems such as Oracle, MySQL, MS SQL Server or PostgreSQL are familiarly used as data base management system. In Indonesia almost all academic information systems at higher education institutions are web-based application with RDBMS as database software. Some researches show the lack of data input validation that makes problem on data security and data quality. Input sanity is a problem that needs a serious attention. Data validation can be done by making a constraint in the database or application level. The fact is that validation in database level is less done by programmers. This research will perform the analysis of advantages or disadvantages from CHECK constraint on database table of academic information system.

Index Terms—CHECK constraint, input validation, input benchmark, data quality, academic database


Cite: Ema Utami, "The Advantages of Using CHECK Constraints in The Academic Database Tables," Journal of Software vol. 9, no. 2, pp. 382-388, 2014.

General Information

ISSN: 1796-217X (Online)
Frequency:  Bimonthly (Since 2020)
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, Google Scholar, ProQuest, INSPEC(IET), ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Apr 26, 2021 News!

    Vol 14, No 4- Vol 14, No 12 has been indexed by IET-(Inspec)     [Click]

  • Jun 22, 2020 News!

    Papers published in JSW Vol 14, No 1- Vol 15 No 4 have been indexed by DBLP     [Click]

  • Sep 13, 2021 News!

    The papers published in Vol 16, No 6 have all received dois from Crossref    [Click]

  • Jan 28, 2021 News!

    [CFP] 2021 the annual meeting of JSW Editorial Board, ICCSM 2021, will be held in Rome, Italy, July 21-23, 2021   [Click]

  • Sep 13, 2021 News!

    Vol 16, No 6 has been published with online version     [Click]