0
What is the difference between object-oriented database and relational database?
Wiki User
∙ 15y ago
A Relational Database is designed and maintained following some very well defined rules of logic and algebra. It often portrays a "one to many" relationship between two sets of data, and, less often, a "one to one" and "many to many" relation can be developed. An OO database uses less rigid design parameters, and can be adjusted design-wise to fit almost any kind of data environment. In fact, I'm not absolutely sure there is such a thing as an "object oriented" database, so much as there are database objects that are created and maintained with OO programming. I know that sounds self-referenceing, but that's OO for you... A relational database uses structure to locate and display data values, rather than programming logic. With a correctly designed RDB, finding and displaying data is very simple, compared to earlier network databases. Relational databases also permit the use of JOINS to merge and match sets of data ("relations"), to glean more information from your database that would normally be available.
Wiki User
∙ 15y ago
Wiki User
∙ 13y agoThe answer can be as simple as parking your car in the garage, considering your car to be an object.
In object database, the object or in this case, the car would be stored or parked in the database,ie, the garage whereas in the relational database, the car would be broken down into its subsystems so its engine,doors,lights,switches and all the parts associated with it would be stored separately(of course with primary key which is gonna be reference when you pull it out) .
Traditional relational databases were build to handle simple data sets but with the advent of OO programming, the information associated with a particular object had to be mapped in the database which created the need to develop object databases.
Wiki User
∙ 15y agoDatabase is of number of types two of them are OODBMS and RDBMS. OODBMS is acronym for object oriented database and RDBMS stands for relational database. In OODBMS object oriented features are inculcated and in RDBMS relation between the tables is defined.
A Relational Database is designed and maintained following some very well defined rules of logic and algebra. It often portrays a "one to many" relationship between two sets of data, and, less often, a "one to one" and "many to many" relation can be developed. An OO database uses less rigid design parameters, and can be adjusted design-wise to fit almost any kind of data environment. In fact, I'm not absolutely sure there is such a thing as an "object oriented" database, so much as there are database objects that are created and maintained with OO programming. I know that sounds self-referenceing, but that's OO for you... A relational database uses structure to locate and display data values, rather than programming logic. With a correctly designed RDB, finding and displaying data is very simple, compared to earlier network databases. Relational databases also permit the use of JOINS to merge and match sets of data ("relations"), to glean more information from your database that would normally be available.
Wiki User
∙ 9y agoDatabase is of number of types two of them are OODBMS and RDBMS. OODBMS is acronym for object oriented database and RDBMS stands for relational database. In OODBMS object oriented features are inculcated and in RDBMS relation between the tables is defined.
Wiki User
∙ 9y agoAn object oriented database has object oriented features . In OODBMS concepts like encapsulation , data hiding, reusability are also involved. While Relational database model defines relationship between the tables.
Wiki User
∙ 11y agothereare many differentation but i dont know
Add your answer:
Earn +20 pts
Difference between database and relational database?
A relational database is a type of database, so in one sense there is no difference. There are various kinds of database. A relational database is one type. Others include network and hierarchical.
When would you want to use a relational database?
The word 'relational' in an RDBMS stands for relationships between tables (parent and child). So whenever you have information that can benefit from such a feature you would use relational database. For example, a customer places many orders and each order has items. This type of real world scenario is better represented in a database than in a spreadsheet for example.
What is the difference between flat file and relational databases?
A flat file system usually stores the same type of information over and over again, whereas a relational database does not. A flat file system might store zip-codes and their explanation (location of the zip code) over and over again, each time per record. A relational database stored the explanation for any given zip-code only once, and looks that information up when it needs it. --
Advantages and disadvantages of relational model?
A relational database is a database that stores data in the form of tables as well as defines relationship between those tables. A RDBMS helps in maintaining data integrity and consistency. Due to greater searching capabilities there is increased overhead.
What is relational conflict?
Relational conflict is between two or more people how either hate or are angry With someone the may be discouraged from seeing the person
What are the difference between hierarchical database and network database?
what is the difference between hirarchical,network and relational database model?
Difference between database and relational database?
A relational database is a type of database, so in one sense there is no difference. There are various kinds of database. A relational database is one type. Others include network and hierarchical.
What is the difference between sybase and rdbms?
An RDBMS is a general term for a relational database system and Sybase is a specific product which implements a relational database.
Difference between database and relational database explain with example?
Database = Generic name for a system to store data Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.
How are relationship between tables expressed in a relational database?
Tables are the basic building blocks of a relational database.
What are the differences between database management system Vs relational dbms?
the database management system analysis the data or record but relational database management system links the database to each other.
Difference between multimedia and hypermedia?
Multimedia is based on two key concepts; integration and interactivity while hypermedia is based on a relational database organisation
What is main difference between dbms rdbms why it is called relational database?
There are mainly three different Database architectures and they are network, hierarchical and Relational. The DBMSystems that follow the Relational architectural concepts are known as RDBMS. This is supposed to be superior in design and performance to the other two and there are, to my knowledge, no functional DBMS following the other two concepts in the market today.
What is difference between linear syntax and relational algebra?
They are not alternative solutions so that we can compare them. Relational database (which is based on relational algebra) demands (atleast the founder of relational database Codd suggests) that the query language follow linear syntax. The linear syntax languages don't rely up on newline characters as terminators of expressions or statements -- instead they rely on other tokens such as semicolon or comma and so on.
Find out functional dependencies?
A constraint between two sets of attributes is known as functional dependency in relational database. Determination of functional dependencies is vital in database denormalization, normalization and relational model.
What is the difference between OODBMS and DBMS?
Third generation of database design theory. DBMS: Database Management System RDBMS: Relational Database Management System OODBMS: Object Oriented Database Management System
Are there any major similiarities between object oriented databases and relational databases?
In a Object Oriented Database, information is given in the form of objects as used in programming languages. "When database capabilities are combined with object programming language capabilities, the result is an object database management system (ODBMS). An ODBMS makes database objects appear as programming language objects in one or more object programming languages." (http://en.wikipedia.org/wiki/Object_database)"A relational database is a database that conforms to the relational model, and refers to a database's data and schema (the database's structure of how those data are arranged). Common usage of the term "Relational database management system" technically refers to the software used to create a relational database, but sometimes mistakenly refers to a relational database." (http://en.wikipedia.org/wiki/Relational_database)
