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

Multiple-dimension data management method and device

A multi-dimensional data and management method technology, applied in the field of multi-dimensional data management methods and devices, can solve the problems of reduced execution efficiency, reduced query performance, hardware resource occupation, etc., and achieve the effect of reducing the amount of data and solving the problem of data query performance degradation

Inactive Publication Date: 2016-11-23
ALIBABA GRP HLDG LTD
View PDF4 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, after a large amount of data is imported into the relational database, its query performance will be greatly reduced, resulting in a reduction in the execution efficiency of data query (especially multi-condition query) and management operations such as query-based data statistics. resources are occupied

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
  • Multiple-dimension data management method and device
  • Multiple-dimension data management method and device
  • Multiple-dimension data management method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary examples do not represent all implementations consistent with the present invention. Rather, they are merely examples of apparatuses and methods consistent with aspects of the invention as recited in the appended claims.

[0028] figure 1 It is a flowchart of a multi-dimensional data management method provided by the embodiment of this application. Such as figure 1 As shown, the method includes the following steps.

[0029] S11. Determine corresponding necessary attributes according to preset management functions, and select at least one of the necessary attributes as a primary key attribute.

[0030] Taking t...

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 discloses a multiple-dimension data management method and device. The method includes the steps that corresponding necessary attributes are determined according to the preset management function, and at least one necessary attribute is selected from the necessary attributes to serve as a main key attribute; according to all pieces of original data, corresponding newly-increased data is generated; the number of the pieces of the newly-increased data is determined according to the number of the main key attributes, the value of the at least one main key attribute in each piece of newly-increased data serves as a preset character, and the values of the other attributes are same as the corresponding original data; the original data and the newly-increased data are subjected to merging treatment according to the main key attributes, and target data is obtained. Compared with the original data, in the target data, unnecessary attributes are reduced, the multiple pieces of data with one or more same necessary attribute values in the original data are merged into one piece, and the problem that due to the enormous data volume, the data querying performance is reduced can be further solved.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a multi-dimensional data management method and device. Background technique [0002] In today's information technology era, the amount and complexity of data is increasing. For example, a piece of transaction data in the e-commerce field can include multiple attributes such as user name, user level, commodity category, receiving / delivering city, transaction amount, etc. ( i.e. dimension). Traditional data tables, databases and other storage methods can no longer meet the needs of business development, so more and more fields and enterprises use data warehouses (Data Warehouse, DW) to realize the storage and management of massive data (data greater than 10 billion rows). A data warehouse is a subject-oriented, integrated, relatively stable data collection that reflects historical changes. It can save a very large amount of data for analysis and allows the us...

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
Inventor 于兴彬
Owner ALIBABA GRP 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