Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Your Frame of Reference Expand / Collapse
Author
Message
Posted Sunday, July 7, 2013 11:25 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:05 PM
Points: 33,165, Visits: 15,299
Comments posted to this topic are about the item Your Frame of Reference






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1470978
Posted Monday, July 8, 2013 3:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 8, 2014 7:06 PM
Points: 211, Visits: 306
I agree we have to view the problem from the clients perspective. Its a skill I pride myself on.
Can I just whinge about the link to the updateable snapshot?
What's wrong with updating the base table and then regenerating the snapshot? This is a far better solution than updating the base table and reading some data from the snapshot and some from the original database as proposed in the article. The approach discussed in the article leads to data inconsistencies.


IMHO


We are the pilgrims, master.
We shall go always, a little further.
Post #1471091
Posted Monday, July 8, 2013 7:14 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:06 AM
Points: 211, Visits: 1,109


Nice Article with very good title.

My frame of reference and general work environments do not let me to try to invigilate new technologies and even to implement solutions other than practiced in my past. We may need to hear the debate such as "reinventing the wheel" in very broader sense, or at least credit from our managers.

But surely the new enhancements in development tools should be given a chance to clearly help ease our new developments or upgrades.

Thank you!
Post #1471174
Posted Monday, July 8, 2013 10:32 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:05 PM
Points: 33,165, Visits: 15,299
Jamie Ingram-729524 (7/8/2013)

Can I just whinge about the link to the updateable snapshot?
What's wrong with updating the base table and then regenerating the snapshot? This is a far better solution than updating the base table and reading some data from the snapshot and some from the original database as proposed in the article. The approach discussed in the article leads to data inconsistencies.


IMHO


I'm not sure if this is an issue with data inconsistency. I believe the scenario was that someone needs to work with data at a point in time for reconciliation. Using some app, rather than rewriting the app to also point to the existing database while reading from the snapshot. With this technique, you can update some information in the existing database, and if you are reading from the same view/synonym, you see the updated data.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1471275
Posted Tuesday, July 9, 2013 7:04 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:55 PM
Points: 1,649, Visits: 4,693
Somewhat related... Oracle has a feature called "Flashback" that leverages the transaction log to query the state of data for any table at a point in time using the "AS OF TIMESTAMP" clause of the SELECT statement. I can see how this could come in handy for quickly viewing past modifications when change data capture isn't implemented, or even recoving data without going to backup.

SELECT * FROM employees
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '60' MINUTE);

What do you think?
Post #1471597
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse