Databases Essay Example | Topics and Well Written Essays - 1000 words - 2

Databases - try out ExampleThe construction of a relational database is built around the concepts of relations. This theory include relational algebra (which is a desexualize of mathematical operators which operate on relations and produce relation results), relation variables, and relational parity operators. A database suitability of a given kind of database, either object oriented or relational databases, dep extirpates on the requirements of the user. The anatomy of a relation consist of the body, which is the cardinality of the relation, attribute name and attribute values (Halpin & Morgan, 2010). The good turn of attributes is referred to as the degree of the relation, while the number of tuples is the cardinality. On the other hand, a set of attributes is the heading of the relation, and the set of tuples is the body of the relation. To manage a database and provide access to them, a database heed clay is used. Database management system is predominantly used in acceptin g commands provided by application programs and executing them on behalf of the user (Ritchie, 2002). This commands ar written in database language of the database management system like SQL. Some of the responses include messages, results of queries, and completion of codes. Database management system normally operate as servers in order to support a wide grade of concurrent users. Application programs which run as invitees for the set servers ar its immediate users. These clients run on behalf of the end users. In transmission of this commands, communication protocol is required and also responses between servers and clients. When a client ineluctably to submit information to the server, a connection must first be established between the client and the servers. This initiates a session. This session typically lasts until its terminated on an explicit request by the client. relational databases take a crap a wide range of application. Thus, this implies its importance in comp uting and data warehousing. Relational databases are important in disaster recovery planning. This is due to several reasons which are highlighted below 1. Relational databases have an ease of maintenance. Once a backup plan is veritable using its maintenance is of great importance. Systems developed with relational databases are easy to maintain. This is due to the fact that once a simple entry is edited, the in all database is updated (Ritchie, 2002). Also, data from other sources can be easily be incorporated into the existing database. This is simply by importing the data using the import function into the current database. This is instantaneous and the imported data is automatically updated into the database. This makes the database maintenance easy since new information is added with easy. 2. Relational databases have ease of access. This is the most important constituent during planning, developing maintaining, testing and the actual process of recovery. The interrelation ship that characterizes relational database systems makes the recovery availability online easy and instantaneous. In the case in which the database relationship has been established sensibly, important information can be reached from any depot which has accessibility to the mainframe. This is if and only if the system is operational. Apart from assisting in disaster preparedness, relational database are needed since there use ensures that there are minimal duplication of data in a given relational databa