Date dimension table automatic generation method and system

A technology for automatically generating dimension tables, applied in database management systems, multidimensional databases, instruments, etc., can solve problems such as low accuracy and efficiency

Pending Publication Date: 2022-05-13
CHINA SHIPPING NETWORK TECH
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In order to solve the existing problems of accuracy and low efficiency in the design of the time dimension, the present invention provides a method for automatically generating a date dimension table, which obtains the requirements of the date dimension by processing the newly added and stock data in the data warehouse, and aims at To meet the needs of business logic and data analysis, design algorithms to automatically create date dimension tables, which can effectively improve the accuracy and efficiency of date dimension table creation

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
  • Date dimension table automatic generation method and system
  • Date dimension table automatic generation method and system
  • Date dimension table automatic generation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] The present invention will be described below in conjunction with the accompanying drawings.

[0042] The present invention relates to a method for automatically generating a date dimension table, the flow chart of the method is as follows figure 1 As shown, the following steps are included in sequence:

[0043] Data loading and preprocessing steps: collect business data uploaded by users, load the business data into the data warehouse after ETL processing, and preprocess new business data and existing business data in the data warehouse; specifically, the acquisition target The business data uploaded by users is processed by data extraction, data cleaning and data conversion. Among them, the collected business data can be full data, incremental data, or data based on specific signs such as business order number and business creation date. The above data is processed by ETL and then loaded into the data warehouse to facilitate subsequent data traceability , and prepro...

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 date dimension table automatic generation method and system, and the method comprises the steps: collecting business data uploaded by a user, carrying out the ETL processing, loading the business data into a data warehouse, carrying out the preprocessing of the newly-added business data and the existing business data in the data warehouse, and carrying out the processing of the data; carrying out attribute identification on the preprocessed business data and metadata corresponding to the business data, carrying out demand analysis on the attributes through a statistical analysis method, determining a business data theme, determining data analysis granularity and display dimensions of different data, determining the range and demand of date dimensions, determining the hierarchy of the date dimensions, and determining the data analysis granularity and the display dimensions of different data; according to the method, the date dimension table is automatically created according to the hierarchy of the date dimension and displayed to the user, the demand of the date dimension is obtained by processing the newly added data warehouse and the stock data, and the date dimension table is automatically created based on the demand of the date dimension, so that the creation efficiency and accuracy of the date dimension table can be effectively improved.

Description

technical field [0001] The invention relates to the technical field of artificial intelligence big data, in particular to a method and system for automatically generating a date dimension table. Background technique [0002] In daily life, the generation of data is related to the date. Data is generated every minute and every second, and data analysis is inseparable from the date. In the data warehouse, without exception, it is necessary to deal with the time dimension, but the current design accuracy and efficiency of the time dimension are low. Therefore, designing a reasonable, efficient and accurate time dimension is a necessary resource reserve for a data warehouse project. , is also the basis for data modeling and analysis. Contents of the invention [0003] In order to solve the existing problems of accuracy and low efficiency in the design of the time dimension, the present invention provides a method for automatically generating a date dimension table, which obta...

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): G06F16/25G06F16/215G06F16/22G06F16/28
CPCG06F16/254G06F16/283G06F16/2282G06F16/215G06F16/258
Inventor 陈怀海郭照军
Owner CHINA SHIPPING NETWORK TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap