Relational Database Management Systems Expository Essay

Exclusively available on IvyPanda Available only on IvyPanda
Updated: Mar 14th, 2024

The idea of database management systems arose in the early 1970s following research conducted by IBM and university of California at Berkeley. The research intended to provide an alternative to the techniques in use at the time, especially to help reduce the cost of deploying and maintaining complex systems (Seltzer, 2008).

We will write a custom essay on your topic a custom Essay on Relational Database Management Systems
808 writers online

In the modern competitive world, the accessibility, accuracy and timeliness of storage and retrieval of information necessary to meet customer needs ensure an entity’s superior performance (Larson, 1988).

Relational database management systems improve productivity, speed and flexibility of data management in an organization through a design that encourages a clear boundary between the logical and physical aspect of database management system (Codd, 1970).

Most enterprises have embraced relational database management system due to their ability to ensure high levels of data security. Data security arises from the authentication and authorization functionalities of a relational database. Authentication is the process of validating users’ credentials to prevent unauthorized access to the entity’s information.

It requires users to enter their usernames and passwords, which can be encrypted to enhance their security. Authorization is the concept of controlling the information that each users can access by allocating different access permissions for users. This ensures that only individuals with the appropriate authorization can access sensitive information.

Organizations have also embraced relational database systems due to their capability to store huge amounts of information; that is, their data-warehousing capabilities (Seltez, 2008). This helps enterprises record customer transactions over time.

Such customer information can give insight into customer’s purchasing patterns, trends in product popularity, and regional product preferences. The entity can use such information to offer customers products that are more relevant to their needs, thus encourage more purchases (Seltez, 2008).

1 hour!
The minimum time our certified writers need to deliver a 100% original paper

Relational databases management systems provide superb directory services. With the increasing dependence on distributed resources, relational database directory servers organize the information in a hierarchical structure similar to that of the physical organization.

An example is LDAP standard that emerged in 1990. The standard is currently used in major companies e.g. IBM Tivoli’s directory server and the Microsoft’s Active directory server. This reduces the amount of time used in locating information in an organization and, for instance, facilitates management of various employee directories.

The relational database’s XML management capacity also provides core tools for entities to grow their business. Most online transactions are encoded using XML documents. These documents require conversion to a relational structure, storage in relational database, and reconversion during retrieval.

Relational database management systems support this workload of queries and traffic as experienced in online transaction processing. While creating data tables, one can define a relational table with a column of type XML that stores an XML document per row.

This means that expressions to search the XML are executed in an opaque manner to the query optimizer. This helps cap the advantages of XML into the data manipulated in the database, for instance, enabling consumer online ordering functions (Hellerstein, Stonebraker & Hamilton, 2007)

Unlike other database management systems, relational database management systems adapt quickly to dynamic business needs, thus helping in acquiring more information for better decisions (Larson, 1988).

Such adaptability increases database flexibility, which reduces management cost of applications, while increasing effectiveness and productivity; this results in improved user satisfaction and confidence in the enterprise (Larson, 1988).

Remember! This is just a sample
You can get your custom paper by one of our expert writers

Relation databases management systems offer modern-day organizations various opportunities for growth. For instance, by enabling structured organization, easy storage, and quick retrieval of information, the relational databases enable the entities meet customer needs by providing offers that meet such needs.

Other aspects such as flexibility and XML management capacity make relational databases a critical tool for an entity to meet its dynamic customer needs.

References

Codd, E. F. (1970). . Communications of the ACM, 13(6), 377- 387. Web.

Hellerstein, J. M., Stonebraker, M. & Hamilton, J. (2007). Architecture of a database system. Hanover, MA: Now Publishers Inc.

Larson, O. (1988). Strategic importance of relational database. Cupertino, CA: Hewlett-Packard Company. Web.

Seltzer, M. (2008). There is more to data access than SQL: Beyond relational databases. Communications of the ACM, 51(7), 52-58. Web.

Print
Need an custom research paper on Relational Database Management Systems written from scratch by a professional specifically for you?
808 writers online
Cite This paper
Select a referencing style:

Reference

IvyPanda. (2024, March 14). Relational Database Management Systems. https://ivypanda.com/essays/relational-database-management-systems/

Work Cited

"Relational Database Management Systems." IvyPanda, 14 Mar. 2024, ivypanda.com/essays/relational-database-management-systems/.

References

IvyPanda. (2024) 'Relational Database Management Systems'. 14 March.

References

IvyPanda. 2024. "Relational Database Management Systems." March 14, 2024. https://ivypanda.com/essays/relational-database-management-systems/.

1. IvyPanda. "Relational Database Management Systems." March 14, 2024. https://ivypanda.com/essays/relational-database-management-systems/.


Bibliography


IvyPanda. "Relational Database Management Systems." March 14, 2024. https://ivypanda.com/essays/relational-database-management-systems/.

Powered by CiteTotal, best bibliography tool
If you are the copyright owner of this paper and no longer wish to have your work published on IvyPanda. Request the removal
More related papers
Cite
Print
1 / 1