Preview

Relational Database vs Object Oriented Database

Powerful Essays
Open Document
Open Document
2737 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Relational Database vs Object Oriented Database
Institute of graduate studies &research Information technology department

Database systems
Report on:
(Comparison between Relational database & object oriented database)
By: Mohammed Hussein Mahmoud Mustafa khedr

To: Dr. Saad Darwish

Introduction
A database is a means of storing information in such a way that information can be retrieved from it. Thus a database is typically a repository for heterogeneous but interrelated pieces of information. Often a database contains more than one table. Codebooks and dictionaries can also be considered as tables. A dictionary is a reference book on any subject, the items of which are arranged in alphabetical order. Codebook is a list of replacements for words or phrases in the original message. A code is a system for hiding the meaning of a message by replacing each word or phrase in the original message with another character or set of characters. The list of replacements is contained in a codebook. An alternative definition of a code is any form of encryption which has no builtin flexibility, i.e. there is only one key, namely the codebook. Databases contain organized data. A database can be as simple as a flat file (a single computer file with data usually in a tabular form) containing names and telephone numbers of one’s friends, or as elaborate as the worldwide reservation system of a major airline. There are many ways to approach the design of a database and tables. The database layout is the most important part of an information system. The more design and thought put into a database, the better the database will be in the long run. We should gather information about the user’s requirement, data objects, and data definitions before creating a database layout. Traditionally, there are four different DBMS data models: the hierarchical data model, the network data model, the relational data model, and the objectoriented data model.

These four data models at the same time signifies the historical



References: 1. Relational and Object-Oriented Databases, by Willi-Hans Steeb , International School for Scientific Computing. 2. Database Management Systems: Relational, Object-Relational, and Object-Oriented Data Models, Lisbeth Bergholt, DTI ,Jacob Steen Due, Rambøll Thomas Hohn, DAIMI, Jørgen Lindskov Knudsen, DAIMI, Kirsten Hjerrild Nielsen WM-data, Thomas Sonne Olesen, DTI, Emil Hahn Pedersen, Rambøll. 3. Comparing Relational and Object-Oriented Databases, Nelson Caballero, University of Maryland University College, 2001.

You May Also Find These Documents Helpful

  • Good Essays

    References: Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.…

    • 906 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Nt1330 Unit 1 Assignment

    • 2207 Words
    • 9 Pages

    This paper gives an idea regarding the important aspects of the database security. It mainly focuses on the security parameters such as confidentiality, authenticity and availability of the data. It also explains the different threats for the security in an organization in relation to the database. The basic steps which are required to control the loss of data are explained in detail. Among the controls the encryption process is the one which has to be followed to control the access into an…

    • 2207 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database consists of one or more tables; each containing data stored as individual records. Different database architectures determine how the tables and records are organized or related…

    • 885 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Kroenke, D. M., & Auer, D. J. (2010). Database Concepts (4th ed.). Retrieved from https://ecampus.phoenix.edu/content/eBookLibrary2.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    3. The database scheme: the specifications of the logical structure of the data stored in the database.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    “A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input (tech-faq.com)”. To ensure practical use over a long period of, databases ought to be built with high-level of data integrity and the capability to recover data in the event of hardware failure. Data that has been destroyed or corrupted is useless within a business’s data system structure.…

    • 624 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    The differences in the architectures are based on how the tables and records are related. Relational architecture is a very popular database. It is also the most mature and widely used database system in production. Relational databases can be used to track patient care in the form of treatments, outcomes of those treatments, and critical indicators of a patient 's current state such as blood pressure, heart rate, and blood glucose levels. They can also be used to interconnect with multiple informational systems throughout a healthcare facility. Relational databases have the potential to eliminate paper storage and transfer of information and to answer important questions about healthcare efficacy. Relational systems serve as the repositories of record behind nearly all online transactions and most online content management systems including social networks. This database also serves as a well-understood point of reference for new extensions and revolutions in database systems that may arise in the future. Another type of database architecture is the Object-oriented model. This model is powerful and quite complex. With the relatively new object-relational database model is the wide spread and simple relational database model extended by some basic object-oriented concepts. These allow them to work with the relational database model but also have some advantages of the…

    • 754 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Proposal

    • 1378 Words
    • 6 Pages

    With the Simulation software, it is relatively easy to change the features or price point of a product and have the simulation software predict the market share that the product would attain in the market. This I hope to achieve by using the computer to emulate a real world situation. It is time based, and takes into account all the resources and constraints involved, as well as the way these things interacts with each other as time passes. Simulation also builds in the randomness that would be seen in real life. For instance, it doesn’t always take exactly 5-minutes for a customer to be served and a customer don’t always arrive every 15-minutes. This means that the simulation really can match reality, so when one make changes to the simulation; it will demonstrate exactly how the system would behave in real life.…

    • 1378 Words
    • 6 Pages
    Good Essays
  • Best Essays

    Historically, a manual file system was composed of a system of file folders and filing cabinets.…

    • 2439 Words
    • 17 Pages
    Best Essays
  • Powerful Essays

    Concept of Dbms

    • 1140 Words
    • 5 Pages

    The problems, other than redundancy, associated with the nondatabase approach to processing data include difficulties accessing related data, limited security features to protect data from access by unauthorized users, limited ability for multiple users to update the same data at the same time, and size limitations.…

    • 1140 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    “Establishing a relational database management system is a great way to increase data integrity, efficiency, ask questions, sort and filter data, provide stronger security, and share information in one concise design which is very user friendly if developed correctly. Relational databases allow the ability to cross-reference data stored by the business and as a result provide a higher level of integrity.” “The key to success is in the foundation of the database's design.” “Relationships of data must be accurately assessed and once this connection is established, the rest falls into place rather smoothly. (Goessl, 2009)”…

    • 672 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Relational Databases

    • 4830 Words
    • 20 Pages

    Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users ' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use.…

    • 4830 Words
    • 20 Pages
    Better Essays
  • Good Essays

    Using a database management system (DBMS) is a wise decision for any business that plans to implement the use of a database as part of their IT infrastructure. A database management system, also referred to as a database manager (Rouse, 2005), allows one or many computers to create, query, and manipulate data in the database (Rouse, 2005). The database management system also manages request from users and applications, making the database much more user friendly, since the users nor the applications have to know where the data is physically located for the database (Rouse, 2005). Where multi-user systems are being utilized the database management system does not allow the current user to see who else is accessing the information. The database contains data that needs to be protected from intentional or accidental misuse (Ricardo, 2012). The database management system is instrumental to securing the database; and that system allows the database administrator to setup security restrictions and enforce them on multiple levels, making sure only those with the proper credential have access to the data (Ricardo, 2012). The DBMS also adds to the overall security by having the functionality to encrypt the data before it is stored in the database (Ricardo, 2012). The database management system also helps to ensure database integrity, making sure data is readily accessible and is organized as intended by the database administrator (Rouse, 2005). The DBMS also allows the database administrator to define integrity constraints, which are consistency rules that the database must obey (Ricardo, 2012).…

    • 821 Words
    • 4 Pages
    Good Essays