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

  • 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
  • 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
  • Good Essays

    References: Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning.…

    • 799 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    This exercise will introduce you to the basic building blocks of any database – fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer vendors, the more applicable use of databases involves the creation of many tables linked together with a common field or “key.” Regardless of the size of the database, the data is stored in the same way – in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries.…

    • 1190 Words
    • 5 Pages
    Powerful 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
  • Powerful Essays

    References: Coronel, C., Morris, S., & Rob, P. (2011). Database systems: Design, implementation and management (9th ed.). Mason, OH: Cengage Learning.…

    • 1451 Words
    • 4 Pages
    Powerful 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
  • 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
  • Better Essays

    A database stores keyed information in an organized and accessible manner. The size and capacity of databases can vary widely, from a small database used by an individual to file phone numbers, to an extremely large enterprise database that stores several gigabytes of information accessed by thousands of individuals. Databases are essential for almost every company in today's business world. Database can help us keep track of, inventory, billing, pay role, phone numbers and much more. Lacking the use of databases, work will take longer to accomplish. Another wonderful feature about having a database in place is that a record of all transitions can be kept for analyzing purposes.…

    • 807 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Relational Databases

    • 750 Words
    • 3 Pages

    Data for our programs are stored in various formats. The most commonly used format is in the form of a database since databases are not dependent on a single program or hardware platform. These databases are stored in five structures of hierarchical, network, relational, multidimensional, and object-oriented. Hierarchical structure organizes data in a one to many relationship. The network goes of the hierarchical structure by organizing data in a many to many relationship. The relational structure organizes the data in tables and allows the end user to determine the relationship at run time. Multidimensional takes the relational structures concept and uses multi dimensions to organize the data. Object-oriented structure has not only the attributes of the entity, but also contain the operations that can be performed on it.…

    • 750 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Databases are very important to every person in the world today. Whatever you do in you daily routine you are bound to come in contact with some form of database and our world has become so dependent on it that most people won’t even realize the importance of databases. A database is a bunch of files that are usually integrated electronically together to make up one big file. The database stores all of these files in one location and numerous people can access this information all at the same time if they have the proper access from the database administrator.…

    • 1084 Words
    • 5 Pages
    Better Essays
  • Better Essays

    The modern database management systems not only share data, they implement the sharing of common data elements and code elements. (Mullins 1995) Currently, the more sought after relational database products…

    • 1186 Words
    • 5 Pages
    Better Essays
  • Better Essays

    The purpose of a database is to provide an organized model of maintaining, storing, managing and retrieving information. The concept is largely based on the use of tables to hold information much like that of a spreadsheet. These tables are arranged in columns and rows where each row pertains to a specific dataset or record and each column represents a specific attribute of the data set. Although databases are similar to spreadsheets, databases are much more powerful and useful in the way data is manipulated, gathered and presented.…

    • 1185 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    Nowadays Database Management System (DBMS) is the important part of many important industries. Databases hold everything from sales, inventory, payroll, accounting, personnel and more. A properly maintained and designed database can give managers insights into trends and information that might Have been otherwise missed. Presently with the large amount of DBMS versions, it is a problem to choose exact and proper database for your requirement. The main reason for my presentation is to help us understand some of the differences between databases and realize that there are some fundamental differences between database implementations. With this paper I want to introduce about differences between two well-known database systems such a MySQL and Oracle. With this paper reader can differentiate two database above with three aspects: security, data type and data storage concepts. Section 2.1, for understand security advantages of two database systems. Section 2.2, with listed data type of two database systems we can differentiate data types. The section 2.3 provide a description of the conceptual differences and similarities in data storage for MySQL and Oracle databases.…

    • 1593 Words
    • 7 Pages
    Powerful Essays