Posts

Showing posts from 2020

Amazon Document DB

Image
Amazon DocumentDB (with MongoDB Compatibility)  

Redshift Architecture

Image
 An Amazon Redshift data warehouse is an enterprise-class relational database query and management system. Amazon Redshift is a fully managed highly scalable data warehouse service in AWS. Here is the list of features covered list of features components Amazon Redshit top features list : Leader Node Optimizing the Data Warehousing Compute Node Petabyte Scale Node Slices Automated Backups Massively Parallel Processing Restore the data fast Columnar Data Storage Network Isolation Data Compression Query Optimizer RedShift Spectrum Leader Node   Communication with data apps  Distribution of workloads  Caching of query results  Maintenance of catalog tables Compute Node ·        Handle all query processing, in parallel execution (MPP) ·        Dense compute no...

Kubernetes -Recipe

Image
What is Kubernetes   Kubernetes is an open-source container-orchestration system for automating application deployment, scaling, and management . Kubernetes provides highly resilient infrastructure with zero downtime deployment capabilities, automatic rollback, scaling, and self-healing of containers.  Kubernetes is portable in nature, meaning it can run on various public or private cloud platforms such as AWS, Azure, OpenStack, or Apache Mesos        

Validating database objects after migration using AWS SCT and AWS DMS

AWS provides several  tools and services  that provide a pre-migration checklist and migration assessments.  You can use the  AWS Schema Conversion Tool  (AWS SCT) to convert your existing database schema from one database engine to another.  AWS Database Migration Service  (AWS DMS) makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores.                         ORACLE                MS SQL SERVER                        PostgreSQL                         Package                            Package SELECT object_name AS package_name   FROM ...