Databases Resources

Four Easy Steps to Set Up Multi-Store in OpenCart

OpenCart is one of the most popular eCommerce platforms available on the market today. In this article, we will walk through the simple steps involved in setting up the multi-store feature using a single OpenCart installation.

February 19, 2016

by Saumil Shah

· 10,073 Views · 2 Likes

Loading Data Into Azure SQL Data Warehouse

I’m not an ETL expert. In fact, I haven’t done any professional ETL work for several years. My skills are, at best, rusty. With this in mind, I knew I’d have a hard time extracting data from a local database in order to move it up to Azure SQL Data Warehouse. Read on to hear about my journey.

February 18, 2016

by Grant Fritchey

· 14,257 Views · 6 Likes

The Most Important Elements of Cloud-Based Applications

Scalability, security, cost savings, integration/connectivity, and stability/availability are all important elements of cloud-based applications.

February 18, 2016

by Tom Smith

CORE

· 9,094 Views · 3 Likes

Expecting Failures in Microservices and Working Around Them

Learn more about microservice failures, and ways to circumvent failures in this excerpt from "Microservices in .NET."

February 17, 2016

by Christian Horsdal

· 28,777 Views · 7 Likes

Making the Impossible Possible with Tachyon: Accelerate Spark Jobs from Hours to Seconds

Barclays Data Scientist Gianmario Spacagna and Harry Powell, Head of Advanced Analytics, describe how they iteratively process raw data directly from the central data warehouse into Spark and how Tachyon is their key enabling technology.

February 16, 2016

by Henry Powell

· 38,063 Views · 8 Likes

Write JUnit Tests in Spring With Mocked and Real Objects

How to use mocked and non-mocked data to write unit tests using the free and open source JUnit framework.

February 16, 2016

by Saravanan Kandasamy

· 17,260 Views · 7 Likes

Graph Databases 101

Let’s talk about graph databases. Some industry watchers claim that they are the fastest-growing type of database. If so, maybe it’s useful to know more about them. So, let's start with the basics: what is a graph database, and what is it useful for?

February 16, 2016

by Adnan Khaleel

· 14,489 Views · 14 Likes

What’s the Difference Between OLTP and OLAP?

As you plan your analytics and data architecture on AWS, you may get confused between Redshift and Aurora. Both are advertised to be scalable and performant. Both are supposedly better than incumbents. Both have optically inspired names. So, what’s the difference?

February 16, 2016

by Kiyoto Tamura

· 17,588 Views · 4 Likes

Running AWS Lambda Functions in AWS CodePipeline Using CloudFormation

Recently, AWS announced that they’ve added support for triggering AWS Lambda functions into AWS CodePipeline–AWS’ Continuous Delivery service. In this article, I’ll describe how I codified the provisioning of all of the AWS resources in the documentation using CloudFormation.

February 12, 2016

by Paul Duvall

· 17,938 Views · 1 Like

Executives' Perspectives on the Evolution of Data Management

Data management has evolved very rapidly since the introduction of Hadoop and big data.

February 12, 2016

by Tom Smith

CORE

· 5,686 Views · 1 Like

The SOLID Principles in Real Life

You're likely familiar with the SOLID principles. Here's a breakdown of the SOLID principles in a real-world setting.

February 12, 2016

by Erik Dietrich

· 228,607 Views · 110 Likes

Enable Docker Remote API on Docker Machine on Mac OS X

Check out how to enable the Docker Remote REST API on a Docker Machine running on Mac OS X in this neat tutorial!

February 12, 2016

by Arun Gupta

· 9,656 Views · 2 Likes

Create a JSON API REST Service With Spring Boot and Elide

Learn how to make a HSON API REST service using Elide and Spring Boot in this awesome tutorial. The JSON API is a great specification for developers, and is getting much more popular.

February 11, 2016

by Matthew Casperson

· 71,784 Views · 10 Likes

MySQL Password Expiration Features to Help You Comply With PCI-DSS

PCI Compliance requires users to change their passwords every 90 days. Luckily, since MySQL version 5.6.6 there’s a password_expired feature which allows one to set a user’s password as expired.

February 10, 2016

by Peter Zaitsev

· 6,216 Views · 2 Likes

Solr vs Elasticsearch: Battle of The Query DSLs

Comparing Solr and Elasticsearch on how they control ranking, and how their query DSLs stack up against each other.

February 10, 2016

by Doug Turnbull

· 10,978 Views · 11 Likes

How to Create a High Performing API

In a nutshell: data analysis, use cases, and thinking about what's essential.

February 10, 2016

by Mary Katherine Sullivan

· 7,582 Views · 5 Likes

Your Application Probably Doesn't Need a Database

Zone Leader Sam Atkinson asks whether you really need that particular part of your stack, and whether local storage is a good alternative.

February 9, 2016

by Sam Atkinson

· 29,759 Views · 10 Likes

SQL Performance Tuning: Query Optimization 101

The following page describes some of the best practices of using SQL queries from a performance perspective. We use Oracle as our primary reference but most of the recommendations are applicable to other RDBMS SQL engines as well.

February 8, 2016

by Bikram Sinha

· 23,158 Views · 9 Likes

Problems Being Solved With Databases — Executives' Perspectives

Databases are enabling companies to use data to inform real-time decisions about their business as well as to use predictive analytics to make better informed, real-time decisions.

February 8, 2016

by Tom Smith

CORE

· 22,851 Views · 2 Likes

What Are the Most Important Elements of Databases?

The most important elements of the database depend upon the application at hand.

February 7, 2016

by Tom Smith

CORE

· 24,726 Views · 3 Likes

The Latest Databases Topics