公开(公告)号：US20130013617A1

公开(公告)日：2013-01-10

申请号：US13177606

申请日：2011-07-07

申请人： Mengchu Cai ,  Stephen Yao Ching Chen ,  Ruiping Li ,  Wei Li ,  Robert W. Lyle

发明人： Mengchu Cai ,  Stephen Yao Ching Chen ,  Ruiping Li ,  Wei Li ,  Robert W. Lyle

IPC分类号： G06F17/30

CPC分类号： G06F17/30336

摘要： Techniques are described for processing a query to produce query results, the query specifying at least a first timestamp value. Embodiments receive the query for processing and access a database index containing a plurality of database keys. The database index contains one or more database index keys, each of which includes at least a timestamp value and a time zone value. Embodiments compare the first timestamp value specified in the query with a portion of one the database index keys to locate at least a portion of the query results. More specifically, the compared portion of the database index key excludes the time zone value. The located portion of the query results is then retrieved.

摘要翻译： 描述了用于处理查询以产生查询结果的技术，所述查询指定至少第一时间戳值。 实施例接收用于处理和访问包含多个数据库密钥的数据库索引的查询。 数据库索引包含一个或多个数据库索引关键字，每个索引关键字至少包含时间戳值和时区值。 实施例将查询中指定的第一个时间戳值与数据库索引键的一部分进行比较，以查找查询结果的至少一部分。 更具体地，数据库索引关键字的比较部分排除时区值。 然后检索查询结果的位置部分。

公开(公告)号：US06446063B1

公开(公告)日：2002-09-03

申请号：US09340352

申请日：1999-06-25

申请人： Stephen Yao Ching Chen ,  Peter Hoa ,  William Y. Kyu ,  Fen-Ling Lin ,  Desai Paramesh Sampatrai ,  Yun Wang

发明人： Stephen Yao Ching Chen ,  Peter Hoa ,  William Y. Kyu ,  Fen-Ling Lin ,  Desai Paramesh Sampatrai ,  Yun Wang

IPC分类号： G06F1730

CPC分类号： G06F17/30498 ,  G06F17/30466 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934

摘要： Disclosed is a system, method, and program for performing a join operation on a multi-column table and at least two satellite tables having a join condition. Each satellite table is comprised of multiple rows and at least one join column. Each multi-column table is comprised of multiple rows and at least one column corresponding to the join column in each satellite table. A join operation is performed on the rows of the satellite tables to generate a first join result comprising concatenations of the rows of the satellite tables. Less than all the concatenated rows in the first join result that satisfy the join condition are then selected. The selected concatenated rows in the first join result are then joined to the multi-column table.

摘要翻译： 公开了一种用于在多列表和至少两个具有连接条件的卫星表中执行加入操作的系统，方法和程序。 每个卫星表由多行和至少一个连接列组成。 每个多列表由多行和至少一列对应于每个卫星表中的连接列组成。 对卫星表的行执行加入操作以生成包括卫星表的行的级联的第一连接结果。 然后选择小于满足连接条件的第一个连接结果中的所有连接行。 第一个连接结果中选定的并置行然后连接到多列表。

公开(公告)号：US06374235B1

公开(公告)日：2002-04-16

申请号：US09344731

申请日：1999-06-25

申请人： Stephen Yao Ching Chen ,  Patrick Michael Malone ,  Jerry Mukai ,  Jeffrey Ralph Ruggles ,  Desai Paramesh Sampatrai ,  Yun Wang ,  Guogen Zhang

发明人： Stephen Yao Ching Chen ,  Patrick Michael Malone ,  Jerry Mukai ,  Jeffrey Ralph Ruggles ,  Desai Paramesh Sampatrai ,  Yun Wang ,  Guogen Zhang

IPC分类号： G06F1730

CPC分类号： G06F17/30466 ,  G06F17/30498 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934

摘要： Disclosed is a method, system, and program for performing a join operation on a multi-column table and at least two satellite tables having a join condition. Each satellite table is comprised of multiple rows and at least one join column. The multi-column table is comprised of multiple rows and at least one column corresponding to the join column in each satellite table. A join operation is performed on the rows of the satellite tables to generate concatenated rows of the satellite tables. One of the concatenated rows is joined to the multi-column table and a returned entry from the multi-column table is received. A determination is then made as to whether the returned entry matches the search criteria. If so, a determination is made as to whether one of the satellite tables has duplicates of values in the join column of the returned matching entry or the multi-column table has duplicate entries in the join columns. Returned matching entries are generated for each duplicate value in the satellite tables and duplicate entry in the multi-column table.

摘要翻译： 公开了一种用于在多列表和至少两个具有连接条件的卫星表上执行加入操作的方法，系统和程序。 每个卫星表由多行和至少一个连接列组成。 多列表由多行和至少一列对应于每个卫星表中的连接列组成。 对卫星表的行执行加入操作，以生成卫星表的级联行。 其中一个连接的行被连接到多列表，并且从多列表中返回的条目被接收。 然后确定返回的条目是否与搜索条件匹配。 如果是，则确定卫星表中的一个是否具有在返回的匹配条目的连接列中的值的重复，或者多列表在连接列中具有重复条目。 为卫星表中的每个重复值和多列表中的重复条目生成返回的匹配条目。

公开(公告)号：US20120197919A1

公开(公告)日：2012-08-02

申请号：US13016010

申请日：2011-01-28

申请人： Stephen Yao Ching Chen ,  Curt L. Cotner ,  Gerald G. Kiernan ,  Irene Ching-Hua Liu ,  Claire W. McFeely ,  Walid Rjaibi ,  Timothy J. Vincent

发明人： Stephen Yao Ching Chen ,  Curt L. Cotner ,  Gerald G. Kiernan ,  Irene Ching-Hua Liu ,  Claire W. McFeely ,  Walid Rjaibi ,  Timothy J. Vincent

IPC分类号： G06F17/30

CPC分类号： G06F17/30315 ,  G06F17/30

摘要： Access to a data element stored within a database object is controlled. A request is received from a user to perform an operation in relation to the database object, the operation including retrieval of information from the data element of the database object. Prior to retrieving information from the data element, a determination is made whether at least a portion of the information from the data element is subject to masking in accordance with an access policy. In response to determining that information from the data element is subject to masking, the request is modified to require that information from the data element be retrieved in a masked condition.

摘要翻译： 控制对数据库对象中存储的数据元素的访问。 从用户接收到执行与数据库对象相关的操作的请求，该操作包括从数据库对象的数据元素检索信息。 在从数据元素检索信息之前，确定根据访问策略是否对来自数据元素的信息的至少一部分进行掩蔽。 响应于确定来自数据元素的信息被屏蔽，修改该请求以要求在掩蔽条件下检索来自数据元素的信息。

公开(公告)号：US06665678B2

公开(公告)日：2003-12-16

申请号：US09750543

申请日：2000-12-28

申请人： Stephen Yao Ching Chen ,  Jerry Wayne Goldsmith ,  Kalpana Shyam ,  Julie Ann Watts

发明人： Stephen Yao Ching Chen ,  Jerry Wayne Goldsmith ,  Kalpana Shyam ,  Julie Ann Watts

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： Provided is a method, system, and program for performing a cursor operation. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. A command is received to perform a cursor operation with respect to a subject row in the result table. A lock is obtained on a row in the base table corresponding to the subject row in the result table. An operation specified in the received command is performed with respect to the subject row after obtaining the lock. The lock on the row in the base table is released after performing the operation.

公开(公告)号：US08983985B2

公开(公告)日：2015-03-17

申请号：US13016010

申请日：2011-01-28

申请人： Stephen Yao Ching Chen ,  Curt L. Cotner ,  Gerald G. Kiernan ,  Irene Ching-Hua Liu ,  Claire W. McFeely ,  Walid Rjaibi ,  Timothy J. Vincent

发明人： Stephen Yao Ching Chen ,  Curt L. Cotner ,  Gerald G. Kiernan ,  Irene Ching-Hua Liu ,  Claire W. McFeely ,  Walid Rjaibi ,  Timothy J. Vincent

IPC分类号： G06F17/30

CPC分类号： G06F17/30315 ,  G06F17/30

摘要： Access to a data element stored within a database object is controlled. A request is received from a user to perform an operation in relation to the database object, the operation including retrieval of information from the data element of the database object. Prior to retrieving information from the data element, a determination is made whether at least a portion of the information from the data element is subject to masking in accordance with an access policy. In response to determining that information from the data element is subject to masking, the request is modified to require that information from the data element be retrieved in a masked condition.

摘要翻译： 控制对数据库对象中存储的数据元素的访问。 从用户接收到执行与数据库对象相关的操作的请求，该操作包括从数据库对象的数据元素检索信息。 在从数据元素检索信息之前，确定根据访问策略是否对来自数据元素的信息的至少一部分进行掩蔽。 响应于确定来自数据元素的信息被屏蔽，修改该请求以要求在掩蔽条件下检索来自数据元素的信息。