Method and process of query optimization to a given environment via specific abstraction layer domain knowledge
    1.
    发明授权
    Method and process of query optimization to a given environment via specific abstraction layer domain knowledge 有权
    通过特定抽象层领域知识,给定环境查询优化的方法和过程

    公开(公告)号:US08548985B2

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

    申请号:US10977765

    申请日:2004-10-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/3056

    摘要: Methods and apparatus for optimizing an abstract query are disclosed. Embodiments of the present invention allow an abstract database to optimize an abstract query composed from a set of logical fields. Each logical field includes a field name and an access method used to map the logical field to an underlying physical representation of the data. After a user composes an abstract query and submits it for execution, a runtime component and optimization component may be configured to resolve the abstract query to a physical query of the underlying physical data source using an access method associated with each logical field. In addition, as the runtime component builds a query consistent with the schema of the underlying database, an optimizing component may modify the query using any suitable optimization techniques. Different optimization techniques include optimizations based on logical field metadata, optimizations based on the underlying physical data repositories referenced by an access method and optimizations based on the relationships between logical fields or underlying data structures.

    摘要翻译: 公开了优化抽象查询的方法和装置。 本发明的实施例允许抽象数据库优化由一组逻辑字段组成的抽象查询。 每个逻辑字段包括字段名称和用于将逻辑字段映射到数据的底层物理表示的访问方法。 在用户组成抽象查询并将其提交以执行之后,可以将运行时组件和优化组件配置为使用与每个逻辑字段相关联的访问方法将抽象查询解析为底层物理数据源的物理查询。 此外,由于运行时组件构建与基础数据库的模式一致的查询,因此优化组件可以使用任何合适的优化技术来修改查询。 不同的优化技术包括基于逻辑字段元数据的优化,基于访问方法引用的底层物理数据存储库的优化和基于逻辑字段或底层数据结构之间的关系的优化。

    Method and system for providing aggregate data access
    2.
    发明授权
    Method and system for providing aggregate data access 有权
    提供聚合数据访问的方法和系统

    公开(公告)号:US08341172B2

    公开(公告)日:2012-12-25

    申请号:US10897333

    申请日:2004-07-22

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30595

    摘要: A method and apparatus for defining and processing aggregate data is disclosed. Using database abstraction techniques, a set of logical fields may be used to compose queries of a set of underlying physical data sources. In one embodiment, a logical field may represent an aggregate data value calculated from the elements appearing in a column of a relational table in an underlying physical data source. The elements may be divided into to subsets to calculate multiple aggregate values. An abstract derived entity is a data object present in a database abstraction model that may be accessed as though it were a relational table contained in an underlying physical data source. In one embodiment, columns of the table defined by the abstract derived entity may be populated with aggregate data values joined to other data as specified by a composition rule included in the definition of the abstract derived entity.

    摘要翻译: 公开了一种用于定义和处理聚合数据的方法和装置。 使用数据库抽象技术,可以使用一组逻辑字段来构成一组底层物理数据源的查询。 在一个实施例中,逻辑字段可以表示从出现在底层物理数据源中的关系表的列中的元素计算的聚合数据值。 元素可以分为子集,以计算多个聚合值。 抽象派生实体是存在于数据库抽象模型中的数据对象,可以被访问,就像它是包含在底层物理数据源中的关系表一样。 在一个实施例中,由抽象派生实体定义的表的列可以填充与由包括在抽象派生实体的定义中的组合规则指定的其他数据连接的聚合数据值。

    Dealing with composite data through data model entities
    3.
    发明授权
    Dealing with composite data through data model entities 有权
    通过数据模型实体处理复合数据

    公开(公告)号:US08122009B2

    公开(公告)日:2012-02-21

    申请号:US12409193

    申请日:2009-03-23

    IPC分类号: G06F7/00 G06F17/30

    摘要: The present invention is generally directed to a system, method and article of manufacture for accessing data represented abstractly through an abstraction model. In one embodiment, a data repository abstraction layer provides a logical view of an underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs conversion of an abstract query (i.e., a request for results or a request to modify data) into a form that can be used against a particular physical data representation. Abstract and/or physical queries are transformed according to model entities which define a relationship between logical fields of the data repository abstraction layer.

    摘要翻译: 本发明一般涉及通过抽象模型抽象地访问数据的系统,方法和制品。 在一个实施例中,数据存储库抽象层提供独立于数据表示的特定方式的底层数据存储库的逻辑视图。 还提供查询抽象层,并基于数据库抽象层。 运行时组件执行将抽象查询(即,对结果的请求或修改数据的请求)转换成可以针对特定物理数据表示使用的形式。 根据定义数据库抽象层的逻辑字段之间的关系的模型实体来转换抽象和/或物理查询。

    Security model using security domains in a security model applied to abstract database
    4.
    发明授权
    Security model using security domains in a security model applied to abstract database 有权
    安全模型在应用于抽象数据库的安全模型中使用安全域

    公开(公告)号:US07672936B2

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

    申请号:US11693478

    申请日:2007-03-29

    IPC分类号: G06F17/30

    CPC分类号: G06F21/6227 Y10S707/99933

    摘要: The present invention generally is directed to a method, system and article of manufacture for controlling the access to data granted to a requesting entity based upon data accessed by the entity in the past. Additionally, embodiments of the present invention allow for access control independent from the particular manner in which the data is physically represented. Generally, abstraction layers are provided to represent various data sources available for use by an application and to compose queries used by the application to access and/or update information contained in these data sources. A runtime component is responsible for resolving an abstract query into concrete data access requests to one or more data repositories using information contained in a data repository abstraction component (one of the abstraction layers). Typically, data is organized into a series of domains. Within each domain, data is associated with an account. User activity is monitored, and when data associated with one account is accessed, a user may subsequently be prohibited from accessing data from a related account within the same domain.

    摘要翻译: 本发明一般涉及一种用于根据过去由实体访问的数据来控制对授权实体授予的数据的访问的方法,系统和制品。 另外,本发明的实施例允许独立于物理表示数据的特定方式的访问控制。 通常,抽象层被提供以表示可供应用使用的各种数据源,并且构成应用程序使用的查询访问和/或更新这些数据源中包含的信息。 运行时组件负责使用数据存储库抽象组件(抽象层之一)中包含的信息将抽象查询解析为对一个或多个数据存储库的具体数据访问请求。 通常,数据被组织成一系列域。 在每个域内,数据与一个帐户相关联。 监视用户活动,并且当访问与一个帐户相关联的数据时,随后可以禁止用户从同一域内的相关帐户访问数据。

    METADATA MANAGEMENT FOR A DATA ABSTRACTION MODEL
    5.
    发明申请
    METADATA MANAGEMENT FOR A DATA ABSTRACTION MODEL 失效
    数据摘要模型的元数据管理

    公开(公告)号:US20090144251A1

    公开(公告)日:2009-06-04

    申请号:US12369204

    申请日:2009-02-11

    IPC分类号: G06F7/06 G06F17/30

    摘要: Systems and articles of manufacture for managing metadata associated with a data abstraction model abstractly describing data in a database. One embodiment provides a technique for managing metadata describing objects of a data abstraction model with logical fields that define abstract views of physical data in a database. Managing metadata includes traversing a logical tree structure representing the data abstraction model. The logical tree structure has a plurality of nodes, each representing a logical field or a category of logical fields of the data abstraction model. Managing metadata also includes identifying metadata describing logical fields or categories represented by the plurality of nodes. The identified metadata is stored in a queryable database. A user is allowed to query the database to identify objects in the data abstraction model that may be used to construct an abstract query.

    摘要翻译: 用于管理与抽象地描述数据库中的数据的数据抽象模型相关联的元数据的系统和制品。 一个实施例提供了一种技术,用于管理描述数据抽象模型的对象的元数据,该逻辑字段定义数据库中物理数据的抽象视图。 管理元数据包括遍历表示数据抽象模型的逻辑树结构。 逻辑树结构具有多个节点,每个节点表示数据抽象模型的逻辑字段或逻辑字段的类别。 管理元数据还包括识别描述由多个节点表示的逻辑字段或类别的元数据。 所识别的元数据存储在可查询的数据库中。 允许用户查询数据库以识别可用于构建抽象查询的数据抽象模型中的对象。

    Dealing with composite data through data model entities
    6.
    发明授权
    Dealing with composite data through data model entities 有权
    通过数据模型实体处理复合数据

    公开(公告)号:US07539662B2

    公开(公告)日:2009-05-26

    申请号:US11360353

    申请日:2006-02-23

    IPC分类号: G06F7/00 G06F17/30

    摘要: The present invention is generally directed to a system, method and article of manufacture for accessing data represented abstractly through an abstraction model. In one embodiment, a data repository abstraction layer provides a logical view of an underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs conversion of an abstract query (i.e., a request for results or a request to modify data) into a form that can be used against a particular physical data representation. Abstract and/or physical queries are transformed according to model entities which define a relationship between logical fields of the data repository abstraction layer.

    摘要翻译: 本发明一般涉及通过抽象模型抽象地访问数据的系统,方法和制品。 在一个实施例中,数据存储库抽象层提供独立于数据表示的特定方式的底层数据存储库的逻辑视图。 还提供查询抽象层,并基于数据库抽象层。 运行时组件执行将抽象查询(即,对结果的请求或修改数据的请求)转换成可以针对特定物理数据表示使用的形式。 根据定义数据库抽象层的逻辑字段之间的关系的模型实体来转换抽象和/或物理查询。

    AUTOMATED DATA MODEL EXTENSION THROUGH DATA CRAWLER APPROACH

    公开(公告)号:US20080154975A1

    公开(公告)日:2008-06-26

    申请号:US12041854

    申请日:2008-03-04

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30864

    摘要: Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.

    Automated data model extension through data crawler approach
    9.
    发明授权
    Automated data model extension through data crawler approach 失效
    通过数据抓取方式自动数据模型扩展

    公开(公告)号:US08165989B2

    公开(公告)日:2012-04-24

    申请号:US12041854

    申请日:2008-03-04

    IPC分类号: G06F17/00 G06F7/00 G06F17/30

    CPC分类号: G06F17/30864

    摘要: Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.

    摘要翻译: 用于访问存储在多个数据源中的数据的方法,系统和制品。 这样的方法使用自动化软件代理来维护可用于查询的数据源的集合。 数据源可以全部驻留在单个本地网络中,或者可以分布在多个位置。 通常,自动化软件代理根据定义的选择标准集搜索给定域中的附加数据源。 在发现附加数据源之后,自动化软件代理配置查询应用程序以反映可用性附加数据源。 此外,自动软件代理可以根据选择标准周期性地评估数据源的收集,并去除不再可用或不再满足选择标准的那些。

    Linked logical fields
    10.
    发明授权
    Linked logical fields 失效
    链接的逻辑字段

    公开(公告)号:US08140595B2

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

    申请号:US12038885

    申请日:2008-02-28

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30389 G06F17/30427

    摘要: A method, system and article of manufacture for linking logical fields abstractly describing data in a database and, more particularly, for creating an abstract query using linked logical fields. One embodiment provides a method of linking logical fields abstractly describing data in a database. The method includes creating link information for a first logical field from the plurality of logical fields. The link information identifies at least one second logical field from the plurality of logical fields and an associated link type operation. The first and second logical fields are linked using the link information.

    摘要翻译: 用于链接逻辑领域的方法,系统和制品,用于抽象地描述数据库中的数据,更具体地,用于使用链接的逻辑字段创建抽象查询。 一个实施例提供了一种将抽象地描述数据库中的数据的逻辑域相关联的方法。 该方法包括从多个逻辑字段创建用于第一逻辑字段的链接信息。 链接信息从多个逻辑字段和相关联的链接类型操作中识别至少一个第二逻辑字段。 使用链接信息链接第一和第二逻辑字段。