Tag: storage

Feed: AWS Architecture Blog. Building on the first three parts of the AWS Lambda scaling and best practices series where you learned how to design serverless apps for massive scale, AWS Lambda’s different invocation models, and best practices for developing with AWS Lambda, we now invite you to take your serverless knowledge to the next level by reviewing the following 10 topics to deepen your serverless skills.1: API and Microservices Design With the move to microservices-based architectures, decomposing monothlic applications and de-coupling dependencies is more important than ever. Learn more about how to design and deploy your microservices with Amazon ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Some MariaDB features are not available in SQL Server. At a first glance, it is not important to know about those features to migrate from SQL Server to MariaDB. However, this is not the case. Using MariaDB feature that are not in SQL Server allows to obtain more advantages from the migration, getting the most from MariaDB. This page has a list of MariaDB features that are not supported in SQL Server. The list is not exhaustive. Storage engines The sql_mode variable determines in which cases an SQL statements should fail with ... Read More

Feed: AWS Big Data Blog. Part 1 of this multi-post series, ETL and ELT design patterns for lake house architecture using Amazon Redshift: Part 1, discussed common customer use cases and design best practices for building ELT and ETL data processing pipelines for data lake architecture using Amazon Redshift Spectrum, Concurrency Scaling, and recent support for data lake export.This post shows you how to get started with a step-by-step walkthrough of a few ETL and ELT design patterns of Amazon Redshift using AWS sample datasets. Prerequisites Before getting started, make sure that you meet the following prerequisites: This post uses ... Read More

Feed: AWS Big Data Blog. Part 1 of this multi-post series discusses design best practices for building scalable ETL (extract, transform, load) and ELT (extract, load, transform) data processing pipelines using both primary and short-lived Amazon Redshift clusters. You also learn about related use cases for some key Amazon Redshift features such as Amazon Redshift Spectrum, Concurrency Scaling, and recent support for data lake export.Part 2 of this series, ETL and ELT design patterns for lake house architecture using Amazon Redshift: Part 2, shows a step-by-step walkthrough to get started using Amazon Redshift for your ETL and ELT use cases ... Read More

Feed: R-bloggers. Author: David Smith. [This article was first published on Revolutions, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. R 3.6.2, the latest update to the R language, is now available for download on Windows, Mac and Linux. As a minor release, R 3.6.2 makes only small improvements to R, including some new options for dot charts and better handling of missing values when using running medians as a smoother on charts ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Modern DBMSs implement several advanced features. While an SQL standard exists, the complete feature list is different for every database system. Sometimes different features allow to achieve the same purpose, but with a different logic and different limitations. This is something to keep into account when planning a migration. Some features are implemented by different DBMSs, with a similar logic and similar syntax. But there could be important differences that users should be aware of. This page has a list of SQL Server features that MariaDB implements in a different way, and ... Read More

Feed: Alation. Author: Nolan Necoechea. December 11, 2019— Hundreds of data sources. Hundreds (even thousands) of data consumers. Millions of datasets. Gone are the days when static metadata repositories and manual curation were enough (if they ever really were). To keep up with the rapid influx of data, the many disparate data environments, and the rise in self-service analytics users, enterprises need an enterprise data catalog to drive the business forward with data, and ensure compliant, accurate data use. In a recent report*, Gartner analysts, Ehtisham Zaidi and Guido De Simoni, call augmented data catalogs an “enterprise must-have” for data ... Read More

Feed: Planet PostgreSQL. Being a PostgreSQL database administrator and managing backups on a daily basis, one of the new features of Barman 2.10 that I liked the most is the transparent management of .partial WAL files during recovery. And, most likely, you feel the same if you have been using Barman with WAL streaming and have been asked to perform a full recovery of an instance.The context: RPO=0 backups and recovery The concept of RPO (Recovery Point Objective) is crucial in the process of Disaster Recovery. It represents the maximum amount of data you can afford to lose. When applied ... Read More

Feed: Redis Labs. Author: Haley Kim. You probably already know Redis as the most launched, most used, and most loved database in the world. What you may not know is that Redis has evolved from a caching and session-storage solution into the primary database for high-performance stateful applications.  At AWS re:Invent 2019, our friends Junaid Fakhruddin and Bhilhanan Jeyaram from Gap and Brandon Mahoney of Alliance Data joined Redis Labs Chief Product Officer Alvin Richards on the stage in a breakout session—Using Redis Beyond Caching—sharing their Redis journeys and how their organizations went from using Redis for simple use cases ... Read More

Feed: James Serra's Blog. Author: James Serra. With two new relational database features (Result-set caching and Materialized Views) just GA’d in Azure Synapse Analytics (formally called Azure SQL Data Warehouse), it makes for some very compelling reporting performance options when combined with Power BI. In this blog I’ll discuss the different ways you can make Power BI queries run faster, and whether you still need Azure Analysis Services or if the tabular model (i.e. “cube”) within Power BI is enough. Note there is a separate preview version of Azure Synapse Analytics which adds workspaces and new features such as Apache Spark, ... Read More