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

Author

Jorng-Tzong Horng ; Gwo-Dong Chen ; Baw-Jhiune Liu

Author_Institution

Dept. of Comput. Sci. & Inf. Eng., Nat. Taiwan Univ., Taipei, Taiwan

Volume

1

fYear

1993

fDate

19-21 Oct. 1993

Firstpage

356

Abstract

Many decision support applications such as task assignment, truck deliveries, airline crew scheduling problems usually need to get information from objects with many-many relationship. However, with current relational operators including the complete set of relational algebra it is difficult to get required information from objects with a many-many relationship. We extend SQL so that users can capture more information from objects with a 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.<>

Keywords

SQL; data structures; database management systems; relational algebra; SQL; airline crew scheduling; cover; decision support applications; many-many relationship; match; maxmatch; mincover; minpartition; partition; relational algebra; relational operators; task assignment; truck deliveries; Algebra; Application software; Computer science; Costs; Councils; Database languages; Fasteners; Job shop scheduling; Power system modeling; Programming profession;

fLanguage

English

Publisher

ieee

Conference_Titel

TENCON '93. Proceedings. Computer, Communication, Control and Power Engineering.1993 IEEE Region 10 Conference on

Conference_Location

Beijing, China

Print_ISBN

0-7803-1233-3

Type

conf

DOI

10.1109/TENCON.1993.320001

Filename

320001