Restricting access to sensitive data
    32.
    发明授权
    Restricting access to sensitive data 失效
    限制访问敏感数据

    公开(公告)号:US08321387B2

    公开(公告)日:2012-11-27

    申请号:US11191415

    申请日:2005-07-28

    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.

    摘要翻译: 公开了用于管理针对数据库的查询的执行的技术,更具体地涉及限制对底层数据库中的敏感数据的访问。 一个实施例包括用于管理对数据库中的敏感数据的访问的操作。 该操作包括从请求实体接收针对数据库中的数据的查询。 针对数据库执行查询以获取结果集。 该操作还包括基于与结果集中的数据相关联的预定灵敏度属性来确定结果集是否包括敏感数据。 如果是,则确定结果集的灵敏度等级,并且基于所确定的灵敏度等级对相对于结果集执行预定义的安全动作。

    Addressing query scheduling and system resource requirements
    33.
    发明授权
    Addressing query scheduling and system resource requirements 失效
    解决查询调度和系统资源需求

    公开(公告)号:US07925619B2

    公开(公告)日:2011-04-12

    申请号:US12187945

    申请日:2008-08-07

    IPC分类号: G06F7/00 G06F17/00

    摘要: Method, system and article of manufacture for scheduling queries. In particular, the scheduling options made available to a user for a particular unit of work are determined dynamically at the time of scheduling. In this way, the execution cost, for example, of a particular unit of work can be taken into account when determining which scheduling options to make available. In addition, or alternatively, system availability and/or user parameters may be accounted for when determining which scheduling options to make available.

    摘要翻译: 调度查询的方法,系统和制造。 特别地,在调度时动态地确定用于特定工作单元的用户可用的调度选项。 以这种方式,在确定哪些调度选项可用时,可以考虑执行成本,例如特定工作单元的执行成本。 此外,或者替代地,当确定哪些调度选项可用时,可以考虑系统可用性和/或用户参数。

    Abstractly mapped physical data fields
    36.
    发明授权
    Abstractly mapped physical data fields 失效
    抽象地映射物理数据字段

    公开(公告)号:US07403937B2

    公开(公告)日:2008-07-22

    申请号:US11216384

    申请日:2005-08-31

    IPC分类号: G06F17/30

    摘要: A method, apparatus, and article of manufacture for managing access to an abstract database are provided. The abstract database may include a data abstraction model comprising a plurality of logical field definitions, each of the definitions comprising a logical field name, and an access method maps the logical field to a physical data field. Collectively, the physical data fields provide an indirection layer logically disposed between the data abstraction model and the underlying physical database. By providing this layer of indirection using the physical data fields, a number of enhancements to the data abstraction model may be provided. This includes providing enhancements to the security, administration, and usability of an abstract database.

    摘要翻译: 提供了一种用于管理对抽象数据库的访问的方法,装置和制品。 抽象数据库可以包括包括多个逻辑字段定义的数据抽象模型,每个定义包括逻辑字段名称,并且访问方法将逻辑字段映射到物理数据字段。 总体而言,物理数据字段提供了逻辑上位于数据抽象模型和底层物理数据库之间的间接层。 通过使用物理数据字段提供这种间接层,可以提供对数据抽象模型的许多增强。 这包括提供抽象数据库的安全性,管理和可用性的增强功能。

    Techniques for representing relationships between queries
    38.
    发明授权
    Techniques for representing relationships between queries 失效
    用于表示查询之间的关系的技术

    公开(公告)号:US08135698B2

    公开(公告)日:2012-03-13

    申请号:US10877230

    申请日:2004-06-25

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30395

    摘要: A method, system and article of manufacture for processing queries and, more particularly, for graphically representing relationships between different queries. One embodiment provides a method for graphically representing a relationship between a first and a second query. The method includes selecting, from the first and second queries, elements to be compared. On the basis of the selected elements, a degree of similarity between the first and second queries is calculated. The method further includes displaying a first query object representative of the first query and a second query object representative of the second query in a user interface. The first and second query objects are positionally arranged on the basis of the calculated degree of similarity. The positional arrangement reflects the relationship between the first and second queries.

    摘要翻译: 一种用于处理查询的方法,系统和制品,更具体地,用于图形地表示不同查询之间的关系。 一个实施例提供了用于图形地表示第一和第二查询之间的关系的方法。 该方法包括从第一和第二查询中选择要比较的元素。 在所选择的元素的基础上,计算第一和第二查询之间的相似程度。 该方法还包括在用户界面中显示表示第一查询的第一查询对象和表示第二查询的第二查询对象。 第一和第二查询对象在计算出的相似程度的基础上进行排列。 位置布置反映了第一和第二查询之间的关系。

    Query rebinding for high-availability database systems
    39.
    发明授权
    Query rebinding for high-availability database systems 有权
    高可用性数据库系统的查询重新绑定

    公开(公告)号:US07668807B2

    公开(公告)日:2010-02-23

    申请号:US11064717

    申请日:2005-02-24

    IPC分类号: G06F17/30 G06F17/00

    摘要: Embodiments of the invention allow for managing execution of queries with respect to different data sources. The different data sources are logically represented by data abstraction models. One embodiment comprises receiving a first abstract query against physical data in a first data source. The first abstract query has result fields configured to return requested data from the first data source. In response it is detected whether the first data source is available. If the first data source is unavailable, a second abstract query against physical data in a second data source containing a portion of the requested data is created on the basis of the first abstract query. The second abstract query has result fields configured to return the portion of the requested data from the second data source. The second abstract query is executed against the second data source to obtain the portion of the requested data.

    摘要翻译: 本发明的实施例允许管理关于不同数据源的查询的执行。 不同的数据源由数据抽象模型逻辑表示。 一个实施例包括接收针对第一数据源中的物理数据的第一抽象查询。 第一个抽象查询的结果字段被配置为从第一个数据源返回所请求的数据。 作为响应,检测第一数据源是否可用。 如果第一数据源不可用,则基于第一抽象查询创建针对包含所请求数据的一部分的第二数据源中的物理数据的第二抽象查询。 第二抽象查询具有被配置为从第二数据源返回所请求数据的部分的结果字段。 针对第二数据源执行第二抽象查询以获得所请求数据的一部分。

    Database staging area read-through or forced flush with dirty notification
    40.
    发明授权
    Database staging area read-through or forced flush with dirty notification 有权
    数据库分段区读取或强制与脏通知冲洗

    公开(公告)号:US08010499B2

    公开(公告)日:2011-08-30

    申请号:US12343340

    申请日:2008-12-23

    IPC分类号: G06F17/30

    摘要: Embodiments of the present invention allow the results of a query to an operational datastore to be augmented with relevant data that may be stored in a staging area datastore. Upon receiving a query to the operational datastore, it is determined whether data relevant to the query is present in the staging area datastore. If relevant data is present, such data may be transformed, transferred and combined with data in the operational datastore. The query is then run against the combined data and the results displayed to the user.

    摘要翻译: 本发明的实施例允许利用可以存储在暂存区数据存储中的相关数据来增加对操作数据存储的查询的结果。 在接收到对操作数据存储的查询后,确定与该查询相关的数据是否存在于暂存区数据存储区中。 如果存在相关数据,则可以将这些数据转换,传输并与操作数据存储区中的数据组合。 然后针对组合的数据运行查询,并向用户显示结果。