Abstract: A system for capturing the context of, and translating, or mapping, from data in an originating database presentation, or in an originating format, to data in a target database presentation, or target format. The translation uses the context of the originating report/query in terms of the originating database as a basis for the translation. The originating context is translated to the target context and is used to accurately map data from one presentation to another. By using a context and a translation map, which define specifics of the translation between contexts against different data sources, the invention is able to achieve a mapping engine that can efficiently map data between databases of different types. The translation map includes rules set automatically by the system, or set by a human administrator. The rules permit special treatment of different mapping scenarios.
Type:
Application
Filed:
August 28, 2006
Publication date:
December 28, 2006
Applicant:
Business Objects, S.A.
Inventors:
Neil Thomson, Andre Paiement, Dave Gould, Martin Peticlerc, Brian Donnelly, Gordon Chow
Abstract: A computer implemented method for mapping data from one presentation to another includes capturing and transmitting the context of an original report based on an originating data source such that it preserves the organization of the query and variable levels of context “fidelity”. The context of the originating report is translated in terms of the originating data source to a target context for presentation of a target report based on a target data source. The translation of different mapping scenarios is controlled in accordance with a translation model with a translation map.
Type:
Grant
Filed:
December 16, 2002
Date of Patent:
November 21, 2006
Assignee:
Business Objects, S.A.
Inventors:
Neil Thomson, Andre Paiement, Dave Gould, Martin Petitclerc, Brian Donnelly, Gordon Chow
Abstract: A computer readable medium includes executable instructions to construct a semantic layer schema based on an XBRL data source and maintain the integrity of the XBRL metadata. The XBRL data can then be loaded into the semantic layer schema, and refreshed, such that the XBRL data is assessed and the semantic layer schema is updated as required.
Abstract: A computer readable medium includes executable instructions to extract XBRL data from a web service feed data source and construct an optimized database schema and tables, based on maintaining the integrity of the XBRL metadata. The XBRL data can then be loaded into the database, and refreshed, such that the XBRL data is assessed and the database schema and tables are updated as required.
Abstract: A computer readable medium includes executable instructions to construct a database query based on a comparator. Executable instructions accept a comparator forming a part of a text question. A value that defines a subject within a text question is received. A structured database query is built based upon the comparator and the subject of the text question.
Abstract: A method of deterministically constructing a text question for application to a data source includes supplying a user with an initial text question. The user is allowed to alter a sentence component of the text question to form an altered sentence component. When the altered sentence component in combination with remaining sentence components creates an invalid question, sentence components are supplied to insure the selection of a valid question. A data source query is constructed from the initial text question and at least one altered sentence component. The data source query is applied to a data source to produce data results. The data results are presented to the user.
Type:
Application
Filed:
April 7, 2005
Publication date:
October 12, 2006
Applicant:
Business Objects, S.A.
Inventors:
Nicholas Kellet, Steve Kopp, Luke Evans
Abstract: A computer readable medium storing executable instructions to define a data modeling system include executable instructions to specify named modular semantic transformation objects that contain a function, a type and metadata. Executable instructions are used to combine modular semantic transformation objects, as permitted based on type and metadata constraints, in order to create composite functionality represented by a composite modular semantic transformation object.
Abstract: A computer readable medium includes executable instructions to audit data migration. The executable instructions include instructions to define a data migration path from a source to a target. Audit points are specified within the data migration path. Audit statistics to be generated at the audit points are identified. The audit statistics including data corresponding to individual data values transmitted over the data migration path. Audit rules to be applied against the audit statistics are established.
Type:
Application
Filed:
March 23, 2005
Publication date:
September 28, 2006
Applicant:
Business Objects, S.A.
Inventors:
Ronaldo Ama, Sachinder Chawla, Balaji Gadhiraju, Awez Syed, Mark Todd, Mon Yee
Abstract: A method of clustering data includes choosing an initial cluster point and proximate data points from a set of data points. A revised data set is defined that excludes the initial cluster point and the proximate data points. A cluster point relatively far from the selected cluster point is selected. A revised data set excluding the selected cluster points and proximate data points is then defined. A decision is made whether to choose another cluster point. If so, a cluster point relatively far from the selected cluster points is selected and a revised data set excluding the selected cluster points and corresponding proximate data points is defined. If another cluster point is not to be selected, a final cluster point is chosen within the revised data set. The final cluster point is relatively far from the previously selected cluster points. The selected cluster points are then used to initiate a cluster analysis.
Abstract: 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.
Type:
Grant
Filed:
April 3, 2001
Date of Patent:
December 14, 2004
Assignee:
Business Objects, S.A.
Inventors:
Jean-Yves Cras, Henri Biestro, Ricardo Polo-Malouvier
Abstract: 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.
Type:
Grant
Filed:
April 3, 2001
Date of Patent:
July 27, 2004
Assignee:
Business Objects, S.A.
Inventors:
Jean-Yves Cras, Henri Biestro, Ricardo Polo-Malouvier
Abstract: A system for capturing the context of, and translating, or mapping, from data in an originating database presentation, or in an originating format, to data in a target database presentation, or target format. The translation uses the context of the originating report/query in terms of the originating database as a basis for the translation. The originating context is translated to the target context and is used to accurately map data from one presentation to another. By using a context and a translation map, which define specifics of the translation between contexts against different data sources, the invention is able to achieve a mapping engine that can efficiently map data between databases of different types. The translation map includes rules set automatically by the system, or set by a human administrator. The rules permit special treatment of different mapping scenarios.
Type:
Application
Filed:
December 16, 2002
Publication date:
February 19, 2004
Applicant:
Business Objects S.A.
Inventors:
Neil Thomson, Andre Paiement, Dave Gould, Martin Peticlerc, Brian Donnelly, Gordon Chow
Abstract: A relational database access system and method provides a new data representation and a query technique which allows information system end users to access (query) relational databases without knowing the relational structure or the structure query language (SQL). The present system utilizes semantically dynamic objects.
Abstract: A relational database access system and method provides a new data representation and a query technique which allows information system end users to access (query) relational databases without knowing the relational structure or the structure query language (SQL). The present invention utilizes semantically dynamic objects.
Abstract: A relational database access system and method provides a new data representation and a query technique which allows information system end users to access (query) relational databases without knowing the relational structure or the structure query language (SQL). The present invention utilizes semantically dynamic objects.