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

31. 发明申请

US20100094844A1 DEDUCTION OF ANALYTIC CONTEXT BASED ON TEXT AND SEMANTIC LAYER 有权
标题翻译：基于文本和语义层的分析语境的抑制
公开(公告)号：US20100094844A1
公开(公告)日：2010-04-15
申请号：US12326379
申请日：2008-12-02
申请人： Jean-Yves Cras
发明人： Jean-Yves Cras
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/2785 , G06F17/3056
摘要： A system includes reception of text, extraction of a plurality of linguistic entities and associated linguistic entity categories based on the text; determination of one or more semantic objects of a semantic layer based on the linguistic entity categories, and generation of a query of the semantic layer based on the plurality of linguistic entities, the associated linguistic entity categories, and the one or more semantic objects. In some aspects, extraction of the plurality of linguistic entities includes identification of the plurality of linguistic entities from a plurality of semantic object-independent linguistic entity categories and a plurality of semantic object-dependent linguistic entity categories, wherein the plurality of semantic object-dependent linguistic entity categories are associated with the semantic layer, and wherein each of the plurality of semantic object-dependent linguistic entity categories is associated with a respective semantic object of the semantic layer and each entity of each semantic object-dependent linguistic entity category is associated with a value of its respective semantic object.
摘要翻译：系统包括基于文本接收文本，提取多个语言实体和相关联的语言实体类别; 基于语言实体类别确定语义层的一个或多个语义对象，以及基于多个语言实体，相关联的语言实体类别和一个或多个语义对象生成语义层的查询。在一些方面，多个语言实体的提取包括从多个语义对象无关语言实体类别和多个语义对象依赖语言实体类别中识别多个语言实体，其中多个语义对象依赖语言实体类别与语义层相关联，并且其中多个语义对象依赖语言实体类别中的每一个与语义层的相应语义对象相关联，并且每个语义对象依赖语言实体类别的每个实体与其各自的语义对象的值。

32. 发明授权

US07356779B2 Analytical reporting on top of multidimensional data model 有权
标题翻译：多维数据模型的分析报告
公开(公告)号：US07356779B2
公开(公告)日：2008-04-08
申请号：US11000597
申请日：2004-11-30
申请人： Jean-Yves Cras , Henri Biestro , Ricardo Polo-Malouvier
发明人： Jean-Yves Cras , Henri Biestro , Ricardo Polo-Malouvier
IPC分类号： G06F3/00
CPC分类号： G06F17/30398 , G06F17/30395 , G06F17/30592 , Y10S707/99943 , Y10S715/968
摘要： An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.
摘要翻译：分析报告功能在多维数据模型之上提供完整的动态报告功能。 GUI便于为维度的各种元素复制相同的报告数据。此外，启用与执行OLAP风格的报表的直接交互。

33. 发明申请

US20070255574A1 Apparatus and method for facilitating trusted business intelligence through data context 有权
标题翻译：通过数据环境促进可信商业智能的装置和方法
公开(公告)号：US20070255574A1
公开(公告)日：2007-11-01
申请号：US11269145
申请日：2005-11-07
申请人： Ricardo Polo-Malouvier , Sebastien Ducaule , Jean-Yves Cras , Pierre Saurel , Charles Piercey
发明人： Ricardo Polo-Malouvier , Sebastien Ducaule , Jean-Yves Cras , Pierre Saurel , Charles Piercey
IPC分类号： G06Q10/00
CPC分类号： G06Q10/10
摘要： A computer readable medium with executable instructions to analyze a report value, includes executable instructions to select a report value and identify the formula evaluated to produce the report value. Formal parameters associated with the formula are determined. The actual parameters used to compute the report value are located. The formula, the formal parameters and the actual parameters are then displayed.
摘要翻译：具有用于分析报告值的可执行指令的计算机可读介质包括可选指令以选择报告值并识别被评估以产生报告值的公式。确定与公式相关联的正式参数。用于计算报告值的实际参数位于。然后显示公式，形式参数和实际参数。

34. 发明授权

US07222130B1 Report then query capability for a multidimensional database model 有权
标题翻译：报告然后查询多维数据库模型的功能
公开(公告)号：US07222130B1
公开(公告)日：2007-05-22
申请号：US10673090
申请日：2003-09-26
申请人： Jean-Yves Cras , Ricardo Polo-Malouvier , Henri Biestro
发明人： Jean-Yves Cras , Ricardo Polo-Malouvier , Henri Biestro
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/917 , Y10S707/957 , Y10S707/958 , Y10S707/96 , Y10S707/99933 , Y10S707/99944 , Y10S707/99945
摘要： A system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.
摘要翻译：一种建立在关系型或多维数据库之上的多维数据模型之上的分析报告的系统和方法。数据库在计算机系统中运行，并提供响应于查询的返回值。这样的查询是自动生成的，并从报表定义中推导出来。根据一个实施例，系统使用报告规范，并且本发明的方法能够延迟数据源的初始查询，如常规报告工具和方法的情况，直到定义报告为止。也就是说，定义分析报告的方式提供了自动生成的查询。报告定义完成后，将检索填写此类报告的数据以构建文档。

35. 发明授权

US07181440B2 Mapping of an RDBMS schema onto a multidimensional data model 有权
标题翻译：将RDBMS模式映射到多维数据模型
公开(公告)号：US07181440B2
公开(公告)日：2007-02-20
申请号：US10899862
申请日：2004-07-26
申请人： Jean-Yves Cras , Henri Biestro , Ricardo Polo-Malouvier
发明人： Jean-Yves Cras , Henri Biestro , Ricardo Polo-Malouvier
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30398 , Y10S707/99932 , Y10S707/99943 , Y10S707/99944 , Y10S707/99945
摘要： A Relational Database Management System (RDBMS) having any arbitrary structure is translated into a multi-dimensional data model suitable for performing OLAP operations upon. If a relational table defining the relational model includes any tables with cardinality of 1,1 or 0,1, the tables are merged into a single table. If the relational table is not normalized, then normalization is performed and a relationship between the original table and the normalized table is created. If the relational table is normalized, but not by dependence between columns, such as in the dimension table in a snowflake schema, the normalization process is performed using the foreign key in order to generate the normalized table. Once the normalized table is generated, OLAP measures are derived from the normalized relational table by an automated method. In addition, OLAP dimensions are derived from the normalized relational table and the results of the OLAP measures derivation by an automated method according to the present invention. According to an aspect, it is possible to associate a member of a dimension to another member of the same or another dimension. According to another aspect, it is possible to create a new dimension of analysis, the members of which are all the different values that a scalar expression can take on. According to yet another aspect, it is possible to access the various instances of a Reporting Object as members in an OLAP dimension. According to the yet another aspect, it is possible to apply opaque filters or a combination of them to the data that underlies analysis.
摘要翻译：具有任意结构的关系数据库管理系统（RDBMS）被翻译成适用于执行OLAP操作的多维数据模型。如果定义关系模型的关系表包含基数为1,1或0,1的任何表，则表被合并到单个表中。如果关系表未被归一化，则执行归一化，并且创建原始表与归一化表之间的关系。如果关系表被归一化，而不是列之间的依赖，例如在雪花模式的维度表中，则使用外键执行归一化过程以生成归一化表。一旦生成了规范化表，就可以通过自动化方法从归一化关系表导出OLAP度量。另外，从归一化关系表导出OLAP维度，并且通过根据本发明的自动化方法推导OLAP测量结果。根据一个方面，可以将尺寸的构件与相同或另一维度的另一个构件相关联。根据另一方面，可以创建分析的新维度，其成员是标量表达式可以承担的所有不同的值。根据另一方面，可以将报告对象的各种实例作为OLAP维度中的成员访问。根据另一方面，可以将不透明滤光片或它们的组合应用于基于分析的数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式