Method and device for accessing a data table into a standard library

An implementation method and standard library technology, applied in the database field, can solve problems such as low efficiency and achieve the effect of improving efficiency

Inactive Publication Date: 2019-06-11
BEIJING MININGLAMP SOFTWARE SYST CO LTD
View PDF7 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of data governance, a large number of multi-source and heterogeneous data tables will be connected. Since the fields in the data tables are often in

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 accessing a data table into a standard library
  • Method and device for accessing a data table into a standard library
  • Method and device for accessing a data table into a standard library

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. 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 arbitrarily with each other.

[0043] The steps shown in the flowcharts of the figures may be performed in a computer system, such as a set of computer-executable instructions. Also, although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0044] In the prior art, data item identification is mostly based on manual intervention and configuration, which cannot quickly and effectively identify data items in the standard library. Efficiently identifying data items in the standard library based ...

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 accessing a data table into a standard library and the method comprises the steps: carrying out the data item matching of a new data table and a standard library table in the standard library, and determining a first standard library table for target alignment according to the similarity; carrying out field-level benchmarking on the new data table and the first standard library table to generate a second standard library table, and establishing a mapping relation between the new data table and the second standard library table; and storing the second standard library table and the mapping relation into the standard library. According to the embodiment of the invention, through data item matching and field-level benchmarking, when the new datatable is accessed, the corresponding data item of the table field in the standard library can be quickly and efficiently identified, so that the new data table can be automatically accessed to the standard library or accessed to the standard library through a small amount of manual intervention, and the data management efficiency is improved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for realizing data table access to a standard library. Background technique [0002] Today's big data applications are booming, but the data in various industries presents the characteristics of various types, large data volume, complex structure, inconsistent construction standards, and data code conflicts. [0003] According to the requirements of the Ministry of Public Security for writing data item standards, the curated data items are required to be information data units with certain meanings, named and identified according to specific rules, and used to describe police activities. To this end, a standard library was established in conjunction with this standard during the governance process. [0004] In the process of data governance, a large number of multi-source and heterogeneous data tables will be connected. Since the fields in the data tables are often i...

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/22G06F16/25G06F16/2458
Inventor 庞皓文张毅然
Owner BEIJING MININGLAMP SOFTWARE SYST 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