Thread: Database modelling question for version management of data

Database modelling question for version management of data

From
Gianni Mariani
Date:
I'm sure this problem has been solved by someone.

I am designing a retail product database and I need to "version control"
the contents of the database.  The requirements include rollback,
branching, merging etc.

I can think of some fairly expensive techniques to manage the data but I
was wondering if someone has some insights into some optimizations.

G








Re: Database modelling question for version management

From
Ron Johnson
Date:
On Sun, 2003-08-17 at 04:05, Gianni Mariani wrote:
> I'm sure this problem has been solved by someone.
>
> I am designing a retail product database and I need to "version control"
> the contents of the database.  The requirements include rollback,
> branching, merging etc.
>
> I can think of some fairly expensive techniques to manage the data but I
> was wondering if someone has some insights into some optimizations.

triggers and history tables?

--
+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net           |
| Jefferson, LA  USA                                            |
|                                                               |
| "Man, I'm pretty.  Hoo Hah!"                                  |
|    Johnny Bravo                                               |
+---------------------------------------------------------------+