90 likes | 191 Views
THE ART OF PARALLEL HETEROGENEOUS DATA TRANSFORMATION. Deema Alswaimil, Eric DeVeau 06/18/2012. Outline. Define Oracle GoldenGate (OGG) History Properties Project Overview Projects’ Steps ERD Q & A. Define Oracle GoldenGate (OGG).
E N D
THE ART OF PARALLEL HETEROGENEOUS DATA TRANSFORMATION Deema Alswaimil, Eric DeVeau06/18/2012
Outline • Define Oracle GoldenGate (OGG) • History • Properties • Project Overview • Projects’ Steps • ERD • Q & A
Define Oracle GoldenGate (OGG) • Oracle GoldenGate is Oracle’s strategic solution for real time data integration. • Gives a nonstop availability and access to the real time data. • Translational data between operational and analytical systems. • OGG will filter, route, verify and deliver transactional data in real-time across Oracle and heterogeneous environments.
History • GoldenGate Software Inc founded in 1995 in San Francisco. • Founders: Eric Fish, Todd Davidson. • Originally designed for the fault tolerant Tandem computers. • Oracle acquired GG in September 2009.
Properties • Data is sent in “real-time” with sub-second speed. • Support heterogeneous environment. • High performance with low impact. • Flexible modular architecture. • Reliable and extremely resilient to failure and data loss.
Project Overview • Build an application-Java based to transfer database to/from different environments • Heterogeneous operating systems and Database i.e. • Linux • Windows Xp
Projects’ Steps • Get two VM-Ware machines • Install Linux, Windows XP • Install My MySQL, Oracle SQL • Install OGG • Create Database • Implement Java App
Online Policy System RANDOM FIRST RANDOM DOMAIN RANDOM MIDDLE RANDOM LAST CUSTOMERS CUSTOMERS DBMS_RANDOM PL/SQL Purchase Workload Simulator Belong DISCOUNT TYPE POLICIES POLICY TYPES
Thank you! Q & A