Database processing method and device

Abstract

The invention provides a processing method and device of a database. The method comprises the steps of obtaining a database identification of the database to be connected; according to the database identification, connecting the database corresponding to the database identification, wherein the database comprises at least one data table, the data table comprises at least one piece of field information, and the field information comprises the field identification; according to the field identification of all the field information and preset formatting, generating a data dictionary of a preset format, wherein the data dictionary comprises the field information generated according to the preset formatting. The field information does not need to be chosen in an artificial mode, nor does the data dictionary need to be compiled artificially; the field information in the data table in the database can be obtained by automatically connecting the database, and therefore according to the preset formatting, the field information is automatically compiled into the data dictionary; the time for generating the data dictionary is shortened, and the efficiency for generating the data dictionary is improved.

Description

technical field [0001] The invention relates to database application technology, in particular to a database processing method and device. Background technique [0002] With the development of database technology, databases are also applied to all aspects of software development and other fields. When engineers build data models, they basically design databases based on business. The more businesses there are, the more data there will be in the database, and the data structure of the data in the database will become more and more complex. There are hundreds of data tables in the database, and the data tables contain various data structures. When looking at the database, it is often necessary to write a data dictionary based on the database. The written data dictionary contains the data in the database, and the data in the database is also called field information. [0003] In the prior art, it is necessary to manually select the data to be written based on each data table ...

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a database processing method and device, which are used to solve the problem of manually selecting field information and manually compiling data dictionaries in the prior art, which takes a long time to generate data dictionaries, and at the same time, the efficiency of generating data dictionaries is very high. low problem

Images