AWS Relational Database Service

Transportation (Heterogeneous) Industry Vertical made their application availability 100% with 45% Increase in End-to-End Query performance

Business Need: 

Industries that depend on data extractions from Distinct source like Databases, Sensors, Files Systems, Events, and Logs needs to deal with multiple Data Handling Methods. Designing an Architecture with a specific Data Handling Capability, might not be an efficient way of Implementation. Capturing the data from a streaming process and storing the data in the easy extractable format might be a challenge.

Solution and Approach:

AWS Relational Database Service (RDS) provides Storage and Data Processing Medium for structured/Semi Structured data with very popular Query Engines Like PostgreSQL, Oracle, MySQL, Maria Db and Aurora DB. A key feature which made AWS RDS most popular is, it can connect from anywhere in the organization. 

Designing an Architecture which includes AWS RDS as a core component, Transportation industry vertical can capture the data from Files, APIs, Databases, and store in RDS. This approach has overcome the challenge of storing and retrieving the data to/from Multiple Storage Devices.

AWS RDS can be able to establish connection from anywhere within the organization. It requires only Client Software to Read/Write the data into AWS RDS. As it is a service provided by AWS, organizations were charged on for the resources used. 

Now Transportation industry vertical Users can Read/Write the data directly into a Single database from multiple locations, applications, API and Databases with the approach discussed.

Benefits:

Amazon RDS is a managed service, which means it provides a high level of security for PostgreSQL databases. These include network isolation using Amazon Virtual Private Cloud (VPC)and private subnet, encryption keys created by the organization and control through AWS Key Management Service (KMS) and encryption of data in transit using SSL.
The automated backup feature of Amazon RDS enables recovery of database instance to any point in time within specified retention period defined by the organization. So, it is very useful in disaster recovery.
On a higher level of scope there is almost 45% increase in the Query performance from End-to-End and 18% lesser cost. Because of the backups enabled, data and platform are almost 100% available to use. With this approach Administration and User Management is reduced to more than 70%.

Posted by wissenadmin | 11 August 2022
APPROACH & SOLUTION: OwlDQ Web application that can connect to source and destination data stores & run spark-based jobs to compare & score the data. This tool helps business visualize…
21 LikesComments Off on RDS – Performance Improvement & Cost Reduction
Posted by wissenadmin | 11 August 2022
AWS Elastic MapReduce (EMR) Increased operational efficiency 40% and reduced 34% of cost Business Need:  Transportation Industry vertical has a wide range of usage pattern in which business has some…
18 LikesComments Off on AWS Elastic MapReduce
Posted by wissenadmin | 10 February 2022
Business need HealthCare is one of the vertical for General Electric. Healthcare system is to bring different type of source data from Hospital equipment which includes sensor data, PHI data,…
30 LikesComments Off on Serverless analytics on AWS