Well organized query result sets
    42.
    发明授权
    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.

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

    Field-to-field join constraints
    43.
    发明授权
    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.

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

    Context insensitive model entity searching
    44.
    发明授权
    Context insensitive model entity searching 失效
    上下文不敏感的模型实体搜索

    公开(公告)号:US07689555B2

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

    申请号:US11035567

    申请日:2005-01-14

    IPC分类号: G06F7/00

    摘要: Methods, systems, and articles of manufacture for context insensitive model entity searching are provided. A model entity is used to identify to a central entity or concept modeled by a database abstraction model. Instances of a model entity may be defined in reference to an identifier in an underlying database. Model entity relationships specify relationships between the model entity and other datasets in the database (e.g., tables of a relational database). A database abstraction model provides an interface to both the model entity and the data in the underlying database. Rather than creating a query of the database using a series of restrictive conditions, or selecting individual the tables or datasets to search, a user may specify search term(s). Instances of the model entity containing the search term(s), regardless of where the search term(s) occur in the underlying database, are returned for the search. Thereafter, a user may select individual instances of the model entity to view in greater detail.

    摘要翻译: 提供了上下文不敏感模型实体搜索的方法,系统和制造。 模型实体用于识别由数据库抽象模型建模的中央实体或概念。 参照基础数据库中的标识符可以定义模型实体的实例。 模型实体关系指定模型实体与数据库中其他数据集之间的关系(例如,关系数据库的表)。 数据库抽象模型为模型实体和底层数据库中的数据提供了一个接口。 不是使用一系列限制性条件创建数据库的查询,或者选择单独的表或数据集进行搜索,用户可以指定搜索项。 返回包含搜索项的模型实体的实例,而不管基础数据库中出现搜索项的位置。 此后,用户可以更详细地选择模型实体的各个实例。

    Query condition building using predefined query objects
    45.
    发明授权
    Query condition building using predefined query objects 有权
    使用预定义查询对象查询条件构建

    公开(公告)号:US07584178B2

    公开(公告)日:2009-09-01

    申请号:US11408188

    申请日:2006-04-20

    摘要: A method, system and article of manufacture for query processing and, more particularly, for managing execution of a query against data in a database. One embodiment comprises receiving a query having (i) at least one result field configured to return data from at least one data record included with the database, and (ii) a query condition comprising a field and a query object associated with the field by an operator configured to select values for the field from the query object. The method further comprises determining whether the query object is configured to provide one or more valid values for the field. If the query object is not configured to provide one or more valid values for the field, the query object is transformed into a transformed query object that is configured to provide one or more valid values for the field. Then, the query is executed against the database.

    摘要翻译: 用于查询处理的方法,系统和制品,更具体地,用于管理对数据库中的数据的查询执行。 一个实施例包括接收具有(i)至少一个结果字段的查询,所述结果字段被配置为从包含在数据库中的至少一个数据记录返回数据,以及(ii)查询条件,其包括通过字段与字段相关联的字段和查询对象 操作员配置为从查询对象中选择字段的值。 所述方法还包括确定所述查询对象是否被配置为为所述字段提供一个或多个有效值。 如果查询对象未配置为为该字段提供一个或多个有效值,则将查询对象转换为已配置为为该字段提供一个或多个有效值的转换查询对象。 然后,针对数据库执行查询。

    DATABASE STAGING AREA READ-THROUGH OR FORCED FLUSH WITH DIRTY NOTIFICATION
    46.
    发明申请
    DATABASE STAGING AREA READ-THROUGH OR FORCED FLUSH WITH DIRTY NOTIFICATION 有权
    数据库分类区域读取或强制通知,具有无效通知

    公开(公告)号:US20090100034A1

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

    申请号:US12343340

    申请日:2008-12-23

    IPC分类号: G06F7/06 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.

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

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

    公开(公告)号:US07469244B2

    公开(公告)日:2008-12-23

    申请号:US11290893

    申请日:2005-11-30

    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.

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

    Electronic health record transaction monitoring
    49.
    发明授权
    Electronic health record transaction monitoring 有权
    电子健康记录交易监控

    公开(公告)号:US08423382B2

    公开(公告)日:2013-04-16

    申请号:US11241706

    申请日:2005-09-30

    IPC分类号: G06Q50/00

    摘要: Method, apparatus and article of manufacture for providing individuals with notifications pertaining to use of health records. In one embodiment, a network-accessible storage repository is configured to store a plurality of electronic health records regarding a plurality of individuals. Requests to access selective records of the plurality of individuals are received over a data communications network. For each individual whose respective records are accessed, a report is generated describing the access. The reports may then be provided to the respective individuals.

    摘要翻译: 为个人提供有关使用健康记录的通知的方法,设备和制品。 在一个实施例中,网络可访问存储库被配置为存储关于多个个体的多个电子健康记录。 通过数据通信网络接收访问多个个人的选择性记录的请求。 对于访问其各自记录的每个人,将生成描述访问的报告。 然后可以向相应个人提供报告。

    System and method for managing access to data in a database
    50.
    发明授权
    System and method for managing access to data in a database 失效
    管理数据库中数据访问的系统和方法

    公开(公告)号:US08280907B2

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

    申请号:US11290895

    申请日:2005-11-30

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F21/6227

    摘要: A method, system and article of manufacture for data processing and more particularly for managing access to data in a database that should be available for a limited number of accesses. One embodiment provides a method comprising receiving, from a requesting entity, a query against a database having consumable data that is configured to be accessible for only a predefined number of accesses. The query is configured to access the consumable data and is executed against the database to obtain a query result that includes the consumable data. The method further comprises determining whether the predefined number of accesses is reached as a result of the execution of the query against the database. If so, the consumable data is made inaccessible. The obtained query result is returned to the requesting entity.

    摘要翻译: 一种用于数据处理的方法,系统和制品,更具体地涉及用于管理数据库中对于有限数量访问可用的数据的访问。 一个实施例提供了一种方法,包括从请求实体接收针对具有被配置为仅对预定数量的访问可访问的可消耗数据的数据库的查询。 该查询被配置为访问消耗品数据并针对数据库执行以获得包括消耗品数据的查询结果。 该方法还包括:作为对数据库执行查询的结果,确定是否达到预定数量的访问。 如果是这样,消耗品数据就无法访问。 获取的查询结果返回给请求实体。