公开(公告)号：US20030065659A1

公开(公告)日：2003-04-03

申请号：US10260384

申请日：2002-09-27

申请人： ORACLE CORPORATION

发明人： Nipun Agarwal ,  Eric Sedlar ,  Ravi Murthy ,  Namit Jain

IPC分类号： G06F007/00

CPC分类号： G06F17/30595 ,  G06F17/30917 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945

摘要： A hierarchy may be explicitly or implicitly reflected in existing data maintained external to hierarchy structures. Such hierarchies are referred to herein as a nullpre-existing hierarchiesnull. Techniques are described herein for capturing a pre-existing hierarchy in hierarchy structures. After a pre-existing hierarchy has been captured, there exist two independent sets of data that reflect the hierarchy: the external hierarchy definition and the internal hierarchy definition. Changing either hierarchy definition changes the hierarchy. Therefore, to maintain a consistent reflection of the hierarchy, the internal hierarchy definition must be modified in response to changes made to the external hierarchy definition, and the external hierarchy definition must be modified in response to changes made to the internal hierarchy definition. Various techniques are described for maintaining consistency between the two hierarchy definitions.

摘要翻译： 层次结构可以在层次结构外部维护的现有数据中显式或隐式地反映出来。 这样的层次结构在本文中称为“预先存在的层级”。 这里描述了用于在层次结构中捕获预先存在的层次结构的技术。 在捕获了一个预先存在的层次结构之后，存在反映层次结构的两个独立的数据集：外部层次结构定义和内部层次结构定义。 更改层次结构定义会更改层次结构。 因此，为了保持层次结构的一致反映，必须根据对外部层次结构定义所做的更改来修改内部层次结构定义，并且必须根据对内部层次结构定义的更改来修改外部层次结构定义。 描述了用于维持两个层次结构定义之间的一致性的各种技术。

公开(公告)号：US20020184253A1

公开(公告)日：2002-12-05

申请号：US09872670

申请日：2001-05-31

申请人： Oracle Corporation

发明人： Nipun Agarwal ,  Ravi Murthy

IPC分类号： G06F007/00

CPC分类号： G06F17/30445 ,  Y10S707/99932 ,  Y10S707/99936 ,  Y10S707/99937

摘要： A method and mechanism to improve the response time of a query that is executed against a partitioned database object. Only a subset or portion of the partitions are accessed during each pass through the partitions, in which only the retrieved portions of the partitions are processed, and in which results can be immediately returned for the query. Processing only a subset of a partition in a given pass permits each partition to be processed multiple times, rather than requiring a first partition to be entirely processed before processing a second partition. In one approach, the query includes a statement to order the result set for a query against a partitioned database object that contains a local index.

摘要翻译： 一种改进针对分区数据库对象执行的查询的响应时间的方法和机制。 在每次通过分区期间只访问分区的子集或部分，其中仅处理所检索的分区的部分，并且可以立即为查询返回哪些结果。 在给定通过中仅处理分区的子集允许每个分区被多次处理，而不是要求在处理第二个分区之前完全处理第一个分区。 在一种方法中，查询包括一个语句，用于针对包含本地索引的分区数据库对象对查询的结果集进行排序。