Optional quantifiers in relational and object-oriented views of database
systems
    1.
    发明授权
    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.

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

    Outer quantifiers in object-oriented queries and views of database
systems
    2.
    发明授权
    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子句中)显示,并创建一个新的运行时语义。 外部量词提供的功能和语义与部分由关系系统中的左外连接提供的功能和语义相似。 如果定义它们的集合为空,则外部量词被绑定到一个空实例。 外部量词是表达查询的一种简单方式,也可以在结果中包含具有空集合的嵌套对象的对象。

    Database method and apparatus for interactively retrieving data members
and related members from a collection of data
    3.
    发明授权
    Database method and apparatus for interactively retrieving data members and related members from a collection of data 失效
    用于从数据集合中交互地检索数据成员和相关成员的数据库方法和装置

    公开(公告)号:US5778355A

    公开(公告)日:1998-07-07

    申请号:US664212

    申请日:1996-06-11

    IPC分类号: G06F17/30

    摘要: A method of, and system for, interactively accessing information in response to a user command having a predefined operator and specifying one of a plurality of collections of information. The collections of information are stored in an object-oriented database in a hierarchical arrangement of data members. The hierarchical arrangement can include one level of data members and in which one of the data members is composed of a next level of data members. Each data member is stored according to one of a system-specified and a user-specified storage definition. A set of user-specified storage definitions is defined from the plurality of storage definitions. Upon detecting the user command, the specified collection of information is analyzed to determine which data members of the one level are stored according to one of the storage definitions of the set. Each data member not in the set is added to a projection list; each data member in the set is expanded into a next level of data members composing the data member in the set. Expanding can include analyzing each data member of the next level to determine whether it is in the set and if so again expanding up until a specified level of expanding. The projection list is processed to return to the user the information corresponding to the data members in the projection list. The invention may be implemented in a Parser layer of a known layered architecture for database systems.

    摘要翻译: 响应于具有预定义操作符的用户命令并指定多个信息集合之一来交互地访问信息的方法和系统。 信息集合以数据成员的分层布置存储在面向对象的数据库中。 分层布置可以包括一级数据成员,并且其中一个数据成员由下一级数据成员组成。 每个数据成员根据系统指定的和用户指定的存储定义之一进行存储。 从多个存储定义中定义一组用户指定的存储定义。 在检测到用户命令时,分析指定的信息集合以根据集合的存储定义之一来确定存储一个级别的哪些数据成员。 不在集合中的每个数据成员都添加到投影列表中; 集合中的每个数据成员被扩展成组成组中的数据成员的下一级数据成员。 扩展可以包括分析下一级别的每个数据成员以确定它是否在集合中,如果再次扩展,直到指定级别的扩展。 处理投影列表以向用户返回与投影列表中的数据成员相对应的信息。 本发明可以在用于数据库系统的已知分层架构的解析器层中实现。

    USING VIEWTYPES FOR ACCESSING INSTANCE DATA STRUCTURED BY A BASE MODEL
    4.
    发明申请
    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遍历实例数据,将该操作应用于基本模型的实例数据。