Category: In-Memory

Feed: MemSQL Blog. Author: Eric Hanson. Released this March, MemSQL 6 Beta 1 introduced MemSQL Procedural SQL (MPSQL). MPSQL supports the creation of: User-Defined Functions (UDFs) Stored Procedures (SPs) Table-Valued Functions (TVFs) User-Defined Aggregate Functions (UDAFs) A Hidden Gem: Array Types There’s a hidden gem in MemSQL 6 Beta 1 that we didn’t document at first — array types!  These make programming much more convenient. Since we compile your extensions to machine code, the performance is fantastic. And you don’t have to leave the comfort of your database language to get it. To declare and initialize a new array of ... Read More

Feed: MemSQL Blog. Author: Bryan Offutt. Apache Spark has made a name for itself as a powerful data processing engine for transforming large datasets in a swift, distributed manner. After using Spark to complete such transformations, you often want to store your data in a persistent and efficient format for long-term access. The common solution of storing data in HDFS solves the issue of persistence, but suffers efficiency issues as a result of the HDFS disk-based architecture. The MemSQL Spark Connector solves both of these issues by providing an easy to use Spark API for reading from, writing to, and ... Read More

Feed: MemSQL Blog. Author: Alec Powell. In today’s wave of Enterprise Cloud applications, having trust in a data store behind your software-as-a-service (SaaS) application is a must. Thus, multi-tenancy support is a critical feature for any enterprise-grade database. This blog post will cover the ways to implement multi-tenancy, and best practices for doing so in MemSQL. With smaller amounts of data in the tens of Gigabytes, it is easy to throw more hardware at the problem to scale up as traditional databases would. However, as table sizes grow, you need to think about ways to scale your multi-tenant database across ... Read More

Feed: MapD Blog - Thoughts on GPU databases, data visualization and integrated analytics. Author: Todd Mostak. Since starting work on MapD more than five years ago while taking a database course at MIT, I had always dreamed of making the project open source. It is thus with great pleasure to announce that today our company is open sourcing the MapD Core database and associated visualization libraries, effective immediately. The code is available on Github under an Apache 2.0 license. It has everything you need to build a fully functional installation of the MapD Core database, enabling sub-second querying across many ... Read More

Feed: MemSQL Blog. Author: Mason Hooten. At Strata+Hadoop World, MemSQL Software Engineer, John Bowler shared two ways of making production data pipelines in MemSQL:1) Using Spark for general purpose computation2) Through a transform defined in MemSQL pipeline for general purpose computation In the video below, John runs a live demonstration of MemSQL and Apache Spark for entity resolution and fraud detection across a dataset composed of a hundred thousand employees and fifty million customers. John uses MemSQL and writes a Spark job along with an open source entity resolution library called Duke to sort through and score combinations of customer ... Read More

Feed: MemSQL Blog. Author: Gary Orenstein. Data is fueling the world’s most valuable companies. Today the list is topped by Apple, Google, Microsoft, Amazon, and Facebook. These top companies harness data to drive outsized value. While the companies are unique, they share a more common approach to analytics than you might expect. The Rapid Rise of Data Capture for Analytics In a short span, entire industries have been born that didn’t exist previously. Each of these areas is supported by one or more of the world’s largest companies App stores from Apple and Google Online music, video, and books books ... Read More

Feed: Hazelcast Blog. Author: Bilal Yasar. In this article series, we are going make demo/tutorial about how to deploy and monitor hazelcast cluster to kubernetes. Also we will execute scale up/down scenarios, failover scenarios, changing configuration, rolling-upgrade cases. Prerequisite Scenario As a user, we want to deploy hazelcast cluster and hazelcast management center to our kubernetes cluster without making any configuration. Also we want to monitor our hazelcast cluster. We want to pass hazelcast.xml to hazelcast cluster. We want to scale up/down the hazelcast cluster easily. Currently we don’t have any running pods,services etc.. We selected to use minikube, you ... Read More

Feed: MapD Blog - Thoughts on GPU databases, data visualization and integrated analytics. Author: Ed O'Donnell. We’re very happy to announce that with today’s release of version 3.0 of the MapD Analytics Platform we're bringing GPU-accelerated analytics onto distributed clusters!We’ve been hard at work for months to extend the unique advantages of our SQL-compliant GPU database from being able to run on one server to now being able to scale across multiple servers, allowing our customers to take on even larger datasets while still maintaining the fluid, instant data exploration experience which we’ve become known for. Check out our distributed ... Read More

Feed: MapD Blog - Thoughts on GPU databases, data visualization and integrated analytics. Author: Tai Dupree. The MapD Immerse visual analytics client has a core feature we refer to as crossfilter, which allows a filter applied to one chart to simultaneously be applied to the rest of the charts on a dashboard. This provides a natural interface for data exploration, allowing a multi-dimensional view of data even as a user drills deep into a dataset. From a technical perspective, crossfiltering is not difficult (on the surface). Behind each Immerse chart is a SQL statement. When an element on the chart ... Read More

Feed: MapD Blog - Thoughts on GPU databases, data visualization and integrated analytics. Author: Todd Mostak. Today I’m proud to announce that MapD Technologies has secured $25M in funding in a Series B round lead by New Enterprise Associates (NEA) with participation from NVIDIA, Vanedge Capital, and Verizon Ventures.This new investment will allow MapD to scale up its engineering, sales, and marketing teams to accelerate product development and deepen customer adoption. It will help us move faster toward our vision of making GPU-powered analytics ubiquitous in the enterprise. There are clear signs this is already happening. Look no further than ... Read More