Monday, 15 March 2010

What is this approach to database updating called? -



What is this approach to database updating called? -

say have set of objects in database: {a, b, c, d}

now, business logic has generated new list {a, b, e, f} , needs update old one:

two options nowadays themselves:

1)

remove entire list {a, b, c, d}

insert entire list {a, b, e, f}

2)

calculate items no longer needed: {c, d}

calculate items need added: {e, f}

remove {c, d}

insert {e, f}

now, naturally 1 of these approaches puts more load on db, , other puts more load on client.

my question is, these 2 approaches called? (read: can refer them in email , have other person understand and/or google , sensible, clarifying explanations?)

thanks!

database

No comments:

Post a Comment