Software Development and Databases

Total Length: 576 words ( 2 double-spaced pages)

Total Sources: 2

Page 1 of 2

Standard-Relational and Object-Relational Databases

Software development has experienced evolution over the past few decades given the increasing demands for better information systems in today's society, especially in the modern business environment. The evolution of software development during this period has also been influenced by the tremendous changes in the ways with which computers are used and programmed. The changes in software development have contributed to the emergence of different categories of databases, which are basically defined as repositories for assorted but interrelated pieces of data or information. Through the evolution of software development, database management systems have been transformed. The most common classifications of databases emerging from the transformation of database management systems include standard-relational and object-relational databases.

Standard-relational databases are those that support interactive data structures and utilize data manipulation language that is akin to relational algebra with regards to its power. Since they utilize powerful data manipulation language, standard-relational databases are utilized for management of huge amounts of data. These databases are also suitable for retrieval of data through they provide very minimal support for manipulation of data (Robie & Bartels, n.d.). On the contrary, object-relational databases are relatively similar to standard-relational databases, but utilize an object-oriented database model.
Based on this model, object-relational databases directly support classes, objects, and inheritance using database schemas and query languages. Object-relational databases, which are commonly known as object-relational database management systems, provide balance between standard-relational and object-oriented database management systems.

As evident in these definitions, there are similarities and differences between standard-relational and object-relational databases. One of the similarities between these two databases is that they both support data model extensions though tailor-made data types and techniques. Secondly, these databases are suitable for management of huge amounts of data and data retrieval because of the data languages they utilize. Third, the two databases are similar on the premise that they are based on a relational model in which data is arranged in at least two tables containing a unique identifier for each row. Through this model, standard-relational and object-relational databases contain interrelated data.

Despite these similarities, there are some huge differences including the fact that object-relational databases include an object-oriented database model unlike standard-relational databases. Given the use of an object-oriented database model, object-relational databases provide a balance between the standard-relational databases and object-oriented databases. Secondly, standard-relational databases are based on two-dimensional tables where every item appears as a row while….....

Show More ⇣


     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Software Development And Databases" (2017, May 05) Retrieved May 20, 2025, from
https://www.aceyourpaper.com/essays/software-development-databases-2165373

Latest MLA Format (8th edition)

Copy Reference
"Software Development And Databases" 05 May 2017. Web.20 May. 2025. <
https://www.aceyourpaper.com/essays/software-development-databases-2165373>

Latest Chicago Format (16th edition)

Copy Reference
"Software Development And Databases", 05 May 2017, Accessed.20 May. 2025,
https://www.aceyourpaper.com/essays/software-development-databases-2165373