Method and system for generating data dictionary

A data dictionary and dictionary technology, applied in the field of database management, can solve the problems of time-consuming and laborious manual maintenance, frequent maintenance operations such as data model modification, addition, deletion, etc., and the inability to change and maintain the data dictionary at the first time. Effective for management

Pending Publication Date: 2022-06-24
杭州数查科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the process of database construction, maintenance operations such as modification, addition, and deletion of data models are relatively frequent, and it is usually impossible to change and maintain the data dictionary in the first place, and manual maintenance is time-consuming and laborious

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 system for generating data dictionary
  • Method and system for generating data dictionary
  • Method and system for generating data dictionary

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0053] like figure 2 As shown, in this embodiment, the data dictionary generation method for multiple target data tables includes:

[0054] Step 301: Create a dictionary directory table according to the multiple target data tables, where the dictionary directory table includes the table name of the target data table.

[0055] In a specific embodiment, the dictionary table of contents is shown in Table 1:

[0056] Table 1

[0057] serial number Central library data source Table name (table library name) Chinese Notes 342 Large screen thematic library data source 1 Share_dp.yth_yytx_xhxmgh Application System-Informatization Project Planning 343 Large screen thematic library maintenance records Share_dp.yth_yytx_ywyytx Application System - Component Supermarket 344 Large screen thematic library maintenance records Share_dp.yth_yytx_yyxtzs Application System - Application System Classification 351 Large screen thematic ...

Embodiment 2

[0072] This embodiment provides a system for implementing the above generation method, such as image 3 As shown, it includes a data range determination module 2, a data table reading module 3 and a structure information writing module 4;

[0073] The data range determination module 2 is used to obtain the data range of the data dictionary to be generated, and the data range includes the target database or data table;

[0074] The data table reading module 3 is used to read the target structure data table from the corresponding data warehouse server according to the data range; and obtain the structure information from the target structure data table according to the format of the data dictionary;

[0075] The structure information writing module 4 is used for writing the structure information into the data dictionary 11 .

[0076] The system may further include a data dictionary generation module 5 , a connection information storage module 6 , and a data source management mo...

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 data dictionary generation method and system, and belongs to the technical field of database management, the generation method comprises: obtaining a data range of a to-be-generated data dictionary, the data range comprising a target database or a data table; obtaining a target structure data table from a corresponding data warehouse server according to the data range; reading structure information from the target structure data table according to the format of a data dictionary; and writing the structure information into the data dictionary. By determining the data source and the data range thereof, the information of the target structure data table is obtained from the data range, and the data dictionary is established according to the target structure data table and the structure data thereof, so that real-time updating and maintenance of the data dictionary are facilitated, and management of the data dictionary is facilitated.

Description

technical field [0001] The invention relates to the technical field of database management, in particular to a method and system for generating a data dictionary. Background technique [0002] A data dictionary is a directory that records database and application metadata that users can access. It defines and describes data items, data structures, data flows, data storage, processing logic, etc. Make detailed descriptions of the various elements in the data flow diagram, using the data dictionary for simple modeling projects. Simply put, a data dictionary is a collection of information describing data, a collection of definitions for all data elements used in a system. [0003] However, at present, most of the data dictionary documents are manually maintained manually, and the data table structure information is read from the database through direct editing or through query statements, and then copied to the document for storage. In the process of database construction, da...

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): G06F16/21G06F16/22
CPCG06F16/212G06F16/2282
Inventor 何山周自强叶强
Owner 杭州数查科技有限公司
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