6-（線上）崔星燦 FFA-Xingcan-ZH.pdf

《6-（線上）崔星燦 FFA-Xingcan-ZH.pdf》由會員分享，可在線閱讀，更多相關《6-（線上）崔星燦 FFA-Xingcan-ZH.pdf（28頁珍藏版）》請在三個皮匠報告上搜索。

1、Oracle CDC Practice with Flink and LogMiner 崔星燦 Software EngineerWealthsimple Outline 1. Introduction 2. Solution Overview 3. The Oracle CDC Connector 4. Other Jobs 5. Future Work Introduction#1 About Wealthsimple A Fintech Startup Based in Toronto #1 Wealthsimple Invest Robo-Advisor #2 Wealthsimple

2、 Trade DIY Stock/Crypto Trading Weathsimple Cash Saving Account Ready for Investment and Daily Use #3 About the BOR Team Book of Record Team Track the Financial Assets (Cash, Security etc.) Writing Transactions to Oracle General Ledger Reading Transactions from Oracle General Ledger Accounting with

3、the Extracted Transactions The Ledger Reading Problem Service A Service B Service C Service D? SQL Queries on DB Views The Source of Truth Service A Service B Service C Service D Change Data Capture Data Pipeline Unification Solution Overview#2 Our Goals To Replicate Oracle Database To Generate an Ordered Transaction Stream (Database View) Try to Preserve Oracle Transactions Systems Involved The F