《数据库系统基本概念教学》appc.pptVIP

Appendix C: Other Relational Languages Appendix C: Other Relational Languages Query-by-Example (QBE) Access Datalog Query-by-Example (QBE) Basic Structure Queries on One Relation Queries on Several Relations The Condition Box The Result Relation Ordering the Display of Tuples Aggregate Operations Modification of the Database QBE — Basic Structure A graphical query language which is based (roughly) on the domain relational calculus Two dimensional syntax – system creates templates of relations that are requested by users Queries are expressed “by example” QBE Skeleton Tables (Cont.) Queries