Since there are so many database management systems are available, so it is important to ensure that they communicate with each other. This is because, most database software comes with an Open Database Connectivity (ODBC) driver which allows the database to incorporate with other databases. A DBMS perform several important functions that guarantee the integrity and consistency of the data in the database. Most of these functions are transparent to end users, and most can be achieved only through the use of a DBMS. They including the data dictionary management, data store management, security management and also backup and recovery management.
Dynamic SQL is SQL allows embedding DDL statements in PL/SQL blocks. • PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications. • PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database. • PL/SQL saves time on design and debugging by strong features, such as encapsulation, data hiding,exception handling and object-oriented data types.
DBMSs keep track of data and it is easy to access stored data when needed. These systems provide security for the data and keep the dates of when the input was received. DBMSs allow multiple user access and have the ability to transform data into information and present it to users in a why they can understand. DBMSs give users the ability to create and modify databases and manipulate the data itself. The business community is pretty busy with database management systems it makes it easier to keep important records and transform data into information from tracking inventory to tracking purchases.
Luckily, Erlang also has this in spades.  Due to Erlang’s powerful concurrency being built into the language, it makes Erlang’s fault-tolerance simple and powerful. Erlang’s processes can actually monitor one another, allowing a process to recover another process in the event that software faults must be recovered from. This allows Erlang to put itself ahead of other languages, as Erlang’s complex architecture is capable of isolating errors, and guaranteeing nonstop operation.  As stated before, Erlang can be very useful when dealing with instant messaging, this can be taken one step farther; socket processing.
NoSQL – or “Not Only SQL” – uses different data structures to house data. These structures could look similar to a relational database but others look completely different. Depending on the specific structure used, your choice of Database Management Systems will change as well. There are four common data models to use; Key/Value Stores, Document Databases, Table-Style Databases, and Graph Database (Data Access for Highly Scalable Solutions). Key Value Stores Looking at the different data storage models, this is the most simple to implement.
COMPARISON: Below is a detailed comparison of different features of both options. • SET-UP: Once a MySQL is mounted on an instance of EC2, it can be up and running instantly without much time or effort required. Amazon’s EC2 comes with a set of API command line tools for different Linux distributions and for use with different File Systems to facilitate easy transition to the cloud. If a MySQL database exists already, it can be easily migrated to EC2 by creating an EBS volume, attaching that volume to EC2 and finally mounting the MySQL on that volume. On the other hand, Amazon RDS has an efficient management console that helps with easy set-up and monitoring of resources.
In this paper I will be discussing the differences and similarities of the three database models we have talked about in class the Entity-Relationship, Object model, and the UML modeling. First let’s look at the definition of the three models. The Entity- Relationship Model is used to visually represent data objects and is used for database design. It is easy to understand which makes it easier to communicate the design to the end user. The form used in the ER model can easily be transformed into relational tables.
Answer Structured data is defined as a data that are record and being filed in the database to make it can be used efficiently. frequent the case with the selection of the type of detailed data structures should be used to allow efficient algorithms can be used. Good design data structure allows a variety of critical operations carried out by using the time and little memory space, as possible. structured data will be represent in discrete form which is in column and row form. this can make the data in the database more organized.
Relational Database Management System Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of data through locking mechanisms.