Outer quantifiers in object-oriented queries and views of database
systems
    5.
    发明授权
    Outer quantifiers in object-oriented queries and views of database systems 失效
    面向对象查询中的外部量词和数据库系统的视图

    公开(公告)号:US5774692A

    公开(公告)日:1998-06-30

    申请号:US539662

    申请日:1995-10-05

    IPC分类号: G06F17/30

    摘要: The system, method, and program of this invention provides for a new type of quantifier that is useful for object-oriented queries that reference collections and nested collections of objects. The invention is applicable to any other type of database where the data has a hierarchical relationship, also. This new type of quantifier is called an outer quantifier. The outer quantifier appears in the language of the query (in the FROM clause) and creates a new runtime semantic. The function and semantics provided by outer quantifiers is similar to that provided partly by left outer joins in relational systems. Outer quantifiers are bound to a null instance if the collection over which they are defined is empty. Outer quantifiers are a simple way of expressing queries so that objects having empty collections of nested objects are included in the result, also.

    摘要翻译: 本发明的系统,方法和程序提供了一种新类型的量词,其对于引用对象的集合和嵌套集合的面向对象的查询是有用的。 本发明也适用于数据具有层次关系的任何其他类型的数据库。 这种新型的量词被称为外部量词。 外部量词器以查询的语言(在FROM子句中)显示,并创建一个新的运行时语义。 外部量词提供的功能和语义与部分由关系系统中的左外连接提供的功能和语义相似。 如果定义它们的集合为空,则外部量词被绑定到一个空实例。 外部量词是表达查询的一种简单方式,也可以在结果中包含具有空集合的嵌套对象的对象。

    USING VIEWTYPES FOR ACCESSING INSTANCE DATA STRUCTURED BY A BASE MODEL
    6.
    发明申请
    USING VIEWTYPES FOR ACCESSING INSTANCE DATA STRUCTURED BY A BASE MODEL 失效
    使用VIEWTYPES来访问由基本模型构成的实时数据

    公开(公告)号:US20090012993A1

    公开(公告)日:2009-01-08

    申请号:US12167177

    申请日:2008-07-02

    IPC分类号: G06F17/30

    摘要: Disclosed is a technique for manipulating instance data of a base model. A ViewType, a root object representing an object of the base model, and an operation are received. Whether the ViewType and the root object are compatible is determined. When the ViewType and the root object are compatible, the operation is applied to the instance data of the base model while using the ViewType to traverse the instance data.

    摘要翻译: 公开了一种用于操纵基本模型的实例数据的技术。 接收ViewType,表示基本模型的对象的根对象和操作。 确定ViewType和根对象是否兼容。 当ViewType和根对象兼容时,将使用ViewType遍历实例数据,将该操作应用于基本模型的实例数据。

    Optional quantifiers in relational and object-oriented views of database
systems
    8.
    发明授权
    Optional quantifiers in relational and object-oriented views of database systems 失效
    数据库系统的关系和面向对象视图中的可选量词

    公开(公告)号:US5797136A

    公开(公告)日:1998-08-18

    申请号:US539561

    申请日:1995-10-05

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 系统,方法和程序使关系数据库和面向对象数据库的数据库管理系统能够将查询中的量词识别为可选。 可选择的量词将根据某些条件参与查询。 如果视图中投射出的依赖于量词的列(或对象)不被查询使用,则从视图的定义中删除量词。 仅使用与可选量词相关联的视图中的关系来处理查询。 返回的结果就好像执行了重复删除的左外连接操作,尽管查询的实际处理与左外连接操作无关,即不涉及。 如果视图中投射出的依赖于量词的列(或对象)由查询使用,则可选量词保留在视图的定义中,并使用连接操作处理查询。