Tag: use case

Feed: MemSQL Blog. Author: Eric Hanson. The limitations of a typical, traditional relational database management system (RDBMS) have forced all sorts of compromises on data processing systems: from limitations on database size, to the separation of transaction processing from analytics. One such compromise has been the “sharding” of various customer accounts into separate database instances, partly so each customer could fit on a single computer server – but, in a typical power law, or Zipf, distribution, the larger database don’t fit. In response, database administrators have had to implement semi-custom sharding schemes. Here, we describe these schemes, discuss their limitations, ... Read More

Feed: Planet PostgreSQL. It is well known that database design should be as simple as possible, and follow the normalization process. Except in some cases, sometimes, for scalability purposes. Partitioning might be used to help deal with large amount of data for instance. But what is a large amount of data? Do you need to pay attention to those scalability trade-offs now, or can you wait until later? How far can you go with a naive schema? To answer those questions, it might be best to estimate the evolution of the size of your database in the following months. Here’s ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Rowid filtering is an optimization in MariaDB 10.4. Its target use case is as follows: a table uses ref access on index IDX1 but it also has a fairly restrictive range predicate on another index IDX2. In this case, it is advantageous to: Do an index-only scan on index IDX2 and collect rowids of index records into a data structure that allows filtering (let's call it $FILTER). When doing ref access on IDX1, check $FILTER before reading the full record Example Consider a query SELECT ... FROM orders JOIN lineitem ON o_orderkey=l_orderkey ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Aaron Burciaga. We live in a world driven by insights and decision making fueled by data and analytics. Information and technologies are so ubiquitous that no organization needs to be a digital titan (such as Amazon or Google) to compete in today’s world of business. Companies, large and small, are recognizing the need to utilize the full value of their enterprise data to obtain an essential competitive edge. Since business competition can be fierce, it is now, more than ever, necessary for a company to be able to adeptly appropriate data assets ... Read More

Feed: Liquid Web. Author: Melanie Purkis; Almost all businesses rely on online services for critical business processes, if not directly for revenue.Downtime and performance disruptions represent lost productivity and sales, along with mitigation, reputation, and other costs.The real cost of tech glitches and outdated technology could mean millions.For this reason, a large and growing number of businesses make a modest investment in upgrading their infrastructure to an architecture based on server clusters.What is a Server Cluster?A server cluster is a unified group of servers, distributed and managed under a single IP address, which serves as a single entity to ensure ... Read More

Feed: Neo4j Graph Database Platform. Author: Jocelyn Hoppa. Neo4j is thrilled to offer a brand new look to the GraphAcademy University Program with updates specifically for instructors – teaching Neo4j in a classroom lab setting! We have been working hard to provide resources for educators to help students learn about Neo4j and introduce graph database concepts to the education community. Let’s take a look at the details of who and what qualifies, what’s offered and how to get started!Program QualificationsQualification to the new Neo4j Educator Program is designed for instructors of accredited, non-profit educational institutions. Instructors can fill out a ... Read More

Feed: AWS Compute Blog. Author: Neelay Thaker. This post is contributed by Jeff Underhill | EC2 Principal Business Development ManagerAmazon Corretto is a no-cost, multiplatform, production-ready distribution of the Open Java Development Kit (OpenJDK). Production-ready Linux builds of JDK8 and JDK 11 for the 64-bit Arm architecture were released Sep 17, 2019. Scale-out Java applications can get significant cost savings using the Arm-based Amazon EC2 A1 instances. Read on to learn more about Amazon EC2 A1 instances, Amazon Corretto, and how support for 64-bit Arm in Amazon Corretto is a significant development for Java developers building cloud native applications. What ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Dr. Markus Bestehorn. Gaining access to sensor data or telemetry of industrial machines is a key requirement for implementing high-value use cases around smart manufacturing or Industry 4.0. For instance, predictive maintenance or automated quality control is not possible without having such data at a high temporal resolution.Given the heterogeneous environment of modern industrial production lines with many different machine types, it’s difficult to access machine data because the machines’ interfaces may use different protocols. This post provides a detailed look at the conversion of industrial protocols and extracting ... Read More

Feed: AWS Architecture Blog. Amazon Web Services (AWS) serves more than a million private and public sector organizations all over the world from its extensive and expanding global infrastructure.Like other countries, organizations all around New Zealand are using AWS to change the way they operate. For example, Xero, a Wellington-based online accountancy software vendor, now serves customers in more than 100 countries, while the Department of Conservation provides its end users with virtual desktops running in Amazon Workspaces. New Zealand doesn’t currently have a dedicated AWS Region. Geographically, the closest is Asia Pacific (Sydney), which is 2,000 kilometers (km) away, ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. SSIMWAVE customers – from film producers to network engineers to media business executives – work to some of the highest standards in the world. They demand to work with the best. SSIMWAVE also works at that level, as the company’s 2015 Emmy award for engineering achievement demonstrates. They also ask the same high standards of their technology vendors/partners. For SSIMWAVE’s rather comprehensive analytics needs, only one database makes the grade: MemSQL. SSIMWAVE has unique technology and unique analytics needs. SSIMWAVE mimics the human visual system, enabling the software to quantify the quality of video ... Read More