Nobody downloaded yet

Object Relational Database - Essay Example

Comments (0) Cite this document
An ORDB (Object relational database) is solely based on Object oriented concepts. As in object oriented programming, a program is a collection of objects. An object represents a real life model encapsulating both data and operations within itself. But before creating such an object, the type/class for that object should have to be declared, depending on its details, the object is instantiated…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER96% of users find it useful
Object Relational Database
Read TextPreview

Extract of sample
"Object Relational Database"

Download file to see previous pages In ORDB, reusability is achieved by using the techniques of inheritance of types and polymorphism. Every record has unique identity within the object table. Here every record is termed to be active, persistent objects encapsulating both data and methods. The only way to access any data, is through the object methods.
In contrast with this advance database system, the traditional database system like RDBMS (Relational database management system) maps the real world models in the form of entities containing tuples/rows. Each tuple in an entity contains the common set of attributes/columns. Here both entity and its tuples are said to passive, as in order to mutate or access these tuples, data manipulation language or external stored procedures are used. A tuple only contains the data and does not contain any methods. A tuple is not identified by an object id but uniquely identified within an entity, by using data of a column, which is called as the primary key column. In RDBMS, there is no concept of reusability, because there are not any concepts of inheritance and polymorphism.
Encapsulation is achieved through abstract data types (ADTs). In this concept, the object has an interface part and an implementation part. The interface provides specifications of the operations that can be performed on the object; the implementation part consists of the data structure for the ADT and the functions that realise the interface. Only the interface part is visible to other object or users. In ORDB, proper encapsulation is achieved by ensuring that programmers have access only to the interface part. In this way encapsulation provides the form of logical data independence. We can change the internal implementation of an ADT without changing any of the application programs using that ADT. (Connolly & Begg, p. 686).
Object and Attributes
A uniquely identifiable entity contains both the attributes that describe the state of the real world object and the actions that are associated with the real world objects. A key part of the definition of an object is unique identity. In an ORDBMS, each object has a unique system-wide identifier that is independent of the values of its attributes (that is its state), and is invisible to the user. Two objects could have the same state but would have different identities. When an object is created, it is assigned and Object Identifier (OID) that is unique and invariant, in the sense that it cannot be altered during its lifetime. The OID distinguishes the object from every other object in the system. Once the object is created, this OID will not be reused for any other object, even after the object has been deleted. OID automatically provides entity integrity.
Object Methods
Object methods define the behaviour of the object. They can be used to change the object's state by modifying its attribute values, or to query the value of selected attributes.
Class, Inheritance and Polymorphism
A class is said to be a blue print of an object. Remember in any ORDBMS, we cannot start creating objects ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Object Relational Database Essay Example | Topics and Well Written Essays - 3000 words”, n.d.)
Retrieved from
(Object Relational Database Essay Example | Topics and Well Written Essays - 3000 Words)
“Object Relational Database Essay Example | Topics and Well Written Essays - 3000 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document
Relational Dialectics
...?Individuality vs. Unity – an Unending Challenge A relationship, whether romantic or arranged, is neither an accident that just persists by chance nor a dice roll that the desired outcome purely depends on probability as what most people presume. Everything involved in a particular relationship follows one certain edict of nature which is theoretically known as the Relational Dialectics. This term implies to the pairs of opposing forces that depend on each other and in majority of ways, influence the outcomes of most relationship. Relational dialectics commonly disguise itself as individuality ­- that each person was made different from another thus occurrences of misunderstandings and conflicts are...
4 Pages(1000 words)Essay
What are the tradeoffs between relational and object-oriented databases and database management systems
...?TRADEOFFS BETWEEN RELATIONAL AND OBJECT-ORIENTED DATABASES AND DATABASE MANAGEMENT SYSTEMS Tradeoffs between relational and object-oriented databases and database management systems Author Author Affiliation Date First Part ODBMS or RDBMS This section of the paper will present a detailed analysis of some of the important aspects of relational, object-oriented databases and database management systems. 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...
7 Pages(1750 words)Essay
Relational Database Assignment
...?Relational Database Importance of Relationships in Database Design Relationships play an extremely important role in the design of a database. In order to come up with the most appropriate design, it is imperative that one knows which relationship needs to be used. The four prime factors that control the integrity of a database include relationship-level integrity, attribute-level integrity, business rules, and entity-level integrity (Lathem, 2008). Using these relationships, one can divide the data in separate tables. This assists the user in matching the data with the help of common characteristics contained in the data set including the...
3 Pages(750 words)Assignment
Information about the Relational Database Business Paper
...-1, 2013). In discussing about the Object Management Group’s Unified Modelling Language, it can be said that it helps in the process of specifying, visualizing and documenting the models of various software systems. While doing so, the focus is given on the fact that it fulfils all the requirements related to structure and design. The OMG’s UML based tools helps in the process of analyzing the requirements of future applications and design solutions which will help in attaining them. The power of OMG UML is that it helps in the modelling of any kind of application, which is running on a variable combination of hardware, programming language, operating system and network (Object...
4 Pages(1000 words)Admission/Application Essay
Relational Database System Design
The current system has been facing some challenges with the structure and the design of its database and the relationship of the data items. The immediately noticeable challenge with the database is the use of important database elements, such as primary keys, foreign keys, and the relationships. The tables apparently require normalization. If the database is not normalized, there is a high risk of the data being inconsistent and lacking integrity. The proposed information management system for the ECT project should have the ability to integrate flawlessly into the ECT Relational Database. The ECT Information Management System infrastructure receives the required data through structural query request, using special criteria for d...
4 Pages(1000 words)Admission/Application Essay
Object Database Management System
...that lead users to implement object database technology. Firstly, relational databases turn out to be cumbersome to use with composite data. Secondly, data is usually operated by application software written using object-oriented programming languages such as C++, Java, Delphi and C#, and the code required translating between this demonstration of the data and the tuples of a relational database can be dreary to write, and prolonged to execute. This variance between the models used to represent information in the application programs and the database is sometimes referred to as an impedance...
8 Pages(2000 words)Essay
Relational Database Design
...Relational Database Design The Design of a Relational Database by This paper describes the process of creating a relational database. Itincludes the SQL code (MySQL) for creating the tables, the joins to create the necessary relationships and the results of those SQL runs. It describes the specifications of the proposed system, the logic of that system, the table definitions and contents, a live transaction which inserts data and one that deletes it and finally a non-trivial query which demonstrates multiple joins, group functions, qualifiers and correlation variables. Relational Database Design The hallmark of the relational database is that when one table changes in the database all other tables are updated and are current. 1... ...
6 Pages(1500 words)Assignment
Relational Database
...120477 Current Of Database Technology Database technology started from flat file storages and over the years evolved into electronic data storages in the form of records and tables to complete relational and object-oriented databases. Today, the databases are not just restricted to objects, but they have also gone to the level of media support in the form of multimedia databases which support multimedia content to be stored in the databases. Today, with the increasing data requirements and storage needs, the databases have gone a step further. The emergence of data...
8 Pages(2000 words)Essay
...Object - Teacup I selected a tea cup that has a curious form, and is used everyday by me in the morning and evening. I bought it from a pavementshop because it attracted me with its unusual shape and simple yet intriguing color pattern that combined white, red and yellow in a creative manner, emphasizing the design positively. Moreover, the fact that this was a handmade teacup, with slight defects in its shape seemed to make it unique work of art to me, though meant also for some utility. It could very well be used as a showpiece, but I decided to use it everyday if possible, in order to establish some connection with its form and design gradually. The cup seemed to follow three geometrical figures, of a cone, a...
3 Pages(750 words)Essay
Relational database solution
...and promote the achievement of the objectives of the business organization. Data sharing in the organization The relational database also offers the ability for users to share information simultaneously. Since all the information required for the business is located within a system, all users can easily and seamlessly share updates or any other changes that are made. The relational database can automatically update in all areas of the information system when an addition, deletion or update is made; all users will have immediate (or almost immediate) access to this information because everything is already cross referenced Benefits of the data base for...
2 Pages(500 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Let us find you another Essay on topic Object Relational Database for FREE!
logo footer
Contact us:
Contact Us Now
FREE Mobile Apps:
  • StudentShare App Store
  • StudentShare Google play
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • Miscellaneous
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us