公开(公告)号：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.

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

公开(公告)号：US20130086088A1

公开(公告)日：2013-04-04

申请号：US13251448

申请日：2011-10-03

申请人： Eric L. Alton ,  Thomas A. Beavin ,  Harley W. Boughton ,  Yao-Ching S. Chen ,  Curt L. Cotner ,  Yuping Ding ,  Dengfeng Gao ,  Gerald G. Kiernan ,  Xun Li ,  Irene C. Liu ,  Walid Rjaibi ,  Gregory R. Stager ,  Joyce A. Taylor ,  Timothy J. Vincent ,  Liyan Zhou

发明人： Eric L. Alton ,  Thomas A. Beavin ,  Harley W. Boughton ,  Yao-Ching S. Chen ,  Curt L. Cotner ,  Yuping Ding ,  Dengfeng Gao ,  Gerald G. Kiernan ,  Xun Li ,  Irene C. Liu ,  Walid Rjaibi ,  Gregory R. Stager ,  Joyce A. Taylor ,  Timothy J. Vincent ,  Liyan Zhou

IPC分类号： G06F17/30

CPC分类号： G06F17/30477

摘要： According to one embodiment of the present invention, a system processes a database query, and comprises a computer system including at least one processor. The system identifies one or more expressions within the database query utilizing a database object with value masking. Masking requirements are determined for each identified expression and the database object utilized by that identified expression is replicated to provide masked and actual versions of that database object in response to the masking requirements for that expression including masked values and actual values of that database object. The value masking of the database object is applied to the identified expressions within the database query based on the determined masking requirements to produce search results with masked values for the database query. Embodiments of the present invention further include a method and computer program product for processing a database query in substantially the same manner described above.

摘要翻译： 根据本发明的一个实施例，系统处理数据库查询，并且包括包括至少一个处理器的计算机系统。 系统使用具有值屏蔽的数据库对象来识别数据库查询中的一个或多个表达式。 针对每个已标识的表达式确定掩蔽要求，并复制由该标识表达式使用的数据库对象，以响应该表达式的掩蔽要求（包括该数据库对象的掩蔽值和实际值）来提供该数据库对象的屏蔽和实际版本。 数据库对象的值屏蔽将基于确定的屏蔽要求应用于数据库查询中的标识表达式，以生成具有数据库查询的掩码值的搜索结果。 本发明的实施例还包括用于以与上述基本相同的方式处理数据库查询的方法和计算机程序产品。

公开(公告)号：US06226637B1

公开(公告)日：2001-05-01

申请号：US09392360

申请日：1999-09-08

申请人： Michael J. Carey ,  Gerald G. Kiernan

发明人： Michael J. Carey ,  Gerald G. Kiernan

IPC分类号： G06F1730

CPC分类号： G06F17/30607 ,  G06F17/3041 ,  G06F17/30424 ,  G06F17/3048 ,  Y10S707/954 ,  Y10S707/955 ,  Y10S707/99934

摘要： An object language application (e.g., C++, JAVA, etc.,) issues a query over a view and receives back, as query results, handles to application type objects which can be further manipulated by the application. A view is defined herein as a collection of a view type, and a view type is defined as a class or type. A tool is used by a programmer writing the application to create object language class definitions that are based upon the view type of the view referenced by the query. Upon receipt of the query referencing a view type, a query engine generates a query plan that builds mock (i.e., proxy) application type objects in memory based upon the view types. The application objects have a form that is consistent with the class definition for a type of object returned as a result. The application can run methods on the application type objects or point to other application type objects from the handles, to the application objects, that are returned to the application; and these manipulations will be understood by the query engine. In a preferred embodiment, query rewrite optimizations are applied to the queries over views requiring object building in order to optimize the evaluation of the query and the building of view objects as query results. Query rewrite optimizations can also be applied so that parts of the query are pushed down to the DBMS to minimize the number of objects that need to be built.

摘要翻译： 对象语言应用程序（例如，C ++，JAVA等）通过视图发出查询，并作为查询结果接收回应用于可由应用程序进一步操纵的应用程序类型对象的句柄。 视图在此被定义为视图类型的集合，视图类型被定义为类或类型。 编写应用程序的程序员使用一个工具来创建基于查询引用的视图的视图类型的对象语言类定义。 在接收到引用视图类型的查询时，查询引擎生成基于视图类型在存储器中构建模拟（即代理）应用程序类型对象的查询计划。 应用程序对象具有与返回的对象类型的类定义一致的表单。 应用程序可以在应用程序类型对象上运行方法，或者从句柄中指向其他应用程序类型对象，返回给应用程序的应用程序对象; 这些操作将被查询引擎所理解。 在优选实施例中，通过需要对象构建的视图将查询重写优化应用于查询，以便优化查询的评估和视图对象的构建作为查询结果。 也可以应用查询重写优化，以便部分查询被压缩到DBMS以最小化需要构建的对象数量。

公开(公告)号：US6134540A

公开(公告)日：2000-10-17

申请号：US853294

申请日：1997-05-09

申请人： Michael J. Carey ,  Gerald G. Kiernan

发明人： Michael J. Carey ,  Gerald G. Kiernan

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30607 ,  G06F17/30471 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934

摘要： The system, method, and program of this invention enables an object language application (e.g., C++, JAVA, etc.,) to issue a query over a view and to receive back, as query results, handles to application type objects which can be further manipulated by the application. A view is defined herein as a collection of a view type, and a view type is defined as a class or type. Upon receipt of the query referencing a view type, a query engine generates a query plan that builds mock (i.e., proxy) application type objects in memory based upon the view types. The application can run methods on the application type objects or point to other application type objects from the handles, to the application objects, that are returned to the application; and these manipulations will be understood by the query engine. In a preferred embodiment, query rewrite optimizations are applied to the queries over views requiring object building in order to optimize the evaluation of the query and the building of view objects as query results. For example, when a query over a view is analyzed and it is determined that the query is not requesting a handle, and is not referencing a method, but only asks for values, no objects are built. Also, if a query traverses a reference type attribute, but the query can be transformed into a join or outer join operation between relational tables, then no object building is required. In these above described situations, the rewritten query can be pushed down to the database management system of the data source for resolution. If the query does request a handle or references a method, then some object building is required. However, query rewrite techniques can still be applied so that parts of the query are pushed down to the DBMS to minimize the number of objects that are built.

摘要翻译： 本发明的系统，方法和程序使得对象语言应用（例如，C ++，JAVA等）能够通过视图发出查询，并且作为查询结果接收返回到可以是应用程序类型对象的句柄 由应用进一步操纵。 视图在此被定义为视图类型的集合，视图类型被定义为类或类型。 在接收到引用视图类型的查询时，查询引擎生成基于视图类型在存储器中构建模拟（即代理）应用程序类型对象的查询计划。 应用程序可以在应用程序类型对象上运行方法，或者从句柄中指向其他应用程序类型对象，返回给应用程序的应用程序对象; 这些操作将被查询引擎所理解。 在优选实施例中，通过需要对象构建的视图将查询重写优化应用于查询，以便优化查询的评估和视图对象的构建作为查询结果。 例如，当分析视图上的查询并且确定查询未请求句柄并且未引用方法，但是仅询问值时，不构建对象。 此外，如果查询遍历引用类型属性，但是查询可以转换为关系表之间的连接或外部连接操作，则不需要构建对象。 在这些上述情况下，可以将重写的查询推送到数据源的数据库管理系统进行解析。 如果查询确实请求一个句柄或引用一个方法，那么需要建立一些对象。 然而，仍然可以应用查询重写技术，以便查询的部分被压下到DBMS以最小化构建的对象的数量。

公开(公告)号：US6122627A

公开(公告)日：2000-09-19

申请号：US853976

申请日：1997-05-09

申请人： Michael J. Carey ,  Gerald G. Kiernan

发明人： Michael J. Carey ,  Gerald G. Kiernan

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30607 ,  G06F17/3041 ,  G06F17/30424 ,  G06F17/3048 ,  Y10S707/954 ,  Y10S707/955 ,  Y10S707/99934

摘要： The system, method, and program of this invention enables an object language application to issue a query over a view and to receive back, as query results, handles to application type objects which can be further manipulated by the application. A view is defined herein as a collection of a view type, and a view type is defined as a class or type. Upon receipt of the query referencing a view type, a query engine generates a query plan that builds mock (i.e., proxy) application type objects in memory based upon the view types. The application objects have a form that is consistent with the class definition for a type of object returned as a result. The application can run methods on the application type objects or point to other application type objects from the handles, to the application objects, that are returned to the application; and these manipulations will be understood by the query engine. In a preferred embodiment, query rewrite optimizations are applied to the queries over views requiring object building in order to optimize the evaluation of the query and the building of view objects as query results.

摘要翻译： 本发明的系统，方法和程序使得对象语言应用程序能够通过视图发出查询，并且作为查询结果接收对应用程序类型对象的处理，该应用程序类型对象可由应用程序进一步操纵。 视图在此被定义为视图类型的集合，视图类型被定义为类或类型。 在接收到引用视图类型的查询时，查询引擎生成基于视图类型在存储器中构建模拟（即代理）应用程序类型对象的查询计划。 应用程序对象具有与返回的对象类型的类定义一致的表单。 应用程序可以在应用程序类型对象上运行方法，或者从句柄中指向其他应用程序类型对象，返回给应用程序的应用程序对象; 这些操作将被查询引擎所理解。 在优选实施例中，通过需要对象构建的视图将查询重写优化应用于查询，以便优化查询的评估和视图对象的构建作为查询结果。

公开(公告)号：US5797136A

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

申请号：US539561

申请日：1995-10-05

申请人： Philip L. Boyer ,  Gerald G. Kiernan

发明人： Philip L. Boyer ,  Gerald G. Kiernan

IPC分类号： G06F17/30

CPC分类号： G06F17/30421 ,  G06F17/30451 ,  G06F17/30471 ,  G06F17/30498 ,  G06F17/30607 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99935

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

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