1 / 9

THE ART OF PARALLEL HETEROGENEOUS DATA TRANSFORMATION

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).

Télécharger la présentation

THE ART OF PARALLEL HETEROGENEOUS DATA TRANSFORMATION

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. THE ART OF PARALLEL HETEROGENEOUS DATA TRANSFORMATION Deema Alswaimil, Eric DeVeau06/18/2012

  2. Outline • Define Oracle GoldenGate (OGG) • History • Properties • Project Overview • Projects’ Steps • ERD • Q & A

  3. 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.

  4. 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.

  5. 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.

  6. Project Overview • Build an application-Java based to transfer database to/from different environments • Heterogeneous operating systems and Database i.e. • Linux • Windows Xp

  7. Projects’ Steps • Get two VM-Ware machines • Install Linux, Windows XP • Install My MySQL, Oracle SQL • Install OGG • Create Database • Implement Java App

  8. 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

  9. Thank you! Q & A

More Related