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

51. 发明申请

US20060235836A1 Query conditions on related model entities 有权
公开(公告)号：US20060235836A1
公开(公告)日：2006-10-19
申请号：US11106283
申请日：2005-04-14
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30392 , Y10S707/99933 , Y10S707/99944 , Y10S707/99945
摘要： Embodiments of the invention provide methods, systems and articles of manufacture for constructing a database abstraction model over an underlying physical database. Typically, queries of the database abstraction model are directed to queries of a model entity defined for the database abstraction model. To compose an abstract query, users select conditions evaluated using data associated with instances of the model entity. Using the database abstraction model, users may compose an abstract query according to logical or intuitive relationships among data elements stored in the underlying database. One addition to the database abstraction model is the ability to apply query criteria against related instances of a model entity. Because model entities may share a predefined relationship, embodiments of the invention allow for users to specify query criteria applied against related instances. Related instances may be identified by invoking a path function provided by the database abstraction model. A path function may be configured to return instances of the model entity that are related to an instance input to the path function.

52. 发明申请

US20060161573A1 Logical record model entity switching 审中-公开
标题翻译：逻辑记录模型实体切换
公开(公告)号：US20060161573A1
公开(公告)日：2006-07-20
申请号：US11035566
申请日：2005-01-14
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F7/00
CPC分类号： G06F16/2425 , G06F16/2423
摘要： 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. 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. In addition, once presented with data for an instance of a first model entity, embodiments of the invention provide for a user to switch the display presented to an instance of a second model entity. A conversion function may be used to map between model entities.
摘要翻译：本发明的实施例提供了用于在底层物理数据库上构建数据库抽象模型的技术。一旦构建，用户可以与数据库抽象模型进行交互，而不是基础物理数据库表示，来查询数据库和查看查询结果。在一个实施例中，从与模型实体相关的底层物理数据库检索信息。通常，模型实体标识用户与查询应用程序交互查询的逻辑焦点或中心实体。抽象记录使用数据库抽象模型来识别每个模型实体可用于查询的数据。此外，一旦呈现了用于第一模型实体的实例的数据，本发明的实施例提供用户将呈现的显示切换到第二模型实体的实例。转换函数可用于在模型实体之间映射。

53. 发明申请

US20060137019A1 Techniques for managing access to physical data via a data abstraction model 失效
标题翻译：通过数据抽象模型管理物理数据访问的技术
公开(公告)号：US20060137019A1
公开(公告)日：2006-06-22
申请号：US11012906
申请日：2004-12-15
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： H04L9/32
CPC分类号： G06F21/6218 , G06F2221/2141
摘要： A method, system and article of manufacture for managing access to a data abstraction model abstractly describing physical data and, more particularly, for creating a logical security model for a data abstraction model abstractly describing data in a database. One embodiment provides a computer-implemented method for creating a logical security model based on a physical security model defining user access rights to physical data. The method comprises, for each of the user access rights defined by the physical security model, creating a logical access right definition for a logical model. The logical model comprises a plurality of logical field definitions each comprising a field name and access information for accessing a field of the physical data. The logical access right definitions are applied to the logical model so that the logical model reflects the user access rights to the physical data.
摘要翻译：用于管理对抽象地描述物理数据的数据抽象模型的访问的方法，系统和制品，更具体地，用于为抽象地描述数据库中的数据的数据抽象模型创建逻辑安全模型。一个实施例提供了一种用于基于定义用户对物理数据的访问权限的物理安全模型来创建逻辑安全模型的计算机实现的方法。对于由物理安全模型定义的每个用户访问权限，该方法包括为逻辑模型创建逻辑访问权限定义。逻辑模型包括多个逻辑字段定义，每个逻辑字段定义包括用于访问物理数据的字段的字段名称和访问信息。逻辑访问权限定义被应用于逻辑模型，使得逻辑模型反映用户对物理数据的访问权限。

54. 发明申请

US20060122977A1 Techniques for managing interdependent data objects 有权
标题翻译：用于管理相互依赖的数据对象的技术
公开(公告)号：US20060122977A1
公开(公告)日：2006-06-08
申请号：US11005436
申请日：2004-12-06
申请人： Mark Brodhun , Richard Dettinger , Daniel Kolz
发明人： Mark Brodhun , Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30604 , Y10S707/955 , Y10S707/99933
摘要： A method, system and article of manufacture for managing interdependent data objects and, more particularly, for managing modifications to at least one of a plurality of interdependent data objects. One embodiment provides a computer-implemented method of managing modifications to at least one of a plurality of interdependent data objects. The method comprises receiving a request for modification of a given data object having at least one dependent data object. The method further comprises accessing a directory of dependencies containing at least one record for each of the plurality of 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.
摘要翻译：一种用于管理相互依赖的数据对象的方法，系统和制品，更具体地，用于管理对多个相互依赖的数据对象中的至少一个的修改。一个实施例提供了一种管理对多个相互依赖的数据对象中的至少一个的修改的计算机实现的方法。该方法包括接收对具有至少一个依赖数据对象的给定数据对象的修改请求。该方法还包括：访问包含至少一个相关数据对象的多个相互依赖的数据对象中的每个的至少一个记录的依赖项目录。每个记录描述了至少两个相互依赖的数据对象之间的相互依赖关系。至少一个依赖数据对象的记录描述给定数据对象与至少一个从属数据对象之间的相互依赖关系。使用所访问的依赖目录，识别给定数据对象与至少一个从属数据对象之间的相互依赖关系。基于所确定的相互依赖性在执行所请求的修改时呈现可能的不期望的结果，执行预定义的动作。

55. 发明申请

US20080091668A1 ABSTRACT QUERY PLAN 有权
标题翻译：摘要查询计划
公开(公告)号：US20080091668A1
公开(公告)日：2008-04-17
申请号：US11953935
申请日：2007-12-11
申请人： RICHARD DETTINGER , Daniel Kolz
发明人： RICHARD DETTINGER , Daniel Kolz
IPC分类号： 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语句（或其他已解析的查询）。此外，一旦构造，抽象查询计划为许多不同的优化提供了一个平台，可以由用户或运行时组件在创建解析的查询之前检查抽象查询计划来选择。

56. 发明申请

US20080082564A1 TIMELINE CONDITION SUPPORT FOR AN ABSTRACT DATABASE 有权
标题翻译：时间线条件支持抽象数据库
公开(公告)号：US20080082564A1
公开(公告)日：2008-04-03
申请号：US11951675
申请日：2007-12-06
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/30551 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942
摘要： Embodiments of the invention relate data retrieved from the logical fields of an abstract database using a timeline. The logical fields specified by a database abstraction model are extended to include attributes that specify where data corresponding to a logical field occurs on a timeline. Query results may be displayed by ordering query results as points (for an event) or segments (for a duration) on the timeline. Further, query processing techniques disclosed by the present invention allow users to include temporal operators such as “before,” “after,” “during,” and “within” in an abstract query. Temporal operators provide users with the ability to include temporal relationships in an abstract query, without having to construct a complex conditional expression from more primitive logical operators (e.g., “ands” and “ors”).
摘要翻译：本发明的实施例涉及使用时间线从抽象数据库的逻辑字段检索的数据。由数据库抽象模型指定的逻辑字段被扩展为包括指定在时间轴上发生对应于逻辑字段的数据的属性的属性。可以通过将查询结果作为时间轴上的点（对于事件）或段（持续时间）排序来显示查询结果。此外，本发明公开的查询处理技术允许用户在抽象查询中包括诸如“之前”，“之后”，“期间”和“内部”之类的时间运算符。时间运算符为用户提供了在抽象查询中包含时间关系的能力，而无需从更原始的逻辑运算符（例如“和”和“ors”）构造复杂条件表达式。

57. 发明申请

US20080071760A1 TRANSFORMATION OF A PHYSICAL QUERY INTO AN ABSTRACT QUERY 审中-公开
标题翻译：将物理查询转换为抽象查询
公开(公告)号：US20080071760A1
公开(公告)日：2008-03-20
申请号：US11947628
申请日：2007-11-29
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F16/24526 , Y10S707/99934 , Y10S707/99935
摘要： Embodiments of the invention provide methods, systems and articles of manufacture for transforming a physical query (e.g., written in SQL) into an abstract query than can be run against an abstract database described by a database abstraction model. In one embodiment, the transformation occurs as a multiple step process: first, transformation of the physical query into an intermediate representation, such as an abstract query plan, and second, transformation of the intermediate representation into an abstract query. There are thousands upon thousands of existing physical (e.g., SQL) queries. Rather than just abandon these existing queries in favor of an abstract database, embodiments of the present invention provide for reverse query processing, that is, for creating an abstract query of the abstract database from a physical query (e.g., an SQL query) of the physical database underlying the abstraction.
摘要翻译：本发明的实施例提供了用于将物理查询（例如，以SQL编写）转换成抽象查询的方法，系统和制品，而不是可以针对由数据库抽象模型描述的抽象数据库运行。在一个实施例中，转换以多步骤过程发生：首先，将物理查询转换为诸如抽象查询计划的中间表示，以及第二，将中间表示转换为抽象查询。有成千上万的现有物理（例如SQL）查询。而不是简单地放弃这些现有的查询以支持抽象数据库，本发明的实施例提供反向查询处理，即，用于从所述抽象数据库的物理查询（例如，SQL查询）创建抽象数据库的抽象查询基础抽象的物理数据库。

58. 发明申请

US20060235835A1 Model entity operations in query results 失效
公开(公告)号：US20060235835A1
公开(公告)日：2006-10-19
申请号：US11106282
申请日：2005-04-14
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30395 , Y10S707/99933 , Y10S707/99944 , Y10S707/99945
摘要： The present invention provides methods, 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.

59. 发明申请

US20060161521A1 Abstract records 失效
公开(公告)号：US20060161521A1
公开(公告)日：2006-07-20
申请号：US11035563
申请日：2005-01-14
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/3043 , Y10S707/99931 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要： Embodiments of the invention provide methods, systems, and articles of manufacture improving the process of query composition, query processing, and presenting query results to users of an abstract database. Embodiments of the present invention organize and view data using abstract records. Specifically, users compose a query according to the logical relationships present in the data. Rather than evaluate conditions against a set of rows from a relational table, conditions included in abstract query are evaluated against instances of an abstract record. Instances that satisfy the conditions specified by an abstract query are returned as query results. In a specific case abstract records are used to evaluate a “never exists conditions, that determine the absence of data in an abstract records that satisfy a particular condition.

60. 发明申请

US20060117032A1 System and method for sorting data records contained in a query result 失效
标题翻译：用于对查询结果中包含的数据记录进行排序的系统和方法
公开(公告)号：US20060117032A1
公开(公告)日：2006-06-01
申请号：US10999494
申请日：2004-11-30
申请人： Richard Dettinger , Daniel Kolz , Frederick Kulack
发明人： Richard Dettinger , Daniel Kolz , Frederick Kulack
IPC分类号： G06F7/00
CPC分类号： G06F17/3053 , G06F17/30941 , Y10S707/99933 , Y10S707/99937
摘要： A system, method and article of manufacture for managing query results and, more particularly, for sorting data records contained in a query result obtained in response to execution of a query against a database. In one embodiment, the data records in the query result are sorted on the basis of related information which is retrieved from a corresponding data source. In another embodiment, the sorting is performed on the basis of a value variance which is determined for each of the data records in the query result. In still another embodiment, the sorting is performed on the basis of a requested value range coverage. In yet another embodiment, the sorting is performed on the basis of suitability scores which are determined with respect to analysis routines which are configured for processing the query result.
摘要翻译：一种用于管理查询结果的系统，方法和制品，更具体地，用于对包含在响应于针对数据库的查询的执行而获得的查询结果中的数据记录的排序。在一个实施例中，查询结果中的数据记录基于从相应数据源检索的相关信息进行排序。在另一个实施例中，基于为查询结果中的每个数据记录确定的值方差来执行排序。在另一个实施例中，基于请求的值范围覆盖来执行排序。在另一个实施例中，基于针对被配置用于处理查询结果的分析例程而确定的适合性评分来执行排序。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式