关系型数据库.pdf

1、MySQL HeatWaveSeema SundaraTechnical Architect,MySQL HeatWaveCopyright 2024,Oracle and/or its affiliates1MySQL is the#1open source databaseCopyright 2024,Oracle and/or its affiliates2Copyright 2024,Oracle and/or its affiliates3Innovative organizations across many industries run MySQL Do you?SocialSo

2、cialE E-CommerceCommerceTechTechFinanceFinanceManufacturingManufacturingMySQL is optimized for OLTP.What about OLAP?Copyright 2024,Oracle and/or its affiliatesOLTP ApplicationsOLAP ApplicationsSeparate analytics databaseComplex ETLNo real-time analyticsSecurity&compliance risksIncreased costsOLTP DB

3、OLAP DBETL ServiceMySQL HeatWave-one database is better than two!Copyright 2024,Oracle and/or its affiliatesInnoDBstorage engineHeatWaveanalytics clusterOne service for OTLP&OLAPNo ETL duplicationUnmatched performance,at a fraction of the costReal-time analyticsImproved securityApplications work wit

4、hout changesAnalytics tools and applicationsTransactional applicationsMySQL HeatWaveTransactions,real-time analytics across data warehouse and data lake,and machine learning in one database service6MySQL HeatWaveAnalyticsIn-database MLMySQL AutopilotOLTPSocial,eCommerce,IoT,gaming,fintech apps.Analy

5、tics and ML toolsSocial,eCommerce,IoT,gaming,fintech apps.Analytics and ML toolsObject StoreDatabase Database exportsexportsDatabase exportsStreaming dataData SourcesEnterprise AppsWeb/SocialLog filesIoTMySQL storageMySQL storageScales from 16 GB to 512 TBQueriesQueriesResultsResultsCopyright 2024,O

6、racle and/or its affiliatesNative high performance real-time,in-memory analyticsCopyright 2024,Oracle and/or its affiliatesAnalyticQueryQuery ResultsQueryPushdownInsert/UpdateReal TimeUpdateAnalytics EngineIn-Memory RepresentationAnalytic Query ExecutionAnalytic Job SchedulerResultsMySQL Database Se