Method and device for importing data into dimension table

A dimension table and data technology, applied in the database field, can solve problems such as low data import efficiency, and achieve the effect of improving data import efficiency, solving low data efficiency, and improving efficiency

Inactive Publication Date: 2014-02-05
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 9 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 method and device for importing data into a dimension table to solve the problem of low efficiency of importing data into a large dimension table in the prior art

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
  • Method and device for importing data into dimension table
  • Method and device for importing data into dimension table
  • Method and device for importing data into dimension table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0026] The present invention provides a method for importing data into a dimension table. The method for importing data into a dimension table provided by the embodiment of the present invention is described in detail below:

[0027] figure 1 It is a flow chart of the method for importing data into a dimension table in the first embodiment of the present invention, such as figure 1 As shown, the method includes the following steps S102 to S106:

[0028] Step S102, establishing a unique index of the target dimension table, wherein the target dimension table is a dimension table receiving data source data in the database. Specifically, the unique index of the target dimension table may be esta...

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 method and device for importing data into a dimension table. The method for importing data into the dimension table comprises the following steps: establishing a unique index of a target dimension table, wherein the target dimension table is a dimension table for receiving data source data in a database; setting the property of the unique index as a preset property, wherein the preset property indicates that the data source data are not inserted and the database does not report errors under the condition that the data source data already exist in the target dimension table; importing the data source data into the target dimension table. According to the method and the device, the problem of low importing efficiency of data into a large dimension table is solved, and the effect of increasing the data importing efficiency is further achieved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for importing data into a dimension table. Background technique [0002] With the growth of data, many companies use databases as analysis systems, and there are dimensions and indicators in the database. The dimension table is used to save a certain dimension, for example, DimUrl saves the dimension of Url, which is used to analyze related indicators (such as visits and page views) from the perspective of Url in the database. Logically, each row of the dimension table represents a unique record row of the dimension, for example, each record row of the Dimurl dimension represents a unique Url record. When the scale of the data warehouse reaches a certain level, it is unavoidable that there will be large dimension tables, and these large dimension tables often have many record rows that need to be imported every day. After importing, the uniqueness of the large dimens...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/2228
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