Database staging area read-through or forced flush with dirty notification
    1.
    发明授权
    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.

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

    Security model using security domains in a security model applied to abstract database
    3.
    发明授权
    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
    4.
    发明申请
    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.

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

    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.

    Method and system for managing execution of data driven workflows
    6.
    发明授权
    Method and system for managing execution of data driven workflows 有权
    用于管理数据驱动工作流的执行的方法和系统

    公开(公告)号:US08650152B2

    公开(公告)日:2014-02-11

    申请号:US10857722

    申请日:2004-05-28

    IPC分类号: G06F17/00

    CPC分类号: G06Q10/06

    摘要: Methods, articles of manufacture and systems for managing execution of workflows. One embodiment provides a computer-implemented method for managing execution of a data driven multi-step workflow. The method includes receiving input data for a step of the workflow and performing the step of the workflow on the input data to obtain a result set. Then, at least one rule is applied to the result set for determining whether one or more associated conditions are satisfied. The at least one rule defines the one or more associated conditions and an associated process. If the one or more associated conditions are satisfied, the associated process is performed on the result set.

    摘要翻译: 方法,制作工具和管理工作流执行的系统。 一个实施例提供了一种用于管理数据驱动的多步骤工作流的执行的计算机实现的方法。 该方法包括接收工作流步骤的输入数据,并对输入数据执行工作流的步骤以获得结果集。 然后,至少一个规则被应用于结果集合以确定是否满足一个或多个相关联的条件。 所述至少一个规则定义所述一个或多个相关联的条件和相关联的过程。 如果满足一个或多个相关联的条件,则对结果集执行相关联的处理。

    Well organized query result sets
    7.
    发明授权
    Well organized query result sets 失效
    组织良好的查询结果集

    公开(公告)号:US08131744B2

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

    申请号:US11016202

    申请日:2004-12-17

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30554

    摘要: Methods, apparatus, and articles of manufacture for processing an abstract query and generating well organized user results are disclosed. Well organized user results preserve the cardinality of one-to-one and one-to-many between data elements retrieved using a database query. Embodiments of the present invention use an abstract database that separates a user from the physical representation of data stored in a data repository by providing a plurality of logical fields based on the substantive information stored in the underlying data repository. During query processing, query results generated from an abstract query are generated and organized according to the one-to-one and one-to-many relationships. Subsequently, query results are presented to users according to the intuitive relationships between data understood by users of an abstract database.

    摘要翻译: 公开了用于处理抽象查询并生成良好组织的用户结果的方法,装置和制品。 有组织的用户结果保留使用数据库查询检索的数据元素之间的一对一和一对多的基数。 本发明的实施例使用抽象数据库,其通过基于存储在底层数据存储库中的实质性信息提供多个逻辑字段来将用户与存储在数据存储库中的数据的物理表示分离。 在查询处理期间,根据一对一和一对多关系生成和组织从抽象查询生成的查询结果。 随后,根据抽象数据库用户理解的数据之间的直观关系向用户提供查询结果。

    Creating a logical table from multiple differently formatted physical tables having different access methods
    8.
    发明授权
    Creating a logical table from multiple differently formatted physical tables having different access methods 有权
    从具有不同访问方式的多个不同格式的物理表创建逻辑表

    公开(公告)号:US08112459B2

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

    申请号:US11016203

    申请日:2004-12-17

    IPC分类号: G06F17/30

    摘要: Embodiments of the present invention provide methods for constructing a database abstraction model that includes logical fields that map to a logical table. The logical table is constructed using data extracted from multiple, differently formatted physical tables. The logical table allows logically related data stored in multiple databases to appear as data from a single table. Relationships between data stored in multiple, differently formatted databases are maintained and logical fields that include multiple access methods that map to the multiple databases are replaced with a single access method that maps to the logical table. Data relationships that are defined for the database abstraction model are modified to reflect the logical table.

    摘要翻译: 本发明的实施例提供了构建数据库抽象模型的方法,该模型包括映射到逻辑表的逻辑字段。 使用从多个不同格式的物理表提取的数据构建逻辑表。 逻辑表允许存储在多个数据库中的逻辑相关数据显示为来自单个表的数据。 维护存储在多个不同格式的数据库中的数据之间的关系,并且将包含映射到多个数据库的多个访问方法的逻辑字段替换为映射到逻辑表的单个访问方法。 为数据库抽象模型定义的数据关系被修改以反映逻辑表。

    Field-to-field join constraints
    9.
    发明授权
    Field-to-field join constraints 有权
    字段到字段连接约束

    公开(公告)号:US07526471B2

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

    申请号:US11016215

    申请日:2004-12-17

    IPC分类号: G06F7/00 G06F17/30

    摘要: Embodiments of the present invention generally provide methods systems and articles of manufacture for query processing and for constructing a database abstraction model over an underlying physical database. The database abstraction model allows users to compose an abstract query using a logical view of data, instead of using the view of the underlying database architecture. Embodiments of the invention constrain the results returned from processing an abstract query according to relationships that exist for a group of logical fields. First, a group of logical fields may be related because they are part of a logical set. Field-to-field join constraints specify the logical fields that form a set, and an instance indicator used to determine the particular instance of a set that an element of data belongs to, according to a discrimination rule. Second, logical fields may be related because they are part of a series, and an instance identifier may provide an ordering rule used to determine the order of data elements that form the series.

    摘要翻译: 本发明的实施例通常提供用于查询处理和在底层物理数据库上构建数据库抽象模型的方法系统和制品。 数据库抽象模型允许用户使用数据的逻辑视图来组合抽象查询,而不是使用底层数据库体系结构的视图。 本发明的实施例约束根据对于一组逻辑字段存在的关系来处理抽象查询返回的结果。 首先,一组逻辑字段可能是相关的,因为它们是逻辑集的一部分。 根据歧视规则,字段到字段连接约束指定形成集合的逻辑字段和用于确定数据元素所属集合的特定实例的实例指示符。 第二,逻辑字段可能是相关的,因为它们是一系列的一部分,并且实例标识符可以提供用于确定形成系列的数据元素的顺序的排序规则。

    Metadata management for a data abstraction model
    10.
    发明授权
    Metadata management for a data abstraction model 失效
    数据抽象模型的元数据管理

    公开(公告)号:US07505958B2

    公开(公告)日:2009-03-17

    申请号:US10955467

    申请日:2004-09-30

    IPC分类号: G06F17/30

    摘要: A method, system and article of manufacture for managing metadata associated with a data abstraction model abstractly describing data in a database. One embodiment provides a method of managing metadata describing objects of a data abstraction model with logical fields that define abstract views of physical data in a database. The method comprises 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. The method further comprises 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.

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