Tradeoffs Between Relational and Object-Oriented Database Management Systems

A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.

A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.

There are several important steps to consider when designing a database, as a well-designed database should be deployed and not only support the accuracy and integrity of business information but also avoid redundant data and assist with has enterprise level reporting tasked. If we analyze the

New applications will utilize off-the-shelf software components that have been customized per Riordan’s specifications and further messaged to ensure that each application will integrate smoothly with all the others in order to create a single cohesive whole. Great effort will be made to ensure that the data structures used in each are consistent in order to simplify the creation of the enterprise’s database. To help facilitate this, we will create an umbrella application that will integrate each other system as a module. This umbrella application will be extendable as needed and will act as a single-launch point for the various systems utilized by Riordan. We will also be working closely with Riordan’s IT department to develop a bridge that will enable them to easily port their existing databases into the new one automatically.

Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This

An enterprise data model presents an abstraction of a more complicated real-world event or object. Generally, a data is graphical simple representation, of an interconnected real organization’s data structures. The main function of the data model is to help in understanding the complexities of a particular organization. A data model within a database environment brings out the data structures, their transformations, constraints, relations, and characteristics, thus providing a blueprint of

1) Before using any DBMS, the creators should have created a data model from the users' requirements.

Connolly and Carolyn (2004) define a database as a structureordesign that consists of theclient’s data as well as metadata. It is also a persistent, logicallycoherentrepository of inherentlymeaningful data that is relevant to someaspects of therealworld. The database consists of data organized in a systematicway, anditallowseasy retrieval of information, analysis, updating andoutput of data. Thatdata can be in theform of graphics, scripts, reports, text, tables, andsoon. Most of thecomputerapplications are databases at their core. Manycompaniesusuallyhave a lot of data, andsotheyhavebig databases that can handlethatlargeamount of data. It is wherenothe database administratorcomes into playtopensurepropermanagement of the database sothatthe organizational data is safe from anyintrudersor data corruption (Jones, 2014). The database is whatcontrolsthedata of theentireorganization, andany tampering of the databases can culminate to the stoppage of businessoperations.

Next, I will address the advantages of a relational model specific to ACME Global Consulting. Since Acme Global Consulting is a leader in providing software development solutions to other companies, they need to have an in-depth knowledge of their clients functional and data needs. Therefore, a relational model can provide great benefits such as: (1). Conceptual simplicity: the model is very simple and helps to simplify data needs of their clients, (2). Design implementation: the model will help the company to achieve structural and data independence i.e. any changes if made to structure of data will not affect accessibility of data, and (3) Ad hoc capability of query implementation: relational model provides a very easy and flexible way of data implementation and manipulation. In addition, a relational model helps to organize data in form of tables. A relational model is composed of three main components: (1), a set of domains and sets that represents data structure, (2). Integrity rules, which ensures data protection, and (3). Operations that will be carried on data i.e. process of data manipulation. The experts on relational models say that it is the most widely used and most evolved method of organizing data Today, all major database management systems assume that you will be working in some manner with the relational model (Date, 2012, p.

This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.

Database system have been inseparable with our daily life, since IBM developed the hierarchical database management system in 1969, database system has been innovated many times, such as hierarchical database, network database, relational database, and object-oriented database. Nowadays, relational database still is the most popular model used by different industries; this article is going to introduce the history of the relational database.

The DBMS has a number of advantages as compared to traditional computer file processing approach. The DBA must keep in mind these benefits or capabilities during designing databases, coordinating and monitoring the DBMS.

The decision on what type of database to employ heavily depends on the scale of the business, plans for expansion, and flexibility. The benefit of a relational database structure for the system architecture is that it will offer the ability to link the

The relational database does have some drawbacks. For example, it may take more time to search for data than some other methods (Heberling, 2008). The relational database would not be the best option if the application used with the database required a special data topology (Stephens, 2009). Suri and Sharma (2011) found that, though the relational database has

An enterprise data is large and complex and spread out through a variety of different in-house and external systems. Also there is a need to analyze the data across different systems by location, time and channel. Hence the data integration is needed here so that all the data organized and stored in one location. It also cuts down time and the lengthy process involved in generation of reports because a series of steps involved in it which are stripping and extraction of data from one source and then sorting and merging of data and then enriching the data by