I ntroducon to MemSQL Introducon This whitepaper introduces MemSQL as a modern data plaorm with the speed, scale and cost efficiencies to generate business value and insights from operaonal data. You’ll learn how MemSQL is designed and built to ingest data at high speeds, scale-out efficiently and deliver record-breaking query performance with familiar relaonal SQL. Data Plaorm Landscape Historically, databases fit into one of two categories: those opmized for online transaconal processing (OLTP) and those opmized for online analycal processing (OLAP). Transaconal systems are tradionally separate from Analycal processing systems, even though they could potenally be combined into a single system. Transacon systems are oen revenue generang, have strict availability requirements, and are viewed as mission crical. OLAP running on Data warehouse systems are used to analyze large amounts of data and require a lot of compung resources. They are not generally as mission crical. Combining data warehouse and transacon systems in a single database generally results in the transacon workload suffering and thus affecng the business adversely. Hence, separaon of the two has become standard. A third type of data plaorm, called an operaonal data store (ODS), is used to support operaonal analycs. This data plaorm allows the business to have near real-me visibility into rapidly changing events, such as orders and/or customer interacon. Success of the operaonal data store is driven by the ability to handle streaming ingest of data with a high number of concurrent analycal queries. 3