THE USE OF RELATIONAL DATABASE MANAGEMENT SYSTEM SOFTWARE IN BUSINESS

The use of Relational Database Management System Software in Business

The use of Relational Database Management System Software in Business

Abstract

The paper discusses the The use of Relational Database Management System Software in Business and studies that relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Most commercial RDBMS's use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use. The leading RDBMS products are Oracle, IBM's DB2 and Microsoft's SQL Server. Despite repeated challenges by competing technologies, as well as the claim by some experts that no current RDBMS has fully implemented relational principles, the majority of new corporate databases are still being created and managed with an RDBMS.

Relational Database Management System in Business

Traditional database design and data access were complicated. The database administrator's job was to oversee any and all database-oriented tasks. This included database design and implementation, installation, upgrade, SQL analysis and advice for application developers.. The DBA was also responsible for back-up and recovery, which required many complex utility programs that run in a specified order. This was a time-consuming energy draining task. (Fosdick, 2008, 533)

Databases are currently in the process of integration. Standardizing data, once done predominately by large corporations, is now filtering down to medium-size and small companies. The meshing of the old and new database causes administrators to maintain two or three database products on a single network. (Fosdick, 2008, 533)

Relational database management systems incorporate complex features and components to help with logic procedures. This requires organizations to expand the traditional approach to database management and administration. The modern database management systems not only share data, they implement the sharing of common data elements and code elements. (Mael, 2008, p45)

Currently, the more sought after relational database products are incorporating more and more complex features and components to simplify procedural logic. Due to the complexity of todays relational database, corporations are changing the established way of dealing with database management personnel. Traditionally, as new features were added to the database, more and more responsibility fell on the DBA. With the emergence of the relational database management system (RDBMS), we are now beginning to see a change in the database administrator's role. (Mullins, 2008, 40)

The design of data access routines in relational database demands extra participation from programmers. The database administrator simply checks the system's optimization choice, because technology is responsible for building access paths to the data. Program design and standard query language (SQL) tools have become essential requirements for the database administrator to do this job. However, this technology requires additional supervision and many DBAs are not competent in SQL analysis and performance monitoring. The database administrator had to learn to master the skills of application logic and programming techniques. (Mullins, 2008, 40)

The database administrator's job description and responsibilities have changed with ...