Helping ordinary people create extraordinary websites!

A Flexible Method of Storing Control Data

By Tony Marston
2006-08-29

Summary

This design has the following advantages:


  • Values can be added to or removed from the control table without having to
    alter the structure of the table. The structure of the table remains static
    while it is only the contents which are varied.
  • Because individual values are held on totally separate records, individual
    values can be locked without affecting other values.
  • Because each value is held on a separate record it is easier for the table
    to hold 1000's of records than it is for the table to contain 1000's of fields.
  • By using a different value for record_id it is possible to use
    the same table for different sets of control data, such as for an individual
    application instead of the whole system.





Tutorial pages:
 4 Votes

You might also want to check these out:


Leave a Comment on "A Flexible Method of Storing Control Data"
You must be logged in to post a comment.

Link to This Tutorial Page!


GET OUR NEWSLETTERS