Bill Hayden Director, Data Services Edward Jones

1. Bill Hayden Director, Data Services Edward Jones

2. Data Virtualization • Define data virtualization • Data virtualization History • The future of data

3. Definition • Data exists at disparate sites • Updates accepted at each site • Capable of running independently • Synchronized by replication technology

4. Data Replication History • Backups taken daily • Sent off site via PTAM • Stored or sent to second site • 24-hour replication latency • Really only good for disaster recovery

5. Replication Today • Mix of technologies • Database replication • File system replication • Disk based replication • Clustering • Publisher/Subscriber model • Remote copies read only or inaccessible • Consistent points of time

6. The Vision • Update anywhere on ALL data • Sites can be geographically disbursed • Data is synchronized in seconds • Status is reported up the stack

7. Issues • Distance • Conflicts • Race Conditions • Split brain • Database of record

8. Industry Status • Databases—Almost there! • File services—NFS and CIFS • Best hope is file sharing appliances • They own the file system and the disk • File systems • Disk replication • Needs to become logical • Read-only at the target site

9. Thank You

10. Questions