Zap Holdings Limited

Zap Holdings Limited Patent applications

Patent application number

Title

Published

20120185425

CONTENT BASED APPROACH TO EXTENDING THE FORM AND FUNCTION OF A BUSINESS INTELLIGENCE SYSTEM - A business intelligence (BI) system which includes the ability to extend its functionality outside of the project life cycle by means of specific content. Complex multidimensional queries are interpreted as trees of atomic sub-expressions that are combined in a parse-tree-like structure to form the overall query. Each sub tree is valid in isolation when provided with the proper context. Any sub tree can be an expression template, stored as application content, which at generation time uses simple text substitution with instance specific parameters to produce multidimensional expression syntax. The system includes a sophisticated type system and semantic layer that hides the user from the complexities inherent in working with OLAP databases. A business intelligence expert can provide type and semantic cues for each expression template, held as content. The content expression templates are then exposed in the application primarily through a context menu that is filtered for appropriateness, but also in an explorer tree, toolbars, menus and submenus. The functionality from a users perspective is integral to the application. An iterative processing capability to complement these expressions is provided by means of OLAP database stored procedures held as application content. Building on the above, workflow content allows business users to extend the application by creating expert-system-like guided analyses and processes. Of key significance to this innovation is the concept that the expression templates, stored procedures and workflows are application content, and therefore redistributable and unshackled from the classic software development lifecycle and the cost and expertise associated.

07-19-2012

20110320399

ETL BUILDER - A method of building a staging database which examines the staging database metadata and constructs a schedule of operations to extract the data, transform it and load it into the staging database by using normalisation, translation blocks and filtering to create a business view of the data that can be seen using standard query languages. This is applied to products such as Navision in building an OLAP cube for use in business intelligence applications.

12-29-2011

20110231359

SYNCHRONIZATION OF RELATIONAL DATABASES WITH OLAP CUBES - A method of synchronizing a source system that stores its records in a relational database and defines its own application level security with an OLAP cube, in which the structure of the relational database and cube is modelled to an intermediate representation for the purpose of comparing both structures; the differences between the two models are identified and used to modify the structure of the cube; the modified structure of the cube is used to generate a script for retrieving data from the relational database for insertion into the cube, after which the script is run and the data is inserted into the modified cube. A unique identifier is used for each item in the base system and each system is tagged with the same identifier in the cube.