Database query language transformation method, transformation apparatus and database query system
    1.
    发明授权
    Database query language transformation method, transformation apparatus and database query system 有权
    数据库查询语言转换方法,转换装置和数据库查询系统

    公开(公告)号:US09223827B2

    公开(公告)日:2015-12-29

    申请号:US12061742

    申请日:2008-04-03

    IPC分类号: G06F17/30 G06F7/00

    摘要: A method, device and system for transforming a concept-based query into SQL query statements, that includes transforming inputted concept-based queries into logic rules, checking validity of the logic rules, optimizing the valid logic rules, and translating the logic rules into SQL query statements in accordance with the optimization result.

    摘要翻译: 一种用于将基于概念的查询转换为SQL查询语句的方法,设备和系统,其包括将输入的基于概念的查询转换为逻辑规则,检查逻辑规则的有效性,优化有效的逻辑规则以及将逻辑规则转换为SQL 查询语句按照优化结果。

    DATABASE QUERY LANGUAGE TRANSFORMATION METHOD, TRANSFORMATION APPARATUS AND DATABASE QUERY SYSTEM
    2.
    发明申请
    DATABASE QUERY LANGUAGE TRANSFORMATION METHOD, TRANSFORMATION APPARATUS AND DATABASE QUERY SYSTEM 有权
    数据库查询语言转换方法,转换设备和数据库查询系统

    公开(公告)号:US20090094216A1

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

    申请号:US12061742

    申请日:2008-04-03

    IPC分类号: G06F7/06 G06F17/30

    摘要: The present invention provides a method for transforming a concept-based query into SQL query statements, comprising the steps of: transforming inputted concept-based queries into logic rules; checking validity of the logic rules; optimizing the valid logic rules; and translating the logic rules into SQL query statements in accordance with the optimization result. The present invention further provides corresponding transformation engine, database query system and computer program product. The present invention facilitates people to use more descriptive query language to query data stored in relational database. Furthermore, the present invention can automatically generate the correct and efficient SQL query statements so that people's efforts to deal with complex data model are saved significantly.

    摘要翻译: 本发明提供了一种将基于概念的查询转换成SQL查询语句的方法,包括以下步骤:将输入的基于概念的查询转换成逻辑规则; 检查逻辑规则的有效性; 优化有效逻辑规则; 并根据优化结果将逻辑规则转换为SQL查询语句。 本发明还提供了相应的转换引擎,数据库查询系统和计算机程序产品。 本发明便于人们使用更具描述性的查询语言来查询存储在关系数据库中的数据。 此外,本发明可以自动生成正确和有效的SQL查询语句,从而大大节省了人们处理复杂数据模型的努力。

    DATABASE QUERY LANGUAGE TRANSFORMATION METHOD, TRANSFORMATION APPARATUS AND DATABASE QUERY SYSTEM
    3.
    发明申请
    DATABASE QUERY LANGUAGE TRANSFORMATION METHOD, TRANSFORMATION APPARATUS AND DATABASE QUERY SYSTEM 失效
    数据库查询语言转换方法,转换设备和数据库查询系统

    公开(公告)号:US20070299836A1

    公开(公告)日:2007-12-27

    申请号:US11746110

    申请日:2007-05-09

    IPC分类号: G06F17/30

    摘要: The present invention provides a method for transforming a concept-based query into SQL query statements, comprising the steps of: transforming inputted concept-based queries into logic rules; checking validity of the logic rules; optimizing the valid logic rules; and translating the logic rules into SQL query statements in accordance with the optimization result. The present invention further provides corresponding transformation engine, database query system and computer program product. The present invention facilitates people to use more descriptive query language to query data stored in relational database. Furthermore, the present invention can automatically generate the correct and efficient SQL query statements so that people's efforts to deal with complex data model are saved significantly.

    摘要翻译: 本发明提供了一种将基于概念的查询转换成SQL查询语句的方法,包括以下步骤:将输入的基于概念的查询转换成逻辑规则; 检查逻辑规则的有效性; 优化有效逻辑规则; 并根据优化结果将逻辑规则转换为SQL查询语句。 本发明还提供了相应的转换引擎,数据库查询系统和计算机程序产品。 本发明便于人们使用更具描述性的查询语言来查询存储在关系数据库中的数据。 此外,本发明可以自动生成正确和有效的SQL查询语句,从而大大节省了人们处理复杂数据模型的努力。

    Database query language transformation method, transformation apparatus and database query system
    4.
    发明授权
    Database query language transformation method, transformation apparatus and database query system 失效
    数据库查询语言转换方法,转换装置和数据库查询系统

    公开(公告)号:US07668818B2

    公开(公告)日:2010-02-23

    申请号:US11746110

    申请日:2007-05-09

    IPC分类号: G06F7/00 G06F17/30

    摘要: The present invention provides a method for transforming a concept-based query into SQL query statements, comprising the steps of: transforming inputted concept-based queries into logic rules; checking validity of the logic rules; optimizing the valid logic rules; and translating the logic rules into SQL query statements in accordance with the optimization result. The present invention further provides corresponding transformation engine, database query system and computer program product. The present invention facilitates people to use more descriptive query language to query data stored in relational database. Furthermore, the present invention can automatically generate the correct and efficient SQL query statements so that people's efforts to deal with complex data model are saved significantly.

    摘要翻译: 本发明提供了一种将基于概念的查询转换成SQL查询语句的方法,包括以下步骤:将输入的基于概念的查询转换成逻辑规则; 检查逻辑规则的有效性; 优化有效逻辑规则; 并根据优化结果将逻辑规则转换为SQL查询语句。 本发明还提供了相应的转换引擎,数据库查询系统和计算机程序产品。 本发明便于人们使用更具描述性的查询语言来查询存储在关系数据库中的数据。 此外,本发明可以自动生成正确和有效的SQL查询语句,从而大大节省了人们处理复杂数据模型的努力。

    Data Processing Method and System Based on Networked Relational Dimension
    5.
    发明申请
    Data Processing Method and System Based on Networked Relational Dimension 审中-公开
    基于网络关系维度的数据处理方法与系统

    公开(公告)号:US20070299837A1

    公开(公告)日:2007-12-27

    申请号:US11765537

    申请日:2007-06-20

    IPC分类号: G06F17/30

    CPC分类号: G06F16/244 G06F16/2452

    摘要: The invention provides a data processing method and system based on a networked relational dimension. An aggregation on the attributes of the entities having networked relations and/or the attributes of the relations between the entities is described; a transitive rule of relations between the entities having networked relations is described as a restriction; the aggregation and the restriction are translated into the queries in a database manipulating language. According to the invention, a networked relational dimension can be described by using concise description, and the description can be effectively converted into standard data manipulation language.

    摘要翻译: 本发明提供了一种基于联网关系维度的数据处理方法和系统。 描述了具有网络关系的实体的属性和/或实体之间的关系的属性的聚合; 具有网络关系的实体之间的关系的传递规则被描述为限制; 聚合和限制被转换成数据库操纵语言中的查询。 根据本发明,通过使用简洁的描述可以描述网络关系维度,并且可以将描述有效地转换成标准数据操作语言。

    Lamp
    6.
    外观设计
    Lamp 有权

    公开(公告)号:USD971453S1

    公开(公告)日:2022-11-29

    申请号:US29837748

    申请日:2022-05-09

    申请人: Tao Liu

    设计人: Tao Liu

    Lamp
    7.
    外观设计
    Lamp 有权

    公开(公告)号:USD971452S1

    公开(公告)日:2022-11-29

    申请号:US29837747

    申请日:2022-05-09

    申请人: Tao Liu

    设计人: Tao Liu