Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

7 total results found

What is Cloud Computing?

AWS Solutions Architect Understanding Amazon Web Services (AWS)

Cloud computing is essentially a group of computers (servers) and other compute resources managed by a third party (AWS, Microsoft, Google) in a data center somewhere.  One important characteristic of the leading cloud providers is the ability to quickly and f...

Why is the Cloud so Popular?

AWS Solutions Architect Understanding Amazon Web Services (AWS)

There are multiple reasons why the cloud market is growing so fast. Some of them are listed here: Elasticity, Security, Availability, Faster hardware cycles, System administration staff, Faster time to market. These factors are crucial when trying to develop...

The Five Pillars of a Well-Architected Framework

AWS Solutions Architect Understanding Amazon Web Services (AWS)

If there is one must-read white paper from AWS, it is the paper titled AWS Well-Architected Framework, which spells out the five pillars of a well-architected framework. The full paper can be found here. A component is the code, configuration, and AWS Resourc...

Understanding Relational Databases

Redshift Data Management

Simply put, you can think of databases as software that simply stores and organizes data in an efficient way. When we think of databases, we tend to think of what are called Relational Databases because they store data in a relational way. This means the data ...

big-data
data
data-engineering

OLAP vs OLTP Databases

Redshift Data Management

Online Transactional Processing (OLTP) There are two major types of Relational Database architectures: OLTP and OLAP. OLTP stands for "Online Transactional Processing". This original architecture stemmed from early applications (like banking software) needing...

big-data
data
data-engineering

Organizing Redshift

Redshift Data Management

Now that we understand the basics of creating primary keys, the concept of foreign keys, and the basics of OLAP. We will dive into how a distributed database like Redshift is best optimized. Distributed Compute Engines In a world driven by data, businesses g...

Redshift Distribution and Sort Keys

Data Build Tool (DBT) Optimization