why there isn't any pointer in relational model?
up vote
-1
down vote
favorite
It is a different from this question, because as I explain in my own post, my purpose is to find out why databases don't use pointers instead of keys and what are the other options to implement its functionality.
As I read the implementation of relational database, there isn't anything with the concept of pointer in it.
Here is my questions:
- Why there isn't any pointer in the relational model?
database relational-database relational-model
asked Nov 10 at 14:02
Somehow
94
add a comment |
up vote
-1
down vote
favorite
It is a different from this question, because as I explain in my own post, my purpose is to find out why databases don't use pointers instead of keys and what are the other options to implement its functionality.
As I read the implementation of relational database, there isn't anything with the concept of pointer in it.
Here is my questions:
- Why there isn't any pointer in the relational model?
database relational-database relational-model
asked Nov 10 at 14:02
Somehow
94
Hi. Please ask one question per question. Also 1 is a faq & 2 is not clear.
– philipxy
Nov 10 at 17:59
Possible duplicate of historically, what made relational databases popular?
– philipxy
Nov 10 at 17:59
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
It is a different from this question, because as I explain in my own post, my purpose is to find out why databases don't use pointers instead of keys and what are the other options to implement its functionality.
As I read the implementation of relational database, there isn't anything with the concept of pointer in it.
Here is my questions:
- Why there isn't any pointer in the relational model?
database relational-database relational-model
asked Nov 10 at 14:02
Somehow
94
It is a different from this question, because as I explain in my own post, my purpose is to find out why databases don't use pointers instead of keys and what are the other options to implement its functionality.
As I read the implementation of relational database, there isn't anything with the concept of pointer in it.
Here is my questions:
- Why there isn't any pointer in the relational model?
database relational-database relational-model
database relational-database relational-model
asked Nov 10 at 14:02
Somehow
94
asked Nov 10 at 14:02
Somehow
94
edited Nov 10 at 18:15
asked Nov 10 at 14:02
Somehow
94
asked Nov 10 at 14:02
Somehow
94
asked Nov 10 at 14:02
Somehow
94
94
Hi. Please ask one question per question. Also 1 is a faq & 2 is not clear.
– philipxy
Nov 10 at 17:59
Possible duplicate of historically, what made relational databases popular?
– philipxy
Nov 10 at 17:59
add a comment |
Hi. Please ask one question per question. Also 1 is a faq & 2 is not clear.
– philipxy
Nov 10 at 17:59
Possible duplicate of historically, what made relational databases popular?
– philipxy
Nov 10 at 17:59
Hi. Please ask one question per question. Also 1 is a faq & 2 is not clear.
– philipxy
Nov 10 at 17:59
Hi. Please ask one question per question. Also 1 is a faq & 2 is not clear.
– philipxy
Nov 10 at 17:59
Possible duplicate of historically, what made relational databases popular?
– philipxy
Nov 10 at 17:59
Possible duplicate of historically, what made relational databases popular?
– philipxy
Nov 10 at 17:59
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
Why there isn't any pointer in the relational model?
Many databases use technical IDs that one could call pointers. It's like generating a number (like an address) with which to find the record in the table.
Say you have a table of orders and another of customers. The customers table would contain some customer ID. A record in the orders table would also contain a customer ID. So an order (a record in the order table) would thus point to the related customer (a record in the customers table).
Is there any system file feature that isn't implemented by relational model?
I can't think of any. Both systems can be used to store, organize, find, copy, move, backup, and versionize files.
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
Do they use keys instead of pointers like described here: 167.99.51.102:8080
– Somehow
Nov 10 at 17:33
I cannot reach that site. Anyway, yes, the key serves as a unique address in a table.
– Thorsten Kettner
Nov 10 at 17:39
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
Why there isn't any pointer in the relational model?
Many databases use technical IDs that one could call pointers. It's like generating a number (like an address) with which to find the record in the table.
Say you have a table of orders and another of customers. The customers table would contain some customer ID. A record in the orders table would also contain a customer ID. So an order (a record in the order table) would thus point to the related customer (a record in the customers table).
Is there any system file feature that isn't implemented by relational model?
I can't think of any. Both systems can be used to store, organize, find, copy, move, backup, and versionize files.
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
Do they use keys instead of pointers like described here: 167.99.51.102:8080
– Somehow
Nov 10 at 17:33
I cannot reach that site. Anyway, yes, the key serves as a unique address in a table.
– Thorsten Kettner
Nov 10 at 17:39
add a comment |
up vote
0
down vote
accepted
Why there isn't any pointer in the relational model?
Many databases use technical IDs that one could call pointers. It's like generating a number (like an address) with which to find the record in the table.
Say you have a table of orders and another of customers. The customers table would contain some customer ID. A record in the orders table would also contain a customer ID. So an order (a record in the order table) would thus point to the related customer (a record in the customers table).
Is there any system file feature that isn't implemented by relational model?
I can't think of any. Both systems can be used to store, organize, find, copy, move, backup, and versionize files.
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
Do they use keys instead of pointers like described here: 167.99.51.102:8080
– Somehow
Nov 10 at 17:33
I cannot reach that site. Anyway, yes, the key serves as a unique address in a table.
– Thorsten Kettner
Nov 10 at 17:39
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
Why there isn't any pointer in the relational model?
Many databases use technical IDs that one could call pointers. It's like generating a number (like an address) with which to find the record in the table.
Say you have a table of orders and another of customers. The customers table would contain some customer ID. A record in the orders table would also contain a customer ID. So an order (a record in the order table) would thus point to the related customer (a record in the customers table).
Is there any system file feature that isn't implemented by relational model?
I can't think of any. Both systems can be used to store, organize, find, copy, move, backup, and versionize files.
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
Why there isn't any pointer in the relational model?
Many databases use technical IDs that one could call pointers. It's like generating a number (like an address) with which to find the record in the table.
Say you have a table of orders and another of customers. The customers table would contain some customer ID. A record in the orders table would also contain a customer ID. So an order (a record in the order table) would thus point to the related customer (a record in the customers table).
Is there any system file feature that isn't implemented by relational model?
I can't think of any. Both systems can be used to store, organize, find, copy, move, backup, and versionize files.
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
edited Nov 10 at 15:58
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
answered Nov 10 at 14:30
Thorsten Kettner
49.7k22441
49.7k22441
Do they use keys instead of pointers like described here: 167.99.51.102:8080
– Somehow
Nov 10 at 17:33
I cannot reach that site. Anyway, yes, the key serves as a unique address in a table.
– Thorsten Kettner
Nov 10 at 17:39
add a comment |
Do they use keys instead of pointers like described here: 167.99.51.102:8080
– Somehow
Nov 10 at 17:33
I cannot reach that site. Anyway, yes, the key serves as a unique address in a table.
– Thorsten Kettner
Nov 10 at 17:39
Do they use keys instead of pointers like described here: 167.99.51.102:8080
– Somehow
Nov 10 at 17:33
Do they use keys instead of pointers like described here: 167.99.51.102:8080
– Somehow
Nov 10 at 17:33
I cannot reach that site. Anyway, yes, the key serves as a unique address in a table.
– Thorsten Kettner
Nov 10 at 17:39
I cannot reach that site. Anyway, yes, the key serves as a unique address in a table.
– Thorsten Kettner
Nov 10 at 17:39
add a comment |
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
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53239724%2fwhy-there-isnt-any-pointer-in-relational-model%23new-answer', 'question_page');
}
);
Post as a guest
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
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
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
Hi. Please ask one question per question. Also 1 is a faq & 2 is not clear.
– philipxy
Nov 10 at 17:59
Possible duplicate of historically, what made relational databases popular?
– philipxy
Nov 10 at 17:59