专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08886632B2 Abstract query plan 有权
标题翻译：抽象查询计划
公开(公告)号：US08886632B2
公开(公告)日：2014-11-11
申请号：US11953935
申请日：2007-12-11
申请人： Richard D. Dettinger , Daniel P. Kolz
发明人： Richard D. Dettinger , Daniel P. Kolz
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30436 , G06F17/30474 , G06F17/30545 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： A method and apparatus, and article of manufacture are provided to process an abstract query of a database abstraction constructed over an underlying physical data storage mechanism. The database may comprise a single data source, or a federated source spanning multiple systems. Embodiments of the invention process an abstract query by generating an intermediate representation of the abstract query. In one embodiment, the intermediate representation comprises an abstract query plan. An abstract query plan includes a combination of elements from the data abstraction model and elements relating to the underlying physical data storage mechanism. Once generated, a back-end component may easily traverse the abstract query plan to generate an SQL statement (or other resolved query) corresponding to the abstract query. Further, once constructed, the abstract query plan provides a platform for many different optimizations that may be selected by a user or by the runtime component inspecting the abstract query plan prior to creating the resolved query.
摘要翻译：提供了一种方法和装置以及制造物品来处理在底层物理数据存储机构上构建的数据库抽象的抽象查询。数据库可以包括单个数据源或跨越多个系统的联合源。本发明的实施例通过生成抽象查询的中间表示来处理抽象查询。在一个实施例中，中间表示包括抽象查询计划。抽象查询计划包括来自数据抽象模型的元素和与底层物理数据存储机制相关的元素的组合。一旦生成，后端组件可以容易地遍历抽象查询计划以生成与抽象查询相对应的SQL语句（或其他已解析的查询）。此外，一旦构造，抽象查询计划为许多不同的优化提供了一个平台，可以由用户或运行时组件在创建解析的查询之前检查抽象查询计划来选择。

2. 发明授权

US08166070B2 Techniques for sharing persistently stored query results between multiple users 有权
标题翻译：在多个用户之间共享持久存储的查询结果的技术
公开(公告)号：US08166070B2
公开(公告)日：2012-04-24
申请号：US12175321
申请日：2008-07-17
申请人： Richard D. Dettinger , Judy I. Djugash , Daniel P. Kolz
发明人： Richard D. Dettinger , Judy I. Djugash , Daniel P. Kolz
IPC分类号： G06F17/30
CPC分类号： G06F21/6227 , Y10S707/99933 , Y10S707/99939
摘要： A method, system and article of manufacture for managing access to query results and, more particularly, for managing access by multiple users to persistently stored query results, whereby at least some of the users may have different access rights. One embodiment provides a method of managing access to a query result obtained upon execution of a query against one or more databases. The method comprises creating security information configured for restricting access to the query result. The security information is associated with the query result. Access to some or all of the query result is granted to a requesting entity on the basis of the security information and an attribute of the requesting entity.
摘要翻译：一种用于管理对查询结果的访问的方法，系统和制品，更具体地，用于管理多个用户对永久存储的查询结果的访问，由此至少一些用户可以具有不同的访问权限。一个实施例提供了一种管理对针对一个或多个数据库执行查询获得的查询结果的访问的方法。该方法包括创建配置用于限制访问查询结果的安全信息。安全信息与查询结果相关联。基于安全信息和请求实体的属性，向请求实体授予访问部分或全部查询结果的权限。

3. 发明授权

US08122012B2 Abstract record timeline rendering/display 失效
标题翻译：抽象记录时间线渲染/显示
公开(公告)号：US08122012B2
公开(公告)日：2012-02-21
申请号：US11035565
申请日：2005-01-14
申请人： Richard D. Dettinger , Daniel P. Kolz
发明人： Richard D. Dettinger , Daniel P. Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30286
摘要： Embodiments of the invention provide techniques for constructing a database abstraction model over an underlying physical database. Once constructed, users may interact with the database abstraction model, rather than the underlying physical database representation, to query the database and view query results. In one embodiment, information is retrieved from the underlying physical database that is related to a model entity and displayed on a timeline. Generally, a model entity identifies the logical focus, or the central entity, being queried by user interacting with a query application. An abstract record identifies what data about each model entity is available to query using the database abstraction model.
摘要翻译：本发明的实施例提供了用于在底层物理数据库上构建数据库抽象模型的技术。一旦构建，用户可以与数据库抽象模型进行交互，而不是基础物理数据库表示，来查询数据库和查看查询结果。在一个实施例中，从与模型实体相关并在时间线上显示的底层物理数据库检索信息。通常，模型实体标识用户与查询应用程序交互查询的逻辑焦点或中心实体。抽象记录使用数据库抽象模型来识别每个模型实体可用于查询的数据。

4. 发明授权

US08010499B2 Database staging area read-through or forced flush with dirty notification 有权
标题翻译：数据库分段区读取或强制与脏通知冲洗
公开(公告)号：US08010499B2
公开(公告)日：2011-08-30
申请号：US12343340
申请日：2008-12-23
申请人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens
发明人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens
IPC分类号： G06F17/30
CPC分类号： G06F17/30501 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99953
摘要： 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.
摘要翻译：本发明的实施例允许利用可以存储在暂存区数据存储中的相关数据来增加对操作数据存储的查询的结果。在接收到对操作数据存储的查询后，确定与该查询相关的数据是否存在于暂存区数据存储区中。如果存在相关数据，则可以将这些数据转换，传输并与操作数据存储区中的数据组合。然后针对组合的数据运行查询，并向用户显示结果。

5. 发明授权

US07949652B2 Filtering query results using model entity limitations 失效
标题翻译：使用模型实体限制过滤查询结果
公开(公告)号：US07949652B2
公开(公告)日：2011-05-24
申请号：US12195159
申请日：2008-08-20
申请人： Richard D. Dettinger , Daniel P. Kolz , Shannon E. Wenzel
发明人： Richard D. Dettinger , Daniel P. Kolz , Shannon E. Wenzel
IPC分类号： G06F7/00
CPC分类号： G06F17/30392 , Y10S707/962 , Y10S707/99933 , Y10S707/99937
摘要： A method, system, and article of manufacture to process database queries are disclosed. One embodiment comprises receiving an abstract query against a database having a multiplicity of data records. The abstract query identifies a model entity that defines a focus of the abstract query. The method further comprises receiving a limitation request configured to restrict a result set for the abstract query. The limitation request specifies a limitation on data records that are returned for one or more instances of the underlying model entity. From the abstract query, an executable query capable of being executed by a query engine is generated. The executable query is modified on the basis of the limitation request. The modified executable query is executed against the database to obtain the result set, whereby the result set is restricted as requested by the limitation request.
摘要翻译：公开了一种处理数据库查询的方法，系统和制品。一个实施例包括针对具有多个数据记录的数据库接收抽象查询。抽象查询标识定义抽象查询焦点的模型实体。该方法还包括接收被配置为限制抽象查询的结果集的限制请求。限制请求指定对基础模型实体的一个或多个实例返回的数据记录的限制。从抽象查询，生成能够被查询引擎执行的可执行查询。可执行查询根据限制请求进行修改。针对数据库执行修改的可执行查询以获得结果集，由此限制请求的请求限制结果集。

6. 发明授权

US07844618B2 Techniques for managing interdependent data objects 有权
标题翻译：用于管理相互依赖的数据对象的技术
公开(公告)号：US07844618B2
公开(公告)日：2010-11-30
申请号：US12019458
申请日：2008-01-24
申请人： Mark A. Brodhun , Richard D. Dettinger , Daniel P. Kolz
发明人： Mark A. Brodhun , Richard D. Dettinger , Daniel P. Kolz
IPC分类号： G06F7/00
CPC分类号： G06F17/30604 , Y10S707/955 , Y10S707/99933
摘要： System and article of manufacture for managing modifications to at least one of a plurality of interdependent data objects. A computer-readable storage medium contains a program which, when executed by a processor, performs operations for managing modifications to at least one of a plurality of interdependent data objects. The operations include receiving a request for modification of a given data object having at least one dependent data object and accessing a directory of dependencies containing records for each of the interdependent data objects including the at least one dependent data object. Each record describes an interdependency between at least two of the interdependent data objects. A record for the at least one dependent data object describes an interdependency between the given data object and the at least one dependent data object. Using the accessed directory of dependencies, the interdependency between the given data object and the at least one dependent data object is identified. On the basis that the identified interdependency presents a possible undesired consequence if the requested modification is performed, a predefined action is performed.
摘要翻译：用于管理对多个相互依赖数据对象中的至少一个的修改的系统和制品。计算机可读存储介质包含程序，当由处理器执行时，执行用于管理对多个相互依赖的数据对象中的至少一个的修改的操作。操作包括接收对具有至少一个依赖数据对象的给定数据对象的修改的请求，并且访问包含每个包括至少一个从属数据对象的相互依赖的数据对象的记录的依赖关系的目录。每个记录描述了至少两个相互依赖的数据对象之间的相互依赖关系。至少一个依赖数据对象的记录描述给定数据对象与至少一个从属数据对象之间的相互依赖关系。使用所访问的依赖目录，识别给定数据对象与至少一个从属数据对象之间的相互依赖关系。基于所确定的相互依赖性在执行所请求的修改时呈现可能的不期望的结果，执行预定义的动作。

7. 发明授权

US07693857B2 Clinical genomics merged repository and partial episode support with support abstract and semantic meaning preserving data sniffers 有权
标题翻译：临床基因组合并存储库和部分情节支持，支持抽象和语义保留数据嗅探器
公开(公告)号：US07693857B2
公开(公告)日：2010-04-06
申请号：US11282094
申请日：2005-11-17
申请人： Richard D. Dettinger , Thomas J. Eggebraaten , Daniel P. Kolz , Richard J. Stevens
发明人： Richard D. Dettinger , Thomas J. Eggebraaten , Daniel P. Kolz , Richard J. Stevens
IPC分类号： G06F7/00 , G06F17/30 , G06Q50/00
CPC分类号： G06Q50/22 , G06F19/00 , G16H10/60
摘要： Method, apparatus and article of manufacture for processing and storing medical episode data with workflow status designations. In one embodiment, a patient episode data is moved from differentiated data stores, via an information broker, to assigned data handlers. The data handlers then pass their respective data to a loader and shredder application. The shredder application is tasked with storing the episode data in the database repository and updating each episode's status.
摘要翻译：用于处理和存储具有工作流状态指定的医疗情节数据的方法，装置和制品。在一个实施例中，患者情节数据从差异数据存储经由信息中介器移动到分配的数据处理程序。然后，数据处理程序将其各自的数据传递给装载机和粉碎机应用程序。破碎机应用程序的任务是将剧集数据存储在数据库存储库中，并更新每个剧集的状态。

8. 发明授权

US07672936B2 Security model using security domains in a security model applied to abstract database 有权
标题翻译：安全模型在应用于抽象数据库的安全模型中使用安全域
公开(公告)号：US07672936B2
公开(公告)日：2010-03-02
申请号：US11693478
申请日：2007-03-29
申请人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
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.
摘要翻译：本发明一般涉及一种用于根据过去由实体访问的数据来控制对授权实体授予的数据的访问的方法，系统和制品。另外，本发明的实施例允许独立于物理表示数据的特定方式的访问控制。通常，抽象层被提供以表示可供应用使用的各种数据源，并且构成应用程序使用的查询访问和/或更新这些数据源中包含的信息。运行时组件负责使用数据存储库抽象组件（抽象层之一）中包含的信息将抽象查询解析为对一个或多个数据存储库的具体数据访问请求。通常，数据被组织成一系列域。在每个域内，数据与一个帐户相关联。监视用户活动，并且当访问与一个帐户相关联的数据时，随后可以禁止用户从同一域内的相关帐户访问数据。

9. 发明申请

US20100030774A1 MODEL ENTITY OPERATIONS IN QUERY RESULTS 失效
标题翻译：查询结果中的模型实体操作
公开(公告)号：US20100030774A1
公开(公告)日：2010-02-04
申请号：US12577244
申请日：2009-10-12
申请人： Richard D. Dettinger , Daniel P. Kolz
发明人： Richard D. Dettinger , Daniel P. Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30395 , Y10S707/99933 , Y10S707/99944 , Y10S707/99945
摘要： The present invention provides systems and articles of manufacture that enhance the capability of a database abstraction model and query application constructed for an underlying physical database. Typically, the query application is used to compose and execute an abstract query. Once an initial query result is presented to a user, a user may select to execute a model entity operation by interacting with a query interface of the query application. A model entity operation allows the user to retrieve additional information from the underlying database, based on information included in the initial query result, without having to create a new query or having to correlate the results of multiple queries.
摘要翻译：本发明提供了增强针对底层物理数据库构建的数据库抽象模型和查询应用的能力的系统和制品。通常，查询应用程序用于撰写和执行抽象查询。一旦向用户呈现初始查询结果，用户可以选择通过与查询应用的查询界面交互来执行模型实体操作。模型实体操作允许用户基于初始查询结果中包含的信息从底层数据库检索附加信息，而不必创建新查询或必须将多个查询的结果相关联。

10. 发明授权

US07624098B2 Generating suitable data for statistical analysis 失效
标题翻译：生成适合的数据进行统计分析
公开(公告)号：US07624098B2
公开(公告)日：2009-11-24
申请号：US11246828
申请日：2005-10-07
申请人： Richard D. Dettinger , Daniel P. Kolz
发明人： Richard D. Dettinger , Daniel P. Kolz
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/30595 , G06F17/30923 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method, system and article of manufacture for processing abstract queries and, more particularly, for generating input to statistical analysis routines. One embodiment comprises receiving an abstract query including a measurement field and a chronological reference condition. The abstract query is transformed into an executable query which is executed by a query engine, whereby result data is determined including an available measurement value for the measurement field. The available measurement value was taken at a point in time different from a point in time that satisfies the chronological reference condition. The method further comprises determining a variance value corresponding to a time variance between the point in time that satisfies the chronological reference condition and the other point in time at which the available measurement value was taken. As a result set for the abstract query, the available measurement value and the variance value are returned.
摘要翻译：一种用于处理抽象查询的方法，系统和制品，更具体地，用于生成对统计分析程序的输入。一个实施例包括接收包括测量字段和时间序列参考条件的抽象查询。抽象查询被转换成由查询引擎执行的可执行查询，由此确定包括测量字段的可用测量值的结果数据。可用的测量值在与满足时间参考条件的时间点不同的时间点进行。该方法还包括确定对应于满足时间性参考条件的时间点与采用可用测量值的另一个时间点之间的时间变化的方差值。作为抽象查询的结果集，返回可用的测量值和方差值。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式