Skip site navigation (1) Skip section navigation (2)

Re: data integrity

From: "Thomas J Keller" <kellert(at)ohsu(dot)edu>
To: pdxpug(at)postgresql(dot)org
Subject: Re: data integrity
Date: 2007-03-30 22:02:38
Message-ID: 09DAB1D2-9AE6-45D1-B62F-D566C906FFC0@ohsu.edu (view raw or flat)
Thread:
Lists: pdxpug
An example of a data integrity issue is where my web form asks for  
the PI last name and the client gives me both first and last name. Or  
they put their name in the PI name field (PI stands for principle  
investigator - the person who got the grant that we will charge  
funded), or they put an extra digit in what should be an 8-digit  
string if they are here at OHSU, but could be any length if they are  
from somewhere else. Or they use a grant identifier (called an  
"alias") that is valid but belongs to someone else. Stuff like that.

My biggest complaint about FMP is that it can't do rollbacks. So a  
simple error can lead to catastrophic loss of data. Plus, in the last  
few years they've wanted to charge for upgrades about every 6 months.  
OHSU used to have a site license, but dropped it.

Thanks,

Tom K
kellert(at)ohsu(dot)edu
503-494-2442


On Mar 30, 2007, at 12:57 PM, Rich Shepard wrote:

> On Fri, 30 Mar 2007, Thomas J Keller wrote:
>
>> Would one of the local gurus like to give a talk on strategies for
>> improving data integrity?
>
> Tom,
>
>   How do you define "data integrity?"
>
> Rich
>
> -- 
> Richard B. Shepard, Ph.D.               |    The Environmental  
> Permitting
> Applied Ecosystem Services, Inc.        |          Accelerator(TM)
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:  
> 503-667-8863
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that  
> your
>       message can get through to the mailing list cleanly
>



In response to

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2007-03-30 22:33:26
Subject: Re: data integrity
Previous:From: Rich ShepardDate: 2007-03-30 19:57:04
Subject: Re: data integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group