公开(公告)号：US07792856B2

公开(公告)日：2010-09-07

申请号：US11771668

申请日：2007-06-29

申请人： Ariel Fuxman ,  Peter Jay Haas ,  Berthold Reinwald ,  Yannis Sismanis ,  Ling Wang

发明人： Ariel Fuxman ,  Peter Jay Haas ,  Berthold Reinwald ,  Yannis Sismanis ,  Ling Wang

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/30592 ,  G06F17/30489

摘要： A method is disclosed for conducting a query to transform data in a pre-existing database, the method comprising: collecting database information from the pre-existing database, the database information including inconsistent dimensional tables and fact tables; running an entity discovery process on the inconsistent dimensional tables and the fact tables to produce entity mapping tables; using the entity mapping tables to resolve the inconsistent dimensional tables into resolved dimensional tables; and running the query on a resolved database to obtain a query result, the resolved database including the resolved dimensional table.

摘要翻译： 公开了一种用于进行在预先存在的数据库中转换数据的查询的方法，所述方法包括：从预先存在的数据库收集数据库信息，所述数据库信息包括不一致的维度表和事实表; 对不一致的维度表和事实表运行实体发现过程以生成实体映射表; 使用实体映射表将不一致的维度表解析为已解析的维度表; 并在解析的数据库上运行查询以获取查询结果，解析的数据库包括已解析的维度表。

公开(公告)号：US20090006349A1

公开(公告)日：2009-01-01

申请号：US12133552

申请日：2008-06-05

申请人： Ariel Fuxman ,  Peter Jay Haas ,  Berthold Reinwald ,  Yannis Sismanis ,  Ling Wang

发明人： Ariel Fuxman ,  Peter Jay Haas ,  Berthold Reinwald ,  Yannis Sismanis ,  Ling Wang

IPC分类号： G06F7/06 ,  G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30489

摘要： A method is disclosed for conducting a query to transform data in a pre-existing database, the method comprising: collecting database information from the pre-existing database, the database information including inconsistent dimensional tables and fact tables; running an entity discovery process on the inconsistent dimensional tables and the fact tables to produce entity mapping tables; using the entity mapping tables to resolve the inconsistent dimensional tables into resolved dimensional tables; and running the query on a resolved database to obtain a query result, the resolved database including the resolved dimensional table.

摘要翻译： 公开了一种用于进行在预先存在的数据库中转换数据的查询的方法，所述方法包括：从预先存在的数据库收集数据库信息，所述数据库信息包括不一致的维度表和事实表; 对不一致的维度表和事实表运行实体发现过程以生成实体映射表; 使用实体映射表将不一致的维度表解析为已解析的维度表; 并在解析的数据库上运行查询以获取查询结果，解析的数据库包括已解析的维度表。

公开(公告)号：US20080243772A1

公开(公告)日：2008-10-02

申请号：US12127904

申请日：2008-05-28

申请人： Ariel Fuxman ,  Mauricio Antonio Hernandez-Sherrington ,  Ching-Tien Ho ,  Renee J. Miller ,  Paolo Papotti ,  Lucian Popa

发明人： Ariel Fuxman ,  Mauricio Antonio Hernandez-Sherrington ,  Ching-Tien Ho ,  Renee J. Miller ,  Paolo Papotti ,  Lucian Popa

IPC分类号： G06F17/30 ,  G06F17/00

CPC分类号： G06F17/2264 ,  G06F17/2785

摘要： A method and system for generating nested mapping specifications and transformation queries based thereon. Basic mappings are generated based on source and target schemas and correspondences between elements of the schemas. A directed acyclic graph (DAG) is constructed whose edges represent ways in which each basic mapping is nestable under any of the other basic mappings. Any transitively implied edges are removed from the DAG. Root mappings of the DAG are identified. Trees of mappings are automatically extracted from the DAG, where each tree of mappings is rooted at a root mapping and expresses a nested mapping specification. A transformation query is generated from the nested mapping specification by generating a first query for transforming source data into flat views of the target and a second query for nesting flat view data according to the target format. Generating the first query includes applying default Skolemization to the specification.

摘要翻译： 一种用于基于此产生嵌套映射规范和转换查询的方法和系统。 基于源和目标模式生成基本映射以及模式元素之间的对应关系。 构造有向非循环图（DAG），其边缘表示每个基本映射在任何其他基本映射下可嵌套的方式。 任何过渡性隐含边缘都从DAG中删除。 确定DAG的根映射。 从DAG自动提取映射树，其中每个映射树都以root映射为根，并表示嵌套映射规范。 通过生成用于将源数据变换为目标的平面视图的第一查询和根据目标格式嵌套平面视图数据的第二查询，从嵌套映射规范生成转换查询。 生成第一个查询包括对规范应用默认的Skolemization。

公开(公告)号：US20080243765A1

公开(公告)日：2008-10-02

申请号：US11693192

申请日：2007-03-29

申请人： Ariel Fuxman ,  Mauricio Antonio Hernandez-Sherrington ,  Ching-Tien Ho ,  Renee J. Miller ,  Paolo Papotti ,  Lucian Popa

发明人： Ariel Fuxman ,  Mauricio Antonio Hernandez-Sherrington ,  Ching-Tien Ho ,  Renee J. Miller ,  Paolo Papotti ,  Lucian Popa

IPC分类号： G06F7/00

CPC分类号： G06F17/2264 ,  G06F17/2785

摘要： A method for generating nested mapping specifications and transformation queries based thereon. Basic mappings are generated based on source and target schemas and correspondences between elements of the schemas. A directed acyclic graph (DAG) is constructed whose edges represent ways in which each basic mapping is nestable under any of the other basic mappings. Any transitively implied edges are removed from the DAG. Root mappings of the DAG are identified. Trees of mappings are automatically extracted from the DAG, where each tree of mappings is rooted at a root mapping and expresses a nested mapping specification.

摘要翻译： 一种用于基于此产生嵌套映射规范和变换查询的方法。 基于源和目标模式生成基本映射以及模式元素之间的对应关系。 构造有向非循环图（DAG），其边缘表示每个基本映射在任何其他基本映射下可嵌套的方式。 任何过渡性隐含边缘都从DAG中删除。 确定DAG的根映射。 从DAG自动提取映射树，其中每个映射树都以root映射为根，并表示嵌套映射规范。