Garbled code processing method and device in data warehouse

A data warehouse and processing method technology, applied in the field of garbled code processing in the data warehouse, can solve problems such as garbled codes, and achieve the effect of speeding up data query

Active Publication Date: 2017-05-10
BEIJING GRIDSUM TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The main purpose of the present invention is to provide a method and device for processing garbled characters in a data warehouse to solve the problem of garbled characters when using different dimension table processing methods to process data warehouse dimensions

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
  • Garbled code processing method and device in data warehouse
  • Garbled code processing method and device in data warehouse
  • Garbled code processing method and device in data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] 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.

[0036] figure 1 is a flow chart of the first embodiment of the method for processing garbled characters in the data warehouse according to the present invention. Such as figure 1 As shown, the garbled code processing methods in the data warehouse include:

[0037] In step S101, all dimensions in the data warehouse are processed in a first dimension table processing manner to obtain a first processing result.

[0038] Data Warehouse, the English name Data Warehouse, referred to as DW or DWH, data warehouse is a strategy for all types of data to improve support for the decision-making process at all levels of the enterprise. It is a single data store, created for idiomatic analytical reportin...

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 processing method and device for messy codes in a data warehouse. The method comprises the steps that all dimensions in the data warehouse are processed in a first dimension table processing mode to obtain a first processing result; error information in the first processing result is detected; whether the error information is messy code information or not is judged; if yes, the dimension where the messy code information occurs in the data warehouse is sought; the found dimension is processed in a second dimension table processing mode to obtain a second processing result, wherein the first dimension table processing mode occupies less memory compared with the second dimension table processing mode. According to the processing method and device, the problem that the messy codes will appear when the dimensions of the data warehouse are processed by using different dimension table processing modes is solved, and data query is accelerated.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a method and device for processing garbled characters in a data warehouse. Background technique [0002] In daily work, it is often necessary to put some relevant data into such a "warehouse" and perform corresponding processing according to management needs. In financial management, warehouse management, and production management, it is also necessary to establish numerous such "databases" so that they can use computers to realize automated management of finance, warehouse, and production. [0003] A database is a general data processing system for a unit or an application field, which stores a collection of related data belonging to enterprises and business departments, groups and individuals. The data in the database is established for many users to share their information, and has got rid of the restrictions and restrictions of specific programs. Different users can use the d...

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 Patents(China)
IPC IPC(8): G06F17/22
Inventor 洪超
Owner BEIJING GRIDSUM TECH CO LTD
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