How to convert “AS” to relational algebra
up vote
-2
down vote
favorite
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
edited Nov 10 at 4:10
D-Shih
24.4k61431
asked Nov 10 at 4:03
Yushey
273
add a comment |
up vote
-2
down vote
favorite
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
edited Nov 10 at 4:10
D-Shih
24.4k61431
asked Nov 10 at 4:03
Yushey
273
2
What do you meanrelational algebra?
– D-Shih
Nov 10 at 4:11
I think, You may referAggregationtitle of this link : en.wikipedia.org/wiki/Relational_algebra
– Barbaros Özhan
Nov 10 at 4:21
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
Nov 10 at 6:02
1
What does your title have to do with the body of your post & your question?
– philipxy
Nov 10 at 6:16
"How would I convert this to relational algebra?" RA is not the same as SQL; does not have the same semantics; and in general there is no mechanical way to 'convert' between them. Why do you think you can 'convert'? Please give a reference to what authority you are quoting from.
– AntC
Nov 12 at 4:38
add a comment |
up vote
-2
down vote
favorite
up vote
-2
down vote
favorite
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
edited Nov 10 at 4:10
D-Shih
24.4k61431
asked Nov 10 at 4:03
Yushey
273
If I have a simple query:
SELECT COUNT(*) AS num
FROM Person
GROUP BY ID;
How would I convert this to relational algebra?
sql relational-algebra
sql relational-algebra
edited Nov 10 at 4:10
D-Shih
24.4k61431
asked Nov 10 at 4:03
Yushey
273
edited Nov 10 at 4:10
D-Shih
24.4k61431
asked Nov 10 at 4:03
Yushey
273
edited Nov 10 at 4:10
D-Shih
24.4k61431
edited Nov 10 at 4:10
D-Shih
24.4k61431
edited Nov 10 at 4:10
D-Shih
24.4k61431
24.4k61431
asked Nov 10 at 4:03
Yushey
273
asked Nov 10 at 4:03
Yushey
273
asked Nov 10 at 4:03
Yushey
273
273
2
What do you meanrelational algebra?
– D-Shih
Nov 10 at 4:11
I think, You may referAggregationtitle of this link : en.wikipedia.org/wiki/Relational_algebra
– Barbaros Özhan
Nov 10 at 4:21
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
Nov 10 at 6:02
1
What does your title have to do with the body of your post & your question?
– philipxy
Nov 10 at 6:16
"How would I convert this to relational algebra?" RA is not the same as SQL; does not have the same semantics; and in general there is no mechanical way to 'convert' between them. Why do you think you can 'convert'? Please give a reference to what authority you are quoting from.
– AntC
Nov 12 at 4:38
add a comment |
2
What do you meanrelational algebra?
– D-Shih
Nov 10 at 4:11
I think, You may referAggregationtitle of this link : en.wikipedia.org/wiki/Relational_algebra
– Barbaros Özhan
Nov 10 at 4:21
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
Nov 10 at 6:02
1
What does your title have to do with the body of your post & your question?
– philipxy
Nov 10 at 6:16
"How would I convert this to relational algebra?" RA is not the same as SQL; does not have the same semantics; and in general there is no mechanical way to 'convert' between them. Why do you think you can 'convert'? Please give a reference to what authority you are quoting from.
– AntC
Nov 12 at 4:38
2
2
What do you mean
relational algebra?– D-Shih
Nov 10 at 4:11
What do you mean
relational algebra?– D-Shih
Nov 10 at 4:11
I think, You may refer
Aggregation title of this link : en.wikipedia.org/wiki/Relational_algebra– Barbaros Özhan
Nov 10 at 4:21
I think, You may refer
Aggregation title of this link : en.wikipedia.org/wiki/Relational_algebra– Barbaros Özhan
Nov 10 at 4:21
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
Nov 10 at 6:02
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
Nov 10 at 6:02
1
1
What does your title have to do with the body of your post & your question?
– philipxy
Nov 10 at 6:16
What does your title have to do with the body of your post & your question?
– philipxy
Nov 10 at 6:16
"How would I convert this to relational algebra?" RA is not the same as SQL; does not have the same semantics; and in general there is no mechanical way to 'convert' between them. Why do you think you can 'convert'? Please give a reference to what authority you are quoting from.
– AntC
Nov 12 at 4:38
"How would I convert this to relational algebra?" RA is not the same as SQL; does not have the same semantics; and in general there is no mechanical way to 'convert' between them. Why do you think you can 'convert'? Please give a reference to what authority you are quoting from.
– AntC
Nov 12 at 4:38
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53235897%2fhow-to-convert-as-to-relational-algebra%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
2
What do you mean
relational algebra?– D-Shih
Nov 10 at 4:11
I think, You may refer
Aggregationtitle of this link : en.wikipedia.org/wiki/Relational_algebra– Barbaros Özhan
Nov 10 at 4:21
Hi. There are many relational algebras--Give your texbook name & edition & where in it or define what "relation" means & exactly how the operators work. Define "convert"--Same result? Same structure also? See How to Ask, the downvote arrow mouseover text & hits googling 'stackexchange homework'--What have you found? What can you do? What do you suspect? PS Relation algebra is a programming language. Is there anything more we need to know from a Minimal, Complete, and Verifiable example?
– philipxy
Nov 10 at 6:02
1
What does your title have to do with the body of your post & your question?
– philipxy
Nov 10 at 6:16
"How would I convert this to relational algebra?" RA is not the same as SQL; does not have the same semantics; and in general there is no mechanical way to 'convert' between them. Why do you think you can 'convert'? Please give a reference to what authority you are quoting from.
– AntC
Nov 12 at 4:38