Database Related Notes

Home » AWS Cheat Sheets » AWS Database Services » Database Related Notes

Amazon Aurora Machine Learning

2023-05-02T05:15:36+00:00

Amazon Aurora Machine Learning is a proprietary technology of Amazon that enables a native SQL user to integrate Machine Learning-based predictions to an application without knowing or understanding any machine learning algorithms. Machine learning heavily relies on datasets for it to work. You can say that data is the oil that keeps the engine of machine learning running. There is a massive amount of data generated every day. To give you an idea, according to this article, “By 2020, it’s estimated that for every person on earth, 1.7 MB of data will be created every second.”  Almost 2 MB of [...]

Amazon Aurora Machine Learning2023-05-02T05:15:36+00:00

Aurora Serverless Tutorial Part 2

2023-05-27T08:37:50+00:00

In the first part of this tutorial, we gave a walkthrough on Aurora Serverless and its use case. You can read the article here. For this tutorial, we will do some hands-on training and create an Aurora Serverless database. Creating an Aurora Serverless Database: 1. Open the AWS console and go to RDS. Click the button “Create database”. 2. Choose Amazon Aurora. You can either choose MySQL or PostgreSQL compatibility. In this tutorial, we will use MySQL compatibility. As of this writing, there are two versions of MySQL that Aurora serverless supports. Under the Database Features, select serverless. 3. Under [...]

Aurora Serverless Tutorial Part 22023-05-27T08:37:50+00:00

Aurora Serverless Tutorial – Part 1

2023-06-02T02:06:31+00:00

What is Aurora Serverless?  Before we get into it, let us briefly define Aurora and serverless first. Aurora is a fully managed, closed source relational database that is compatible with MySQL and PostgreSQL. According to Amazon, it is five times faster than the standard MySQL and three times faster than PostgreSQL. It uses a distributed architecture that provides fault tolerance and high availability.  Serverless is a technique in the cloud that follows the ‘pay-per-use’ model. As opposed to its name, serverless does not mean not using ‘servers’. There is no magic in it. It still uses a physical server that [...]

Aurora Serverless Tutorial – Part 12023-06-02T02:06:31+00:00

Global Secondary Index vs Local Secondary Index

2024-01-24T09:25:20+00:00

Bookmarks Global Secondary Index Local Secondary Index A secondary index is a data structure that contains a subset of attributes from a table, along with an alternate key to support Query operations. An Amazon DynamoDB table can have multiple secondary indexes.   Global secondary index Local secondary index Definition An index with a partition key and a sort key that can be different from those on the base table. An index that has the same partition key as the base table, but a different sort key.  Span of query Queries on the index can span [...]

Global Secondary Index vs Local Secondary Index2024-01-24T09:25:20+00:00

Calculating the Required Read and Write Capacity Unit for your DynamoDB Table

2021-05-04T09:10:25+00:00

Read Capacity Unit On-Demand Mode When you choose on-demand mode, DynamoDB instantly accommodates your workloads as they ramp up or down to any previously reached traffic level. If a workload’s traffic level hits a new peak, DynamoDB adapts rapidly to accommodate the workload. The request rate is only limited by the DynamoDB throughput default table limits, but it can be raised upon request. For on-demand mode tables, you don't need to specify how much read throughput you expect your application to perform. DynamoDB charges you for the reads that your application performs on your tables in terms of read request [...]

Calculating the Required Read and Write Capacity Unit for your DynamoDB Table2021-05-04T09:10:25+00:00

AWS Lambda Integration with Amazon DynamoDB Streams

2021-05-03T13:23:37+00:00

Amazon DynamoDB is integrated with AWS Lambda so that you can create triggers, which are pieces of code that automatically respond to events in DynamoDB Streams. With triggers, you can build applications that react to data modifications in DynamoDB tables. After you enable DynamoDB Streams on a table, associate the DynamoDB table with a Lambda function. AWS Lambda polls the stream and invokes your Lambda function synchronously when it detects new stream records.  Configure the StreamSpecification you want for your DynamoDB Streams: StreamEnabled (Boolean) - indicates whether DynamoDB Streams is enabled (true) or disabled (false) on the table. StreamViewType (string) [...]

AWS Lambda Integration with Amazon DynamoDB Streams2021-05-03T13:23:37+00:00

DynamoDB Scan vs Query

2023-01-30T13:33:00+00:00

Scan The Scan operation returns one or more items and item attributes by accessing every item in a table or a secondary index. The total number of scanned items has a maximum size limit of 1 MB. Scan operations proceed sequentially; however, for faster performance on a large table or secondary index, applications can request a parallel Scan operation. Scan uses eventually consistent reads when accessing the data in a table; therefore, the result set might not include the changes to data in the table immediately before the operation began. If you need a consistent copy of the data, as [...]

DynamoDB Scan vs Query2023-01-30T13:33:00+00:00

Redis (cluster mode enabled vs disabled) vs Memcached

2023-04-10T05:29:45+00:00

  Redis (cluster mode enabled) Redis (cluster mode disabled) Memcached Data Types string, sets, sorted sets, lists, hashes, bitmaps, hyperloglog, geospatial indexes string, sets, sorted sets, lists, hashes, bitmaps, hyperloglog, geospatial indexes string, objects (like databases) Data Partitioning (distribute your data among multiple nodes) Supported Unsupported Supported Modifiable cluster Only versions 3.2.10 and later  Yes Yes Online resharding Only versions 3.2.10 and later  No No Encryption 3.2.6, 4.0.10 and later 3.2.6, 4.0.10 and later Unsupported Sub-millisecond latency Yes Yes Yes FedRAMP, PCI DSS and HIPAA compliant 3.2.6, 4.0.10 and later 3.2.6, 4.0.10 and later No Multi-threaded (make use of multiple [...]

Redis (cluster mode enabled vs disabled) vs Memcached2023-04-10T05:29:45+00:00

Redis Append-Only Files vs Redis Replication

2023-04-10T05:21:12+00:00

Redis Append-Only Files (AOF) Redis Replication You can enable the Redis append-only file feature (AOF) for data durability. It is similar to creating manual backups. When enabled, the node writes all of the commands that change cache data to an append-only file.  When a node is rebooted and the cache engine starts, Redis goes through an AOF to replay the actions that were performed before the crash; the result is a warm Redis cache with all of the data intact. To enable AOF for a cluster running Redis, you must create a parameter group with the appendonly parameter set to [...]

Redis Append-Only Files vs Redis Replication2023-04-10T05:21:12+00:00

AWS, Azure, and GCP Certifications are consistently among the top-paying IT certifications in the world, considering that most companies have now shifted to the cloud. Upskill and earn over $150,000 per year with an AWS, Azure, or GCP certification!

Follow us on LinkedIn, Facebook, or join our Slack study group. More importantly, answer as many practice exams as you can to help increase your chances of passing your certification exams on your first try!