turbocharge your sql queries in- memory with apache® ignite™€¦ · memory with apache® ignite...
TRANSCRIPT
DENIS MAGDAProduct Manager, Apache PMC Chair
TurbochargeyourSQLqueriesin-memorywithApache®Ignite™
www.ignite.apache.org #apacheignite
IN-MEMORY DATA FABRICSTRATEGIC APPROACH TO IMC
IN-MEMORY SQL GRID
ANSI-99SQLCompliantAggregations,groupby,sortingCross-cachejoins,unions,etc.
DMLandDDLJDBC,ODBC,NativeAPIsDistributed
AlwaysconsistentFaulttolerant
DISTRIBUTED COLLOCATED QUERIES
CollocatedModeAnykindofJOINs(ANSI-99)Datahastobecollocatedinadvance*
RecommendedmodeAvoidsdatamovementEnabledbydefault
DISTRIBUTED NON COLLOCATED QUERIES
Non-CollocatedModeNoneedtocollocatedataDatamovementonjoins
JustificationNotfeasibletoachievecollocationTosupport100%ofallSQLqueries
DISTRIBUTED DML
ANSI-99CompliantINSERTUPDATEDELETEMERGE
APIsJava,.NET,C++ODBC&JDBC
APACHE IGNITE WEB CONSOLE
ConfigurationWizardFullClusterConfigurationRDBMSSchemaImport
ManagementandMonitoringClusterMonitoringQueriesMonitoring
QueriesExecution
APACHE ZEPPELIN
DATA ANALYSIS WITH TABLEAU
THANK YOU!
www.ignite.apache.org #apacheignite