MANEJEMEN BASIS DATA UNTUK APLIKASI INTERNET OF THINGS (IoT)

Abstract

This research highlights the importance of maximizing the implementation of data integrity constraints in Relational Database Management Systems (RDBMS), particularly within the context of Internet of Things (IoT) applications. Data quality in information systems is often compromised because many systems rely solely on application-level validation, which allows non-compliant data to enter and causes issues such as duplication or inconsistency. Using a pure experimental design, this study compares two main conditions: a table without maximized constraints (Control Condition) and a table with full constraint implementation (Experimental Condition), encompassing Primary Key, Foreign Key, Unique, Not Null, and Check constraints. Simulated test data deliberately designed to violate each type of constraint was used to evaluate the database's rejection capabilities. The results prove that constraints serve as a highly effective primary data security layer. Each type of constraint such as the Primary Key preventing duplication and the Foreign Key maintaining relational consistency between tables successfully and automatically rejected invalid data without any application system intervention. This comprehensive use of constraints not only significantly reduces input errors and enhances the reliability of real-time data in IoT systems but also results in a more structured and efficient database design. This study confirms that data integrity must be guaranteed directly at the database layer to achieve higher and more consistent data quality.