Model Your Data Before You Move it
Presented by:
Clay Jackson
Clay Jackson is a Sr. Database Solutions Architect for Quest, specializing in Database Performance Management and Data Movement Tools. Prior to joining Quest, Jackson was the DBA Manager at Darigold. He also spent over 10 years managing Oracle, SQLServer and DB2 databases and DBAs at Washington Mutual. While at WaMu, Jackson was the Enterprise Database Compliance Officer, with responsibility for Database Security and Disaster Recovery. He was also responsible for Oracle databases at Starbucks and US West. While at Starbucks, he participated in the Oracle 7 Alpha Test, and was part of the Oracle Very Large Database Customer Focus Group. He is also part of the OAK Table Group
No video of the event yet, sorry!
Model Your Data Before You Move It Data movement is a transformative force in today's digital landscape, enabling organizations to unlock the true value of data. Successful data movement requires a comprehensive data governance strategy that encompasses data selection, understanding, quality, mapping, schema development, and serialization.
Effective data selection prioritizes valuable data, minimizing unnecessary overhead. Understanding the data through reverse engineering and modeling ensures seamless movement across systems. Data governance ensures data quality through scans, code generation, and validation rules, guaranteeing accuracy.
Mapping, both physical and logical, enables integration between source and target systems, while semantic mapping ensures proper interpretation. Schema development adapts data to different databases, while serialization techniques facilitate efficient encoding and decoding.
Data governance establishes policies and guidelines for data selection, deepens understanding, and fosters accurate movement. Automation streamlines schema development and serialization, reducing manual efforts and ensuring consistency. Code generation automates transformation logic, enabling efficient and repeatable data movement.
Data governance is the key to unlocking the power of data movement, ensuring accurate, efficient, and reliable transfers. With automation and standardization, it optimizes resources and empowers organizations to make informed decisions based on valuable data assets.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference: 2026
- Language:
- Track:
- Essentials
- Difficulty:
- Easy