Relationship between data independence and database schemaHow to translate high level entity relationship...
Biological Blimps: Propulsion
Does malloc reserve more space while allocating memory?
When were female captains banned from Starfleet?
Do the primes contain an infinite almost arithmetic progression?
Can disgust be a key component of horror?
Why is short-wave infrared portion of electromagnetic spectrum so sensitive to fire?
Why is this estimator biased?
It grows, but water kills it
Can a college of swords bard use blade flourish on an OA from dissonant whispers?
What is the evidence for the "tyranny of the majority problem" in a direct democracy context?
How much character growth crosses the line into breaking the character
Non-trope happy ending?
A binary search solution to 3Sum
Electoral considerations aside, what are potential benefits, for the US, of policy changes proposed by the tweet recognizing Golan annexation?
How do I delete all blank lines in a buffer?
Multiplicative persistence
What if you are holding an Iron Flask with a demon inside and walk into Antimagic Field?
Strong empirical falsification of quantum mechanics based on vacuum energy density?
What is going on with 'gets(stdin)' on the site coderbyte?
Can a stoichiometric mixture of oxygen and methane exist as a liquid at standard pressure and some (low) temperature?
What features enable the Su-25 Frogfoot to operate with such a wide variety of fuels?
Is there a RAID 0 Equivalent for RAM?
Calculating total slots
How should I address a possible mistake to co-authors in a submitted paper
Relationship between data independence and database schema
How to translate high level entity relationship into schemaTernary relationship: what's the difference between having single table and having multiple tables?What is the best way to represent the relationship between Team and Player in an ERD?Does software exist for transforming data from one DB schema to another?Help with database schemaDifference between star schema and data cube?How do I model a many-to-many relationship on two different columns?M:M RelationshipsRelationship between stock and productSame relationship between tables
What is the relationship between data independence and database schema? I know both of them separately. But I don't know how to explain the relationship of these two.
database-design replication
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
What is the relationship between data independence and database schema? I know both of them separately. But I don't know how to explain the relationship of these two.
database-design replication
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
What is the relationship between data independence and database schema? I know both of them separately. But I don't know how to explain the relationship of these two.
database-design replication
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
What is the relationship between data independence and database schema? I know both of them separately. But I don't know how to explain the relationship of these two.
database-design replication
database-design replication
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
asked Feb 11 '16 at 22:27
QuestionMakerQuestionMaker
1
1
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 10 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Once upon a time, applications had to deal not only with the logic, the relation between data elements but with the gory details of structuring, reading and writing of the data.
Even slight modifications of the data and the relations of the data to store could result in changes of the code in magnitudes that shook its foundations.
On the other hand, if the logic changed so that any tiny modification in the stored data was necessary, then boring and often dangerous data conversion tasks had to be done - and even the code for that was your responsibility, with all the gory details again.
That is the code was tightly bound to the data and vice versa.
Things changed when database managers appeared. They take off the load of those gory details from the shoulder of the developers. They allow them creation and modifications of data structures without the need of knowing every inch of the underlying OS and without having to write low level code for migration from scratch.
Of course, modifications still have to be followed at each sides and high level code (its kind depends of the db manager) for conversion is still required but the complexity (and thus, probability of bugs) is incomparably lower than without data independence.
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
i think i got some sort of idea with your explanation.. thanks a lot..
– QuestionMaker
Feb 18 '16 at 17:55
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f129046%2frelationship-between-data-independence-and-database-schema%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
Once upon a time, applications had to deal not only with the logic, the relation between data elements but with the gory details of structuring, reading and writing of the data.
Even slight modifications of the data and the relations of the data to store could result in changes of the code in magnitudes that shook its foundations.
On the other hand, if the logic changed so that any tiny modification in the stored data was necessary, then boring and often dangerous data conversion tasks had to be done - and even the code for that was your responsibility, with all the gory details again.
That is the code was tightly bound to the data and vice versa.
Things changed when database managers appeared. They take off the load of those gory details from the shoulder of the developers. They allow them creation and modifications of data structures without the need of knowing every inch of the underlying OS and without having to write low level code for migration from scratch.
Of course, modifications still have to be followed at each sides and high level code (its kind depends of the db manager) for conversion is still required but the complexity (and thus, probability of bugs) is incomparably lower than without data independence.
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
i think i got some sort of idea with your explanation.. thanks a lot..
– QuestionMaker
Feb 18 '16 at 17:55
add a comment |
Once upon a time, applications had to deal not only with the logic, the relation between data elements but with the gory details of structuring, reading and writing of the data.
Even slight modifications of the data and the relations of the data to store could result in changes of the code in magnitudes that shook its foundations.
On the other hand, if the logic changed so that any tiny modification in the stored data was necessary, then boring and often dangerous data conversion tasks had to be done - and even the code for that was your responsibility, with all the gory details again.
That is the code was tightly bound to the data and vice versa.
Things changed when database managers appeared. They take off the load of those gory details from the shoulder of the developers. They allow them creation and modifications of data structures without the need of knowing every inch of the underlying OS and without having to write low level code for migration from scratch.
Of course, modifications still have to be followed at each sides and high level code (its kind depends of the db manager) for conversion is still required but the complexity (and thus, probability of bugs) is incomparably lower than without data independence.
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
i think i got some sort of idea with your explanation.. thanks a lot..
– QuestionMaker
Feb 18 '16 at 17:55
add a comment |
Once upon a time, applications had to deal not only with the logic, the relation between data elements but with the gory details of structuring, reading and writing of the data.
Even slight modifications of the data and the relations of the data to store could result in changes of the code in magnitudes that shook its foundations.
On the other hand, if the logic changed so that any tiny modification in the stored data was necessary, then boring and often dangerous data conversion tasks had to be done - and even the code for that was your responsibility, with all the gory details again.
That is the code was tightly bound to the data and vice versa.
Things changed when database managers appeared. They take off the load of those gory details from the shoulder of the developers. They allow them creation and modifications of data structures without the need of knowing every inch of the underlying OS and without having to write low level code for migration from scratch.
Of course, modifications still have to be followed at each sides and high level code (its kind depends of the db manager) for conversion is still required but the complexity (and thus, probability of bugs) is incomparably lower than without data independence.
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
Once upon a time, applications had to deal not only with the logic, the relation between data elements but with the gory details of structuring, reading and writing of the data.
Even slight modifications of the data and the relations of the data to store could result in changes of the code in magnitudes that shook its foundations.
On the other hand, if the logic changed so that any tiny modification in the stored data was necessary, then boring and often dangerous data conversion tasks had to be done - and even the code for that was your responsibility, with all the gory details again.
That is the code was tightly bound to the data and vice versa.
Things changed when database managers appeared. They take off the load of those gory details from the shoulder of the developers. They allow them creation and modifications of data structures without the need of knowing every inch of the underlying OS and without having to write low level code for migration from scratch.
Of course, modifications still have to be followed at each sides and high level code (its kind depends of the db manager) for conversion is still required but the complexity (and thus, probability of bugs) is incomparably lower than without data independence.
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
answered Feb 14 '16 at 11:44
Gombai SándorGombai Sándor
101
101
i think i got some sort of idea with your explanation.. thanks a lot..
– QuestionMaker
Feb 18 '16 at 17:55
add a comment |
i think i got some sort of idea with your explanation.. thanks a lot..
– QuestionMaker
Feb 18 '16 at 17:55
i think i got some sort of idea with your explanation.. thanks a lot..
– QuestionMaker
Feb 18 '16 at 17:55
i think i got some sort of idea with your explanation.. thanks a lot..
– QuestionMaker
Feb 18 '16 at 17:55
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f129046%2frelationship-between-data-independence-and-database-schema%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
