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

Relational database data processing method and device

A data processing device and data processing technology, applied in the Internet field, can solve problems such as low efficiency, and achieve the effect of improving the efficiency of MDX query

Active Publication Date: 2015-03-25
BEIJING GRIDSUM TECH CO LTD
View PDF3 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to provide a data processing method and device for a relational database, to solve the problem of low efficiency caused by querying each partition in the ROLAP mode in the related art to a certain extent

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
  • Relational database data processing method and device
  • Relational database data processing method and device
  • Relational database data processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0023] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0024] It should be noted that the terms "fir...

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 relational database data processing method and device. The method includes: acquiring dimension attributes of data stored in a relational database; storing the dimension attributes into a dimension table; reading primary keys of the dimension attributes from the dimension table; searching storage region values of the dimension attributes in the relational database according to the primary keys; storing the mapping relation of the primary keys and the storage region values into the dimension table. By storage of the mapping relation of the primary keys and the storage region values, the problem of low efficiency due to the fact that each partition needs to be queried in an ROLAP (relational online analytical processing) mode in related technologies can be solved to some extent, trouble of handwriting of slices is avoided, and efficiency of MDX (multidimensional expressions) query under the ROLAP mode is improved.

Description

technical field [0001] The invention relates to the field of the Internet, in particular to a data processing method and device for a relational database. Background technique [0002] With the continuous improvement of Sql Server database query performance, in the field of Online Analytical Processing (OLAP for short), relational online analytical processing (Relational Online Analytical Processing, ROLAP for short) storage schemes have become more and more Popularity. In the ROLAP mode, the data is highly real-time, and the data in the relational database does not need to be processed into the cube. The multi-dimensional expressions (Multi-Dimensional expressions, MDX for short) query statement of the OLAP user will pass through the OLAP server Convert it into a Sql statement and get the required data directly from the relational database. Whether or not enough information can be provided for the OLAP server to convert MDX into an efficient Sql query will greatly affect ...

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
IPC IPC(8): G06F17/30
CPCG06F16/284
Inventor 储雨知
Owner BEIJING GRIDSUM TECH CO 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