%type is used to declare a field of a table while %rowtype is used to declare a record with the same type as specified in that table, view or cursor.

Example of %type:

DECLARE

         v_EmployeeName emp.ename%TYPE

Example of %rowtype

DECLARE

          v_empployee emp%ROWTYPE;

-  A stored procedure can accept parameters while a trigger cannot.
-  A trigger can’t return any value while stored procedures can.
-  A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
-  Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
-  A trigger cannot be written in a stored procedure. However, the reverse is not possible.

There are four phases that basically gets involved in the cloud architecture:

1. Launch phase: it launches the basic services and makes the system ready for communication and for application building

2. Monitor phase: it monitors the services that is being launched and then manages them so that on demand the user will be able to get what he wants.

3. Shutdown phase: it shutdown the services that are not required first and after all the services gets shutdown, and then it closes the system services. 

4. Cleanup phase: it clean up the left out processes and services that is being either broken or didn’t get shutdown correctly.

Cloud architecture provide large pool of dynamic resources that can be accessed any time whenever there is a requirement, which is not being given by the traditional architecture. In traditional architecture it is not possible to dynamically associate a machine with the rising demand of infrastructure and the services. Cloud architecture provides scalable properties to meet the high demand of infrastructure and provide on-demand access to the user.

Cloud computing architecture consists of many layers which help it to be more organized and can be managed from one place. The layers are as follows:

1. Cloud controller or CLC is the top most level in the hirerachy which is used to manage the virtualized resources like servers, network and storage with the user APIs. 

2. Walrus is used for the storage and act as a storage controller to manage the demands of the users. It maintains a scalable approach to control the virtual machine images and user data.

3. Cluster Controller or CC is used to control all the virtual machines for executions the virtual machines are stored on the nodes and manages the virtual networking between Virtual machines and external users.

4. Storage Controller or SC provides a storage area in block form that are dynamically attached by Virtual machines. 

5. Node Controller or NC is at the lowest level and provides the functionality of a hypervisor that controls the VMs activities, which includes execution, management and termination of many instances.

Cloud computing is going all together for a different look as it now includes different data types like emails, contracts, images, blogs, etc. The amount of data increasing day by day and cloud computing is requiring new and efficient data types to store them. For example if you want to save video then you need a data type to save that. Latency requirements are increasing as the demand is increasing. Companies are going for lower latency for many applications.

Cloud computing consists of 3 layers in the hierarchy and these are as follows:

1. Infrastructure as a Service (IaaS) provides cloud infrastructure in terms of hardware like memory, processor speed etc. 

2. Platform as a Service (PaaS) provides cloud application platform for the developers. 

3. Software as a Service (SaaS) provides cloud applications which are used by the user directly without installing anything on the system. The application remains on the cloud and it can be saved and edited in there only.

Data warehouse

- It is a decision support database system for the purpose of organizational needs. 

-It is non volatile, integrated and time variant collection of data

Operational Data Stage

- It is an integrated collection of information. 

-It can contain 90 days of information at maximum.

-ODS supports dynamic data.