What are the tradeoffs between relational and object-oriented Essay

What are the tradeoffs between relational and object-oriented databases and database management systems - Essay Example This section also outlines tradeoffs between relational, object-oriented databases and database management systems. RDBMSs (Relational Database Management Systems) have been offering excellent services and benefits to their users; however this achievement is incomplete as well as limited to only some kinds of applications. In view of the fact that the business clients adopt latest versions of systems, as well as develop to previous ones, their efforts to make use of RDBMS come across the "Relational Wall," where RDBMS technology is no longer capable to offer the functionality and services required by the users. Additionally, users face this barrier when they try to enlarge information models to sustain associations among data, novel data types, extensible data types, and straight support of data objects. In the same way, the barrier can take place when implementing database in distributed environments through complicated processes. On the other hand, attempts to resolve these issues with relational technology cause an explosion of tables, a lot of joins, deprived performance, unfortunate scalability as well as loss of integrity. Thus, ODBMSs present a path further than the wall (Objectivity, Inc., 2005). Additionally, the emergence of new generation of Relational Database Management Systems has offered a lot of advantages to clients. These advantages comprise unplanned query, self-governing data from logical application, and a variety of front-end GUI (graphical user interface) systems. In addition, it has also offered many business applications, as well as the business sector has expended to over $4B yearly, comprising tools. There is a question that why we should look beyond RDBMSs? We should perform so simply when essential to capability and support of new types of systems, new associations, distribution, media data types as well as scalability. In reality, the majority of systems and applications have never made use of RDBMSs, and a lot of applications that have utilized RDMBS are now searching for other options, like that ODBMSs (Objectivity, Inc., 2005). In addition, the relational databases have offered a high-quality service in a lot of customary database systems. Despite the fact that, in many scenarios for instance when it is complicated to deal with information, or when superior efficiency is needed (i.e. objects having anonymous identifiers, or objects going from one type to another, etc.), or when we need to manage non-conventional data (such as images, long texts, etc.), additional techniques need to be implemented. Normally, these techniques include object-oriented or semantic databases. Additionally, the semantic database models are object oriented database models. Moreover, they present, a variety of levels, a lot of characteristics of semantic models, in the form of conceptual information, as well as, purify a number of behavioral characteristics of the data (Rishe, 2010). However, if a RDBMS can resolve our problems without numerous efforts as well as offers the required results, efficiency and scalability then there is no need to utilize an ODBMS. If some of the below given situations are convened then we should think about using ODBMS. Belo w are some of the important reasons that require us to make use of RDBMS: (Objectivity, Inc., 2011) Complicated Relationships: If we are having numerous many-to-many relationships in our database, tree arrangements or network (graph) formations (Objectivity, Inc., 2011). Complicated Data Arrangement: If the data has numerous changeable length parts, such as arrays of structures, multi-dimensional arrays or binary streams (Objectivity, In