Patents Assigned to Business Objects
  • Publication number: 20060294098
    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
  • Patent number: 7139766
    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
  • Publication number: 20060242624
    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.
    Type: Application
    Filed: April 22, 2005
    Publication date: October 26, 2006
    Applicant: Business Objects
    Inventor: Diane Mueller-Klingspor
  • Publication number: 20060242181
    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.
    Type: Application
    Filed: April 22, 2005
    Publication date: October 26, 2006
    Applicant: Business Objects
    Inventor: Diane Mueller-Klingspor
  • Publication number: 20060230028
    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.
    Type: Application
    Filed: April 7, 2005
    Publication date: October 12, 2006
    Applicant: Business Objects, S.A.
    Inventors: Nicholas Kellet, Richard Webster
  • Publication number: 20060229866
    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
  • Publication number: 20060229853
    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.
    Type: Application
    Filed: April 7, 2005
    Publication date: October 12, 2006
    Applicant: Business Objects, S.A.
    Inventor: Luke Evans
  • Publication number: 20060218405
    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
  • Patent number: 6882998
    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.
    Type: Grant
    Filed: September 28, 2001
    Date of Patent: April 19, 2005
    Assignee: Business Objects Americas
    Inventor: Iain C. Stemp
  • Patent number: 6831668
    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
  • Patent number: 6768986
    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
  • Publication number: 20040034615
    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
  • Patent number: 6578027
    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.
    Type: Grant
    Filed: March 19, 2001
    Date of Patent: June 10, 2003
    Assignee: Business Objects, SA
    Inventors: Jean-Michel Cambot, Bernard Liautaud
  • Patent number: 6247008
    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.
    Type: Grant
    Filed: August 20, 1996
    Date of Patent: June 12, 2001
    Assignee: Business Objects, SA
    Inventors: Jean-Michel Cambot, Bernard Liautaud
  • Patent number: 5555403
    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.
    Type: Grant
    Filed: November 27, 1991
    Date of Patent: September 10, 1996
    Assignee: Business Objects, S.A.
    Inventors: Jean-Michel Cambot, Bernard Liautaud