SYNCHRONIZATION OF RELATIONAL DATABASES WITH OLAP CUBES

摘要

Synchronous method, which defines its record storage the application layer security of own in relational database and with OLAP cube, and wherein the structure of relational database and cube is modeled as intermediate representation, to be compared to two structures; Difference model between the two is identified and is used to modify the cube of structure; The cube for improving structure is used to generate script for retrieving the insertion cube from relational database, and hereafter script operation is inserted into modified cube with data. The cube of identical identifier is labeled with using each system of each project in unique identifier basic system.