A relation model establishment method and system for intellectual property multi-dimensional data

Abstract

The invention relates to a relation model establishment method and system for intellectual property multi-dimensional data, relates to the technical field of data mining, and solves the problems thatprofessional data warehouse software is generally high in complexity, high in requirement on hardware and needs to be maintained by professional personnel; when a star model and a star system model are adopted, a central table becomes very large, and query efficiency and access efficiency are low. The method comprises the following steps: P101, determining a theme and a dimension; P102, constructing a dynamic Hash ring; P103, adjusting the Hash ring; P104, carrying out data positioning; and P105, completing data extraction and extracting data. Through a new center table construction mode, multiple center tables with the same theme are planned to be constructed to work cooperatively, the data size of a single center table is reduced, and the effect of improving the access efficiency of thecenter table is achieved.

Description

technical field [0001] The invention relates to the technical field of data mining, in particular to a method and system for establishing a relational model for intellectual property multi-dimensional data. Background technique [0002] In the field of data warehousing, data is generally modeled in a multi-dimensional form. [0003] refer to figure 1 As shown, taking the trademark sales data of intellectual property as an example, we want to count which international classification (category dimension) has the highest number of registrations, and which month (year) has the highest number of registrations. Usually, in the process of modeling, a theme will be confirmed, and the theme is the content that needs to be counted. For example, the number of trademark sales is confirmed as the model theme; after the established theme, the measurement of the established data, that is, the statistical dimension, will also be established. For example, confirm the three measurement dim...

AI Technical Summary

Problems solved by technology

[0012] The existing technical solutions mentioned above have the following defects: specialized data warehouse software generally has relatively high complexity, and at the same time has relatively high requirements for hardware (generally requires small Machine), also requires professional personnel to maintain; at the same time, when using the star model and galaxy model, the central table will become very large, resulting in low query efficiency, low access efficiency, and there is still room for improvement

Images