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

1. 发明申请

US20100287223A1 FUNCTIONALLY-DEPENDENT ANALYSIS OBJECTS 有权
标题翻译：功能依赖性分析对象
公开(公告)号：US20100287223A1
公开(公告)日：2010-11-11
申请号：US12463702
申请日：2009-05-11
申请人： Jean-Yves Cras , Serge Thepaut , Gilles Vergnory-Mion , Juan Francisco Calvente
发明人： Jean-Yves Cras , Serge Thepaut , Gilles Vergnory-Mion , Juan Francisco Calvente
IPC分类号： G06F17/30
CPC分类号： G06F17/30392
摘要： A system may include a database of physical data tables, a logical database schema of logical entities associated with the physical data tables, and an abstraction layer comprising a plurality of dimension objects mapped to the logical entities, at least one of the plurality of dimension objects comprising one or more properties associating the at least one of the plurality of dimension objects to one or more others of the plurality of dimension objects.
摘要翻译：系统可以包括物理数据表的数据库，与物理数据表相关联的逻辑实体的逻辑数据库模式，以及抽象层，包括映射到逻辑实体的多个维度对象，多个维度对象中的至少一个包括将所述多个维度对象中的所述至少一个维度对象与所述多个维度对象中的一个或多个属性相关联的一个或多个属性。

2. 发明授权

US08260825B2 Functionally-dependent analysis objects 有权
标题翻译：功能依赖的分析对象
公开(公告)号：US08260825B2
公开(公告)日：2012-09-04
申请号：US12463702
申请日：2009-05-11
申请人： Jean-Yves Cras , Serge Thepaut , Gilles Vergnory-Mion , Juan Francisco Calvente
发明人： Jean-Yves Cras , Serge Thepaut , Gilles Vergnory-Mion , Juan Francisco Calvente
IPC分类号： G06F17/30
CPC分类号： G06F17/30392
摘要： A system may include a database of physical data tables, a logical database schema of logical entities associated with the physical data tables, and an abstraction layer comprising a plurality of dimension objects mapped to the logical entities, at least one of the plurality of dimension objects comprising one or more properties associating the at least one of the plurality of dimension objects to one or more others of the plurality of dimension objects.
摘要翻译：系统可以包括物理数据表的数据库，与物理数据表相关联的逻辑实体的逻辑数据库模式，以及抽象层，包括映射到逻辑实体的多个维度对象，多个维度对象中的至少一个包括将所述多个维度对象中的所述至少一个维度对象与所述多个维度对象中的一个或多个属性相关联的一个或多个属性。

3. 发明授权

US08229952B2 Generation of logical database schema representation based on symbolic business intelligence query 有权
标题翻译：基于符号商业智能查询生成逻辑数据库模式表示
公开(公告)号：US08229952B2
公开(公告)日：2012-07-24
申请号：US12463757
申请日：2009-05-11
申请人： Jean-Yves Cras , Juan Francisco Calvente , Yucheng Sha , Serge Thepaut
发明人： Jean-Yves Cras , Juan Francisco Calvente , Yucheng Sha , Serge Thepaut
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30439 , G06F17/30389
摘要： A system to query a database based on a logical schema of the database and an abstraction of the logical database schema, the abstraction including a plurality of objects and one or more properties associating one or more of the plurality of objects to one or more others of the plurality of objects. The system includes reception of a query including a first plurality of objects of the abstraction, a first one or more properties associating one of the first plurality of objects with another one of the plurality of objects, and two or more instances of a first one of the first plurality of objects. A dynamic representation of the logical database schema is modified to include an alias of the first one of the plurality of objects, the query is modified to include the alias, one or more functional dependencies of the abstraction to be enforced are determined based on the modified query, the modified dynamic representation of the logical database schema is edited based on the determined one or more functional dependencies, and a database query is generated based on the modified query and the edited dynamic representation.
摘要翻译：一种基于所述数据库的逻辑模式和所述逻辑数据库模式的抽象来查询数据库的系统，所述抽象包括多个对象以及将所述多个对象中的一个或多个对象与一个或多个其他对象相关联的一个或多个属性多个对象。所述系统包括接收包括所述抽象的第一多个对象的查询，将所述第一多个对象中的一个与所述多个对象中的另一个相关联的第一个或多个属性以及所述多个对象中的第一个的两个或更多个实例第一个多个对象。逻辑数据库模式的动态表示被修改为包括多个对象中的第一个对象的别名，修改该查询以包括该别名，基于修改后的确定的要执行的抽象的一个或多个功能依赖性查询，基于确定的一个或多个功能依赖性来编辑逻辑数据库模式的修改的动态表示，并且基于修改的查询和编辑的动态表示来生成数据库查询。

4. 发明申请

US20100287185A1 GENERATION OF LOGICAL DATABASE SCHEMA REPRESENTATION BASED ON SYMBOLIC BUSINESS INTELLIGENCE QUERY 有权
标题翻译：基于符号业务智能查询的逻辑数据库示意图生成
公开(公告)号：US20100287185A1
公开(公告)日：2010-11-11
申请号：US12463757
申请日：2009-05-11
申请人： Jean-Yves Cras , Juan Francisco Calvente , Yucheng Sha , Serge Thepaut
发明人： Jean-Yves Cras , Juan Francisco Calvente , Yucheng Sha , Serge Thepaut
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30439 , G06F17/30389
摘要： A system to query a database based on a logical schema of the database and an abstraction of the logical database schema, the abstraction including a plurality of objects and one or more properties associating one or more of the plurality of objects to one or more others of the plurality of objects. The system includes reception of a query including a first plurality of objects of the abstraction, a first one or more properties associating one of the first plurality of objects with another one of the plurality of objects, and two or more instances of a first one of the first plurality of objects. A dynamic representation of the logical database schema is modified to include an alias of the first one of the plurality of objects, the query is modified to include the alias, one or more functional dependencies of the abstraction to be enforced are determined based on the modified query, the modified dynamic representation of the logical database schema is edited based on the determined one or more functional dependencies, and a database query is generated based on the modified query and the edited dynamic representation.
摘要翻译：一种基于所述数据库的逻辑模式和所述逻辑数据库模式的抽象来查询数据库的系统，所述抽象包括多个对象以及将所述多个对象中的一个或多个对象与一个或多个其他对象相关联的一个或多个属性多个对象。所述系统包括接收包括所述抽象的第一多个对象的查询，将所述第一多个对象中的一个与所述多个对象中的另一个相关联的第一个或多个属性以及所述多个对象中的第一个的两个或更多个实例第一个多个对象。逻辑数据库模式的动态表示被修改为包括多个对象中的第一个对象的别名，修改该查询以包括该别名，基于修改后的确定的要执行的抽象的一个或多个功能依赖性查询，基于确定的一个或多个功能依赖性来编辑逻辑数据库模式的修改的动态表示，并且基于修改的查询和编辑的动态表示来生成数据库查询。

5. 发明申请

US20110131248A1 ANALYSIS GROUPS FOR SEMANTIC LAYER 有权
标题翻译：语义层分析组
公开(公告)号：US20110131248A1
公开(公告)日：2011-06-02
申请号：US12629580
申请日：2009-12-02
申请人： Serge Thépaut , Juan Francisco Calvente
发明人： Serge Thépaut , Juan Francisco Calvente
IPC分类号： G06F17/30
CPC分类号： G06F17/30607
摘要： A system may include a database of physical data tables including stored data, and an abstraction layer associated with the stored data. The abstraction layer may include a measure object associated with a measure, a plurality of dimension objects associated with respective dimensions, a first analysis group object linked to the measure object, to a first one or more of the plurality of dimension objects, and to a first portion of the stored data associating the measure with respective dimensions of the first one or more of the plurality of dimension objects, and a second analysis group object linked to the measure object, to a second one or more of the plurality of dimension objects, and to a second portion of the stored data associating the measure with respective dimensions of the first one or more of the plurality of dimension objects and of the second one or more of the plurality of dimension objects.
摘要翻译：系统可以包括包括存储的数据的物理数据表的数据库和与存储的数据相关联的抽象层。抽象层可以包括与度量相关联的度量对象，与相应维度相关联的多个维度对象，链接到度量对象的第一分析组对象，到多个维度对象中的第一个或多个维度对象，以及存储的数据的第一部分将测量与多个维度对象中的第一个或多个维对象的相应维度以及链接到度量对象的第二分析组对象相关联到多个维度对象中的第二个或多个维度对象，以及所述存储数据的第二部分将所述测量与所述多个维度对象中的所述第一个或多个尺寸对象以及所述多个维度对象中的所述第二个一个或多个维度对象的相应维度相关联。

6. 发明授权

US09990416B2 Analysis groups for semantic layer 有权
公开(公告)号：US09990416B2
公开(公告)日：2018-06-05
申请号：US12629580
申请日：2009-12-02
申请人： Serge Thépaut , Juan Francisco Calvente
发明人： Serge Thépaut , Juan Francisco Calvente
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/30607
摘要： A system may include a database of physical data tables including stored data, and an abstraction layer associated with the stored data. The abstraction layer may include a measure object associated with a measure, a plurality of dimension objects associated with respective dimensions, a first analysis group object linked to the measure object, to a first one or more of the plurality of dimension objects, and to a first portion of the stored data associating the measure with respective dimensions of the first one or more of the plurality of dimension objects, and a second analysis group object linked to the measure object, to a second one or more of the plurality of dimension objects, and to a second portion of the stored data associating the measure with respective dimensions of the first one or more of the plurality of dimension objects and of the second one or more of the plurality of dimension objects.

7. 发明申请

US20110093487A1 DATA PROVIDER WITH TRANSIENT UNIVERSE 审中-公开
标题翻译：数据提供者与瞬态大学
公开(公告)号：US20110093487A1
公开(公告)日：2011-04-21
申请号：US12580787
申请日：2009-10-16
申请人： Yann Le Biannic , John O'Byrne , Juan Francisco Calvente
发明人： Yann Le Biannic , John O'Byrne , Juan Francisco Calvente
IPC分类号： G06F17/30
CPC分类号： G06F16/283 , G06F16/254
摘要： A computer-implemented system to receive an instruction to initialize a data provider associated with an analysis cube and a dataset, and, in response to the instruction, acquire first metadata associated with the analysis cube and generate, based on the first metadata, second metadata of an abstraction layer comprising a plurality of objects. A query comprising a first plurality of objects of the abstraction layer is received, the query is transformed to a query state based on the second metadata of the abstraction layer, and a result set is acquired from the dataset using the query state and the analysis cube.
摘要翻译：一种计算机实现的系统，用于接收用于初始化与分析立方体和数据集相关联的数据提供者的指令，并且响应于该指令，获取与分析多维数据集相关联的第一元数据，并基于第一元数据生成第二元数据包括多个对象的抽象层。接收到包括抽象层的第一多个对象的查询，基于抽象层的第二元数据将查询转换为查询状态，并且使用查询状态和分析立方体从数据集获取结果集。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式