[AccessD] Stored Procedure not producing results

<<<
So. Today's job is to dig out that PITA article and pitch it to somebody.
>>>
Arthur,

I must say I did "muse" on similar to your PITA ("Point in Time
Architecture") subject somewhere in year 1992 or 1993, that time in FIDO
groups and in Russian...

Am I wrong - wasn't that feature of versioned database data somehow limited
but built-in way implemented in Borland Interbase?

And in MS SQL Server it can be relatively inexpensive way
implemented/simulated using triggers - correct?

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com
Sent: Wednesday, November 22, 2006 3:15 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Stored Procedure not producing results

Right on. That's why I suggested the default GetDate(). 

There is a whole other subject on this, about which I have written, but I
googled it and it didn't come up, so perhaps I wrote it and forgot to sell
it to somebody.  The gist is this: it's called PITA, which doesn't mean pain
in the arse, but rather Point In Time Architecture. Without PITA, the
central problem with relational databases is that they don't provide an
instant "roll back to August 1" capability. With PITA, they do. It's not all
that complicated, but it does require a detailed walk-through so you can
understand all the implications, the most critical of which is, "Nothing is
ever updated. An updated row is actually replaced, and the updated row's
EndDate column is updated to reflect the datetime on which the row was
"changed". Thus it becomes possible to issue a query that reflects the state
of the database on August 1, 2005. Obviously this increases the size of the
db significantly, but in certain environments (such as medical), this is
critical -- who was
 JWC's physician on that date, and what tests were performed, and by which
medicos, and so on.

So. Today's job is to dig out that PITA article and pitch it to somebody. 

Arthur


<<< tail skipped >>>