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

1. 发明申请

US20070143245A1 System and method for managing presentation of query results 审中-公开
标题翻译：用于管理查询结果呈现的系统和方法
公开(公告)号：US20070143245A1
公开(公告)日：2007-06-21
申请号：US11303524
申请日：2005-12-16
申请人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
发明人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
IPC分类号： G06F17/30
CPC分类号： G06F16/248
摘要： A method, system and article of manufacture for managing presentation of query results. One embodiment comprises receiving, from a requesting entity, a query having at least (i) one result field for which data from one or more databases is to be returned, (ii) one or more conditions for filtering which of the data contained in the one or more databases is returned for each result field, and (iii) a conditions object defining at least one expression for at least one of the conditions. The query is executed against the one or more databases to obtain a query result having one or more data records. The query result is returned in a format relating the data records to respective expressions on the basis of which conditions the data records satisfy. Thereby, it is exposed which of the data records satisfy respective conditions having defined expressions in the conditions object.
摘要翻译：一种用于管理查询结果呈现的方法，系统和制品。一个实施例包括从请求实体接收具有至少（i）要从其返回一个或多个数据库的数据的一个结果字段的查询，（ii）一个或多个条件，用于过滤包含在对于每个结果字段返回一个或多个数据库，以及（iii）为至少一个条件定义至少一个表达式的条件对象。针对一个或多个数据库执行查询以获得具有一个或多个数据记录的查询结果。基于数据记录满足的条件，以与数据记录相关的各种表达式的格式返回查询结果。从而，暴露在条件对象中哪个数据记录满足具有规定表达式的各个条件。

2. 发明申请

US20070027880A1 System and method for restricting access to sensitive data 失效
标题翻译：限制访问敏感数据的系统和方法
公开(公告)号：US20070027880A1
公开(公告)日：2007-02-01
申请号：US11191415
申请日：2005-07-28
申请人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
发明人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
IPC分类号： G06F7/00
CPC分类号： G06F21/6227
摘要： A method, system and article of manufacture for managing execution of queries against databases and more particularly for restricting access to sensitive data in underlying databases. One embodiment provides a method for managing access to sensitive data in a database. The method comprises 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 method further comprises 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 preformed with respect to the result set on the basis of the determined sensitivity rating.
摘要翻译：用于管理针对数据库的查询执行的方法，系统和制品，特别是用于限制对底层数据库中的敏感数据的访问。一个实施例提供了一种用于管理对数据库中的敏感数据的访问的方法。该方法包括从请求实体接收针对数据库中的数据的查询。针对数据库执行查询以获取结果集。该方法还包括基于与结果集中的数据相关联的预定灵敏度属性来确定结果集是否包括敏感数据。如果是，则确定结果集的灵敏度等级，并且基于所确定的灵敏度等级，相对于结果集执行预定义的安全动作。

3. 发明申请

US20080249998A1 TECHNIQUES FOR PROCESSING DATA FROM A MULTILINGUAL DATABASE 有权
标题翻译：从多数据库处理数据的技术
公开(公告)号：US20080249998A1
公开(公告)日：2008-10-09
申请号：US11697377
申请日：2007-04-06
申请人： Richard D. Dettinger , Janice Glowacki , Frederick A. Kulack
发明人： Richard D. Dettinger , Janice Glowacki , Frederick A. Kulack
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30401 , G06F17/3043 , G06F17/30554 , G06F17/30991 , Y10S707/99933
摘要： A method, system and article of manufacture for providing natural language support for users running queries against a multilingual database. One embodiment comprises identifying one or more physical values defined by physical data in the multilingual database for a query result associated with an executed query. At least one translation function configured to transform at least a portion of the identified physical values defined in one or more different natural languages into alternative values defined in a selected language is executed. From each executed translation function, a data structure mapping at least a portion of the identified physical values to translated values defined in the selected language is identified and the translated values defining the alternative values defined in the selected language are retrieved from each identified data structure. The query result associated with the executed query including the alternative values defined in the selected language is output.
摘要翻译：一种为多语言数据库运行查询的用户提供自然语言支持的方法，系统和制品。一个实施例包括识别由多个语言数据库中的物理数据定义的与执行的查询相关联的查询结果的一个或多个物理值。至少一个翻译功能被配置为将所定义的一个或多个不同自然语言中所识别的物理值的至少一部分转换为以选定语言定义的替换值。从每个执行的翻译功能，识别将所识别的物理值的至少一部分映射到以所选择的语言定义的翻译值的数据结构，并且从每个识别的数据结构中检索定义所选语言中定义的替代值的翻译值。输出与执行查询相关联的查询结果，包括以所选语言定义的替代值。

4. 发明申请

US20070083514A1 System and method for protecting sensitive data 有权
标题翻译：用于保护敏感数据的系统和方法
公开(公告)号：US20070083514A1
公开(公告)日：2007-04-12
申请号：US11246792
申请日：2005-10-07
申请人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
发明人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
IPC分类号： G06F7/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）排序指令。该方法还包括从数据库检索结果集，并且基于预定义的过滤规则对检索的结果集进行过滤，以从包含在检索结果集中的至少一个数据记录的选定结果字段中移除所选数据。根据分类指令对滤波后的结果集进行排序，以产生排序结果集，由此排序独立于所移除的所选数据进行，使得分类结果集将至少一个数据记录放置在非指示位置的已删除选定数据的值。

5. 发明授权

US07680780B2 Techniques for processing data from a multilingual database 有权
标题翻译：从多语言数据库处理数据的技术
公开(公告)号：US07680780B2
公开(公告)日：2010-03-16
申请号：US11697377
申请日：2007-04-06
申请人： Richard D. Dettinger , Janice Glowacki , Frederick A. Kulack
发明人： Richard D. Dettinger , Janice Glowacki , Frederick A. Kulack
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30401 , G06F17/3043 , G06F17/30554 , G06F17/30991 , Y10S707/99933
摘要： A method, system and article of manufacture for providing natural language support for users running queries against a multilingual database. One embodiment comprises identifying one or more physical values defined by physical data in the multilingual database for a query result associated with an executed query. At least one translation function configured to transform at least a portion of the identified physical values defined in one or more different natural languages into alternative values defined in a selected language is executed. From each executed translation function, a data structure mapping at least a portion of the identified physical values to translated values defined in the selected language is identified and the translated values defining the alternative values defined in the selected language are retrieved from each identified data structure. The query result associated with the executed query including the alternative values defined in the selected language is output.
摘要翻译：一种为多语言数据库运行查询的用户提供自然语言支持的方法，系统和制品。一个实施例包括识别由多个语言数据库中的物理数据定义的与执行的查询相关联的查询结果的一个或多个物理值。至少一个翻译功能被配置为将所定义的一个或多个不同自然语言中所识别的物理值的至少一部分转换为以选定语言定义的替换值。从每个执行的翻译功能，识别将所识别的物理值的至少一部分映射到以所选择的语言定义的翻译值的数据结构，并且从每个识别的数据结构中检索定义所选语言中定义的替代值的翻译值。输出与执行查询相关联的查询结果，包括以所选语言定义的替代值。

6. 发明申请

US20060161528A1 Method for regenerating selected rows for an otherwise static result set 有权
标题翻译：为其他静态结果集重新生成所选行的方法
公开(公告)号：US20060161528A1
公开(公告)日：2006-07-20
申请号：US11038710
申请日：2005-01-20
申请人： Richard Dettinger , Janice Glowacki
发明人： Richard Dettinger , Janice Glowacki
IPC分类号： G06F17/30
CPC分类号： G06F17/30595
摘要： Methods and a computer readable medium 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.
摘要翻译：提供了用于更新查询结果的方法和计算机可读介质。在一个实施例中，修改存储的查询以从存储的查询结果中检索所选择的行子集，而不检索存储结果的剩余部分。执行修改的查询，从修改后的查询中获取更新的结果，并显示更新的结果。

7. 发明申请

US20070276825A1 QUERY REUSE THROUGH RECOMMEND PARAMETER FLEXIBILITY 审中-公开
标题翻译：通过推荐参数灵活地查询重新使用
公开(公告)号：US20070276825A1
公开(公告)日：2007-11-29
申请号：US11380772
申请日：2006-04-28
申请人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
发明人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
IPC分类号： G06F17/30
CPC分类号： G06F16/2425 , G06F16/2423
摘要： Embodiments of the present invention provide methods and systems for increasing the flexibility and reusability of parameterized queries. A user may be allowed to select and run a predefined query. If the query is a parameterized query, the user may be prompted to input one or more parameters. Embodiments of the invention allow the user to recommend a parameter that retrieves maximum or minimum results for the query instead of specifying a parameter. In response to such a user selection, a predefined parameter may be inserted as a parameter for the query. Alternatively, the query may be modified by changing or removing one or more query conditions to achieve the desired results.
摘要翻译：本发明的实施例提供了用于增加参数化查询的灵活性和可重用性的方法和系统。可以允许用户选择并运行预定义的查询。如果查询是参数化查询，则可能会提示用户输入一个或多个参数。本发明的实施例允许用户推荐检索查询的最大或最小结果的参数，而不是指定参数。响应于这样的用户选择，可以插入预定义参数作为查询的参数。或者，可以通过更改或移除一个或多个查询条件来修改查询以实现期望的结果。

8. 发明申请

US20070156668A1 Dynamic authorization based on focus data 有权
标题翻译：基于焦点数据的动态授权
公开(公告)号：US20070156668A1
公开(公告)日：2007-07-05
申请号：US11326560
申请日：2006-01-05
申请人： Richard Dettinger , Janice Glowacki , Daniel Kolz
发明人： Richard Dettinger , Janice Glowacki , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30448
摘要： Embodiments of the invention provide a mechanism 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.
摘要翻译：基于数据库查询的重点，本发明的实施例提供了一种用于选择在执行数据库查询时应用的授权过滤器的机制。基于针对给定查询指定的焦点，可以在查询处理期间向数据库查询添加不同的条件。这样做提供了一种灵活的方法来管理数据访问请求，其中查询可能从许多不同的角度集中在相同的底层数据上。

9. 发明申请

US20060085437A1 Management of relationships between database tables 有权
标题翻译：管理数据库表之间的关系
公开(公告)号：US20060085437A1
公开(公告)日：2006-04-20
申请号：US10965186
申请日：2004-10-14
申请人： Mark Brodhun , Richard Dettinger , Janice Glowacki , Daniel Kolz
发明人： Mark Brodhun , Richard Dettinger , Janice Glowacki , Daniel 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.
摘要翻译：一种用于管理数据库表之间的关系的方法，系统和制品，更具体地，用于识别和准确描述数据库中的表之间的关系。一个实施例提供了一种用于识别数据库中的表之间的关系的方法。该方法包括接收从数据库中选择多个表的用户输入。多个表被组织成定义与特定逻辑实体相关的逻辑单元的逻辑岛。所述方法还包括接收用户输入，对于所述多个表中的每一个，识别包含标识所述表中的特定逻辑实体的信息的表列，由此所标识的不同表的表列定义逻辑中不同表之间的逻辑关系岛。在识别的表列的基础上，创建了描述逻辑岛中的不同表之间的逻辑关系的关系规范。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式