A New Generation of Database for a New Class of Operational Workloads The only way to deliver true real-time decision making at organizational scale is to combine ingest, transactions, and analysis in a single, continually updated, fast database. This is where a new generation of database can help. Specifically, scalability is addressed using new operational analytics processing solutions that are fully distributed and can run as a single database across a pool of machines while maintaining consistency and stability. This allows an organization to scale out. This new generation of database can speed up transaction processing, avoiding batching on ingest. It can also speed up analytics processing, making real-time analytics at scale possible. And it can combine both processes and enable true, end-to-end, real-time decision-making. These are all areas where MemSQL excels. MemSQL is a distributed, highly scalable, SQL database that can run anywhere. It delivers maximum performance for transactional and analytical workloads with familiar relational data structures. MemSQL ingests data continuously to perform operational analytics for critical industrial operational systems. It can ingest millions of events per day while simultaneously analyzing billions of rows of data in relational SQL, JSON, geospatial, and full-text search formats. Organizations that use MemSQL get high ingestion performance at scale, and eliminate the need for costly data integration tools with built-in batch and real-time data pipelines. MemSQL lets organizations achieve ultra-fast query responses across both live and historical data using familiar ANSI SQL. This highly scalable, distributed system balances data and queries across a cluster of commodity serv- ers or cloud instances for maximum performance, concurrency, and availability. Infrastructure elements that enable these characteristics include: · Distributed storage that allows for the processing of data across clusters of machines for maximum resilience and performance. Distributed storage helps an application more efficiently leverage system memory and disk infrastructure. · Massively parallel architecture that provides a robust parallel execution engine for both updates and queries, delivering ultra-fast performance. · Big data capacity that allows for the storage of petabytes of data on low-cost disk and cloud storage (for archive requirements) while maintaining instant retrieval for fast, deep analysis. · ANSI SQL support so the widest possible range of ad hoc queries, BI tools, application interfaces, and programming language interfaces can be supported. Combined, these capabilities allow MemSQL to deliver: · Extremely fast performance · Massive scalability · An easy-to-use SQL architecture · Cloud-native, able to run on any cloud infrastructure or commodity hardware · Reasonable price, with strong price-performance Copyright (©) 2019 RTInsights Industrial IoT Data Collection & Analysis for Real-Time Decision-Making and Predictive Maintenance 12
