会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 128. 发明申请
    • ABSTRACT QUERY PLAN
    • 摘要查询计划
    • US20080091668A1
    • 2008-04-17
    • US11953935
    • 2007-12-11
    • RICHARD DETTINGERDaniel Kolz
    • RICHARD DETTINGERDaniel Kolz
    • G06F17/30
    • G06F17/30436G06F17/30474G06F17/30545Y10S707/99932Y10S707/99933Y10S707/99934Y10S707/99935Y10S707/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语句(或其他已解析的查询)。 此外,一旦构造,抽象查询计划为许多不同的优化提供了一个平台,可以由用户或运行时组件在创建解析的查询之前检查抽象查询计划来选择。
    • 129. 发明申请
    • TIMELINE CONDITION SUPPORT FOR AN ABSTRACT DATABASE
    • 时间线条件支持抽象数据库
    • US20080082564A1
    • 2008-04-03
    • US11951675
    • 2007-12-06
    • Richard DettingerDaniel Kolz
    • Richard DettingerDaniel Kolz
    • G06F17/30G06F17/00
    • G06F17/30551Y10S707/99933Y10S707/99934Y10S707/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”)构造复杂条件表达式。
    • 130. 发明申请
    • TRANSFORMATION OF A PHYSICAL QUERY INTO AN ABSTRACT QUERY
    • 将物理查询转换为抽象查询
    • US20080071760A1
    • 2008-03-20
    • US11947628
    • 2007-11-29
    • Richard DettingerDaniel Kolz
    • Richard DettingerDaniel Kolz
    • G06F17/30
    • G06F16/24526Y10S707/99934Y10S707/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查询)创建抽象数据库的抽象查询 基础抽象的物理数据库。