公开(公告)号：EP3267330A1

公开(公告)日：2018-01-10

申请号：EP16187202.3

申请日：2016-09-05

申请人： Accenture Global Solutions Limited

发明人： Abolhassani, Neda ,  Sheausan Tung, Teresa ,  Gomadam, Karthik

IPC分类号： G06F17/30

CPC分类号： G06F17/30474 ,  G06F17/30401 ,  G06F17/30436

摘要： A query rewriting processor (processor) analyzes database semantic models (e.g., RDF knowledge graphs) that capture the interconnections (e.g., foreign and primary key links to other tables) present in a relational database. The processor generates an enriched model query given an initial model query (e.g., a SPARQL query) against the semantic model. The processor generates the enriched model query and translates the enriched model query into a relational database query (e.g., an SQL query). The processor may then pass the relational database query to another system or process (e.g., a data virtualization layer) for execution against the individual relational databases. In this manner, the processor automatically translates queries for information about the relational database structure to a corresponding or matching query for data from the relational database structure.

摘要翻译： 查询重写处理器（处理器）分析捕获存在于关系数据库中的互连（例如，到其他表的外键和主键链接）的数据库语义模型（例如，RDF知识图）。 处理器根据针对语义模型的初始模型查询（例如SPARQL查询）生成丰富的模型查询。 处理器生成丰富的模型查询并将丰富的模型查询转换为关系数据库查询（例如，SQL查询）。 然后，处理器可以将关系数据库查询传递给另一个系统或进程（例如，数据虚拟化层）以针对个体关系数据库执行。 以这种方式，处理器将关于关系数据库结构的信息的查询自动转换为来自关系数据库结构的数据的对应或匹配查询。

公开(公告)号：EP2652639A2

公开(公告)日：2013-10-23

申请号：EP11848459.1

申请日：2011-12-13

申请人： Microsoft Corporation

发明人： DE SMET, Bart ,  MEIJER, Henricus Johannes Maria

IPC分类号： G06F17/20 ,  G06F17/40 ,  G06F9/44

CPC分类号： G06F17/30436 ,  G06F17/30002 ,  G06F17/30483

摘要： Data acquisition is facilitated by way of an intermediate representation of a query expression. The intermediate representation can be generated and subsequently transmitted to, and employed by, a plurality of execution environments with respect to query execution. More particularly, the intermediate representation can be transformed into a locally executable query expression. Furthermore, numerous factors can shape the created and transmitted intermediate representation.

摘要翻译： 通过查询表达式的中间表示方式来促进数据采集。 中间表示可以被生成并且随后被发送到多个执行环境并且被用于查询执行。 更具体地，中间表示可以被转换成本地可执行的查询表达式。 此外，许多因素可以塑造所创建和传输的中间表示。

公开(公告)号：EP2455869A1

公开(公告)日：2012-05-23

申请号：EP10189989.6

申请日：2010-11-04

申请人： Tieto Oyj

发明人： Lähteenmäki, Juha

IPC分类号： G06F17/30

CPC分类号： G06F17/30498 ,  G06F17/30436 ,  G06F17/30445

摘要： The invention relates to a method for performing a query to a database system. In the method metadata relating to a database is retrieved from the database system. A search category is determined based on the metadata. The search category represents relationships between tables in the database. Search terms associated with the columns in the tables and received. A search data structure is obtained based on the search category and the search terms. The data structure comprises different parts corresponding to different tables. Search corresponding to the different parts are executed as separate using information in the different parts of the search data structure. A set operation between key column value sets obtained from the searches.

摘要翻译： 本发明涉及一种用于对数据库系统执行查询的方法。 在方法中，从数据库系统检索与数据库有关的元数据。 搜索类别是根据元数据确定的。 搜索类别表示数据库中表之间的关系。 与表格中的列相关联的搜索字词并接收。 基于搜索类别和搜索项获得搜索数据结构。 数据结构包括与不同表对应的不同部分。 对应于不同部分的搜索在搜索数据结构的不同部分中作为单独使用信息执行。 从搜索获得的关键列值集之间的集合操作。

公开(公告)号：EP1899873A2

公开(公告)日：2008-03-19

申请号：EP06785623.7

申请日：2006-06-27

申请人： AB Initio Software Corporation

发明人： STANFILL, Craig W. ,  WHOLEY, J. Skeffington ,  LARSON, Brond ,  ALLIN, Glenn John

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  G06F8/51 ,  G06F17/30398 ,  G06F17/30436

摘要： Determining metadata associated with a graph-based computation includes functionally transforming metadata associated with a first portion (2310) of a graph to generate transformed metadata associated with a second portion (2316) of the graph; determining a third portion (2317) of the graph related to the second portion of the graph; and propagating the transformed metadata from the second portion of the graph to the third portion of the graph.

公开(公告)号：EP1383056A3

公开(公告)日：2006-07-26

申请号：EP03016438.8

申请日：2003-07-21

申请人： MICROSOFT CORPORATION

发明人： Anonsen, Steven P. ,  Trappen, Antony R.

IPC分类号： G06F17/30

CPC分类号： G06F17/30436 ,  G06F17/3041 ,  G06F17/30427 ,  G06F17/30595 ,  G06F17/30607 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99936 ,  Y10S707/99943

摘要： The present invention is a method and system for querying a database system. An object query identifies a partial set of properties of an object to be returned. A portion of the relational database containing those properties is identified and only those properties are returned.

公开(公告)号：EP0715739A1

公开(公告)日：1996-06-12

申请号：EP94927247.0

申请日：1994-08-24

申请人： ASYMETRIX CORPORATION

发明人： HARDING, James, Allan ,  McCORMACK, Jonathan, Ian

IPC分类号： G06F12 ,  G06F17

CPC分类号： G06F17/30398 ,  G06F17/30392 ,  G06F17/30401 ,  G06F17/30436 ,  Y10S707/917 ,  Y10S707/968 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： Computerized tools for modeling database designs and specifying queries of the data contained therein. Once it is determined that an information system needs to be created, the Fact Complier (100) of the present invention is invoked to create it. After creating the information system, the user creates a fact-tree, using the Fact ^_Tree ^_Specification Module (300), as a prelude to generating queries to the system. After creating the fact-tree, the user verifies that it is correct, using the Tree Interpreter, invoked as Fact ^_Tree ^_to ^_Description Module (500), of the present invention. Once the fact-tree has been verified, the Query Mapper of the present invention, invoked as Fact ^_Tree ^_to ^_SQL ^_Query Module (400), is used to generate information system queries.

公开(公告)号：EP0387226A1

公开(公告)日：1990-09-12

申请号：EP90850095.2

申请日：1990-03-05

申请人： International Business Machines Corporation

发明人： Hedin, Erik Bertil ,  Jonsson, Gregor I. ,  Olsson, Lars Erik ,  Sanamrad, Mohammad A. ,  Westling, Sven Olof Gunnar

IPC分类号： G06F15/38 ,  G06F15/40

CPC分类号： G06F17/2785 ,  G06F17/271 ,  G06F17/274 ,  G06F17/2755 ,  G06F17/2836 ,  G06F17/2872 ,  G06F17/2881 ,  G06F17/289 ,  G06F17/3043 ,  G06F17/30436 ,  G06F17/30684 ,  Y10S706/934 ,  Y10S707/99934

摘要： A system for natural language (NL) analyzis is provided which comprises apparatus and method. It has the capability to analyze NL expressions and to resolve ambiguities and present them to the user for verification of correct interpretation.
The invention is based on a language independent model of the contents of a data base. The model contains records of information defining entity types and rela­tions between such entity types. The model is created (customizing the system) by the user, and is stored as a conceptual schema.
The entities of the schema are linked or connected to natural language terms in a vocabulary.
The entities represent objects in the data base, and there is a link or connection between the entities and those objects of the data base.
The actual analysis of NL expressions is performed by a Natural Language Engine (NLE) in cooperation with an Analysis Grammar and the schema. The analysis results in an intermediate, language independent logic form repre­sentation of the input, which is paraphrased back to NL for verification, and if the input is a query, there is a translation into a query language such as SQL.

摘要翻译： 提供了一种用于自然语言（NL）分析的系统，其包括装置和方法。 它具有分析NL表达式并解决模糊性并将其呈现给用户以验证正确解释的能力。 本发明基于数据库内容的语言无关模型。 该模型包含定义实体类型和这些实体类型之间关系的信息记录。 该模型由用户创建（自定义系统），并作为概念模式存储。 模式的实体链接或连接到词汇表中的自然语言术语。 实体表示数据库中的对象，并且实体和数据库中的对象之间存在链接或连接。 NL表达式的实际分析由自然语言引擎（NLE）与分析语法和模式协作完成。 分析导致输入的中间的，与语言无关的逻辑形式表示，其被转换为NL以进行验证，并且如果输入是查询，则存在诸如SQL的查询语言的翻译。

公开(公告)号：EP2652639A4

公开(公告)日：2017-07-12

申请号：EP11848459

申请日：2011-12-13

申请人： MICROSOFT TECHNOLOGY LICENSING LLC

发明人： DE SMET BART ,  MEIJER HENRICUS JOHANNES MARIA

IPC分类号： G06F17/20 ,  G06F9/44 ,  G06F17/30 ,  G06F17/40

CPC分类号： G06F17/30436 ,  G06F17/30002 ,  G06F17/30483

公开(公告)号：EP2859476A1

公开(公告)日：2015-04-15

申请号：EP13803504.3

申请日：2013-05-16

申请人： International Business Machines Corporation

发明人： PAIKOWSKY, Oren ,  TZABAN, Yariv ,  STARK, Shimon

IPC分类号： G06F17/30

CPC分类号： G06F17/30477 ,  G06F17/3043 ,  G06F17/30436 ,  G06F17/30911 ,  G06F17/30929

摘要： Facilitating the searching of structured documents by identifying multiple element paths corresponding to multiple elements included in multiple structured documents, and for each of the element paths providing, for inclusion in a first searchable data structure, the element path exclusive of a value of the element corresponding to the element path and exclusive of an identifier of the structured document including the element corresponding to the element path, and providing, for inclusion in a second searchable data structure, the element path in association with a value of the element corresponding to the element path and in association with an identifier of the structured document including the element corresponding to the element path.

公开(公告)号：EP2784697A1

公开(公告)日：2014-10-01

申请号：EP13161804.3

申请日：2013-03-28

申请人： FUJITSU LIMITED

发明人： Nuno, Carvalho ,  Hu, Bo

IPC分类号： G06F17/30

CPC分类号： G06F17/30424 ,  G06F17/30436 ,  G06F17/30451 ,  G06F17/30469 ,  G06F17/30545

摘要： Embodiments include a querying method for a database of graph data encoded as triples, the triples each comprising values of three triple elements and being stored on a plurality of storage servers, the method comprising: a dividing step comprising dividing a query into a plurality of result criteria, the result criteria comprising a plurality of triple patterns which some or all query results must match, each triple pattern is composed of three triple pattern elements each corresponding to a different one of the three triple elements; each triple pattern element being either: a single value triple pattern element specifying a single value of the corresponding triple element which triples must have to match the triple pattern; or a variable value triple pattern element specifying an ID of a variable, the ID being attributed to values of the corresponding triple elements of triples matching the triple pattern. The method further comprises a sub-query forming step comprising, forming one or more sub-queries each comprising two or more triple patterns having the same single value triple pattern element or specifying the same ID of a variable as a variable value triple pattern element; a sub-query issuing step comprising issuing each formed sub-query to each of the plurality of storage servers; and a query result preparing step comprising receiving triples satisfying at least one formed sub-query as sub-query results from the plurality of storage servers and using the sub-query results to prepare query results as a response to the query.

摘要翻译： 实施例包括用于编码为三元组的图形数据的数据库的查询方法，每个包括三个三元素的值并且存储在多个存储服务器上的三元组，所述方法包括：分割步骤，包括将查询分成多个结果 标准，结果标准包括一些或全部查询结果必须匹配的多个三重图案，每个三重图案由三个三重图案元素组成，每个三个图案元素对应于三个三元素中的不同一个; 每个三重图案元素是：单值三重图案元素，其指定三元组必须与三重图案匹配的相应三重元素的单个值; 或指定变量的ID的变量值三重图案元素，该ID被归因于与三重图案匹配的三元组的相应三元组元素的值。 该方法还包括一个子查询形成步骤，包括：形成一个或多个子查询，每个子查询包括具有相同单值三重图案元素的两个或多个三重图案，或者指定与变量值三重图案元素相同的变量ID; 子查询发布步骤，包括向所述多个存储服务器中的每个存储服务器发出每个形成的子查询; 以及查询结果准备步骤，包括从所述多个存储服务器接收满足至少一个形成的子查询的三元组作为子查询结果，并且使用所述子查询结果来准备作为对所述查询的响应的查询结果。