molecularsciences.org

Procedural Language extension of SQL (PL/SQL) combines SQL with procedural programming features such as looping, conditionals, and reusable blocks. PL/SQL engine processes PL/SQL statements. PL/SQL statements can reside on the client on server.

PL/SQL Blocks

PL/SQL blocks are made up of PL/SQL and SQL statements. A block is a functional unit made up of an optional declaration section, an execution section, and an optional exception or error handling section. A block has the following syntax

Below are a collection of articles on Oracle.

AWS offers Route53 for DNS and related services. ELB optimally distributes load between your EC2 instances.

Route53

Route53 is a DNS Service that provides a reliable and scalable way to route traffic. DNS maps IP to a domain name. Key features:

• global, highly available DNS
• domain registration
• public and private names
• multiple routing algorithm
• both IPv4 and IPv6
• integrated with other AWS cloud Services

To setup:

There are three category of services provided by AWS to assist with implementing elasticity, deployment, and configuration management of applications. Generally, the more convenience you ask for, the less control you will get. You need to decide which service best suits your needs and matches your skill set:

Amazon offers a few storage options:

• File Storage - use EFS
• Block Storage - use EBS and EC2
• Object Storage - use S3

EFS works very much like your computer's directory structure. All files are classified hierarchically and each has a unique address which is used to retrieve it. Block storage is mostly used by software. Object can be any raw data such as an image, text file, pdf, etc. Objects are non-relational and unstructured. Each object has a unique id. This id is used to retrieve the object. REST API can also be used to access objects.

Autoscaling ensures that you have the sufficient AWS EC2 instances available to handle the load and it also ensures that you don't have more instances allocated than you require.

The load on a server fluctuates over time. Autoscaling allows you to allocate more EC2 resources when you need them and retire them when you no longer need them. You can either manually define peak and low-peak times or you can define rules based on CloudWatch alarm that automatically allocate and retire resources as needed.

Elastic Compute Cloud or EC2 refers to compute (server) resources. In AWS, servers are called Amazon EC2 instances or just "instances". To create or change an EC2 instance, login into your AWS console. Then click on relevant links under EC2. Once your setup is complete, you can log into your instance via your terminal.

You can create your own private cloud with AWS cloud. VPC is a logically isolated section of AWS Cloud. Following are key features of VPC:

There are 3 ways to use AWS:

• AWS Management Console (GUI Interface)
• Command Line Interface (CLI)
• Software Development Kits (SDKs) - enables access using other tools

To access the console, go to http://aws.amazon.com/console. Login and you will see a list of resources and services you can setup and configure.

CLI interface allows you to access AWS through your terminal window. See AWS CLI to learn how to use it. Example command:

aws ec2 describe-instances