33:
359:
Here E is a tuple variable that ranges over the EMPLOYEE relation, and all tuples in that relation are found which satisfy the qualification `E.Name = "Jones"`. The result of the query is a new relation W, which has a single domain COMP that has been calculated for each qualifying tuple. Additional
255:
gained market share in the early 1980s, most companies then supporting QUEL moved to SQL instead. QUEL continues to be available as a part of the Ingres DBMS, although no QUEL-specific language enhancements have been added for many years.
461:
Here is a sample of a simple session that creates a table, inserts a row into it, and then retrieves and modifies the data inside it and finally deletes the row that was added (assuming that name is a unique field).
457:
In this example, the relation is being stored in a new table W. This is not a direct analog of the QUEL version; relations in QUEL are more similar to temporary tables seen in most modern SQL implementations.
1085:
reverses the process. Similar commands are available in many SQL systems, but usually as external tools, as opposed to being internal to the SQL language. This makes them unavailable to
1092:
QUEL has an extremely powerful aggregation capability. Aggregates can be nested, and different aggregates can have independent by-lists and/or restriction clauses. For example:
1584:
243:. QUEL was used for a short time in most products based on the freely available Ingres source code, most notably in an implementation called POSTQUEL supported by
1378:
1077:
which creates a comma-delimited file of all the records in the student table. The d1 indicates a delimiter, as opposed to a data type. Changing the
1350:
1219:
This example illustrates one of the arguably less desirable quirks of QUEL, namely that all string comparisons are potentially pattern matches.
1486:
1451:
50:
1569:
268:, which can be used to limit queries or return result sets. Consider this example, taken from one of the first original Ingres papers:
176:
230:
116:
97:
69:
959:
Another feature of QUEL was a built-in system for moving records en-masse into and out of the system. Consider this command:
54:
76:
1371:
1466:
1406:
238:
196:
83:
1476:
43:
1532:
1456:
1421:
1411:
1248:
215:
65:
1574:
1461:
1441:
1364:
1416:
1426:
1318:
1527:
1511:
1471:
1292:
1579:
1323:
1306:
1279:
1259:
208:
150:
90:
1254:
1309:; Wong, Eugene; Kreps, Peter; Held, Gerald (1976). "The Design and Implementation of INGRES".
223:
183:
1328:
1086:
248:
145:
1387:
211:
138:
1563:
234:
1283:
32:
1332:
244:
17:
1548:
1436:
1431:
252:
1501:
1491:
1506:
1356:
1446:
226:
1360:
1496:
1401:
219:
26:
1541:
1520:
1394:
1236:
1232:
1228:
1224:
1220:
1082:
1078:
190:
174:
156:
144:
134:
57:. Unsourced material may be challenged and removed.
360:queries can then be made against the relation W.
1372:
8:
129:
1239:is used when pattern matching is required.
1379:
1365:
1357:
128:
1322:
237:'s earlier suggested but not implemented
117:Learn how and when to remove this message
464:
1351:A Critique of the SQL Database Language
1271:
1585:Relational database management systems
1295:on Management of Data. Washington, DC.
264:QUEL statements are always defined by
7:
1311:ACM Transactions on Database Systems
55:adding citations to reliable sources
222:. It was created as a part of the
1353:. SIGMOD Record 14(3): 8-54, 1984.
231:University of California, Berkeley
25:
363:An equivalent SQL statement is:
31:
42:needs additional citations for
1235:only for exact matches, while
1:
218:, with some similarities to
1570:Database management systems
162:; 48 years ago
1601:
1249:D4 (programming language)
216:tuple relational calculus
195:
182:
1251:(an implementation of D)
1231:. In contrast, SQL uses
1094:
1072:"/student.txt"
961:
725:
476:
365:
270:
1282:; Rowe, LA (May 1986).
1221:y.str = "ii*"
240:Data Sub-Language ALPHA
1285:The design of POSTGRES
66:"QUEL query languages"
1333:10.1145/320473.320476
1293:ACM SIGMOD Conference
1227:values starting with
1307:Stonebraker, Michael
51:improve this article
1260:Relational calculus
209:relational database
157:First appeared
151:Michael Stonebraker
131:
1255:Relational algebra
719:"philip"
569:"philip"
1557:
1556:
1087:stored procedures
957:
956:
354:"Jones"
202:
201:
127:
126:
119:
101:
16:(Redirected from
1592:
1381:
1374:
1367:
1358:
1337:
1336:
1326:
1303:
1297:
1296:
1290:
1276:
1238:
1234:
1230:
1226:
1222:
1215:
1212:
1209:
1206:
1203:
1200:
1197:
1194:
1191:
1188:
1185:
1182:
1179:
1176:
1173:
1170:
1167:
1164:
1161:
1158:
1155:
1152:
1149:
1146:
1143:
1140:
1137:
1134:
1131:
1128:
1125:
1122:
1119:
1116:
1113:
1110:
1107:
1104:
1101:
1098:
1084:
1080:
1073:
1070:
1067:
1064:
1061:
1058:
1055:
1052:
1049:
1046:
1043:
1040:
1037:
1034:
1031:
1028:
1025:
1022:
1019:
1016:
1013:
1010:
1007:
1004:
1001:
998:
995:
992:
989:
986:
983:
980:
977:
974:
971:
968:
965:
951:
948:
947:'philip'
945:
942:
939:
936:
933:
930:
927:
924:
921:
918:
915:
912:
909:
906:
903:
900:
897:
894:
891:
888:
885:
882:
879:
876:
873:
870:
867:
864:
861:
858:
855:
852:
849:
846:
843:
840:
837:
836:'philip'
834:
831:
828:
825:
822:
819:
816:
813:
810:
807:
804:
801:
798:
795:
792:
789:
786:
783:
780:
777:
774:
771:
768:
765:
762:
759:
756:
753:
750:
747:
744:
741:
738:
735:
732:
729:
720:
717:
714:
711:
708:
705:
702:
699:
696:
693:
690:
687:
684:
681:
678:
675:
672:
669:
666:
663:
660:
657:
654:
651:
648:
645:
642:
639:
636:
633:
630:
627:
624:
621:
618:
615:
612:
609:
606:
603:
600:
597:
594:
591:
588:
585:
582:
579:
576:
573:
570:
567:
564:
561:
558:
555:
552:
549:
546:
543:
540:
537:
534:
531:
528:
525:
522:
519:
516:
513:
510:
507:
504:
501:
498:
495:
492:
489:
486:
483:
480:
465:
453:
450:
447:
444:
441:
438:
435:
432:
429:
426:
423:
420:
417:
414:
411:
408:
405:
402:
399:
396:
393:
390:
387:
384:
381:
378:
375:
372:
369:
355:
352:
349:
346:
343:
340:
337:
334:
331:
328:
325:
322:
319:
316:
313:
310:
307:
304:
301:
298:
295:
292:
289:
286:
283:
280:
277:
274:
170:
168:
163:
146:Designed by
132:
122:
115:
111:
108:
102:
100:
59:
35:
27:
21:
1600:
1599:
1595:
1594:
1593:
1591:
1590:
1589:
1575:Query languages
1560:
1559:
1558:
1553:
1537:
1516:
1390:
1388:Query languages
1385:
1346:
1344:Further reading
1341:
1340:
1305:
1304:
1300:
1288:
1278:
1277:
1273:
1268:
1245:
1217:
1216:
1213:
1210:
1207:
1204:
1201:
1198:
1195:
1192:
1189:
1186:
1183:
1180:
1177:
1174:
1171:
1169:"foo"
1168:
1165:
1162:
1159:
1156:
1153:
1151:"ii*"
1150:
1147:
1144:
1141:
1138:
1135:
1132:
1129:
1126:
1123:
1120:
1117:
1114:
1111:
1108:
1105:
1102:
1099:
1096:
1075:
1074:
1071:
1068:
1065:
1062:
1059:
1056:
1053:
1050:
1047:
1044:
1041:
1038:
1035:
1032:
1029:
1026:
1023:
1020:
1017:
1014:
1011:
1008:
1005:
1002:
999:
996:
993:
990:
987:
984:
981:
978:
975:
972:
969:
966:
963:
953:
952:
949:
946:
943:
940:
937:
934:
931:
928:
925:
922:
919:
916:
913:
910:
907:
904:
901:
898:
895:
892:
889:
886:
883:
880:
877:
874:
871:
868:
865:
862:
859:
856:
853:
850:
847:
844:
841:
838:
835:
832:
829:
826:
823:
820:
817:
814:
811:
808:
805:
802:
799:
796:
793:
790:
787:
784:
781:
778:
775:
772:
769:
766:
763:
760:
757:
754:
751:
748:
745:
742:
739:
736:
733:
730:
727:
722:
721:
718:
715:
712:
709:
706:
703:
700:
697:
694:
691:
688:
685:
682:
679:
676:
673:
670:
667:
664:
661:
658:
655:
652:
649:
646:
643:
640:
637:
634:
631:
628:
625:
622:
619:
616:
613:
610:
607:
604:
601:
598:
595:
592:
589:
586:
583:
580:
577:
574:
571:
568:
565:
562:
559:
556:
553:
550:
547:
544:
541:
538:
535:
532:
529:
526:
523:
520:
517:
514:
511:
508:
505:
502:
499:
496:
493:
490:
487:
484:
481:
478:
455:
454:
452:'Jones'
451:
448:
445:
442:
439:
436:
433:
430:
427:
424:
421:
418:
415:
412:
409:
406:
403:
400:
397:
394:
391:
388:
385:
382:
379:
376:
373:
370:
367:
357:
356:
353:
350:
347:
344:
341:
338:
335:
332:
329:
326:
323:
320:
317:
314:
311:
308:
305:
302:
299:
296:
293:
290:
287:
284:
281:
278:
275:
272:
266:tuple variables
262:
177:implementations
166:
164:
161:
123:
112:
106:
103:
60:
58:
48:
36:
23:
22:
15:
12:
11:
5:
1598:
1596:
1588:
1587:
1582:
1577:
1572:
1562:
1561:
1555:
1554:
1552:
1551:
1545:
1543:
1539:
1538:
1536:
1535:
1530:
1524:
1522:
1518:
1517:
1515:
1514:
1509:
1504:
1499:
1494:
1489:
1484:
1479:
1474:
1469:
1464:
1459:
1454:
1449:
1444:
1439:
1434:
1429:
1424:
1419:
1414:
1409:
1404:
1398:
1396:
1395:In current use
1392:
1391:
1386:
1384:
1383:
1376:
1369:
1361:
1355:
1354:
1345:
1342:
1339:
1338:
1324:10.1.1.109.957
1298:
1280:Stonebraker, M
1270:
1269:
1267:
1264:
1263:
1262:
1257:
1252:
1244:
1241:
1095:
962:
955:
954:
726:
723:
644:"FL"
605:"FL"
477:
473:
472:
469:
366:
271:
261:
258:
212:query language
200:
199:
193:
192:
188:
187:
180:
179:
172:
171:
158:
154:
153:
148:
142:
141:
139:Query language
136:
125:
124:
39:
37:
30:
24:
14:
13:
10:
9:
6:
4:
3:
2:
1597:
1586:
1583:
1581:
1578:
1576:
1573:
1571:
1568:
1567:
1565:
1550:
1547:
1546:
1544:
1540:
1534:
1531:
1529:
1526:
1525:
1523:
1519:
1513:
1510:
1508:
1505:
1503:
1500:
1498:
1495:
1493:
1490:
1488:
1485:
1483:
1480:
1478:
1475:
1473:
1470:
1468:
1465:
1463:
1460:
1458:
1455:
1453:
1450:
1448:
1445:
1443:
1440:
1438:
1435:
1433:
1430:
1428:
1425:
1423:
1420:
1418:
1415:
1413:
1410:
1408:
1405:
1403:
1400:
1399:
1397:
1393:
1389:
1382:
1377:
1375:
1370:
1368:
1363:
1362:
1359:
1352:
1348:
1347:
1343:
1334:
1330:
1325:
1320:
1316:
1312:
1308:
1302:
1299:
1294:
1291:. Proc. 1986
1287:
1286:
1281:
1275:
1272:
1265:
1261:
1258:
1256:
1253:
1250:
1247:
1246:
1242:
1240:
1093:
1090:
1088:
960:
724:
593:"m"
475:
474:
470:
467:
466:
463:
459:
364:
361:
269:
267:
259:
257:
254:
250:
246:
242:
241:
236:
232:
228:
225:
221:
217:
213:
210:
206:
198:
194:
191:Influenced by
189:
185:
181:
178:
173:
159:
155:
152:
149:
147:
143:
140:
137:
133:
121:
118:
110:
107:November 2013
99:
96:
92:
89:
85:
82:
78:
75:
71:
68: –
67:
63:
62:Find sources:
56:
52:
46:
45:
40:This article
38:
34:
29:
28:
19:
1481:
1349:C. J. Date:
1314:
1310:
1301:
1284:
1274:
1223:matches all
1218:
1091:
1076:
958:
881:'FL'
854:'FL'
460:
456:
362:
358:
265:
263:
239:
204:
203:
113:
104:
94:
87:
80:
73:
61:
49:Please help
44:verification
41:
1521:Proprietary
848:'m'
233:, based on
214:, based on
1580:PostgreSQL
1564:Categories
1542:Superseded
1317:(3): 191.
1266:References
229:effort at
186:, POSTQUEL
77:newspapers
1319:CiteSeerX
1243:See also
1097:retrieve
680:retrieve
611:retrieve
428:employee
288:retrieve
285:EMPLOYEE
245:POSTGRES
18:PostQUEL
1549:CODASYL
1442:Gremlin
1437:GraphQL
1432:Datalog
1045:address
967:student
935:student
923:student
890:student
869:student
800:student
734:student
647:replace
548:student
482:student
165: (
91:scholar
1502:XQuery
1492:SPARQL
1487:SMARTS
1417:Cypher
1321:
929:delete
914:select
887:update
860:select
830:values
794:insert
728:create
698:delete
551:append
479:create
392:salary
380:select
368:create
312:Salary
249:Oracle
224:Ingres
184:Ingres
175:Major
135:Family
93:
86:
79:
72:
64:
1507:XPath
1407:ALPHA
1289:(PDF)
1225:y.str
1187:count
1136:where
1109:count
1081:to a
1033:comma
1009:comma
985:comma
938:where
875:state
872:where
824:state
779:state
731:table
704:where
638:state
629:where
599:state
536:range
524:state
437:where
371:table
339:where
273:range
260:Usage
247:. As
207:is a
197:Alpha
98:JSTOR
84:books
1533:LINQ
1482:QUEL
1457:LINQ
1452:LDAP
1447:ISBL
1237:like
1083:from
1079:into
1069:into
973:name
964:copy
941:name
932:from
920:from
866:from
806:name
797:into
782:char
767:char
743:char
740:name
713:name
563:name
488:name
471:SQL
468:QUEL
446:name
425:from
422:COMP
348:Name
300:COMP
291:into
251:and
235:Codd
227:DBMS
205:QUEL
167:1976
160:1976
130:QUEL
70:news
1528:YQL
1512:YQL
1497:SQL
1477:OCL
1472:OQL
1467:MDX
1462:MQL
1427:DMX
1422:DAX
1412:CQL
1402:.QL
1329:doi
1214:)))
1181:max
1163:str
1145:str
1021:sex
997:age
902:age
896:age
893:set
818:sex
812:age
791:));
764:sex
758:int
755:age
692:all
668:age
656:age
623:all
587:sex
575:age
512:sex
500:age
494:c10
407:age
327:Age
253:DB2
220:SQL
53:by
1566::
1327:.
1313:.
1229:ii
1202:by
1172:),
1154:or
1124:by
1089:.
1063:d1
1057:nl
1051:c0
1039:d1
1027:c0
1015:d1
1003:c0
991:d1
979:c0
857:);
842:17
776:),
752:),
749:10
581:17
554:to
545:is
539:of
530:c2
518:c1
506:i4
431:as
419:as
416:))
413:18
377:as
336:))
333:18
282:is
276:of
1380:e
1373:t
1366:v
1335:.
1331::
1315:1
1233:=
1211:d
1208:.
1205:y
1199:i
1196:.
1193:y
1190:(
1184:(
1178:=
1175:b
1166:=
1160:.
1157:y
1148:=
1142:.
1139:y
1133:d
1130:.
1127:y
1121:i
1118:.
1115:y
1112:(
1106:=
1103:a
1100:(
1066:)
1060:=
1054:,
1048:=
1042:,
1036:=
1030:,
1024:=
1018:,
1012:=
1006:,
1000:=
994:,
988:=
982:,
976:=
970:(
950:;
944:=
926:;
917:*
911:;
908:1
905:+
899:=
884:;
878:=
863:*
851:,
845:,
839:,
833:(
827:)
821:,
815:,
809:,
803:(
788:2
785:(
773:1
770:(
761:,
746:(
737:(
716:=
710:.
707:s
701:s
695:)
689:.
686:s
683:(
677:)
674:1
671:+
665:.
662:s
659:=
653:(
650:s
641:=
635:.
632:s
626:)
620:.
617:s
614:(
608:)
602:=
596:,
590:=
584:,
578:=
572:,
566:=
560:(
557:s
542:s
533:)
527:=
521:,
515:=
509:,
503:=
497:,
491:=
485:(
449:=
443:.
440:E
434:E
410:-
404:.
401:E
398:(
395:/
389:.
386:E
383:(
374:W
351:=
345:.
342:E
330:-
324:.
321:E
318:(
315:/
309:.
306:E
303:=
297:(
294:W
279:E
169:)
120:)
114:(
109:)
105:(
95:·
88:·
81:·
74:·
47:.
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.