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

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

A data export and database technology, applied in database models, structured data retrieval, database management systems, etc., can solve problems such as low data processing performance, loss of analysis value, manual operation errors, etc., to improve data export efficiency and avoid The effect of human error

Pending Publication Date: 2022-07-12
北京元年科技股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Data exporting method, device and equipment and computer readable storage medium
  • Data exporting method, device and equipment and computer readable storage medium
  • Data exporting method, device and equipment and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0089] The features and exemplary embodiments of various aspects of the present application will be described in detail below. In order to make the purpose, technical solutions and advantages of the present application more clear, the present application will be further described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the specific embodiments described herein are only intended to explain the present application, but not to limit the present application. It will be apparent to those skilled in the art that the present application may be practiced without some of these specific details. The following description of the embodiments is merely to provide a better understanding of the present application by illustrating examples of the present application.

[0090] It should be noted that, in this document, relational terms such as first and second are used only to distinguish one entity or operation from an...

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

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

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): G06F16/27G06F16/25G06F16/28
CPCG06F16/27G06F16/283G06F16/284G06F16/25
Inventor 屈恩
Owner 北京元年科技股份有限公司
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