Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Synchronization of relational databases with OLAP cubes

A cube and database technology, applied in multidimensional databases, database models, structured data retrieval, etc., can solve problems such as cost hindering the purchase and implementation of BI systems

Inactive Publication Date: 2011-08-31
ZAP HLDG LTD
View PDF12 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The cost of the process is a deterrent to purchasing and implementing a BI system, and only large companies can afford the costs involved

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Synchronization of relational databases with OLAP cubes
  • Synchronization of relational databases with OLAP cubes
  • Synchronization of relational databases with OLAP cubes

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] Preferred embodiments of the invention will now be described with reference to the accompanying drawings, in which:

[0058] ● figure 1 is a schematic outline of the system of the invention;

[0059] ● figure 2 Schematically shows the relationship between a measurement group (Internet sales) and two dimensions (customer and geographic location);

[0060] ● image 3 Schematically shows the relationship between a measurement group (bank account) and two dimensions (account ID and user);

[0061] ● Figure 4 Schematically shows the security relationship in CRM and cube;

[0062] ● Figure 5 shows the business unit structure for security in the CRM database;

[0063] ● Figure 6 to Figure 11 The roles representing these security settings in the CRM application are shown.

[0064] The following examples illustrate certain aspects of the invention applied when used with Microsoft CRM software and Microsoft SQL Server Analysis Services.

[0065] The process that the...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Provided is 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.

Description

technical field [0001] The present invention relates to the preparation of databases for use in BI (Business Intelligence) systems, especially for source systems with automatically generated or pre-existing multidimensional representations such as CRM (Customer Relationship Management) and ERP (Enterprise Resource Planning) to automatically synchronize relational databases. Background technique [0002] Business intelligence is a powerful tool for business management, and several patents have claimed systems that provide business intelligence: [0003] • US Patent 7120629 discloses a business intelligence system that obtains prospects by using an Internet-based system and commercial databases. [0004] • US Patent 7315861 discloses a text mining system for business intelligence. [0005] • US Patent 7333982 discloses a CRM with an integrated database management system that aggregates data into a non-relational data store accessible via a query processing mechanism. [000...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F7/06G06F17/30
CPCG06F17/30592G06F17/30578G06F16/273G06F16/283
Inventor M·J·勒威克J·H·威尔逊
Owner ZAP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com