专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07774355B2 Dynamic authorization based on focus data 有权
标题翻译：基于焦点数据的动态授权
公开(公告)号：US07774355B2
公开(公告)日：2010-08-10
申请号：US11326560
申请日：2006-01-05
申请人： Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz
发明人： Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz
IPC分类号： G06F7/00
CPC分类号： G06F17/30448
摘要： A mechanism is disclosed for selecting an authorization filter to apply when executing a database query, based on the focus of the database query. Based on the focus specified for a given of the query, different conditions may be added during query processing to a database query. Doing so provides a flexible approach to managing data access requests where queries may focus on the same underlying data from many different perspectives.
摘要翻译：公开了一种基于数据库查询的重点来选择在执行数据库查询时应用的授权过滤器的机制。基于针对给定查询指定的焦点，可以在查询处理期间向数据库查询添加不同的条件。这样做提供了一种灵活的方法来管理数据访问请求，其中查询可能从许多不同的角度集中在相同的底层数据上。

2. 发明授权

US07752215B2 System and method for protecting sensitive data 有权
标题翻译：用于保护敏感数据的系统和方法
公开(公告)号：US07752215B2
公开(公告)日：2010-07-06
申请号：US11246792
申请日：2005-10-07
申请人： Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz , Padma S. Rao , Marci L. Sperber , Shannon E. Wenzel
发明人： Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz , Padma S. Rao , Marci L. Sperber , Shannon E. Wenzel
IPC分类号： G06F7/00 , G06F17/30 , G06F17/00
CPC分类号： G06F21/6245 , G06F17/3053 , G06F21/6227
摘要： A method, system and article of manufacture for protecting sensitive data in databases and, more particularly, for managing access to sensitive data in a database. One embodiment comprises receiving a query against the data in the database comprising at least (i) a result field specification, and (ii) a sorting instruction. The method further comprises retrieving a result set from the database, and filtering the retrieved result set on the basis of predefined filtering rules to remove selected data from a selected result field of at least one data record included with the retrieved result set. The filtered result set is sorted according to the sorting instruction to produce the sorted result set, whereby the sorting is done independently of the removed selected data so that the sorted result set places the at least one data record at a position which is non-indicative of a value of the removed selected data.
摘要翻译：一种用于保护数据库中敏感数据的方法，系统和制品，更具体地说，用于管理对数据库中的敏感数据的访问。一个实施例包括接收关于数据库中的数据的查询，其包括至少（i）结果字段规范和（ii）排序指令。该方法还包括从数据库检索结果集，并且基于预定义的过滤规则对检索的结果集进行过滤，以从包含在检索结果集中的至少一个数据记录的选定结果字段中移除所选数据。根据分类指令对滤波后的结果集进行排序，以产生排序结果集，由此排序独立于所移除的所选数据进行，使得分类结果集将至少一个数据记录放置在非指示位置的已删除选定数据的值。

3. 发明授权

US08321387B2 Restricting access to sensitive data 失效
标题翻译：限制访问敏感数据
公开(公告)号：US08321387B2
公开(公告)日：2012-11-27
申请号：US11191415
申请日：2005-07-28
申请人： Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz , Padma S. Rao , Marci L. Sperber , Shannon E. Wenzel
发明人： Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz , Padma S. Rao , Marci L. Sperber , Shannon E. Wenzel
IPC分类号： G06F17/30
CPC分类号： G06F21/6227
摘要： Techniques are disclosed for managing execution of queries against databases and more particularly for restricting access to sensitive data in underlying databases. One embodiment includes an operation for managing access to sensitive data in a database. The operation includes receiving, from a requesting entity, a query against the data in the database. The query is executed against the database to obtain a result set. The operation further includes determining whether the result set includes sensitive data based on predefined sensitivity attributes associated with data in the result set. If so, a sensitivity rating is determined for the result set, and a predefined security action is performed with respect to the result set on the basis of the determined sensitivity rating.
摘要翻译：公开了用于管理针对数据库的查询的执行的技术，更具体地涉及限制对底层数据库中的敏感数据的访问。一个实施例包括用于管理对数据库中的敏感数据的访问的操作。该操作包括从请求实体接收针对数据库中的数据的查询。针对数据库执行查询以获取结果集。该操作还包括基于与结果集中的数据相关联的预定灵敏度属性来确定结果集是否包括敏感数据。如果是，则确定结果集的灵敏度等级，并且基于所确定的灵敏度等级对相对于结果集执行预定义的安全动作。

4. 发明授权

US08055683B2 Management of relationships between database tables 有权
标题翻译：管理数据库表之间的关系
公开(公告)号：US08055683B2
公开(公告)日：2011-11-08
申请号：US10965186
申请日：2004-10-14
申请人： Mark A. Brodhun , Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz
发明人： Mark A. Brodhun , Richard D. Dettinger , Janice R. Glowacki , Daniel P. Kolz
IPC分类号： G06F7/00
CPC分类号： G06F17/30604
摘要： A method, system and article of manufacture for managing relationships between database tables and, more particularly, for identifying and accurately describing relationships between tables in a database. One embodiment provides a method for identifying relationships between tables in a database. The method comprises receiving user input selecting a plurality of tables from the database. The plurality of tables is organized into a logical island defining a logical unit related to a particular logical entity. The method further comprises receiving user input identifying, for each of the plurality of tables, a table column containing information that identifies the particular logical entity in the table, whereby the identified table columns of different tables define logical relationships between the different tables in the logical island. On the basis of the identified table columns, relations specifications are created which describe the logical relationships between the different tables in the logical island.
摘要翻译：一种用于管理数据库表之间的关系的方法，系统和制品，更具体地，用于识别和准确描述数据库中的表之间的关系。一个实施例提供了一种用于识别数据库中的表之间的关系的方法。该方法包括接收从数据库中选择多个表的用户输入。多个表被组织成定义与特定逻辑实体相关的逻辑单元的逻辑岛。所述方法还包括接收用户输入，对于所述多个表中的每一个，识别包含标识所述表中的特定逻辑实体的信息的表列，由此所标识的不同表的表列定义逻辑中不同表之间的逻辑关系岛。在识别的表列的基础上，创建了描述逻辑岛中的不同表之间的逻辑关系的关系规范。

5. 发明授权

US07747640B2 Method for regenerating selected rows for an otherwise static result set 有权
标题翻译：为其他静态结果集重新生成所选行的方法
公开(公告)号：US07747640B2
公开(公告)日：2010-06-29
申请号：US11038710
申请日：2005-01-20
申请人： Richard D. Dettinger , Janice R. Glowacki
发明人： Richard D. Dettinger , Janice R. Glowacki
IPC分类号： G06F17/30
CPC分类号： G06F17/30595
摘要： Methods for updating query results are provided. In one embodiment, a stored query is modified to retrieve a selected subset of rows from stored query results without retrieving a remaining portion of the stored results. The modified query is executed, updated results are obtained from the modified query, and the updated results are displayed.
摘要翻译：提供更新查询结果的方法。在一个实施例中，修改存储的查询以从存储的查询结果中检索所选择的行子集，而不检索存储结果的剩余部分。执行修改的查询，从修改后的查询中获取更新的结果，并显示更新的结果。

6. 发明申请

US20080319968A1 PROCESSING QUERY CONDITIONS HAVING FILTERED FIELDS WITHIN A DATA ABSTRACTION ENVIRONMENT 有权
标题翻译：在数据抽取环境中处理具有过滤字段的查询条件
公开(公告)号：US20080319968A1
公开(公告)日：2008-12-25
申请号：US12204232
申请日：2008-09-04
申请人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack
发明人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30392 , G06F17/30427
摘要： Embodiments of the invention provide techniques for composing and executing queries using filtered fields. In one embodiment, a query may be composed with compatible fields, meaning filtered fields that store related data of a particular data type. Such compatible fields may be combined into a single query condition, thus simplifying the composition and execution of the query. In one embodiment, fields may be identified as compatible based on metadata included in a database abstraction model.
摘要翻译：本发明的实施例提供了使用过滤字段来组合和执行查询的技术。在一个实施例中，查询可以由兼容字段组成，意思是存储特定数据类型的相关数据的经过过滤的字段。这样的兼容字段可以被组合成单个查询条件，从而简化查询的组合和执行。在一个实施例中，可以基于包括在数据库抽象模型中的元数据将字段识别为兼容的。

7. 发明授权

US08458200B2 Processing query conditions having filtered fields within a data abstraction environment 有权
标题翻译：处理在数据抽象环境中具有过滤字段的查询条件
公开(公告)号：US08458200B2
公开(公告)日：2013-06-04
申请号：US12204232
申请日：2008-09-04
申请人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack
发明人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack
IPC分类号： G06F17/30
CPC分类号： G06F17/30392 , G06F17/30427
摘要： Embodiments of the invention provide techniques for composing and executing queries using filtered fields. In one embodiment, a query may be composed with compatible fields, meaning filtered fields that store related data of a particular data type. Such compatible fields may be combined into a single query condition, thus simplifying the composition and execution of the query. In one embodiment, fields may be identified as compatible based on metadata included in a database abstraction model.
摘要翻译：本发明的实施例提供了使用过滤字段来组合和执行查询的技术。在一个实施例中，查询可以由兼容字段组成，意思是存储特定数据类型的相关数据的经过过滤的字段。这样的兼容字段可以被组合成单个查询条件，从而简化查询的组合和执行。在一个实施例中，可以基于包括在数据库抽象模型中的元数据将字段识别为兼容的。

8. 发明授权

US07836071B2 Displaying relevant abstract database elements 有权
标题翻译：显示相关的抽象数据库元素
公开(公告)号：US07836071B2
公开(公告)日：2010-11-16
申请号：US11856923
申请日：2007-09-18
申请人： Janice R. Glowacki , Richard D. Dettinger , Fred A. Kulack
发明人： Janice R. Glowacki , Richard D. Dettinger , Fred A. Kulack
IPC分类号： G06F17/30
CPC分类号： G06F17/30392 , Y10S707/99933
摘要： Embodiments of the invention enable users of an abstract database to use logical fields that are relevant to a given model entity. In one embodiment, a user may be presented with a query interface that includes relevant fields, and which may be used to compose abstract queries. In another embodiment, the query interface may include an initial query result, and may include relevant fields for model entities included in the initial query result. The query interface may be configured to enable a user to perform subsequent query operations using the included relevant fields.
摘要翻译：本发明的实施例使得抽象数据库的用户能够使用与给定模型实体相关的逻辑字段。在一个实施例中，可以向用户呈现包括相关字段的查询界面，并且其可以用于撰写抽象查询。在另一实施例中，查询界面可以包括初始查询结果，并且可以包括初始查询结果中包括的模型实体的相关字段。查询接口可以被配置为使得用户能够使用包括的相关字段来执行后续查询操作。

9. 发明申请

US20080319969A1 QUERY CONDITIONS HAVING FILTERED FIELDS WITHIN A DATA ABSTRACTION ENVIRONMENT 有权
标题翻译：在数据抽取环境中具有过滤字段的查询条件
公开(公告)号：US20080319969A1
公开(公告)日：2008-12-25
申请号：US12204250
申请日：2008-09-04
申请人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack
发明人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30392 , G06F17/30398
摘要： Embodiments of the invention provide techniques for composing and executing queries using filtered fields. In one embodiment, a query may be composed with compatible fields, meaning filtered fields that store related data of a particular data type. Such compatible fields may be combined into a single query condition, thus simplifying the composition and execution of the query. In one embodiment, fields may be identified as compatible based on metadata included in a database abstraction model.
摘要翻译：本发明的实施例提供了使用过滤字段来组合和执行查询的技术。在一个实施例中，查询可以由兼容字段组成，意思是存储特定数据类型的相关数据的经过过滤的字段。这样的兼容字段可以被组合成单个查询条件，从而简化查询的组合和执行。在一个实施例中，可以基于包括在数据库抽象模型中的元数据将字段识别为兼容的。

10. 发明申请

US20080016049A1 NATURAL LANGUAGE SUPPORT FOR QUERY RESULTS 审中-公开
标题翻译：自然语言支持查询结果
公开(公告)号：US20080016049A1
公开(公告)日：2008-01-17
申请号：US11456940
申请日：2006-07-12
申请人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack , Erik E. Voldal
发明人： Richard D. Dettinger , Janice R. Glowacki , Frederick A. Kulack , Erik E. Voldal
IPC分类号： G06F17/30
CPC分类号： G06F16/248 , G06F16/243 , G06F16/24522
摘要： A method, system and article of manufacture for providing language transformation support for a query result obtained in response to execution of a query against an underlying database containing physical data. The method comprises identifying one or more physical values defined by the physical data for the query result for the executed query. The method further comprises retrieving a user-defined function configured to transform the one or more identified physical values from a first language defined by the physical data in the underlying database into alternative values defined in a second language. The query result is outputted in the second language on the basis of the user-defined function.
摘要翻译：一种方法，系统和制品，用于为响应于针对包含物理数据的底层数据库的查询的执行而获得的查询结果提供语言变换支持。该方法包括识别由用于执行的查询的查询结果的物理数据定义的一个或多个物理值。该方法还包括检索用户定义的功能，该功能被配置为将由基础数据库中的物理数据定义的第一语言的一个或多个识别的物理值转换成以第二语言定义的替代值。查询结果基于用户定义的功能以第二语言输出。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式