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

[PDF]

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:  Quarterly
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, CNKIGoogle 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]

  • Nov 18, 2021 News!

    Papers published in JSW Vol 16, No 1- Vol 16, No 6 have been indexed by DBLP   [Click]

  • Dec 24, 2021 News!

     Vol 15, No 1- Vol 15, No 6 has been indexed by IET-(Inspec)   [Click]

  • Nov 18, 2021 News!

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

  • Nov 25, 2022 News!

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