公开(公告)号：US20060224574A1

公开(公告)日：2006-10-05

申请号：US11424156

申请日：2006-06-14

申请人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

发明人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

IPC分类号： G06F17/30

CPC分类号： G06F16/903 ,  G06F16/2428 ,  Y10S707/99933 ,  Y10S707/99945 ,  Y10S715/968

摘要： A method, apparatus and article of manufacture provide a user interface allowing user selection and arrangement of result fields selected, in one embodiment, from a logical model. In one embodiment, the user interface is a graphical user interface and comprises input cells for user-selected logical result fields. The cells are arranged to define a geometric relationship between logical result fields which dictates the combinatorial statement type by which the logical result fields in the cells are related in a query.

摘要翻译： 一种方法，装置和制品提供用户界面，允许用户在一个实施例中从逻辑模型中选择和排列结果字段。 在一个实施例中，用户界面是图形用户界面，并且包括用于用户选择的逻辑结果字段的输入单元。 这些单元被设置为定义逻辑结果字段之间的几何关系，这些字段指示单元格中的逻辑结果字段在查询中相关联的组合语句类型。

公开(公告)号：US20080120331A1

公开(公告)日：2008-05-22

申请号：US12023845

申请日：2008-01-31

申请人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

发明人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

IPC分类号： G06F17/30

CPC分类号： G06F17/30398

摘要： Methods, systems, and articles of manufacture that may be used to create and share annotations for query components, such as query conditions, in an effort to share domain knowledge, are provided. The annotations may be created by users with particular domain knowledge and may contain information useful to other users when building queries including the annotated query components. An annotation may indicate a particular format or syntax for an associated query component. In some cases, a replacement to the associated query component is suggested.

公开(公告)号：US20050038788A1

公开(公告)日：2005-02-17

申请号：US10640814

申请日：2003-08-14

申请人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

发明人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

IPC分类号： G06F17/00 ,  G06F21/00

CPC分类号： G06F21/6227

摘要： Methods, systems, and articles of manufacture that may be used to prevent sensitive information from being divulged in an annotation are provided. Upon creation, modification and/or retrieval of an annotation, a set of predefined security rules may be applied to the annotation, in an effort to detect sensitive information contained therein. Upon detecting sensitive information in an annotation, appropriate security measures may be taken, such as notifying a user creating, modifying, or retrieving the annotation (e.g., prompting the user to modify annotation to remove the sensitive information), preventing entry of the annotation, and/or notifying appropriate personnel in charge of security, such as a system administrator.

摘要翻译： 提供了可用于防止敏感信息在注释中泄露的方法，系统和制造。 在注释的创建，修改和/或检索之后，可以将一组预定义的安全规则应用于注释，以便检测其中包含的敏感信息。 在检测到注释中的敏感信息时，可以采取适当的安全措施，例如通知用户创建，修改或检索注释（例如，提示用户修改注释以移除敏感信息），防止注释的输入， 和/或通知负责安全的适当人员，如系统管理员。

公开(公告)号：US20050010557A1

公开(公告)日：2005-01-13

申请号：US10618409

申请日：2003-07-11

申请人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

发明人： Richard Dettinger ,  Cale Rath ,  Richard Stevens

IPC分类号： G06F17/30

CPC分类号： G06F17/30398 ,  G06F17/30964 ,  Y10S707/99933 ,  Y10S707/99945 ,  Y10S715/968

摘要： A method, apparatus and article of manufacture provide a user interface allowing user selection and arrangement of result fields selected, in one embodiment, from a logical model. In one embodiment, the user interface is a graphical user interface and comprises input cells for user-selected logical result fields. The cells are arranged to define a geometric relationship between logical result fields which dictates the combinatorial statement type by which the logical result fields in the cells are related in a query.

摘要翻译： 一种方法，装置和制品提供用户界面，允许用户在一个实施例中从逻辑模型中选择和排列结果字段。 在一个实施例中，用户界面是图形用户界面，并且包括用于用户选择的逻辑结果字段的输入单元。 这些单元被设置为定义逻辑结果字段之间的几何关系，这些字段指示单元格中的逻辑结果字段在查询中相关联的组合语句类型。

公开(公告)号：US20050234878A1

公开(公告)日：2005-10-20

申请号：US10821149

申请日：2004-04-08

申请人： Richard Dettinger ,  Dan Kolz ,  Richard Stevens ,  Shannon Wenzel

发明人： Richard Dettinger ,  Dan Kolz ,  Richard Stevens ,  Shannon Wenzel

IPC分类号： G06F12/00 ,  G06F17/30 ,  G06F7/00

CPC分类号： G06F17/3041 ,  G06F17/30395

摘要： Methods, systems and articles of manufacture for managing parameterized queries and making them available to users based on associations between parameterized queries and fields belonging to result sets are provided. By associating fields with parameterized queries, a query manager can be configured to provide users with a contextually appropriate selection of parameterized queries that can be used to obtain data related to objects in a result set. The selection of parameterized queries may be provided to users via a variety of interfaces including graphic interfaces and plug-in components utilized by external applications.

摘要翻译： 提供了用于管理参数化查询并基于参数化查询与属于结果集合的字段之间的关联使其可用的方法，系统和制造。 通过将字段与参数化查询相关联，可以将查询管理器配置为向用户提供可用于获取与结果集中的对象相关的数据的参数化查询的上下文相关选择。 参数化查询的选择可以通过包括图形界面和外部应用程序使用的插件组件的各种接口提供给用户。

公开(公告)号：US20070150489A1

公开(公告)日：2007-06-28

申请号：US11316246

申请日：2005-12-22

申请人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens

发明人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens

IPC分类号： G06F7/00

CPC分类号： G06F16/245

摘要： A method and apparatus for representing a continuum of data as a rolling column within a relational model is disclosed. Data from a continuous data source may be used to populate a rolling column. Metadata defining the rolling column specifies the correct portion of data from the continuum of data that should be used to populate the rolling column. Whenever data from the rolling column is included in a data access request, such as a database query, a database management system may be configured to update the rolling column, according to the metadata.

摘要翻译： 公开了一种用于在关系模型内表示作为滚动列的连续数据的方法和装置。 来自连续数据源的数据可用于填充滚动列。 定义滚动列的元数据指定了应该用于填充滚动列的数据的连续数据中正确的数据部分。 每当来自滚动列的数据被包括在诸如数据库查询的数据访问请求中时，可以配置数据库管理系统以根据元数据来更新滚动列。

公开(公告)号：US20070078856A1

公开(公告)日：2007-04-05

申请号：US11241697

申请日：2005-09-30

申请人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens

发明人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens

IPC分类号： G06F17/30

CPC分类号： G06F17/30545 ,  G06F19/00 ,  G16H10/60

摘要： A method, apparatus, and article of manufacture are provided to optimize the time and effort required to locate all data on a given entity that may span multiple data nodes in a distributed environment. For example, embodiments of the invention may be used to locate nodes within the distributed environment that store electronic healthcare records. A poll request from a first node to a second node may include electronic records existence data indicating data nodes known to have, or not have, records related to a given individual. This information is used to minimize the number of nodes that need to be polled to arrive at the complete aggregation of patient records that exist within a given set of nodes.

摘要翻译： 提供了一种方法，装置和制品，以优化在分布式环境中跨越多个数据节点的给定实体上定位所有数据所需的时间和精力。 例如，本发明的实施例可以用于定位存储电子保健记录的分布式环境中的节点。 从第一节点到第二节点的轮询请求可以包括指示已知具有或不具有与给定个体有关的记录的数据节点的电子记录存在数据。 该信息用于最小化需要轮询的节点的数量，以获得存在于给定的一组节点内的患者记录的完整聚合。

公开(公告)号：US20060136469A1

公开(公告)日：2006-06-22

申请号：US11016203

申请日：2004-12-17

申请人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens ,  Jeffrey Tenner

发明人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens ,  Jeffrey Tenner

IPC分类号： G06F17/00

CPC分类号： G06F17/30566 ,  G06F17/30427 ,  G06F17/30545

摘要： 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.

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

公开(公告)号：US20060047638A1

公开(公告)日：2006-03-02

申请号：US10932709

申请日：2004-09-02

申请人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens ,  Jeffrey Tenner

发明人： Richard Dettinger ,  Daniel Kolz ,  Richard Stevens ,  Jeffrey Tenner

IPC分类号： G06F17/30

CPC分类号： G06F16/24542

摘要： A method, system and article of manufacture for query processing and, more particularly, for determining that Cartesian Products will occur in query results without executing corresponding queries. One embodiment provides a method for detecting Cartesian Products in query results. The method comprises identifying, from a query against one or more databases, joins between different tables of the one or more databases. Without executing the query against the one or more databases, it is determined on the basis of cardinalities of the identified joins whether a Cartesian Product will occur in a query result corresponding to the query.

摘要翻译： 用于查询处理的方法，系统和制品，更具体地，用于确定笛卡尔乘积将在查询结果中发生而不执行相应的查询。 一个实施例提供了一种在查询结果中检测笛卡儿积分的方法。 该方法包括从针对一个或多个数据库的查询中识别一个或多个数据库的不同表之间的连接。 在不执行针对一个或多个数据库的查询的情况下，基于所识别的联接的基数来确定在对应于查询的查询结果中是否将出现笛卡尔乘积。

公开(公告)号：US20070250472A1

公开(公告)日：2007-10-25

申请号：US11408188

申请日：2006-04-20

申请人： Richard Dettinger ,  Daniel Kolz ,  Fred Kulack ,  Richard Stevens

发明人： Richard Dettinger ,  Daniel Kolz ,  Fred Kulack ,  Richard Stevens

IPC分类号： G06F17/30

CPC分类号： G06F17/30477 ,  G06F17/30595 ,  Y10S707/99933

摘要： 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）查询条件，其包括通过字段与字段相关联的字段和查询对象 操作员配置为从查询对象中选择字段的值。 所述方法还包括确定所述查询对象是否被配置为为所述字段提供一个或多个有效值。 如果查询对象未配置为为该字段提供一个或多个有效值，则将查询对象转换为已配置为为该字段提供一个或多个有效值的转换查询对象。 然后，针对数据库执行查询。