Data exporting method, device and equipment and computer readable storage medium

Abstract

The invention provides a data exporting method, device and equipment and a computer readable storage medium. The method comprises the steps of configuring parameters related to data export operation of a multi-dimensional database, including the type of a target relational database, determining a matched proprietary client development library according to the type, and establishing a connection relationship between the multi-dimensional database and the target relational database through the development library; creating a fact data table of the target relational database according to a dimension structure of a multi-dimensional data cube of the multi-dimensional database, and creating a dimension table of the target relational database according to a member attribute structure forming dimensions of the multi-dimensional cube; and based on the connection relationship, exporting attribute data of each dimension member of the multi-dimensional cube to a dimension table in the target relationship library, and exporting business data of the multi-dimensional cube to a fact data table in the target relationship library. According to the embodiment of the invention, the data exporting efficiency of the multi-dimensional database is improved, and manual operation errors in the data exporting process are avoided.

Description

technical field [0001] The present application belongs to the technical field of multi-dimensional online analysis and processing, and in particular, relates to a data exporting method, apparatus, device, and computer-readable storage medium. Background technique [0002] Multidimensional database is the carrier of multidimensional online analytical processing technology (MOLAP). According to the way of data storage, it can usually be divided into traditional multidimensional database and in-memory multidimensional database. [0003] Among them, traditional multidimensional databases store data based on disk files. When massive data is calculated, frequent disk reads and writes will occur. However, the performance of disk read and write in traditional multidimensional databases is much lower than the performance of in-memory data read and write. Therefore, The computational efficiency of traditional multidimensional databases will be greatly reduced by disk reads and writes....

AI Technical Summary

Problems solved by technology

[0005] However, when the above method (1) is used, the export efficiency is low due to the need to operate the disk file; moreover, the data on the disk file is cold data, and the analysis value is completely lost without being loaded into the database

When using the above method (2), although the analytical value of the exported data can be retained, this method needs to manually create a relational database table in the relational database in advance before the multidimensional database export operation, which is prone to the risk of manual operation errors; secondly, This method uses the ODBC common interface, resulting in low data processing performance

Images