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

Databases - Essay Example The construction of a relational database is built around the concepts of relations. This theory include relational algebra (which is a set of mathematical operators which operate on relations and produce relation results), relation variables, and relational comparison operators. A database suitability of a given kind of database, either object oriented or relational databases, depends 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 number 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 management system is used. Database management system is predominantly used in accepting commands provided by application prog rams and executing them on behalf of the user (Ritchie, 2002). This commands are 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 variety of concurrent users. Application programs which run as clients for the set servers are 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 needs 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 it’s terminated on an explicit request by the client. Relational databases have a wide range of application. Thus, this implies its importance in computing and data warehousing. Relational database s 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 developed 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 whole 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 factor during planning, developing maintaining, testing and the actual process of recovery. The interrelationship that characterizes relational database systems make s 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 terminal 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