Panoply.io - A blog about data management and data infrastructure

Data Technology

Subscribe to our emails and get Panoply updates on the fly.

Data Technology

MySQL vs Oracle

This series of posts analyzes how specific databases stack up against each other. We've covered the following comparisons so far:

[+]
Written by An Bui |May 22, 2018

Databases Data Technology

MariaDB vs MySQL: In-Depth Comparison 2018

Healthy competition can bring out the best in organizations. Just look at companies like Coke and Pepsi or General Motors and Ford, all of which were obsessed with outdoing the other while the....

[+]
Written by Matan Sarig |May 03, 2018

Databases Data Technology

Cassandra vs MongoDB in 2018

When it comes to NoSQL databases, MongoDB and Cassandra may seem similar but are quite different. Both have similar use cases, but are not intended for transactional data (i.e., accounting....

[+]
Written by Matan Sarig |May 01, 2018

Data Technology

PostgreSQL vs. MySQL

This series of posts analyzes how specific databases stack up against each other. We've covered the following comparisons so far: [+]
Written by An Bui |April 25, 2018

From raw data to analysis in under 10 minutes.

Sign up now for a demo or a free trail of the Panoply.io platform.

Learn more about platform features

Being Data Driven Data Technology

Business Intelligence and Data Warehousing Meet: Magic Ensues

Humans are visually-motivated. When we see a movie, we’re drawn to the most beautiful and exotic settings, the most striking and recognizable actors, the biggest explosions. What we don’t spend a....

[+]
Written by An Bui |April 19, 2018

Data Technology

PostgreSQL vs. MongoDB

This series of posts analyzes how specific databases stack up against each other. We've covered the following comparisons so far: [+]
Written by An Bui |March 16, 2018

Data Technology

DynamoDB vs. MongoDB

This series of posts analyzes how specific NoSQL databases stack up against one of the most popular NoSQL databases, MongoDB. We've covered the following comparisons so far:

[+]
Written by An Bui |February 01, 2018

Data Technology

Redshift vs. BigQuery: The Full Comparison

As we speak the future of cloud computing is being decided. Amazon and Google, as well as Microsoft and a few others, offer multiple cloud solutions for practically everything. Despite the....

[+]
Written by Roi Avinoam |January 31, 2018

Being Data Driven Data Technology

Redshift Benchmark: A First Test of the Entire Data Funnel

Amazon Redshift is a very powerful data warehouse, optimized for analyzing massive amounts of data in a blink of a second, when configured right.

[+]
Written by Roi Avinoam |January 24, 2018

Data Industry and Trends Data Technology

10 Critical ETL and Data Storage Posts You Need for 2018

2017 has come to an end, and as you're gearing up for a successful 2018, you might find a cheat sheet of essential ETL tools and data storage comparisions handy. This list provides commentary to....

[+]
Written by An Bui |January 05, 2018

Data Technology

Top 10 Tools for a Dangerously Effective Data Stack in 2018

The data industry continues to impress with new tools being released every month. While we all love choices, the current data stack landscape can be overwhelming. We’re here to help separate the....

[+]
Written by An Bui |December 19, 2017

Being Data Driven Data Technology

Enterprise Data Warehousing vs Data Virtualization: The Battle

Data analytics allows organizations to gain insight into their business operations and find new ways to increase their revenue. However, the data sources used to provide these insights are often....

[+]
Written by An Bui |December 12, 2017

Data Technology

Data Warehouse Design: The Good, the Bad, the Ugly

Good Business Intelligence (BI), allows your organization to query data obtained from trusted sources and use the answers to gain a competitive edge in your industry. The first step to achieving....

[+]
Written by An Bui |November 28, 2017

Data Technology

MongoDB vs MySQL: the differences explained

MySQL has become an inexpensive option for organizations around the globe that need a relational database. However, as the variety and volume of data has increased in recent years, non-relational....

[+]
Written by Matan Sarig |November 27, 2017

Being Data Driven Data Technology

Data Warehouse or Data Lake: How to Select the Right Solution

Data warehouses and data lakes are two different types of data storage repositories. Data warehouses integrate data from various sources and structures them for business reporting. Data lakes....

[+]
Written by An Bui |November 21, 2017

Data Technology

Database vs Data Warehouse - What's The Difference?

The future of any successful enterprise will hinge on its ability to harness and use massive amounts of data currently available, to improve productivity, decrease costs, and increase profits. How....

[+]
Written by An Bui |November 07, 2017

Data Technology

PostgreSQL vs MariaDB: In-Depth Comparison

PostgreSQL and MariaDB are open source databases, which boast of vast community support and development, as well as enterprise versions. While PostgreSQL has withstood time and continued....

[+]
Written by Cheryl Adams |October 31, 2017

Being Data Driven Data Technology

Embedded Analytics with Power BI and Azure

Business Intelligence (BI) has, by tradition, been a long and drawn out process. In the early days of computers, BI tools such as SAP/Crystal Reports and IBM/Cognos came along to speed things up.....

[+]
Written by Cheryl Adams |October 24, 2017

Being Data Driven Data Technology

Connecting to Data Warehouses in Tableau

Is it easy to connect to a data warehouse? Selecting the right tool can help make this connection attainable. Tableau Desktop makes this connection easy, from opening the software to connecting to....

[+]
Written by Cheryl Adams |October 05, 2017

Data Technology

Redshift Pricing: A Data Engineer's Guide

Although there are several data warehousing systems on the market, Amazon Redshift and Google BigQuery are the industry behemoths. There is a “prevailing consensus that Amazon is leading the pack.....

[+]
Written by Alon Brody |July 06, 2017

Data Technology

CouchDB vs MongoDB

Whether your database needs to run on a mobile device or scale to a humongous size, this post has you covered with CouchDB vs. MongoDB. One of these databases can run on your phone while the other....

[+]
Written by Matan Sarig |June 12, 2017

Data Technology

Redis vs MongoDB

The battle of the NoSQL databases continues. We first analyzed Cassandra vs MongoDB. This time we will dig in Redis vs MongoDB.

[+]
Written by Matan Sarig |May 29, 2017

Data Technology

Redshift Data Types. Day to Day Challenges.

Let's talk about data. The sheer volume of the data collected today is enormous. When I try to even imagine the amounts ... it's staggering.

[+]
Written by Alon Brody |May 15, 2017

Data Technology

Redshift Query Queues: The Complete Guide

Setting up a Redshift cluster that hangs on some number of query executions is always a hassle. When users run queries in Amazon Redshift, the queries are routed to query queues. Usually the....

[+]
Written by Alon Brody |April 25, 2017

Data Technology

AWS Spectrum, Athena and S3: Everything You Need to Know

Yesterday at AWS San Francisco Summit, Amazon announced a powerful new feature - Redshift Spectrum. Spectrum offers a set of new capabilities that allow Redshift users to seamlessly query....

[+]
Written by Roi Avinoam |April 21, 2017

Data Industry and Trends Data Technology

Amazon Athena Does Battle: Comparing Athena and Redshift

Data warehouse technologies are advancing towards interactive, real-time, and analytical solutions. In particular, cloud-based data warehouse technologies have reached new heights with the help of....

[+]
Written by Alon Brody |April 18, 2017

Data Technology

Lessons Learned From the Recent Amazon S3 Outage

On Feb 28th, Amazon Web Services (AWS), went down for approximately 4 hours. The outage occurred in Amazon’s US-East-1 facility in Virginia, their biggest region, and disrupted business continuity....

[+]
Written by Yaniv Leven |March 30, 2017

Product Data Technology

Introducing Panoply Multi Zone Redshift Service

Today’s considered data management best practices, advocate building resilient architectures that span multiple data centers, regions or even continents.

[+]
Written by Roi Avinoam |March 02, 2017

Data Technology

Redshift Security - Encrypting Loads with S3/KMS/Lambda

One of the main goals of this blog is to help developers and data architects, just like us, with their Amazon Redshift operations, including Redshift security. Starting from a full comparison with....

[+]
Written by Alon Brody |February 22, 2017

Data Technology

11 Great ETL Tools, and the Case for Saying “No” to ETL

Extract, Transform, and Load (ETL) is a data warehousing process that uses batch processing to help business users analyze and report on data relevant to their business focus. The ETL process....

[+]
Written by Alon Brody |January 09, 2017

Data Industry and Trends Data Technology

Apache Spark Architecture, Use Cases and Issues

If you’re looking for a solution for processing huge chuncks of data, then there are lots of options these days. Depending on your use case and the type of operations you want to perform on data,....

[+]
Written by Alon Brody |December 20, 2016

Being Data Driven Data Technology

Blitz Analyzing with Microsoft SandDance

Microsoft Research just released SandDance, a free web-based data visualization tool.

[+]
Written by Alon Brody |March 25, 2016