Extension of SQL to capture more information from objects with many-many relationship

Jorng Tzong Horng; Gwo Dong Chen; Baw Jhiune Liu

Extension of SQL to capture more information from objects with many-many relationship

Jorng Tzong Horng, Gwo Dong Chen, Baw Jhiune Liu

Department of Computer Science and Information Engineering

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

Abstract

Many decision support applications such as task assignment, truck deliveries, airline screw scheduling problems usually need to get information from objects with many-many relationship. However, current relational operators including the complete set of relational algebra and other relational operators are difficult to get required information from objects with many-many relationship. In this paper, we extend SQL so that users can capture more information from objects with many-many relationship by using the query language directly. The relational operators were extended with six operators, namely, match, maxmatch, cover, mincover, partition, and minpartition.

Original language	English
Title of host publication	Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering
Publisher	Publ by IEEE
Pages	356-359
Number of pages	4
ISBN (Print)	0780312333
State	Published - 1993
Event	Proceedings of the 1993 IEEE Region 10 Conference on Computer, Communication, Control and Power Engineering (TENCON '93). Part 1 (of 5) - Beijing, China Duration: 19 Oct 1993 → 21 Oct 1993

Publication series

Name	Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering

Conference

Conference	Proceedings of the 1993 IEEE Region 10 Conference on Computer, Communication, Control and Power Engineering (TENCON '93). Part 1 (of 5)
City	Beijing, China
Period	19/10/93 → 21/10/93

Cite this

Horng, J. T., Chen, G. D., & Liu, B. J. (1993). Extension of SQL to capture more information from objects with many-many relationship. In Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering (pp. 356-359). (Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering). Publ by IEEE.

Horng, Jorng Tzong ; Chen, Gwo Dong ; Liu, Baw Jhiune. / Extension of SQL to capture more information from objects with many-many relationship. Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering. Publ by IEEE, 1993. pp. 356-359 (Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering).

@inproceedings{58020e103ea344169a3ad8fbb19f3003,

title = "Extension of SQL to capture more information from objects with many-many relationship",

abstract = "Many decision support applications such as task assignment, truck deliveries, airline screw scheduling problems usually need to get information from objects with many-many relationship. However, current relational operators including the complete set of relational algebra and other relational operators are difficult to get required information from objects with many-many relationship. In this paper, we extend SQL so that users can capture more information from objects with many-many relationship by using the query language directly. The relational operators were extended with six operators, namely, match, maxmatch, cover, mincover, partition, and minpartition.",

author = "Horng, {Jorng Tzong} and Chen, {Gwo Dong} and Liu, {Baw Jhiune}",

year = "1993",

language = "???core.languages.en_GB???",

isbn = "0780312333",

series = "Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering",

publisher = "Publ by IEEE",

pages = "356--359",

booktitle = "Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering",

note = "null ; Conference date: 19-10-1993 Through 21-10-1993",

}

Horng, JT , Chen, GD & Liu, BJ 1993, Extension of SQL to capture more information from objects with many-many relationship. in Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering. Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering, Publ by IEEE, pp. 356-359, Proceedings of the 1993 IEEE Region 10 Conference on Computer, Communication, Control and Power Engineering (TENCON '93). Part 1 (of 5), Beijing, China, 19/10/93.

Extension of SQL to capture more information from objects with many-many relationship. / Horng, Jorng Tzong ; Chen, Gwo Dong; Liu, Baw Jhiune.

Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering. Publ by IEEE, 1993. p. 356-359 (Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - Extension of SQL to capture more information from objects with many-many relationship

AU - Horng, Jorng Tzong

AU - Chen, Gwo Dong

AU - Liu, Baw Jhiune

PY - 1993

Y1 - 1993

N2 - Many decision support applications such as task assignment, truck deliveries, airline screw scheduling problems usually need to get information from objects with many-many relationship. However, current relational operators including the complete set of relational algebra and other relational operators are difficult to get required information from objects with many-many relationship. In this paper, we extend SQL so that users can capture more information from objects with many-many relationship by using the query language directly. The relational operators were extended with six operators, namely, match, maxmatch, cover, mincover, partition, and minpartition.

AB - Many decision support applications such as task assignment, truck deliveries, airline screw scheduling problems usually need to get information from objects with many-many relationship. However, current relational operators including the complete set of relational algebra and other relational operators are difficult to get required information from objects with many-many relationship. In this paper, we extend SQL so that users can capture more information from objects with many-many relationship by using the query language directly. The relational operators were extended with six operators, namely, match, maxmatch, cover, mincover, partition, and minpartition.

UR - http://www.scopus.com/inward/record.url?scp=0027813217&partnerID=8YFLogxK

M3 - 會議論文篇章

AN - SCOPUS:0027813217

SN - 0780312333

T3 - Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering

SP - 356

EP - 359

BT - Proceedings of the 10th IEEE Region Conference on Computer, Communication, Control and Power Engineering

PB - Publ by IEEE

Y2 - 19 October 1993 through 21 October 1993

ER -

Extension of SQL to capture more information from objects with many-many relationship

Abstract

Publication series

Conference

Fingerprint

Cite this