Validation


Using validation to prevent errors

Open ModelSphere offers DBMS validations to prevent the most common errors in Data Definition Language (DDL) generation. It is recommended to validate the database information prior to interfacing with the database and make the corrections if necessary.

To validate your database:
  1. Select the database and right-click it.
  2. From the pop-up menu, choose Validate .
A report will be generated. It will give you the errors and hyperlinks will point to the concerned objects.




Common validation list (Generic)

The following validations are available on every database.
  1. Every object has a physical name.
    a. Every object’s physical name’s length does not exceed the maximum length.
    b. Every object’s physical name contains only valid characters.
    c. Every object’s physical name is not a word reserved by the corresponding DBMS.
    d. Every object’s physical name is unique inside the namespace.

  2. Every domain is bound to a type.

  3. Every column is bound to a type.

  4. Every table contains at least one column.

  5. Every primary, unique or foreign key columns does not exceed the maximum number of columns .

  6. Every column bound to a type that requires a length has one.

  7. Every column bound to a type that requires a Nbr. decimals value has one.

  8. Every primary/unique/foreign index has no column with a forbidden type.

  9. Every trigger contains instructions.

  10. Every procedure contains instructions.

  11. Every check constraint contains instructions.

  12. Every view has a selection rule.