Data Integrity Overview

For data to have integrity means that the data is valid—that is, correct and accurate—and that the relational structure of the database is intact.

The relational structure of the database is described through referential integrity constraints, which are business rules that maintain the consistency of data between tables.

SAP Sybase IQ supports stored procedures and JDBC, which allow you detailed control over how data gets entered into the database. For information on JDBC, see the SAP Sybase IQ Programming guide.

• How Data Can Become Invalid
  Data may become invalid without proper checks.
• Rules and Checks for Valid Data
  To help ensure that the data in a database is valid, formulate checks that define valid and invalid data, and design the rules to which data must adhere.
• Statements That Change Database Contents
  Client applications change information in database tables by submitting SQL statements.
• Data Integrity Tools
  Use data constraints and constraints that specify the referential structure of the database to maintain data integrity.
• Statements that Implement Integrity Constraints
  Implement integrity constraints by submitting SQL statements.