August 2020 Summaries

You can run SingleStoreDB Self-Managed effectively on Windows, using the Windows Subsystem for Linux Version 2 (WSL 2). This is a development cluster running on a single host, and not suitable for production deployments. You can also run Singlestore Helios for free or spin up a SingleStore cluster on Linux, on Docker Desktop, on Kubernetes, or on Vagrant, all in roughly 10 minutes. SingleStore is a Linux program exclusively, so it doesn't run directly on other operating systems. Windows features WSL 2, which hosts a Linux kernel in a lightweight Virtual Machine (VM), allowing you to run any Linux program on Windows. To run SingleStore on WSL on Windows, you need a machine with at least four cores and 4GB of RAM. SingleStore provides free licenses that allow you to run a four-node cluster, with community support, for as long as you'd like. You can get a free license by registering at singlestore.com/self-managed-standard/. To install WSL 2 on Windows, you need to install all available Windows Updates and then enable the Windows Subsystem for Linux. After installing WSL 2, you can download the kernel update from https://wslstorestorage.blob.core.windows.net/wslblob/wsl_update_x64.msi and install it. You can then set up a SingleStore cluster on Ubuntu running on WSL 2 by downloading the memsql-deploy command-line tool, creating a variable for your license key, and running the `memsql-deploy` command. To verify that the cluster is running, you need to run the `wsl memsql-admin list-nodes` command. You can then launch SingleStore Studio and connect to the cluster using the root username and password.

SingleStore has been adopted by Thentia, a global leader in regulatory software, as the core operational database for its cloud-based regulatory licensing, assurance, and enforcement technology. This partnership enables Thentia to achieve fast response times and automate a historically paper-based regulatory compliance process, which is crucial at a time when scamming is on the rise and regulators need modern digital solutions to protect public health. With SingleStore's speed and scale, Thentia can process billions of events and perform real-time analytics, providing its customers with unparalleled analytical power. The adoption of SingleStore also enables Thentia to build reports and leverage machine learning and predictive algorithms to generate insights, which is more effective than using Excel documents. This partnership highlights the importance of data in protecting public safety and the need for scalable and secure architectures to support regulatory bodies in their obligations.

The SingleStore company has been announced as a winner in the 2020 SaaS Awards, specifically in the category of Best SaaS Innovation for The Internet of Things. This recognition is a testament to SingleStore's commitment to innovation and customer satisfaction, particularly in providing cloud-native solutions for operational analytics and IoT applications. Nikita Shamgunov, co-CEO and founder of SingleStore, highlighted the company's unique solution, SingleStore Helios, which provides real-time streaming data ingestion with low latency queries in the cloud, enabling instant insights from IoT devices and sensor systems. The award is a significant milestone for SingleStore, demonstrating its expertise in delivering transformative solutions to modern business needs.

Infiswift uses AI to help meet real-world challenges through Internet of Things (IoT) deployments, optimizing physical device operation with connectivity and data. The company's innovative platform makes it easy to connect and manage endpoints at scale with security and build solutions that open new services or improve existing ones. Infiswift empowers customers to be data-driven in industries such as renewable energy, agriculture, and manufacturing. They have chosen SingleStore as the real-time insights engine of their platform for fast, reliable analytics and powering machine learning models. The platform reliably ingests data from any endpoint, delivering real-time insights across streams of data as they enter the system, improving equipment reliability and optimizing costs. Infiswift has found a adaptable database platform that can manage fast ingestion of intermittent data in SingleStore, which also supports JSON data, scalable transactions, relational SQL, compression, and AI/ML integration. The company's choice of SingleStore meets their four key requirements: an in-memory rowstore, on-disk columnstore with compression, SQL support, and availability both on-premises and in the cloud. With SingleStore, Infiswift can efficiently enable data-driven operations and deliver high-performance IoT systems that meet operational requirements.

In a recent Forbes article, Nikita Shamgunov, co-founder and co-CEO of SingleStore, discusses the growing importance of digital twins in various industries. Digital twins can be applied to any business or product, extending their uses beyond industrial and heavy machinery to consumer electronics and financial services. To create an effective digital twin, a company must consolidate its data and provide a single pane of glass across all data services, requiring modern data management capabilities. Successfully maintaining a digital twin demands real-time data access and scalable data management, which SingleStore can help achieve with its solutions.

SingleStore has been shortlisted as a finalist in two categories for the 2020 SaaS Awards: Best SaaS for Business Intelligence or Analytics, and Best SaaS Innovation in the Internet of Things. The company's cloud database, Singlestore Helios, is being recognized for its unique combination of fast in-memory rowstore, disk-based columnstore, predictive low-latency analytic query capability, and MySQL compatibility. This recognition highlights SingleStore's ability to deliver instant, effortless access to a scalable data platform for operational analytics, machine learning, and AI, which is particularly important in today's digital transformation era. The company's focus on real-time decision-making and its competitive advantage in terms of latency are also being acknowledged by the SaaS Awards program.

The exchange is a crucial component of the economic system, with various markets built to facilitate buyers and sellers meeting and transacting. The advent of computers and the internet has enabled online trading, reducing transaction times from months to seconds. Building an exchange requires expertise spanning multiple fields, including game theory, computer science, and finance. A centralized exchange platform solves the centralized clearing problem by ensuring market integrity and facilitating trades. However, building such a system is complex, and existing tutorials often focus on high-frequency market making or proprietary trading rather than exchange-side operations. The Chicago Mercantile Exchange (CME) has implemented a successful solution, but its architecture may not be directly applicable to cryptocurrency exchanges due to differences in market characteristics and volatility. Bitwyre aims to address this gap by building a derivatives exchange that offers institutional traders exposure to cryptocurrency price movements without holding the underlying coins, utilizing a cash settlement system and separation of wallet functionalities to mitigate risks. The platform uses SingleStore as its database and Redpanda for streaming processing, aiming to lower latency and improve performance compared to existing solutions.

Hadoop has moved through various stages of the Gartner Hype Cycle, from being a revolutionary technology with high expectations and enthusiasm, to experiencing disillusionment and failure due to its inability to analyze data at scale. After a trough of disillusionment, Hadoop is now entering a maturity phase, where it will be used for what it does best - as a low-cost, high-volume storage platform with reliable batch processing. The adoption rate has declined significantly, but early adopters have learned from their experiences and are now using Hadoop in a more thoughtful and effective way. Emerging trends include the use of relational databases, cloud-based services, object storage, and hybrid data architectures that combine the strengths of different technologies to deliver better performance and business outcomes.