Relational database vs object-relational database
up vote
0
down vote
favorite
There's plenty of questions on SO about the differences between OO databases like MongoDB vs relational databases, but I can't find anything about the differences between a relational database like MySQL vs an object-relational database like PostgreSQL at a high level. I understand that these two particular databases have differing functionality respectively, but I don't really understand why something like MySQL that claims to be simply relational doesn't return the same formed data as an object-relational database like PostgreSQL. Some of what I read on other sources say it's what they return when queried that is different; is this true?
mysql postgresql
asked Nov 20 at 2:05
Yeysides
74411021
add a comment |
up vote
0
down vote
favorite
There's plenty of questions on SO about the differences between OO databases like MongoDB vs relational databases, but I can't find anything about the differences between a relational database like MySQL vs an object-relational database like PostgreSQL at a high level. I understand that these two particular databases have differing functionality respectively, but I don't really understand why something like MySQL that claims to be simply relational doesn't return the same formed data as an object-relational database like PostgreSQL. Some of what I read on other sources say it's what they return when queried that is different; is this true?
mysql postgresql
asked Nov 20 at 2:05
Yeysides
74411021
This a very general question. Why should different database be required to return the same formed data? Not sure of the context. For the most part SQL queries that don't deviate from the SQL standard will will return the same result.
– danblack
Nov 20 at 2:13
Can you try to clarify the purpose of this differentiation? If you want comments on the accuracy of differences, be precise and quote references.
– danblack
Nov 20 at 2:15
Who says that Postgres is an object relational database, and MySQL is not? Is there any real meaning here?
– Tim Biegeleisen
Nov 20 at 2:20
@TimBiegeleisen "PostgreSQL is a powerful, open source object-relational database system.." from the postgresl website. I want to know how that's different from just a relational database.
– Yeysides
Nov 20 at 2:30
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
There's plenty of questions on SO about the differences between OO databases like MongoDB vs relational databases, but I can't find anything about the differences between a relational database like MySQL vs an object-relational database like PostgreSQL at a high level. I understand that these two particular databases have differing functionality respectively, but I don't really understand why something like MySQL that claims to be simply relational doesn't return the same formed data as an object-relational database like PostgreSQL. Some of what I read on other sources say it's what they return when queried that is different; is this true?
mysql postgresql
asked Nov 20 at 2:05
Yeysides
74411021
There's plenty of questions on SO about the differences between OO databases like MongoDB vs relational databases, but I can't find anything about the differences between a relational database like MySQL vs an object-relational database like PostgreSQL at a high level. I understand that these two particular databases have differing functionality respectively, but I don't really understand why something like MySQL that claims to be simply relational doesn't return the same formed data as an object-relational database like PostgreSQL. Some of what I read on other sources say it's what they return when queried that is different; is this true?
mysql postgresql
mysql postgresql
asked Nov 20 at 2:05
Yeysides
74411021
asked Nov 20 at 2:05
Yeysides
74411021
asked Nov 20 at 2:05
Yeysides
74411021
asked Nov 20 at 2:05
Yeysides
74411021
asked Nov 20 at 2:05
Yeysides
74411021
74411021
This a very general question. Why should different database be required to return the same formed data? Not sure of the context. For the most part SQL queries that don't deviate from the SQL standard will will return the same result.
– danblack
Nov 20 at 2:13
Can you try to clarify the purpose of this differentiation? If you want comments on the accuracy of differences, be precise and quote references.
– danblack
Nov 20 at 2:15
Who says that Postgres is an object relational database, and MySQL is not? Is there any real meaning here?
– Tim Biegeleisen
Nov 20 at 2:20
@TimBiegeleisen "PostgreSQL is a powerful, open source object-relational database system.." from the postgresl website. I want to know how that's different from just a relational database.
– Yeysides
Nov 20 at 2:30
add a comment |
This a very general question. Why should different database be required to return the same formed data? Not sure of the context. For the most part SQL queries that don't deviate from the SQL standard will will return the same result.
– danblack
Nov 20 at 2:13
Can you try to clarify the purpose of this differentiation? If you want comments on the accuracy of differences, be precise and quote references.
– danblack
Nov 20 at 2:15
Who says that Postgres is an object relational database, and MySQL is not? Is there any real meaning here?
– Tim Biegeleisen
Nov 20 at 2:20
@TimBiegeleisen "PostgreSQL is a powerful, open source object-relational database system.." from the postgresl website. I want to know how that's different from just a relational database.
– Yeysides
Nov 20 at 2:30
This a very general question. Why should different database be required to return the same formed data? Not sure of the context. For the most part SQL queries that don't deviate from the SQL standard will will return the same result.
– danblack
Nov 20 at 2:13
This a very general question. Why should different database be required to return the same formed data? Not sure of the context. For the most part SQL queries that don't deviate from the SQL standard will will return the same result.
– danblack
Nov 20 at 2:13
Can you try to clarify the purpose of this differentiation? If you want comments on the accuracy of differences, be precise and quote references.
– danblack
Nov 20 at 2:15
Can you try to clarify the purpose of this differentiation? If you want comments on the accuracy of differences, be precise and quote references.
– danblack
Nov 20 at 2:15
Who says that Postgres is an object relational database, and MySQL is not? Is there any real meaning here?
– Tim Biegeleisen
Nov 20 at 2:20
Who says that Postgres is an object relational database, and MySQL is not? Is there any real meaning here?
– Tim Biegeleisen
Nov 20 at 2:20
@TimBiegeleisen "PostgreSQL is a powerful, open source object-relational database system.." from the postgresl website. I want to know how that's different from just a relational database.
– Yeysides
Nov 20 at 2:30
@TimBiegeleisen "PostgreSQL is a powerful, open source object-relational database system.." from the postgresl website. I want to know how that's different from just a relational database.
– Yeysides
Nov 20 at 2:30
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
Maybe this entry from DBA Stackexchange would be helpful:
https://dba.stackexchange.com/questions/77340/how-to-understand-object-relational
In particular, this answer: https://dba.stackexchange.com/a/77344/111252
Essentially it describes built-in inheritance features of Postgres that are outside of the SQL standard. That seems to be the key difference.
answered Nov 20 at 2:29
Matt Morgan
2,1712820
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53385202%2frelational-database-vs-object-relational-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
Maybe this entry from DBA Stackexchange would be helpful:
https://dba.stackexchange.com/questions/77340/how-to-understand-object-relational
In particular, this answer: https://dba.stackexchange.com/a/77344/111252
Essentially it describes built-in inheritance features of Postgres that are outside of the SQL standard. That seems to be the key difference.
answered Nov 20 at 2:29
Matt Morgan
2,1712820
add a comment |
up vote
1
down vote
accepted
Maybe this entry from DBA Stackexchange would be helpful:
https://dba.stackexchange.com/questions/77340/how-to-understand-object-relational
In particular, this answer: https://dba.stackexchange.com/a/77344/111252
Essentially it describes built-in inheritance features of Postgres that are outside of the SQL standard. That seems to be the key difference.
answered Nov 20 at 2:29
Matt Morgan
2,1712820
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
Maybe this entry from DBA Stackexchange would be helpful:
https://dba.stackexchange.com/questions/77340/how-to-understand-object-relational
In particular, this answer: https://dba.stackexchange.com/a/77344/111252
Essentially it describes built-in inheritance features of Postgres that are outside of the SQL standard. That seems to be the key difference.
answered Nov 20 at 2:29
Matt Morgan
2,1712820
Maybe this entry from DBA Stackexchange would be helpful:
https://dba.stackexchange.com/questions/77340/how-to-understand-object-relational
In particular, this answer: https://dba.stackexchange.com/a/77344/111252
Essentially it describes built-in inheritance features of Postgres that are outside of the SQL standard. That seems to be the key difference.
answered Nov 20 at 2:29
Matt Morgan
2,1712820
answered Nov 20 at 2:29
Matt Morgan
2,1712820
answered Nov 20 at 2:29
Matt Morgan
2,1712820
answered Nov 20 at 2:29
Matt Morgan
2,1712820
2,1712820
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53385202%2frelational-database-vs-object-relational-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
This a very general question. Why should different database be required to return the same formed data? Not sure of the context. For the most part SQL queries that don't deviate from the SQL standard will will return the same result.
– danblack
Nov 20 at 2:13
Can you try to clarify the purpose of this differentiation? If you want comments on the accuracy of differences, be precise and quote references.
– danblack
Nov 20 at 2:15
Who says that Postgres is an object relational database, and MySQL is not? Is there any real meaning here?
– Tim Biegeleisen
Nov 20 at 2:20
@TimBiegeleisen "PostgreSQL is a powerful, open source object-relational database system.." from the postgresl website. I want to know how that's different from just a relational database.
– Yeysides
Nov 20 at 2:30