Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010

    What kind of design flaw is data field re-use?

    We had a program malfunction because it re-used a data field to make a processing decision; when the characteristics of the data stored in the data field later changed, the program made a processing error and reported an incorrect amount. In general, I have avoided the practice using data fields for different, disparate purposes because it creates a hidden dependency. Someone asked me what the exact principle was for this design heuristic, and I could only reply that it is a form of coupling. Do you know a more specific rule that prevents this practice?

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    Domain integrity specifies that all columns in relational database must be declared upon a defined domain. The primary unit of data in the relational data model is the data item. Such data items are said to be non-decomposable or atomic. A domain is a set of values of the same type. Domains are therefore pools of values from which actual values appearing in the columns of a table are drawn.

    - Data integrity - Wikipedia, the free encyclopedia | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts