首页>
外国专利>
Optional quantifiers in relational and object-oriented views of database systems
Optional quantifiers in relational and object-oriented views of database systems
展开▼
机译:数据库系统的关系和面向对象视图中的可选量词
展开▼
页面导航
摘要
著录项
相似文献
摘要
A system, method, and program enables database management systems for relational and object-oriented databases to recognize a quantifier in a query as being designated as optional. An optional quantifier will participate in a query depending upon certain conditions. If the columns (or objects) projected out in the view that are dependent upon the quantifier are not used by the query, the quantifier is dropped from the definition of the view. The query is processed using only the relations in the view not associated with the optional quantifier. The results returned are as if a left outer join operation with duplicate elimination had been performed, although the actual processing of the query was independent of, i.e., did not involve, a left outer join operation. If the columns (or objects) projected out in the view that are dependent upon the quantifier are used by the query, the optional quantifier remains in the definition of the view and the query is processed using a join operation.
展开▼